dataGrid and textBox

[aPerfectCircle]

I can display results of a view I created in Sql server on a dataGrid,how would I display the same result on a txtBox ???

aPerfectTool

[freshonlineMax]

Hi I think you want to access database tables field to show in textbox. If below code is not your answer contact me: SqlConnction cnn = new SqlConnection("Data Source=YourCopmputerName;Initial Catalog=YouDatabaseName;User Id=databaseUserName;Password=DatabasePassword"); string strSql="SELECT id,name FROM Table1"; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(strSql,cnn); da.fill(ds,"Table1"); if (ds.Tables[0].Rows.Count != 0) { TextBox1.Text = ds.Tables[0].Rows[0][1].toString(); } This code get "name" column of tables from first row. you can access another cells by changing array index. Bye

[mkc2k3]

Hi, I think U can achieve this in two ways. 1) Command.Text = "SELECT * FROM UR View Name (Nested of Table Name)" 2) Create one store Proc, Let the Store Proc intern selects view data by executing SELECT * FROM UR View Name. For binding and displaying on Data Grid follow normal method.

Happy Coding Gowda

[aPerfectCircle]

Thanks guys, I got it going, your reponse helped me alot :|

aPerfectTool