datagridview.rows.add(1)无效 [英] datagridview.rows.add(1) not working
问题描述
你好家伙
i刚刚制作了一些代码来绑定Datagridview和Adodb但是我不能在网格中添加空行!
< pre lang =vb> Imports ADODB
Imports System.Data.OleDb
公开 类 Form1
Dim Cntemp As New ADODB.Connection
Dim Rstemp 作为 新 ADODB.Recordset
Dim Dataset1 As 新 DataSet
Dim DataAdapter1 As 新 OleDbDataAdapter
Priv ate Sub Form1_Load( ByVal sender As 系统。对象, ByVal e As System.EventArgs)句柄 MyBase .Load
Cntemp.Open( Provider = Microsoft.ace.OLEDB.12.0;数据源=& Application.StartupPath& \ vbdata.accdb )
Rstemp.Open( Select * From tbltemp,Cntemp, 1 , 2 )
DataAdapter1.Fill(Dataset1,Rstemp, tbltemp)
dgv.DataSource = Dataset1.Tables( 0 )
dgv.Rows.Add( 10 )
End Sub
dgv。 Rows.Add(10)
不会在这里工作。
请参阅此处的参考资料。
参考
< a href =http://forums.asp.net/post/2165946.aspx> http://forums.asp.net/post/2165946.aspx [ ^ ]
http://geekswithblogs.net/dotNETvinz/archive/2009/03/ 11 / tiptrick-show-header-and-footer-of-gridview-when-no-data.aspx [ ^ ]
< blockquote>你不能打电话给dgv.Rows.Add(10)
你需要申报一个新的数据流,例如
Dim dr As DataRow = dataset1.Tables( 0 )。NewRow
dgv.rows.add(dr)
>
hello guys
i just made some code to bind Datagridview with Adodb but i cannot add an empty rows to the grid!
Imports ADODB
Imports System.Data.OleDb
Public Class Form1
Dim Cntemp As New ADODB.Connection
Dim Rstemp As New ADODB.Recordset
Dim Dataset1 As New DataSet
Dim DataAdapter1 As New OleDbDataAdapter
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Cntemp.Open("Provider=Microsoft.ace.OLEDB.12.0; Data Source=" & Application.StartupPath & "\vbdata.accdb")
Rstemp.Open("Select * From tbltemp", Cntemp, 1, 2)
DataAdapter1.Fill(Dataset1, Rstemp, "tbltemp")
dgv.DataSource = Dataset1.Tables(0)
dgv.Rows.Add(10)
End Sub
dgv.Rows.Add(10)
Not gonna work here.
see the references here.
Ref.
http://forums.asp.net/post/2165946.aspx[^]
http://geekswithblogs.net/dotNETvinz/archive/2009/03/11/tiptrick-show-header-and-footer-of-gridview-when-no-data.aspx[^]
you cant call dgv.Rows.Add(10)
you need to declare a new datarow e.g.
Dim dr As DataRow = dataset1.Tables(0).NewRow dgv.rows.add(dr)
这篇关于datagridview.rows.add(1)无效的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!