public int update(string SP_Name)
{
c = new DBaccess();
int a;
c.connect();
c.cmd = new SqlCommand(SP_Name, c.con);
c.cmd.CommandType = CommandType.StoredProcedure;
c.cmd.Parameters.AddWithValue("@stid", _stid);
c.cmd.Parameters.AddWithValue("@sname", _sname);
c.cmd.Parameters.AddWithValue("@dob", _dob);
c.cmd.Parameters.AddWithValue("@gender", _gender);
c.cmd.Parameters.AddWithValue("@photo", _photo);
c.cmd.Parameters.AddWithValue("@mname", _mname);
c.cmd.Parameters.AddWithValue("@fname", _fname);
c.cmd.Parameters.AddWithValue("@saddress", _saddress);
c.cmd.Parameters.AddWithValue("@mobileno", _mobileno);
a = c.cmd.ExecuteNonQuery();
c.disconnect();
if (a > 0 && (countstid() > 0))
{
return 1;
}
else
{
return -1;
}
}
What I have tried:
public int update(string SP_Name)
{
c = new DBaccess();
int a;
c.connect();
c.cmd = new SqlCommand(SP_Name, c.con);
c.cmd.CommandType = CommandType.StoredProcedure;
c.cmd.Parameters.AddWithValue("@stid", _stid);
c.cmd.Parameters.AddWithValue("@sname", _sname);
c.cmd.Parameters.AddWithValue("@dob", _dob);
c.cmd.Parameters.AddWithValue("@gender", _gender);
c.cmd.Parameters.AddWithValue("@photo", _photo);
c.cmd.Parameters.AddWithValue("@mname", _mname);
c.cmd.Parameters.AddWithValue("@fname", _fname);
c.cmd.Parameters.AddWithValue("@saddress", _saddress);
c.cmd.Parameters.AddWithValue("@mobileno", _mobileno);
a = c.cmd.ExecuteNonQuery();
c.disconnect();
if (a > 0 && (countstid() > 0))
{
return 1;
}
else
{
return -1;
}
}
asp.net in c#