How Do I Save Files In Two Places?

Question

0.00/5 (No votes)

See more:

i have created a simple data insert system? and there is a save method. all the textbox data save in a excel sheet. one file goes to shared folder and other file save in user's pc.

so how can i write these details to two files in separate destination?

i have used two data sources at once in one oledb connection.

C#

{


            string szConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\172.21.1.91\enquiry/enquiry-Excel.xls;Data Source=d:\\enquiry1/enquiry-Excel.xls;Extended Properties='Excel 8.0;HDR=YES;'";
            OleDbConnection conn = new OleDbConnection(szConn);
            

            DateTime result = dateTimePicker1.Value;
            string date1 = result.ToString();
            String name = textBox1.Text;
            int Contct = Int32.Parse(textBox2.Text);
            DateTime result2 = dateTimePicker2.Value;
            string date2 = result2.ToString();
            string requirment = textBox3.Text;
            string cb = "";
            string cb2 = "";
            string cb3 = "";

            if (checkBox1.Checked)
            {
                cb = "checked";
            }
            else if (checkBox2.Checked)
            {
                cb2 = "checked";
            }
            else if (checkBox3.Checked)
            {
                cb3 = "checked";
            }

            string team;
            team = comboBox3.Text;

            string cmb;
            cmb = comboBox1.Text;

            string cmb2;
            cmb2 = comboBox2.Text;

            string status1 = textBox5.Text;
            string status2 = textBox6.Text;

           

            conn.Open();
            OleDbCommand cmd = new OleDbCommand("INSERT INTO [Sheet1$]([Team],[Date],[Name],[Contact Details],[Req Date],[Requirment],[Ticket],[Fit Package],[Group],[No of Pax],[Status 1],[Status 2],[Status 3]) VALUES('" + team + "','" + date1 + "','" + name + "','" + Contct + "','" + date2 + "','" + requirment + "','" + cb + "','" + cb2 + "','" + cb3 + "','" + cmb2 + "','" + cmb + "','" + status1 + "','" + status2 + "')", conn);
            OleDbCommand cmd2 = new OleDbCommand("INSERT INTO [Sheet1$]([Team],[Date],[Name],[Contact Details],[Req Date],[Requirment],[Ticket],[Fit Package],[Group],[No of Pax],[Status 1],[Status 2],[Status 3]) VALUES('" + team + "','" + date1 + "','" + name + "','" + Contct + "','" + date2 + "','" + requirment + "','" + cb + "','" + cb2 + "','" + cb3 + "','" + cmb2 + "','" + cmb + "','" + status1 + "','" + status2 + "')", conn);
            cmd.ExecuteNonQuery();
            cmd2.ExecuteNonQuery();

            conn.Close();
            MessageBox.Show("complete");     
        }

Posted 31-Oct-14 17:47pm

Hemas Ilearn

Updated 31-Oct-14 17:49pm

v2

Add a Solution

Comments

Robert Welliever 1-Nov-14 0:16am

You should use the OleDbParameter object. I guess it's dependent on who is accessing the code, but it really would be easy for a user to delete all the data from that file by injecting a Delete statement into your textbox.

1 solution

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)

DamithSL · Accepted Answer · 2014-10-31T17:52:00

Solution 1

use two connection strings with the two different locations. assume szConn1 and szConn2

C#

OleDbConnection conn1 = new OleDbConnection(szConn1);
OleDbConnection conn2 = new OleDbConnection(szConn2);

OleDbCommand cmd1 = new OleDbCommand(sqlString, conn1); 
OleDbCommand cmd2 = new OleDbCommand(sqlString, conn2); 

conn1.Open();
conn2.Open();

cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();

after you successfully write in to two files you better study about how to use sql parameters and also use of using statements. Sample code:

C#

string SqlString = "Insert Into Contacts (FirstName, LastName) Values (?,?)";
using (OleDbConnection conn = new OleDbConnection(ConnString))
{
  using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))
  {
    cmd.CommandType = CommandType.Text;
    cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text);
    cmd.Parameters.AddWithValue("LastName", txtLastName.Text);
    conn.Open();
    cmd.ExecuteNonQuery();
  }
}

Posted 31-Oct-14 17:52pm

DamithSL

Updated 31-Oct-14 18:31pm

v2

Comments

Robert Welliever 1-Nov-14 0:11am

Why are you leaving the connection open?

DamithSL 1-Nov-14 0:19am

I haven't add entire code, only wanted to show how to use two connection strings. Anyway I have updated answer with sample code with parameters and using blocks.

Hemas Ilearn 1-Nov-14 0:25am

i did like this?

string szConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\172.21.1.91\enquiry/enquiry-Excel.xls;Extended Properties='Excel 8.0;HDR=YES;'";
string szConn1 = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\\enquiry1/enquiry-Excel.xls;Extended Properties='Excel 8.0;HDR=YES;'";
OleDbConnection conn = new OleDbConnection(szConn);
OleDbConnection conn1 = new OleDbConnection(szConn1);

OleDbCommand cmd = new OleDbCommand("INSERT INTO [Sheet1$]([Team],[Date],[Name],[Contact Details],[Req Date],[Requirment],[Ticket],[Fit Package],[Group],[No of Pax],[Status 1],[Status 2],[Status 3]) VALUES('" + team + "','" + date1 + "','" + name + "','" + Contct + "','" + date2 + "','" + requirment + "','" + cb + "','" + cb2 + "','" + cb3 + "','" + cmb2 + "','" + cmb + "','" + status1 + "','" + status2 + "')", conn);
OleDbCommand cmd2 = new OleDbCommand("INSERT INTO [Sheet1$]([Team],[Date],[Name],[Contact Details],[Req Date],[Requirment],[Ticket],[Fit Package],[Group],[No of Pax],[Status 1],[Status 2],[Status 3]) VALUES('" + team + "','" + date1 + "','" + name + "','" + Contct + "','" + date2 + "','" + requirment + "','" + cb + "','" + cb2 + "','" + cb3 + "','" + cmb2 + "','" + cmb + "','" + status1 + "','" + status2 + "')", conn);

conn.Open();
conn1.Open();

cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();

conn.Close();
MessageBox.Show("complete");
conn1.Close();

but still have same problem?

DamithSL 1-Nov-14 0:28am

bath cmd and cmd2 using conn! change cmd2 initialization with conn1

OleDbCommand cmd2 = new OleDbCommand("INSERT INTO [Sheet1$]([Team],[Date],[Name],[Contact Details],[Req Date],[Requirment],[Ticket],[Fit Package],[Group],[No of Pax],[Status 1],[Status 2],[Status 3]) VALUES('" + team + "','" + date1 + "','" + name + "','" + Contct + "','" + date2 + "','" + requirment + "','" + cb + "','" + cb2 + "','" + cb3 + "','" + cmb2 + "','" + cmb + "','" + status1 + "','" + status2 + "')", conn1);

Hemas Ilearn 1-Nov-14 0:39am

got it.... (y)
thank you

BillWoodruff 1-Nov-14 0:45am

+5 nice work !

DamithSL 1-Nov-14 0:49am

Thank You BillWoodruff

Robert Welliever 1-Nov-14 1:10am

The parameter names should not be the same names as the column names; the accepted practice is to use the @ symbol, and then use them correctly in the command text. So for your example to be acceptable the command text should be:
"Insert Into Contacts (FirstName, LastName) Values (@FirstName,@LastName)"
and then adding the parameter would be like:
cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text);

DamithSL 1-Nov-14 1:16am

Dear Robert, check below code

string queryString = "SELECT * FROM Table1 WHERE Field1 LIKE ?";
OleDbCommand command = new OleDbCommand(queryString, connection);
command.Parameters.Add("@p1", OleDbType.Char, 3).Value = "a";
OleDbDataReader reader = command.ExecuteReader();

what do you think?
above is taken from MSDN. read the documentation and lean why there is question mark used.

http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbparameter(v=vs.110).aspx[^]

Robert Welliever 1-Nov-14 1:45am

I read it. It appears the code you pasted specifically is for connecting to Oracle and he's connecting to Excel. Aside from that, the page does use the @ symbol for all parameter naming. Using named parameters in the command text works just fine in OleDb and so the code will look the same as other adapters. This is for readability and/or if you need to write a SqlCommand version using the same code. I know I sound really arrogant but I still think I'm right.

DamithSL 1-Nov-14 2:00am

"The OLE DB.NET Framework Data Provider uses positional parameters that are marked with a question mark (?) instead of named parameters."

Robert Welliever 1-Nov-14 2:08am

Except whichever Microsoft employee wrote that isn't telling the whole story and the article you keep referencing isn't up to Microsoft's usually stringent quality control.

DamithSL 1-Nov-14 2:06am

I have answered to OP's question. if you think all these improvements need to be addressed PERFECT cord should provided when you answering to a question, please go ahead and answer to this question.

Robert Welliever 1-Nov-14 2:12am

What I was suggesting is just basic and common practice, not some idealistic implementation of perfection. How about I mark your answer with 5 stars so you won't be so pissy. Happy now?

DamithSL 1-Nov-14 2:23am

It is not about the reputation, OP already solved his original issue and if you have something to add for his improvement, please add answer or directly comment to OP and say it. Don't think that common practice will work for all the cases.

Robert Welliever 1-Nov-14 2:30am

No thanks, I'd rather just add comments to improve an existing answer if the answer is close but just a little bit wrong. Thanks for the suggestion though.