mi_returnmode = ds2.Tables [0] .Rows [0] ["mi_return_mode"].ToString();在位置0没有行. [英] There is no row at position 0 at mi_returnmode = ds2.Tables[0].Rows[0]["mi_return_mode"].ToString();

查看:56
本文介绍了mi_returnmode = ds2.Tables [0] .Rows [0] ["mi_return_mode"].ToString();在位置0没有行.的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

protected void txt_fdbookamt_TextChanged(object sender, EventArgs e)
    {
        DataSet ds2 = obj.returndataset("select rd_min_book_amount,rd_multiple_of,rd_total_book_amount,rd_credit_value,term_type,increment,rd_total_entry,fd_min_book_amount,fd_multiple_of,fd_total_book_amount,fd_credit_value,fd_total_entry,mi_return_amount,mi_return_mode,total_dividends from term_master where scheme = '" + drp_plan.SelectedValue.ToString().Trim() + "' AND term='" + drp_term.SelectedItem.Text.ToString() + "' AND nplan = '" + DropDownList1.SelectedItem.Text.Trim() + "' AND status='0'");
        int rd_rbook_amt, mi_value, rd_rcredit_value, fd_rbookamt, rd_credit_value, fd_credit_value, fd_rcredit_value, rd_book_amt, fd_book_amt, rd_min_book_amount, rd_multiple_of, rd_total_book_amount, fd_min_book_amount, fd_total_book_amount, mi_return_amount;
        mi_value = fd_rcredit_value = rd_rbook_amt = rd_rcredit_value = rd_credit_value = fd_credit_value = fd_rbookamt = rd_book_amt = fd_book_amt = rd_min_book_amount = rd_multiple_of = rd_total_book_amount = fd_min_book_amount = fd_total_book_amount = mi_return_amount = 0;
        int fd_multiple_of, rd_total_entry, fd_total_entry, total_dividends;
        rd_multiple_of = fd_multiple_of = rd_total_entry = fd_total_entry = total_dividends = 0;

        string mi_returnmode;
        mi_returnmode = ds2.Tables[0].Rows[0]["mi_return_mode"].ToString();
        total_dividends = Convert.ToInt32(ds2.Tables[0].Rows[0]["total_dividends"].ToString());
        rd_min_book_amount = Convert.ToInt32(ds2.Tables[0].Rows[0]["rd_min_book_amount"].ToString());
        rd_multiple_of = Convert.ToInt32(ds2.Tables[0].Rows[0]["rd_multiple_of"].ToString());

        double rd_total_book_amount12 = Convert.ToDouble(ds2.Tables[0].Rows[0]["rd_total_book_amount"].ToString());
        rd_total_book_amount = Convert.ToInt32(rd_total_book_amount12);

        double rd_credit_value12 = Convert.ToDouble(ds2.Tables[0].Rows[0]["rd_credit_value"].ToString());
        rd_credit_value = Convert.ToInt32(rd_credit_value12);

        fd_credit_value = Convert.ToInt32(ds2.Tables[0].Rows[0]["fd_credit_value"].ToString());
        string term_type = ds2.Tables[0].Rows[0]["term_type"].ToString();
        rd_book_amt = Convert.ToInt32(txt_rdbookamt.Text.Trim());
        fd_book_amt = Convert.ToInt32(txt_fdbookamt.Text.Trim());
        fd_min_book_amount = Convert.ToInt32(ds2.Tables[0].Rows[0]["fd_min_book_amount"].ToString());
        int increment = Convert.ToInt32(ds2.Tables[0].Rows[0]["increment"].ToString());
        rd_total_entry = Convert.ToInt32(ds2.Tables[0].Rows[0]["rd_total_entry"].ToString());
        fd_total_entry = Convert.ToInt32(ds2.Tables[0].Rows[0]["fd_total_entry"].ToString());
        fd_multiple_of = Convert.ToInt32(ds2.Tables[0].Rows[0]["fd_multiple_of"].ToString());
        fd_total_book_amount = Convert.ToInt32(ds2.Tables[0].Rows[0]["fd_total_book_amount"].ToString());
        mi_return_amount = Convert.ToInt32(ds2.Tables[0].Rows[0]["mi_return_amount"].ToString());
        double ard, afd;
        int brd, bfd;
                
            if (fd_book_amt < fd_min_book_amount)
            {
                lbl_err.Text = "FD Booking Amount is very little";
            }
            else
            {
                ard = 0;
                afd = System.Math.DivRem(fd_book_amt, fd_multiple_of, out bfd);
                if (bfd == 0)
                {
                    lbl_err.Text = "";
                    fd_rbookamt = Convert.ToInt32(afd) * fd_total_book_amount;
                    fd_rcredit_value = Convert.ToInt32(afd) * fd_credit_value;
                    mi_value = Convert.ToInt32(afd) * mi_return_amount;

                    TextBox6.Text = fd_rbookamt.ToString().Trim();
                    TextBox7.Text = fd_rcredit_value.ToString().Trim();

                    if (Label2.Text == "MIS")
                    {
                        Label3.Text = "MIS Return Amount is : " + mi_value.ToString().Trim();
                    }
                    else
                    {
                        Label3.Text = "";
                    }
                }
                else
                {                  
                    lbl_err.Text = "Enter a correct Booking Amount !";
                }
            }
            TextBox8.Focus();
       
    }
    protected void txt_rdbookamt_TextChanged(object sender, EventArgs e)
    {
        DataSet ds2 = obj.returndataset("select rd_min_book_amount,rd_multiple_of,rd_total_book_amount,rd_credit_value,term_type,increment,rd_total_entry,fd_min_book_amount,fd_multiple_of,fd_total_book_amount,fd_credit_value,fd_total_entry,mi_return_amount,mi_return_mode,total_dividends from term_master where scheme = '" + drp_plan.SelectedValue.ToString().Trim() + "' AND term='" + drp_term.SelectedItem.Text.ToString() + "' AND nplan = '" + DropDownList1.SelectedItem.Text.Trim() + "' AND status='0'");
        int rd_rbook_amt, mi_value, rd_rcredit_value, fd_rbookamt, rd_credit_value, fd_credit_value, fd_rcredit_value, rd_book_amt, fd_book_amt, rd_min_book_amount, rd_multiple_of, rd_total_book_amount, fd_min_book_amount, fd_total_book_amount, mi_return_amount;
        mi_value = fd_rcredit_value = rd_rbook_amt = rd_rcredit_value = rd_credit_value = fd_credit_value = fd_rbookamt = rd_book_amt = fd_book_amt = rd_min_book_amount = rd_multiple_of = rd_total_book_amount = fd_min_book_amount = fd_total_book_amount = mi_return_amount = 0;
        int fd_multiple_of, rd_total_entry, fd_total_entry, total_dividends;
        rd_multiple_of = fd_multiple_of = rd_total_entry = fd_total_entry = total_dividends = 0;

        string mi_returnmode;
        mi_returnmode = ds2.Tables[0].Rows[0]["mi_return_mode"].ToString();
        total_dividends = Convert.ToInt32(ds2.Tables[0].Rows[0]["total_dividends"].ToString());
        rd_min_book_amount = Convert.ToInt32(ds2.Tables[0].Rows[0]["rd_min_book_amount"].ToString());
        rd_multiple_of = Convert.ToInt32(ds2.Tables[0].Rows[0]["rd_multiple_of"].ToString());

        double rd_total_book_amount12 = Convert.ToDouble(ds2.Tables[0].Rows[0]["rd_total_book_amount"].ToString());
        rd_total_book_amount = Convert.ToInt32(rd_total_book_amount12);

        double rd_credit_value12 = Convert.ToDouble(ds2.Tables[0].Rows[0]["rd_credit_value"].ToString());
        rd_credit_value = Convert.ToInt32(rd_credit_value12);

        fd_credit_value = Convert.ToInt32(ds2.Tables[0].Rows[0]["fd_credit_value"].ToString());
        string term_type = ds2.Tables[0].Rows[0]["term_type"].ToString();
        rd_book_amt = Convert.ToInt32(txt_rdbookamt.Text.Trim());
        fd_book_amt = Convert.ToInt32(txt_fdbookamt.Text.Trim());
        fd_min_book_amount = Convert.ToInt32(ds2.Tables[0].Rows[0]["fd_min_book_amount"].ToString());
        int increment = Convert.ToInt32(ds2.Tables[0].Rows[0]["increment"].ToString());
        rd_total_entry = Convert.ToInt32(ds2.Tables[0].Rows[0]["rd_total_entry"].ToString());
        fd_total_entry = Convert.ToInt32(ds2.Tables[0].Rows[0]["fd_total_entry"].ToString());
        fd_multiple_of = Convert.ToInt32(ds2.Tables[0].Rows[0]["fd_multiple_of"].ToString());
        fd_total_book_amount = Convert.ToInt32(ds2.Tables[0].Rows[0]["fd_total_book_amount"].ToString());
        mi_return_amount = Convert.ToInt32(ds2.Tables[0].Rows[0]["mi_return_amount"].ToString());
        double ard, afd;
        int brd, bfd;

        if (rd_min_book_amount > 0)
        {
            if (rd_book_amt < rd_min_book_amount)
            {
                lbl_err.Text = "RD Booking Amount is very little";
            }
            else
            {
                ard = System.Math.DivRem(rd_book_amt, rd_multiple_of, out brd);
                afd = 0;
                if (brd == 0)
                {
                    lbl_err.Text = "";
                    rd_rbook_amt = Convert.ToInt32(ard) * rd_total_book_amount;
                    rd_rcredit_value = Convert.ToInt32(ard) * rd_credit_value;

                    TextBox6.Text = rd_rbook_amt.ToString().Trim();
                    TextBox7.Text = rd_rcredit_value.ToString().Trim();
                }
                else
                {                    
                    lbl_err.Text = "Enter a correct Booking Amount !";
                }
            }
        }
        else
        {
           
        }
        TextBox8.Focus();
    }   
}

推荐答案

很明显,这行

mi_returnmode = ds2.Tables[0].Rows[0]["mi_return_mode"].ToString();

在这两种方法中的一种/两种方法中,都访问没有行的表.
Obviously the line

mi_returnmode = ds2.Tables[0].Rows[0]["mi_return_mode"].ToString();

in either one/both of the methods accesses a table with no rows.


在查找表中的行之前,先检查表中是否存在行.例如:

Check for the existence of rows in the table before looking for values on those rows. For example:

if (ds2.Tables[0].Rows.Count > 0) {
  mi_returnmode = ds2.Tables[0].Rows[0]["mi_return_mode"].ToString();
}


这篇关于mi_returnmode = ds2.Tables [0] .Rows [0] ["mi_return_mode"].ToString();在位置0没有行.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆