狂送100分(29)

binbin2000 2003-07-19 11:51:55

怎样在datagrid中增加一行数据

...全文

21 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

lihonggen0 2003-07-19

打赏
举报

上面是往记录集里添加一行数据

即相应的DATAGRID的新加行

lihonggen0 2003-07-19

打赏
举报

象这样：

Private Sub Command1_Click()
Rs.AddNew
Rs.Fields("xxx") = "xxx"
Rs.Fields("xxx") = "xxx"
Rs.Fields("xxx") = "xxx"
Rs.Fields("xxx") = 3
End Sub

binbin2000 2003-07-19

打赏
举报

to lihonggen0(李洪根,用.NET，标准答案来了) :
帮个忙,我还是不知道怎么用,请写个具体代码好吗?
rs.addnew('1','2','3')不对阿

lihonggen0 2003-07-19

打赏
举报

Dim CN As New ADODB.Connection '定义数据库的连接
Dim Rs As New ADODB.Recordset

Private Sub Command1_Click()
Rs.AddNew
End Sub

Private Sub Form_Load()

CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from employees", CN, adOpenDynamic, adLockOptimistic

Set DataGrid1.DataSource = Rs
End Sub

lihonggen0 2003-07-19