C# Discussion Boards - CodeProject

Re: Insert statement throws an exception

V.29-Nov-06 1:38

29-Nov-06 1:38

ACTION was a keyword. Stupid me, I already renamed the table to ACTION_SELF because I thought ACTIONS was a keyword, than I forget to check the columns... D'Oh! | :doh:

thanks it works now...

V.

Stop smoking so you can: Enjoy longer the money you save.
Moviereview Archive

Re: Insert statement throws an exception

Guffa29-Nov-06 1:48

Guffa

29-Nov-06 1:48

Yes, ACTION is a reserved keyword in JET4 (OLEDB) and ODBC, but not in the database itself.

---
b { font-weight: normal; }

Re: Insert statement throws an exception

V.29-Nov-06 2:01

29-Nov-06 2:01

horrible, and I tried to do [TABLENAME].[ACTION], but I couldn't fool it like that Unsure | :~

.
I guess I'll just have to rename it Smile | :)

.
Anyway, now I know what's going wrong Smile | :)

V.

Stop smoking so you can: Enjoy longer the money you save.
Moviereview Archive

Re: Insert statement throws an exception

ed^nrgc29-Nov-06 2:50

ed^nrgc

29-Nov-06 2:50

Open the statement in Query Analyzer or whatever else you use.

Remove columns in the statement until you locate the problem item (you may have to let nulls be placed in field temporarily).

ConfigurationManager raises an exception

manustone29-Nov-06 0:46

manustone

29-Nov-06 0:46

Hi all
I'm not able to use the ConfigurationManager class.
Each time I try to access to Application Settings I receive an exception.

In my App.config file I have

<!--General Settings--><br />
  <appsettings><br />
    <add key  =  "Author"   value = "manustone"  /><br />
  </appsettings><br />

inside <configuration></configuration>.

I added a reference to System.Configuration.dll

When in my code i use

<br />
string strAuthor = ConfigurationManager.AppSettings["Author"];<br />

I've got an exception.
Do you know where is the problem?

Regards
Manu Stone

Re: ConfigurationManager raises an exception

Eduard Keilholz29-Nov-06 1:15

Eduard Keilholz

29-Nov-06 1:15

What's the exception...

I don't know if this solves your problem...
change appsettings to appSettings in your app.config
remove the spaces after the key and value attributes

<br />
 <add key = "Author" value = "manustone" /><br />

<br />
 <add key="Author" value="manustone" /><br />

The rest looks fine to me... it those steps above don't work, we might require the exception message thrown...

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

Re: ConfigurationManager raises an exception

manustone29-Nov-06 2:42

manustone

29-Nov-06 2:42

Hi
I changed it but the same error occurs.
The excetpion error message is

"Configuration system failed to initialize"

How to initialize a Configuration Manager?

Re: ConfigurationManager raises an exception

manustone29-Nov-06 5:14

manustone

29-Nov-06 5:14

Finally I found the problem!!!

There was a character written just above the section that was corrupting the file.
Thanks for your help.

Regards
ManuStone

Re: ConfigurationManager raises an exception

Bassam Saoud29-Nov-06 1:21

Bassam Saoud

29-Nov-06 1:21

Do you get this error : "Unrecognized configuration section appsettings" ? if you do then change appsettings to appSettings as advised earlier , otherwise supply us with the exception you are getting.

Re: ConfigurationManager raises an exception

manustone29-Nov-06 2:40

manustone

29-Nov-06 2:40

Hi all
the excetpion error message is

"Configuration system failed to initialize"

How to initialize a Configuration Manager?

Re: ConfigurationManager raises an exception

manustone29-Nov-06 5:15

manustone

29-Nov-06 5:15

Finally I found the problem!!!

There was a character written just above the section that was corrupting the file.
Thanks for your help.

Regards
ManuStone

Re: ConfigurationManager raises an exception

ed^nrgc29-Nov-06 3:04

ed^nrgc

29-Nov-06 3:04

Just a shot in the dark, rename appsettings to appSettings

Re: ConfigurationManager raises an exception

manustone29-Nov-06 5:01

manustone

29-Nov-06 5:01

Yes I agree!!!
Do you know if Do I need to do some settings in the Project Settings to activate this ConfigurationManager class?

Re: ConfigurationManager raises an exception

manustone29-Nov-06 5:15

manustone

29-Nov-06 5:15

Finally I found the problem!!!

There was a character written just above the section that was corrupting the file.
Thanks for your help.

Regards
ManuStone

How to Pass Paramaters to CrystalReports ?

hdv21229-Nov-06 0:41

hdv212

29-Nov-06 0:41

hi i want to pass some parameters to crystal reports but how to do that ?
i tried to pass parameters to Crystal reports by ParameterFields properties but it's could not pass my value to crystal reports fields.
please give me a tested example for vc# 2005 ..
thanks

Form.Activeform shows Undefined value

ASGuru29-Nov-06 0:29

ASGuru

29-Nov-06 0:29

frmMdiZNMS myform1;//frmMdiZNMS is the parent form

myform1 = (frmMdiZNMS)frmMdiZNMS.ActiveForm ;

if(myform1 != null)
{
//isSerialConnected is the serialport connection status
if(myform1.isSerialConnected==true)
{
//write is used to write the data through serial port using RS232 Application
myform1.serPort.Write(myform1.paninfo.ClearBindingRequest(srcaddress,destaddress));

myform1.paninfo.Events.Add(new Event(0,"Clear Binding table request sent.",(int)EVENT_TYPE.INFORMATION));

}
else
{
myform1.paninfo.Events.Add(new Event(0,SERIAL_NOT_CONNECTED,(int)EVENT_TYPE.CRITICAL));
return;
}
}

In this method every time myform1 should shows undefined value.
So I cant able to write the data in to the serial port.
Please do the needful

Thanks & Regards
AsGuru

Re: Form.Activeform shows Undefined value

Martin#29-Nov-06 1:03

Martin#

29-Nov-06 1:03

Hello,

Do you mean the static property "System.Windows.Forms.Form.ActiveForm"?

Maybe this works:
frmMdiZNMS myform1 = (frmMdiZNMS)System.Windows.Forms.Form.ActiveForm;

or
frmMdiZNMS myform1 = System.Windows.Forms.Form.ActiveForm as frmMdiZNMS;

All the best,

Martin

Diable /enable Top Down button in printpreviewDialog when reached end page or first page

GauravRahi29-Nov-06 0:14

GauravRahi

29-Nov-06 0:14

I am using PrintPreviewDialog to preview the contents.While previewing,when i reach the first page or the last page then also the top arrow or the down arrow buttons(in side of current page number display) does not get disabled . How can i disable them in such a situation

Gaurav Rahi

SerializedExceptionExtension

Rohit Pandhi28-Nov-06 23:44

Rohit Pandhi

28-Nov-06 23:44

Hi all
if i add the attribute SerializedExceptionExtension to mine web method will i still need to cast the exceptions thrown in SoapException.

Thanks in advance

An invalid VARIANT was detected

MANOJ BATRA28-Nov-06 23:20

MANOJ BATRA

28-Nov-06 23:20

I am getting following error

An invalid VARIANT was detected during a conversion from an unmanaged VARIANT to a managed object. Passing invalid VARIANTs to the CLR can cause unexpected exceptions, corruption or data loss.

while using a component in .Net (C#) Project. Please let me know its solution.
Confused | :confused:

With Regards
Manoj

Re: An invalid VARIANT was detected

ed^nrgc29-Nov-06 3:12

ed^nrgc

29-Nov-06 3:12

Are you looking for GetObjectForNativeVariant()?

Seeking: Panel Opacity & Border

adrianna_r28-Nov-06 22:42

adrianna_r

28-Nov-06 22:42

Hello,

Beginning with the hard bit first, I have recently started looking for a way to control a panel's background's opacity, and have not encountered a fully explained C# solution (though there are quite a lot of VB ones, which I sadly only managed to gape at without understanding a thing).

I have seen the way to make it completely transparent[^], and I have encountered a way to create opacity for a PictureBox's image[^]... but attempts to combine the two have failed miserably.

I assume that once I get the transparent background thing going, drawing a non-transparent border (perhaps using some of the code from here[^]) would be easy enough to figure out (though if it clashes with the opacity goal, then I would like to know how/why).

I'd appreciate any tips/links/code bits/etc.
Thanks.

-M.

Re: Seeking: Panel Opacity & Border

Martin#28-Nov-06 23:43

Martin#

28-Nov-06 23:43

Hello,

I had the same problem, by using a backgroundimage on a Form.
There are some solution (property "TransparencyKey") that are not working for every graphic card.

This works:

			Bitmap bm = new Bitmap(...);<br />
			Color transparent = bm.GetPixel(0,0);<br />
			bm.MakeTransparent(transparent);<br />
<br />
			this.BackgroundImage = bm;

What I found out is, that you can not change the opacity after you made it transparent. (Ok, you can but transparency doesn't work after that.)
After you change opacity you have to "MakeTransparent" again.

I know it's not much, but maybe it helps.

All the best,

Martin

Re: Seeking: Panel Opacity & Border

adrianna_r28-Nov-06 23:54

adrianna_r

28-Nov-06 23:54

Hmm... I think there may have been a misunderstanding.

What I'm trying to do is create a panel with opacity, so that when I move it around over other controls, the other controls are visible under it, but the panel's background is still shown, just faded according to its opacity value. Something to the effect of looking at the world through a piece of colored cellophane...

If I understand your suggestion correctly, that code will make my panel transparent, but I want it to still be visible, but faded.

-M.

Re: Seeking: Panel Opacity & Border

Martin#29-Nov-06 0:01

Martin#

29-Nov-06 0:01

Hello,

adrianna_r wrote:
If I understand your suggestion correctly, that code will make my panel transparent, but I want it to still be visible, but faded.

Only the color of the specified bixel will be transparent.

Martin

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.