Deployment issue in c# winform application

Question

0.00/5 (No votes)

See more:

Hi I have developed winform application in c# it was working fine in may development pc i have created installer package and deployed in another pc (Server 2008) part of the module is to get excel file display all records in a datagrid and was able to do all of these, get the excel file from a certain location,was able to logged in but when saving to the database it got an error(System.IO.Filenotfoundexeption).

Please help.

Posted 15-Dec-13 14:43pm

JOEY G. MOYA

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2013-12-15T15:00:00

Solution 1

There's no way to tell you exactly what's wrong with your code because of the complete lack of detail on what your choice is supposed to be found at the time of the error and what that code looks like.

The meaning of the error is quite obvious. You tried to open a file someway and the file path you have doesn't exist.

Posted 15-Dec-13 15:00pm

Dave Kreskowiak

Comments

JOEY G. MOYA 16-Dec-13 0:14am

Yes, I Agree based on the error message but actully to give you more details, I was able to logged to the winform application which means i was able to connect to the database, i was able to open an excel file and was able to display to data gridview the records from an excel file which i was able to open the error came out when a button i clicked which contains saving of each row from grid data to the SQL SERVER

string InsertDetails = "INSERT INTO CycleDetails " +
"([postal] " +
",[province] " +
",[courier]" +
",[delivrydln]" +
",[MobileNo]" +
",[invno]" +
",[acctno]" +
",[soadte]" +
",[name]" +
",[billno]" +
",[tracerno]" +
",[clientID],[cycle],batchno,address,lname,fname)" +
"VALUES " +
"('" + GridForUpload.Rows[i].Cells[0].Value.ToString().Replace("'", "''") + "' " +
",'" + GridForUpload.Rows[i].Cells[1].Value + "'" +
",'" + GridForUpload.Rows[i].Cells[2].Value + "'" +
",'" + GridForUpload.Rows[i].Cells[3].Value + "'" +
",'" + GridForUpload.Rows[i].Cells[4].Value + "'" +
",'" + GridForUpload.Rows[i].Cells[5].Value + "'" +
",'" + GridForUpload.Rows[i].Cells[6].Value + "'" +
",'" + GridForUpload.Rows[i].Cells[7].Value + "'" +
",'" + namevaluefull + "'" +
",'" + GridForUpload.Rows[i].Cells[9].Value + "'" +
",'" + GridForUpload.Rows[i].Cells[10].Value + "','" + VarClientId + "','" + VarCycle + "','" + VarBatch + "','" + GridForUpload.Rows[i].Cells[11].Value.ToString().Replace("'", "''") + "','" + lastName + "','" + firstName + "')";

SqlCommand cmdsaveDtls = QuikConn.CreateCommand(InsertDetails);
qConect.Open();
cmdsaveDtls.Connection = qConect;
cmdsaveDtls.ExecuteNonQuery();
rowCount += 1;
qConect.Close();

this worked perfectly in my development pc but errors out when tried to execute in other pc

Dave Kreskowiak 16-Dec-13 0:31am

The code you posted cannot possibly generate a "FileNotFound" exception unless the connection string specifies an attaching SQL file that cannot be found.

An@nd Rajan10 · Accepted Answer · 2013-12-15T18:03:00

Solution 2

check your connection string...do you using dataset ??

Posted 15-Dec-13 18:03pm

An@nd Rajan10

Comments

JOEY G. MOYA 16-Dec-13 0:17am

As mentioned i was able to logged to the application which means i was able to connect to the server. below is the actual code
qCon.Open();
cmd.Connection = qCon;
SqlDataAdapter dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand = cmd;
DataSet dsResult = new DataSet("ResultSet");
dataAdapter.Fill(dsResult);
DataTable dtResult = dsResult.Tables[0];
int rowCount = 0;