DataSet dspc = obj.returndataset("select * from commission_master where product_code='" + DropDownList1.SelectedItem.Text.Trim() + "'"); Label4.Text = dspc.Tables[0].Rows[0]["product_name"].ToString().Trim(); DataTable dt = obj.returndatatable("select * from term_master where scheme = '" + drp_plan.SelectedValue.ToString().Trim() + "' and nplan = '" + DropDownList1.SelectedItem.Text.Trim() + "' order by slno"); if (dt.Rows.Count > 0) { double rdmin, fdmin; rdmin = Convert.ToDouble(dt.Rows[0]["rd_min_book_amount"].ToString().Trim()); fdmin = Convert.ToDouble(dt.Rows[0]["fd_min_book_amount"].ToString().Trim()); if (rdmin > 0 && fdmin > 0) { //tr_rdbookamt.Visible = true; //tr_fdbookamt.Visible = true; txt_fdbookamt.Text = "0"; } else if (rdmin > 0) { //tr_rdbookamt.Visible = true; txt_fdbookamt.Text = "0"; } else { //tr_fdbookamt.Visible = true; txt_rdbookamt.Text = "0"; } } else { lbl_err.Text = "Select Scheme & Plan !"; } drp_term.Items.Insert(0, "Select"); drp_term.Focus(); }
if(dspc.Tables[0].Rows.Count>0) { Label4.Text = dspc.Tables[0].Rows[0]["product_name"].ToString().Trim(); } else { //return from code //or dont handle that dataset in this part }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)