如何在两个地方保存文件？ [英] How Do I Save Files In Two Places?

问题描述

我创建了一个简单的数据插入系统？还有一种保存方法。所有文本框数据都保存在Excel工作表中。一个文件转到共享文件夹，其他文件保存在用户的电脑上。



所以如何将这些细节写入两个文件在不同的目的地？



i在一个oledb连接中同时使用了两个数据源。

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.

{


            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");     
        }

推荐答案

（[团队]，[日期]，[姓名]，[联系方式]，[需求日期] ]，[需要]，[机票]，[适合套餐]，[组]，[职员编号]，[状态1]，[状态2]，[状态3]）价值（' +团队+ '，' + date1 + '，' + name + '， ' + Contct + '，' + date2 + '，' + requirment + '，' + cb + '，' + cb2 + '，' + cb3 + '，' + cmb2 + '，' + cmb + '，' + status1 + '，' + status2 + < span class =code-string> '），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); OleDbCommand cmd2 = new OleDbCommand("INSERT INTO [Sheet1

（[团队]，[日期]，[姓名]，[联系方式]，[需求日期]，[要求]，[机票]，[适合套餐]， [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）;
}

([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"); }

使用两个不同位置的连接字符串。假设szConn1和szConn2

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

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();

成功写入两个文件后你最好学习如何使用sql参数并使用using语句。示例代码：

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:

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();
  }
}

这篇关于如何在两个地方保存文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！