Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. HomerJS

    Progressbar with dataset and SQL stored procedure

    yes
  2. HomerJS

    Progressbar with dataset and SQL stored procedure

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

    Progressbar with dataset and SQL stored procedure

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

    Progressbar with dataset and SQL stored procedure

    It will vary.
  5. HomerJS

    Progressbar with dataset and SQL stored procedure

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

    BeginExecuteNonQuery

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

    BeginExecuteNonQuery

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

    BeginExecuteNonQuery

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

    Create dataset from non-delimited text file

    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?
  10. HomerJS

    SQL job to skip certain days

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

    Convert hex to string

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

    textbox and refreshing dataset

    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)...
  13. HomerJS

    textbox and refreshing dataset

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

    textbox and refreshing dataset

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

    textbox and refreshing 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...
  16. HomerJS

    full text index after insert?

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

    add distinct fields from one table into another

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

    add distinct fields from one table into another

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

    EASY: Counting records

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

    insert with multiple conditions

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

Part and Inventory Search

Back
Top