Image Uploading and displaying

In design:

onclick="Button_Upload_Click" />

Code:

protected void Button_Upload_Click(object sender, EventArgs e)

{

string F_Type = UploadedFile.PostedFile.ContentType;

byte[] F_Data = new byte[UploadedFile.PostedFile.InputStream.Length + 1];

UploadedFile.PostedFile.InputStream.Read(F_Data, 0, F_Data.Length);

SqlConnection conn = new SqlConnection(constring);

SqlCommand cmd = new SqlCommand("Insert into FileUploda(F_Data,F_Type)values(@F_Data,@F_Type)",conn);

SqlParameter perm1 = new SqlParameter("@F_Data", SqlDbType.Image);

perm1.Value = F_Data;

cmd.Parameters.Add(perm1);

SqlParameter perm2 = new SqlParameter("@F_Type",SqlDbType.VarChar);

perm2.Value = F_Type;

cmd.Parameters.Add(perm2);

conn.Open();

cmd.ExecuteNonQuery();

int theID = System.Convert.ToInt32(cmd.ExecuteScalar());

conn.Close();

lit_status.Text = "file is uploda.Click here to see it.";

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

g s11y ago
Refer Below Link

http://dotnetdrizzles.blogspot.in/2014/09/image-insert-upload-bind-gridview-using.html
0
Rakesh11y ago
In design:

onclick="Button_Upload_Click" />

Code:

protected void Button_Upload_Click(object sender, EventArgs e)
{
string F_Type = UploadedFile.PostedFile.ContentType;
byte[] F_Data = new byte[UploadedFile.PostedFile.InputStream.Length + 1];
UploadedFile.PostedFile.InputStream.Read(F_Data, 0, F_Data.Length);
SqlConnection conn = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand("Insert into FileUploda(F_Data,F_Type)values(@F_Data,@F_Type)",conn);

SqlParameter perm1 = new SqlParameter("@F_Data", SqlDbType.Image);
perm1.Value = F_Data;
cmd.Parameters.Add(perm1);
SqlParameter perm2 = new SqlParameter("@F_Type",SqlDbType.VarChar);
perm2.Value = F_Type;
cmd.Parameters.Add(perm2);
conn.Open();
cmd.ExecuteNonQuery();
int theID = System.Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
lit_status.Text = "file is uploda.Click here to see it.";
}
+1