通过OleDB连接方式,访问Access,Excel数据库.docx

通过OleDB连接方式,访问Access,Excel数据库.OleDbConnectionStringBuilder?oleConStr?=?new?OleDbConnectionStringBuilder();Access?连接信息oleConStr.ConnectionString?=?Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=?+?myDBFileName?+?;User?Id=admin;Password=;;Excel?连接信息string?myExcelConStr?=?Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=?+?myDBFileName?+?;Extended?Properties=Excel?8.0;;???????????????myExcelConStr?=????????????????@Provider=Microsoft.Jet.OLEDB.4.0;?+????????????????@Data?Source=?+?myDBFileName?+?;?+????????????????@Extended?Properties=?+?Convert.ToChar(34).ToString()?+????????????????@Excel?8.0;?+?ExcelConnectionOptions()?+?Convert.ToChar(34).ToString();????????public?bool?Headers????????{????????????get?{?return?HasHeaders;?}????????????set?{?HasHeaders?=?value;?}????????}????????public?bool?MixedData????????{????????????get?{?return?IsMixedData;?}????????????set?{?IsMixedData?=?value;?}????????}????????private?string?ExcelConnectionOptions()????????{????????????string?strOpts?=?;????????????if?(this.MixedData?==?true)????????????????strOpts?+=?Imex=2;;????????????if?(this.Headers?==?true)????????????????strOpts?+=?HDR=Yes;;????????????else????????????????strOpts?+=?HDR=No;;????????????return?strOpts;????????}=======查询数据===========?OleDbConnection?OleConn?=?new?OleDbConnection(oleConStr.ConnectionString);???????OleDbCommand?cmd;???????string?SqlStr?=???Select?top?1?*??from?[?+?newMaTolName?+?]?;???????cmd?=?new?OleDbCommand(SqlStr,?OleConn);???????OleDbDataAdapter?OleDapt?=?new?OleDbDataAdapter();???????OleDapt.SelectCommand?=?cmd;???????OleConn.Open();???????DataSet?myDS?=?new?DataSet();???????OleDapt.Fill(myDS);注意:如果是Excel数据库需在表名后加$;=======增加字段===========SqlStr?=???ALTER?TABLE??[?+?newMaTolName.Replace($,)?+?]???ADD?IsRead?decimal,RowNo?long?IDENTITY(1,1)??;cmd?=?new?OleDbCommand(SqlStr,?OleConn);int?affectRows?=?cmd.ExecuteNonQuery();=======在DataSet表中增加一列=======myDS?是已保存有数据的DataSetif?(myDS.Tables[0].Rows.Count??1)????????????????{????????????????????return?IsSuccess;????