|
|
m using insert query to insert data into 7 tables , bt the problem is tht there is a problem in table named"tbl_master" when m not writing insert query for this table,rest of all tables r getting data bt when m writing insert query 4 this table also , no tables r getting data . i've checked the query with query analyzer , with query analyzer it is working properly
bt in aspx.cs pg it is not working.cud anyone help me out??????????????
this is insert query for "tbl_master"
string mas1="";
mas1="insert into tbl_master(cl_title,cl_firstname,cl_middlename,cl_surname,cl_dateofbirth,cl_gender,cl_marrital_status,cl_address,cl_city,cl_state,cl_pincode,cl_telephone_no,cl_mobile_no,cl_email_id,clientcode,pro_firstname,pro_middlename,pro_surname,pro_dateofbirth,pro_gender,pro_marrital_status,pro_address,pro_city,pro_state,pro_pincode,pro_telephone_no,pro_mobile_no,pro_email_id,pro_title,plan_name,duration_policy,sum_assured,annual_premium,premium_freq,issue_dt,rider_name,policyno,applicationno,model_premium,applicationdate,logindate,chequeno,issuingbank,chequeamount,cheque_issue_dt,sa_rider_cri,sa_rider_acc,sa_rider_inc,sa_rider_waiver,sa_rider_hos,cashamt,sa_rider_ko_term,sa_rider_ko_pre_term,sa_rider_ko_par,sa_rider_rel_term,rm_name,rm_code,rm_branch_name,ma_name,ma_code,tele_id,tele_name)values";
mas1+="('"+dropdown_title_cl.SelectedValue+"','"+textbox_first_cl.Text+"','"+textbox_middle_cl.Text+"','"+textbox_sur_cl.Text+"','"+dropdown_date_cl.SelectedValue+"/index.html"+dropdown_month_cl.SelectedValue+"/index.html"+dropdown_year_cl.SelectedValue+"','"+dropdown_gender_cl.SelectedValue+"','"+dropdown_mari_cl.SelectedValue+"','"+textbox_add_cl.Text+"','"+dropdown_city_cl.SelectedValue+"','"+dropdown_state_cl.SelectedValue+"','"+textbox_pin_cl.Text+"','"+textbox_std_cl.Text+"-"+textbox_tno_cl.Text+"','"+textbox_con_cl.Text+"-"+textbox_mno_cl.Text+"','"+textbox_em_cl.Text+"','"+text_clcode.Text+"','"+textbox_first_cl.Text+"','"+textbox_middle_cl.Text+"','"+textbox_sur_cl.Text+"','"+dropdown_date_cl.SelectedValue+"/index.html"+dropdown_month_cl.SelectedValue+"/index.html"+dropdown_year_cl.SelectedValue+"'";
mas1+="'"+dropdown_gender_cl.SelectedValue+"','"+dropdown_mari_cl.SelectedValue+"','"+textbox_add_cl.Text+"','"+dropdown_city_cl.SelectedValue+"','"+dropdown_state_cl.SelectedValue+"','"+textbox_pin_cl.Text+"','"+textbox_std_cl.Text+"-"+textbox_tno_cl.Text+"','"+textbox_con_cl.Text+"-"+textbox_mno_cl.Text+"','"+textbox_em_cl.Text+"','"+dropdown_title_cl.SelectedValue+"','"+drop_icici.SelectedValue+"','"+drop_dur_pol.SelectedValue+"','"+text_sum_as.Text+"','"+text_ann_pre.Text+"','"+dropdown_prem_fre.SelectedValue+"','"+drop_iss_date.SelectedValue+"/index.html"+drop_iss_month.SelectedValue+"/index.html"+drop_iss_year.SelectedValue+"','"+id+"','"+text_pol_no.Text+"','"+text_app_no.Text+"','"+text_mod_pre.Text+"','"+drop_app_dt.SelectedValue+"/index.html"+drop_app_month.SelectedValue+"/index.html"+drop_app_year.SelectedValue+"'";
mas1+="'"+drop_log_dt.SelectedValue+"/index.html"+drop_log_mon.SelectedValue+"/index.html"+drop_log_yr.SelectedValue+"','"+text_che_no.Text+"','"+text_bank.Text+"','"+text_che_amt.Text+"','"+drop_iss_dt.SelectedValue+"/index.html"+drop_iss_mon.SelectedValue+"/index.html"+drop_iss_yr.SelectedValue+"','"+text_ic_sa_cri.Text+"','"+text_ic_sa_acc.Text+"','"+text_ic_sa_in.Text+"','"+text_ic_sa_wa.Text+"','"+text_ba_sa_hos.Text+"','"+text_cash_amt.Text+"','"+text_ko_sa_term.Text+"','"+text_ko_sa_pre.Text+"','"+text_ko_sa_par.Text+"','"+text_rel_sa_term.Text+"','"+text_rm.Text+"','"+text_rm_co.Text+"','"+drop_branch_name.SelectedValue+"','"+text_ma_name.Text+"','"+text_ma_code.Text+"','"+text_tele_id.Text+"','"+text_tele_name+"')";
cmd=new SqlCommand(mas1,conn,trans);
k=cmd.ExecuteNonQuery();
|
|
|
|
|
anant
