how to get id value From Table in text box c#? windows app

Jyoti Jodha

con.Open();

SqlCommand cmd = new SqlCommand("select Description,Tax_ID, Unit_id from Product where Name= '" + producttxt.Text + "'", con);

SqlDataReader sdr = cmd.ExecuteReader();

while (sdr.Read())

{

ProductExists = 1;

dectxt.Text = sdr.GetString(0);

txtqty.Text = sdr.GetString(2);

txttax.Text = sdr.GetString(1);

ProductExists = 1;

}

con.Close();

How to Get Tax_ID & Unit_ID his Values from Tax And Unit Database table......???

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
in order to get product Id
you can make product as dropdown and bind Id and name ito it
than when you select you can see only name behind Id wil be there you can use that here
+1
Rafnas T P9y ago
if you select like this you will get more than one result, and your result will be from first row,
so please avoid this
+1
Rafnas T P9y ago
hi jyoti,

first of all you should not select items from product based on Name, you should use product id(primary key) because product name may be same but Id never
+1
Ramesh Palanivel9y ago
Hi Joythi,

In your code, try this,
int id=0;
con.Open();
SqlCommand cmd = new SqlCommand("select Id,Description,Tax_ID, Unit_id from Product where Name= '" + producttxt.Text + "'", con);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ProductExists = 1;
id=Convert.ToInt32(str.GetString(0));
dectxt.Text = sdr.GetString(1);
txtqty.Text = sdr.GetString(3);
txttax.Text = sdr.GetString(2);
ProductExists = 1;
}
con.Close();
con.Open();
SqlCommand cmd1 = new SqlCommand("select Tax_id,unit_ID from TaxTable where Id='"+id+"', con);
SqlDataReader sdr1 = cmd1.ExecuteReader();
while (sdr1.Read())
{
// write your textbox code here
}
con.Close();
+2