Calling Stored Procedures in ASP.NET 2.0 with C#

[Fiddlehead]

Hi

I have a WebPage which happily reads data FROM a database to fill drop-down lists etc, so my connection is OK.

I use code along these lines (ALL parameters omitted) to call a stored procedure in MS SQL Server Express 2005 (stored procedure works when tested independently). This code is my Submit Button's Event Handler. Can anyone tell me why this does not work. My page compiles & loads fine, but I keep getting the error message:

SqlConnection conn;
SqlCommand comm;
string connectionString =
ConfigurationManager.ConnectionStrings["HRConnectionString2"].ConnectionString;
conn = new SqlConnection(connectionString);
comm = new SqlCommand("sp_NewEmployee", conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add(new SqlParameter("@Employee_Name", txtEmpName.Text));
//..... other parameters added this way - tried lots of ways, believe me...
try {
conn.Open();
comm.ExecuteNonQuery();
dbErrorMessage.Text =
"Congratulations you finally managed to talk to a database!!!";
}
catch{
dbErrorMessage.Text ="Error adding new employee! Try again later!";
}
finally{
conn.Close();
}
}

[karenRoss]

This is how I would handle the same situation:

System.Data.SqlClient.SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrin gs["Intranet"].ConnectionString);
System.Data.SqlClient.SqlCommand updatecomm = new SqlCommand("EMP_spUpdateContactInfo", myConnection);
updatecomm.CommandType = CommandType.StoredProcedure;


updatecomm.Parameters.Add("@ContactData", SqlDbType.VarChar, 50).Value = data;

try
{
myConnection.Open();
System.Data.SqlClient.SqlDataReader updatereader = updatecomm.ExecuteReader(CommandBehavior.CloseConn ection);
updatereader.Close();