C#Windows应用程序中的数据插入问题

问题描述

当我单击注册"按钮时，它显示诸如过程或函数sp_InsertStudent"的错误，期望参数"@RollNo"(未提供).我没有找到解决方法...请帮助.

When i click the Register button it gives error like "Procedure or Function ''sp_InsertStudent'' expects parameter ''@RollNo'', which was not supplied.". I m not finding how to solve it... Plz help.

//code for front end that works against the clicking of Register button

private void btnRegister_Click(object sender, EventArgs e)
{
    string source = ("data source = localhost; database = student; " +
                     "Integrated Security = SSPI");
    SqlConnection conn = new SqlConnection(source);
    conn.Open();
    SqlCommand cmd = new SqlCommand("sp_InsertStudent", conn);
    cmd.CommandType = CommandType.StoredProcedure;
    //cmd.Parameters.Add("@RollNo", SqlDbType.Int, 0, "RollNo");
    cmd.Parameters.Add("@Name", SqlDbType.VarChar, 30, "Name");
    cmd.Parameters.Add("@CourseName", SqlDbType.VarChar, 20,
                       "CourseName");
    cmd.Parameters.Add("@Fee", SqlDbType.VarChar, 6,
                       "CourseName");
    cmd.ExecuteNonQuery();
    conn.Close();
}

-- My stored Procedure for inserting data in the table Student_Registration

Create Procedure sp_InsertStudent
@RollNo int,
@Name Varchar(30),
@CourseName Varchar(20),
@Fee int
As
BEGIN
 SET NOCOUNT ON
INSERT INTO dbo.Student_Registration
(
RollNo,
Name,
CourseName,
Fee
 )
     VALUES
          (
            @RollNo,
            @Name,
            @CourseName,
            @Fee
          )
END

GO

[修改:添加的代码格式]

[Modified: added code formatting]

推荐答案

   private void btnRegister_Click(object sender, EventArgs e)
{
	//Need Variables to add to SP
	int RollNumber=1;
	string Name="Some Name";
	string courseName="Course Name";
	int Fee=25;


	string source = ("data source = localhost; database = student; " +
	                 "Integrated Security = SSPI");
	SqlConnection conn = new SqlConnection(source);
	conn.Open();
	SqlCommand cmd = new SqlCommand("sp_InsertStudent", conn);
	cmd.CommandType = CommandType.StoredProcedure;
	cmd.Parameters.AddWithValue("@RollNo",RollNumber);
	cmd.Parameters.AddWithValue("@Name",Name);
	cmd.Parameters.AddWithValue("@CourseName",courseName);
	cmd.Parameters.AddWithValue("@Fee",Fee);
	cmd.ExecuteNonQuery();
	conn.Close();
} 

这篇关于C#Windows应用程序中的数据插入问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！