GridView+Linq增删改操作

最新推荐文章于 2019-04-15 14:24:04 发布

原创最新推荐文章于 2019-04-15 14:24:04 发布 · 2.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#linq #textbox #sorting #javascript #asp #c

ASP.NET 专栏收录该内容

28 篇文章

订阅专栏

本文介绍了一个使用ASP.NET中的GridView控件结合Linq实现数据的增删改查功能的示例。示例中详细展示了如何配置GridView控件以支持编辑、删除等功能，并在后台代码中实现了数据绑定、添加、更新及删除的具体逻辑。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前台代码：

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>GridView+Linq增删改操作</title>

</head>

<body>

<div>

<asp:GridView ID="gvDictionary" runat="server" SkinID="gvDefault" OnRowCancelingEdit="gvDictionary_RowCancelingEdit"

OnRowEditing="gvDictionary_RowEditing" OnRowUpdating="gvDictionary_RowUpdating"

OnRowDeleting="gvDictionary_RowDeleting"

onpageindexchanging="gvDictionary_PageIndexChanging"

onrowdatabound="gvDictionary_RowDataBound" onsorting="gvDictionary_Sorting"

AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False"

CellPadding="4" ForeColor="#333333" GridLines="None" PageSize="5" Width="419px">

<asp:BoundField ReadOnly="true" DataField="DictCode" SortExpression="DictCode" HeaderText="字典编号">

</asp:BoundField>

<asp:BoundField DataField="DictName" SortExpression="DictName" HeaderText="字典名称">

</asp:BoundField>

<asp:CheckBoxField DataField="IfUsing" SortExpression="IfUsing" HeaderText="启用" Text="启用">

</asp:CheckBoxField>

<asp:BoundField DataField="Note" HeaderText="备注">

</asp:BoundField>

<asp:CommandField CancelText="取消" EditText="编辑" ShowEditButton="True" UpdateText="更新">

</asp:CommandField>

<asp:CommandField DeleteText="删除" ShowDeleteButton="True"></asp:CommandField>

</Columns>

<HeaderStyle BackColor="#1C5E55" BorderStyle="None" Font-Bold="True"

ForeColor="White" HorizontalAlign="Left" />

</asp:GridView>

<tr>

<td>

字典编号：</td>

<td>

<asp:TextBox ID="txtDictCode" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

字典名称</td>

<td>

<asp:TextBox ID="txtDictName" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

是否启用：</td>

<td>

<asp:CheckBox ID="chkIfUsing" runat="server" Checked="True" Text="启用" />

</td>

</tr>

<tr>

<td>

备注：</td>

<td>

<asp:TextBox ID="txtNote" runat="server" Height="88px" TextMode="MultiLine" Width="313px"></asp:TextBox>

</td>

</tr>

<tr>

<asp:Button ID="btnSave" runat="server" Text="保存" OnClick="btnSave_Click" />

<br />

<asp:Label ID="lblInfo" runat="server" />

<asp:Label ID="lblSort" runat="server" Visible="false"></asp:Label>

</td>

</tr>

</table>

</div>

</form>

</body>

</html>

后台代码：

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.Linq;

using System.Collections.Generic;

namespace WebApplication1

{

public partial class Default5 : System.Web.UI.Page

{

/*作者：WhirlWind(20080524) */

ProviderTypeDataContext myprovider = new ProviderTypeDataContext();

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

//进行绑定

gvBind();

}

// 进行数据绑定

public void gvBind()

{

var query = from p in myprovider.Provider_Type

select p;

this.gvDictionary.DataSource = query;

this.gvDictionary.DataBind();

}

//添加操作

protected void btnSave_Click(object sender, EventArgs e)

{

//判断当前主键编号是否存在

var bol = from p in myprovider.Provider_Type

where p.DictCode.Contains(this.txtDictCode.Text)

select p.DictCode;

if (bol.Count() >= 1)

{

this.lblInfo.ForeColor = System.Drawing.Color.Red;

this.lblInfo.Text = string.Format("字典编号为 '{0}' 已经存在，请重新填写", this.txtDictCode.Text);

return;

}

else

{

this.lblInfo.Text = "";

}

Provider_Type provider = new Provider_Type();

provider.DictCode = this.txtDictCode.Text;

provider.DictName = this.txtDictName.Text;

provider.IfUsing = this.chkIfUsing.Checked;

provider.Note = this.txtNote.Text;

//进行添加操作

//Table<Provider_Type> TabProviderTypes = myprovider.GetTable<Provider_Type>();

// myprovider.Provider_Type.Add(provider);

// TabProviderTypes.res

myprovider.Provider_Type.InsertOnSubmit(provider);

myprovider.SubmitChanges();

//重新进行绑定

this.gvBind();

}

protected void gvDictionary_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

this.gvDictionary.EditIndex = -1;

this.gvBind();

}

protected void gvDictionary_RowEditing(object sender, GridViewEditEventArgs e)

{

this.gvDictionary.EditIndex = e.NewEditIndex;

this.gvBind();

}

//更新操作

protected void gvDictionary_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

//获取字典编号值

string strDictCode = this.gvDictionary.Rows[e.RowIndex].Cells[0].Text;

Provider_Type provider = myprovider.Provider_Type.Single(p => p.DictCode == strDictCode);

//更新内容

provider.DictName = ((TextBox)this.gvDictionary.Rows[e.RowIndex].Cells[1].Controls[0]).Text;

provider.IfUsing = ((CheckBox)this.gvDictionary.Rows[e.RowIndex].Cells[2].Controls[0]).Checked;

provider.Note = ((TextBox)this.gvDictionary.Rows[e.RowIndex].Cells[3].Controls[0]).Text;

//进行更新操作

myprovider.SubmitChanges();

//取消更新状态

this.gvDictionary.EditIndex = -1;

//重新进行绑定

this.gvBind();

}

protected void gvDictionary_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

//获取主键

string strDictCode = this.gvDictionary.Rows[e.RowIndex].Cells[0].Text;

var provider = from p in myprovider.Provider_Type

where p.DictCode.Contains(strDictCode)

select p;

//执行删除操作

//myprovider.ProviderTypes.RemoveAll(provider);

myprovider.Provider_Type.DeleteAllOnSubmit(provider);

//开始提交

myprovider.SubmitChanges();

//重新进行绑定

this.gvBind();

}

//排序

protected void gvDictionary_Sorting(object sender, GridViewSortEventArgs e)

{

//Table<Model.ProviderType> provider = from p in myprovider.ProviderTypes

// select p;

//if (this.lblSort.Text == e.SortExpression)

//{

// this.lblSort.Text = e.SortExpression + " DESC";

//}

//else

//{

// this.lblSort.Text = e.SortExpression;

//}

var mysort = from p in myprovider.Provider_Type

orderby p.DictName descending

select p;

this.gvDictionary.DataSource = mysort;

this.gvDictionary.DataBind();

}

//分页

protected void gvDictionary_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

this.gvDictionary.PageIndex = e.NewPageIndex;

this.gvBind();

}

protected void gvDictionary_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

string strMsg = "javascript:return confirm('您确定要删除字典名称为：" + e.Row.Cells[1].Text + " 的信息吗？')";

e.Row.Cells[5].Attributes.Add("onclick", strMsg);

}

参考了网上别人的文章，并修改调试通过！