آپلود با SP ؟؟؟؟

منظورتون ذخیره تصویر در بانک با Sp است ؟

بله آقای مهندس

Stor

CREATE PROCEDURE InsertImage

      -- Add the parameters for the stored procedure here

      @fileName varchar(250),

      @fileContent image,

      @active bit

AS

BEGIN

      -- SET NOCOUNT ON added to prevent extra result sets from

      -- interfering with SELECT statements.

      SET NOCOUNT ON;

 

     -- Insert statements for procedure here

       INSERT INTO Files ([FileName], FileContent, Active) VALUES (@fileName,

@fileContent, @active)

END

C# Code

    string _connStr =

ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;

 

 

   /// <summary>

   /// Uploads the and save into database.

   /// </summary>

   /// <param name="sender">The sender.</param>

   /// <param name="e">The <see cref="System.EventArgs"/> instance containing the

event data.</param>

    protected void UploadAndSaveIntoDatabase(object sender, EventArgs e)

    {

        string fileName = FileUpload1.PostedFile.FileName;

        int fileLength = FileUpload1.PostedFile.ContentLength;

 

        byte[] imageBytes = new byte[fileLength];

        FileUpload1.PostedFile.InputStream.Read(imageBytes, 0, fileLength);

 

        using (SqlConnection conn = new SqlConnection(_connStr))

        {

          using (SqlCommand cmd = new SqlCommand("InsertImage", conn))

          {

              cmd.CommandType = CommandType.StoredProcedure;

 

              SqlParameter[] prms = new SqlParameter[3];

              prms[0] = new SqlParameter("@fileName", SqlDbType.VarChar, 50);

              prms[0].Value = fileName;

              prms[1] = new SqlParameter("@fileContent", SqlDbType.Image);

              prms[1].Value = imageBytes;

              prms[2] = new SqlParameter("@active", SqlDbType.Bit);

              prms[2].Value = true; // hard coded value

 

              cmd.Parameters.AddRange(prms);

 

              conn.Open();

              cmd.ExecuteNonQuery();

              conn.Close();

        }

        lblMessage.Text = fileName + " saved to the database successsfully !";

    }

} 

HTML

<h4>Save images into the database</h4>

       Select file: <asp:FileUpload ID="FileUpload1" runat="server" />

       <asp:Button ID="btnSubmit" runat="server" Text="Upload & Save" OnClick="UploadAndSaveIntoDatabase" />

        <p><asp:Label ID="lblMessage" runat="server" EnableViewState="false" 

ForeColor="Green" /></p>

خیلی ممنون اقای مهندس