Question

求asp的增删改查完整代码。本人为新手，数据库是sql的。谢啦~！两个字段就可以。

我邮箱fir_3@126.com 谢啦

Answer 1

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;
using System.Data;
using System.Data.SqlClient;

namespace asp.net
{
public partial class _Default : System.Web.UI.Page
{
//连接数据库文件
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename='i:\我的文档\My Documents\Visual Studio 2008\Projects\asp.net课程作业\asp.net课程作业\App_Data\User.mdf';Integrated Security=True;User Instance=True");

protected void Page_Load(object sender, EventArgs e)
{

}
//从数据库中查询用户数据函数
public void CheckUser()
{

SqlCommand cmd =new SqlCommand("select * from [User] where ID=2008");
cmd.Connection = conn;
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
TextBox1.Text = sdr["ID"].ToString();
TextBox2.Text = sdr["name"].ToString();
TextBox3.Text = sdr["age"].ToString();
}
sdr.Close();
}

protected void Button1_Click(object sender, EventArgs e)
{
CheckUser();
conn.Close();
}

protected void Button2_Click(object sender, EventArgs e)
{
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
}
}
}

Answer 2

增加：INSERT INTO 表名 (列1, 列2) VALUES (值1, 值2)
删除：DELETE 表名 where 条件
修改：Update 表名 set 列1=值1,列2=值2 where 条件