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!

  • Congratulations wOOdy-Soft 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: *

  • Users: HomerJS
  • Content: Threads
  • Order by date
  1. 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.
  2. 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...
  3. 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?
  4. HomerJS

    SQL job to skip certain days

    How can I have a scheduled SQL job skip certain days (e.g., holidays)?
  5. 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...
  6. 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...
  7. 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.
  8. 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...
  9. HomerJS

    insert with multiple conditions

    I have three tables (Order, City, Company) which contain the fields: Order OrderNo ShipperName ShipperCity ShipperState City ID = numeric field Name = actual name of the city Company Name = Order.ShipperName Code = left(Order.ShipperName) + left(City.Name,3) City =...
  10. HomerJS

    datagrid context menu

    I can get a context menu that I created to display when I right-click on a datagrid. How can I get the context menu to display when I right-click on a cell inside the datagrid? Currently when I right-click on a cell it gives me the standard context menu (Cut, Copy, Paste, etc).
  11. HomerJS

    datagrid scrollbar not responding

    I have a few datagrids on my form, which are on different tabs of a tab control, and it seems that the scrollbars are not responding. What I mean is that they don't show up and where they are supposed to display, the information from another window is in it's place. (just like when a window...
  12. HomerJS

    no date in datagrid

    How can I change a column in a datagrid that originally had a date to display blank? TaskGrid.Item(TaskGrid.CurrentRowIndex, 5) = 0 I am using column styles to set up the grid and display only columns I want to show. I have tried 0 (zero), nothing (TaskGrid.Item(TaskGrid.CurrentRowIndex...
  13. HomerJS

    .NET environment - sort Class Name combobox

    How can I get the class name combobox (the combobox that lists all of the controls on a form) to sort alphabetically?
  14. HomerJS

    combobox valuemember & datamember

    I have the following code inside a buttons click event. How can I get the value of .valuemember? The messageboxes from the SelectedIndexChanged events display blank. Dim i As Long For i = 0 To 3 With cbo1 .DisplayMember = "value" & CStr(i + i)...
  15. HomerJS

    value cannot be null - using dataset

    I'm building a windows application that has a datagrid. I want to make a few columns invisible and have found a way to do it using a dataset. When I load the datagrid with a datatable, it works fine. However when I load it with a dataset I get the following error: An unhandled exception of...
  16. HomerJS

    textbox and return

    I want a user to enter data into a textbox and then be able to either hit return or click a command button to retrieve the data. The command button works fine, but how do I get it to fire when the user hits the return key when they're still at the textbox?
  17. HomerJS

    crystal report export or change page margin

    How do I export a crystal report that's viewed in a web page that has parameters? It works fine when I display it to the web page. The following statement assigns the parameters to the viewer, but what do I assign the parameters to when I export? crystalreportviewer1.ParameterFieldInfo =...
  18. HomerJS

    Crystal Reports - multiple parameters - Invalid object type

    Any help would be appreciated with what I'm doing wrong to get the following error in the related code below: ERROR ================================ Exception Details: System.ArgumentException: Invalid object type. Source Error: Line 61: .CurrentValues.Add(discreteVal) Line 62...
  19. HomerJS

    server files needed for crystal reports

    I'm trying to add a crystal report to a website. The website works fine without the crystal report but gives me the following error messages when I try to go to the page that has the crystal report viewer. Is there something I need to install on the web server (if so where do I find it?) or...
  20. HomerJS

    multiple datagrid on same page

    I have 2 datagrids on the same web page. They are positioned vertically one right after the other. My problem is that the first one overlaps the second one. How can I position the second datagrid so they don't overlap? I was looking for something like datagrid.top but cannot findi it.

Part and Inventory Search

Back
Top