NullReferenceException updating a DataSet rows

yoord · August 30th, 2004, 07:00 AM

hi every one i am getting this error when i am trying to update a row in table that i was created a row and assigned it some value and
add it to DataSet using Adding to DataSet using this code

Code:

 SqlConnection objSqlConnection=new SqlConnection(strConnection);
 SqlDataAdapter  objDataAdapter=new SqlDataAdapter("select id,count_all from counters",objSqlConnection)
try
{
   string selectCmd="update counters set count_all=@count where id=1";
   SqlDataAdapter myCommand = new SqlDataAdapter(selectCmd,objSqlConnection);
   DataSet objDataSet=new DataSet();
   objDataAdapter.Fill(objDataSet,"counters");
// this portion of code dont work correctly nd seems dont intiate an object
    

	Quote:
	
	
		
			
				quote:DataTable objDataTable=new DataTable();
			
		
	
	



	Quote:
	
	
		
			
				   objDataTable=objDataSet.Tables["counters"];
   DataRow objNewRow=objDataSet.Tables["counters"].NewRow();
   objNewRow["count_all"]=100;
   objDataSet.Tables["count_all"].Rows.Add(objNewRow);
			
		
	
	

      objDataAdapter.Update(objDataSet,"counters");
   SqlCommandBuilder objCommandBuider=null;
   objCommandBuider=new SqlCommandBuilder(objDataAdapter); 
   objDataAdapter.UpdateCommand=objCommandBuider.GetUpdateCommand();
   objDataAdapter.Update(objDataSet,"counters");

Thanks In Advance .
YoOrD.

Beauty Is not in the face
Beauty is In the heart
--<<Ghibran Khalil>>--

bmains · August 30th, 2004, 07:38 AM

Hey,

Your select statement is an update statement. That's probably causing huge problems right there:

string selectCmd="update counters set count_all=@count where id=1";

Brian

yoord · August 30th, 2004, 09:51 AM

Thanks for your replies.
what changes i must pply to them to work correct.
if i must change selectCommand to a select command(a select query only)is it what you like that i must to change.
Thanks In Advance.
YoOrD.

Beauty Is not in the face
Beauty is In the heart
--<<Ghibran Khalil>>--

yoord · August 30th, 2004, 10:00 AM

i m change it to a select query but the problem persists.

Beauty Is not in the face
Beauty is In the heart
--<<Ghibran Khalil>>--

bmains · August 30th, 2004, 02:34 PM

Hey,

You are going to need to provide the update statement also to the UpdateCommand, to get SQLDataAdapter.Update to work also.

Brian

yoord · September 1st, 2004, 04:04 AM

I dont what changes i must appy to the code to work corect.
if you can give an example.
Thanks In Advance.
YoOrD.

Beauty Is not in the face
Beauty is In the heart
--<<Ghibran Khalil>>--

bmains · September 1st, 2004, 09:14 AM

http://msdn.microsoft.com/library/de...datetopic2.asp

yoord · September 1st, 2004, 03:49 PM

thanx 4 your replies.
YoOrD.

Beauty Is not in the face
Beauty is In the heart
--<<Ghibran Khalil>>--