位置0没有行.请帮助. [英] There is no row at position 0. Please Help.

问题描述

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();
    }

推荐答案

我认为您在第三行遇到了此异常.
在此之前添加

i think you are getting this exception at third line.
Add before this

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
}

这篇关于位置0没有行.请帮助.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！