一:用数据集制作:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DataSet1TableAdapters;
using System.Data;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
UsersTableAdapter adapter = new UsersTableAdapter();
DataSet1.UsersDataTable table = new DataSet1.UsersDataTable();
adapter.Fill(table);
//table[0].name = "张小平"; //修改
//table[3].Delete(); //删除
//DataSet1.UsersRow row = table.NewUsersRow(); //增加
//row.uid = "004";
//row.name = "保定";
//row.password = "123";
//row.power = 2;
//row._lock = false;
//table.Rows.Add(row);
DataRow[] rows = table.Select("name='张三'"); //查找
Response.Write(rows[0]["uid"] + " | " + rows[0]["name"].ToString() + " | " + rows[0]["password"] + " | " + rows[0]["power"] + " | " + rows[0]["lock"]);
adapter.Update(table); //这句话必须有否则只能更新视图不能更新数据库
this.GridView1.DataSource = table;
this.GridView1.DataBind();
}
}
二:用DataSet做:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string str = ConfigurationManager.ConnectionStrings["sqlstring"].ConnectionString;
using (SqlConnection sqlcnn = new SqlConnection(str))
{
SqlCommand sqlcmm = sqlcnn.CreateCommand();
sqlcmm.CommandText = "select * from Users";
SqlDataAdapter adapter = new SqlDataAdapter(sqlcmm);
adapter.Fill(ds, "Users");
//ds.Tables["Users"].Rows[0].Delete(); //删除
//ds.Tables["Users"].Rows[1]["name"] = "李?四?"; //修改
//DataRow dr = ds.Tables[0].NewRow(); //增加
//dr["uid"] = 0007;
//dr["name"] = "赵?六ⅷ?;
//dr["password"] = 123;
//dr["power"]=0;
//dr["lock"] = false;
//ds.Tables[0].Rows.Add(dr);
//DataRow[] rows = ds.Tables[0].Select("name='张三'");
//查找
//Response.Write(rows[0]["name"].ToString()+rows[0]["password"]);
//DataRow []rows=t.Select("Dname='"+TextBox3 .Text .Trim ()+"'","id DESC");
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
adapter.Update(ds, "Users");//这句话必须有否则只能更新视图不能更新数据库
}
this.GridView1.DataSource = ds.Tables[0];
this.GridView1.DataBind();
}
}