Im trying to insert records in table..
if the name is already existed in particular column, i have to display. Username alredy existed.
else insert that records...
I have tried like this...
protected void Update_Click(object sender, EventArgs e)
{
int d = obj.check_mandal(txt_mname.Text);
if (d > 0)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Mandal name already existed. kindly update it.');", true);
}
else
{
obj.mandals(txt_mname.Text, txt_desp.Text);
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Mandal details inserted Sucessfully');", true);
txt_mname.Text = txt_desp.Text = "";
}
}
public int check_mandal(string s)
{
SqlConnection con = new SqlConnection(s1);
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_check_mandal";
cmd.Parameters.AddWithValue("@mname", s);
con.Open();
int c = cmd.ExecuteNonQuery();
con.Close();
return c;
}
public void mandals(string mname, string desp1)
{
SqlConnection con = new SqlConnection(s1);
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_mandal";
con.Open();
cmd.Parameters.AddWithValue("@spmname", mname);
cmd.Parameters.AddWithValue("@spdesp", desp1);
cmd.ExecuteNonQuery();
con.Close();
}
sql....
create procedure [dbo].[sp_mandal]
@spmname varchar(100),@spdesp varchar(max)
as
begin
insert into mandal(mname,desp) values(@spmname,@spdesp)
end
CREATE procedure [dbo].[sp_check_mandal](@mname varchar(100))
as
begin
select mname from mandal where mname=@mname
end
But it showing error:
Procedure or function sp_mandal has too many arguments specified.
Kindly help me to fix this issue..
Thanks in advance