17,740
社区成员
发帖
与我相关
我的任务
分享
string sql="INSERT INTO [contacts] (name,email,gender,phone,QQ,address) VALUES (@name,@email,@gender,@phone,@QQ,@address)";
string data=Application["ConnectionString"].ToString();
SqlConnection conn=new SqlConnection(data);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add("@name",SqlDbType.NVarChar);
cmd.Parameters["@name"].Value=this.xingming.Text.Trim();
cmd.Parameters.Add("@email",SqlDbType.NVarChar);
cmd.Parameters["@email"].Value=this.youxiang.Text.Trim();
cmd.Parameters.Add("@gender",SqlDbType.NVarChar);
cmd.Parameters["@gender"].Value=this.xingbie.SelectedValue.Trim();
cmd.Parameters.Add("@phone",SqlDbType.NVarChar);
cmd.Parameters["@phone"].Value=this.dianhua.Text.Trim();
cmd.Parameters.Add("@QQ",SqlDbType.NVarChar);
cmd.Parameters["@QQ"].Value=this.qq.Text.Trim();
cmd.Parameters.Add("@address",SqlDbType.NVarChar);
cmd.Parameters["@address"].Value=this.zhuzhi.Text.Trim();
cmd.CommandText=sql;
cmd.Connection=conn;
try
{
cmd.ExecuteReader();
Response.Write("<script language='javascript'>alert('保存成功!');location.href='WebForm1.aspx'</script>");
}
catch(System.Exception ex)
{
Response.Write("<script language='javascript'>alert(\"保存失败!\\r\\n["+ex.Message.Replace("\r","\\r").Replace("\n","\\n")+"]\");history.go(-1);</script>");
}
finally
{
cmd.Dispose();
conn.Close();
}
Application("ConnectionString") ="Password=;Persist Security Info=True;User ID=sa;Initial Catalog=XCH;Data Source=tongxun";
string data=Application["ConnectionString"].ToString();
SqlConnection conn=new SqlConnection(data);
conn.Open();
SqlConnection conn= new SqlConnection(Application["ConnectionString"].ToString());
这样写还是不对啊SqlConnection comm=new Application["ConnectionString"];