dcsimg

Search:

Type: Posts; User: nbrege

Page 1 of 13 1 2 3 4

Search: Search took 3.24 seconds.

  1. Replies
    4
    Views
    312

    VS 2017 Re: Need help connecting to database

    I have always used ODBC in the past with SQL Server without any issues. I guess my connection string is wrong in this case.

    Also, that code I posted is just for testing. I always have it do...
  2. Replies
    4
    Views
    312

    VS 2017 Need help connecting to database

    I'm trying to connect to a MS SQL database. I can connect to it just fine using the Server Explorer in Visual Studio, but I can't seem to connect to it through code alone. The Server Explorer...
  3. Replies
    4
    Views
    363

    VS 2017 Re: Need help getting data from XML file

    To clarify what I'm looking for, I need the data highlighted below, for each <Row> element in the XML file:


    <Row>
    <Cell>
    <Data...
  4. Replies
    4
    Views
    363

    VS 2017 Need help getting data from XML file

    I've been struggling with this for a few hours now & can't get it to work. I have an XML file that will be provided by a customer & I need to extract the data from it. Here is the XML I have to...
  5. VS 2017 Re: Find words from a list of letters

    Peter ... your solution is still not working correctly. Using "benrt" as the search letters, it's returning "abate", "abort", "agent", etc. It shouldn't return those words since there is no "a",...
  6. VS 2017 Re: Find words from a list of letters

    Paul ... with a few tweaks I got your code to work. Thanks.
  7. VS 2017 Re: Find words from a list of letters

    Peter ... I tried your code, but I'm getting unexpected results. Using the list of letters in your code ("benrt"), it's returning words like "aberrant", "banister" & "tribune". The only word that...
  8. VS 2017 Re: Find words from a list of letters

    Thanks for the replies guys. I'm using the following code to read the list of words into a List object & filter them for the desired length...


    Dim wordList As New List(Of String)
    ...
  9. VS 2017 [RESOLVED] Find words from a list of letters

    I want to create a program to find all the words that can be made from a list of letters. So for example, if I have the letters D, E, I, N, R & V ... I could make the words Die, Den, End, Drive,...
  10. Re: Problem installing Access distributable - help please

    Thanks. Using the /quiet switch did the trick.
  11. [RESOLVED] Problem installing Access distributable - help please

    I'm trying to create a VB.net app that can read/write to an Access database & have it run on a PC that has MS Office365 installed, which doesn't include Access. From everything I've read it seems I...
  12. Replies
    5
    Views
    462

    VS 2017 Re: Extracting data from XML file

    Great explanation. Thanks again!
  13. Replies
    5
    Views
    462

    VS 2017 Re: Extracting data from XML file

    Thanks dday ... that gives me a good start. I am just getting back into programming after a several year break, so I'm a bit rusty.
  14. Replies
    5
    Views
    462

    VS 2017 [RESOLVED] Extracting data from XML file

    How would I loop through each node of this XML sample and extract the date & price for each node? Thanks in advance for any help...



    <div class="page">



    <table...
  15. Replies
    29
    Views
    1,985

    VS 2017 Re: Issue with reading Access database

    Ahhh, yes you are correct. I temporarily switched to compile to x64. When I switched to x86 it ran fine on the target PC. So it looks like I have a path forward now. Thanks for everybodies...
  16. Replies
    29
    Views
    1,985

    VS 2017 Re: Issue with reading Access database

    OK, I just got a chance to try the Jet provider and now I'm getting this error on my dev machine:

    "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine"

    Any ideas?
  17. Replies
    29
    Views
    1,985

    VS 2017 Re: Issue with reading Access database

    I will try the Jet provider tomorrow morning. If that doesn't work then I think I will give this a try...
  18. Replies
    29
    Views
    1,985

    VS 2017 Re: Issue with reading Access database

    The PC I am testing on has both Access and Office installed. I am stumped at this point & ready to just use text files. I don't want to have users have to download & install anything on their PC's....
  19. Replies
    29
    Views
    1,985

    VS 2017 Re: Issue with reading Access database

    Well I just tried it using OLEDB and I still have problems. This is the connection string I'm using:


    Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data...
  20. Replies
    29
    Views
    1,985

    VS 2017 Re: Issue with reading Access database

    OK, I will give that a shot. The only reason I didn't use OLEDB is because I tried using it on a previous project & had issues with being able write data to columns that had validation rules on...
  21. Replies
    29
    Views
    1,985

    VS 2017 Re: Issue with reading Access database

    152271
  22. Replies
    29
    Views
    1,985

    VS 2017 Re: Issue with reading Access database

    Any particular reason? Why does it work on my machine?
  23. Replies
    29
    Views
    1,985

    VS 2017 Re: Issue with reading Access database

    As I stated in post #4 ... my connection string in my code has the actual network path. I just used a dummy path in my example.
  24. Replies
    29
    Views
    1,985

    VS 2017 Re: Issue with reading Access database

    I just have the connection string hard-coded in the program for now. And the connection string contains the actual network path name. I just used a dummy filename in my example above...
  25. Replies
    29
    Views
    1,985

    VS 2017 Issue with reading Access database

    I have developed a small app that reads some data that is stored in a table in an Access database that is located in a network folder. The app works perfect on my dev machine with no issues...
  26. Re: Error inserting into an Access field with a validation rule

    Thanks for leading me in the right direction. I switched to an odbc connection and it works as desired now.
  27. Re: Error inserting into an Access field with a validation rule

    Dim MDBConnString_ As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & path
  28. Re: Error inserting into an Access field with a validation rule

    After playing around a bit I discovered that if I actually try to insert the string "????-??????" it works. So apparently the "?" acts as a literal character instead of a wildcard, which is totally...
  29. Re: Error inserting into an Access field with a validation rule

    Yes, inserting as string. Like I said ... if I remove the validation rule from the field it does the insert just fine.
  30. [RESOLVED] Error inserting into an Access field with a validation rule

    I'm having an issue inserting data into an Access table in a field that has a validation rule on it. The field is storing a part number in the format of "xxxx-yyyyyy". There is a validation rule of...
  31. Replies
    2
    Views
    640

    Cloning a row in Sql Server

    I need some help cloning/duplicating a row in Sql Server. Assuming I have the following schema:

    Col1 (int Identity=True)
    Col2 (varchar)
    Col3 (varchar)
    Col4 (varchar)

    How would I clone one...
  32. Replies
    2
    Views
    907

    VS 2015 Re: Why does RowEnter event fire twice?

    Actually the event only fires twice on the first click after the initial load. Any subsequent clicks only fire the event once. I guess that is tolerable. Yeah, I could do what you suggested, but...
  33. Replies
    2
    Views
    907

    VS 2015 Why does RowEnter event fire twice?

    After initially loading a DataGridView with some rows from a database, the first row is selected & the RowEnter event fires once, which is fine. If I then click on any other row, the RowEnter event...
  34. Replies
    1
    Views
    407

    VS 2015 Get DataGridView display area width

    Is there a way to get the width of the display area of a DGV? By that I mean the width minus the vertical scroll bar. Is it a matter of just adding up the widths of all the visible columns? Is...
  35. VS 2015 Re: Adding a UserControl to a DataGridView cell ... need a little help

    I am doing that only because that's how it was done in the example I found, that I linked to in my first post. I have never used the CellPainting event before so this is new to me.




    That was...
  36. VS 2015 Re: Adding a UserControl to a DataGridView cell ... need a little help

    Thanks for the reply ... what you said makes sense. Here is the current version of my code, which seems to fix the previous problems I was having. Can you review it & see if I'm doing it the most...
  37. VS 2015 Re: Adding a UserControl to a DataGridView cell ... need a little help

    Yes, I'm sure. That's where the screen shot came from. Like I said, it's close to working except that when I scroll the DGV up & down, the cell in the top displayed row always shows the same user...
  38. VS 2015 Re: Adding a UserControl to a DataGridView cell ... need a little help

    Well, it's getting closer. The extra user control no longer displays at 0,0 as desired, but now the user control in row 1 is not changing when I scroll up & down. All the rows below it work fine. ...
  39. VS 2015 Re: Adding a UserControl to a DataGridView cell ... need a little help

    Kebo ... you are correct. I did try that earlier & saw the {0,0}'s, but unsure how to resolve. Any ideas?
  40. VS 2015 Re: Adding a UserControl to a DataGridView cell ... need a little help

    Project attached
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width