Command Parameters Declaration

Type 1

Con.Open();

string Qry = "Update tblcentreselection set ImgHeaderBinayByte=@ImgBinary,ImgExtension=@ImgExtention where Centreid=@CenterId";

SqlCommand cmd = new SqlCommand(Qry, Con);

cmd.Parameters.Add("@ImgBinary", SqlDbType.VarBinary);

cmd.Parameters["@ImgBinary"].Value = ImgBinary;

cmd.Parameters.Add("@ImgExtention", SqlDbType.VarChar);

cmd.Parameters["@ImgExtention"].Value = StrExtension;

cmd.Parameters.Add("@CenterId", SqlDbType.Int);

cmd.Parameters["@CenterId"].Value = Convert.ToString(Session["_SelCen"]);

cmd.ExecuteNonQuery();

Con.Close();

Type 2

Con.Open();

string Qry = "Update tblcentreselection set ImgHeaderBinayByte=@ImgBinary,ImgExtension=@ImgExtention where Centreid=@CenterId";

SqlCommand cmd = new SqlCommand(Qry, Con);

Cmd.Parameters.AddWithValue("", OrgId);

Cmd.Parameters.AddWithValue("", ExVisitId);

Cmd.Parameters.AddWithValue("", ReportType);

Cmd.Parameters.AddWithValue("", LabPdfBinary);

cmd.ExecuteNonQuery();

Con.Close();