Wednesday, March 07, 2007

QueryAnaliser sample

I have updated my QueryAnaliser sample . All javascript code is on the js file( as it should be)
and the code is Object Oriented. No more global variables ( just one) ...
and some scope changes.
I have learned a lot from looking at ext code.


Anonymous said...

hi Rodrigo,

i'm playing with your QueryAnalyzer (thanks for the sample!) but i can't get it to work.

it looks like you have some technique (of which i'm not aware of...and very interested in) of referencing your Util.cs without explicitly referencing the assembly (e.g. import Util).

your Util.cs is in the same directory as the source but does it need to be compiled into an assembly? or am i missing something? thanks!

rodiniz said...

The is no secret ,actually the Util.cs is on my app_code folder.
There is no dll. If you put on a dll then you would have to add a refrence and use the "using" statement

Anonymous said...


I want to try your query analyser. However the following files are missing from the package.


I have downloaded yui 2.2.0a and ext 1.0 but cannot find these files. Could you please point me in the right direction? or preferably include all necessary files in the download file?

T .J .

rodiniz said...

css/yui-ext.css -
this is ext-all.css( from ext 1.0)
css/ytheme-aero.css-- this file comes with ext
scripts/yui.js this is the same as yui utilities.js
this comes with ext 1.0
ext-all.js( from ext 1.0)

Anonymous said...

Thank you very much for clearing that up.

Is there anyway to get this working for a Microsoft Access database - I keep getting this error:

Exception Details: System.ArgumentException: Keyword not supported: 'provider'.

Source Error:

Line 147: }
Line 148: SqlConnection con = new SqlConnection();
Line 149: con.ConnectionString = ConfigurationManager.ConnectionStrings[configName].ConnectionString;
Line 150: con.Open();
Line 151: SqlCommand cmd = new SqlCommand();

The connection string I use is...

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mypath\mydb.mdb;Persist Security Info=True;Jet OLEDB:Database Password=mypassword;

Thanks very much


rodiniz said...

You cant use the SqlConnection class
to connect to access you have to use the OleDbConnection class.
And the configuration is different also. Your connection string is ok. But my code is for SqlServer.