ASP form code
<div align="center">
<form id="frmUpload" runat="server">
<h2>Save Book Details</h2><br />
Book Name : <asp:TextBox runat="server" ID="txtBookname" Text=""></asp:TextBox><br /><br />
Choose File : <asp:FileUpload runat="server" ID="fupPdfBrowse"/><br /><br />
<asp:Button runat="server" ID="btnSave" text="Upload" onclick="btnSave_Click" /><br /><br />
<asp:Label runat="server" ID="lblStatus" text="Click on Browsre to Select File and Enter Book Name then Click Save." />
</form>
</div>
C# Code
Include this two
using System.IO;
using System.Data.SqlClient;
button Save Click event
protected void btnSave_Click(object sender, EventArgs e)
{
if (fupPdfBrowse.HasFile)
{
try
{
string filename = Path.GetFileName(fupPdfBrowse.FileName);
fupPdfBrowse.SaveAs(Server.MapPath("~/") + filename);
lblStatus.Text = "File Uploaded";
SaveBookDetails(txtBookname.Text, filename);
}
catch (Exception ex)
{
lblStatus.Text = "The file could not be uploaded.Exception : " + ex.Message;
}
}
}
method to Save in Database
private void SaveBookDetails(string strBookName, string strFilename)
{
try
{
string strCmd = "INSERT INTO book (name,filename) VALUES (@name, @filename)";
string strCon = "your connection string";
using (SqlConnection con = new SqlConnection(strCon))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = strCmd;
cmd.Parameters.AddWithValue("@name", strBookName);
cmd.Parameters.AddWithValue("@filename", strFilename);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
lblStatus.Text = "File Saved & uploaded";
}
}
}
catch (Exception ex)
{
lblStatus.Text = "Failed to Save book details in Database. Exception : " + ex.Message.ToString();
}
}