What is missing?

I have a webform that has four text box inputs and a button for inserting data into a database. See below: Here is the code behind: using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Text; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; namespace TimeSheet1 { ///

/// Summary description for Profile. ///

public class Profile : System.Web.UI.Page { protected System.Web.UI.WebControls.TextBox F_Name; protected System.Web.UI.WebControls.TextBox L_Name; protected System.Web.UI.WebControls.TextBox Emp_Num; protected System.Web.UI.WebControls.TextBox Email; protected System.Web.UI.WebControls.TextBox Phone; protected System.Web.UI.WebControls.Button Add_Profile; private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here } public void AddProfile_Click(Object sender, EventArgs E) { SqlConnection sqlConn = new SqlConnection("server=C099450d01;uid=sa;pwd=;database=WebTimeSheet"); sqlConn.Open(); SqlCommand com = new SqlCommand("InsertProfile",sqlConn); com.CommandType = CommandType.StoredProcedure; com.ExecuteNonQuery(); sqlConn.Close(); } #region Web Form Designer generated code } } As you can see the code behind page is callng a stored procedure to insert data into the Profile table: Here is the stored procedure: ALTER PROCEDURE dbo.InsertProfile ( @F_Name [varchar] (100), @L_Name [varchar] (100), @Emp_Num [numeric] (9), @Email [varchar] (250), @Phone [nvarchar] (12) ) AS Insert into [Profile] ( [F_Name], [L_Name], [Emp_Num], [Email], [Phone] ) Values (@F_Name, @L_Name, @Emp_Num, @Email, @Phone) The problem is that when I submitt the form, I get an error indicating that there is no value for @F_Name. It would appear to me that the values from the form are not making it to the stored procedure. Can anyone help me with what code is missing to complete this action? Thank you. Sincerely, Tim P.S. Sorry for the long post. This forum should really incoporate formating for code blocks.

Maybe I don't see the big picture, but here's what I do see: public void AddProfile_Click(Object sender, EventArgs E) { SqlConnection sqlConn = new SqlConnection("server=C099450d01;uid=sa;pwd=;database=WebTimeSheet"); sqlConn.Open(); SqlCommand com = new SqlCommand("InsertProfile",sqlConn); com.CommandType = CommandType.StoredProcedure; com.ExecuteNonQuery(); sqlConn.Close(); } You create a SQL Command, but you don't create any parameters and set their values. How will the parameters get there if you don't set the command's parameter values? My recommendation would be to write the code in a standard winforms application that will do what you want it to do with the database, then move that code over to your ASP.NET application. That way you know if the problem is in the HTMl, the codebehind or the stored procedure.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

spgilmore22y ago
Maybe I don't see the big picture, but here's what I do see: public void AddProfile_Click(Object sender, EventArgs E) { SqlConnection sqlConn = new SqlConnection("server=C099450d01;uid=sa;pwd=;database=WebTimeSheet"); sqlConn.Open(); SqlCommand com = new SqlCommand("InsertProfile",sqlConn); com.CommandType = CommandType.StoredProcedure; com.ExecuteNonQuery(); sqlConn.Close(); } You create a SQL Command, but you don't create any parameters and set their values. How will the parameters get there if you don't set the command's parameter values? My recommendation would be to write the code in a standard winforms application that will do what you want it to do with the database, then move that code over to your ASP.NET application. That way you know if the problem is in the HTMl, the codebehind or the stored procedure.
+1