568 Posted Topics
 | can you please your required unique schedule format .? |
| | hello ! if you want to bind combobox then try this [CODE] dim con as new sqlconnection("string") con.open() dim da as new sqldataadapter("your sql query",con) dim dt as datatable da.fill(dt) 'now here you can bind your combobox combobox.databinding.add("selectedvalue",dt,"your database field name",true) 'combobox.databinding.add("selectedvalue",dt,"CityID",true)--like this [/CODE] If this code solve your prob … |
| | hello! you can use this code at the click event of the listbox [CODE] button1.enable= true [/CODE] |
| | hello LearnVBnet! i read this thread more then 5 times , but i still not able to understand what is your question "How to NoT In Paylist LvList where InvNomer have add to dgv Payment Not Display InvNomer in LvList Paylist where InvNomer in Dgv Payment." this the description of … |
| | you can do this by using query , can you please tell me about table and fields and on which fields you want to set you record selection criteria . Regards  |
| | use this code to save pic [CODE] 'use this code instead of this code ( cmd.Parameters.Add(New SqlParameter("@picture", SqlDbType.Image)).Value = arrimage) Dim myFile As String = picture If picture.ToString.Length <= 1 Then Me.myCmd.Parameters.Add("@Picture", SqlDbType.Image).Value = Convert.DBNull Else Dim myStream As FileStream = New FileStream(myFile, FileMode.Open) Dim myImageBuffer() As Byte = New … |
| | hello ! check this code this will show some records in datagrid and some of them in textboxes as you mentioned in your snap shoot. [CODE] dim con as new sqlconnection("connection string") dim da as new sqldataadapter("select * from table or your query",con) dim dt as datatable da.fill(dt) 'take a … |
| | i cant get your point , i think you want to select all records from persons table of selected person id in grid , if i am wrong then please correct me , well for simple select case you can do like this [CODE] dim myCmd as string myCmd = … |
| | hello! i am working on a Asp.net project using C#, now i want to connect mssql server 2008 using JS or AJAX , i am very new with JS so i have no idea where to start .can anyone help me in this . Regards M.Waqas Aslam |
| | hello! how can this code update database :P you are using select statement instead of update :) Regards |
| | Hello ! i watched this given video . it is very simple i write this code right here so there may be some spelling mistake in it. check this out dgvTableList---is a grid which will show tables of selected database dgvAllRecords---it will show all records of the selected table [CODE] … |
| | skp03 , can you please post some of your code or snap shoots of your forms so that i can better ans you . and if you are working in C# then it is better to post this question in C# forum so that someone can better answer your prob. … |
| | check this , may be it helps you [CODE] dim myCon as new sqlconnection("your connection string") dim cmd as new sqlcommand myCon.open() cmd.connection=myCon cmd.commandtext="insert into tablename (field1,field2,field3) values (@field1,@field2,@field3)" cmd.parameter.add("@field1",______).value = txtvalue1.text 'in place of ___ write datatype of your field in your db. cmd.parameter.add("@field2",______).value = txtvalue2.text cmd.parameter.add("@field3",______).value = txtvalue3.text'if … |
| | |
 | hello ! you can do it like this [CODE] 'first import system.data.sqlclient then dim myCon as new sqlconnection("your connection string") dim cmd as new sqlcommand myCon.open() cmd.connection=myCon cmd.commandtext="insert into tablename (field1,field2,field3) values (@field1,@field2,@field3)" cmd.parameter.add("@field1",______).value = txtvalue1.text 'in place of ___ write datatype of your field in your db. cmd.parameter.add("@field2",______).value = … |
 | you can set your column readonly property true . Regards |
 | your given proj is not working at my end and it gives an error when i run it .you should use break points in your code to solve this type of issues .please in order to get help , post your code or again give new link of working project …  |
| | yes it is possible , but can you tell me what you want to print ,every time before printing you want to change amount , and name ,which is not a good approach. as you said that you want to print a payment receipt you can do like this [CODE] … |
| | try this code [CODE] 'use this code on the keydown event of the listbox If e.KeyData = Keys.Down Then ListBox1.SelectedItem = ListBox1.Items(0) End If If e.KeyData = Keys.Up Then ListBox1.SelectedItem = ListBox1.Items(0) End If [/CODE] Hope this helps you Regards |
| | Re: Array problem hello ! array in vb.net is defined like this [CODE] dim array(5) as string [/CODE] hope this will work fine :P Regards |
| | hello honeybee2090! here is simple code to perform same action , [CODE] 'use this code at you button click event Dim i As Integer Dim x As Integer Dim no As Integer Dim rec As New ArrayList For i = 0 To ListBox1.Items.Count - 1 no = 0 A = … |
| | hello ! take a look on this link[URL="http://www.daniweb.com/software-development/vbnet/threads/21529"]http://www.daniweb.com/software-development/vbnet/threads/21529[/URL] |
| | hello! in you db , date format is same as you specified in your windows , so change the date format .secondly users have concern with the interface , time showing on there datetime picker , there you can set the format property custom and set your required format of …  |
| | it is not possible ,if you use order by desc then it will sort all records descending order . but you want just to show single column like this , this will will effect all the related records |
| | hello ! i am developing an desktop application , i want to make my menus just like in VS2008 have tool box , ,when we click on the main tab it will open and slid down , i want to make same thing , is there any one who guide … |
| | hello ! look , for example i have 2 textboxes in my vb form, i want that when i press enter key the focus move from 1st textbox to 2nd textbox , i use this code on my every control to move focus [CODE] if e.keychar = chr(keys.enter) then textbox2.focus … |
| | hello ! i want to make a xml file to store my Settings such as server name , user name , and password , etc , i try to search how to read and write xml file i found this code for writing an xml file it works fine for … |
| | hello ! I want to use JSON in my asp.net project using c# .how can i do that , i am very new in JS and JSON , please help me so that i can start work .i googled about it , and read some posts on different forums and … |
| | try to use mouse hover event of the grid and place your binding code in it , Regards |
| | hello ! i think you have to code at grid double or single click event . it will work fine :) Regards |
| | this error occurs only when we try to entered the foreign key which is not in its parent table ,sorry for my bad english. first try to look at your relations between hrBranchSetup and hrBranchSetup_Audit , hrBranchSetup has a PK OsID and hrBranchSetup_Audit has FK OsID .you should have PK … |
| | try form.focus() , may be this will work for you :) Regards |
| | Re: Sales hello! i think you want to develop POS (point of sale) software , please google it by typing POS , there may be some demo out there , and also some online guide , that will help you allot Regards |
| | hello! it takes long time to read your all code , but as far as concern about update query ,you can do like this [CODE] dim mycon as new sqlconnection("connection string") dim cmd as new sqlcommand mycon.open() cmd.connection= mycon cmd.commandtext="update tablename set dbcolumnname1=@Column1,dbcolumnname1=@Column2,dbcolumnname1=@Column3 where recID=@RecID" cmd.parameters.addwithvalue("=@Column1",txt1.text) cmd.parameters.addwithvalue("=@Column2",txt2.text) cmd.parameters.addwithvalue("=@Column3",txt3.text) cmd.parameters.addwithvalue("=@recID",txtRecID.text) cmd.executenonquery() … |
| | hello ! i am working on an application and i want to connect it with mssql database , i dont know about the version of installed mssql server at the pc , how can i get the version of installed mssql server so that i can connect my application with …  |
 | both are good , i think it depend on your requirement .  |
| | hello ! i have experience in VB.net,C# and MSSQL2000,2005,2008r2 .but today my boss assign me a task to connect mssql server 2008 by using JS or JSON ,both are unknown for me ,:( i dont have any knowledge about JSON and JS , can any one help me how to …  |
| | hello ! use this code , [CODE] Dim MyConn As New SqlConnection("Data Source=(local);Initial Catalog=dbname;Integrated Security=SSPI;") [/CODE] Regards M.Waqas Aslam  |
| | hello ! [CODE]rpt.RecordSelectionFormula = "{cashtbl.stdid}='" +Convert.ToInt32(textBox2.Text) + "'";[/CODE] in above line you are converting textbox value in to integer and after that you are using '' and dealing like a string .use this [CODE] rpt.RecordSelectionFormula = "{cashtbl.stdid}= +Convert.ToInt32(textBox2.Text); [/CODE] Hope this will solve your prob,if yes please mark your thread … |
| | hello skran ! are you using sql query to get filtered records from database and show them in datagrid.??? Regards |
| | hello ! you are adding txtPostcode.text and txtDMA.text in your Query , this totally wrong . you are using totally wrong logic for this query , can you please tell me what you want to get from this query , well you can do like this [CODE] dim Query as … |
| | hello ! you can do like in this way [CODE] 'place this code at the single click event of the grid txt1.text = datagrid.item(0,datagrid.currentrow.index+1).value.tostring [/CODE] hope this will solve your prob :) Regards |
| | hello ! i am very new in webdevelopment , i want to use ExtJs , please help me , i download the extjs-4.0.1 .now please tell me how to import it in my project , i mean is i copy this extjs-4.0.1 to my project or is there is another … |
| | hello ! my boss assign me a task to connect mssql server 2008 and show records in table using JS and JSON , i m very new in asp.net , can any one me help me where to start my work and how i can complete this , can any … |
| | hello ! i am working on an application and i want to connect it with mssql database , i dont know about the version of installed mssql server at the pc , how can i get the version of installed mssql server so that i can connect my application with …  |
| | hello! may be this will help you Regards |
| | hello Awais try this code [CODE] Dim cn As ADODB.Connection 'ADODB Connection Object Dim rs As New ADODB.Recordset 'Recordset Object Dim sqlStr As String ' String variable to store sql command Set cn = New ADODB.Connection cn.ConnectionString = "Provider = MSDASQL;" & _ "Data Source=LocalServer;" & _ "Initial Catalog=sample;" & … |
| | hello! you can do like this harrispc [CODE] 'put this code on the load event of the form 'before coding set selection property of grid to full row select DataGridView1.Focus() DataGridView1.Rows.GetFirstRow(DataGridViewElementStates.Visible) 'and shann1718 u can do like this DataGridView1.Rows.GetLastRow(DataGridViewElementStates.Visible) [/CODE] hope this will helps you |
| | Re: [VB] Timer Help hello ! you can do like this [CODE] 'enable timer by using this code timer1.enable= true 'now give interval , 1000 = 1 sec you want to perform action after 60 sec so timer1.interval=60000 'now code this on the timer tick event My.Computer.Audio.Play("ur sound file path") [/CODE] hope this will … |
| | hello ! use this code to insert your data in your database table [CODE] dim myCon as new sqlconnection("string_connection") dim cmd as new sqlcommand mycon.open() cmd.connection = myCon cmd.commandtext= "insert into CheckIn(field1,filed2,field3,field4...." values (@field1,@field2,@field3,@field4.....) cmd.parameter.add ("@field1".sqldatatype.varchar(50)).value = txtbox1.text cmd.parameter.add ("@field2".sqldatatype.varchar(50)).value = txtbox2.text cmd.parameter.add ("@field3".sqldatatype.varchar(50)).value = txtbox3.text cmd.parameter.add ("@field4".sqldatatype.varchar(50)).value = txtbox4.text … |
The End.