Thread: images from Database

Inserting and retrieving images from Database

How to load and insert the images into database using code in ASP.NET and I am using SQL Server as a backend. I am not able to loading and calling an image from database.

I have called the data from database and passed to string. Any help would be highly appreciated.

If you would like to call the data from database and you are using front end as a .net and back end as a SQL Server .Absolutely, you can do this and I do not think any problem should be come.

C#.net code:

private void button2_Click(object sender, EventArgs e)

{
const string conString = "Data Source=apex2006sql;Initial Catalog=ServManLeather;Integrated Security=True;";

const string firequery = "Select ImgNumber, FacilityImg From FacilityImg Where ImgNumber = 1000";

using (SqlConnection sqlconn = new SqlConnection(conString))

{

sqlconn.Open();
using (SqlCommand comnd = new SqlCommand(firequery, sqlconn))

{

using (SqlDataReader rdr = comnd.ExecuteReader())

{

using (DataTable tbdata = new DataTable())

{

tbdata.Load(rdr);
File.WriteAllBytes(@"C:\picture.bmp", (byte[])dt.Rows[0]["FacilityImg"]);

}

}

}

}

}

Vb.net Code:

Private Sub button2_Click(ByVal sender As Object, ByVal e As EventArgs)
Const conString As String = "Data Source=apex2006sql;Initial Catalog=ServManLeather;Integrated Security=True;"
Const firequery As String = "Select ImgNumber, FacilityImg From FacilityImg Where ImgNumber = 1000"
Using sqlconn As New SqlConnection(conString)
sqlconn.Open()
Using comnd As New SqlCommand(firequery, sqlconn)
Using rdr As SqlDataReader = comnd.ExecuteReader()
Using tbdata As New DataTable()
tbdata.Load(rdr)
File.WriteAllBytes("C:\picture.bmp", DirectCast(dt.Rows(0)("FacilityImg"), Byte()))
End Using
End Using
End Using
End Using
End Sub