C# App:how to fetch records from the database

[muskan]

hello,

Can u tell me how we can retrieve the records from the database.

[vinaykeshav]

connection = new SqlConnection();
connection.ConnectionString = "Persist Security Info=False;" +
  "Integrated Security=SSPI;database=northwind;" +
  "server=localhost;Connect Timeout=30";
connection.Open();
dataadapter = new SqlDataAdapter("select * from customers", connection);
dataset = new DataSet();
dataadapter.Fill(dataset, "table1");
dataGrid1.DataSource = dataset;
dataGrid1.DataMember = "table1";

[muskan]

Actually I want to know how we can fetch records from database into controls using dataadapter not execute reader command.

[vinaykeshav]

in the example i have provided it uses the dataadapter itself,
and datagrid is a control where the data is getting binded

Actually I want to know how we can fetch records from database into controls using dataadapter not execute reader command.

[muskan]

I want to put data into textboxes not datagrid

[vinaykeshav]

for a textbox i am sure that u wil not fetch more than one row of data
so,,..

connection = new SqlConnection();
connection.ConnectionString = "Persist Security Info=False;" +
"Integrated Security=SSPI;database=northwind;" +
"server=localhost;Connect Timeout=30";
connection.Open();
dataadapter = new SqlDataAdapter("select * from customers", connection);
dataset = new DataSet();
dataadapter.Fill(dataset, "table1");
//dataGrid1.DataSource = dataset;
//so once ur dataset is filled then from that pick one value
textbox1.text = dataset.tables("table1").columns("colname");

I want to put data into textboxes not datagrid

[muskan]

I have written like this but it shows column name into the textboxes.
means it is showing name & roll no in textboxes instead of data values.

txtname.Text =ds.Tables[0].Columns["name"].ToString() ;
txtroll.Text= ds.Tables[0].Columns["roll no"].ToString() ;
OR

txtname.Text =ds.Tables["deatail].Columns["name"].ToString() ;
txtroll.Text= ds.Tables["detail"].Columns["roll no"].ToString() ;

[vinaykeshav]

txtname.Text =ds.Tables[0].ds.Tables["details"].Rows[0]["name"].ToString() ;
txtname.Text =ds.Tables[0].ds.Tables["details"].Rows[0]["roll no"].ToString() ;


please specify the row no like zeroth ..

I have written like this but it shows column name into the textboxes.
means it is showing name & roll no in textboxes instead of data values.

txtname.Text =ds.Tables[0].Columns["name"].ToString() ;
txtroll.Text= ds.Tables[0].Columns["roll no"].ToString() ;
OR

txtname.Text =ds.Tables["deatail].Columns["name"].ToString() ;
txtroll.Text= ds.Tables["detail"].Columns["roll no"].ToString() ;

[muskan]

thanks ...........a lot

now it is working.

but we can see only one record at a time.
how we can see all records one by one.

[vinaykeshav]

to view the list u need to use the listbox / datagrid ,,, u can display all items inside the textbox using a comma seperator...

thanks ...........a lot

now it is working.

but we can see only one record at a time.
how we can see all records one by one.

[childg]

I tried the code above and it tells me that it can't connect to the server.

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections."

but i have my db local in the app_data folder.

[Shashi Sadasivan]

please refer to www.connectionstrings.com on how to create a connection string to your database (file / server based)

[childg]

edit: after like 2 hours of sitting debugging i figure out my select statement had a missing space between the quotes...gotta love those buggers.

[ashish711]

I Have To Insert Data In Sql Server Through Textbox WHEN CLICK ON BUTTON In Database Connectivity Plz Help Me