How we can save Images in database?

yes you can save image into database if you are using SQL server than you have to use Image type of column and if you are using Oracle DB than you have to use Blog Data type to save image into database.

Let me know if you need code to save image into database.

plese tell me the procedure to save the image in the database

Hello Rama Krishna,

To save and retrieve Image into/from SQL Server please follow these articles


To Save Image
http://www.dotnetspark.com/kb/35-read--write-image-into-sql-server-asp-net.aspx

To retrieve Image from Sql Server
http://www.dotnetspark.com/kb/36-read--write-image-into-sql-server-asp-net.aspx

Cheers
Pankaj

i have a gridview there are three field like,ID,image,Name and also a link print in gridview . retrieve all record from database showing in Gridview i have done it.but when i click link buttion print in gridview then show all record:

HTML Code:

<tr bgcolor="#f2f2f2" class="black">
<td height="25" style="width: 15px"> </td>
<td ><div align="left">ID*: </div></td>
<td style="text-align: left" id="ct" runat="server" ></td>
<td> </td>
</tr>

<tr bgcolor="#f2f2f2" class="black">
<td height="25" style="width: 15px"> </td>
<td ><div align="left">name : </div></td>
<td style="text-align: left" id="fname" runat="server" ></td>
<td> </td>
</tr>
<asp:Image ID="Image1" Width="120" Height="120" runat="server" ImageAlign ="Middle" />


Csharp Code:

protected void Page_Load(object sender, EventArgs e)
{
conn = new SqlConnection("data source=(local);uid=sa;pwd=sa;initial catalog=databasename");


cmd = new SqlCommand("select name,ID,impimg from tablename where ID='" + Request.QueryString.Get("id") + "'");

cmd.Connection = conn;
conn.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
fname.InnerHtml = dr["name"].ToString();

ct.InnerHtml = dr["ID"].ToString();
Image1.ImageUrl = dr["impimg"].ToString();


}


two record dislaying but Image not display .
i want show one by one record when click print buttion please help me.

}

we can save images in database in 2 ways ist is in the form of byte formate
and second and easier way is store the path of the image in the data base........