C#

A_A wrote:

all the images that i load have 13 bytes

A_A wrote:

i do not know how to check the no. of bytes in the (sql 2005)

SqlConnection con = new SqlConnection("DATA SOURCE = MAX_TOSHIBA;Initial Catalog=nodule; Integrated security = true");

                string sql = "INSERT INTO pic (pic_id,patient,id,the_pic,pic_no) values ('" + j + "','" + txt_patient_name.Text + "','" + 0 + "', @a,'" + 0 + "')";
                //string sql = "UPDATE CUSTOMER SET IMAGE = (@ImagPar)";
                SqlCommand cmd = new SqlCommand();
                SqlParameter sp = new SqlParameter("@a", SqlDbType.Image);
                sp.Value = by_img;
                cmd.Parameters.Add(sp);
                cmd.CommandText = sql;
                cmd.CommandType = CommandType.Text;
                cmd.Connection = con;

                //open connection
                con.Open();

                //execute the sql command
                cmd.ExecuteNonQuery();

                con.Close();

using (SqlCommand command = new SqlCommand(sql, connection))
{
    // etc.
}

//Store the scrollposition
int _xScrollPosition = dataGridView1.HorizontalScrollingOffset;
//update the datagridview
dataGridView1.HorizontalScrollingOffset = _xScrollPosition;