客户端操作读取客户端文件,服务器端如何正确获取文件路径!
在客户端把xls文件导入到服务器的SQL中,现在出现路径错误,如何解决?
以下是获取xls文件路径和打开xls文件的代码,望高手指点。
public string sConnectionString
{
get
{
//EXCEL 的连接串
string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + File1.PostedFile.FileName.ToString() + " ;" + "Extended Properties=Excel 8.0;";
return sConnectionString;
}
}
protected void button1_Click(object sender, EventArgs e)
{
try
{
GridView1.Visible = true;
//开始导入
//建立EXCEL的连接
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
string sqlStr = "select * from [Sheet1$]";
OleDbCommand myCmd = new OleDbCommand(sqlStr, objConn);
OleDbDataAdapter myda = new OleDbDataAdapter(myCmd);
DataSet myDs = new DataSet();
myda.Fill(myDs, "a");
// GridView1.DataSource = myDs;
objConn.Close();
....