how to get values in text box from database

[praveenkhade]

i have 8 textboxs with one uniqe id (Acc id) . i want to fetch it from database (as i have datas in database), to these texboxs.
plz help me out...........................

[dip_developer]

i have 8 textboxs with one uniqe id (Acc id) . i want to fetch it from database (as i have datas in database), to these texboxs.
plz help me out...........................

please elaborate....did not understand your problem....

[DKn]

hai..

you write a function like this.

public DataSet GetParticularEmpDetails(int EmpID)
        {
    String connectStr ="EmpDetails.mdb";   //Give the proper connection string  here ;
 
            OleDbConnection con = new OleDbConnection(connectStr);
            con.Open();
            OleDbDataAdapter da = new OleDbDataAdapter("Select * from EmpDetails where EmpID= " +EmpID +" ", con);
 
            DataSet ds = new DataSet();
            da.Fill(ds, "Employee");
            return ds;
         }

in that calling function you will get DS.

DataSet ds = new DataSet();
ds= GetParticularEmpDetails(EMPID)
 
           txtEmpId.Text = ds.Tables[0].Rows[0][0].ToString();
            txtName.Text = ds.Tables[0].Rows[0][1].ToString();
            txtDesignation.Text = ds.Tables[0].Rows[0][2].ToString();
            txtLocation.Text = ds.Tables[0].Rows[0][3].ToString();
 

Try this. It may work out.

i have 8 textboxs with one uniqe id (Acc id) . i want to fetch it from database (as i have datas in database), to these texboxs.
plz help me out...........................