我想用SqlDataReader读取所有表内的信息
dbconn已经在web.config里设置了全球信息
Private strConn As String = System.Configuration.ConfigurationSettings.AppSettings("DBConn")
Private dbConn As SqlConnection
Private strComm As String = ""
Private dbComm As SqlCommand
Private dr As SqlDataReader
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
data_show() '读取数据库
End Sub
Sub data_show()
dbConn = New SqlConnection(strConn)
dbConn.Open()
strComm = "select * from caigou_info_mgn"
dbComm = New SqlCommand(strComm, dbConn)
dr = dbComm.ExecuteReader
Dim i As Int32 = 0
While dr.Read
While i < 26 '就这一块我不大会写,看别人的代码和书也不是很明白 是象asp一样读数据行么
大家能给个详细读数据方法吗?
End While End While
End Sub
请问我怎样用语句才能获得读取的所有信息,并且用一个数组保存起来
比如我的Sqlserver表里
数据如下:
id daleixing xiaoleixing fenlei content
一共有26行数据
While dr.Read
While i < 26
数组[i]=read[字段名].tostring();
End While End While