(sql server2000)表结构:
pid(int) picname(nvchar)
1 200614164828.doc
2 200614164838.jpg文件保存路径在根目录下的up_file文件中。
我用datagrid显示出来的也如上。现在想实现的是:点某一文件名,就直接打开,方式为:
http://localhost/asp.net/up_file/200614164838.jpg 一下是pageload 代码
Dim myconn As SqlConnection = New SqlConnection
myconn.ConnectionString = ConfigurationSettings.AppSettings("conn")
Dim dr As SqlDataAdapter
Dim sql As String = "select * from pic order by pid desc"
dr = New SqlDataAdapter(sql, myconn)
Dim ds As DataSet = New DataSet
dr.Fill(ds, "pic")
mygrid.DataSource = ds.Tables("pic").DefaultView
mygrid.DataBind()谢谢各位。。
pid(int) picname(nvchar)
1 200614164828.doc
2 200614164838.jpg文件保存路径在根目录下的up_file文件中。
我用datagrid显示出来的也如上。现在想实现的是:点某一文件名,就直接打开,方式为:
http://localhost/asp.net/up_file/200614164838.jpg 一下是pageload 代码
Dim myconn As SqlConnection = New SqlConnection
myconn.ConnectionString = ConfigurationSettings.AppSettings("conn")
Dim dr As SqlDataAdapter
Dim sql As String = "select * from pic order by pid desc"
dr = New SqlDataAdapter(sql, myconn)
Dim ds As DataSet = New DataSet
dr.Fill(ds, "pic")
mygrid.DataSource = ds.Tables("pic").DefaultView
mygrid.DataBind()谢谢各位。。
以下是我的代码。。但是显示不出来图片
Dim myconn As SqlConnection = New SqlConnection
myconn.ConnectionString = ConfigurationSettings.AppSettings("conn")
Dim id As String = Request.QueryString("pid").ToString.Replace("'", "")
Dim sql As String = "select * from pic where pid ='" + id + "'"
Dim comm As SqlCommand
comm = New SqlCommand(sql, myconn)
myconn.Open()
Dim dr As SqlDataReader = comm.ExecuteReader()
While dr.Read()
filename = dr.Item("picname") End While myconn.Close()
dr.Close()
Dim path As String = "up_file"
img.ImageUrl = path / filename
分不够在加