向表中插入数据时报错
SqlDataAdapter da = new SqlDataAdapter();String strconn = ConfigurationManager.ConnectionStrings["dsn"].ConnectionString;
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlCommand selectCmd = new SqlCommand();
selectCmd.CommandText = "select * from UserInfo";
selectCmd.Connection = conn;
SqlCommand insertCmd = new SqlCommand();
insertCmd.CommandText = "insert into UserInfo values(@people,@pwd,@email,@name,@address,@phone)";
insertCmd.Connection = conn;
insertCmd.Parameters.Add("@people", SqlDbType.NVarChar, 50, "people");
insertCmd.Parameters.Add("@pwd", SqlDbType.NVarChar, 50, "pwd");
insertCmd.Parameters.Add("@email", SqlDbType.NVarChar, 50, "email");
insertCmd.Parameters.Add("@name", SqlDbType.Money, 50, "name");
insertCmd.Parameters.Add("@address", SqlDbType.NVarChar, 100, "address");
insertCmd.Parameters.Add("@phone", SqlDbType.NVarChar, 50, "phone");
da.SelectCommand = selectCmd;
da.InsertCommand = insertCmd;
DataSet data = new DataSet();
da.Fill(data, "UserInfo");
DataRow drNew = data.Tables["UserInfo"].NewRow();
drNew[1] = txt_name.Text;
drNew[2] = txt_psw.Text;
drNew[3] = txt_email.Text;
drNew[4] = txt_realanme.Text;
drNew[5] = txt_address.Text;
drNew[6] = txt_tel.Text;
drNew[6] = txt_tel.Text;
data.Tables["UserInfo"].Rows.Add(drNew);
da.Update(data,"UserInfo");
Response.Write("<script>alert('添加成功!')</script>");
表UserInfo中最后一个字段数regtime,数据类型是datetime,设置了(getdate())
运行时提示“da.Update(data,"UserInfo");”有错误。
错误信息:[img=http://fleet1.footbig.com/f/00/00/2b/9e/l/90/be/90bed04d5f040513d384933d477c74cf-5486.jpg ][/img]
da.update 有什么问题吗?
--------------------编程问答-------------------- 很简单你的SQLSever表单中有数据格式不对都改成Varchar的 --------------------编程问答-------------------- insertCmd.Parameters.Add("@name", SqlDbType.Money, 50, "name");
这里要转换一下
Convert.ToDecimal --------------------编程问答-------------------- 字段的数据类型和参数的类型不一样 --------------------编程问答-------------------- money 的那个地方改过来了
运行是提示这个错误: --------------------编程问答-------------------- XP不发威,你当我是DOS啊!
忍不住笑了! --------------------编程问答-------------------- UserInfo表里还有一个id字段 设置成了标示,和这个id有关系吗? --------------------编程问答-------------------- insertCmd.Parameters.Add("@people", SqlDbType.NVarChar, 50, "people");
insertCmd.Parameters.Add("@pwd", SqlDbType.NVarChar, 50, "pwd");
insertCmd.Parameters.Add("@email", SqlDbType.NVarChar, 50, "email");
insertCmd.Parameters.Add("@name", SqlDbType.Money, 50, "name");
insertCmd.Parameters.Add("@address", SqlDbType.NVarChar, 100, "address");
insertCmd.Parameters.Add("@phone", SqlDbType.NVarChar, 50, "phone");
这里面的值检查一下``
补充:.NET技术 , C#