Search results

  1. B

    tableadapter.update

    cjard Thank you for your comments. I got it to work using the overload function. However, the overload function can be erased automatically by VS. I only got it to work if it's created and build immediately without moving around in the project. I don't know why it's being removed if I click...
  2. B

    tableadapter.update

    Hello All, I am trying to update two fields based on where chart = @chart. Update executed successfully but nothing happens. Where or at what point does it ask for @chart value. I even tried to create another update function but the program just removes it by itself. I am confused...please...
  3. B

    Get Application Path Name

    For some reason all the windows application created in VB.NET using Setup and Deployment Projects, when installed, are registered under "Assemblies" and not "App Paths" or any other locations. If I do a Find in the Registry, that's where it's located at and nowhere else. I don't want to know...
  4. B

    Get Application Path Name

    Hello Everyone, I am very frustrated:mad: . I am relatively new to VB.NET. Can someone please help me:) . I need to get the paths of applications I have installed written in VB.NET. For some reason they're all registered under \My Computer\HKEY_CLASSES_ROOT\Installer\Assemblies\C:|Program...
  5. B

    How to scroll to a record in DataGrid?

    Hello everyone, I know how to perform a go to record in a Datagrid, however, I need to know how to center that particular record in the Datagrid. I don't want it at the top or bottom of the Datagrid. Can anyone help? Thanks in advance btran
  6. B

    Get column name/number and sorting order

    Hello everyone, I am new to VB.NET and I am a little lost. This may be an easy question to all of you. I have a datagrid and I want to get the column name/number and sorting order when the user click on the column header. The sorting order changes everytime ASC or DESC, of course. Can someone...
  7. B

    Listview in Multiple tab pages

    Hello everyone, I am stuck on how to get rid of hottracking and hoverselection in AXlistview when tried to migrate from VB6 to .NET. Everyone's solution is to use .NET listview instead. However, I am stuck on how to display one Listview in multiple tab pages(tabcontrol). The listview will...
  8. B

    How to disable listview auto row selection

    I can't...it's a huge program. Maybe I need to do the migration again and hopefully that will solve it or find out what's the cause.
  9. B

    Disable listview auto row selection

    It's my mission to migrate it over from VB6 to .NET. I don't want to change the default configuration. I want to keep it as-is.
  10. B

    How to disable listview auto row selection

    You tell me...I can't figure it out for days now. It only happens to this particular program. A similar message was posted by someone else, but did not get a reply. Maybe someone else knows this.
  11. B

    How to disable listview auto row selection

    Hi Yall, This may seem very simple but I don't know how to disable ActiveX Listview auto row selection. It automatically selects a row in the Listview whenever the mouse cursor hovers over it, usually after Listview got focus. I have tried to disable Hottracking and HoverSelection, but it...
  12. B

    Disable listview auto row selection

    Hi Y'all, This may seem easy but I don't know how to disable ActiveX Listview auto row selection. It automatically selects a row whenever the mouse cursor hovers over a row, usually after the ListView got focus. I have tried to disable Hottracking and HoverSelection (hardcoded also), but...
  13. B

    SQL string concatenate field name

    Thanks Paszt. I think I will try that. I think that will solve my problem. Thank You Much.
  14. B

    Find substring in dataview/datagrid

    Thanks ABSOLUT, This is a good idea and I have thought about it. But I have over 100K+ rows and 30 columns and that may take awhile. I want to minimize down to one column. I believe dv.Find() will work, but I don't know the exact syntax. If it comes down to it, I may have to resort to your...
  15. B

    Find substring in dataview/datagrid

    Hello everyone, Can anyone please show me how to find substring in dataview/datagrid? Basically, a column contains bunch of phone numbers 410-555-1212 410-379-2215 410-443-5214 410-555-2351 410-555-5623 410-895-8951 After sorting- 410-379-2215 410-443-5214 410-555-1212 410-555-2351...
  16. B

    SQL string concatenate field name

    Cool. There's something new to try. That solves the Select query, but doesn't the Select query generates a temporary view and bind it to the Recordset, for example. Isn't the field no longer startDate but [Start Date]? If I need to reference [Start Date], I don't think I can go back to...
  17. B

    SQL string concatenate field name

    This is a simple SQL Select query SELECT startDate as [Start Date] FROM Table WHERE [Start Date] = '8/16/2006' The error is "Invalid column name 'Start Date'". How would you fix that?
  18. B

    SQL string concatenate field name

    Paszt, That's very true. I have also tried Dataset but the problem lies at when a view as been created and by using the SELECT statement. How do you reference a field that was created using the SELECT statement, ie. ""Start Date"" or [Start Date]. I know that this works: date =...
  19. B

    SQL string concatenate field name

    Hello everyone, I am a newbie. I have tried to google all over the internet but of no avail. Can anyone help me on querying using vb.net SQL string with field name of two or more words, ie "Start Date", "Del Last First Name" Code: strSQL = "SELECT startDate as ""Start Date"", delLastFirst as...
Top Bottom