dcsimg

Search:

Type: Posts; User: mhmm

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    2,372

    Click Listboxes and the UI freezes

    Hi

    I've got a form which has a listbox on it, as well as a search button and of course the data entry text boxes. However when I click anything in the list box the whole UI freezes and I can't...
  2. Replies
    14
    Views
    5,747

    Re: Non exact search of a database

    Thank you so much for the help! I tried playing around with the position of the % sign and managed to get it to search how I wanted it to. Thank you guys again!
  3. Replies
    14
    Views
    5,747

    Re: Non exact search of a database

    Yes, I get results appearing. I then tried moving this to my GUI and ran it but again nothing appeared, I think it might be a problem with the GUI code as opposed to the database query :/
  4. Replies
    14
    Views
    5,747

    Re: Non exact search of a database

    Its not actually doing anything at all, I've removed the first % sign and nothing.

    Its within a button so that when people press search, it should then trigger the query.
  5. Replies
    14
    Views
    5,747

    Re: Non exact search of a database

    I've tried getting a LIKE query together for this, however I know I can't just give it a query, there are other bits involved.

    This is what I have so far:


    Dim SQLQuery = "Select FirstName...
  6. Replies
    14
    Views
    5,747

    Non exact search of a database

    Hi,

    I'm trying to do a non exact search of a database. ie. searching an address book searching John instead of John Smith.

    I've been told its possible to do but you have to make your own...
  7. Re: Cannot find a parameter that needs to be specified

    Thank you for getting back to me with this. I have a new error if it's okay to ask it in the same thread?

    My drop down boxes are now passing System.Data.DataRowView instead of an actual value...
  8. Re: Cannot find a parameter that needs to be specified

    I would have thought it had something to do with these lines from the SP:


    SET @PostcodeID = (SELECT PostcodeID FROM ContactPostcode WHERE Postcode = @PostcodeID)

    I tried rearranging...
  9. Re: Cannot find a parameter that needs to be specified

    I'll try putting them in order but what do you mean by



    ?
  10. Cannot find a parameter that needs to be specified

    Hi,

    Sorry the title wasn't as descriptive as I'd hoped (word restriction on it) but I've been getting this error for a while and I'm not too sure how to fix it. I have a database which is for...
  11. Replies
    1
    Views
    2,599

    Searching a database in a random order

    Hi,

    I'm trying to search through a database with a GUI that I've made, and it searches just fine when I do it in a specific order like:

    John Joseph Smith

    However when I look for something...
  12. Re: Open DataReader associated with this Command in a Try/Catch code

    IDE? I used that line of code from when you create a new ContactTableAdapter query

    LBSearch is a databound listbox and its bound to
    Datasource = ContactBindingSource
    DisplayMember = FirstName...
  13. Re: Open DataReader associated with this Command in a Try/Catch code

    Sorry just realised I hadn't posted the error message above.

    91027

    This error, when I run the code in my first post.
  14. Open DataReader associated with this Command in a Try/Catch code

    In my programming, I've had this error come up a lot recently and its stopping me from testing my code properly. It has to do with a Try/Catch piece of code I think.

    The code is as follows:

    ...
  15. Saving data from text boxes to an SQL server database

    Hi,

    I've been working on a piece of code to get a GUI to input data into then save to an SQL server database but as ever I got stuck. I followed a tutorial for it but now I'm stuck with the wrong...
  16. Replies
    4
    Views
    736

    Re: Problem when making an SQL connection in VB

    Thank you for getting back to me! It was that the database was still attached to the SQL Server management. The other thing was that because I was using Visual Basic and not Visual Studio, it didn't...
  17. Replies
    4
    Views
    736

    Problem when making an SQL connection in VB

    Hi,

    I've been working on making a GUI for data input into a Sql server database. However when I've tried using the SQL connection on in the design section but its just displays an error saying:
    ...
Results 1 to 17 of 18



Featured


Click Here to Expand Forum to Full Width