VS 2010 - Allow User To Input Data Into Spreadsheet / Table
Apr 13, 2011
I've worked out how to display charts in VB 2010 Express, but now I'm needing the user to input data into a spreadsheet/table that will be used within the program. I know that table is no longer available and neither is the OWC11 set. Is my remaining option then to use DataGridView? I know it is SQL based and I don't have much experience there yet, but I didn't want to commit to it if there is another method that would work just as well. The values that are put in by the user does not need to be preserved.
View 3 Replies
ADVERTISEMENT
Jul 7, 2011
I have 1 access database with 3 tables How do I make the combobox get data from one table and input it to another table?ex.I have a table with all my Carriers and another table with jobs that are assigned to Carriers?
View 3 Replies
Apr 12, 2011
So I'm developing a Windows Forms Application in Visual Basic 2010. The user searches for data and fetches results, updates fields and some other CRUD operations. I want to provide a user input validation. Usual stuff i.e. some fields need to be always numbers>0, others need to be non-empty in order to avoid Null access on some objects and others just need to be some fixed strings.
[Code]...
View 3 Replies
Jan 12, 2012
I am trying to export table data to an excel spreadsheet.It would be beneficial to have filtering pull-downs in the spreadsheet.I would be will to purchase any software tools to make this task easier. Otherwise are there some tutorials for accomplishing this?
View 4 Replies
Jan 15, 2011
I need some help with the input validation of my application. Attached is the code that I have written as well as a screenshot of the front end. I specifically need input validation to verify that the user selected input for cbLengthOfStay is a number between 1-10 as well as input validation to verify the user input for txtMedication, txtSurgicalCharges, txtLabFees and txtRehabilitation is a positive numerical number. Please feel free to critique my attached code. [Code]
View 2 Replies
Nov 12, 2010
I have a flow document table with text in it. The text some timess just on one line , often on many lines, that means it could include a return and a tab spacing (all in the same cell).I want to put the data from the table to the clipboard in such a way that i
View 7 Replies
Mar 10, 2009
I am using Visual Studio 2005. I am using a data reader to read an Excel spreadsheet and want to update a SQL Express table. The datatypes in this table mimic a software application I will eventually be passing data to and are listed in the comments in my code. No matter what I do or change, this will not run. I even populated my spreadsheet with zeros and this will not run. I have found many suggestions on the web and tried changing things but nothing seems to work. I also don't know specifically which variable is causing the error or the proper way to make sure there are no blanks in this spreadsheet.The error says "conversion from string "" to 'Double' is not valid Here is my code:
Public Sub btnUpload_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpload.Click
'Connect to the Excel spreadsheet
Dim xConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & txtFileName.Text & ";" & _
using a data reader to read an Excel spreadsheet and want to update a SQL Express table
View 1 Replies
Nov 3, 2011
Option Strict On Public Class Form1 Private Sub btnDistance_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDistance.Click 'The btnEnterSpeed click event accepts and displays up to ten speeds from the user'and then calculates and displays average speed
[Code]...
I cannot figure out how to incorporate the number of days into the input box then get it to loop and count the number of times the User inputs in the number of days. Then I have to incorporate it into the equation to get the total distance D = MPH * Hours. What I have right now wil not count up the number of days and locks up after I input one number and will not add anything to the listbox. Because I also have to make sure that they cant add nonnumaric values and the number of hours per day cannot exceed 20. I have put things in and taken them out but it has been 2 days and I am lost now
View 1 Replies
Mar 11, 2010
I need something tje user can type in data to such a parts QTY cost etc. There are no predefined parts list so the user can enter any part name/Number and there is no limit to amount of parts that can be entered.
Does anyone have any idea what might be useful. It was thinks of a listview bu i can't see that you can type into that. I cant use comboboxs because there are no predefined list and i know there is some way to generate text at runtime (i think) but i don't know how to do it and i would prefer a clearer approach.
View 3 Replies
Mar 21, 2010
I need to code a basic multiplication table in VB. I need a popup input box to ask the user to enter a number, then a label to display the multiplication table for that number from 1 to 9.
[Code]...
View 5 Replies
Mar 19, 2011
My basic set up is Visual Basic 2010 Express on Windows 7 64 bit What I'm trying to do is to have VB 2010 get the data from a Open Office spreadsheet. I have looked around on the general interenet and have found quite a few references to MS Excel, but none dealling with Open Office. The code samples I have tried to use seem to rely on MS Excel being installed (Which I dont have). The 'Automate excel' page (Here: http://support.microsoft.com/kb/302094) naturally seems to rely on a Microsoft Excel Object Library reference that, not surprisingly, isnt there because I dont have MS Excel. Keep in mind I havent mucked around with a programming code for decades!
What I do have is Open Office 3.2, which CAN save spreadsheets in a excel format (.xls), and a few others such as .ods, .dbf and .xml (Excel 2003?).
[Code]...
View 1 Replies
Jun 15, 2009
I'm just trying to create a graph where the user can input data into textboxes and then plot the data. I am attempting to use Zedgraph, but open to other suggestions. The program below creates a plot, but it won't update when the textboxes are updated.
Imports ZedGraph
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]....
View 7 Replies
May 10, 2010
I have used following code to create and write the user input data to XML through Dataset. Hope it can be understood by looking the following code:[code]But the above code is not working. it is not writing the value in XML file.
View 8 Replies
Apr 19, 2011
I am coding a Student Management System using VB.NET and Access DOn the Form for Teacher Bio-Data, I want to use a table in which I can place Teacher Qualifications in a tabular format. In other words, say, the teacher had Primary, Secondary and Tertiary education. I want to put a header as Qualifications, Year and Grades. Is there any such tool in Visual Studio that I can use?
View 9 Replies
Apr 16, 2009
I am using a RichTextBox to allow user data input.I need to allow a user to select all, and change the font value of the text within the RichTextBox.
View 1 Replies
Apr 9, 2012
I have three tables in my SQL Server DB. I need to import some CSV files into these tables. First table is a Order Table, which will contain all the order level information from that customer in that CSV File. Each order has multiple items and the second table is an item level data. Third table is a mapping table which shows the mapping for each customer . for a Customer say A ,
[Code]...
View 3 Replies
Mar 15, 2012
How do I determin if a user has given me what I am asking for in terms of data type.
Example if my prompt to the user say "Give me a number of double data type"
How can I tell that the user entered a double xx.yy?
Or if I am testing for integers and I get user input ABC.GH?
I know about CDbl and CInt and CStr but these don't work unless data is provided. Also how do you test if the conversion took place? Also how do you differencate between 12.00 being integer?
View 4 Replies
Sep 30, 2009
I want to create a page in asp.net website . it has to have one text box . the user enter the productcode in the textbox and click on search . when the user click search i want to display all the information about that product from product table.
[Code]...
View 2 Replies
Dec 18, 2010
I have two pages the first one will receive all data that are required from the user such as username e.mail and then the same page will do the calculation but when clicking on result button two things should happen: 1-the result and all user inputs should be sent to the second page 2- the same information should be sent to the user email as the e.mail messege
View 1 Replies
Mar 8, 2009
I'm trying to make a program where user can input data from a textbox into an array and when the user hit the enter key, it compare it to a data grab from a text file. Here is my code so far:
Private Sub TextBox_KeyDown(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox.TextChanged
Dim input As String
[Code]....
I got the part where the program can graph data from text file and put it into an array called "varia3". The part I could not get is allowing user to enter data into the textbox. When I run the program, the sec I try to enter a letter or number into the textbox the program ended.
View 2 Replies
Nov 14, 2010
i want to convert the user input field to MD5 Algorithm
View 2 Replies
Jan 23, 2012
How can i limit the user to input only one period in textbox cause in my textbox the user can input may periods on it??
View 3 Replies
Apr 17, 2012
I have a text box that I only want the user to enter A, B, C or D (it'll give an error msg if anything else is entered)
View 6 Replies
Apr 16, 2012
Ok, as you can see I am totaly new with Visual Basic. I have learned all those loops, if&else statements, byval, byref and etc. But now, I want to create this kind of application. I have 3 textboxes. One will contain URL, second username, and last password. There is a listbox also and a button. I want when user add a values inside textboxes , that values go to listbox as one variable and then save those settings for user so when he start up application again there are saved variables inside listbox. I just dont know how to do that.
View 11 Replies
Feb 17, 2011
It's been a good few years since I dabbled in VB and I'm very very rusty so any help would be great! What I'm looking to do is search an access database with user input and display the relevant record.I have a single table set up in an access database called school_info with the following fields and data:
Tres________DfE________Name_________Type
001________1234________School 1________Primary
002________4321________School 2________Secondary
[code]...
I've linked the database to my new project, connected the database and added the 4 fields to my form. When I run it, the data shows in the boxes fine.The Tres and DfE fields are show in text boxes on the VB form, and the school and Type are show in labels. What I really want to do is be able to manually type in either a Tres or DfE number into the relevant text field and have the other labels auto populate with the relevant data that's stored in the database table.
View 9 Replies
Jun 9, 2010
So far i have a really basic form application that allows a user to enter some information and does a small calculation, displaying all of the information gathered on the final form.
Im looking to try to save this information but have no idea where to start,im trying to just take whatever is in my text field and put it in a table row. I created a one table database in Access and linked it to the form with a button to try and save it.
I thought it would be as simple as tablename.rowname = textbox.text or something but apparently not and all ive ended up with so far is this:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Me.Validate()
Me.TblCustomerBindingSource.EndEdit()
Me.TblCustomertableadaptor.Update(Me.DatabaseDataSet.tblCustomer)
End Sub
I dont even think im close, ive just been fiddling with the predefined code in Visual Studio, trying import ect but the button just doesnt seem to do anything.
View 2 Replies
Mar 11, 2010
i have a access database with two tables, one for customer and one for booking.
I then have a form application i made in VS 2008 which lets a user enter details such as their name phone number ect into text boxes.
All of the information the person enters thoughout the program is shown via labels at the end, all on one form.
Would it be possible to then have a button that when clicked saves all of this information into the access tables into the correct columns, im sure it must be possible i just don't really know where to start.
View 14 Replies
Jul 22, 2011
I'm developing a windows forms application using VB.NET. I'm currently working on DataReport (by Microsoft, not Crystal). Everything works fine when using DataSet as DataSource. But I have a question on how am I going to put data to my DataReport from a user input? Preferably when the user is on the act of printing(clicking the print button in the ReportViewer), a Form will pop-up and ask him for input. That input I'm talking about is random names of people, and we don't have to track their names so there's no reason to put it on the database.
Here's my simple setup:
MainForm.vb (Form)
MyReportViewer (ReportViewer)
MyReport.rdlc (DataReport)
[Code]....
If it is impossible to do it on the act of printing. Maybe on the MainForm_Load event or before the generation of report can do.
View 1 Replies
Jun 9, 2011
How do I prompt the user to input elements in a two dimensional array? And how do I then save the output?I've figured out how write and print a program where the program provides the elements (see short version below), but I can't work out how to get the user to input the elements instead.
Solfa(0, 0) = 11
Solfa(0, 1) = 12
Solfa(1, 0) = 21
[code].....
View 2 Replies
Oct 6, 2011
I have DataTable, and is bound to DataGridView. So, when the user inputs some values in 4 columns, it would calculate the sum and put it in the last 2nd last column.
Here's the code that I'm experimenting:
vb.net
Private Sub DataGridView1_RowLeave(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.RowLeave
Dim i As Integer
Dim intTotal As Integer = 0
For i = 5 To DataGridView1.Columns.Count - 3
[Code]...
So, basically it should sum up certain columns when the user enters numbers into it and then display it in the last column.
View 3 Replies
