How To Insert Image Into Database
hi
try for this code: insert image in to database.
.aspx:
<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:TextBox ID="TextBox1" runat="server" Style="left: 380px; position: relative;
top: -401px"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
.cs:
page_load()
{
// give sql connections(connection string)
}
protected void Button1_Click(object sender, EventArgs e)
{
int len = FileUpload1.PostedFile.ContentLength;
byte[] pic = new byte[len];
FileUpload1.PostedFile.InputStream.Read(pic, 0, len);
string fup = FileUpload1.PostedFile.FileName;
if (k1 == 0)
{
cmd = new SqlCommand("insert into login_inf(first_name,logo) values (@name,@logo)", conn);
cmd.Parameters.Add("@name", TextBox1.Text.Replace("'", "''"));
cmd.Parameters.Add("@logo", pic);
cmd.ExecuteNonQuery();
}
}
good programming.exellent.