请大家帮忙看看,谢谢了。
string constr = @"Data Source=.\sqlexpress;Initial Catalog=student1;Integrated Security=True";
SqlConnection con = null;
con = new SqlConnection();
con.ConnectionString = constr;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "insert into 宾馆用户信息1(账号,密码,姓名,性别,身份证号,家庭住址,联系方式) VALUES('czt123','123','hzj','nv','510222','hanguo','11118')";
con.Open();
cmd.ExecuteNonQuery();
cmd.CommandText = "select * from 宾馆用户信息1";
SqlDataReader reader = cmd.ExecuteReader();
con.Close();
string constr = @"Data Source=.\sqlexpress;Initial Catalog=student1;Integrated Security=True";
SqlConnection con = null;
con = new SqlConnection();
con.ConnectionString = constr;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "insert into 宾馆用户信息1(账号,密码,姓名,性别,身份证号,家庭住址,联系方式) VALUES('czt123','123','hzj','nv','510222','hanguo','11118')";
con.Open();
cmd.ExecuteNonQuery();
cmd.CommandText = "select * from 宾馆用户信息1";
SqlDataReader reader = cmd.ExecuteReader();
con.Close();
=》cmd.CommandText = "insert into 宾馆用户信息1 (账号,密码,姓名,性别,身份证号,家庭住址,联系方式) VALUES('czt123','123','hzj','nv','510222','hanguo','11118')";
cmd.CommandText = "insert into 宾馆用户信息1(账号,密码,姓名,性别,身份证号,家庭住址,联系方式) VALUES('czt123','123','hzj','nv','510222','hanguo','11118')";
SqlConnection con = null;
con = new SqlConnection();
con.ConnectionString = constr;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "insert into 宾馆用户信息1(账号,密码,姓名,性别,身份证号,家庭住址,联系方式) VALUES('czt123','123','hzj','nv','510222','hanguo','11118')";
con.Open();
cmd.ExecuteNonQuery();
string strSQL = "select * from 宾馆用户信息1";
SqlDataAdapter adapter = new SqlDataAdapter(strSQL,con);
DataSet ds = new DataSet();
adapter.Fill(ds);
con.Close();
SqlConnection con = null;
con = new SqlConnection();
con.ConnectionString = constr;
con.Open();
string SQL="select * from 宾馆用户信息1";
SqlDataAdapter da = new SqlDataAdapter(SQL,constr);
DataSet ds = new DataSet();
da.Fill(ds, "宾馆用户信息1");
DataRow row = ds.Tables["宾馆用户信息1"].NewRow();
row["账号"] = "123";
row["密码"] = "321";
ds.Tables["宾馆用户信息1"].Rows.Add(row);写不进去,没报错