Update 方法会将更改解析回数据源,但是自上次填充 DataSet 以来,其他客户端可能已修改了数据源中的数据。若要使用当前数据刷新 DataSet,请再次使用 DataAdapter 填充 (Fill) DataSet。
1
using System;
2
using System.Data;
3
using System.Data.SqlClient;
4![](/Images/OutliningIndicators/None.gif)
5
namespace DataSetAdapter
6
{
7
/**//// <summary>
8
/// Summary description for EntityAA.
9
/// </summary>
10
public class EntityAA
11
{
12
private string connstr = System.Configuration.ConfigurationSettings.AppSettings["connString"];
13
private SqlConnection conn;
14![](/Images/OutliningIndicators/InBlock.gif)
15
private string sql;
16![](/Images/OutliningIndicators/InBlock.gif)
17
private SqlDataAdapter adp;
18
private SqlCommandBuilder cb;
19![](/Images/OutliningIndicators/InBlock.gif)
20
private DataSet ds;
21
private DataTable dt;
22![](/Images/OutliningIndicators/InBlock.gif)
23
public EntityAA()
24
{
25
conn = new SqlConnection(connstr);
26
sql = "select * from aa";
27![](/Images/OutliningIndicators/InBlock.gif)
28
adp = new SqlDataAdapter(sql,conn);
29
cb = new SqlCommandBuilder(adp);
30![](/Images/OutliningIndicators/InBlock.gif)
31
ds = new DataSet();
32![](/Images/OutliningIndicators/InBlock.gif)
33
FillDataSet();
34![](/Images/OutliningIndicators/InBlock.gif)
35
dt = ds.Tables["table_aa"];
36![](/Images/OutliningIndicators/InBlock.gif)
37
dt.PrimaryKey = new DataColumn[]{dt.Columns["a"]};
38
}
39
40
private void FillDataSet()
41
{
42
conn.Open();
43
adp.Fill(ds,"table_aa");
44
conn.Close();
45
}
46![](/Images/OutliningIndicators/InBlock.gif)
47
public DataSet List
48
{
49
get {return ds;}
50
}
51![](/Images/OutliningIndicators/InBlock.gif)
52
public void insert(string c)
53
{
54
dt.Columns["a"].AutoIncrement = true;
55![](/Images/OutliningIndicators/InBlock.gif)
56
DataRow dr = dt.NewRow();
57
dr["c"] = c;
58
dt.Rows.Add(dr); //添加新行
59![](/Images/OutliningIndicators/InBlock.gif)
60
adp.Update(ds,"table_aa");
61![](/Images/OutliningIndicators/InBlock.gif)
62
}
63![](/Images/OutliningIndicators/InBlock.gif)
64
public void up_date(int ids,string name)
65
{
66
DataRow dr = dt.Rows.Find(ids); //获取由主键值指定的行
67
dr["c"] = name; //更新
68![](/Images/OutliningIndicators/InBlock.gif)
69
adp.Update(ds,"table_aa");
70
}
71![](/Images/OutliningIndicators/InBlock.gif)
72
public void del(int ids)
73
{
74
DataRow dr = dt.Rows.Find(ids); //获取由主键值指定的行
75
dr.Delete();
76![](/Images/OutliningIndicators/InBlock.gif)
77
adp.Update(ds,"table_aa");
78![](/Images/OutliningIndicators/InBlock.gif)
79
}
80![](/Images/OutliningIndicators/InBlock.gif)
81
}
82
}
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
7
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/InBlock.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/InBlock.gif)
24
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
25
![](/Images/OutliningIndicators/InBlock.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/InBlock.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/InBlock.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/InBlock.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/InBlock.gif)
36
![](/Images/OutliningIndicators/InBlock.gif)
37
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
38
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
39
![](/Images/OutliningIndicators/InBlock.gif)
40
![](/Images/OutliningIndicators/InBlock.gif)
41
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
42
![](/Images/OutliningIndicators/InBlock.gif)
43
![](/Images/OutliningIndicators/InBlock.gif)
44
![](/Images/OutliningIndicators/InBlock.gif)
45
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
46
![](/Images/OutliningIndicators/InBlock.gif)
47
![](/Images/OutliningIndicators/InBlock.gif)
48
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
49
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
50
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
51
![](/Images/OutliningIndicators/InBlock.gif)
52
![](/Images/OutliningIndicators/InBlock.gif)
53
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
54
![](/Images/OutliningIndicators/InBlock.gif)
55
![](/Images/OutliningIndicators/InBlock.gif)
56
![](/Images/OutliningIndicators/InBlock.gif)
57
![](/Images/OutliningIndicators/InBlock.gif)
58
![](/Images/OutliningIndicators/InBlock.gif)
59
![](/Images/OutliningIndicators/InBlock.gif)
60
![](/Images/OutliningIndicators/InBlock.gif)
61
![](/Images/OutliningIndicators/InBlock.gif)
62
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
63
![](/Images/OutliningIndicators/InBlock.gif)
64
![](/Images/OutliningIndicators/InBlock.gif)
65
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
66
![](/Images/OutliningIndicators/InBlock.gif)
67
![](/Images/OutliningIndicators/InBlock.gif)
68
![](/Images/OutliningIndicators/InBlock.gif)
69
![](/Images/OutliningIndicators/InBlock.gif)
70
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
71
![](/Images/OutliningIndicators/InBlock.gif)
72
![](/Images/OutliningIndicators/InBlock.gif)
73
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
74
![](/Images/OutliningIndicators/InBlock.gif)
75
![](/Images/OutliningIndicators/InBlock.gif)
76
![](/Images/OutliningIndicators/InBlock.gif)
77
![](/Images/OutliningIndicators/InBlock.gif)
78
![](/Images/OutliningIndicators/InBlock.gif)
79
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
80
![](/Images/OutliningIndicators/InBlock.gif)
81
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
82
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
1
using System;
2
using System.Collections;
3
using System.ComponentModel;
4
using System.Data;
5
using System.Drawing;
6
using System.Web;
7
using System.Web.SessionState;
8
using System.Web.UI;
9
using System.Web.UI.WebControls;
10
using System.Web.UI.HtmlControls;
11
using System.Data.SqlClient;
12![](/Images/OutliningIndicators/None.gif)
13
namespace DataSetAdapter
14
{
15
/**//// <summary>
16
/// Summary description for WebForm1.
17
/// </summary>
18
public class WebForm1 : System.Web.UI.Page
19
{
20
protected System.Web.UI.WebControls.Label Label1;
21
protected System.Web.UI.WebControls.Label Label2;
22
protected System.Web.UI.WebControls.TextBox txt_a;
23
protected System.Web.UI.WebControls.TextBox txt_c;
24
protected System.Web.UI.WebControls.Button delete;
25
protected System.Web.UI.WebControls.Button Button2;
26
protected System.Web.UI.WebControls.DataGrid DataGrid1;
27
protected System.Web.UI.WebControls.Button Button1;
28
29
private void Page_Load(object sender, System.EventArgs e)
30
{
31
if(!this.Page.IsPostBack)
32
BindGrid();
33
}
34![](/Images/OutliningIndicators/InBlock.gif)
35
Web Form Designer generated codeWeb Form Designer generated code
58![](/Images/OutliningIndicators/InBlock.gif)
59
private void BindGrid()
60
{
61
EntityAA entityaa = new EntityAA();
62
DataSet ds = entityaa.List;
63![](/Images/OutliningIndicators/InBlock.gif)
64
this.DataGrid1.DataSource = ds;
65
this.DataGrid1.DataBind();
66
}
67
private void Button1_Click(object sender, System.EventArgs e)
68
{
69
int ids = Int32.Parse(this.txt_a.Text);
70
string name = this.txt_c.Text;
71![](/Images/OutliningIndicators/InBlock.gif)
72
EntityAA entityaa = new EntityAA();
73
entityaa.up_date(ids,name);
74![](/Images/OutliningIndicators/InBlock.gif)
75
BindGrid();
76
}
77
private void delete_Click(object sender, System.EventArgs e)
78
{
79
int ids = Int32.Parse(this.txt_a.Text);
80![](/Images/OutliningIndicators/InBlock.gif)
81
EntityAA entityaa = new EntityAA();
82
entityaa.del(ids);
83![](/Images/OutliningIndicators/InBlock.gif)
84
BindGrid();
85
}
86![](/Images/OutliningIndicators/InBlock.gif)
87
private void Button2_Click(object sender, System.EventArgs e)
88
{
89
string c = this.txt_c.Text;
90
91
EntityAA entityaa = new EntityAA();
92
entityaa.insert(c);
93![](/Images/OutliningIndicators/InBlock.gif)
94
BindGrid();
95
}
96![](/Images/OutliningIndicators/InBlock.gif)
97
}
98
}
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/None.gif)
14
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
15
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/InBlock.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/InBlock.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/InBlock.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/InBlock.gif)
30
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
31
![](/Images/OutliningIndicators/InBlock.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
58
![](/Images/OutliningIndicators/InBlock.gif)
59
![](/Images/OutliningIndicators/InBlock.gif)
60
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
61
![](/Images/OutliningIndicators/InBlock.gif)
62
![](/Images/OutliningIndicators/InBlock.gif)
63
![](/Images/OutliningIndicators/InBlock.gif)
64
![](/Images/OutliningIndicators/InBlock.gif)
65
![](/Images/OutliningIndicators/InBlock.gif)
66
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
67
![](/Images/OutliningIndicators/InBlock.gif)
68
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
69
![](/Images/OutliningIndicators/InBlock.gif)
70
![](/Images/OutliningIndicators/InBlock.gif)
71
![](/Images/OutliningIndicators/InBlock.gif)
72
![](/Images/OutliningIndicators/InBlock.gif)
73
![](/Images/OutliningIndicators/InBlock.gif)
74
![](/Images/OutliningIndicators/InBlock.gif)
75
![](/Images/OutliningIndicators/InBlock.gif)
76
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
77
![](/Images/OutliningIndicators/InBlock.gif)
78
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
79
![](/Images/OutliningIndicators/InBlock.gif)
80
![](/Images/OutliningIndicators/InBlock.gif)
81
![](/Images/OutliningIndicators/InBlock.gif)
82
![](/Images/OutliningIndicators/InBlock.gif)
83
![](/Images/OutliningIndicators/InBlock.gif)
84
![](/Images/OutliningIndicators/InBlock.gif)
85
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
86
![](/Images/OutliningIndicators/InBlock.gif)
87
![](/Images/OutliningIndicators/InBlock.gif)
88
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
89
![](/Images/OutliningIndicators/InBlock.gif)
90
![](/Images/OutliningIndicators/InBlock.gif)
91
![](/Images/OutliningIndicators/InBlock.gif)
92
![](/Images/OutliningIndicators/InBlock.gif)
93
![](/Images/OutliningIndicators/InBlock.gif)
94
![](/Images/OutliningIndicators/InBlock.gif)
95
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
96
![](/Images/OutliningIndicators/InBlock.gif)
97
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
98
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)