Expert one-on-one: VB.NET Business Objects ! :rolleyes: Written by Rockford Lhotka and published by Wrox Press Wrox Press has become insolvent and has gone into liquidation and only 3500 copies of the book were printed and distributed. Luckly I managed to get a copy of this beauty!! :laugh::cool:

In the Worldcup Portugal-Korea game of last friday, the first Portugal player to be sent out apparently hit the referee just about seconds after he was shown the red card!!! Amazing stuff...:wtf: here's the link: http://www.onefootball.com/index.phtml?page=fullstory&competition\_id=128&newsid=115931&

Seems that using a parameterized query as a SelectCommand for an OleDbDDataAdapter to fill a DataSet doesn't work! The following code is how I'm doing that. All the code is inside an try/catch block. The language i'm using is C# // Using a UDL file for the connection string string strDBConn = "FileName=D:\Contacts.udl;"; // Sets up the connection OleDbConnection conn = new OleDbConnection(strDBConn); conn.Open(strDBConn); // Creates a new command OleDbCommand cmd = new OleDbCommand( "select * from dbo.Contacts where contact_id = ?", conn); // Sets up the Data Adapter OleDbDataAdapter da = new OleDbDataAdapter(); da.SelectCommand = cmd; // Sets the Command parameters param = da.SelectCommand.Parameters.Add ( "@contact_id", OleDbType.Numeric, 9, "entid_id"); param.Value = 1; // The parameter value // creates a new DataSet DataSet dsResult = new DataSet() // Fills the DataSet da.Fill(dsResult); Somehow in the last instruction it generates an exception that even 'catch (Exception e)' can't get exactly because in spite of falling in this catch block the 'e' (the exception) is null! But the reason he is throwing some weird exception is because the parameters are not being declared first before querying the database with the parameterized select command and consequently the string that is being sent is only "select * from dbo.Contacts where contact_id = @P1" and nothing else. I'm using a .UDL file to set my connection string which is set with valid parameters because it's being used everywhere else in the app and it works perfectly. My Database is SQL Server 2000... Yeah, of course I could use SqlDataAdapter and all the other classes specific for SQL Server but the fact is that I want to use an .UDL file to set my datasource and the only way to do this is using the OleDb... classes. UDL files doesn't work with SqlConnection in case you didn't know. So... am I doing something wrong here in setting the Data Adapter to a parameterized query? Is this a bug in the .NET framework? Can you help me out with this? Thanks in advance :) Best Regards, Paulo

Maybe you can try this one: http://www.devexpress.com/products/net/xtrabars/index.asp :omg::omg::omg: :-O beware that this product is still in beta but it will be released soon :laugh::cool:

Glad to read all that you all have said :-D Reading that article for a moment i thought i was in another planet ... :eek: By the way what the hell is wrong with the press??? Anybody knows that java just stinks. Why the hell is the propaganda for? :mad: The press is supposed to tell the truth, isn't it?

C++Builder is a bit slow comparing to Delphi in building the projects - what it takes 1 sec compiling in delphi, it takes aprox. 10 secs in Builder - and why? Because in compiling the units, C++ Builder has to produce .OBJ's which are way more dificult to build than the Delphi Units (the .DCU files) due to the far more complex (and way way more POWERFUL) syntax of C++. So my point is that C++ should have been the language on which VCL framework should have been built and not definitely Pascal (even considering the more time consuming builds). Choosing Pascal was one BIG mistake but choosing C++ in that time they'll always have to live with the direct competition of visual c++ i guess... What i think that Borland should have done was to take C++Builder to produce the VCL components and Delphi to use them! Just that simple... Hope one day Chris dedicates one section of his site to C++Builder... It's a great product and a great tool to partner with Visual C++. :)