retreive values from the database in asp.net using c#

[muskan]

hello,

I have written below code for retreiving the values from database into the textboxes only when I enter id into the textbox.
but it doesn't show any values ino the textboxes.

please tell how it will be done.

da = new SqlDataAdapter("select * from customers where customerid=" + '" + txtcustid.Text + "' ,conn);

DataSet ds = new DataSet();
da.Fill(ds,"customers");

for(s=0;s<ds.Tables[0].Rows.Count ;s++)
{
if( txtcustid.Text== ds.Tables[0].Rows[s]["customerid"].ToString() )
{
txtcustid.Text =ds.Tables[0].Rows[s] ["customerid"].ToString();

Txtcustname .Text =ds.Tables[0].Rows[s]["contactname"].ToString();
Txtdept.Text= ds.Tables[0].Rows[s]["organisation"].ToString();
}
break;
}

[sandeepk84]

hello,

I have written below code for retreiving the values from database into the textboxes only when I enter id into the textbox.
but it doesn't show any values ino the textboxes.

please tell how it will be done.

da = new SqlDataAdapter("select * from customers where customerid=" + '" + txtcustid.Text + "' ,conn);

DataSet ds = new DataSet();
da.Fill(ds,"customers");

for(s=0;s<ds.Tables[0].Rows.Count ;s++)
{
if( txtcustid.Text== ds.Tables[0].Rows[s]["customerid"].ToString() )
{
txtcustid.Text =ds.Tables[0].Rows[s] ["customerid"].ToString();

Txtcustname .Text =ds.Tables[0].Rows[s]["contactname"].ToString();
Txtdept.Text= ds.Tables[0].Rows[s]["organisation"].ToString();
}
break;
}

Hi...
i think u may have some pblm while u specify d sqlquery
ie. while calling d SqlDataAdapter() constructor by passing d query...
try like dis...

da = new SqlDataAdapter("select * from customers where
customerid ='"+ txtcustid.Text + "'" ,conn);

hope this helps...
thanx and rgrds..
sand...

[Rathorevivek]

Hi,
Here is the modified code.

DataSet ds =new DataSet();
SqlDataAdapter da= new SqlDataAdapter("select * from Customers","database=Test;server=Test;uid=test;pwd =test");
da.Fill(ds);
for(i=0;i<ds.Tables[0].Rows.Count;i++) ///or if(ds.Tables[0].Rows.Count>0)
{
TextBox1.Text= ds.Tables[0].Rows[0]["CustomerID"].ToString();
TextBox2.Text=ds.Tables[0].Rows[0]["CustomerName"].ToString();
TextBox3.Text=.................................... .
}

I had tested it and its working well.
Hope It will help you.

Vivek Rathore.

hello,

I have written below code for retreiving the values from database into the textboxes only when I enter id into the textbox.
but it doesn't show any values ino the textboxes.

please tell how it will be done.

da = new SqlDataAdapter("select * from customers where customerid=" + '" + txtcustid.Text + "' ,conn);

DataSet ds = new DataSet();
da.Fill(ds,"customers");

for(s=0;s<ds.Tables[0].Rows.Count ;s++)
{
if( txtcustid.Text== ds.Tables[0].Rows[s]["customerid"].ToString() )
{
txtcustid.Text =ds.Tables[0].Rows[s] ["customerid"].ToString();

Txtcustname .Text =ds.Tables[0].Rows[s]["contactname"].ToString();
Txtdept.Text= ds.Tables[0].Rows[s]["organisation"].ToString();
}
break;
}

[aaryan]

hello,

I have written below code for retreiving the values from database into the textboxes only when I enter id into the textbox.
but it doesn't show any values ino the textboxes.

please tell how it will be done.

da = new SqlDataAdapter("select * from customers where customerid=" + '" + txtcustid.Text + "' ,conn);

DataSet ds = new DataSet();
da.Fill(ds,"customers");

for(s=0;s<ds.Tables[0].Rows.Count ;s++)
{
if( txtcustid.Text== ds.Tables[0].Rows[s]["customerid"].ToString() )
{
txtcustid.Text =ds.Tables[0].Rows[s] ["customerid"].ToString();

Txtcustname .Text =ds.Tables[0].Rows[s]["contactname"].ToString();
Txtdept.Text= ds.Tables[0].Rows[s]["organisation"].ToString();
}
break;
}

hi muskan,
i remember reading it somewhere that if we want to filter a query this is the bad way of doing it
[HTML]da = new SqlDataAdapter("select * from customers where customerid=" + '" + txtcustid.Text + "' ,conn); [/HTML]
to know much about it, you can go thro the following link. hope it will help you.
http://www.csharp-station.com/Tutori.../Lesson06.aspx