我想通过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
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
楼主打断点跟下strfn的值
在sql中file,filename是关键字,改成
Dim sqlstr As String = "select * from [file] where [filename]='" + strfn + "'"
对了~不过为什么textbox1里的内容显示不出来
Dim sqlstr As String = "select * from file where filename='" + strfn + "'"
=======>
Dim sqlstr As String = "select * from [file] where filename='" & strfn & "'"
textbox里不能插图片,是不是存在一个什么richtextbox的?
可以用richtextbox
localphotopath = 从数据库读出路径;
this.pb_PatientImage.Image = Image.FromFile(localphotopath);
至于下载你自己看看下载相关把,一两句话也说不清楚,我又不知道你是ftp上传还是用socket??
如何参数化,你百度下。