Hint and tips about the .net Framework and the internet.
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.
6 comments:
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!
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
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 sorcecode.zip download file?
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 scripts/ext-yui-adapter.js this comes with ext 1.0 scripts/yui-ext.js ext-all.js( from ext 1.0)
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();
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.
6 comments:
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!
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
Hello,
I want to try your query analyser. However the following files are missing from the package.
css/yui-ext.css
css/ytheme-aero.css
scripts/yui.js
scripts/ext-yui-adapter.js
scripts/yui-ext.js
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 sorcecode.zip download file?
Thanks.
T .J .
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
scripts/ext-yui-adapter.js
this comes with ext 1.0
scripts/yui-ext.js
ext-all.js( from ext 1.0)
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
T.J.
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.
Post a Comment