SqlConnection Conn = new SqlConnection("server=202.121.241.116;database=064833486;uid=064833486;pwd=251858");
string sql = "insert into member (username,[password],sex,email,birthday,city,hobby) values('" + Label3.Text + "','" + pwd.Text + "','" + sex4.Text + "','" + mail4.Text + "','" + birth4.Text + "','" + native4.Text + "','" + hobby4.Text + "')";
SqlDataAdapter Comm = new SqlDataAdapter(sql, Conn);
DataSet ds = new DataSet();
Comm.Fill(ds, "Member");连接数据库应该没有问题,就是这句SQL语句可能不对,数据插入不进去,还提示出错,又不知道什么错,请大家帮忙啊~~~
string sql = "insert into member (username,[password],sex,email,birthday,city,hobby) values('" + Label3.Text + "','" + pwd.Text + "','" + sex4.Text + "','" + mail4.Text + "','" + birth4.Text + "','" + native4.Text + "','" + hobby4.Text + "')";
SqlDataAdapter Comm = new SqlDataAdapter(sql, Conn);
DataSet ds = new DataSet();
Comm.Fill(ds, "Member");连接数据库应该没有问题,就是这句SQL语句可能不对,数据插入不进去,还提示出错,又不知道什么错,请大家帮忙啊~~~
Insert插入,你直接ExecuteNoQuery就可以了SqlConnection Conn = new SqlConnection("server=202.121.241.116;database=064833486;uid=064833486;pwd=251858");
string sql = "insert into member (username,[password],sex,email,birthday,city,hobby) values('" + Label3.Text + "','" + pwd.Text + "','" + sex4.Text + "','" + mail4.Text + "','" + birth4.Text + "','" + native4.Text + "','" + hobby4.Text + "')";
conn.Open();
SqlCommand Comm=conn.CreateCommand();
Comm.CommandText=sql;
comm.ExecuteNoQuery();
conn.Close();
SqlCommand Comm=conn.CreateCommand();
Comm.CommandText=sql;
comm.ExecuteNoQuery();//插入,更新,删除
或者
SqlDataReader reader=comm.ExecuteReader() //查询,返回查询结果
离线模式
SqlDataAdapter Comm = new SqlDataAdapter(sql, Conn);
DataSet ds = new DataSet();
Comm.Fill(ds, "Member");
//把读取的结果放入DataSet里,在内存里操作