Re: Deployment for Visual C# 2010 Express - C# Discussion Boards

11-Mar-11 19:43

Hi,
1-
On my laptop, I have developed an application called MyApp in Visual C# 2010 Express which connects to sql server 2005 express.
Works fine.
2-
As you know there is no installation mechanism with c# 2010 express, so as a test, I copied all the files (.dll, .exe, pdb...) from the release folder and placed them into c:\program files(86)\MyApp
3-
When running the .exe in this folder, error is shown on the screen as "Login failed for user user1". Then when the continue button is clicked on the error message, the application form appears with all the controls but empty data.
4-
It seems there is a problem with the login to the sql server, BUT note that the login does exist in the sql server as the application works fine when I run it in the visual c# 2010 express environment when developing it.

5- In the application, there is a class library project (The .dll in this project) which uses the connectionstring in the app.config file.

What do y ou think the problem is please?
Thanks

Luc Pattyn11-Mar-11 19:55

Luc Pattyn

11-Mar-11 19:55

Read me[^].

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

arkiboys11-Mar-11 19:59

11-Mar-11 19:59

Thanks for coming back to me,
but note that I have mentioned that as I use the same machine to develop the application, the application is able to login to the database when running it through the development environment i.e. when I am developing the application but it fails when the .exe is run manually.
Any thoughts on that please?

Luc Pattyn11-Mar-11 20:07

Luc Pattyn

11-Mar-11 20:07

arkiboys wrote:
Any thoughts on that please?

Personally no, so I suggest you read up on the experience others have had and published about. Error messages tend to make very good Google search sentences.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

OriginalGriff12-Mar-11 2:34

OriginalGriff

12-Mar-11 2:34

Have you tried looking in your Debug folder?
I am reasonably sure you might find your data files in there...possibly including the file you store the login information in?

Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Manfred R. Bihy: "Looks as if OP is learning resistant."

arkiboys12-Mar-11 5:10

12-Mar-11 5:10

The connection string is in the settings of a class library project which is now a .dll file.
I have included this file but I get the ERROR as descrived before.
Thanks

OriginalGriff12-Mar-11 5:16

OriginalGriff

12-Mar-11 5:16

That is probably because the settings are stored in a ".config" XML file.
Check all of those in your debug directory, and you will probably find it.

Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Manfred R. Bihy: "Looks as if OP is learning resistant."

arkiboys13-Mar-11 11:55

13-Mar-11 11:55

Yes, I have found the config file in the debug folder and copied that also to C:\program files\AppName
But still ge tthe login failed error.
Not sure what is wrong because there is sql server and the login works as I can login using the application I have written when in the development environment.

jschell13-Mar-11 10:01

jschell

13-Mar-11 10:01

arkiboys wrote:
As you know there is no installation mechanism with c# 2010 express, so as a test, I copied all the files (.dll, .exe, pdb...) from the release folder and placed them into c:\program files(86)\MyApp

So you are copying on the binaries from C# and are not attempting a copy of SQL Server correct?

If yes then I would expect something is wrong with your code to do the login. As an example (only an example) you catch an exception and instead of reporting the exception error you report a failed login.

arkiboys13-Mar-11 11:56

13-Mar-11 11:56

Correct.
I am not copying the sql server because it is already installed with the database and login.
Pleas enote that the login works through the application when connecting to the database.

Setup File

Syed Shahid Hussain11-Mar-11 11:41

Syed Shahid Hussain

11-Mar-11 11:41

Hei All,

Can we install any big software via C# setup application? I want to install SQL Server before my application and then create user in sql server but I dont know how can i install SQL server via setup file?

Thanks

Syed Shahid Hussain

thatraja11-Mar-11 12:50

thatraja

11-Mar-11 12:50

Here you go

Embedding SQL Server Express into Custom Applications[^]
Walkthrough: Using a Custom Action to Create a Database at Installation[^]

Install sql server database with visual studio setup[^]

Fun with VS2008 Setup Package Pre-Requisites[^]

.NET Setup Deployment - MSI, Cassini, SQL Server, NTFS[^]

Deploy your Application and Database[^]

thatraja

My Tip/Tricks
My Dad had a Heart Attack on this day so don't...

Syed Shahid Hussain11-Mar-11 13:10

Syed Shahid Hussain

11-Mar-11 13:10

Hei Thatraja,

Thanks u so so so so much. You dont know how big treasure u have given to me.

I'm Happy Thanks once again.

Syed Shahid Hussain

Dave Kreskowiak11-Mar-11 12:51

Dave Kreskowiak

11-Mar-11 12:51

Best practice is that you don't do this. SQL Server is only supported as a seperate install.

Once the server is installed and running seperately, your application installer can be told which SQL Server to use and what the login credentials should be to execute a SQL script to add your users and setup the database and its security.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Syed Shahid Hussain11-Mar-11 13:12

Syed Shahid Hussain

11-Mar-11 13:12

Thanks for ur reply.

I'll read the setup process completely and keep in mind ur points while developing setup project.

Syed Shahid Hussain

Finding controls [modified]

Dalek Dave11-Mar-11 13:52

Dalek Dave

11-Mar-11 13:52

Simple answer is yes.

But, what the hell do you want to install?

------------------------------------

I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave

CCC Link[^]
Trolls[^]

Orcun Iyigun11-Mar-11 7:02

Orcun Iyigun

11-Mar-11 7:02

Hello all,

I have two questions.
1) I have labels and textbox.
For ex;

lblName1.Text = txtName.Text;
lblName2.Text = txtName.Text;
lblName3.Text = txtName.Text;
lblName4.Text = txtName.Text;

Is there a way that i can do that in a loop something like:

for(i=0; i<4; i++)
{
lblName[i].Text = txtName.Text; // of course it does not accept [i] Smile | :)

}

2) How can I find a certain type of a contol in a webform and change the controls property.

Ex; I have 10 checkboxes. without coding one by one. Is there a way that I can assign its check selected to false more proper way ;

cb1.Checked = false;
cb2.Checked = false;
cb3.Checked = false;
.
.
cb10.Checked = false;

Thanks.

modified on Friday, March 11, 2011 1:30 PM

OriginalGriff11-Mar-11 9:09

OriginalGriff

11-Mar-11 9:09

1) You can do it - sort of - with reflection, but it is one heck of a sledgehammer to crap a simple nut. What you end up with will be longer than the code to do it directly, and a lot harder to read and understand.
If you really want to access a number of controls in a loop, can I suggest the simpler, elegant way of having a class level list of labels?

List<Label>myLabels = new List<Label>();
...
myLabels.Add(lblName1);
myLabels.Add(lblName2);
myLabels.Add(lblName3);
myLabels.Add(lblName4);
...
foreach (Label lab in myLabels)
   {
   lab.Text = txtName.Text;
   }

2) Not sure what you mean here: are you trying to do the same as in (1) but for CheckBox? If so, then the same answer applies. If not, then what are you trying to do?

Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Manfred R. Bihy: "Looks as if OP is learning resistant."

Orcun Iyigun11-Mar-11 9:50

Orcun Iyigun

11-Mar-11 9:50

Well actually I mislead you on the first one it was like;
lblName1.Text = txtName.Text;
lblName2.Text = txtName.Text;
lblSurname1.Text = txtSurname.Text;
lblSurname2.Text = txtSurname.Text;

so seems like it is better for me to code it directly.

for the second one; after evaluating your answer, it seems like the solution for the second is the same with Q 1 Smile | :)

GenJerDan11-Mar-11 11:26

GenJerDan

11-Mar-11 11:26

Anyway, even though you've apparently changed what you need to do, what you originaly asked for *is* possible, relatively easily done, and only moderately dangerous. Laugh | :laugh:

for (int i = 0; i < 4; i++)
{
    (FindControl("lblName" + i.ToString()) as Label).Text = txtName.Text;
}

Pretty sure, anyway.

There is water at the bottom of the ocean.
My Mu[sic]
My Films
My Windows Programs, etc.

Orcun Iyigun11-Mar-11 11:32

Orcun Iyigun

11-Mar-11 11:32

Actually yeah that is what I tried to mean. That should do it thanks anyway though Smile | :)

but why is it dangerous?
I am guessing ;
During looping, when cant find a matching label name, it will throw an exception?

GenJerDan11-Mar-11 14:44

GenJerDan

11-Mar-11 14:44

Yep. There had better be controls to match the loop variable number, or ka-boom!

Also: if, for whatever reason, you ever need the controlks to be set in a certain order...don't count on it. The compiler will do the loop in whichever order it feels is best.

There is water at the bottom of the ocean.
My Mu[sic]
My Films
My Windows Programs, etc.

Luc Pattyn11-Mar-11 18:18

Luc Pattyn

11-Mar-11 18:18

Not tested, however I expect this should suffice:

for (int i = 0; i < 4; i++) FindControl("lblName" + i).Text = txtName.Text;

as each Control has a Text property, so no need to cast; and ToString() is implicit when appending to a string.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.