Databind预览记录删除后 [英] After Databind Previews record are deleted

问题描述

实际上现在我在Datagrid工作。



i我试图绑定记录。



第一次记录绑定正确显示，但2时间记录绑定第一条记录被删除。

我想添加第二条记录。



如果我尝试3次绑定需要添加3行，我通过sql查询绑定。

查询工作正常。我也得到数据到datatable。



如果有人帮帮我..

Actually now i am working in Datagrid.

i am trying to bind a records.

First time record binding properly displayed but 2 time record is binding 1st record was deleted.
I want to add 2nd record.

if i try 3 time binding need to add 3 row and i am binding through sql Query.
Query is working fine. i am getting data to datatable also.

If any one Help me..

public dt As DataTable

Private Sub btnADD_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnADD.Click
       Dim sql As String = "select * from court where courtid='" & ddlfromsec.SelectedValue & "'"
       dt = class.Bysql(sql)
       If dt.Rows.Count > 0 Then
           dg1.DataSource = dt
           dg1.DataBind()
       End If
   End Sub

我将更改ddlfromsec.SelectedValue。第一次一个值，第二行一个值就是这样。

I will Change ddlfromsec.SelectedValue. first time one value, 2nd line one value like that.

推荐答案

每次都要创建一个新的数据表，所以它只包含一行。

要么只是向dgv添加行而不是使用数据绑定

或

每次都不要创建新的数据表并添加行在子

You''re creating a new datatable each time so it will only contain a single row.
Either just add rows to the dgv instead of using databinding
or
Don''t create a new datatable each time and add rows to a datatable defined outside the sub

这篇关于Databind预览记录删除后的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！