Results 1 to 2 of 2

Thread: Fetch the details about particular person from database

  1. #1

    Fetch the details about particular person from database

    I want to fetch the details about particular person from database by giving input in VB.

    For eg, If i give a name like 'Susi' in textbox of vb, it should fetch and display the corresponding details from database to VB.

    Can you just clarrify my doubts as soon as possible.


  2. #2
    Contributing Member
    Join Date
    May 2007
    Answers
    60

    Re: Fetch the details about particular person from database

    I am sending one example code for u just try that it will work...first import the System.data.sqlclient

    1. Place one textbox and one datagrid in form
    2. Dim cn as new SqlConnection("connection string")
    Dim da as new SqlDataAdapter("select * from tablename where columname='TextBox1.Text' ",cn)
    Dim ds as new DataSet
    da.fill(ds,"tablename")
    DataGrid1.DataSource=ds.tables("tablename")


    I hope it will work if not give me a reply and post what errors u r getting.......


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact