Am trying to read product name from the sql database and iwant to display it using amessage box on the form.but when i debug,the message box is empty.where is the problem.
//code to read name from the database.
public string hardname()
{
string name = "";
try
{
SqlConnection con = new SqlConnection("Data Source=HISHAMKAL-PC;Initial Catalog=LA GHardware;User ID=sa;Password=hish;");
SqlCommand cmd = new SqlCommand("SELECT 'Product_Name' FROM Hardware WHERE ID=" + textBox1.Text,con);
SqlDataReader reder = cmd.ExecuteReader();
while (reder.Read())
{
name =(string)reder[0];
}
con.Close();
}
catch(Exception x)
{
x.ToString();
}
return name;
}
//code behind the button
private void button1_Click(object sender, EventArgs e)
{
MessageBox.Show(hardname());
}