retrieving a selected field from database through textbox

Question

hi frnd's  please help me in explaining me how to retrieve a selected field from database in c# language.. For example . entering a roll no in a text box  then the data corresponding to that roll no. should be retrived from the database and should be displayed in grid view .

ajay raju · Answer

hi friend write the code like the following: string str = select sub1sub2 from marks where rollno =  + TextBox1.Text; SqlDataAdapter da = new SqlDataAdapter (strcn); DataSet ds = new DataSet(); da.Fill(dsmarks); Gridview1.Datasource = ds.Tables[0]; Gridview1.DataBind(); it will may helps you. if it helps you please mark as Accepting Answer. Thanks.

Liya · Answer

are you looking for the query? int rolNo = 0; bool isOk = Int32.TryParse(MyTextBox.Text out rollNo); if (isOk) { string sql = select columnA cilumnB from myTable where ColumnRollNo =  + Convert.ToInt32(MyTextBox.Text); ...here go to db in the way you work and run the query or call the stored procedure with the parameter rollNo }