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

Question

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

Jignesh Trivedi · Answer

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.

Kunal Vaishya · Answer

Dear sorry but we cat understand what you have codede in GetDataSet function give me source code so we can help you

AL MUBARAK · Answer

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

Kunal Vaishya · Answer

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

AL MUBARAK · Answer

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]; }

Jignesh Trivedi · Answer

hi can u please share code of GetDataSet method? I think this will usefull to resolved issue. thx.

Kunal Vaishya · Answer

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

AL MUBARAK · Answer

Dear Kunal & Jignesh Thanks for your reply i check DB data's. in the table one fieldits 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

Kunal Vaishya · Answer

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

Jignesh Trivedi · Answer

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.