不存在你说的问题呀!
你试试下面的代码:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim conn As New SqlConnection("Server=localhost;user id=sa;password=ycm119;database=northwind;")
Dim cmd As New SqlCommand("Select * from Products", conn)
conn.Open()
Dim dtr As SqlDataReader
dtr = cmd.ExecuteReader
dtr.Read()
Label1.Text = dtr("CategoryID").ToString
conn.Close()
End Sub
你试试下面的代码:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim conn As New SqlConnection("Server=localhost;user id=sa;password=ycm119;database=northwind;")
Dim cmd As New SqlCommand("Select * from Products", conn)
conn.Open()
Dim dtr As SqlDataReader
dtr = cmd.ExecuteReader
dtr.Read()
Label1.Text = dtr("CategoryID").ToString
conn.Close()
End Sub
注意是GetSql×××
:)
GetValue得到的Object对象啊,哪来得带参数的ToString()呀?
那怎么把取出的值转换为百分比呀,我试了好几种方法都不行
没有呀,我试了好多方法,就是无法转换为百分比,郁闷呀
此法可行
double.Parse(R["UnitPrice"].ToString())
float.Parse(R["UnitPrice"].ToString())