from some reason it still doest work what should be the expension i should add?
On 21 ספטמבר, 16:35, Raghupathi Kamuni <[email protected]> wrote: > Problem with quotes in your connection string > > Try this connection string, I have tested this in a sample project > > string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data > Source=c:\Yourspreadsheet.xls;Extended Properties= ""Excel 8.0;HDR=YES;"""; > > > > On Sun, Sep 20, 2009 at 10:57 PM, thread <[email protected]> wrote: > > > hello > > i'm trying to build in C#.net an interface that pulling information > > from excel file > > from some reason the information is not appearing. > > this is the code: > > <%-- > > > <%@ Page Language="C#" %> > > <%@ import Namespace="System.Data" %> > > <%@ import Namespace="System.Data.OleDb" %> > > <script runat="server"> > > > void Page_Load(object sender, EventArgs e) > > { > > MessageBox.Show("Yaniv"); > > string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; > > Data Source=C:\Yourspreadsheet.xls; Extended Properties=""Excel > > 8.0;HDR=Yes"";"; > > string CommandText = "select * from [book$]"; > > > OleDbConnection myConnection = new OleDbConnection > > (ConnectionString); > > OleDbCommand myCommand = new OleDbCommand(CommandText, > > myConnection); > > > myConnection.Open(); > > DataGrid1.DataSource = myCommand.ExecuteReader > > (CommandBehavior.CloseConnection); > > DataGrid1.DataBind(); > > myConnection.Close(); > > } > > > </script> > > <html> > > <head> > > </head> > > <body style="FONT-FAMILY: arial"> > > <h2>Simple Data Report > > </h2> > > <hr size="10" /> > > <form runat="server"> > > <asp:datagrid id="DataGrid1" runat="server" > > EnableViewState="False" ForeColor="Black" BackColor="White" > > CellPadding="3" GridLines="None" CellSpacing="1"> > > <HeaderStyle font-bold="True" forecolor="white" > > backcolor="#4A3C8C"></HeaderStyle> > > <ItemStyle backcolor="#DEDFDE"></ItemStyle> > > </asp:datagrid> > > <hr size="10" /> > > </form> > > </body> > > </html> > > > --%> > > what is wrong?-הסתר טקסט מצוטט- > > -הראה טקסט מצוטט-
