我如何在我的数据网格中解决此问题 [英] how can i fix this issue in my data grid
本文介绍了我如何在我的数据网格中解决此问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
亲爱的朋友
我有一个网格
dear friend
i have a grid
<body>
<form id="Form1" method="post" runat="server">
<table width="100%">
<tr>
<td width="100%">
<asp:Button id="btnAdd" runat="server" Text="Add"></asp:Button>
</td>
</tr>
<tr>
<td width="100%">
<asp:DataGrid id="DataGrid1" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:TemplateColumn HeaderText="CompanyID">
<ItemTemplate>
<asp:TextBox id="txtID" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "CompanyID") %>'>
</asp:TextBox>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="CompanyName">
<ItemTemplate>
<asp:TextBox id="txtName" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "CompanyName") %>'>
</asp:TextBox>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Address">
<ItemTemplate>
<asp:TextBox id="txtAdd" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Address") %>'>
</asp:TextBox>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="PhoneNumber">
<ItemTemplate>
<asp:TextBox id="txtPoneNumber" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "PhoneNumber") %>'>
</asp:TextBox>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</td>
</tr>
<tr>
<td>
<asp:Button id="btnSave" runat="server" Text="Save"></asp:Button>
</td>
</tr>
</table>
</form>
</body>
并在后端
and at back end
Imports System
Imports System.Collections
Imports System.ComponentModel
Imports System.Data
Imports System.Drawing
Imports System.Web
Imports System.Web.SessionState
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.HtmlControls
Imports System.Data.SqlClient
Partial Class GridTest
Inherits System.Web.UI.Page
Dim dtGrid As System.Web.UI.WebControls.DataGrid
Dim table As DataTable = New DataTable
Dim btAdd As System.Web.UI.WebControls.Button
Dim con As SqlConnection = New SqlConnection("Server=DBSRV2008\MSSQLSERVER2008R;DataBase=MVC_Test;uid=sa;pwd=subway3328;")
Private Sub Fill()
Dim da As SqlDataAdapter
Dim ds As DataSet
da = New SqlDataAdapter("Select * from Company", con)
ds = New DataSet
da.Fill(table)
End Sub
Private Sub BindDG()
DataGrid1.DataSource = table
DataGrid1.DataBind()
End Sub
Private Sub Nrow()
table.Rows.InsertAt(table.NewRow(), 0)
End Sub
Protected Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click
'While btAdd.OnClientClick = True
DataGrid1.CurrentPageIndex = DataGrid1.CurrentPageIndex + 1
Fill()
Nrow()
BindDG()
'End While
End Sub
End Class
我想在用户添加按钮上动态添加行,点击
然后按保存按钮,我想将数据保存在数据库中
i want to add rows dynamically on user add button click
and on pressing save button i want to save data in my database
how can i do tis?
推荐答案
如果要执行的操作是插入过程,则将列更改为template字段,并为每个模板添加页脚控件插入或添加按钮,然后单击添加到数据库,无论用户在页脚行中输入了什么内容
if what your welling to do is an insert procedure then change your columns to template field and add a footer control for each template , with an insert or add button and when click add to database whatever the user have input in the footer row see this
这篇关于我如何在我的数据网格中解决此问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文