There are two sets of code in the above reply:

Imports System.Data.SqlClient
Dim con As New SqlClient.SqlConnection("data source=DATASOURCE;initial catalog=NAME OF DATABASE;Integrated...

In code you can do it this way

Imports System.Data
Imports System.Data.SqlClient
Public conn As SqlConnection
conn = New SqlConnection("server = SRVERNAME ;database =...

Changed the GetString(n) to GetValue(n) and it worked! It didn't like the String so I looked at the code and realized I could send the value in its current format. Thanks for the help!

Ok I'll check the table definition. I'll get back to you.

I'm trying to create a *.csv file using the records stored in a table. Searching the Net, I came across a code snippet that I modified for my use. The relevant code is

If dlg.ShowDialog =...

Just to let you know, everyone, that the code was correct. When I ran the code to create the table, it was created on the wrong server... so when I ran it, the application was looking for the created...

The connection string is correct. I can pull information from the same database and display it - I am trying to save the information taken from one table into a newly created table.

I'm trying to use VB.NET to insert the data in the current row of my datagrid into a table. I wrote the following code:


Dim vCustomer, vBulkQty, vItem, vBaseUnit, vEachQty, vEachUnit As...

Ok I've finally gotten to look at these snippets.... 4Advanced, works like a charm.... :)

Will keep the right click option for another time ;)

Now that I can see the data in the datagrid, I realize that the size of the fields is too small - the customerid and customer name fields both could use expanding so that I can see all of the text....

Thanks! I'm about to send another post - so watch out! lol Need to view the entire content of the field Description without the user having to manually stretch the field title by dragging the right...

@Rapture - you hit the nail on the head... it did sound condescending a bit, and the exclamation marks didn't help.

@4advanced - your explanation did help clarify why what I did worked, so thank...

This is the code that worked for me.

dgCustomers.DataSource = ds.Tables(0)

It's not working. I've been doing everything people have requested from the time I asked for help. I know it's supposed to work, and I've already "checked the posts on the first page", thank you very...

Sorry, couldn't get to this yesterday evening...

I tried the Databind() function, but VB says that Databind is not a member of the 'System.Windows.Forms.DataGridView'.

Yeah the connection is built in a module, so that's why my code only has the conn.open() in this snippet. I call the module in the Form_Load of this form...

To verify that data is being...

Tried to run the application and it compiled and started without a problem, but when I choose the radio buttons that would fire the required code, nothing shows up in the datagrid.

Here is a look...

Looks familiar, but I don't think I used this code on this occasion... it does look like I saw it while researching another day, though. The [icode]DataGrid1.DataSource =...

I'm not able to ascertain how to bind this datagrid... I was trying [icode] dgCustomers.setdatabinding(ds, "region")[\icode] but it says that "SetDatabinding' is not a member of...

Thanks Rapture....

I'm reading the suggested thread, so I'm researching data binding for VB.NET as apposed to C#. Keep you posted!

I've read up on attaching a dataset to a datagrid and followed all the code snippets I can, but I am still having problems viewing data.

Have a look at this code:


Private Sub...

cool. So, I'll send this request on VB.NET.

Thanks again.

It works!

Thanks!

But why???? lol I already have the Imports System.Data.SqlClient at the top of my code... so isn't using the Dim r As SqlClient.SqlDataReader redundant?

I'll mark it as...

sorta... now I got another one. The original problem is fixed, but now I'm getting another... here's a quote...

Thanks, Salem...
I was encouraged to ask it in the SQL forum... didn't remember to update this thread. Sorry!!! *embarrassed*

Could someone help me find where to place the SQL question? I don't see a specific SQL forum...

Thanks. I'll check out the SQL thread too. Thanks a lot

Sorry about the code tags... I tried using them, but I guess they didn't come out as I expected....

I'll do some more digging on this error. Thanks.

Hi guys!
I have created two table valued multi-statement functions using SQL Server 2000 and am now trying to develop a VB.NET front end application where I run the functions and pass string...

I realize that the response time of my GUI is extremely slow! I have three combo boxes - I want the user to select a template from one drop down list, which will populate the second drop down list...

Worked like a charm. Thanks!

How do I get a textbox to automatically update with information when I select an item from a combobox?
txtCustID.Text = Custds.Tables(0).Rows(cboCustomer.SelectedIndex).Item("custno") is what I...

I went the boolean route... the other way seemed too complex for me.

How do I stop a combo box from firing the SelectedValueChanged event when the DataSource property is added?

Thanks for the suggestion, Destino....
It's been working in Query Analyzer - I know the query brings results, as it is a business script that is used to select and delete purchase orders from time...

I do. Here's the code I put in:

dgBlowOut.DataMember = ds.Tables[0].TableName


There is a blue line under ds.Tables and another one under [0] Putting my mouse over the ds.Tables gives the...

When I tried that I got this error: value of type 'System.Data.DataTableConnection' cannot be converted to string.

Ok I have created a dataset name Uploads and set the datamember using the code given...

[code=VB.NET]
Dim ds As New DataSet("Uploads")
....
dgBlowOut.DataMember = "Uploads"
[\code]

and now...

Ok so now I'm trying to understand the Datamember... is the DataSet("Uploads") the NAME of a Dataset? As in that code creates a dataset with a name?

I have changed the connection string username and password and the connection seems to now be working - but now I'm back to the original issue: I can't get the datagrid populated from records using...