textbox dataset

altafingar · August 12th, 2004, 10:37 AM

I am trying to display the result of my select statement in a textbox.
For example I have a select statement that will return record from 3 different column in a table. I want the result to go to the text box i know how to display it in a datagrid or mxgrid but i want my query result togo into the textbox i have 3 text box my result from the select statement will be from 3 different column and so each textbox will get the result of each column. it works fine with datagrid or mxdatagrid.

thanks.

katsarosj · August 12th, 2004, 11:33 AM

Please post some code to show how you are loading your data.

altafingar · August 12th, 2004, 11:35 AM

its a access database file

mehdi62b · August 12th, 2004, 02:41 PM

use DataReader...

Code:

SqlDataReader s=objCommand.ExecuteReader();
while(s.Read())
{
TextBox1.Text+=s.GetString(0)+"\n";
TextBox2.Text+=s.GetString(1)+"\n";
TextBox3.Text+=s.GetString(2)+"\n";

}

--------------------------------------------
Mehdi.:)