Advertisement
Advertisement
| 11.15.2007 at 09:56AM PST, ID: 22963601 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: |
if (FileUpload1.FileName == "")
return;
FileUpload1.SaveAs("c:\\EmployeeExpenses.xls");
SqlConnection SQLConn = new SqlConnection("Data Source=KSSQL01;Initial Catalog=stamp;Integrated Security=SSPI");
SQLConn.Open();
SqlCommand SQLCommand = new SqlCommand("Delete tempEmployeeExpenses", SQLConn);
SQLCommand.ExecuteNonQuery();
SQLConn.Close();
OleDbConnection ExcelConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\EmployeeExpenses.xls;Extended Properties=Excel 8.0;");
ExcelConnection.Open();
OleDbCommand ExcelCommand = new OleDbCommand(
"INSERT INTO [ODBC;Driver={SQL Server};Server=KSSQL01;Database=stamp;Trusted_ Connection=yes].[tempEmployeeExpenses] "+
"(Date, Description, CardMember, Amount) "+
"SELECT [Date], [Description], [CardMember], [Amount] "+
"FROM [Sheet1$] "+
"WHERE [Sheet1$].[CardMember] = \"" + CardHolderName + "\";", ExcelConnection);
ExcelCommand.ExecuteNonQuery();
ExcelConnection.Close();
|