日期:2014-05-16 浏览次数:21027 次
写入本地数据库,应该怎么做,急求各位大神指导,在这个代码基础上增加吧
string name = name.Text;
string pwd = pwd.Text;
string sql = "insert into table1(Name,Password) Values ('"+name+"','"+pwd+"')";
string strsql = ConfigurationManager.ConnectionStrings["testConnectionString"].ToString();//testConnectionString为你的数据库连接字符串在config文件里面配置
SqlConnection con = new SqlConnection(strsql);
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, con);
da.Fill(ds);
int n = ds.Tables[0].Rows.Count;
if (n > 0)
{
Response.Write("<script>alert('成功!')</script>");
}
else
{
Response.Write("<script>alert('失败!')</script>");
}