table Member:
MemberID | MemberName | Type
Insert query:
ALTER PROCEDURE [dbo].[SavetblMember]
(
@MemberID varchar (50),
@MemberName varchar (50),
@Type varchar (50)
)
as
INSERT INTO tblMember(MemberID, MemberName, Type)
VALUES(@MemberID, @MemberName, @Type)
C# code:(to save the member)
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
string c = ConfigurationManager.ConnectionStrings["Constr"].ConnectionString;
SqlConnection conn = new SqlConnection(c);
SqlCommand cmd = new SqlCommand("SavetblMember", conn);
conn.Open();
cmd.ExecuteNonQuery();
cmd.Parameters.Add("@MemberID", SqlDbType.VarChar, 50).Value = metroTextBox1.Text;
cmd.Parameters.Add("@MemberName", SqlDbType.VarChar, 50).Value = metroTextBox2.Text;
cmd.Parameters.Add("@Type", SqlDbType.VarChar, 50).Value = CombMemType.Text;
conn.Close();
storedprocMem();
}
catch (SqlException ex)
{
MetroMessageBox.Show(this, "Error" + ex.Message);
}
}
When I try to Add member,update and delete, it throws me Sqlexception:
Error procedure or Function 'SavetlMem'expects parameter '@MemberID', which was not supplied.
I put execute statement after the parameter it gives me same error.
I tried by OleDbtype for it but didn't work.