protected void btnSave_Click(object sender, EventArgs e) { con.Open(); cmd = new SqlCommand("emp_insert", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@empno", TextBox1.Text); cmd.Parameters.AddWithValue("@empname", TextBox2.Text); cmd.Parameters.AddWithValue("@Picture", FileUpload1.FileName); cmd.Parameters.AddWithValue("@action", "i"); cmd.ExecuteNonQuery(); Label3.Text = "Inserted"; con.Close(); }
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();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)