C# asp.net winforms strings

Question

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());

          }