DataTable dt = null; //Excel 2003 string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + fileName + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection objConn = new OleDbConnection(connectionString); try { objConn.Open(); } catch { return null; } OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [" + parm.excelSheetName + "$]", objConn); OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(); objAdapter1.SelectCommand = objCmdSelect; try { dt = new DataTable("ExcelTable"); objAdapter1.Fill(dt); objConn.Close(); } catch (Exception e) { throw e; } return dt;>Hi all,
>using System.Data.OleDb; >using System.Data.SqlClient; > >public partial class _Default : System.Web.UI.Page >{ > protected void Page_Load(object sender, EventArgs e) > { > string strConn, strSQL; > // strConn = "provider=SQLOLEDB; Data Source=E:\\_ASP\\TXTUzorak.txt; Extended Properties='text;HDR=No;FMT=Delimited'"; > strConn = "provider=SQLOLEDB; Data Source=E:\\_ASP\\TXTUzorak.txt;Integrated Security=True"; > > > strSQL = "SELECT * from TXTUzorak.txt" ; > > OleDbConnection cn = new OleDbConnection(); > cn.ConnectionString = strConn; > cn.Open(); > > > //OleDbDataAdapter da = new OleDbDataAdapter(strSQL, cn); > //DataSet ds = new DataSet(); > //da.Fill(ds, "Kupci"); > > OleDbCommand izvrsi = new OleDbCommand(strSQL, cn); > OleDbDataReader citac = izvrsi.ExecuteReader(); > > cn.Close(); > > GridView1.DataSource = citac; > //GridView1.DataSource = ds; > //GridView1.DataMember = "Kupci"; > GridView1.DataBind() ; > > } > >>