Torna al Thread
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\politecnico\siti\laprealpina.net1\Listino_web.xls; Extended Properties=""Excel 8.0;HDR=Yes"";";
string CommandText = "SELECT [Codice],[Iva inclusa],[Descrizione],[Dimensione] FROM [Foglio1$] WHERE Codice = " + GridView1.SelectedRow.Cells[1].Text;
OleDbConnection myConnection = new OleDbConnection(ConnectionString);
OleDbCommand myCommand = new OleDbCommand(CommandText, myConnection);
myConnection.Open();
GridView2.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
GridView2.DataBind();
myconnection.Close();