小弟刚学.net,入门很难,被一系列“小问题”困扰,前来请教高手,同时散分谋求好运
程序如下:
Dim public MyConnstring As string="server=lv;database=**AUTO**;User ID=***;password=******;"
Dim MyConnection As SqlConnection
public sub page_load(sender as Object,e as EventArgs)
Dim sqlstr as string= "select * from NS_AS_Outlook order by msgid"
Dim TB1 as DataTable = new DataTable("TB1")
myConnection = New SqlConnection(MyConnstring)
Dim mycomm as sqlDataAdapter=new sqlDataAdapter(sqlstr, myConnection )
Dim MyDataSet as DataSet=new DataSet()
Mycomm.fill(MyDataset,"TB1")
MyConnection.close()
Dim MyRow1 as string
MyRow1= TB1.rows(1)("msgip")
end sub 干的事情很简单,从数据库里取一个表的内容放入TB1,再从TB1里取出某行某列。
以上代码的错误提示为:“在位置 1 处没有任何行”
剧烈疑惑中,如有那位大虾顺便告诉我一下取出msgip=1的那条记录的方法定重谢!!
程序如下:
Dim public MyConnstring As string="server=lv;database=**AUTO**;User ID=***;password=******;"
Dim MyConnection As SqlConnection
public sub page_load(sender as Object,e as EventArgs)
Dim sqlstr as string= "select * from NS_AS_Outlook order by msgid"
Dim TB1 as DataTable = new DataTable("TB1")
myConnection = New SqlConnection(MyConnstring)
Dim mycomm as sqlDataAdapter=new sqlDataAdapter(sqlstr, myConnection )
Dim MyDataSet as DataSet=new DataSet()
Mycomm.fill(MyDataset,"TB1")
MyConnection.close()
Dim MyRow1 as string
MyRow1= TB1.rows(1)("msgip")
end sub 干的事情很简单,从数据库里取一个表的内容放入TB1,再从TB1里取出某行某列。
以上代码的错误提示为:“在位置 1 处没有任何行”
剧烈疑惑中,如有那位大虾顺便告诉我一下取出msgip=1的那条记录的方法定重谢!!
Dim MyConnection As SqlConnection
public sub page_load(sender as Object,e as EventArgs)
Dim sqlstr as string= "select * from NS_AS_Outlook order by msgid"
myConnection = New SqlConnection(MyConnstring)
Dim mycomm as sqlDataAdapter=new sqlDataAdapter(sqlstr, myConnection )
Dim MyDataSet as DataSet=new DataSet()
Mycomm.fill(MyDataset,"TB1")
MyConnection.close()
Dim MyRow1 as string
MyRow1= ds.Tables("TB1").rows(0)("msgip").Tostring
end sub
这样就好。
第一行的值,因为第一行的索引是0
那位大虾顺便告诉我一下怎么样才能把msgip=1的那条记录取出来。
呵呵,大家多说说嘛,我是散分谋求好运
然后用rowfilter("msgip=1")
dataview dv = Tables[0].DefaultView
dv.rowfilter("msgip=1")
Dim rows As DataRow()
rows = MyDataSet.Tables("TB1").Select("msgip=2")
'取得过滤后DataRows中第一行其中一列的值
MyRow2 = rows(0)(1).ToString()
response.write( MyRow2)
呵呵呵,这样实现也可以哦。好了,结贴,谢谢大家给我的运气!