whenever i am trying to save excel sheet into ms access database 2003.it is throwing exception i dont know why?kindly help here.
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.
WebParts;
using System.Web.UI.HtmlControls
;
using System.ComponentModel;
using System.Data.OleDb;
using System.Data.SqlTypes;
using System.Drawing;
using System.Web.SessionState;
using System.Security.Permission
s;
using System.Runtime.InteropServ
ices;
using System.Diagnostics;
using System.Reflection;
using Microsoft.Office.Core;
code :
public bool LoadXlsFile(string StrFileName)
{
bool flag = false;
string strSql = "";
if (this.fileDialog.Value.ToS
tring() != "")
{
try
{
string strReplace = "\\\\";
string strPath = StrFileName.Replace("\\", strReplace);
string strConn;
strSql = "";
strConn = "Provider=Microsoft.Jet.OL
EDB.4.0;" + "Data Source=" + strPath + ";" + "Extended Properties=Excel 11.0;"; //You must use the $ after the object you reference in the spreadsheet
System.Data.OleDb.OleDbDat
aAdapter myCommand = new System.Data.OleDb.OleDbDat
aAdapter("
SELECT * FROM [CustomerMaster$]", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ExcelInfo");
DataTable dt = new DataTable();
dt = myDataSet.Tables["ExcelInf
o"];
//loop through the excel sheet and insert contract number into tblorganizationentity
if (dt.Rows.Count != 0)
{
foreach (DataRow drow in dt.Rows)
{
if (drow[1].ToString().Trim()
!= "")
{
strSql = "Update CustomerMaster set CustomerNumber='" + drow[0].ToString().Trim() + "',CustomerName='" + drow[1].ToString().Trim() + "',CustomerAddressLine1='"
+ drow[2].ToString().Trim() + "' ,CustomerAddressLine2='" + drow[3].ToString().Trim() + "',CustomerCity='" + drow[4].ToString().Trim() + "',CustomerState='" + drow[5].ToString().Trim() + "',CustomerZipcode='" + drow[6].ToString().Trim() + "',CustomerBranchCode='" + drow[7].ToString().Trim() + "',CustomerBranchName='" + drow[8].ToString().Trim() + "' ";
AccessDB.DBExecuteNonQuery
Object(str
Sql);
//cmd.CommandText = strSql;
//cmd.ExecuteNonQuery();
}
}
flag = true;
}
else
{
this.lblOutput.Text = "Worksheet-Contract Not Found or No Data Available";
}
}
catch (System.Exception ex)
{
this.lblOutput.Text = ex.Message;//"Worksheet-Sh
eet1 Not Found or No Data Available" ;
}
}
return flag;
}