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

Question

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......???

Rafnas T P · 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

Ramesh Palanivel · Answer

Hi Joythi In your code try this int id=0; con.Open(); SqlCommand cmd = new SqlCommand( select Id DescriptionTax_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_idunit_ID from TaxTable where Id=' +id+ ' con); SqlDataReader sdr1 = cmd1.ExecuteReader(); while (sdr1.Read()) { // write your textbox code here } con.Close();

Rafnas T P · Answer

if you select like this you will get more than one result and your result will be from first row so please avoid this

Rafnas T P · Answer

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