Great help... thanks a lot!!

My manager has just asked me to research whether it would be possible to restore a previously fully backed up database into two or more filegroups, with each filegroup being on a separate drive using...

Thanks, but I wanted it as an INTEGER, not a varchar... the script references the sysjobhistory table in the msdb database, and, in that table, the run_date column is an integer.

This set of code below shows all SQL Server Agent jobs that have failed for the date 200.03.29. The run_date column is an integer, but I want to run the code in such a way that the resultset is...

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.

Yeah I recognize that. Thanks! I was just opening the VB.NET to send it there

ok thanks .... here we go...

I will... thanks!

Should I post another question concerning why the datagrid isn't showing up the data from the function, or should I ask it here?

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*

I seem to have gotten past that problem... now it says

InvalidCastException
Unable to cast object of type 'System.Data.SqlClient.SqlDataReader' to type 'System.Data.SqlClient.SqlDataReader[]'.'
...

wow... I didn't see that... you're right! I'll modify it and get back to you... give me a sec...

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 parameters to...

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...