我想通过gridview查看详细的信息,但是显示如上错误,我另外一个页面同样的代码,却是对的,为什么这个会报错?如下是我的代码:
Label1.Text = Session("tname").ToString()
Dim t As String
t = Choose(Weekday(Now), "星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六")
Label6.Text = "今天是:" & Now & Space(3) & t
myconn = New SqlConnection("server=localhost;database=database;uid=sa;pwd=sa")
myconn.Open()
Dim strfn As String = Request.QueryString("filename")
If Not String.IsNullOrEmpty(strfn) Then
Dim sqlstr As String = "select * from file where filename='" + strfn + "'"
Dim sda As New SqlDataAdapter(sqlstr, myconn)
ds = New DataSet
sda.Fill(ds, "file") 报错
Dim drv As DataRowView
drv = ds.Tables("file").DefaultView(0)
Label2.Text = Convert.ToString(drv.Row("filename"))
Label3.Text = Convert.ToString(drv.Row("filetime"))
Label4.Text = Convert.ToString(drv.Row("sname"))
TextBox1.Text = Convert.ToString(drv.Row("filecontent"))
End If
myconn.Close()
End Sub
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
Dim sqlstr As String = "select * from file where filename='" + strfn + "'"
=======>
Dim sqlstr As String = "select * from [file] where filename='" & strfn & "'"
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
我也猜是3楼所说的原因,建议你把file全部替换成 file2 试试;
另外,楼主这样写sql语句很不安全哟!~