Search results for query: *

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

Is there a way to reindex a full text indexed filed after inserting record(s)? I have a table of customers, with the name having a full text index, and after inserting more records the CONTAINS search does not include the new records.

Yeah I realized that and although as you pointed out it would be less acurate, it is what I want.

I have two tables. Tbl1 starts by having only OrderNo for data. Tbl2 has multiple occurences of the same order and owner. I want to add each owner into tbl1. An example is below. tbl1 OrderNo Owner1 Tractor Owner2 123 456 tbl2 OrderNo Owner Tractor 123 9...

select count(*) from mytable where mytable.field = 'something'

Thanks Angel!! I was pretty close but didn't quite have it.