Im after some advice on how i go about opening my sqlConnection. At the moment when my program is first run i open the sqlConnection and this is made as a public object so i can reference throughout the program without having to close it untill i close the program. I thought this was fine...
I have this picture to be more clear:
My idea is when I paste (ctrl+v) for example this number :
it would automatically paste them in textboxes one by one in order!
so txtBox1 will contain : 4111
txtBox2 : 1111
txtBox3 : 1111
txtBox4 : 1111
the automation of...
I'm trying to fill a dataadapter from my sql2005 server. After filling i'm planning on generating a chart (VS2008) from the datarows.
But upon filling the data adapter I'm getting: "A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll" in...
I am filling a datatable contained within a dataset from a datadapter in a separate thread. What I want to do is see if this datatable is still being "filled" so that I wait until its done before I call upon it from the primary thread. Is there a status in the datatable that shows that it is...
I want to modify this function to populate an array with each item in the database.
I have tried various options, but I just can't get it to work
Private Function ConnectMe() As DataTable
Dim conn As String = "Server=192.168.0.36;Port=3306;Database=wswc;Uid=root;Pwd=Jack"...
I am trying to fill a DataTable with a DataSet using a SQL query with one parameter. The parameter is the Node text of a treeview whose checkbox has been checked. It will retrieve Products from one table and any associated Packages from a different table. I am using a FOR loop to...
I have a file with the following fields
productnumber and newprice.
I need to make a robot which can do the following tasks programatically
open an 3rd party Internet application with explorer, fill user name and password, press enter, select product modification button , type the...