你好，
参考下面代码试试。
private List<string> GetExcelCon()
{
string connection = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = C:\\Documents and Settings\\yangjh\\桌面\\sample.xls;Extended Properties=Excel 8.0";
OleDbConnection thisconnection = new OleDbConnection(connection);
string command = "select * from [sheet1$]";
thisconnection.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(command, thisconnection);
DataSet ds = new DataSet();
adapter.Fill(ds, "[sheet1$]");
thisconnection.Close();
List<string> parameters = new List<string>();
foreach (DataRow Row in ds.Tables[0].Rows)
{
parameters.Add(Row[0].ToString());
}
return parameters;
}
private DataTable SampleData(string para)
{
string connection = "Server=192.100.3.3;Datasource=AIS20090330165131;uid=sa;pwd=;";
SqlConnection thisconntion = new SqlConnection(connection);
SqlCommand cmd = thisconntion.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "t_StoreAndSale";
cmd.CommandTimeout = 0;
SqlParameter parameter = new SqlParameter("@FFullNumber", SqlDbType.VarChar, 40);
parameter.Direction = ParameterDirection.ReturnValue;
parameter.Value =para;
cmd.Parameters.Add(parameter);
SqlDataAdapter Adapter = new SqlDataAdapter();
Adapter.SelectCommand = cmd;
DataSet ds = new DataSet();
Adapter.Fill(ds);
return ds.Tables[0];
}
public DataTable GetAllData()
{
List<string> parameters = GetExcelCon();
DataTable dt = new DataTable();
foreach (string item in parameters)
{
DataTable returnDt = SampleData(item);
if (returnDt!=null&&returnDt.Rows.Count!=0)
{
dt.Rows.Add(returnDt.Rows[0].ItemArray);
}
}
return dt;
}
Microsoft Online Community Support
