gridView 和 detailsView的使用

最新推荐文章于 2019-04-18 15:59:46 发布

jame_peng

最新推荐文章于 2019-04-18 15:59:46 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏：【ASP.NET】文章标签： textbox asp server button dataset sql

本文链接：https://blog.youkuaiyun.com/jame_peng/article/details/1660940

【ASP.NET】专栏收录该内容

88 篇文章

订阅专栏

本文详细介绍了在ASP.NET中如何结合使用GridView和DetailsView控件来实现数据展示和编辑功能。通过具体实例代码，展示了如何配置GridView进行数据绑定及链接跳转至DetailsView进行数据详细查看和编辑。

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

最近项目的需要，正好用到了detaisView控件，所以写了写

gridview:这里我用的是数据源

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

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

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">

<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />

<asp:BoundField DataField="id" HeaderText="id" SortExpression="id" />

<asp:TemplateField>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=localhost;Initial Catalog=test;User ID=sa;pwd=sql;"

SelectCommand="SELECT [name], [id] FROM [userInfo]"></asp:SqlDataSource>

</form>

</body>

</html>

detailsView：

前台：

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %>

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

</head>

<body>

<div>

<asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px" AutoGenerateRows="False">

<asp:TemplateField HeaderText="id">

<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("id") %>'></asp:TextBox>

</EditItemTemplate>

<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("id") %>'></asp:TextBox>

</InsertItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Bind("id") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="name">

<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("name") %>'></asp:TextBox>

</EditItemTemplate>

<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("name") %>'></asp:TextBox>

</InsertItemTemplate>

<asp:Label ID="Label2" runat="server" Text='<%# Bind("name") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField ShowHeader="False">

<asp:Button ID="Button1" runat="server" CausesValidation="True" CommandName="Update"

Text="Update" /> <asp:Button ID="Button2" runat="server" CausesValidation="False"

CommandName="Cancel" Text="Cancel" />

</EditItemTemplate>

<asp:Button ID="Button1" runat="server" CausesValidation="False" CommandName="Edit"

Text="Edit" />

</ItemTemplate>

</asp:TemplateField>

</Fields>

</asp:DetailsView>

</div>

</form>

</body>

</html>

后台：

Imports System

Imports System.Data.SqlClient

Imports System.Data

Partial Class Default2

Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not IsPostBack Then

Dim strID As String = Request.QueryString("id")

ViewState("strID") = strID

DetailsView1.DataSource = bindData(strID)

DetailsView1.DataBind()

End If

End Sub

Public Function bindData(ByVal ID As String) As DataSet

Dim strCon As String = "server=.;database=test;uid=sa;pwd=sql"

Dim sql As String = "select * from userinfo where id='" + ID + "'"

Using con As New SqlConnection(strCon)

Using cmd As New SqlCommand(sql, con)

con.Open()

Dim da As New SqlDataAdapter(cmd)

Dim dataset As New DataSet()

da.Fill(dataset)

Return dataset

End Using

End Function

Protected Sub DetailsView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewPageEventArgs) Handles DetailsView1.PageIndexChanging

End Sub

Protected Sub DetailsView1_ItemCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewCommandEventArgs) Handles DetailsView1.ItemCommand

If e.CommandName.Equals("Edit") Then

'DetailsView1.DefaultMode = DetailsViewMode.Edit

DetailsView1.ChangeMode(DetailsViewMode.Edit)

DetailsView1.DataSource = bindData(ViewState("strID").ToString())

DetailsView1.DataBind()

End If

If e.CommandName.Equals("Cancel") Then

DetailsView1.ChangeMode(DetailsViewMode.ReadOnly)

DetailsView1.DataSource = bindData(ViewState("strID").ToString())

DetailsView1.DataBind()

End If

End Sub

Protected Sub DetailsView1_ItemUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewUpdateEventArgs) Handles DetailsView1.ItemUpdating

Dim strid As String = ViewState("strID").ToString()

Dim sql As String = "update userinfo set name ='" + CType(DetailsView1.FindControl("TextBox2"), TextBox).Text.Trim() + "' where id='" + strid + "'"

Dim strCon As String = "server=.;database=test;uid=sa;pwd=sql"

Using con As New SqlConnection(strCon)

Using cmd As New SqlCommand(sql, con)

con.Open()

cmd.ExecuteNonQuery()

End Using

DetailsView1.ChangeMode(DetailsViewMode.ReadOnly)

DetailsView1.DataSource = bindData(ViewState("strID").ToString())

DetailsView1.DataBind()

End Sub

Protected Sub DetailsView1_ModeChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewModeEventArgs) Handles DetailsView1.ModeChanging

End Sub

Protected Sub DetailsView1_ItemCreated(ByVal sender As Object, ByVal e As System.EventArgs) Handles DetailsView1.ItemCreated

End Sub

End Class