On 26 Aug 2005 16:38:28 -0700, ".Net Sports" <ba********@cox.net> wrote:
¤ Thanks for the help - . I would have to start this webform over to go
¤ into the VS.net sqldataAdapter wizard to do that. I would just need to
¤ put the data from my DataReader (drRevenue) into a sqlDataAdapter
¤
¤ here's my creation of the datareader
¤
¤ SqlCommand objCommand = new SqlCommand(strSQL, objConn2);
¤ objConn2.Open();
¤
¤ SqlDataReader drRevenue = objCommand.ExecuteReader();
¤
¤ I would now need to do something like:
¤
¤ da = new SqlDataAdapter(drRevenue);
¤
¤ but that is invalid, as SqlDataAdapter wants a command object
You're still using a DataReader. See the doc for an example of how to use the Fill method with the
DataAdapter:
http://msdn.microsoft.com/library/de...classtopic.asp
Paul
~~~~
Microsoft MVP (Visual Basic)