asp.net类似vb ado 的功能？

来源：百度知道 编辑：UC知道 时间：2024/06/08 02:08:36
VB通过ADO可以把查询出来的字段显示出来，
如Adodc1.Recordset.Fields (1)
但asp.net 中的SqlDataSource1 控件如何实现同样功能呢？
请楼下详细说明我试来试去没有像VB里面的recordset的功能？如果满意再加分。。。

绑定。
或者读取复制。
或者直接写出。
只要你想得到的就能够做得到.

这个是部分功能的调用。试试看
Imports System.Data
Imports System.Data.SqlClient
Public Class user
Inherits System.Web.UI.Page
Private connectionstring As String
Protected WithEvents username As System.Web.UI.WebControls.TextBox
Protected WithEvents userpwd As System.Web.UI.WebControls.TextBox
Dim conn As SqlConnection
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim sql As String
Dim cmd As SqlCommand
Dim uid As String = ""
uid = Session("userid")
sql = "update users set username='" + username.Text + "',userpwd='" + userpwd.Text + "'where userid='" + uid + "'"
cmd = New SqlCommand(sql, conn)
conn.Open()
cmd.ExecuteNonQ