Recent content by HomerJS

yes

So how would it be done if the number of records returned was known?

That's a question I had myself, and why I asked it. :)

It will vary.

I am using vb.net 2003 and want to use a progress bar while a dataset is loaded. The dataset is bound to a grid which does take some time to load.

When I try the code ca8msm posted, I get the error: 'beginexecutereader' is not a member of 'System.Data.SqlClient.SqlCommand'. Reading other articles on the web it does work in .net 2005, however I am using .net 2003. The BeginExecuteNonQuery, and other asynchronous methods, come with ADO...

I cannot find the method under system.data.sqlclient. It does not show up in intellisense and even when I enter the method it returns an error. Is there a reference I am missing? I do have version 2.81.1117 of MDAC.

I am using vb.net 2003 and want to display a progress bar while a form loads. I am trying to use async call using the BeginExecuteNonQuery method to do this. However I cannot find how to get to the BeginExecuteNonQuery method. Does anyone know where I can find the method? Or another/better...

I have a non-delimited text file where I extract 4 different repeating items from. I want to put those 4 variables into a dataset. I've tried creating a datatable but cannot figure out how to create datarows manually. Is this the best way or how can I get the data into a dataset?

How can I have a scheduled SQL job skip certain days (e.g., holidays)?

I have a value that I need to convert to a hex number, take off the leading Fs, and then use the rest to retrieve a file. Example: value: -2144747826 hex value: FFFFFFFF8029BECE file name: 8029BECE The way I have it set up so far is I have the hex value in a SQL database with the varbinary...

Here's the basics of it . . . 'textbox that does not work 'txtState ' Me.txtState.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.DsInfo1, "Customers.State")) Me.txtState.Location = New System.Drawing.Point(300, 172)...

I should also mention that if I add a completely new text box and bind it to the same data, the new textbox does return the correct value. The textbox that was originally on the form does not.

The dataset gives me the new (correct) value. I check it after I fill the dataset.

I have textboxes on a form that are bound to a dataset. I updated the dataset because of changes and now the textboxes do not display the data when I fill the dataset. There is data in the dataset because MsgBox(DsInfo1.Customers.Rows(0).Item("Name")) gives me a value. Any ideas on...