How To Overcome Query Engine Error - C# Discussion Boards

hello

i need some documentation and sample how to use remoting. i don't find noting interesting on web.

thanks,
mihai

The best text in the world on remoting: Advanced .NET Remoting by Ingo Rammer

His website also provides alot of information, the first 8 sites that came up in Google provided lots of information, and I believe there is an article here on code project that gives a client/server chat example using remoting. I suggest you improve your search skills.

Does someone have some references on the commands ADPU for access to the smartcards?
I am trying to read the data from a smartcard using the winscard.ddl API . I succeed in connecting to the card but I don't find information on what commands to send Cry | :((

thanks

Good luck.

SmartCard commands are typically specific to the particular card involved, and depending upon what the card is and what it is used for, you will likely never be able to get that information. The ISO specification (It has been too long... I don't even remember which one it was.) only defined a very few "generic" commands, and as I recall, they were just suggestions anyway.

I used to work for a company that developed its own SmartCard reader, and just to get sample cards and the command documentation to test with the reader, we had to jump through all kinds of legal hoops with the SmartCard vendors, involving all kinds of Non-Disclosure agreements, etc.

Don't hold your breath... Sigh | :sigh:

Tom

hi all, can someone help me how to link up multiple forms in VS 2003? i mean when i debugged, i clicked a "link" in form 1 how to get to form 2??
i appreciate experts out there can teach me the coding.. thanks in advance Smile | :)

Use the event LinkClicked from LinkLabel and use this code:

Form form = new Form();
form.ShowDialog();
or
form.Show();

skyeddie wrote as the subject line:
C#

Whoda thunk it! A C# question in a C# forum. Please make your subject lines more meaningful. For example the subject "Link up multiple forms in VS 2003" would be much better.

i am using this code to print a report but the problem comes when i pass parameters like Supplier_Id as i have done in this query the error comes like "Query engine Error and follows with the path.I am using this code.Well the problem doesn't comes with the query in which i have not passed parameters Pls help me to sort out this problem.Thanks Fahad.

try
{
int Supplier_Id=Convert.ToInt32(Supplier_Id_C.Text);
string s_p="sp_P_S_Rpt";
SqlConnection conn = Class_Connection.Make_Conn();
// SqlCommand command = new SqlCommand(s_p, conn);
// command.CommandType = CommandType.StoredProcedure;
// command.Parameters.Add("@Supplier_Id", SqlDbType.Int);
// command.Parameters["@Supplier_Id"].Value = Supplier_Id;
// SqlDataAdapter adapter = new SqlDataAdapter(command);
// DataSet ds = new DataSet();
// adapter.Fill(ds, "P_S");
//

// dataGrid1.DataSource=ds;
// dataGrid1.DataMember="P_S";
// P_R_Rpt obj = new P_R_Rpt();
// obj.SetDatabaseLogon("sa","sa","CDMA","Final_Project1_e");
// obj.SetDataSource(ds);
// crystalReportViewer1.ReportSource=obj;
// Cursor = System.Windows.Forms.Cursors.Default;
//reportDocument1.SetDatabaseLogon("sa","sa","CDMA","Final_Project1_e");

// reportDocument1.SetDataSource(ds);
// crystalReportViewer1.ReportSource = reportDocument1;

// Finalized.P_R_Rpt obj = new P_R_Rpt();
// obj.SetDatabaseLogon("sa","sa","CDMA","Final_Project1_e");
// reportDocument1.SetDataSource(ds);
// crystalReportViewer1.ReportSource = reportDocument1;

SqlCommand command = new SqlCommand(s_p, conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Supplier_Id", SqlDbType.Int);
command.Parameters["@Supplier_Id"].Value = Supplier_Id;
SqlDataAdapter adapter = new SqlDataAdapter("SELECT dbo.Supplier.Supplier_Name, dbo.P_Order.P_O_Date, dbo.P_Order.P_O_Serial_No, dbo.P_Order.P_O_Id FROM dbo.P_Order INNER JOIN dbo.P_O_Details ON dbo.P_Order.P_O_Id = dbo.P_O_Details.P_O_Id INNER JOIN dbo.Supplier ON dbo.P_O_Details.Supplier_Id = dbo.Supplier.Supplier_Id WHERE(dbo.P_O_Details.Supplier_Id = 2)","Data Source=CDMA;Database=Final_Project1_e;UID=saASSWORD=sa");// = new SqlDataAdapter(command);
//P_R ds = new P_R();
//SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
adapter.Fill(ds,"P_R_Rpt1");

dataGrid1.DataSource=ds;
dataGrid1.DataMember = "P_R_Rpt1";
//P_R ds = new P_R();
// P_R_Rpt obj = new P_R_Rpt();
// obj.Load();
// obj.SetDataSource(ds);
P_R_Rpt1 obj = new P_R_Rpt1();
obj.SetDataSource(ds);
//obj.Load();

//sample_Rpt1.FilePath = @"C:\\Documents and Settings\\Fahad\\Desktop\\Finalized_With_Report\\Sample_Rpt.rpt";
obj.SetDatabaseLogon("sa","sa");//oRpt.SetDataSource (ds);

crystalReportViewer1.Visible=true;//CrystalReportViewer1.Visible=true;
crystalReportViewer1.DisplayGroupTree=false;
crystalReportViewer1.ReportSource = obj;//CrystalReportViewer1.ReportSource = oRpt;
//obj.Load();
//obj.Refresh();
// crystalReportViewer1.RefreshReport();//.RefreshReport()
// crystalReportViewer1.Refresh();//crystalReportViewer1.Refresh()
// crystalReportViewer1.Show();//crystalReportViewer1.Show()

}
catch(Exception ee)
{
MessageBox.Show(ee.Message);
}

Keep your post in 1 thread...!!

How to use windows XP remote desktop services through .net application

Rizwan Afsar
Associate Member, Technical Team
IAP Company Ltd, Gurgaon
INDIA
www.iap-online.com

"A winner is not the one who never fails,
But one who NEVER QUITS"

I have a page of text painted on a tabpage panel. But I cannot highlight the text on it. How can I do it?

Thanks

I assume, from your question, that you are doing the following:

1) override void OnPaint()
2) doing a graphic.DrawString()

You will not be able to select text in that situation. The only way you can have selectable text is to replace the owner-paint function with populating a control that is meant for text selection....like, oh say textbox???!!!!!

I am developing Login Control where the user can enter username and password. in the Username and password box i should restrict the user from entering Special Chars, and other invalid keys.

i know i can compare the the value in Keydown event using Keys.Keycode, but it is very ugly to put all the Spl char comparision like if(e.Keycode==Keys.Enter || etc..). Is there any function or way to Compare the key pressed is a spl. char or not.

Thanks and Regards
Srini

Try MaskedTextBox!

But filtering using KeyDown is still my preference.

-K

Jup

Think outside the box!!!!!

You have a group of keys that you want to have disallowed from entry in a textbox. So a simple solution to this would be something like this:

List<Key> invalidKeys = new List<Key>();
        ...
private void ThisForm_Load()
{
     invalidKeys.Add(Keys.Enter);
     invalidKeys.Add(Keys.Ctl);
      ...
}

       ...
// keypress event handler
     if ( invalidKeys.Contains(e.Keycode) )
         e.Handled = true;

-- modified at 9:49 Thursday 13th July, 2006

"frmAdmin" is a value of a string variable.
There is a Form class in that name too.

i get this string value during run time.
how can i instantiate a form of which the class name is the string value ?

supun

-- modified at 0:59 Thursday 13th July, 2006

Use Activator.CreateInstance() method:

Type formType = Type.GetType("MyNamespace.frmAdmin");
frmAdmin form = (frmAdmin)Activator.CreateInstance(formType);
form.Show();

This will work if frmAdmin is defined in the same assembly. Otherwise use CreateInstance() with other parameters.

Thank you very much Andrew.

Supun

Hi all,

I have set an image to the Background of the form,
Now the image consists of a circle in blue color and the rest area is
black in color and i want this part to be transparent so that the form
looks Circular in shape.

I have gone thru http://www.codeproject.com/csharp/customforms.asp[^]
to do the above part.

But this link specifies that the VGA should be set to 1 bit,
I tried that and the form looked circular but the blue circle had some rough border,
i want the image to have a soft look and also that should work on 32 bit VGA

Thanks & Regards,
Pramod

Read this article.

Best regards, Alexey.

I want to create CHM Help file programmatically in C#. Basically I want to create documentation for my tables and stored procedures.

I did lot of searching on net but what I found is "HTML to CHM".
So What I think is,
1) I will create html files programmatically
2) Using some complier or some batch command or some thing, I will create CHM files

But some article points that you can use CHM file as a help in your .NET Application & some where it is written that System.Windows.Forms.Help can be used for it so there must be some way.

Can anyone give me some idea or some right direction?

Just I need fire, Then I will do it.

Nilesh Gambhava,
Life is NP-Complete so don't use Algorithm but use Heuristics

Hi,
To use .chm-file in your application as help file you can use HelpProvider class.

appHelp = new HelpProvider();
appHelp.HelpNamespace = "MyApplication.chm";

And then use SetHelpNavigator(), SetHelpKeyword(), SetHelpString() and other methods.

Thanks for quick response.

But I am not getting it.

I want to create new CHM file, I dont want to use CHM file as help

Nilesh

Nilesh Gambhava,
Life is NP-Complete so don't use Algorithm but use Heuristics

Like a 'critical system process'

What i really need is to stop people form closing a security app through the command line. So if theres any way to do that then, yeah.

try building a windows service that and set the stop property to false.

Do your best to be the best