Hi all,
Why is the last line of this code snippit pulling up with an error? Any help
will be appreciated - Thanks, Steve.
string str_SQLLayoutsP ound = "SELECT * FROM Layouts ORDER BY Name";
OleDbCommand obj_SQLLayoutsP ound = new OleDbCommand( str_SQLLayoutsP ound,
obj_SourceConn );
OleDbDataReader obj_ReaderLayou tsPound = obj_SQLLayoutsP ound.ExecuteRea der();
while( obj_ReaderLayou tsPound.Read())
{
string str_CurrentReco rd = obj_ReaderLayou tsPound["Name"].ToString();
string str_SQLLayouts = "SELECT * FROM Layouts WHERE [Name] LIKE '" +
str_CurrentReco rd + "' AND Currency = 1" ;
OleDbCommand obj_SQLLayouts = new OleDbCommand( str_SQLLayouts,
obj_Destination Conn );
OleDbDataReader obj_ReaderLayou ts = obj_SQLLayouts. ExecuteReader() ;
if( obj_ReaderLayou ts.Read())
{
OleDbDataAdapte r obj_AdapterLayo uts = new OleDbDataAdapte r(
str_SQLLayouts, obj_Destination Conn );
DataSet obj_DatasetLayo uts = new DataSet();
obj_AdapterLayo uts.Fill( obj_DatasetLayo uts, "layouts" );
}
}
--
Message posted via DotNetMonster.c om
http://www.dotnetmonster.com/Uwe/For...sharp/200509/1