//codepage
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="image.aspx.cs" Inherits="image" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><<%@ Page Language="C#" AutoEventWireup="true" CodeFile="image.aspx.cs" Inherits="image" %>
html xmlns="http://www.w3.org/1999/xhtml"><
head runat="server"><title>Untitled Page</title></
head><
body><form id="form1" runat="server"><div><asp:FileUpload ID="FileUpload1" runat="server" /><asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" /></div><div><asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"><Columns><asp:TemplateField HeaderText="Photo"><ItemTemplate><asp:Image ID="Image1" runat="server" Width="50" Height="50" ImageUrl='<%# "Handler.ashx?id=" + Eval("Img_Id") %>' /></ItemTemplate></asp:TemplateField><asp:TemplateField HeaderText="imageno"><ItemTemplate><asp:Label ID="lab1" runat="server" Text='<%# Bind("Img_Id") %>' /></ItemTemplate></asp:TemplateField><asp:TemplateField HeaderText="ImageType"><ItemTemplate><asp:Label ID="lab1" runat="server" Text='<%# Bind("Image_Type") %>' /></ItemTemplate></asp:TemplateField><asp:TemplateField HeaderText="ImageSize"><ItemTemplate><asp:Label ID="lab1" runat="server" Text='<%# Bind("Image_Size") %>' /></ItemTemplate></asp:TemplateField></Columns></asp:GridView></div></form></
body></
html>
//code page
using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.IO;using System.Data.SqlClient;using DatabaseUtility;public partial class image : System.Web.UI.Page{
GlobalConnection GST = new GlobalConnection();
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString);
protected void Page_Load(object sender, EventArgs e){
GridView1.DataSource = FetchAllImagesInfo();
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e){
if (FileUpload1.PostedFile != null && FileUpload1.PostedFile.FileName != ""){
byte[] myimage = new byte[FileUpload1.PostedFile.ContentLength];
HttpPostedFile Image = FileUpload1.PostedFile;Image.InputStream.Read(myimage, 0, (
int)FileUpload1.PostedFile.ContentLength);
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString);
SqlCommand storeimage = new SqlCommand("insert into ImageGallery "+ "(Image_Content, Image_Type, Image_Size) "+ " values (@image, @imagetype, @imagesize)", myConnection);storeimage.Parameters.Add(
"@image", SqlDbType.Image, myimage.Length).Value = myimage;storeimage.Parameters.Add(
"@imagetype", SqlDbType.VarChar, 100).Value= FileUpload1.PostedFile.ContentType;
storeimage.Parameters.Add(
"@imagesize", SqlDbType.BigInt, 99999).Value= FileUpload1.PostedFile.ContentLength;
myConnection.Open();
storeimage.ExecuteNonQuery();
myConnection.Close();
}
}
public DataTable FetchAllImagesInfo(){
string sql = "Select * from ImageGallery";
SqlDataAdapter da = new SqlDataAdapter(sql, myConnection);
DataTable dt = new DataTable();da.Fill(dt);
return dt;}
}
url:http://www.aspdotnetcodes.com/Insert_Images_Database.aspx
