用存储过程嘛,很好用的东西干嘛不用:
create procedure [sp_insert]
(
@name as varchar(50)
)
as
if(exists(select * from [user] where name=@name))
begin
return(-1);
end
else
begin
insert into [user](name) values(@name);
return (1);
SqlConnection conn = new SqlConnection("server=pany;database=pany;uid=sa;pwd=123");
conn.Open();
string strSQL= "select * from user where name='" + Name.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(strSQL,conn)
DataSet ds = new DataSet();
da.Fill(ds);
if(ds.Tables[0].Rows.Count==0)
{
strSQL = "INSERT INTO user (name) VALUES ( '" + Name.Text + "')";
SqlCommand myCmd = new SqlCommand(strSQL,conn);
myCmd.ExecuteNonQuery();
}
else
{
//已经存在,不可插入