Class Library
ASPX PAGE
using Upload;
protected void Button1_Click(object sender, EventArgs e)
{
File oFile = new File();
oFile.UploadFile(Server.MapPath("~/Repository"), FileUpload1);
oFile.SaveFileInfo("server=banka-pc;uid=sa;pwd=banka;database=test2", "Fin001", "V1.1", FileUpload1.FileName);
}
SQL Table:
namespace Upload { public class File { public void UploadFile(string strUploadPath, FileUpload fu) { if (fu.HasFile) { try { string filename = Path.GetFileName(fu.FileName); fu.SaveAs(strUploadPath + "/" + filename); } catch (Exception ex) { } } } public void SaveFileInfo(string cnStr,string strDocID, string strVersion, string strStoredPath) { try { SqlConnection cn = new SqlConnection(cnStr); if (ConnectionState.Open != cn.State) { cn.Open(); } //Add params SqlParameter prmDocID = new SqlParameter("@DocID", strDocID); SqlParameter prmVersion = new SqlParameter("@FileName", strVersion); SqlParameter prmFileName = new SqlParameter("@DocVersion", strStoredPath); SqlCommand cmd = new SqlCommand("InsertFilePath", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(prmDocID); cmd.Parameters.Add(prmFileName); cmd.Parameters.Add(prmVersion); cmd.ExecuteNonQuery(); } catch (Exception ex) { } } } } |
ASPX PAGE
using Upload;
protected void Button1_Click(object sender, EventArgs e)
{
File oFile = new File();
oFile.UploadFile(Server.MapPath("~/Repository"), FileUpload1);
oFile.SaveFileInfo("server=banka-pc;uid=sa;pwd=banka;database=test2", "Fin001", "V1.1", FileUpload1.FileName);
}
SQL Table:
Stored Proc
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
Create PROCEDURE InsertFilePath
@DocID char(10),
@FileName varchar(50),
@DocVersion varchar(10)
AS
BEGIN
Insert into DocMaster values(@DocID,@FileName,@DocVersion)
END
