André Parreira Posted March 11, 2009 at 04:22 PM Report Share #249893 Posted March 11, 2009 at 04:22 PM Boas Tenho que criar o excel como base de dados( assim foi pedido) Tenho este codigo Inherits System.Windows.Forms.Form Private da As OleDbDataAdapter Private dt As DataTable Dim conexao_Excel As String = "Provider=Microsoft.Jet.OleDb.4.0;" _ & "data source=C:\Users\utilizador\Favorites\Desktop\testar.xls;" _ & "Extended Properties=Excel 8.0;" Que trabalha perfeitamente, mas como é que eu fasso para ele ir buscar a DIR a textbox que tenho introduzida no form??? Obrigado Link to comment Share on other sites More sharing options...
André Parreira Posted March 12, 2009 at 10:16 AM Author Report Share #250122 Posted March 12, 2009 at 10:16 AM ja axo que consegui fazer, ainda nao conseui testar, mas deve ser isso penso eu Provider=Microsoft.Jet.Oledb.4.0; data source= " + TextPathExcel.Text + ";Extended properties=""Excel 8.0;hdr=yes;imex=1""" Link to comment Share on other sites More sharing options...
André Parreira Posted March 12, 2009 at 10:30 AM Author Report Share #250130 Posted March 12, 2009 at 10:30 AM Boas Meti esse codigo mas agora nao consigo entrar no form quando executo o programa. An error occurred creating the form. See Exception.InnerException for details. The error is: A referência de objecto não foi definida como uma instância de um objecto. podiam ajudar? Obrigado Link to comment Share on other sites More sharing options...
Hellblazer Posted March 12, 2009 at 10:34 AM Report Share #250133 Posted March 12, 2009 at 10:34 AM Tens algum objecto vazio ou nao inicializado a ser utilizado.. There are two ways to write error-free programs; only the third one works. Link to comment Share on other sites More sharing options...
André Parreira Posted March 12, 2009 at 10:38 AM Author Report Share #250138 Posted March 12, 2009 at 10:38 AM por exemplo uma textbox?? Como e possivel resolver o problemas?? Obrigado Link to comment Share on other sites More sharing options...
Hellblazer Posted March 12, 2009 at 10:47 AM Report Share #250147 Posted March 12, 2009 at 10:47 AM Tipo por exemplo estares a utilizar o valor da textbox ali 👍 There are two ways to write error-free programs; only the third one works. Link to comment Share on other sites More sharing options...
André Parreira Posted March 12, 2009 at 10:48 AM Author Report Share #250152 Posted March 12, 2009 at 10:48 AM ent como e que eu fasso a chamada a um ficheiro excel, tenho que abrir num OpenFileDialog e depois a dir que ficava na textbox ficava la tb e dava. ent n sei como fazer agradecia ajudas obrigado Link to comment Share on other sites More sharing options...
Hellblazer Posted March 12, 2009 at 10:51 AM Report Share #250155 Posted March 12, 2009 at 10:51 AM http://www.java2s.com/Tutorial/VB/0260__GUI/SetOpenFileDialogFilterandgetselectedfilename.htm There are two ways to write error-free programs; only the third one works. Link to comment Share on other sites More sharing options...
André Parreira Posted March 12, 2009 at 10:55 AM Author Report Share #250159 Posted March 12, 2009 at 10:55 AM Isso e para fazer a chamada a um ficheiro, ja sei komo se faz, mas como meto o utilizador a esclher o ficheiro que quiser. tenho que fazer a cahamda ao ficheiro meto a dir numa textbox, depois como fasso?? Obrigado Link to comment Share on other sites More sharing options...
Hellblazer Posted March 12, 2009 at 11:19 AM Report Share #250172 Posted March 12, 2009 at 11:19 AM depois de aberto o dialog e de o user escolher o ficheiro Dim openFileDialog1 As System.Windows.Forms.OpenFileDialog openFileDialog1 = New System.Windows.Forms.OpenFileDialog() If openFileDialog1.ShowDialog() = DialogResult.OK Then textBox1.Text = openFileDialog1.FileName End If There are two ways to write error-free programs; only the third one works. Link to comment Share on other sites More sharing options...
André Parreira Posted March 12, 2009 at 11:23 AM Author Report Share #250175 Posted March 12, 2009 at 11:23 AM Sim para a textbox ficar com a dir, depois onde é que meto para no datagrid, ele abrir o ficheiro escolhido?? Obrigado Link to comment Share on other sites More sharing options...
Hellblazer Posted March 12, 2009 at 11:25 AM Report Share #250179 Posted March 12, 2009 at 11:25 AM Como assim? que tipo de ficheiro é? Queres meter o conteudo ou simplesmente uma grid com a lista de ficheiros? There are two ways to write error-free programs; only the third one works. Link to comment Share on other sites More sharing options...
André Parreira Posted March 12, 2009 at 11:29 AM Author Report Share #250183 Posted March 12, 2009 at 11:29 AM Sim, e para para fazer a chamada a uma folha excel. para aparece na datagrid o que vem no excel, eu consigo fazer a chamada apenas a 1 ficheiro excel, mas so eu que escolho, e isso n pode ser Inherits System.Windows.Forms.Form Private da As OleDbDataAdapter Private dt As DataTable Dim conexao_Excel As String = "Provider=Microsoft.Jet.OleDb.4.0;" _ & "data source=C:\Users\utilizador\Favorites\Desktop\nadanada.xls;" _ & "Extended Properties=Excel 8.0;" meti onde tava a dir uma textbox, mas n deu o erro foi: An error occurred creating the form. See Exception.InnerException for details. The error is: A referência de objecto não foi definida como uma instância de um objecto. Nao estou a ver como resolver isto Obrigado Link to comment Share on other sites More sharing options...
Hellblazer Posted March 12, 2009 at 11:40 AM Report Share #250192 Posted March 12, 2009 at 11:40 AM Tu nao podes meter ali fora dos metodos o valor da textbox... There are two ways to write error-free programs; only the third one works. Link to comment Share on other sites More sharing options...
André Parreira Posted March 12, 2009 at 11:46 AM Author Report Share #250195 Posted March 12, 2009 at 11:46 AM Entao como posso fazer? Obrigado Link to comment Share on other sites More sharing options...
Hellblazer Posted March 12, 2009 at 11:47 AM Report Share #250197 Posted March 12, 2009 at 11:47 AM Por exemplo quando preenches a textbox logo aseguir podes fazer isso 👍 Declarando a mesma o Private conexao_Excel as String There are two ways to write error-free programs; only the third one works. Link to comment Share on other sites More sharing options...
André Parreira Posted March 12, 2009 at 12:26 PM Author Report Share #250219 Posted March 12, 2009 at 12:26 PM Nao estou a conseguir fazer... eu consigo ir buscar a dir do ficheiro excel, mas n estou a conseguir abrir o datagrid com o conteudo dessa folha excel, Agradecia ajuda Link to comment Share on other sites More sharing options...
Hellblazer Posted March 12, 2009 at 12:46 PM Report Share #250228 Posted March 12, 2009 at 12:46 PM Dim FileSource As String = "C:\teste.xls" Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook(FileSource) Dim dataSet As DataSet = workbook.GetDataSet("Ordem", SpreadsheetGear.Data.GetDataFlags.FormattedText) DataGrid1.DataSource = dataSet DataGrid1.DataBind() There are two ways to write error-free programs; only the third one works. Link to comment Share on other sites More sharing options...
André Parreira Posted March 12, 2009 at 12:53 PM Author Report Share #250231 Posted March 12, 2009 at 12:53 PM Onde introduzo esse codigo??? no botao para quando pedir para ir buscar o excel?? ou la em cima?? tenho que usar algum impots? e que o SpreadsheetGear diz que nao esta declarado Obrigado pela ajuda Link to comment Share on other sites More sharing options...
Hellblazer Posted March 12, 2009 at 12:58 PM Report Share #250236 Posted March 12, 2009 at 12:58 PM Desculpa... estava a pesquisar e nao reparei que isso utiliza um third party control deixa procurar melhor. Ve aqui http://dotnetguts.blogspot.com/2006/10/import-excel-to-datagrid-aspnet.html se precisares de ajuda a passar para vb.net eu ajudo 🙂 There are two ways to write error-free programs; only the third one works. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now