User Selects An Excel File And The Contents Are Loaded Into A DataGrid?
Dec 20, 2011
I'm in the process of adapting a current program that I've created to automate it. **Current State***User selects an excel file and the contents are loaded into a DataGrid User can select which environment to run their query against (stage/prod) Program completes processing and updates datagrid with new values User can export datagrid to excel What I'd like to do is centralize the program on one computer and have it monitor a network folder for creation of a specific file type (*.xls or *.xlsx). If one of these is created in that folder then I want to add that file to a queue for processing. Once done processing I want to send the results as an attachment to an email to the user that created the file. After a file is processed I would like to remove it from that folder as well (into a diff folder of completed items).
[Code]...
View 8 Replies
ADVERTISEMENT
Jun 8, 2012
I am making a minor basket system which the user selects a number of products from a datagrid and it adds them to a basket using an array list (arrItemID).However on the ViewBasket form I want another datagrid however a query is formed listing the selected products. Though the datagrid seems to be empty (though the query when outputted to a text box is ideal. [code]
View 3 Replies
May 31, 2012
I am trying to decrypt a file and the decrypted contents will be loaded to a listbox.
Public Sub Decrypt(ByVal inName As String, ByVal outName As String)
Try
Dim array As Byte() = New Byte(&H1001 - 1) {}
Dim num2 As Long = 8
Dim stream2 As New FileStream(inName, FileMode.Open, FileAccess.Read)
[Code]...
View 12 Replies
Sep 21, 2010
I have a form on which the user selects a file using an openFileDialog. The selected filepath is then processed, which may take 10-20 seconds before the user is presented with the results.I'm finding that the once the user selects the file (clicking the OK button on the openFileDialog), the openFileDialog remains open until all of the processing going on in the background is completed. Once the processing has finished the openFileDialog disappears and the results are shown.The problem is that whilst the openFileDialog remains open on screen, it is not apparent to the user that anything is happening in the background. I do actually have a textbox which updates the user with messages showing the progress. However the openFileDialog hides the messages until it closes, essentially making the progress messages useless.What I'm trying to do is have the openFileDialog close immediately that the user selects a file. Then the processing can continue without the openFileDialog obscuring my form.
View 5 Replies
Jan 6, 2010
I am working on cinema booking system project in vb.net..I have to book seats in the cinema..I have created a file for seat reservation for every movie..The seating is such that there are 18 seats and in the file have written 0s and 1s indicating reserved and vacant seats respectively..User selects a movie from a combobox and the corresponding file opens..We have to change the color of those seats which are already booked to red.Here is my code but it doesnt work..
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles movies.SelectedIndexChanged Dim Seat As Button() = New Button() {Form4.Button1, Form4.Button2, Form4.Button3, Form4.Button4, Form4.Button5, Form4.Button6, Form4.Button7, Form4.Button8, Form4.Button9, Form4.Button10, Form4.Button11, Form4.Button12, Form4.Button13, Form4.Button14, Form4.Button15, Form4.Button16, Form4.Button17, Form4.Button18}
[Code]...
View 5 Replies
Aug 24, 2011
I decided to rewrite my project. Hit another snag. How do I write the contents from a datagrid to a file and back into the datagrid again later? (Actually, I've done the writing ok - but for the life of me can't get the data back into a blank datagrid.
Here's what I done so far:
Imports System
Imports System.IO
Imports System.Text
[Code]....
View 4 Replies
Apr 17, 2012
I'm using Microsoft Visual Basic 2008 Express Edition. I have a Folder Dialog Browser added in my form and I call it when the user presses a button. The folder path string is stored in a string variable and displayed as text in a text box. (maybe I should use a combo box)
My question is: If the user inputs by hand a non existent path, how do I return an error message, stop the file creation into the invalid path, and return to my main form?
View 1 Replies
Jun 5, 2011
I have a datagrid table with 5 columns and as many rows as the user enters. Is there a simple way to export the contents of the table to a CSV file?
The columns are named; a,b,c,d and e Im using VB 2005.
View 11 Replies
Nov 15, 2010
I have an OpenFileDialog. I want the program to copy the file that the user selects to my "temp" folder. If the user doesn't select any file, then it doesn't copy any thing. Here is my code:
Dim Temp As String = "Temp"
If Not Form6.OpenFileDialog12.FileName = "" Then
System.IO.File.Copy(Form6.OpenFileDialog12.FileName, Temp & System.IO.Path.GetFileName(Form6.OpenFileDialog12.FileName))
End If
But it doesn't copy any of my files over that are loaded in the OpenFileDialog.
View 1 Replies
Apr 21, 2010
My text file is something like what you see below, and I want to populate the datagrid. Once I populate the datagrid, I'll use that kind of like an excel spreadsheet in the sense that I'll dip in and grab values based on row and column index to display to the user. I will also (on a different form maybe) display the same datagrid to the users so they can sort by column at their choosing.[code]The error I am getting is: Value of type 'Integer' cannot be converted to 'System.Windows.Forms.DataGridViewCell'.
View 1 Replies
Aug 29, 2010
the project i am currently working on has a form in it that has quite a few objects that take a couple of seconds to load. Because of that, if i simply use the .show command, the form shows up, but there are a bunch of blank white boxes where the content is still loading, how can i have the form not become visible until ALL of the contents and images inside are fully loaded?
View 1 Replies
Jun 2, 2010
This is the code that I have to export data to Excel.
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object
oExcel = CreateObject("Excel.Application")
oBook = oExcel.Workbooks.Add
[Code] ....
I can create and save the excel file, but I can't update the contents.
View 2 Replies
Apr 17, 2010
I want to get the contents of my excel file and put some of it to textboxes..
View 4 Replies
Mar 5, 2012
I use vb.net express 2010. I have tried to find a way to add an EULA to my project but have not found it (nor any solutions online).
does express have the ability to add an EULA?also is there a way to get the setup file to move the database into a particular area OR have it make a new database where the user selects?
View 1 Replies
Nov 1, 2010
I am creating the items in a combobox in my code behind. I am setting the display member and the value member. When the user makes a selection from the combo box, I need to get the value of the selected item. I have written some code, but when I step through it, it says that the selectedvalue is Nothing.
Here is the code where I am creating the items in the combo box:
Do While drReader.Read
cboTheater.Items.Add(drReader("TheaterDesc"))
cboTheater.ValueMember = CStr(drReader("TheaterID"))
cboTheater.DisplayMember = CStr(drReader("TheaterDesc"))
Loop
In the selected index change event for the combo box, I am doing the following:
Dim strTheater As String
strTheater = CStr(cboTheater.SelectedValue)
When I step thru the code, strTheater is Nothing
View 2 Replies
Jun 12, 2011
How would you be able to Capture the Value of a Cell when the User Selects a Row?
View 7 Replies
Jan 12, 2010
i have created a comboBox and want to set it so when a user selects option1 from the drop down list. a Text box populates with text for the user to see.
View 5 Replies
Dec 6, 2011
I am not sure what the heck I am doing wrong. I would like if when the user selects no, then the app setting is nothing. By nothing I mean nothing, I am using "Nothing" to test but its not working it returns whatever is in the richtextbox
This is in my formclosing event
Dim msg As String = "Do you want to save your comments?"
MessageBox.Show(msg, "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
If DialogResult = Windows.Forms.DialogResult.Yes Then
[CODE]...
View 2 Replies
Aug 10, 2009
How do I make it so that after the user selects a program it gets executed?Also can I the the OpenFileDialog1 to anything else?
View 13 Replies
Jun 2, 2010
i need to create an application(VB.net or VBA) which will convert text file contents into excel. u the contents fromt he text file have delimiters(special characters).The condition is while converting it should remove all the delimiters and paste teh content between two delimiters in to one cell.For Eg:
Text fiel content
|WGS|123123123|[Rxxxxx~CXXXXXCCCC~ADVANCED PPPPPPPP ASSOC
Excel sheet content:
WGS 123123123 Rxxxxx CXXXXXCCCC ADVANCED PPPPPPPP ASSOC
View 3 Replies
Jul 5, 2009
I'm trying to assign a number from a row the user selects in a DataGridView to a textbox. On the dgvProducts_CellContentClick event I wish to take whats in column(6) to a textbox.
[Code]...
View 1 Replies
Nov 23, 2011
In my datagridview, I want to be able to change the value of comboBox1 depending on what the user selects in comboBox2
I had this working correctly, however if I move onto a new line in my gridview and select a different value in the second row it changes the previous row also. For instance, on Row1, if comboBox1 = A, combox2 = B
Then on Row2, if comBox1 = Y, comboBox2 = Z
However, when I change Row1, Row2 is also changed to reflect what was chosen in Row1. Is there a way I can tailor it to each specific row?
View 7 Replies
Oct 19, 2010
i am trying to design and code a simple help desk program. i would like it to send the details that the user selects and types from the form i have designed (see picture) and also to send the username, computer name, servername and a copy of the windows event log for the previous 15 minutes, to a designated email address in pretend I.T. department.
View 4 Replies
Jan 4, 2011
I have a form with a drop down combo box and a list view. The user selects a date from the combo box and then they are to select an item from the list view. I want to ensure that the user has selected a date from the combo box before processing the information from the selection in the list view.
If cboYEARMONTH.SelectedItem = Nothing Then MessageBox.Show("Please Select a Year Month")
View 1 Replies
Jun 2, 2010
I have 2 combo boxes. One is in a form called subcat_selector.vb
on the button Pick Sub Catagory.click event it shows the subcat_selector form. form there, the onload event:
Dim button As DialogResult
[Code].....
View 10 Replies
May 27, 2010
I have a combo box and use the SelectedIndexChanged event. I noticed when I assign a value to the combo box that this event fires even though the user does not click on the control. Can you tell me how to test for when the user clicks on it and actually selects a value from it?
View 19 Replies
Apr 27, 2012
I am populating text boxes when a user selects a company name from the cbo box. When I make the first selection everything looks good, but when i make another selection the text boxes do not clear and repopulate with the new values. Here is the code in the selected index change event.
[Code]...
View 4 Replies
Jun 14, 2012
I have a datagridview that is filled by a query in the dataabse via the DataSource property.What I want to retrieve some infomation from the record that a user selects in the DataGridView. How do I do that? i've been looking for some time now but I can;t figure it out.
View 6 Replies
Sep 7, 2009
I have a field called "payor" where the user selectes either "All, Medicare, Managed care" from a drop down list. I am sending the value of payor to the Fill query once the user selects the one they want.
I have no problem with coding 'Where (payor = @payor) if the user doesn't pick ALL, but what code do I need to include ALL records if the user selects "ALL" in the where statement?
View 7 Replies
Dec 2, 2009
I am using a Message box with buttons Yes/No. If the user selects a quantity of Dogs a Messagebox is displayed asking if all the dogs have been vaccinated. If the user says yes I want them to be able to proceed. If the user selects No I want the number in the combo box to delete and go back to zero.My code for the button selected is this:
Dim button As DialogResult If button = Windows.Forms.DialogResult.Yes Then btnCalculate.Focus()
End If
If button = Windows.Forms.DialogResult.No Then
[Code]...
View 6 Replies
