if (chkRecmmdtn.Checked == true)
{
chkno = 2;
//------------------------ LOOP FOR RECOMMENDATIONS ---------------------
int j = 0;
string[] b = new string[4];
for (j = 0; j <= chkOpt2.Items.Count - 1; j++)
{
if (chkOpt2.Items[j].Selected == true)
{
b[j] += chkOpt2.Items[j] + "";
}
}
//InsertTypedata(str1, str1, chkno, b[4]);
SqlParameter[] objPrms = new SqlParameter[7];
//SqlParameter objPrms = new SqlParameter();
objPrms[0] = new SqlParameter("@REG_NEW_ID", SqlDbType.VarChar, 100);
objPrms[0].Value = str1;
objPrms[1] = new SqlParameter("@portfolio_new_id", SqlDbType.VarChar, 100);
objPrms[1].Value = str1;
objPrms[2] = new SqlParameter("@type", SqlDbType.Int);
objPrms[2].Value = chkno;
objPrms[3] = new SqlParameter("@IS_AGM", SqlDbType.Int);
objPrms[3].Value = Convert.ToInt32(b[0]!= null?true:false);
objPrms[4] = new SqlParameter("@IS_EGM", SqlDbType.Int);
objPrms[4].Value = Convert.ToInt32(b[1] != null ? true : false);
objPrms[5] = new SqlParameter("@IS_CCM", SqlDbType.Int);
objPrms[5].Value = Convert.ToInt32(b[2] != null ? true : false);
objPrms[6] = new SqlParameter("@IS_PB", SqlDbType.Int);
objPrms[6].Value = Convert.ToInt32(b[3] != null ? true : false);
ds = SqlHelper.ExecuteDataset(ConnStr, CommandType.StoredProcedure, "USP_INS", objPrms);
This is my code, this is for one checkbox where my checklist values are checked and stored in db. but i m not able to stored all the values in db on 3rd checkbox checked and also user should be able to see that values are checked by default on 3rd checkbox checked,
Thanks & Regards
Priti
Priti2010, if this helps please login to Mark As Answer. | Alert Moderator