How to fetch some of the data from databse to textbox in a form.

Do you know how to connect to a database using ADO.NET?

Do you know how to connect to a database using ADO.NET?

yes i know the connectivity steps.i am using sqlserver.my query is how to get the data from database to the textbox in a form.i know how to display the data from database to gridveiw but i dont know how to display it into textbox from database.

i hav a form. there is a roll.no textbox,i want that when i enter a roll no. ,that rollno if exist in a table in the database then it bring its corresponding values like name,add,etc to the textbox in the same form.
hope my query is clear.
plz reply as soon as possible.thanks ......

Then just write a select that filters according to the entered rollno and run that against the database when an appropriate event is fired.
Post your code if you still get problems with it.

...i know how to display the data from database to gridveiw but i dont know how to display it into textbox from database.

Well, we have two articles that you might want to read. After that, you should be able to figure out how to fill a textbox from a database.

Article 1
Article 2

Well, we have two articles that you might want to read. After that, you should be able to figure out how to fill a textbox from a database.

Article 1
Article 2

thanks for the articles.The matter u hav given me,i already know that,what i want to know is described below.
i m using C# .net and working on window forms.
my code is-

SqlConnection cn = new SqlConnection() ;
cn.ConnectionSt ring = "Data Source= abc ;Database=def ;uid=ghh ;pwd=ty ";
cn.Open();
string sql="select * from order where order_no=@order ";
SqlCommand cmd=new SqlCommand(sql, cn);
cmd.Parameters. AddWithValue("@ order",Convert. ToInt32(textBox 1.Text);
SqlDataAdapter da=new SqlDataAdapter( cmd);
da.Fill(dt); /*dt is a instance of DataTable*/
dataGridView1.D ataSource=dt;
cn.Close();
............... ............... ............... ............... ............... ...........
i want to show the values in textbox respectively.
i know how to show the data in gridview but i want to know how can i get the data in textBox not in dataGridview.

So, instead of making the DataTable a datasource for the gridview, loop through it and put the contents in a textbox. Or, if you are just selecting one value, you can use the ExecuteScalar method that I discuss in the 2nd article. Just cast the return value as a string, and then put that string in a textbox. You're making this harder than it has to be.

So, instead of making the DataTable a datasource for the gridview, loop through it and put the contents in a textbox. Or, if you are just selecting one value, you can use the ExecuteScalar method that I discuss in the 2nd article. Just cast the return value as a string, and then put that string in a textbox. You're making this harder than it has to be.

thanks i got it,i will try it.

thanks i got it,i will try it.

thank u ,its working.

Glad to help.