I get a problem with my program. My program should do :
-Explore folders from a main folder (LOGS)
-See if there are csv files
-Copy the data from CSV (all informations are on the first column)
-Paste it in one xls file (with a sheet for every csv)[code]...
i having trouble with exporting data from a dataset into an excel file, mainly i have included references to excel 12.0 and included the import line:Imports Microsoft.Office.Interopand i try to export a dataset to excel using a button that contains the following:
Dim row As Integer
Dim col As Integer
Dim rowCount As Integer
[code].....
I have a SQL server table that has a list of Usernames and a list of points ranging from 1 to 10,000.I want to display the number of points in my VB.NET program from the username given. For example, if I type in "john" in the first box the program will give me a message box saying whatever amount of points "john" has. I'm not really sure about
This is the Table Structure:
Usernames Points
-----------------------------
[code].....
I have a data entry screen to collect data. At the bottom of the form I have buttons to add a new record, save current and add, save current and end, and an end without saving. The buttons all function properly. After clicking the save current and add new record button, a new blank record comes up with the cursor on the save current and add button. I haven't been able to figure out how reset the tab order so the first field in the entry screen is ready for data. I'm coming up empy on my research.
View 2 RepliesI have 4 textboxs in my new form. and each of them, i want the data from the db show in the txtbox.[code]...
View 1 RepliesI collect two sets of data from two different databases, This data is now in two collections. I then join/append the one collection to the other and then put it in to a list view.I really would like to order this list view by the first column without the click event.To make this even harder the First column contains Data that is DateTime and i have found that it orders the items by the day number and not the months or years or time.I have found one way but it then cause's me further agony when doing some checks upon the data within the listview later in my code. This answer is to rearrange the format to "yyyy-MM-dd HH:mm:SS" then using the listview.sorting = sortorder.
View 7 Repliesi want to create an application that collect data from the rs-232.Someone have a code example with multi rs-232 in thread .I have one pc that have mapping virtual com.
View 1 RepliesI have an access database with 3 tables, want to collect data from 2 and insert them into a new row in the third (although this seems redundant there are reasons for wanting it that way). I created a form and call the data from the two tables fine, once the form is filled I try to add a new row to the third but it will not add the row even though it is telling me that is has. When I open my access table the record is not there. I am new at this and just can't figure out why it won't work, I have tried several approaches the latest is
Code:
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.Activate()
Dim IDNUM As String = InputBox("Enter Student ID Number")
'storing the text entered in a string
[Code] .....
We use a database to create Data Collection forms with dynamic items
I used this code to generate labels and textboxes from a table in database (when the user hits the button "load CRF")
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click[code]...
I have just written an app in VB 2010 with .NET 4.0 that contacts our field loggers to collect data via modem or IP. Originally it was written without threading, but now the requirements have changed and I need to collect data simultaneously from 4-6 sites at a time. I have never used threading, TPL, etc. Can anybody tell me where to begin so that I can concurrently run multiple collections?
View 6 RepliesI am running into an issue with phrasing the following XML. I need to load the content into a object that is outline in the second code block. I am looking for all items to be Property flags within the Object.
<MigrationType>
<MigrationOption id="1">
<NAME>Project Configuration</NAME>
<DISPLAY>TRUE</DISPLAY>
<PAGE id="1">RequiredItems</PAGE>
[Code]...
We are creating a VB program for school to collect data on student attendance and populate it to a table. I have all of the 'GET' statements but am having trouble creating the 'Insert' procedure. This is what I have so far. The form being used to fill the table has 4 items being recorded. 'Present' radio button marked as present, tardy or absent; StudentId, PeriodId and date. Not sure if we are on the right track. The target table is tmAttendance. There are approximately 25 rows of data on the input form.
View 3 Replieswant to make a program where you can select multiple files and when you press a button, all files are being copied to one specific location.
View 6 Replieshow to detect the source and destination of files being paste?VB .NET Code would be appreciated, I can monitor Copy but not Paste.
View 1 Repliesi need to copy some files from Application Folder to system32 and need to create regisrty while run the setup
View 1 RepliesI have a small copy/paste type of program. You put text in the boxes, click copy and it copies it to the clipboard. I have a text file attached to format the text when it is copied. what I want to accomplish is...If I don't fill in every single textbox with text, I don't want that particular field to show when I paste it. Example, I have the layout like below on the text document.
textbox1.
textbox2.
textbox3.
No matter what, when I click copy, the text document is going to copy textbox1,2,and 3. If I only put text in textbox 1 and 3, I don't want it to copy textbox2 if its empty.
I have a text box and want to know if the data enter into is via pressing numeric keys or via a CTRL+V or via mouse right click.
Do not want to use windows message to process for paste/right click paste event.
i want to create a program in which i want to use function key like F12, F11 i mean to say when i press F11 or F12 a particular code is paste in text box. when i used this method in my own form text box it works but i want to use it another window like google search box or
notepad. when i press F11 in notepad then my code should be pasted on that page
I have these files [code]...
How can I use code to put all data from these files to a new file for searching purpose?
In the key down event for a text or rich text box:If (e.Control) And (e.KeyCode = Keys.V) Then e.SuppressKeyPress = TrueTo prevent pasting for all text boxes on your form, set form KeyPreview to true and add the above code to form key down event.
View 4 RepliesI have a webbrowser control which I have created a contextmenu for. I have added a paste button and do docbrowser.body.inner.body = clipboard.gettext. The problem with this is when I copy text from a word document and paste it I loose all the formatting. If I remove my context menu and use the default and paste I keep my formatting.
View 2 RepliesI want to copy data from a website and paste it into Excel.
View 4 RepliesI have a data-bound DataGridView. I want to know if it is possible to copy data from Excel and just paste it into the DataGridView it, click on the button ... would be to copy the Excel data from clipboard to DataGridView. What I want is to copy two columns from an open excel file to the first two columns in a DataGridView.
View 10 RepliesI have set data into clipboard and I have assigned it some hot key e.g. ctrl+alt+d now I want is while the my application created in vb is running whenever I press the hotkeys my program will put the data into that active window by getting it from the clipboard.
View 2 RepliesI've made a Rich Text Box in VS 2008, how ever when I try to actually paste data in to it, either by right clicking it or by using the short cut CTRL + V, nothing will actually paste in to the RTB.
View 6 RepliesI have a table I created in SQL Server Management Studio. I had to create it there because I needed to use a function for an alpha-numeric ID column that increments itself. I then exported the table, but had to use my local server. Now, in visual studio, I have the local server connection that contains the table I want to copy to a connection for a remote server. I can right-click and select 'Copy', but I can't right-click and 'Paste' into the database I need.
View 2 RepliesI have a simple application where output is posted on to a textbox.
Eg:
John Smith
101 Road street
NewTown
I need to copy this data in exactly the same format and paste is in word or textpad. How do I go about this. What do I need to make sure when I copy the data from outputtext box the format of the text is exactly the same as it is the textbox?
Is it possible to make sort of an installer where you have your files you wan to install in the Project resurces file and then copy and paste them into a directory?
View 16 RepliesHow to avoid webbrowser data copy, paste to word or notepad in vb.net. Disable right click on webbrowser by using IswebbrowserContextmenuEnabled =false
View 1 RepliesI am making an sql search engine. I need it to find a row of data take some of the columns and paste it to some labels or textboxes.Need some help with the code got my connection, command, I am thinking on how to split the notes and the username onto two different controls or should I get two different sql statements for them ?
Private Sub btnFind_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFind.Click
Dim con As New SqlConnection
Dim cmd As SqlCommand = New SqlCommand("select owner, notes from orders where orderref = '" + txtReference.Text + "'", con)
[code]....