62,046
社区成员
发帖
与我相关
我的任务
分享
string connString = @"Data Source=USER-20160821CN\BOTA227;Initial Catalog=zaihai;User ID=bota;Password=877460873";
string sql = "insert into denglu(用户名,密码) values(@name,@password) ";
string name = textBox1.Text;//姓名
string password = textBox2.Text;//密码
SqlParameter[] spArr = new SqlParameter[]{
new SqlParameter("@name", name),
new SqlParameter("@password", password)
};
try
{
using (SqlConnection connection = new SqlConnection(connString))
{
connection.Open();
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.AddRange(spArr);
cmd.ExecuteNonQuery();
}
MessageBox.Show("插入数据库成功");
}
catch (Exception ex)
{
MessageBox.Show("插入失败,原因:"+ex.Message);
}