想用个存储过程删除数据库中的一条记录
我写的代码如下
类中
public void Delete(SqlConnection con, Mode_user model)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UP_user_info_Delete";
cmd.Parameters.Add("@u_userid", SqlDbType.NVarChar,10,ParameterDirection.Input.ToString());
cmd.Parameters.Add("@abc", SqlDbType.VarChar);
cmd.Parameters["@u_userid"].Value = model.u_userid;
cmd.ExecuteNonQuery();
}
事件中的代码
private void button6_Click(object sender, EventArgs e)
{
Class1 cl1 = new Class1();
SqlConnection con = new SqlConnection();
con = cl1.con("Data Source=.;Initial Catalog=budui;Integrated Security=True");
con.Open();
Mode_user mode_user = new Mode_user();
mode_user.u_userid = textBox1.Text.ToString();
cl1.Delete(con, mode_user);
con.Close();
}
存储过程
CREATE PROCEDURE UP_user_info_Delete
@u_userid nvarchar
AS
DELETE user_info
WHERE [u_userid] = @u_userid
GO
执行不抱错 但就是删不了记录 前辈门 帮忙看看 那的问题 搞了一晚上了 谢了先
我写的代码如下
类中
public void Delete(SqlConnection con, Mode_user model)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UP_user_info_Delete";
cmd.Parameters.Add("@u_userid", SqlDbType.NVarChar,10,ParameterDirection.Input.ToString());
cmd.Parameters.Add("@abc", SqlDbType.VarChar);
cmd.Parameters["@u_userid"].Value = model.u_userid;
cmd.ExecuteNonQuery();
}
事件中的代码
private void button6_Click(object sender, EventArgs e)
{
Class1 cl1 = new Class1();
SqlConnection con = new SqlConnection();
con = cl1.con("Data Source=.;Initial Catalog=budui;Integrated Security=True");
con.Open();
Mode_user mode_user = new Mode_user();
mode_user.u_userid = textBox1.Text.ToString();
cl1.Delete(con, mode_user);
con.Close();
}
存储过程
CREATE PROCEDURE UP_user_info_Delete
@u_userid nvarchar
AS
DELETE user_info
WHERE [u_userid] = @u_userid
GO
执行不抱错 但就是删不了记录 前辈门 帮忙看看 那的问题 搞了一晚上了 谢了先
@u_userid nvarchar--这里要写上数字的把nvarchar(10)
AS
DELETE user_info
WHERE [u_userid] = @u_userid
GO
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UP_user_info_Delete";
cmd.Parameters.Add("@u_userid", SqlDbType.NVarChar,10,ParameterDirection.Input.ToString());
cmd.Parameters.Add("@abc", SqlDbType.VarChar); //???
cmd.Parameters["@u_userid"].Value = model.u_userid;
cmd.ExecuteNonQuery();
}调试进去看看。
谢谢shuanghei(双黑) 就是哪个问题 嘿嘿 我有想吐血的冲动 搞了那么长时间 就这有错啊 郁闷
刚又遇到问题 在界面上添加信息 每次修改信息 都的 换图片 不换就抱错Class1 cl1 = new Class1();
SqlConnection con = new SqlConnection();
con = cl1.con("Data Source=.;Initial Catalog=budui;Integrated Security=True");
con.Open();
//获取图片流
string curFileName;
curFileName = openFileDialog1.FileName;
byte[] ib = new Byte[60000];
FileStream fs = new FileStream(string.Format("{0}", curFileName), FileMode.Open, FileAccess.Read);
fs.Read(ib, 0, 60000);
怎么会事啊
fs.close();
Class1 cl1 = new Class1();
SqlConnection con = new SqlConnection();
con = cl1.con("Data Source=.;Initial Catalog=budui;Integrated Security=True");
con.Open();
//获取图片流
string curFileName;
curFileName = openFileDialog1.FileName;
byte[] ib = new Byte[60000];
FileStream fs = new FileStream(string.Format("{0}", curFileName), FileMode.Open, FileAccess.Read);
fs.Read(ib, 0, 60000);
Mode_user mode_user = new Mode_user(); mode_user.u_danwei = dw_textBox3.Text;
mode_user.u_name = textBox2.Text;
mode_user.u_userid = textBox1.Text;
mode_user.u_born = born_dateTimePicker1.Value;
mode_user.u_indate = ruwudate_dateTimePicker3.Value;
mode_user.u_incity = ruwuaddress_textBox4.Text;
mode_user.j_id = 2;
mode_user.u_zheng = zheng_comboBox3.Text;
mode_user.u_intd = rudangtuandate_dateTimePicker2.Value;
mode_user.u_hun = hf_comboBox2.Text;
mode_user.u_hu = hu_comboBox4.Text;
mode_user.u_home = address_textBox7.Text;
mode_user.u_link = like_textBox8.Text;
mode_user.u_phone = tel_textBox5.Text;
mode_user.u_homeinfo = homeinfo_richTextBox2.Text;
mode_user.u_jiang = jiangfa_richTextBox5.Text;
mode_user.u_shouxun = shouxun_richTextBox4.Text;
mode_user.u_jianli = jianli_richTextBox1.Text;
mode_user.u_biaoxian = biaoxian_richTextBox3.Text;
mode_user.u_pic = ib;
mode_user.u_zaiwei = shifouzaiwei_comboBox5.Text; cl1.Add (con, mode_user,fs);
con.Close();