asp.net中gridview的绑定数据源实现增删改查

上善若水

gridview还是比较灵活的，有一种类似于excel的用法，可以直接在表格中进行添加，修改等操作。单元格数据比较段的表格用起来很方便。

可以参考https://blog.csdn.net/yingzhaom/article/details/50614599

我在这基础上改成了点击按钮弹出模态框进行操作。如有此类需求可以参考我的代码。

先从绑定数据源开始。

页面加载时绑定数据(可以把数据库连接封装，后面会多次使用)：

1. //数据库连接
2. SqlConnection sqlcon;
3. SqlCommand sqlcom;
4. string strCon = "Data Source=(local);Database=数据库名;Uid=帐号;Pwd=密码";
5. protected void Page_Load(object sender, EventArgs e)
6. {
8. if (!IsPostBack)
9. {
10. //初始化table
11. bind_gv();
12. }
13. }
14. protected void bind_gv()
15. {
16. string sqlstr = "select * from 表";
17. sqlcon = new SqlConnection(strCon);
18. SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
19. DataSet myds = new DataSet();
20. sqlcon.Open();
21. myda.Fill(myds, "表");
22. gvTag.DataSource = myds;
23. gvTag.DataKeyNames = new string[] { "tid" };
24. gvTag.DataBind();
25. sqlcon.Close();
26. }

复制代码

前端代码（表中列的dataField与查询的列名对应）：

1. <asp:GridView ID="gvTag" runat="server" AutoGenerateColumns="False" AllowSorting="True" CssClass="table table-striped" AllowPaging="True" OnPageIndexChanging="gvTag_PageIndexChanging" OnDataBound="gvTag_DataBound" PageSize="10" >
2. <Columns>
3. <asp:BoundField DataField="TID" HeaderText="Tag序号" ReadOnly="true" Visible="False" />
4. <asp:BoundField DataField="GROUPCODE" HeaderText="Group" ReadOnly="true" ItemStyle-Width="70" />
5. <asp:BoundField DataField="ELEMENTCODE" HeaderText="Element" ReadOnly="true" ItemStyle-Width="70" />
6. <asp:BoundField DataField="TAGNAME" HeaderText="TagName" ReadOnly="true" ItemStyle-Width="260" />
7. <asp:BoundField DataField="VID" HeaderText="VR序号" ReadOnly="true" Visible="False" />
8. <asp:BoundField DataField="VRCode" HeaderText="VR" ReadOnly="true" ItemStyle-Width="50" />
9. <asp:BoundField DataField="NOTES" HeaderText="描述" ReadOnly="true" />
10. <asp:TemplateField HeaderText="操作" ItemStyle-Width="80" >
11. <ItemTemplate>
13. <asp:LinkButton ID="Modify" runat="server" CausesValidation="False" CommandArgument='<%# Eval("tid") %>' OnClick="Modify_Click" Text="编辑"></asp:LinkButton>
14. <asp:LinkButton ID="Delete" runat="server" CausesValidation="False" CommandArgument='<%# Eval("tid") %>' OnClientClick="javascript:return confirm('确认要删除吗？')" AlternateText="删除此条目" OnCommand="Delete_Click" Text="删除"></asp:LinkButton>
15. </ItemTemplate>
17. </asp:TemplateField>
18. </Columns>
19. <PagerSettings Mode = "NextPreviousFirstLast" FirstPageText = "第一页" LastPageText = "末页" />
20. <PagerTemplate>
21. <table width="100%">
22. <tr>
23. <td width="75%">
24. <asp:ImageButton ID="imgBtnFirst" runat="server" CommandArgument="First" CommandName="Page"
25. ImageUrl="~/Images/First.png" ToolTip="第一页" />
26. <asp:ImageButton ID="imgBtnPrev" runat="server" CommandArgument="Prev" CommandName="Page"
27. ImageUrl="~/Images/Previous.png" ToolTip="上一页" />
28. <asp:ImageButton ID="imgBtnNext" runat="server" CommandArgument="Next" CommandName="Page"
29. ImageUrl="~/Images/Next.png" ToolTip="下一页" />
30. <asp:ImageButton ID="imgBtnLast" runat="server" CommandArgument="Last" CommandName="Page"
31. ImageUrl="~/Images/Last.png" ToolTip="最后页" />
32. </td>
33. <td align="right" width="25%">
34. 页数：<asp:Label ID="lblCurrentPage" runat="server"></asp:Label>
35. </td>
36. </tr>
37. </table>
38. </PagerTemplate>
39. </asp:GridView>

复制代码

分页后台代码：

1. protected void gvTag_PageIndexChanging(object sender, System.Web.UI.WebControls.GridViewPageEventArgs e)
2. {
3. gvTag.PageIndex = e.NewPageIndex;
4. bind_gv();
5. }
7. protected void gvTag_DataBound(object sender, EventArgs e)
8. {
9. // 取得显示页数的那一列。
10. GridViewRow pagerRow = gvTag.BottomPagerRow;
11. if (pagerRow != null)
12. {
13. // 取得显示目前所在页数的 Label 控件。
14. Label pageLabel = (Label)(pagerRow.Cells[0].FindControl("lblCurrentPage"));
16. // 取得 第一页、上一页、下一页、最后页 的按钮。
17. ImageButton imgBtnFirst =
18. (ImageButton)(pagerRow.Cells[0].FindControl("imgBtnFirst"));
19. ImageButton imgBtnPrev =
20. (ImageButton)(pagerRow.Cells[0].FindControl("imgBtnPrev"));
21. ImageButton imgBtnNext =
22. (ImageButton)(pagerRow.Cells[0].FindControl("imgBtnNext"));
23. ImageButton imgBtnLast =
24. (ImageButton)(pagerRow.Cells[0].FindControl("imgBtnLast"));
26. // 设定何时应该显示 第一页、上一页、下一页、最后页 的按钮。
27. if (gvTag.PageIndex == 0)
28. {
29. imgBtnFirst.Style.Add(HtmlTextWriterStyle.Visibility, "hidden");
30. imgBtnPrev.Style.Add(HtmlTextWriterStyle.Visibility, "hidden");
31. }
32. else if (gvTag.PageIndex == gvTag.PageCount - 1)
33. {
34. imgBtnLast.Style.Add(HtmlTextWriterStyle.Visibility, "hidden");
35. imgBtnNext.Style.Add(HtmlTextWriterStyle.Visibility, "hidden");
36. }
37. else if (gvTag.PageCount <= 0)
38. {
39. imgBtnFirst.Style.Add(HtmlTextWriterStyle.Visibility, "hidden");
40. imgBtnPrev.Style.Add(HtmlTextWriterStyle.Visibility, "hidden");
41. imgBtnNext.Style.Add(HtmlTextWriterStyle.Visibility, "hidden");
42. imgBtnLast.Style.Add(HtmlTextWriterStyle.Visibility, "hidden");
43. }
45. if (pageLabel != null)
46. {
47. // 计算目前所在的页数。
48. int currentPage = gvTag.PageIndex + 1;
50. pageLabel.Text = currentPage.ToString() +
51. " / " + gvTag.PageCount.ToString();
52. }
53. }
54. }

复制代码

前台弹框代码：

1. <!--编辑-->
2. <div class="modal fade" id="editModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel">
3. <div class="modal-dialog" role="document">
4. <div class="modal-content">
5. <div class="modal-header">
6. <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
7. <h4 class="modal-title" id="exampleModalLabel">编辑</h4>
8. </div>
9. <div class="modal-body">
10. <asp:TextBox type="text" ID="TidEdit" runat="server" Visible="False"></asp:TextBox>
11. <div class="form-group">
12. <label for="TagEdit" class="control-label">Tag:</label>
13. <asp:TextBox type="text" class="form-control" ID="TagEdit" runat="server" ReadOnly="True"></asp:TextBox>
15. </div>
16. <div class="form-group">
17. <label for="TagNameEdit" class="control-label">TagName:</label>
18. <asp:TextBox type="text" class="form-control" ID="TagNameEdit" runat="server"></asp:TextBox>
19. </div>
20. <div class="form-group">
21. <label for="NotesEdit" class="control-label">描述:</label>
22. <asp:TextBox type="text" class="form-control" ID="NotesEdit" runat="server" TextMode="MultiLine" Height="80px"></asp:TextBox>
23. </div>
24. <div class="form-group">
25. <label for="ddlVREdit" class="control-label">VR:</label>
26. <asp:DropDownList ID="ddlVREdit" runat="server" Height="34px"></asp:DropDownList>
27. </div>
28. </div>
29. <div class="modal-footer">
30. <button type="button" class="btn btn-default" data-dismiss="modal">取消</button>
31. <asp:Button ID="SaveEdit" type="button" class="btn btn-primary" runat="server" Text="保存" OnClick="SaveEdit_Click" />
32. </div>
33. </div>
34. </div>
35. </div>

复制代码

后台弹框和编辑代码（里面的dao和impl是封装的数据库连接和更新的代码，TagInfo是封装的实体类）：

1. //编辑弹框弹出
2. protected void Modify_Click(object sender, EventArgs e)
3. {
4. LinkButton link = sender as LinkButton;
5. int index = Convert.ToInt32(link.CommandArgument);
6. TagInfoDao tag = new TagInfoDaoImpl();
7. TagInfo tagInfo = tag.findByTid(index);
8. //赋值
9. TidEdit.Text = index.ToString();
10. TagEdit.Text = tagInfo.groupCode +","+ tagInfo.elementCode;
11. TagNameEdit.Text = tagInfo.tagName;
12. NotesEdit.Text = tagInfo.notes;
13. //弹出模态框
14. ClientScriptManager scriptManager = ((Page)System.Web.HttpContext.Current.Handler).ClientScript;
15. scriptManager.RegisterStartupScript(typeof(string), "", "$('#editModal').modal('show');", true);
16. //查询
17. VRInfoDao vr = new VRInfoDaoImpl();
18. List<VRInfo> vrList = vr.findVRInfo("");
19. ddlVREdit.DataSource = vrList;
20. ddlVREdit.DataTextField = "code";
21. ddlVREdit.DataValueField = "VID";
22. ddlVREdit.DataBind();
23. ddlVREdit.SelectedIndex = tagInfo.vid - 1;
24. }
25. //编辑保存
26. protected void SaveEdit_Click(object sender, EventArgs e)
27. {
28. TagInfo tag = new TagInfo();
29. tag.tid = Convert.ToInt32(TidEdit.Text);
30. tag.groupCode = TagEdit.Text.Split(',')[0];
31. tag.elementCode = TagEdit.Text.Split(',')[1];
32. tag.tagName = TagNameEdit.Text;
33. tag.notes = NotesEdit.Text;
34. tag.vid = Convert.ToInt32(ddlVREdit.SelectedValue);
35. TagInfoDao tagDao = new TagInfoDaoImpl();
36. if (tagDao.updata(tag))
37. {
38. Alert("修改成功！");
39. }
40. else
41. {
42. Alert("修改失败！");
43. }
44. bind_gv();
45. }

复制代码

Alert弹框代码：

1. public void Alert(string str_Message)
2. {
3. ClientScriptManager scriptManager = ((Page)System.Web.HttpContext.Current.Handler).ClientScript;
4. scriptManager.RegisterStartupScript(typeof(string), "", "alert('" + str_Message + "');", true);
5. }

复制代码

删除后台代码：

1. //删除
2. protected void Delete_Click(object sender, EventArgs e)
3. {
7. LinkButton link = sender as LinkButton;
8. int index = Convert.ToInt32(link.CommandArgument);
9. TagInfoDao tag = new TagInfoDaoImpl();
10. if (tag.delete(index))
11. {
12. //删除成功
13. Alert("删除成功");
14. }
15. else
16. {
17. //删除失败
18. Alert("删除失败");
19. }
20. bind_gv();
21. }

复制代码

新增跟编辑一样就不放代码了。

来源：https://blog.csdn.net/ab17171313/article/details/81504755
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！