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();
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5