asp.net - 根据查询结果填充一个TextBox，并在DetailsView插入前绑定

Question

我想在输入（fullName）文本框后根据查询用数字填充（访问）文本框我正在使用详细信息视图，我尝试但它总是在插入时返回“0”这是我在 VB.NET 中查找的代码如果名称存在匹配，则增加访问次数，如果没有找到任何匹配的访问次数，最初将是“1”。注意：代码完美运行，只有我遇到的问题是在插入记录之前将访问次数绑定到（访问）文本框。

 Protected Sub DetailsView1_ItemInserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewInsertEventArgs) Handles DetailsView1.ItemInserting
    Dim NameOfPatients As TextBox = DetailsView1.FindControl("TextBox1")
    Dim conn As New SqlConnection
    Dim sda As SqlDataAdapter
    conn.ConnectionString = ConfigurationManager.ConnectionStrings("ClinicConn").ConnectionString
    Dim sql As String = "SELECT * FROM Patients_tab WHERE FullName = '" & NameOfPatients.Text & "'"
    sda = New SqlDataAdapter(sql, conn)
    conn.Open()
    Dim ds As New DataSet
    sda.Fill(ds)
    If ds.Tables(0).Rows.Count > 0 Then
        VisitCount = Val(ds.Tables(0).Rows.Count) + 1
    Else
        VisitCount = 1
    End If
    conn.Close()
End Sub

标签： asp.netsql-servervb.net-2010