如何保存在SQLServer2005的图片

Pritesh雅利安:此连结将帮助我想......imgsrc=]
kanjolia GOPAL

codeprelang="c#"<asp:gridviewid=spanclass="code-string""/spanspanclass="code-string"GridView3"/spanrunat=spanclass="code-string""/spanspanclass="code-string"server"/spanautogeneratecolumns=spanclass="code-string""/spanspanclass="code-string"False"/spandatakeynames=spanclass="code-string""/spanspanclass="code-string"IdBanner"/spanxmlns:asp=spanclass="code-string""/spanspanclass="code-string"#unknown"/spanEmptyDataText=spanclass="code-string""/spanspanclass="code-string"NoRecordFound."/spanShowFooter=spanclass="code-string""/spanspanclass="code-string"True"/spanCellPadding=spanclass="code-string""/spanspanclass="code-string"4"/spanForeColor=spanclass="code-string""/spanspanclass="code-string"#333333"/spanGridLines=spanclass="code-string""/spanspanclass="code-string"None"/spanCellSpacing=spanclass="code-string""/spanspanclass="code-string"2"/spanonrowcommand=spanclass="code-string""/spanspanclass="code-string"GridView3_RowCommand"/span><rowstylebackcolor=spanclass="code-string""/spanspanclass="code-string"#EFF3FB"/span/<emptydatarowstylebordercolor=spanclass="code-string""/spanspanclass="code-string"Red"/spanborderstyle=spanclass="code-string""/spanspanclass="code-string"Double"/spanforecolor=spanclass="code-string""/spanspanclass="code-string"Red"/spanHorizontalAlign=spanclass="code-string""/spanspanclass="code-string"Center"/span/><columns<%--==========================================================================--spanclass="code-pagedirective"%>/span spanclass="code-keyword"</spanspanclass="code-leadattribute"asp:templatefield/spanspanclass="code-attribute"headertext/spanspanclass="code-keyword"="/spanspanclass="code-keyword"Id"/spanspanclass="code-attribute"visible/spanspanclass="code-keyword"="/spanspanclass="code-keyword"true"/spanspanclass="code-attribute"/span spanclass="code-attribute"<itemtemplate/span spanclass="code-attribute"<asp:label/spanspanclass="code-attribute"id/spanspanclass="code-keyword"="/spanspanclass="code-keyword"lblId"/spanspanclass="code-attribute"runat/spanspanclass="code-keyword"="/spanspanclass="code-keyword"server"/spanspanclass="code-attribute"text/spanspanclass="code-keyword"="/spanspanclass="code-keyword"<%#Eval("/spanspanclass="code-attribute"Id")/spanspanclass="code-attribute"%/spanspanclass="code-keyword">/span"spanclass="code-keyword"</spanspanclass="code-keyword"//spanspanclass="code-leadattribute"asp:label/span spanclass="code-keyword"<//spanspanclass="code-leadattribute"itemtemplate/span spanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:templatefield/span spanclass="code-attribute"<%--/span===================================================spanclass="code-attribute"--%/spanspanclass="code-keyword">/span spanclass="code-keyword"</spanspanclass="code-leadattribute"asp:templatefield/spanspanclass="code-attribute"headertext/spanspanclass="code-keyword"="/spanspanclass="code-keyword"Image"/spanspanclass="code-attribute"itemstyle-horizontalalign/spanspanclass="code-keyword"="/spanspanclass="code-keyword"Left"/spanspanclass="code-attribute"headerstyle-horizontalalign/spanspanclass="code-keyword"="/spanspanclass="code-keyword"Left"/spanspanclass="code-attribute"/spanspanclass="code-attribute"<edititemtemplate/spanspanclass="code-attribute"<asp:fileupload/spanspanclass="code-attribute"id/spanspanclass="code-keyword"="/spanspanclass="code-keyword"FileUploadEdit"/spanspanclass="code-attribute"runat/spanspanclass="code-keyword"="/spanspanclass="code-keyword"server"/spanspanclass="code-keyword"//spanspanclass="code-attribute"/spanspanclass="code-keyword"<//spanspanclass="code-leadattribute"edititemtemplate/spanspanclass="code-attribute"<itemtemplate/spanspanclass="code-attribute"<asp:image/spanspanclass="code-attribute"id/span=spanclass="code-keyword""/spanspanclass="code-keyword"ImageIT"/spanspanclass="code-attribute"runat/span=spanclass="code-keyword""/spanspanclass="code-keyword"server"/spanspanclass="code-attribute"width/span=spanclass="code-keyword""/spanspanclass="code-keyword"40px"/spanspanclass="code-attribute"height/span=spanclass="code-keyword""/spanspanclass="code-keyword"40px"/spanspanclass="code-attribute"imageurl/span=spanclass="code-keyword""/spanspanclass="code-keyword"<%#"/spanspanclass="code-attribute"../spanspanclass="code-keyword"//spanspanclass="code-attribute"Handler.ashx/spanspanclass="code-keyword"?/spanspanclass="code-attribute"IdBanner/span=spanclass="code-keyword""/spanspanclass="code-keyword"+Eval("/spanspanclass="code-attribute"IdBanner/spanspanclass="code-keyword""/spanspanclass="code-keyword")%>"/spanspanclass="code-keyword"//spanspanclass="code-attribute"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"itemtemplate/spanspanclass="code-attribute"<footertemplate/spanspanclass="code-attribute"<asp:fileupload/spanspanclass="code-attribute"id/span=spanclass="code-keyword""/spanspanclass="code-keyword"FileUploadN"/spanspanclass="code-attribute"runat/span=spanclass="code-keyword""/spanspanclass="code-keyword"server"/spanspanclass="code-keyword"//spanspanclass="code-attribute"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"footertemplate/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:templatefield/span spanclass="code-attribute"<asp:templatefield/spanspanclass="code-attribute"headertext/span=spanclass="code-keyword""/spanspanclass="code-keyword""/spanspanclass="code-attribute"showheader/span=spanclass="code-keyword""/spanspanclass="code-keyword"False"/spanspanclass="code-attribute"/span spanclass="code-attribute"<edititemtemplate/spanspanclass="code-attribute"<asp:linkbutton/spanspanclass="code-attribute"id/span=spanclass="code-keyword""/spanspanclass="code-keyword"LinkButton1"/spanspanclass="code-attribute"runat/span=spanclass="code-keyword""/spanspanclass="code-keyword"server"/spanspanclass="code-attribute"causesvalidation/span=spanclass="code-keyword""/spanspanclass="code-keyword"True"/spanspanclass="code-attribute"commandname/span=spanclass="code-keyword""/spanspanclass="code-keyword"Update"/spanspanclass="code-attribute"commandargument/span=spanclass="code-keyword""/spanspanclass="code-keyword"<%#Container.DataItemIndex%>"/spanspanclass="code-attribute"onclientclick/span=spanclass="code-keyword""/spanspanclass="code-keyword"returnEditConfirmation();"/spanspanclass="code-attribute"tooltip/span=spanclass="code-keyword""/spanspanclass="code-keyword"UpdateRecord"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:linkbutton/spanspanclass="code-attribute"<asp:linkbutton/spanspanclass="code-attribute"id/span=spanclass="code-keyword""/spanspanclass="code-keyword"LinkButton2"/spanspanclass="code-attribute"runat/span=spanclass="code-keyword""/spanspanclass="code-keyword"server"/spanspanclass="code-attribute"causesvalidation/span=spanclass="code-keyword""/spanspanclass="code-keyword"False"/spanspanclass="code-attribute"commandname/span=spanclass="code-keyword""/spanspanclass="code-keyword"Cancel"/spanspanclass="code-attribute"commandargument/span=spanclass="code-keyword""/spanspanclass="code-keyword"<%#Container.DataItemIndex%>"/spanspanclass="code-attribute"tooltip/span=spanclass="code-keyword""/spanspanclass="code-keyword"CancelEdit"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:linkbutton/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"edititemtemplate/spanspanclass="code-attribute"<itemtemplate/spanspanclass="code-attribute"<%--OnClick/span=spanclass="code-keyword""/spanspanclass="code-keyword"Edit"/spanspanclass="code-attribute"--%/spanspanclass="code-keyword">/spanspanclass="code-keyword"</spanspanclass="code-leadattribute"asp:linkbutton/spanspanclass="code-attribute"id/spanspanclass="code-keyword"="/spanspanclass="code-keyword"lnkEdit"/spanspanclass="code-attribute"runat/spanspanclass="code-keyword"="/spanspanclass="code-keyword"server"/spanspanclass="code-attribute"text/spanspanclass="code-keyword"="/spanspanclass="code-keyword""/spanspanclass="code-attribute"commandname/spanspanclass="code-keyword"="/spanspanclass="code-keyword"Edit"/spanspanclass="code-attribute"commandargument/spanspanclass="code-keyword"="/spanspanclass="code-keyword"<%#Container.DataItemIndex%>"/spanspanclass="code-attribute"/spanspanclass="code-keyword"<//spanspanclass="code-leadattribute"asp:linkbutton/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"itemtemplate/spanspanclass="code-attribute"<footertemplate/spanspanclass="code-attribute"<asp:linkbutton/spanspanclass="code-attribute"id/span=spanclass="code-keyword""/spanspanclass="code-keyword"LinkButton2"/spanspanclass="code-attribute"runat/span=spanclass="code-keyword""/spanspanclass="code-keyword"server"/spanspanclass="code-attribute"causesvalidation/span=spanclass="code-keyword""/spanspanclass="code-keyword"False"/spanspanclass="code-attribute"commandname/span=spanclass="code-keyword""/spanspanclass="code-keyword"AddNew"/spanspanclass="code-attribute"forecolor/span=spanclass="code-keyword""/spanspanclass="code-keyword"White"/spanspanclass="code-attribute"tooltip/span=spanclass="code-keyword""/spanspanclass="code-keyword"AddNewRecord"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:linkbutton/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"footertemplate/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:templatefield/spanspanclass="code-attribute"<asp:templatefield/spanspanclass="code-attribute"headertext/span=spanclass="code-keyword""/spanspanclass="code-keyword""/spanspanclass="code-attribute"showheader/span=spanclass="code-keyword""/spanspanclass="code-keyword"False"/spanspanclass="code-attribute"/spanspanclass="code-attribute"<itemtemplate/spanspanclass="code-attribute"<asp:linkbutton/spanspanclass="code-attribute"id/span=spanclass="code-keyword""/spanspanclass="code-keyword"LinkButton4"/spanspanclass="code-attribute"runat/span=spanclass="code-keyword""/spanspanclass="code-keyword"server"/spanspanclass="code-attribute"causesvalidation/span=spanclass="code-keyword""/spanspanclass="code-keyword"False"/spanspanclass="code-attribute"commandname/span=spanclass="code-keyword""/spanspanclass="code-keyword"Delete"/spanspanclass="code-attribute"commandargument/span=spanclass="code-keyword""/spanspanclass="code-keyword"<%#Container.DataItemIndex%>"/spanspanclass="code-attribute"tooltip/span=spanclass="code-keyword""/spanspanclass="code-keyword"EliminarRecord"/spanspanclass="code-attribute"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:linkbutton/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"itemtemplate/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:templatefield/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"columns/spanspanclass="code-attribute"<footerstyle/spanspanclass="code-attribute"backcolor/span=spanclass="code-keyword""/spanspanclass="code-keyword"#1A4D8A"/spanspanclass="code-attribute"font-bold/span=spanclass="code-keyword""/spanspanclass="code-keyword"True"/spanspanclass="code-attribute"forecolor/span=spanclass="code-keyword""/spanspanclass="code-keyword"White"/spanspanclass="code-keyword"//spanspanclass="code-attribute"/spanspanclass="code-attribute"<pagerstyle/spanspanclass="code-attribute"backcolor/span=spanclass="code-keyword""/spanspanclass="code-keyword"#2461BF"/spanspanclass="code-attribute"forecolor/span=spanclass="code-keyword""/spanspanclass="code-keyword"White"/spanspanclass="code-attribute"horizontalalign/span=spanclass="code-keyword""/spanspanclass="code-keyword"center"/spanspanclass="code-keyword"//spanspanclass="code-attribute"/spanspanclass="code-attribute"<SelectedRowStyle/spanspanclass="code-attribute"BackColor/span=spanclass="code-keyword""/spanspanclass="code-keyword"#D1DDF1"/spanspanclass="code-attribute"Font-Bold/span=spanclass="code-keyword""/spanspanclass="code-keyword"True"/spanspanclass="code-attribute"ForeColor/span=spanclass="code-keyword""/spanspanclass="code-keyword"#333333"/spanspanclass="code-keyword"//spanspanclass="code-keyword">/spanspanclass="code-keyword"</spanspanclass="code-leadattribute"HeaderStyle/spanspanclass="code-attribute"BackColor/spanspanclass="code-keyword"="/spanspanclass="code-keyword"#1A4D8A"/spanspanclass="code-attribute"Font-Bold/spanspanclass="code-keyword"="/spanspanclass="code-keyword"True"/spanspanclass="code-attribute"ForeColor/spanspanclass="code-keyword"="/spanspanclass="code-keyword"White"/spanspanclass="code-keyword"//spanspanclass="code-keyword">/spanspanclass="code-keyword"</spanspanclass="code-leadattribute"editrowstyle/spanspanclass="code-attribute"horizontalalign/spanspanclass="code-keyword"="/spanspanclass="code-keyword"Center"/spanspanclass="code-attribute"verticalalign/spanspanclass="code-keyword"="/spanspanclass="code-keyword"Middle"/spanspanclass="code-attribute"backcolor/spanspanclass="code-keyword"="/spanspanclass="code-keyword"#2461BF"/spanspanclass="code-keyword"//spanspanclass="code-attribute"/spanspanclass="code-attribute"<alternatingrowstyle/spanspanclass="code-attribute"backcolor/spanspanclass="code-keyword"="/spanspanclass="code-keyword"White"/spanspanclass="code-keyword"//spanspanclass="code-attribute"/spanspanclass="code-keyword"<//spanspanclass="code-leadattribute"emptydatarowstyle</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:gridview/span/pre/code{C}codeprelang="c#"<![CDATA[spanclass="code-pagedirective"<%@/spanspanclass="code-leadattribute"WebHandlerLanguage/spanspanclass="code-keyword"="/spanspanclass="code-keyword"C#"/spanspanclass="code-attribute"Class/spanspanclass="code-keyword"="/spanspanclass="code-keyword"Handler"/spanspanclass="code-attribute"/spanspanclass="code-pagedirective"%>/span]] spanclass="code-keyword"using/spanSystem;spanclass="code-keyword"using/spanSystem.Web;spanclass="code-keyword"using/spanSystem.Configuration;spanclass="code-keyword"using/spanSystem.Data.SqlClient;spanclass="code-keyword"using/spanSystem.Net; spanclass="code-keyword"public/spanspanclass="code-keyword"class/spanHandler:IHttpHandler{spanclass="code-keyword"public/spanspanclass="code-keyword"void/spanProcessRequest(HttpContextcontext){SqlConnectioncon=spanclass="code-keyword"new/spanSqlConnection();con.ConnectionString=ConfigurationManager.ConnectionStrings[spanclass="code-string""/spanspanclass="code-string"conm"/span].ConnectionString;SqlCommandcmd=spanclass="code-keyword"new/spanSqlCommand();cmd.CommandText=spanclass="code-string""/spanspanclass="code-string"selectImagefromBannerswhereIdBanner=@IdBanner"/span;spanclass="code-comment"///spanspanclass="code-comment"cmd.CommandText="SelectImageName,ImagefromImageswhereID=@ID";/spancmd.CommandType=System.Data.CommandType.Text;cmd.Connection=con; SqlParameterImageID=spanclass="code-keyword"new/spanSqlParameter(spanclass="code-string""/spanspanclass="code-string"@IdBanner"/span,System.Data.SqlDbType.Int);ImageID.Value=context.Request.QueryString[spanclass="code-string""/spanspanclass="code-string"IdBanner"/span];cmd.Parameters.Add(ImageID);con.Open();SqlDataReaderdReader=cmd.ExecuteReader(); spanclass="code-keyword"if/span(dReader.Read()){spanclass="code-keyword"string/spanimpath=System.Web.HttpContext.Current.Server.MapPath(spanclass="code-string""/spanspanclass="code-string"/Images/no-image.gif"/span);spanclass="code-comment"///spanspanclass="code-comment"Server.MapPath("/XMLSupplier/");/spanspanclass="code-comment"///spanspanclass="code-comment"stringimpath=server/spanspanclass="code-comment"///spanspanclass="code-comment"stringimpath="/Images/no-image.gif";/spanspanclass="code-keyword"if/span(spanclass="code-keyword"string/span.IsNullOrEmpty(Convert.ToString(dReader[spanclass="code-string""/spanspanclass="code-string"Image"/span]))){context.Response.ContentType=spanclass="code-string""/spanspanclass="code-string"image/jpg"/span;context.Response.BinaryWrite((spanclass="code-keyword"byte/span[])ConvertImageFiletoBytes(impath));}spanclass="code-keyword"else/span{context.Response.ContentType=spanclass="code-string""/spanspanclass="code-string"image/jpg"/span;context.Response.BinaryWrite((spanclass="code-keyword"byte/span[])dReader[spanclass="code-string""/spanspanclass="code-string"Image"/span]);}spanclass="code-comment"///spanspanclass="code-comment"context.Response.BinaryWrite((byte[])Convert.ToByte(no-image.gif));/span}dReader.Close();con.Close();}spanclass="code-keyword"public/spanspanclass="code-keyword"bool/spanIsReusable{spanclass="code-keyword"get/span{spanclass="code-keyword"return/spanspanclass="code-keyword"false/span;}} spanclass="code-keyword"public/spanspanclass="code-keyword"byte/span[]ConvertImageFiletoBytes(spanclass="code-keyword"string/spanImageFilePath){spanclass="code-keyword"byte/span[]_tempByte=spanclass="code-keyword"null/span;spanclass="code-keyword"if/span(spanclass="code-keyword"string/span.IsNullOrEmpty(ImageFilePath)==spanclass="code-keyword"true/span){spanclass="code-comment"///spanspanclass="code-comment"thrownewArgumentNullException("ImageFileNameCannotbeNullorEmpty","ImageFilePath");/spanspanclass="code-keyword"throw/spanspanclass="code-keyword"new/spanArgumentNullException(spanclass="code-string""/spanspanclass="code-string"ImageFileNameCannotbeNullorEmpty"/span,spanclass="code-string""/spanspanclass="code-string"ImageFilePath"/span);spanclass="code-keyword"return/spanspanclass="code-keyword"null/span; }spanclass="code-keyword"try/span{System.IO.FileInfo_fileInfo=spanclass="code-keyword"new/spanSystem.IO.FileInfo(ImageFilePath);spanclass="code-keyword"long/span_NumBytes=_fileInfo.Length;System.IO.FileStream_FStream=spanclass="code-keyword"new/spanSystem.IO.FileStream(ImageFilePath,System.IO.FileMode.Open,System.IO.FileAccess.Read);System.IO.BinaryReader_BinaryReader=spanclass="code-keyword"new/spanSystem.IO.BinaryReader(_FStream);_tempByte=_BinaryReader.ReadBytes(Convert.ToInt32(_NumBytes));_fileInfo=spanclass="code-keyword"null/span;_NumBytes=spanclass="code-digit"0/span;_FStream.Close();_FStream.Dispose();_BinaryReader.Close();spanclass="code-keyword"return/span_tempByte;}spanclass="code-keyword"catch/span(Exceptionex){spanclass="code-keyword"return/spanspanclass="code-keyword"null/span;}} }/pre/code{的C4}{C5的}{5233}
您好，
请参考下面的链接

{A}

{A2}

{A3的}

{A4纸}]

arunrv:希望这将有助于U{A3的}{A2的}]