我在DataRow创建时遇到NULLException错误 [英] i got an NULLException Error at DataRow Creation

问题描述

嗨我在数据表中创建DataRow时出现NULLException错误...





这个是以下代码

  string  des =  ; 
十进制perc =  0 ; 
  string  mnth =  ; 
  string  year =  ; 
 
 da =  new  SqlDataAdapter（ 从EmployeeSalary_structure选择Employee_Id，annual_Basic，Description_Name，Percentage，Monthly，Yearly，其中Employee_id =' + Session [  Employee_id]。ToString（）+  '，con）; 
 da.Fill（ds，  EmployeeSalary）; 
  if （ds.Tables [  EmployeeSalary ]。Rows.Count >   0 ）
 {
 txtbasicy.Text = ds.Tables [  EmployeeSalary]。行[ 0 ] [ 1 ]。ToString（）; 
 txtbasicm.Text =  String  .Format（  {0：##}，Convert.ToDecimal（txtbasicy.Text）/ 12）; 
 
 des = ds.Tables [  EmployeeSalary]。行[< span class =code-digit> 0 ] [ 2 ]。ToString（）; 
 perc = Convert.ToDecimal（ds.Tables [  EmployeeSalary]。行[< span class =code-digit> 0 ] [ 3 ]。ToString（））; 
  if （perc！=  0 ）
 {
 mnth = Convert.ToString（Convert.ToDecimal（txtbasicm.Text）*（perc /  100 ））; 
 year = Convert.ToString（Convert.ToDecimal（txtbasicy.Text）*（perc /  100 ））; 
} 
  else  
 {
 mnth = ds.Tables [   EmployeeSalary]。行[ 0 ] [ 4 ]的ToString（）; 
 year = ds.Tables [  EmployeeSalary]。行[ 0 ] [ 5 ]。ToString（）; 
} 
 
  const   string  key8 =   empsal1; 
 DataTable dt2 = Session [key8]  as  DataTable; 
 dbsal =（DataTable）会话[  SessionTable5]; 
 
 DataRow dr8 = dbsal.NewRow（）;  //  这里我得到了NULLException错误 
 dr8 [ 0 ] = des; 
 dr8 [ 1 ] =  < /跨度>; 
 dr8 [ 2 ] = perc; 
 dr8 [ 3 ] = mnth; 
 dr8 [ 4 ] =年; 
 
 dbsal.Rows.Add（des， ，perc，mnth ， 年）; 
 
 Session [key8] = dbsal; 
 grdsalarybreakup.DataSource = dbsal; 
 grdsalarybreakup.DataBind（）; 
} 

请帮帮我...



提前感谢

解决方案

使用这个

-----------



< pre lang =c＃> string des = ;
十进制perc = 0 ;
string mnth = ;
string year = ;

da = new SqlDataAdapter（ 从EmployeeSalary_structure选择Employee_Id，annual_Basic，Description_Name，Percentage，Monthly，Yearly，其中Employee_id =' + Session [ Employee_id]。ToString（）+ '，con）;
da.Fill（ds）;
if （ds！= null && ds.Tables.Count> 0 && ds.Tables [ 0 ]。Rows.Count > 0 ）
{
txtbasicy.Text = ds.Tables [ 0 ]。行[ 0 ] [ 1 ]。ToString（）;
txtbasicm.Text = String .Format（ {0：。##}，Convert.ToDecimal（txtbasicy.Text）/ 12 ）;

des = ds.Tables [ 0 ]。行[ 0 ] [ 2 ]。ToString（）;
perc = Convert.ToDecimal（ds.Tables [ 0 ]。行[ 0 ] [ 3 ]。ToString（））;
if （perc！= 0 ）
{
mnth = Convert.ToString（Convert.ToDecimal（txtbasicm.Text）*（perc / 100 ））;
year = Convert.ToString（Convert.ToDecimal（txtbasicy.Text）*（perc / 100 ））;
}
else
{
mnth = ds.Tables [ 0 ]。行[ 0 ] [ 4 ]。ToString（）;
year = ds.Tables [ 0 ]。行[ 0 ] [ 5 ]的ToString（）;
}

const string key8 = empsal1;
DataTable dt2 = Session [key8] as DataTable;
dbsal =（DataTable）会话[ SessionTable5];

DataRow dr8 = dbsal.NewRow（）; // 这里我得到了NULLException错误
dr8 [ 0 ] = des;
dr8 [ 1 ] = < /跨度>;
dr8 [ 2 ] = perc;
dr8 [ 3 ] = mnth;
dr8 [ 4 ] =年;

dbsal.Rows.Add（dr8）;

Session [key8] = dbsal;
grdsalarybreakup.DataSource = dbsal;
grdsalarybreakup.DataBind（）;
}

Hi I got a NULLException Error at DataRow creation in a datatable...


This is the following code

string des="";
        Decimal perc=0;
        string mnth="";
        string year="";

        da = new SqlDataAdapter("Select Employee_Id,yearly_Basic,Description_Name,Percentage,Monthly,Yearly from EmployeeSalary_structure where Employee_id='" + Session["Employee_id"].ToString() + "' ", con);
        da.Fill(ds, "EmployeeSalary");
     if (ds.Tables["EmployeeSalary"].Rows.Count > 0)
     { 
         txtbasicy.Text=ds.Tables["EmployeeSalary"].Rows[0][1].ToString();
         txtbasicm.Text= String.Format("{0:.##}",Convert.ToDecimal(txtbasicy.Text)/12);
            
         des=ds.Tables["EmployeeSalary"].Rows[0][2].ToString();
         perc=Convert.ToDecimal(ds.Tables["EmployeeSalary"].Rows[0][3].ToString());
         if (perc != 0)
         {
             mnth = Convert.ToString(Convert.ToDecimal(txtbasicm.Text) * (perc / 100));
             year = Convert.ToString(Convert.ToDecimal(txtbasicy.Text) * (perc / 100));
         }
         else
         {
             mnth = ds.Tables["EmployeeSalary"].Rows[0][4].ToString();
             year = ds.Tables["EmployeeSalary"].Rows[0][5].ToString();
         }

         const string key8 = "empsal1";
         DataTable dt2 = Session[key8] as DataTable;
         dbsal = (DataTable)Session["SessionTable5"];
        
         DataRow dr8 = dbsal.NewRow();//Here i got NULLException Error
         dr8[0] = des;
         dr8[1] = "";
         dr8[2] =perc; 
         dr8[3] =mnth;
         dr8[4] = year;
        
         dbsal.Rows.Add(des, "", perc, mnth, year);

         Session[key8] = dbsal;
         grdsalarybreakup.DataSource = dbsal;
         grdsalarybreakup.DataBind();     
     }

please help me...

thanks in advance

解决方案

use this
-----------

string des = "";
                Decimal perc = 0;
                string mnth = "";
                string year = "";

                da = new SqlDataAdapter("Select Employee_Id,yearly_Basic,Description_Name,Percentage,Monthly,Yearly from EmployeeSalary_structure where Employee_id='" + Session["Employee_id"].ToString() + "' ", con);
                da.Fill(ds);
                if (ds!=null && ds.Tables.Count >0 && ds.Tables[0].Rows.Count > 0)
                {
                    txtbasicy.Text = ds.Tables[0].Rows[0][1].ToString();
                    txtbasicm.Text = String.Format("{0:.##}", Convert.ToDecimal(txtbasicy.Text) / 12);

                    des = ds.Tables[0].Rows[0][2].ToString();
                    perc = Convert.ToDecimal(ds.Tables[0].Rows[0][3].ToString());
                    if (perc != 0)
                    {
                        mnth = Convert.ToString(Convert.ToDecimal(txtbasicm.Text) * (perc / 100));
                        year = Convert.ToString(Convert.ToDecimal(txtbasicy.Text) * (perc / 100));
                    }
                    else
                    {
                        mnth = ds.Tables[0].Rows[0][4].ToString();
                        year = ds.Tables[0].Rows[0][5].ToString();
                    }

                    const string key8 = "empsal1";
                    DataTable dt2 = Session[key8] as DataTable;
                    dbsal = (DataTable)Session["SessionTable5"];

                    DataRow dr8 = dbsal.NewRow();//Here i got NULLException Error
                    dr8[0] = des;
                    dr8[1] = "";
                    dr8[2] = perc;
                    dr8[3] = mnth;
                    dr8[4] = year;

                    dbsal.Rows.Add(dr8);

                    Session[key8] = dbsal;
                    grdsalarybreakup.DataSource = dbsal;
                    grdsalarybreakup.DataBind();
                }

这篇关于我在DataRow创建时遇到NULLException错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！