Search results for query: *

  1. P

    Why i get error like this : "Syntax error in query expression"

    Sir JohnH Hi, This code is for getting the data from listbox and display to textbox . I already get the code for displaying the data to listbox and now i want to display it in textbox . I can't understand what you said . can you explain or give example in vb.net ?
  2. P

    Why i get error like this : "Syntax error in query expression"

    What wrong with my code ? here's my code : Try Connection.Open() Dim query As String query = ("SELECT * from RegistrationTable WHERE _Name = '" & ListBox1.Text & "'") command = New OleDbCommand(query, Connection) Reader =...
  3. P

    Question How can i make auto increment in my textbox

    Sir Ian what if my database patientregistration table is blank or no data . then i run the program then i want to display 1 in my textbox PatientID . It is possible or not ?
  4. P

    Question How can i make auto increment in my textbox

    i can't understand . can you show me what your're saying ?
  5. P

    Question How can i make auto increment in my textbox

    Sir this is my new code but i i got error " Datatype mismatch in criteria expression. " in my database i already set the PatientID as primary and autonumber . but why i got error like this ? " Datatype mismatch in criteria expression. " Try Dim query As String =...
  7. P

    Question How can i make auto increment in my textbox

    Ok . i'll try to recode my code , even though it's hard for me . by the way this is my thesis project and i'm only a 3rd college student . can you give me sample of how should i start to recode my code ?
  8. P

    Question How can i make auto increment in my textbox

    i know now what is executescalar . but what if i don't use the autonumber in database ? i want to generate autonumber in my textbox ? you think it is possible ? because in my code that i post ., when i run the program and register i got the patient id = 1 and register again patient id = 2 but...
  9. P

    Question How can i make auto increment in my textbox

    Sorry . i don't know how to use ExecuteScalar . and what is @@IDENTITY ? is that column name ?
  10. P

    Question How can i make auto increment in my textbox

    I already try that but i don't know how i will display the ID column in my textbox , because im new in vb.net so its hard . can you give me some example of what your're saying ?
  11. P

    Question How can i make auto increment in my textbox

    All i want is every time i finish the registration and I click ADD button I want my ID increase one . Like 1 , 2 , 3, ... Here's my code Try cn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " & Application.StartupPath & "\HMSdb.accdb") cn.Open()...
Back
Top