public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { onflbload(sender, e); } public void onflbload(object sender, EventArgs e) { // Create a byte[] from the input file int len = flbload.PostedFile.ContentLength; byte[] pic = new byte[len]; flbload.PostedFile.InputStream.Read(pic, 0, len); // Insert the image and comment into the database SqlConnection connection = new SqlConnection(@"Data Source=DEVI\SQLEXPRESS; Initial Catalog =cat; Integrated Security=SSPI"); SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=DEVI\SQLEXPRESS; Initial Catalog =cat; Integrated Security=SSPI"; try { connection.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "photoset"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BillNo", SqlDbType.NVarChar).Value = TextBox1.Text; cmd.Parameters.Add("@CustomerName", SqlDbType.NVarChar).Value = TextBox2.Text; cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = TextBox3.Text; cmd.Parameters.Add("@StartDate", SqlDbType.NVarChar).Value = Rdbsdate.SelectedDate; cmd.Parameters.Add("@EndDate", SqlDbType.NVarChar).Value = Rdbddate.SelectedDate; cmd.Parameters.Add("@Systemurl", SqlDbType.Image).Value = pic; SqlParameter Src = new SqlParameter("@FilePath", SqlDbType.VarChar, 450); Src.Value = flbload.FileName; cmd.Parameters.Add(Src); cmd.Parameters.Add("@Numberofcopies", SqlDbType.NVarChar).Value = TextBox7.Text; cmd.Parameters.Add("@Amount", SqlDbType.NVarChar).Value = TextBox8.Text; cmd.Parameters.Add("@Total", SqlDbType.NVarChar).Value = TextBox9.Text; cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); } finally { connection.Close(); } } } } My Error all record are insert but file name not insert how to change
filename
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)