- public static bool insertPerson(Person p)
- {
- try
- {
- SqlConnection con = DBCon.createConnection();
- con.Open();
- SqlCommand cmd = new SqlCommand("insert into person values=(@pId,@pName,@pSex)",con);
- SqlParameter para = new SqlParameter("@pId", SqlDbType.VarChar, 10);
- para.Value = p.pId;
- cmd.Parameters.Add(para);
- para = new SqlParameter("@pName", SqlDbType.VarChar, 20);
- para.Value = p.pName;
- cmd.Parameters.Add(para);
- para = new SqlParameter("@pSex", SqlDbType.VarChar, 2);
- para.Value = p.pSex;
- cmd.Parameters.Add(para);
- cmd.ExecuteNonQuery();
- con.Close();
- return true;
- }
- catch (Exception e)
- {
- return false;
- }
- }
- con.Open();
- //SqlCommand cmd = new SqlCommand();
- cmd.CommandText = "insert into person values('" + record[0] + "','" + record[1] + "','" + record[2] + "')";
- cmd.Connection = con;
- cmd.ExecuteNonQuery();
- con.Close();
- protected void CustomValidator2_ServerValidate(object source, ServerValidateEventArgs args)
- {
- string personId = args.Value;
- SqlConnection con = DBConnection.createConnection();
- con.Open();
- SqlCommand cmd = new SqlCommand();
- cmd.CommandText = "select count(*) from person where personId='" + personId + "'";
- cmd.Connection = con;
- int count = Convert.ToInt32(cmd.ExecuteScalar());
- if (count > 0)
- {
- args.IsValid = false;
- }
- else
- {
- args.IsValid = true;
- }
- con.Close();
- }
ASP.NET数据库操作实例
最新推荐文章于 2021-01-26 16:18:25 发布