技巧百问(7):DataGrid和XML执行数据添加、更新、删除
主要就是通过读xml，填充DataSet，通过Table来修改数据。比较简单
xml好东西啊
1 <%@ Page Language="C#" Debug="true" ContentType="text/html" ResponseEncoding="gb2312" %>
2 <%@ Import Namespace="System" %>
3 <%@ Import Namespace="System.Data" %>
4 <%@ Import Namespace="System.Xml" %>
5 <%@ Import Namespace="System.Data.OleDb" %>
6 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
7 <script language="c#" runat="server">
8 public void Page_Load(object src,EventArgs e)
9 {
10 if(!IsPostBack)
11 {
12 LoadXML();
13 }
14 }
15 public void LoadXML()
16 {
17 DataSet objdata=new DataSet();
18 try
19 {
20 objdata.ReadXml(Server.MapPath("sample.xml"));
21 datagrid1.DataSource=objdata;
22 datagrid1.DataBind();
23 }
24 catch
25 {
26 CreatXML();
27 }
28 }
29 public void CreatXML()
30 {
31 DataSet objdata=new DataSet("root");
32 DataTable dt=new DataTable("record");
33 DataRow dr;
34
35 dt.Columns.Add(new DataColumn("aid"));
36 dt.Columns.Add(new DataColumn("name"));
37 dt.Columns.Add(new DataColumn("dept"));
38 dt.Columns.Add(new DataColumn("salary"));
39
40 dr=dt.NewRow();
41 dr[0]="1";
42 dr[1]="No Data";
43 dr[2]="No Data";
44 dr[3]="No Data";
45
46 dt.Rows.Add(dr);
47
48 objdata.Tables.Add(dt);
49
50 datagrid1.DataSource=objdata;
51 datagrid1.DataBind();
52
53 objdata.WriteXml(Server.MapPath("sample.xml"));
54
55 LoadXML();
56 }
57 public void EditXML(object sender,DataGridCommandEventArgs e)
58 {
59 DataSet objdata=new DataSet();
60 string x1;
61
62 objdata.ReadXml(Server.MapPath("sample.xml"));
63
64 x1=Convert.ToString(datagrid1.DataKeys[e.Item.ItemIndex]);
65
66 objdata.Tables["record"].DefaultView.RowFilter="aid='" + x1 + "'";
67
68 if(objdata.Tables["record"].DefaultView.Count>0)
69 {
70 error4.Visible=false;
71 datagrid1.EditItemIndex=e.Item.ItemIndex;
72 datagrid1.ShowFooter=false;
73 LoadXML();
74 }
75 else
76 error4.Visible=true;
77 }
78 public void CancelXML(object sender,DataGridCommandEventArgs e)
79 {
80 datagrid1.EditItemIndex=-1;
81 datagrid1.ShowFooter=true;
82 error1.Visible=false;
83 error2.Visible=false;
84 error3.Visible=false;
85 error4.Visible=false;
86 error5.Visible=false;
87
88 LoadXML();
89 }
90 public void DelXML(Object s, DataGridCommandEventArgs e)
91 {
92 if(e.CommandName=="Delete")
93 {
94 if(datagrid1.EditItemIndex==-1)
95 {
96 error5.Visible=false;
97 string x1;
98
99 x1=Convert.ToString(datagrid1.DataKeys[e.Item.ItemIndex]);
100
101 DataSet objdata=new DataSet();
102 try
103 {
104 objdata.ReadXml(Server.MapPath("sample.xml"));
105 objdata.Tables["record"].DefaultView.RowFilter="aid='" + x1 + "'";
106 if(objdata.Tables["record"].DefaultView.Count>0)
107 objdata.Tables["record"].DefaultView.Delete(0);
108
109 objdata.Tables["record"].DefaultView.RowFilter="";
110
111 objdata.WriteXml(Server.MapPath("sample.xml"));
112 }
113 catch
114 {
115 CreatXML();
116 }
117 LoadXML();
118 }
119 else
120 error5.Visible=true;
121 }
122 }
123 public void UpdateXML(Object s,DataGridCommandEventArgs e)
124 {
125 if(e.CommandName=="Update")
126 {
127 string str1, str2, str3;
128 int v1;
129 TextBox txt1,txt2,txt3;
130 DataSet objdata=new DataSet();
131 string x1;
132
133 objdata.ReadXml(Server.MapPath("sample.xml"));
134
135 v1=e.Item.ItemIndex;
136
137 x1=Convert.ToString(datagrid1.DataKeys[e.Item.ItemIndex]);
138
139 objdata.Tables["record"].DefaultView.RowFilter="aid='" + x1 + "'";
140
141 if(objdata.Tables["record"].DefaultView.Count>0)
142 {
143 error3.Visible=false;
144
145 /*txt1=e.Item.FindControl("name_edit");
146 txt2=e.Item.FindControl("dept_edit");
147 txt3=e.Item.FindControl("sal_edit");*/
148
149 DataRow myRow;
150
151 myRow=objdata.Tables["record"].Rows[v1];
152 myRow["name"]=((TextBox)e.Item.FindControl("name_edit")).Text;
153 myRow=objdata.Tables["record"].Rows[v1];
154 myRow["dept"]=((TextBox)e.Item.FindControl("dept_edit")).Text;
155 myRow=objdata.Tables["record"].Rows[v1];
156 myRow["salary"]=((TextBox)e.Item.FindControl("sal_edit")).Text;
157 datagrid1.DataSource=objdata;
158 datagrid1.DataBind();
159
160 objdata.WriteXml(Server.MapPath("sample.xml"));
161
162 datagrid1.EditItemIndex=-1;
163 LoadXML();
164 datagrid1.ShowFooter=true;
165 }
166 else
167 error3.Visible=true;
168 }
169 }
170 public void doInsert(Object s, DataGridCommandEventArgs e)
171 {
172 if(e.CommandName=="doAdd")
173 {
174 string v1;
175 int a;
176 TextBox tadd1,tadd2,tadd3,tadd4;
177 DataSet objdata=new DataSet();
178 DataRow dr;
179
180 objdata.ReadXml(Server.MapPath("sample.xml"));
181
182 tadd1=(TextBox)e.Item.FindControl("aid_add");
183 tadd2=(TextBox)e.Item.FindControl("name_add");
184 tadd3=(TextBox)e.Item.FindControl("dept_add");
185 tadd4=(TextBox)e.Item.FindControl("sal_add");
186
187 try
188 {
189 a=Convert.ToInt32(tadd1.Text);
190 tadd1.Text=Convert.ToString(a);
191 error2.Visible=false;
192
193 if(a<1)
194 {
195 tadd1.Text="";
196 error2.Visible=true;
197 }
198 }
199 catch
200 {
201 tadd1.Text="";
202 error2.Visible=true;
203 }
204
205 if(tadd1.Text!=""&&tadd2.Text!=""&&tadd3.Text!=""&&tadd4.Text!="")
206 {
207 objdata.Tables["record"].DefaultView.RowFilter="aid='" + tadd1.Text + "'";
208 if(objdata.Tables["record"].DefaultView.Count<=0)
209 {
210 error1.Visible=false;
211 objdata.Tables["record"].DefaultView.RowFilter="";
212 dr=objdata.Tables["record"].NewRow();
213
214 dr[0]=tadd1.Text;
215 dr[1]=tadd2.Text;
216 dr[2]=tadd3.Text;
217 dr[3]=tadd4.Text;
218 objdata.Tables["record"].Rows.Add(dr);
219
220 objdata.WriteXml(Server.MapPath("sample.xml"));
221 LoadXML();
222 }
223 else
224 {
225 error1.Visible=true;
226 error1.Text="Id must be unique";
227 }
228 }
229 }
230 }
231 private int lastVarValue;
232 public int showval(int a)
233 {
234 lastVarValue=a;
235 return a;
236 }
237 </script>
238 <html>
239 <head>
240 <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
241 <title></title>
242 </head>
243 <body>
244 <form runat="server">
245 <div align="center">
246 <br>
247 <h2>Working with XML in a Datagrid
248 </h2>
249 <asp:datagrid id="datagrid1" runat="server" Font-Size="8pt" Font-Name="verdana" Cellpadding="3" onUpdateCommand="UpdateXML" OnCancelCommand="CancelXML" onEditCommand="EditXML" AutoGenerateColumns="False" onDeleteCommand="DelXML" ShowFooter="True" DataKeyField="aid" onItemCommand="doInsert" BorderWidth="1px" BorderColor="#DEBA84" BackColor="#DEBA84" Font-Names="verdana" BorderStyle="None" CellSpacing="2">
250 <FooterStyle forecolor="#8C4510" backcolor="#F7DFB5"></FooterStyle>
251 <HeaderStyle font-size="8pt" font-names="Arial" font-bold="True" horizontalalign="Center" forecolor="White" backcolor="#A55129"></HeaderStyle>
252 <PagerStyle horizontalalign="Center" forecolor="#8C4510" mode="NumericPages"></PagerStyle>
253 <SelectedItemStyle font-bold="True" forecolor="White" backcolor="#738A9C"></SelectedItemStyle>
254 <ItemStyle forecolor="#8C4510" backcolor="#FFF7E7"></ItemStyle>
255 <Columns>
256 <asp:TemplateColumn HeaderText="Id">
257 <ItemTemplate>
258 <%# showval(Convert.ToInt32(DataBinder.Eval(Container.DataItem,"aid"))) %>
259 </ItemTemplate>
260 <FooterTemplate>
261 <asp:Textbox runat="server" id="aid_add" Text='<%# Convert.ToInt32(lastVarValue)+1 %>' Columns="2" />
262 </FooterTemplate>
263 <EditItemTemplate>
264 <%# DataBinder.Eval(Container.DataItem,"aid") %>
265 </EditItemTemplate>
266 </asp:TemplateColumn>
267 <asp:TemplateColumn HeaderText="Name">
268 <ItemTemplate>
269 <%# DataBinder.Eval(Container.DataItem,"name") %>
270 </ItemTemplate>
271 <FooterTemplate>
272 <asp:TextBox id="name_add" runat="server" Columns="20" />
273 </FooterTemplate>
274 <EditItemTemplate>
275 <asp:Textbox runat="server" Columns="20" id="name_edit" Text='<%# DataBinder.Eval(Container.DataItem,"name") %>' />
276 </EditItemTemplate>
277 </asp:TemplateColumn>
278 <asp:TemplateColumn HeaderText="Department">
279 <ItemTemplate>
280 <%# DataBinder.Eval(Container.DataItem,"dept") %>
281 </ItemTemplate>
282 <FooterTemplate>
283 <asp:TextBox id="dept_add" runat="server" Columns="10" />
284 </FooterTemplate>
285 <EditItemTemplate>
286 <asp:Textbox runat="server" Columns="15" id="dept_edit" Text='<%# DataBinder.Eval(Container.DataItem,"dept") %>' />
287 </EditItemTemplate>
288 </asp:TemplateColumn>
289 <asp:TemplateColumn HeaderText="Salary">
290 <ItemTemplate>
291 <%# DataBinder.Eval(Container.DataItem,"salary") %>
292 </ItemTemplate>
293 <FooterTemplate>
294 <asp:TextBox id="sal_add" runat="server" Columns="10" />
295 </FooterTemplate>
296 <EditItemTemplate>
297 <asp:Textbox runat="server" Columns="15" id="sal_edit" Text='<%# DataBinder.Eval(Container.DataItem,"salary") %>' />
298 </EditItemTemplate>
299 </asp:TemplateColumn>
300 <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" CancelText="Cancel" EditText="Edit" HeaderText="Edit"></asp:EditCommandColumn>
301 <asp:TemplateColumn HeaderText="Delete">
302 <ItemTemplate>
303 <asp:LinkButton runat="Server" Text="Delete" CommandName="Delete"/>
304 </ItemTemplate>
305 <FooterTemplate>
306 <asp:LinkButton Text="Add" Runat="Server" CommandName="doAdd" />
307 </FooterTemplate>
308 </asp:TemplateColumn>
309 </Columns>
310 </asp:datagrid>
311 </center>
312 <center><asp:Label id="error1" runat="server" Visible="False" font-names="Tahoma" bordercolor="#FFC080" font-size="Smaller" font-bold="True" forecolor="Red" tooltip="Id must be unique" backcolor="White" width="161px">Error!
313 Id must be unique</asp:Label>
314 </center>
315 <center><asp:Label id="error2" runat="server" Visible="False" font-names="Tahoma" bordercolor="#FFC080" font-size="Smaller" font-bold="True" forecolor="Red" tooltip="Id must be numeric within the range of 1 to 99999" backcolor="White" width="402px">Error!
316 Id must be numeric within the range of 1 to 9999</asp:Label>
317 </center>
318 <center><asp:Label id="error3" runat="server" Visible="False" font-names="Tahoma" bordercolor="#FFC080" font-size="Smaller" font-bold="True" forecolor="Red" tooltip="The Record you are updating has been deleted by another user!" backcolor="White" width="402px">Error! The Record you are updating has been deleted by another user!</asp:Label>
319 </center>
320 <center><asp:Label id="error4" runat="server" Visible="False" font-names="Tahoma" bordercolor="#FFC080" font-size="Smaller" font-bold="True" forecolor="Red" tooltip="The Record you are trying to Edit has been deleted by another user!" backcolor="White" width="402px">Error! The Record you are trying to Edit has been deleted by another user!</asp:Label>
321 </center>
322 <center><asp:Label id="error5" runat="server" Visible="False" font-names="Tahoma" bordercolor="#FFC080" font-size="Smaller" font-bold="True" forecolor="Red" tooltip="The Record cannot be deleted while in Edit Mode" backcolor="White" width="402px">Error! The Record cannot be deleted while in Edit Mode</asp:Label>
323 </center>
324 </div>
325 </form>
326 </body>
327 </html>
328
2 <%@ Import Namespace="System" %>
3 <%@ Import Namespace="System.Data" %>
4 <%@ Import Namespace="System.Xml" %>
5 <%@ Import Namespace="System.Data.OleDb" %>
6 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
7 <script language="c#" runat="server">
8 public void Page_Load(object src,EventArgs e)
9 {
10 if(!IsPostBack)
11 {
12 LoadXML();
13 }
14 }
15 public void LoadXML()
16 {
17 DataSet objdata=new DataSet();
18 try
19 {
20 objdata.ReadXml(Server.MapPath("sample.xml"));
21 datagrid1.DataSource=objdata;
22 datagrid1.DataBind();
23 }
24 catch
25 {
26 CreatXML();
27 }
28 }
29 public void CreatXML()
30 {
31 DataSet objdata=new DataSet("root");
32 DataTable dt=new DataTable("record");
33 DataRow dr;
34
35 dt.Columns.Add(new DataColumn("aid"));
36 dt.Columns.Add(new DataColumn("name"));
37 dt.Columns.Add(new DataColumn("dept"));
38 dt.Columns.Add(new DataColumn("salary"));
39
40 dr=dt.NewRow();
41 dr[0]="1";
42 dr[1]="No Data";
43 dr[2]="No Data";
44 dr[3]="No Data";
45
46 dt.Rows.Add(dr);
47
48 objdata.Tables.Add(dt);
49
50 datagrid1.DataSource=objdata;
51 datagrid1.DataBind();
52
53 objdata.WriteXml(Server.MapPath("sample.xml"));
54
55 LoadXML();
56 }
57 public void EditXML(object sender,DataGridCommandEventArgs e)
58 {
59 DataSet objdata=new DataSet();
60 string x1;
61
62 objdata.ReadXml(Server.MapPath("sample.xml"));
63
64 x1=Convert.ToString(datagrid1.DataKeys[e.Item.ItemIndex]);
65
66 objdata.Tables["record"].DefaultView.RowFilter="aid='" + x1 + "'";
67
68 if(objdata.Tables["record"].DefaultView.Count>0)
69 {
70 error4.Visible=false;
71 datagrid1.EditItemIndex=e.Item.ItemIndex;
72 datagrid1.ShowFooter=false;
73 LoadXML();
74 }
75 else
76 error4.Visible=true;
77 }
78 public void CancelXML(object sender,DataGridCommandEventArgs e)
79 {
80 datagrid1.EditItemIndex=-1;
81 datagrid1.ShowFooter=true;
82 error1.Visible=false;
83 error2.Visible=false;
84 error3.Visible=false;
85 error4.Visible=false;
86 error5.Visible=false;
87
88 LoadXML();
89 }
90 public void DelXML(Object s, DataGridCommandEventArgs e)
91 {
92 if(e.CommandName=="Delete")
93 {
94 if(datagrid1.EditItemIndex==-1)
95 {
96 error5.Visible=false;
97 string x1;
98
99 x1=Convert.ToString(datagrid1.DataKeys[e.Item.ItemIndex]);
100
101 DataSet objdata=new DataSet();
102 try
103 {
104 objdata.ReadXml(Server.MapPath("sample.xml"));
105 objdata.Tables["record"].DefaultView.RowFilter="aid='" + x1 + "'";
106 if(objdata.Tables["record"].DefaultView.Count>0)
107 objdata.Tables["record"].DefaultView.Delete(0);
108
109 objdata.Tables["record"].DefaultView.RowFilter="";
110
111 objdata.WriteXml(Server.MapPath("sample.xml"));
112 }
113 catch
114 {
115 CreatXML();
116 }
117 LoadXML();
118 }
119 else
120 error5.Visible=true;
121 }
122 }
123 public void UpdateXML(Object s,DataGridCommandEventArgs e)
124 {
125 if(e.CommandName=="Update")
126 {
127 string str1, str2, str3;
128 int v1;
129 TextBox txt1,txt2,txt3;
130 DataSet objdata=new DataSet();
131 string x1;
132
133 objdata.ReadXml(Server.MapPath("sample.xml"));
134
135 v1=e.Item.ItemIndex;
136
137 x1=Convert.ToString(datagrid1.DataKeys[e.Item.ItemIndex]);
138
139 objdata.Tables["record"].DefaultView.RowFilter="aid='" + x1 + "'";
140
141 if(objdata.Tables["record"].DefaultView.Count>0)
142 {
143 error3.Visible=false;
144
145 /*txt1=e.Item.FindControl("name_edit");
146 txt2=e.Item.FindControl("dept_edit");
147 txt3=e.Item.FindControl("sal_edit");*/
148
149 DataRow myRow;
150
151 myRow=objdata.Tables["record"].Rows[v1];
152 myRow["name"]=((TextBox)e.Item.FindControl("name_edit")).Text;
153 myRow=objdata.Tables["record"].Rows[v1];
154 myRow["dept"]=((TextBox)e.Item.FindControl("dept_edit")).Text;
155 myRow=objdata.Tables["record"].Rows[v1];
156 myRow["salary"]=((TextBox)e.Item.FindControl("sal_edit")).Text;
157 datagrid1.DataSource=objdata;
158 datagrid1.DataBind();
159
160 objdata.WriteXml(Server.MapPath("sample.xml"));
161
162 datagrid1.EditItemIndex=-1;
163 LoadXML();
164 datagrid1.ShowFooter=true;
165 }
166 else
167 error3.Visible=true;
168 }
169 }
170 public void doInsert(Object s, DataGridCommandEventArgs e)
171 {
172 if(e.CommandName=="doAdd")
173 {
174 string v1;
175 int a;
176 TextBox tadd1,tadd2,tadd3,tadd4;
177 DataSet objdata=new DataSet();
178 DataRow dr;
179
180 objdata.ReadXml(Server.MapPath("sample.xml"));
181
182 tadd1=(TextBox)e.Item.FindControl("aid_add");
183 tadd2=(TextBox)e.Item.FindControl("name_add");
184 tadd3=(TextBox)e.Item.FindControl("dept_add");
185 tadd4=(TextBox)e.Item.FindControl("sal_add");
186
187 try
188 {
189 a=Convert.ToInt32(tadd1.Text);
190 tadd1.Text=Convert.ToString(a);
191 error2.Visible=false;
192
193 if(a<1)
194 {
195 tadd1.Text="";
196 error2.Visible=true;
197 }
198 }
199 catch
200 {
201 tadd1.Text="";
202 error2.Visible=true;
203 }
204
205 if(tadd1.Text!=""&&tadd2.Text!=""&&tadd3.Text!=""&&tadd4.Text!="")
206 {
207 objdata.Tables["record"].DefaultView.RowFilter="aid='" + tadd1.Text + "'";
208 if(objdata.Tables["record"].DefaultView.Count<=0)
209 {
210 error1.Visible=false;
211 objdata.Tables["record"].DefaultView.RowFilter="";
212 dr=objdata.Tables["record"].NewRow();
213
214 dr[0]=tadd1.Text;
215 dr[1]=tadd2.Text;
216 dr[2]=tadd3.Text;
217 dr[3]=tadd4.Text;
218 objdata.Tables["record"].Rows.Add(dr);
219
220 objdata.WriteXml(Server.MapPath("sample.xml"));
221 LoadXML();
222 }
223 else
224 {
225 error1.Visible=true;
226 error1.Text="Id must be unique";
227 }
228 }
229 }
230 }
231 private int lastVarValue;
232 public int showval(int a)
233 {
234 lastVarValue=a;
235 return a;
236 }
237 </script>
238 <html>
239 <head>
240 <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
241 <title></title>
242 </head>
243 <body>
244 <form runat="server">
245 <div align="center">
246 <br>
247 <h2>Working with XML in a Datagrid
248 </h2>
249 <asp:datagrid id="datagrid1" runat="server" Font-Size="8pt" Font-Name="verdana" Cellpadding="3" onUpdateCommand="UpdateXML" OnCancelCommand="CancelXML" onEditCommand="EditXML" AutoGenerateColumns="False" onDeleteCommand="DelXML" ShowFooter="True" DataKeyField="aid" onItemCommand="doInsert" BorderWidth="1px" BorderColor="#DEBA84" BackColor="#DEBA84" Font-Names="verdana" BorderStyle="None" CellSpacing="2">
250 <FooterStyle forecolor="#8C4510" backcolor="#F7DFB5"></FooterStyle>
251 <HeaderStyle font-size="8pt" font-names="Arial" font-bold="True" horizontalalign="Center" forecolor="White" backcolor="#A55129"></HeaderStyle>
252 <PagerStyle horizontalalign="Center" forecolor="#8C4510" mode="NumericPages"></PagerStyle>
253 <SelectedItemStyle font-bold="True" forecolor="White" backcolor="#738A9C"></SelectedItemStyle>
254 <ItemStyle forecolor="#8C4510" backcolor="#FFF7E7"></ItemStyle>
255 <Columns>
256 <asp:TemplateColumn HeaderText="Id">
257 <ItemTemplate>
258 <%# showval(Convert.ToInt32(DataBinder.Eval(Container.DataItem,"aid"))) %>
259 </ItemTemplate>
260 <FooterTemplate>
261 <asp:Textbox runat="server" id="aid_add" Text='<%# Convert.ToInt32(lastVarValue)+1 %>' Columns="2" />
262 </FooterTemplate>
263 <EditItemTemplate>
264 <%# DataBinder.Eval(Container.DataItem,"aid") %>
265 </EditItemTemplate>
266 </asp:TemplateColumn>
267 <asp:TemplateColumn HeaderText="Name">
268 <ItemTemplate>
269 <%# DataBinder.Eval(Container.DataItem,"name") %>
270 </ItemTemplate>
271 <FooterTemplate>
272 <asp:TextBox id="name_add" runat="server" Columns="20" />
273 </FooterTemplate>
274 <EditItemTemplate>
275 <asp:Textbox runat="server" Columns="20" id="name_edit" Text='<%# DataBinder.Eval(Container.DataItem,"name") %>' />
276 </EditItemTemplate>
277 </asp:TemplateColumn>
278 <asp:TemplateColumn HeaderText="Department">
279 <ItemTemplate>
280 <%# DataBinder.Eval(Container.DataItem,"dept") %>
281 </ItemTemplate>
282 <FooterTemplate>
283 <asp:TextBox id="dept_add" runat="server" Columns="10" />
284 </FooterTemplate>
285 <EditItemTemplate>
286 <asp:Textbox runat="server" Columns="15" id="dept_edit" Text='<%# DataBinder.Eval(Container.DataItem,"dept") %>' />
287 </EditItemTemplate>
288 </asp:TemplateColumn>
289 <asp:TemplateColumn HeaderText="Salary">
290 <ItemTemplate>
291 <%# DataBinder.Eval(Container.DataItem,"salary") %>
292 </ItemTemplate>
293 <FooterTemplate>
294 <asp:TextBox id="sal_add" runat="server" Columns="10" />
295 </FooterTemplate>
296 <EditItemTemplate>
297 <asp:Textbox runat="server" Columns="15" id="sal_edit" Text='<%# DataBinder.Eval(Container.DataItem,"salary") %>' />
298 </EditItemTemplate>
299 </asp:TemplateColumn>
300 <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" CancelText="Cancel" EditText="Edit" HeaderText="Edit"></asp:EditCommandColumn>
301 <asp:TemplateColumn HeaderText="Delete">
302 <ItemTemplate>
303 <asp:LinkButton runat="Server" Text="Delete" CommandName="Delete"/>
304 </ItemTemplate>
305 <FooterTemplate>
306 <asp:LinkButton Text="Add" Runat="Server" CommandName="doAdd" />
307 </FooterTemplate>
308 </asp:TemplateColumn>
309 </Columns>
310 </asp:datagrid>
311 </center>
312 <center><asp:Label id="error1" runat="server" Visible="False" font-names="Tahoma" bordercolor="#FFC080" font-size="Smaller" font-bold="True" forecolor="Red" tooltip="Id must be unique" backcolor="White" width="161px">Error!
313 Id must be unique</asp:Label>
314 </center>
315 <center><asp:Label id="error2" runat="server" Visible="False" font-names="Tahoma" bordercolor="#FFC080" font-size="Smaller" font-bold="True" forecolor="Red" tooltip="Id must be numeric within the range of 1 to 99999" backcolor="White" width="402px">Error!
316 Id must be numeric within the range of 1 to 9999</asp:Label>
317 </center>
318 <center><asp:Label id="error3" runat="server" Visible="False" font-names="Tahoma" bordercolor="#FFC080" font-size="Smaller" font-bold="True" forecolor="Red" tooltip="The Record you are updating has been deleted by another user!" backcolor="White" width="402px">Error! The Record you are updating has been deleted by another user!</asp:Label>
319 </center>
320 <center><asp:Label id="error4" runat="server" Visible="False" font-names="Tahoma" bordercolor="#FFC080" font-size="Smaller" font-bold="True" forecolor="Red" tooltip="The Record you are trying to Edit has been deleted by another user!" backcolor="White" width="402px">Error! The Record you are trying to Edit has been deleted by another user!</asp:Label>
321 </center>
322 <center><asp:Label id="error5" runat="server" Visible="False" font-names="Tahoma" bordercolor="#FFC080" font-size="Smaller" font-bold="True" forecolor="Red" tooltip="The Record cannot be deleted while in Edit Mode" backcolor="White" width="402px">Error! The Record cannot be deleted while in Edit Mode</asp:Label>
323 </center>
324 </div>
325 </form>
326 </body>
327 </html>
328
xml好东西啊
