مشکل در ارتباط با data source

[majesticsoft]

آقا اشکال این کد چیه؟؟؟؟
string strid = Session["id"].ToString();
string connectionstring = "provider=Microsoft.Jet.OLeDB.4.0;Data Source=|datadirectory|\\Database1.mdb ; persist security info= true";
OleDbConnection con = new OleDbConnection(connectionstring);
string strselect = "select * from table1 where stdid=@stdid2";
OleDbCommand cm5 = new OleDbCommand(strselect, con);
con.Open();
cm5.Parameters.AddWithValue("@stdid2", strid);
GridView1.DataSource = cm5.ExecuteScalar();
GridView1.DataBind();
con.Close();


این پیغامو میده:
Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource.

راهنمایی کنین.........

[mehrzad_ali]

OleDbConnection myconnection = new OleDbConnection();
OleDbDataAdapter mycommand;
DataSet dtset;

myconnection.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source=|DataDirectory|\\001.xls; Extended properties=Excel 8.0";
mycommand = new OleDbDataAdapter("select * from[sheet1$]", myconnection);
mycommand.TableMappings.Add("Table", "Table1");
dtset = new DataSet();
mycommand.Fill(dtset);
GridView1.DataSource = dtset.Tables[0];
GridView1.DataBind();
myconnection.Dispose();



البته این کد از اکسل سلکت میکنه