using System.Data.SqlClientSqlConnection cn = new SqlConnection("server=localhost;database=db1;uid=sa;pwd=;");
cn.Open();
string s = " insert into table(字段) values('"+ 变量 + "') ";
SqlCommand cmd = new SqlCommand(s,cn);
try
{
cmd.ExecuteNonQuery();
}
catch
{
Response.Write("系统有错");
}
cn.Open();
string s = " insert into table(字段) values('"+ 变量 + "') ";
SqlCommand cmd = new SqlCommand(s,cn);
try
{
cmd.ExecuteNonQuery();
}
catch
{
Response.Write("系统有错");
}
可是如果是更新一条记录而不是增加,不知道怎么用adapter写.
后面添加:
SqlCommandBuilder ken_cb = new SqlCommandBuilder(dzs_kenAdap);
就可以了,如果是更改已有数据:
myRow=ds.Tables["ken_logon"].NewRow();
改为:
myRow=ds.Tables["ken_logon"]
省略:
ds.Tables["ken_logon"].Rows.Add(myRow);
就可以了