How to image insert and show user images by session?

If this post helps you mark it as answer
Thanks

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

private void btnclick_Click(object sender, EventArgs e)

         {

             // Creating instance of SqlConnection

            SqlConnection conn = new SqlConnection("Database=student;Server=.;user=sa;password=aaaaaaa");

             conn.Open();// open the database connection

            SqlCommand cmd = new SqlCommand();// Creating instance of SqlCommand

            cmd.Connection = conn; // set the connection to instance of SqlCommand

            cmd.CommandText = "insert into student_detail values (" + txtrollno.Text + ",'" + txtname.Text + "','" + txtcourse.Text + "')";  // set

               //the sql command ( Statement )

            cmd.ExecuteNonQuery();

             MessageBox.Show("Record Saved"); // showing messagebox for confirmation message for user

            conn.Close();// Close the connection

        }

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

protected void btnUpload_Click(object sender, EventArgs e)

{

//Condition to check if the file uploaded or not 

if (fileuploadImage.HasFile)

{

//getting length of uploaded file

int length = fileuploadImage.PostedFile.ContentLength;

//create a byte array to store the binary image data

byte[] imgbyte = new byte[length];

//store the currently selected file in memeory

HttpPostedFile img = fileuploadImage.PostedFile;

//set the binary data

img.InputStream.Read(imgbyte, 0, length);

string imagename = txtImageName.Text;

//use the web.config to store the connection string

SqlConnection connection = new SqlConnection(strcon);

connection.Open();

SqlCommand cmd = new SqlCommand("INSERT INTO Image (ImageName,Image) VALUES (@imagename,@imagedata)", connection);

cmd.Parameters.Add("@imagename", SqlDbType.VarChar, 50).Value = imagename;

cmd.Parameters.Add("@imagedata", SqlDbType.Image).Value = imgbyte;

int count = cmd.ExecuteNonQuery();

connection.Close();

if (count == 1)

{

BindGridData();

txtImageName.Text = string.Empty;

ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('" + imagename + " image inserted successfully')", true);

}

}

}

<form id="form1" runat="server">

<div>

<table>

<tr>

<td>

Image Name:

</td>

<td>

<asp:TextBox ID="txtImageName" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

Upload Image:

</td>

<td>

<asp:FileUpload ID="fileuploadImage" runat="server" />

</td>

</tr>

<tr>

<td>

</td>

<td>

<asp:Button ID="btnUpload" runat="server" Text="Upload" onclick="btnUpload_Click" />

</td>

</tr>

</table>

</div>

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif