System.NullReferenceException: Object reference not set to an instance of an object.

AL MUBARAK

Hi,

i had bug in getting dataset value from databse. but the corresponsing value is in null. so it is returns Null value in dataset. it return the expection and sows the error of like below,

System.NullReferenceException: Object reference not set to an instance of an object.

Here is my code :

DataSet ds = service.GetDataSet("sp_smsinbox", "@action$#!@$@substr", "count$#!@$" + substr);

The substr get the values from application and fetch into dataset. but the dataset had null value, then it redirectd the error.

page.

Can anyone please help me to achieve this.

Any help will be greatly appreciated.

Thanks
Mubarak

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
hi dear,

In which line you get the error?
It may possible your "ds" is null and you are accessinf ds.Table[0].

kindly provide some info.

thx.
0
Kunal Vaishya14y ago
Dear sorry but we cat understand what you have codede in GetDataSet function give me source code so we can help you
0
AL MUBARAK14y ago
Dear,

please check the Getdataset value for this function from given below,

namespace smscmsws
{
public service();
{
public DataSet GetDataSet(string sp, string keys, string values);
}
}

Thanks
Mubarak
0
Kunal Vaishya14y ago
Dear

we want GetDataSet Function code to check whats function return to check your problem

so can you send me the code of GetDataSet so we can check it
0
AL MUBARAK14y ago
Hi Jignesh,

Here is some sample of my code. please take a look for it.

DataSet ds = service.GetDataSet("sp_smsinbox", "@action$#!@$@substr", "count$#!@$" + substr);
            int ct = 0;
            if (ds.Tables[0].Rows.Count > 0)
            {
                lblSMSCount.Text = Convert.ToString(ds.Tables[0].Rows[0]["reccount"]);
                lblTotPrice.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["tot_price"]).ToString("#0.000");
                ct = (int)ds.Tables[0].Rows[0]["reccount"];
            }
0
Jignesh Trivedi14y ago
hi,
can u please share code of GetDataSet method?
I think this will usefull to resolved issue.

thx.
0
Kunal Vaishya14y ago
So Check Before assign DataSet Source

if ( service.GetDataSet("sp_smsinbox", "@action$#!@$@substr", "count$#!@$" + substr) != null )
{

DataSet ds = service.GetDataSet("sp_smsinbox", "@action$#!@$@substr", "count$#!@$" + substr);

}
0
AL MUBARAK14y ago
Dear Kunal & Jignesh,

Thanks for your reply, i check DB data's. in the table one field,its returns Null value. but the thing is , i dont have idea, using to solve the issue from creating system.DBNull parameter. Can you please guide me tat how can i solve this issue from DB.

Thanks
Mubarak
0
Kunal Vaishya14y ago
Dear ,

Have you checked that GetDataSet function return some records or blank

may be some problem there is return null value please check return source

0
Jignesh Trivedi14y ago
hi,

I think you must Initialize data set.
try..
DataSet ds =new Dataset();
ds = service.GetDataSet("sp_smsinbox", "@action$#!@$@substr", "count$#!@$" + substr);
can u plese more info about getdataset method.
hope this help.
0