我在页面上面的信息添加到数据库中,一直不行,请高手帮我看看哪里出错了。
谢谢!~类:
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;/// <summary>
///addperson 的摘要说明
/// </summary>
public class addperson
{
public string kb;
public string jz;
public string gh;
public string xm;
public string jb;
public string zw;
public string rsr;
public string xb;
public string csnyr;
public string lb;
public string gw;
public string gwm;
public string ssbz;
public string sszz;
public string jcfl;
public string jcqk;
public string cq;
public string cqtbsm;
public string lzks;
public string lzjs;
public string rybc;
public string bh;
public string dlrq;
public addperson()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
}
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Data;
/// <summary>
///addpersonOperate 的摘要说明
/// </summary>
public class addpersonOperate
{
public addpersonOperate()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
public static SqlConnection createCon()
{
return new SqlConnection("server=etta;database=addperson;uid=sa;pwd=sa;"); }
public static bool findPerson(string gh)
{
SqlConnection con = addpersonOperate.createCon();
con.Open(); SqlCommand cmd = new SqlCommand("select count(*) from personlist where gh='" + gh + "'", con); int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
return true;
}
else
{
return false;
}
} public static bool insertOperate(addperson p)
{
try
{
SqlConnection con = addpersonOperate.createCon();
con.Open();
SqlCommand cmd = new SqlCommand("insert into personlist values(@gh)", con);
SqlParameter para = new SqlParameter("@gh", SqlDbType.VarChar, 20);
para.Value = p.gh;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
return false;
}
}
}页面的代码
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;public partial class main_addperson : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
addperson p = new addperson();
p.gh = this.addGh.Text;
if (addpersonOperate.insertOperate(p))
{
Response.Write("添加成功");
// Response.Write("<script> alert('添加成功') </script>");
}
else
{
Response.Write("添加失败");
// Response.Write("<script> alert('添加失败') </script>");
}
} protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
string gh = args.Value; if (addpersonOperate.findPerson(gh))
{ args.IsValid = false;
}
else
{
args.IsValid = true;
} }
}
谢谢!~类:
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;/// <summary>
///addperson 的摘要说明
/// </summary>
public class addperson
{
public string kb;
public string jz;
public string gh;
public string xm;
public string jb;
public string zw;
public string rsr;
public string xb;
public string csnyr;
public string lb;
public string gw;
public string gwm;
public string ssbz;
public string sszz;
public string jcfl;
public string jcqk;
public string cq;
public string cqtbsm;
public string lzks;
public string lzjs;
public string rybc;
public string bh;
public string dlrq;
public addperson()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
}
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Data;
/// <summary>
///addpersonOperate 的摘要说明
/// </summary>
public class addpersonOperate
{
public addpersonOperate()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
public static SqlConnection createCon()
{
return new SqlConnection("server=etta;database=addperson;uid=sa;pwd=sa;"); }
public static bool findPerson(string gh)
{
SqlConnection con = addpersonOperate.createCon();
con.Open(); SqlCommand cmd = new SqlCommand("select count(*) from personlist where gh='" + gh + "'", con); int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
return true;
}
else
{
return false;
}
} public static bool insertOperate(addperson p)
{
try
{
SqlConnection con = addpersonOperate.createCon();
con.Open();
SqlCommand cmd = new SqlCommand("insert into personlist values(@gh)", con);
SqlParameter para = new SqlParameter("@gh", SqlDbType.VarChar, 20);
para.Value = p.gh;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
return false;
}
}
}页面的代码
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;public partial class main_addperson : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
addperson p = new addperson();
p.gh = this.addGh.Text;
if (addpersonOperate.insertOperate(p))
{
Response.Write("添加成功");
// Response.Write("<script> alert('添加成功') </script>");
}
else
{
Response.Write("添加失败");
// Response.Write("<script> alert('添加失败') </script>");
}
} protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
string gh = args.Value; if (addpersonOperate.findPerson(gh))
{ args.IsValid = false;
}
else
{
args.IsValid = true;
} }
}
解决方案 »
- asp.net中DataKeysName必须绑定string 类型的吗?
- 大家好,想请教一下关于msdn webcast学习资源的问题
- .net c#中如何像asp一样自由调用和定义函数
- 新浪的博客地址http://blog.sina.com.cn/u/1214132890是什么技术?
- C#如何实现网址编码?
- 高分求:ASP.NET中间件问题
- crystal report使用总结。
- 设置aspx网页背景图象时,怎么不能用虚拟目录下的jpg文件?
- 又来送分来了
- 關于對DataList ItemTemplate數據綁定后本地化的問題?(孟子E章,思歸請进)
- GRIDVIEW中负数用红色显示
- 请问asp.net是怎么实现跳转的?
{
try
{
SqlConnection con = addpersonOperate.createCon();
con.Open();
SqlCommand cmd = new SqlCommand("insert into personlist values(@gh)", con);
SqlParameter para = new SqlParameter("@gh", SqlDbType.VarChar, 20);
para.Value = p.gh;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception e)
{
return false;
}
}
}这个不是插入吗?
personlist只有一个字段吗? 如果不是则要指定字段.
insert into personlist(name) values(@gh)
这个有问题指定一个字段的 values=@gh, 否则系统不知道你这里是干什么