string nameStr;
cmd = new SqlCommand("SELECT idCode FROM tbl WHERE name=@Pname AND family=@Pfamily", con);
cmd.Parameters.AddWithValue("@Pname", textBox1.Text);
cmd.Parameters.AddWithValue("@Pfamily" , textBox2.Text);
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
nameStr = sdr.GetString(0);
MessageBox.Show(nameStr);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}