Datagrid视图帮助编辑表? [英] Datagrid view help with editing table?
本文介绍了Datagrid视图帮助编辑表?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
现在我的代码在加载时会显示列标题和行标题。但是,当我将表格提起时,我希望表格可以完全编辑,以便您可以输入它。有关如何做到的任何想法吗?
公开 Sub GetChartDataGrid()
SqlChart.SelectCommand = < span class =code-string> SELECT NAMES,vacAccrued,vacUsed,vacBalance,perAccrued& _
FROM EMPLOYEES& _
WHERE(NAMES =?)'& lblName.Text& '
' 构建您的DataTable
Dim dt As 新 DataTable()
dt.Columns.Add(新 DataColumn ( Accrued, GetType (< span class =code-keyword> Integer )))
dt.Columns.Add( New DataColumn( 使用, GetType (整数)))
dt.Columns.Add(新 DataColumn( 余额, GetType ( Integer )))
dt.Columns.Add( New DataColumn( Accrued, GetType (整数)))
dt.Columns.Add(新 DataColumn( 使用, GetType (整数) ))
dt.Columns.Add( New DataColumn( Balance, GetType ( Integer )))
dt .Columns.Add( New DataColumn( Total Balance , GetType (整数)))
dt.Columns.Add( New DataColumn( 生病, GetType (整数)))
dt.Columns.Add( New DataColumn( 其他, GetType (整数)))
对于 j 作为 Int16 = 1 13
Dim dr As DataRow = dt.NewRow()
For i 作为 Int16 = 0 8
dr(i )= 0
下一步 i
dt.Rows.Add(dr)
下一步 j
' 将数据绑定到GridView
GridViewChart.DataSource = dt
GridViewChart.DataBind()
End Sub
私有 Sub GridViewChart_RowDataBound(发件人作为 对象,e 作为 GridViewRowEventArgs)句柄 GridViewChart.RowDataBound
Dim mons ()作为 字符串 = { 1月, 2月, March, April, 可能, 6月, 7月, 8月, 九月,
十月, 11月, December, 年总计}
如果 e.Row.RowType = DataControlRowType.DataRow 那么
Dim lblRowHdr As Label = DirectCast (e.Row.FindControl( lblRowHdr),Label)
lblRowHdr.Text = mons(e.Row.RowIndex)
结束 如果
结束 Sub
解决方案
处理GridView.RowEditing Event [ ^ ]活动。
示例 - ASP.NET 2.0中的可编辑GridView [ ^ ]。
尝试
http://msdn.microsoft.com/en-us/library/czzytf25%28v=vs.90%29.aspx [ ^ ]
http://www.youtube.com/watch?v=_1qzVTuz14Y [ ^ ]
http://blogs.msdn.com/b/mattdotson/archive/2005/11/09/real-world-gridview-bulk-editing.aspx [ ^ ]
Right now my code below shows the column headers and row headers when loaded..However, when I bring the table up I want the table to be completely editable so that you can type in it. Any ideas of how to do that?
Public Sub GetChartDataGrid()
SqlChart.SelectCommand = "SELECT NAMES, vacAccrued, vacUsed, vacBalance, perAccrued" & _
"FROM EMPLOYEES" & _
"WHERE (NAMES = ?)'" & lblName.Text & "'"
'Build your DataTable
Dim dt As New DataTable()
dt.Columns.Add(New DataColumn("Accrued", GetType(Integer)))
dt.Columns.Add(New DataColumn("Used", GetType(Integer)))
dt.Columns.Add(New DataColumn("Balance", GetType(Integer)))
dt.Columns.Add(New DataColumn("Accrued ", GetType(Integer)))
dt.Columns.Add(New DataColumn("Used ", GetType(Integer)))
dt.Columns.Add(New DataColumn("Balance ", GetType(Integer)))
dt.Columns.Add(New DataColumn("Total Balance", GetType(Integer)))
dt.Columns.Add(New DataColumn("Sick", GetType(Integer)))
dt.Columns.Add(New DataColumn("Other", GetType(Integer)))
For j As Int16 = 1 To 13
Dim dr As DataRow = dt.NewRow()
For i As Int16 = 0 To 8
dr(i) = 0
Next i
dt.Rows.Add(dr)
Next j
'Bind your data to a GridView
GridViewChart.DataSource = dt
GridViewChart.DataBind()
End Sub
Private Sub GridViewChart_RowDataBound(sender As Object, e As GridViewRowEventArgs) Handles GridViewChart.RowDataBound
Dim mons() As String = {"January", "February", "March", "April", "May", "June", "July", "August", "September",
"October", "November", "December", "Years Totals"}
If e.Row.RowType = DataControlRowType.DataRow Then
Dim lblRowHdr As Label = DirectCast(e.Row.FindControl("lblRowHdr"), Label)
lblRowHdr.Text = mons(e.Row.RowIndex)
End If
End Sub
解决方案
Handle GridView.RowEditing Event[^] event.
Example - Editable GridView in ASP.NET 2.0[^].
Try
http://msdn.microsoft.com/en-us/library/czzytf25%28v=vs.90%29.aspx[^]
http://www.youtube.com/watch?v=_1qzVTuz14Y[^]
http://blogs.msdn.com/b/mattdotson/archive/2005/11/09/real-world-gridview-bulk-editing.aspx[^]
这篇关于Datagrid视图帮助编辑表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文