I have a spreadsheet control on a windows form that I would like to populate with data from an existing worksheet (myworkbook.xls, sheet1). The best solution for me would to be to actually open the workbook on my form (not sure that is possible?), the next best solution would be to fill the spreadsheet control.
View 1 RepliesI'm trying to add the spreadsheet control to a form in VB but I can't remember what reference or file I need to load to get the object in the toolbox.It has been a while since I used it last and that was in VB 2008.I looked and loaded several microsoft interop files from the .net reference menu but none of the seemed to work.
View 3 RepliesError: ClassFactory cannot supply requested class.I installed 2003 Add-in: Office Web Components, you can download and install OWC11.exe from the following link:aunched a VB formadded the Spreadsheet 11.0 control and got the above error.
View 1 RepliesThere is no other workaround at this point, so here is what I am attempting to do:
1. Fill a DataAdapter from an Excel.xls spreadsheet.
2. TRUNCATE an existing SQLServer2005 db table that matches this excel spreadsheet.
3. UPDATE that SQL Table with the DataTable filled from the excel spreadsheet.
If there are anyother suggestions (OPENROWSET/DATASET is not possible for my situation, in or outside of a SProc),Here's the current dev point I am at --- no errors, but also the SQL table does not update.
[Code]...
I am trying to fill a DataGridView box with data from an Excel2007 spreadsheet. My code below connects to Excel2007 workbook but then errors and gives this error
[Code]....
Where have I gone wrong and how can I fix this, as I want to show the data in the DataGridView and then move it from there into my SQLServer DB?
I am working on VB.Net. I have a sub form with a datagridview, that is being loaded with the criteria taken from another form. Hence this form is called with parameters. Here is the code that calls the sub form.
[code]...
where ds is the dataset to fill the datagridview and rb is the string from a radio button on this form.
Here is the code in the sub form.
[code]...
Now, I need to refresh this sub form every -- minutes, depending on how the user wants it to be. For this I have given a NumericUpDown control to select the mins. All this works fine. But how do I refresh the dataset and the datagridview?
In VB6 classical, we could do:
Private Sub Form_Load()
WebBrowser1.Navigate2 "http://yourSite.com"
End Sub
[code].....
In the past, I used the code below to fill out a form field using the webbrowser control in VB.Net. The page I am working with doesn't have name field for the inputbox, so my code doesn't work. How would I fill out the input box defined at the bottom of this post in bold?[code]...
View 1 RepliesBasic scenario is that I need to programatically fill out a PDFs text fields that resides on a webserver. The fields will be mapped and filled out with data contained in a CSV. The PDF must be opened in the browser (browser control or ie/ff/chrome/etc) and edited in place. Cannot be downloaded, filled out, and uploaded (it must be filled out and submitted using the submit button in it; I've tried editing the buttons submission path to no avail).Thus far I've put a web browser control on a form and made it navigate to the website, login, and load the PDF file. How do I interact with the PDF file thats open in the web browser control? Looking through various PDF libraries, they seem to mainly interact with a closed pdf located on the harddrive, make the modificatio
View 2 RepliesI am using a WebBrowser-Control to fill in a webform and then click at a button, this currently results in a standard Download File Dialog (you get these if you download a file using internet explorer), but instead, I have to catch this file and save it automatically with a by me defined name to a specific folder.I am trying to code a little application in vb.net which download the Export-file from my wordpress-blog, and I want to do this completely without user-interaction.Currently everything works, except the downloading of the file.I tried to catch it with the event System.Windows.Controls.WebBrowser.Navigating(ByVal Object, ByVal System.Windows.Navigation.NavigatingCancelEventArgs) but I don't see where to download the file from?
View 3 RepliesI am creating a form for work where managers can report when they find a customer's personal information laying around on a desk (we work at a call center where agents answer calls for a wireless cell phone provider, so we take personal information security very seriously). Anyway, I am wondering if there is a way to have a text box autofill with that manager's windows username (since they will need to be logged into their own profile to use the form).
View 2 RepliesIt is possible to create windows service using windows form control in vb.net. give me the url or links. The windows forms control such as, Timer control, list-box, notify-icon control etc.
View 1 RepliesI have a basic Windows form with one Crystal Reports form veiwer control on it. When ran on the development machine it displays the report fine.After build and publish the application is now installed on a user PC. I am getting an error that the Crystal Decisions. Windows. Form version 12.0.2000.0 can not be found. All the Crystal dll's are in the install directory but none of them are being installed in the install machines GAC.Am I setting my publish output up wrong, may references wrong, or is the local GAC files the problem. The message is so criptic, it doesnt really point me in the right direction.
View 1 RepliesWhen reading date fields, if the year is 1900 it subtracts 1 day from the value (1/1/1900 becomes 12/31/1899). Anyone else have this issue? If so, were you able to fix without coding for it?
View 1 RepliesI wanted to know how I would go about coding a website form controller in vb.net?I want to be able to connect to a website then enter a username and password by only entering the username and password and then pressing a login button on the windows form. How would I go about doing this?how to control website forms using windows forms.
View 3 Repliesrecommend a spreadsheet control other than the OWC webcomponents with very simple functionality? I just need a 2x100 matrix and the ability for user input. I need this for VB.NET and I need it to be compatible with both 32bit and 64bit systems.
View 1 RepliesI am wondering if anyone has any idea how to make the controls stack and fill up the available space left by a control if the control is hidden or removed from the UltraGridBagLayoutPanel.
Example:
[Textbox 1]
[Textbox 2]
[Textbox 3]
[Textbox 4]
[Textbox 5]
If I hide [Textbox 3] as of now, it will disperse the space left equally and pad the remaining text boxes with the space. However, I would like it to do this...
[Textbox 1]
[Textbox 2]
[Textbox 4]
[Textbox 5]
Where all the text boxes will move up and [Textbox 4] will completely consume the space left by [Textbox 3].
I have a spreadsheet in excel with three headers:
Project Name The name of a project i'm working on.
Requested Role The job title/profession of the project employee. (example: mechanic, manager, engineer)
The name of the employee.When i click on the Person's name i want another page or tab (specific to this person) to appear showing details about them such as their name, job title, how long they worked, what project they are doing... etc. (similar to a Facebook profile)
When i click on the project name i want another page or tab (specific to this project) to appear showing details about it such as the requirements, the deadline, who is currently working on it... etc.
Furthermore, i would like to set up two levels of access:For the specific pages i was thinking of using the tab control but i want it so that i can search through the list of projects or names, select one, and then it brings up the page about it.The levels of access is the least of my worries.
I have a VB.Net program that reads in a flat file, and then parses line by line, formatting the data into different spreadsheets in an excel workbook (each line can be any 10+ different record types so I parse and put in appropriate excel sheet).
For smaller sized flat files (under 10mb), the parser works great. However, I am trying this on a file that is over 120mb (400k+ lines). While running, I will get an OleDBException saying that the spreadsheet is full. Now I am pretty confident that Excel can handle a much larger data set than a flat file. So I assume this exception is not giving me the true story as to what is really occuring.
I open a connection, and then parse each line in the file, inserting each row into the excel file. I assumed it would be bad performance wise to open/close the connection between each insert. Could this be causing the issue? Any ideas what I need to do to handle such a large file? There are cases where the flat file can be over 500mb.
To actually do the insert into excel, I am just doing the following (I construct an sql query based on the type of row and values parsed):
Dim conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExportLocation.Text + "" + importFileName + "-PVF.xls;Extended Properties=""Excel 8.0;HDR=YES"""
[Code]....
I have been searchingall day to find out it, but did not find the best way, all but I found one forvb. That framework can not beused on 4, but can be used in the framework 3.5 and below.
View 4 RepliesI'm trying to create a windows user control project that has a textbox placed on it.I want the textbox to fill the user control window.I've built the control and added it to another project, but it isn't behaving the way I want it too.When I drag and drop the control from the toolbox onto a windows form and try to resize it, because the textbox.multiline property has been set to True, the Textbox resizes horizontaly and not vertically (just like normal textboxes do) however the underlying user control window resizes which is undisireable. How can I get the user control window to stop doing this.
View 2 RepliesSuppose I have a label control on a windows form called "UserName". How can I refer to that label programmatically using the label name? For example I can do:
For each ctrl as Control in TabPage.Controls
If ctrl.Name = "UserName" Then
' Do something
End If
Next
This seems quite inefficient. I would like to do something like: TabPage.Controls("UserName").Text = "Something" I did some googling but couldn't find a satisfactory answer. Most suggested looping, some said .NET 2005 doesn't support direct refenece using string name, and FindControl method was asp.net only...
[Code]....
I have a spreadsheet control on a windows form that I would like to populate with data from an existing worksheet (myworkbook.xls, sheet1).
View 4 RepliesI am trying to add a windows media player control to my form. However I do not see the control in the toolbox. Is there a way to add it?
View 3 RepliesI created a custom user control named "XYZ" and It is avaialble at the toolbox menu in the design mode and I can drag and drop it to a vb.net Windows form. What I really want is to dynamically to add this user control to the Windows form during the Windows form load event. Actually I want to add this user control to a "split container" named "sc_1" on the tab page named "tp_1" on a tab control named "tc_1" on a Windows form. What is teh vb code to add a user control to a Windows form. I am using vs 2005 and dotnetwork v2.0.
View 3 RepliesCan Windows Form Trigger when a control has been modify or not ? I mean i have 3 panel and inside of those panel have a textbox, how am i able to find whether some of the textbox where modified in a specific panel? i.e panel 3 textbox2 has been modify i want that i have a notification that panel3 textbox were modified
View 1 RepliesI have a VB windows application and I need a way to control input output from this windows application to a batch file.The batch script is quite complex so converting to a VB console application is out of the question because it will too much time.An simplified example is this:I have this batch file test.bat(just for example)
@echo off
set /p choice=name : %choice%
echo Hello %choice%!
In this batch file the user input the name which is then stored in a variable and after the user press enter on the screen will appear Hello + user input.
1. Is it possible to enter the name in a textbox from the windows form and by pushing a send button pass the name to the batch application and then the batch file to continue the operation of displaying the Hello message?
2. After the batch file finishes the operations it will open another console windows (3) with status of the various operations that take place on the system(in my case connected users to a server)Is it possible to hide this child console windows that are generated after my main .bat application finished the operations of opening connections?Can this be done from the windows application or I need to modify the .bat script?
3. Is there a way to collect the console windows output in a textbox from the windows application?One idea that came to me was to redirect the console output to a textfile and then read the textfile in the VB application but I want to know if there is another way.
4. Is it possible to hide this batch file inside the windows application exe?
I have a VB windows application and I need a way to control input output from this windows application to a batch file.
The batch script is quite complex so converting to a VB console application is out of the question because it will too much time.[code]...
1. Is it possible to enter the name in a textbox from the windows form and by pushing a send button pass the name to the batch application and then the batch file to continue the operation of displaying the Hello message?
2. After the batch file finishes the operations it will open another console windows (3) with status of the various operations that take place on the system(in my case connected users to a server)
Is it possible to hide this child console windows that are generated after my main .bat application finished the operations of opening connections?
Can this be done from the windows application or I need to modify the .bat script?
3. Is there a way to collect the console windows output in a textbox from the windows application?
how to create an use control?this link http:[url]....
View 4 RepliesI have a customer which as a Visual Basic Project in single instance mode with a wired presentation logic.
The main form contains a TabControl with mutliple TabPages.If I click on TabPageA another form is shown in front of the Form and resized to have the same size as the TabPage.
If I click on TabPageB the first form is hidden and another form is displayed.So basically for the user it looks like you have a TabControl with different TabPages which is not the case.
I tried converting the Forms to UserControls and put them inside the TabPage, but, thanks to the SingleInstance app, this would take a whole lot of refactoring. I tried it but eventually gave up because of many many runtime errors and I don't want to put any more effort in this.