Re: Database Connectivity Error.... - C# Discussion Boards

Re: converting a visual C# code itno an .exe format

Hesham Yassin10-Jun-07 5:29

10-Jun-07 5:29

Hi
enter to the project properties by clicking right click on the project at the "Solution Explorer" in visual studio 2005 and then enter to publish and click the "Publish Now" or "Publish Wizard..." command!

Web .config

Tauseef A7-Jun-07 21:18

Tauseef A

7-Jun-07 21:18

Hi guys

actualyy i am very much new to dot net

i am using fram work 1.1 . i want to read from web.config gile in my application
but i am not getting that can any body tell me the exzact syntax,,

my web.config is as follows

<configuration>
<appsettings>my text here<\appsettings>
<connectionstring> my connection string here<\connectionstring>

thanks in advance

hello

Hi g

Re: Web .config

Russell Jones7-Jun-07 22:32

Russell Jones

7-Jun-07 22:32

In web. config:

<connectionStrings><br />
    <add name="ConnectionName" connectionString="blah blah blah"/><br />
 </connectionStrings>

In the app:

<br />
ConfigurationManager.ConnectionStrings["ConnectionName"].ConnectionString;<br />

I'm using MySQL for adb at the moment so i removed the connection string stuff

HTH

Russ

Re: Web .config

Manas Bhardwaj7-Jun-07 22:57

Manas Bhardwaj

7-Jun-07 22:57

ConfigurationManager.ConnectionStrings will only help in reading the text in ConnectionStrings section.
To read in appsettings use ConfigurationSettings.AppSettings.Get("Name")
Hope this helps

Re: Web .config

blackjack21508-Jun-07 0:55

blackjack2150

8-Jun-07 0:55

Wouldn't this work for you?

string cs = Form1.Properties.Settings.Default["connectionstring"];

Where you replace Form1 with the namespace of your application.

Database Connectivity Error....

codingrocks7-Jun-07 20:59

codingrocks

7-Jun-07 20:59

I am doing a windows application.. I was working well with it and suddenly a form shows error...

i am using stored procedures to insert and retrieve data ...and it seems that the stored procedure is correct..

in C#.net code

command.ExecuteNonQuery();

the error handler points to this and puts error

"Failed to convert parameter value from a String to a Int32."

SAJAN A PILLAI

C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE

Re: Database Connectivity Error....

AikinX7-Jun-07 21:11

AikinX

7-Jun-07 21:11

sajan ss wrote:
"Failed to convert parameter value from a String to a Int32."

sajan ss, This error says that you mistakenly provide String instead of int to stored procedure.

Could you give us more code for analyze.
I want to get the listing where you are filling the stored procedure parameters and signature of calling stored procedure.

Re: Database Connectivity Error....

Muammar©7-Jun-07 21:41

Muammar©

7-Jun-07 21:41

There's not much you're showing from your code, but if you're sure the error is fired exactly from that line, then double check your stored procedure parameter values and make sure the types are matching.

Cheers,

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: Database Connectivity Error....

codingrocks7-Jun-07 22:05

codingrocks

7-Jun-07 22:05

thanks for that information....

type mismatched ...

i made it correct.....

SAJAN A PILLAI

C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE

About Ticker in C# Windows Application ,how to solve this problem?

sarathyheart807-Jun-07 20:48

sarathyheart80

7-Jun-07 20:48

Hello Friends,
I hope your are help to me
I have using VS2005 and XP prof
I developing Ticker module
When i open the Ticker it's display top of the screen
Now I open any window(mycomputer,any folder like that)opened but that window close button inside the Ticker,So I couldn't close that window.

I want when i open Ticker at the time, if any window open all are open bellow the Ticker
What i do and how to solve this problem?
plz help to me

parthasarathy

Re: About Ticker in C# Windows Application ,how to solve this problem?

sharmit7-Jun-07 22:38

sharmit

7-Jun-07 22:38

if u r thinking of something like a splash screen which shuld be available always on top of all the application, set the splashscreen form property- TopMost to true

want to make uninstaller

devesh_code7-Jun-07 20:32

devesh_code

7-Jun-07 20:32

Hello

I want to make an Uninstaller in Visual Studio. I have already made the Installer in Visual Studio.

Reply me asap.

Thanks

Devesh Mishra

Re: want to make uninstaller

Christian Graus7-Jun-07 20:43

Christian Graus

7-Jun-07 20:43

The installer IS the uninstaller. Your program will get added to the add/remove programs list when you install it

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: want to make uninstaller

devesh_code7-Jun-07 20:48

devesh_code

7-Jun-07 20:48

Thanks for ur reply..

Yah i know that my program will get added to the add/remove programs list when i install it. But i dont want to uninstall it from control panel. I want to uninstall it from start menu.

Thanks

Devesh Mishra

Re: want to make uninstaller

Muammar©7-Jun-07 22:05

Muammar©

7-Jun-07 22:05

Just add a shortcut of the uninstaller to the right folder
Drive:\Documents and Settings\YourUser\Start Menu\Programs\YourAppFolder\Uninstall.exe //for a specific user "usually current by matching the current user System.Environment.UserName with the special folder"
or:
Drive:\Documents and Settings\All Users\Start Menu\Programs\YourAppFolder\Uninstall.exe //for all users

ps. Of course you'll have to check your folders locations using System.Environment.SpecialFolder.ProgramFiles

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: want to make uninstaller

devesh_code8-Jun-07 0:05

devesh_code

8-Jun-07 0:05

I think u r not getting me what i need...
I want to make Uninstall.exe using Visual studio.You are saying to add me the shortcut of Uninstaller. But i dont have Uninstaller.exe. Got it ???
Reply me asap.

Thanks

Devesh Mishra

Re: want to make uninstaller

Dave Kreskowiak8-Jun-07 4:16

Dave Kreskowiak

8-Jun-07 4:16

All you have to do is add ashortcut with the command line to invoke msiexec</code. with the <code>/x option and the correct .MSI file name OR Product Code.

msiexec /x filename.msi

msiexec /x productcode

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: want to make uninstaller

devesh_code8-Jun-07 4:41

devesh_code

8-Jun-07 4:41

Thanks for ur reply...

I am doing the same whatever you are saying to do...But its not happening....
I got a message box and it shows "This installation package could not be opened"

Now what should i do...
Thanks

Devesh Mishra

Re: want to make uninstaller

Dave Kreskowiak8-Jun-07 10:15

Dave Kreskowiak

8-Jun-07 10:15

Did you supply the FULL path to the .MSI file? A better option would be to use the Product code instead.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

confused arabic when reading from excel-file

Pixinger777-Jun-07 20:29

Pixinger77

7-Jun-07 20:29

Hi
I have an excel-table wich i use for a translation project. left side english right side the language that needs to be translated. I wrote a program that parses this table and will merge it with the C# resx files. in chinese it works very well but in arabic i fell into some problems.

I can see this text in the excel table:
{النتيجة الإجمالية - {0

If I convert the text, I finally get something like that (there is something twisted):
النتيجة الإجمالية - {0}

By the way, the same thing happends if you copy the cell from excel and paste it into the notepad.

I tried to convert the string by using system.text.encoding... but didn't get far.
Any suggestions or hints how to handle this problem?

Thanks in advance, greets Snow.

Re: confused arabic when reading from excel-file

Muammar©

7-Jun-07 21:38

Hey Snow Flake!
Encoding has nothing to do with it in that case, just try to set the Right to left and Right to left layout properties of the destination control to true, it should work fine then.

Cheers.

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: confused arabic when reading from excel-file

Pixinger778-Jun-07 0:01

Pixinger77

8-Jun-07 0:01

Worked for 100%, thanks for your help (even when this leads me into some new problems Smile | :)

Re: confused arabic when reading from excel-file

Pixinger778-Jun-07 0:02

Pixinger77

8-Jun-07 0:02

Does arabic really work with totally mirrored desktops? I didnt keep this in mind Frown | :-(

How to annul Drag formBorder for resize ？

jason_mf7-Jun-07 20:27

jason_mf

7-Jun-07 20:27

if(height <= 100)
{
//annul Drag top and bottom border,for stop resize
}
else
{
//come back Drag
}

if (width <= 100)
{
//annul Drag left and right border, for stop resize
}
else
{
//come back Drag
}

how to do?
thanks.

Re: How to annul Drag formBorder for resize ？

jason_mf7-Jun-07 20:42

jason_mf

7-Jun-07 20:42

I get a miss,
do not annul resize,
stop becoming low or narrow only.

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