 |
| |
ช่วยทีครับ ต้องการ ดึงภาพจาก database มาแสดงที่ image จะต้องทำงัยอะครับ |
| |
 |
|
|
 |
 |
|
ช่วยทีครับ ต้องการ ดึงภาพจาก database มาแสดงที่ image จะต้องทำงัยอะครับ
ตามหัวข้อเลยครับ เคยเอามาแสดงแต่ใน GridView แล้วถ้าจะเอามาใส่ ที่ Image ใน tag ImageUrl เลยจะต้องทำยังไงครับ
( ค้นหาภาพ หรือ เอาสุดท้ายที่อัพลงฐานข้อมูล มาแสดงครับ )
Code (ASP)
//this.pnlForm.Visible = false;
if (this.fUpload.HasFile == false)
{
this.lblStatus.Text = "Please input Name and Chooes File.";
}
else
{
//*** Read Binary Data ***'
byte[] imbByte = new byte[fUpload.PostedFile.InputStream.Length + 1];
fUpload.PostedFile.InputStream.Read(imbByte, 0, imbByte.Length);
fileNamePic = fUpload.FileName;
//*** MimeType ***'
string ExtType = System.IO.Path.GetExtension(fUpload.PostedFile.FileName).ToLower();
string strMIME = null;
switch (ExtType)
{
case ".gif":
strMIME = "image/gif";
break;
case ".bmp":
strMIME = "image/BMP";
break;
case ".jpg":
case ".jpeg":
case ".jpe":
strMIME = "image/jpeg";
break;
case ".png":
strMIME = "image/png";
break;
default:
this.lblStatus.Text = "Invalid file type.";
return;
}
//*** Insert to Database ***'
OleDbConnection objConn = new OleDbConnection();
string strConnString = null;
string strSQL = null;
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
Server.MapPath("App_Data/mydatabase.mdb") + ";Jet OLEDB:Database Password=;";
objConn.ConnectionString = strConnString;
objConn.Open();
strSQL = "DELETE * FROM files";
OleDbCommand objCmd = new OleDbCommand(strSQL, objConn);
objCmd = new OleDbCommand(strSQL, objConn);
objCmd.ExecuteNonQuery();
strSQL = "INSERT INTO files (Name,FilesName,FilesType) VALUES (@sName,@sFilesName,@sFilesType)";
OleDbCommand objCmd1 = new OleDbCommand(strSQL, objConn);
objCmd1.Parameters.Add("@sName", OleDbType.VarChar).Value = fUpload.FileName;
objCmd1.Parameters.Add("@sFilesName", OleDbType.Binary).Value = imbByte;
objCmd1.Parameters.Add("@sFilesType", OleDbType.VarChar).Value = strMIME;
objCmd1.ExecuteNonQuery();
objConn.Close();
objConn = null;
BindData();
Tag : ASP.NET, Ms Access, Web (ASP.NET), VB.NET
|
|
|
 |
 |
 |
 |
| Date :
2012-01-21 16:41:51 |
By :
likhit |
View :
1382 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
Code (VB.NET)
Imports System.Data
Imports System.Data.OleDb
Partial Class ViewImg
Inherits System.Web.UI.Page
Dim objConn As New OleDbConnection
Dim objCmd As OleDbCommand
Dim strConnString, strSQL As String
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& _
Server.MapPath("App_Data/mydatabase.mdb")&";Jet OLEDB:Database Password=;"
objConn.ConnectionString = strConnString
objConn.Open()
'*** DataTable ***'
Dim dtAdapter As OleDbDataAdapter
Dim dt As New DataTable
strSQL = "SELECT * FROM files WHERE FilesID = @sFilesID "
dtAdapter = New OleDbDataAdapter(strSQL, objConn)
objCmd = dtAdapter.SelectCommand
objCmd.Parameters.Add("@sFilesID", OleDbType.Integer).Value = Request.QueryString("FilesID")
dtAdapter.Fill(dt)
If dt.Rows.Count > 0 Then
Response.ContentType = dt.Rows(0)("FilesType").ToString()
Response.BinaryWrite(dt.Rows(0)("FilesName"))
End If
dt = Nothing
End Sub
Protected Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Unload
objConn.Close()
objConn = Nothing
End Sub
End Class
Go to : ASP.NET Access BLOB Binary Data and Parameterized Query
|
| |
|
|
| |
| Date :
2012-01-22 06:35:51 |
By :
webmaster |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
