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