I'm playing around with the Select Case structure and have the following code:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim colour As String = InputBox("Please enter the name of a colour.", "Colours")
[code].....
I have an assignment that asks me to:
1. create a button
2. when that button is clicked, an inputBox will appear to ask the user how many words they will enter.
3. then display an inputBox for each word.
For example, when the first inputBox appears, I enter "3" (meaning that I will enter 3 words).Then there should be 3 more inputBox (each inputBox allows me to enter only 1 word)After I enter the third word, there will be no more inputBox.How can we FLAG (stop) the inputBox, or let the inputBox know when to stop showing up?
How do i search data by using input box? it'sdo i use the inputbox for search data?.I have codes but not working. look my example code.
Dim conn As New SqlConnection
conn.ConnectionString = "server=Ryan-PC;Database=DRRM_Student_Database;User ID=sa;Password=*****;Trusted_Connection
[code].....
im having trouble try to validate the data in the inputbox. I am trying to make sure only integers/decimals are entered, but the code is failing to reconize it in the loop, and the loop dosent promt the user to a valid number. What am i doing wrong or this a weakness of the inputbox?
'Developer- John Nelson Date- March 5, 2012 Application Name- Semester Final Averages Purpose-This application allows an instructor to enter up to 10 project scores from a course for a semester compute a students average score. The application displays the final average for the semester with the two lowest grades removed from the average. The eight scores are sorted in order and final averages are written to a file named grades.txt
[Code]...
Im working on a project that needs to save data and show the data from a inputbox to a label text. Its suppose to keep track and show the name of winner in a game and their score i got it to where if you win the input box pops up and ask for your name and number of guesses but that about all i got
txtHint.Text = "You Guessed It"
InputBox("Name of the Winners", "Number of guesses")
[code]...
and that whats put in the input box will show in the lblscore but it doesnt work, wounldn't i need to delcare a Var and if so where do i put it.
My assignment involves wrinting an airline reservation brogram where the user can hit a make reservation button and the user can then input passenger name departure city and arrival city, all of this has to print to a multiline textbox, the professor also wants a find reservation button and a cancel reservation button.
Public Class Form1
Sub get_data()
Dim passengername As String = InputBox("please enter passsenger name")
Dim departure As String = InputBox("please enter departure city")
[code].....
I have created a users database in access and included that database in the bin directory of my project. I have then created a connection to that database using the wizard in 2k8 express.What i need to be able to do is to insert usernames into the users table in the database. I am at a loss of where to start with this problem. Do i need to create a recordset or not? If so how do i write an sql query in VB2K8 to insert data into that recordset and then update the underlying database?
View 1 RepliesQuick question on the InputBox. I am just learning this, what is the code to "read" commands that are placed from the Inputbox? I can do this in the command line: System.Console.Writeline(), System.console.Readline()
I just would like to know how read the line from the inputbox. Also when I debug my script do I -always- need to have the command prompt in the background?
I have a DGV that is getting data from a sql db. The dates in this db are stored as doubles ie 40025.708681
How do I format this column as Date/Time?
I tried but this doesn't seem to work.
how to do this? DGV1.Columns("HostDate").DefaultCellStyle.Format = "d"
This the test example.
Dim dt As DataTable = New DataTabledt.Columns.Add("StartTime")dt.Columns(0).DataType = System.Type.GetType("System.TimeSpan")
[code]....
i just write code for application, in which data is get by user and entered data is to print in a particular format?give me a code for vb.net button by which after click on it will print entered data?
View 1 Repliesin one of my table i use some date which has quantity and unit in it
for eg
"quantity" "unit"
10 pcs
[code]....
( for both quantity and unit i am using two different columns)now the thing is that i want to the total quantity as per units in one text let say textbox1 in this format
"64 pcs , 27 mtr, 12 sets"
how to get data in this format.
I am implementing RFC 1350/TFTP in my application. I've got everything figured out and working as expected except for NetASCII transfer mode.
"A host which receives netascii mode data must translate the data to its own format."
That's the part that has been bugging me for a while now. get NetASCII mode working correctly?
i am doing a VB program using four for loops to generate a set of numbers using the following code.[code]i need to export the output of this program to CSV format.
View 3 Repliesmy code is working fine, but the output shows for example 12345.000 i would like to only show the data before the .000 is this posible?
[Code]...
does anyone know a simple code that would save data in zip format ?
View 3 RepliesSo what i am trying to do is get what i query to write to a text file i am having trouble getting my variables right so th at i get my "smessage" format to spit out so called data[code]...
View 1 RepliesI am wanting to develop a VB program that will access a web page containg XML format data and pick out one number.I have opened the web page and see the number between tags <*> <*> how do I point my search to the web address, I have found XML examples of data being searched when the file is on your hard drive, how to point my program to a http:// web address and then how do I scan or search for my number?
View 1 RepliesHeres my code under the console application[code]...
How do I keep the inputbox up until the user guesses the right answer?
I have a large data.DataTable and some formatting rules to apply.For example, the LASTNAME column has a value of "Jones" but my formatting rule requires it be 10 characters padded with spaces on the right and uppercase only. Like: "JONES "My initial thought is to loop through each row and generate a string. But, I wonder if I could accomplish this more efficiently with a DataView, LINQ or something else.
View 1 RepliesI have a label that displays information from my database and I need to format it. It displays a number format like so: (53389) and I just need it to display (53,389)it uses the SQL to COUNT or SUM the data from the datasource. is there a way to have it format like I want when it is displayed, or do I need to change the data format in the database?
here is my code:
Try
Me.MAINTableAdapter.Fill(Me.MainDataSet.MAIN)
Me.MAINTableAdapter1.FillByExceeds(Me.BurnListingDataSet.MAIN)
[code]....
I am currently reading a table from Access database and displaying it a DataGridView. Here is my
Dim ConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= ....db1.mdb"
Dim SQLString As String = "SELECT Cost, Average, FROM expense_summary"
[Code]....
All the files in my access data base are numeric (database cannot be changed) but I need to change the value formats in the table. I want to convert one particular cell in the table to a percent with one decimal and also display the '%' symbol. Similarly, I want to round and display a '$' symbol in another cell. How would I do that? How would I select a specific cell in this table to change?
I am developing windows application. Now I have got the data in the data set . Now I need that to be displayed in the table format, not in the grid.but in the table format as we get in web applications.Is it possible to achieve it? If so how could it be archived?
View 1 RepliesI'm looking to get the following code converted to working VB.NET code. I need to export data from a datagrid into the CSV format that the user can save off, and the code below from David in Dakota would work great, but it's in C#. This is for a Silverlight 4 site we're working on.
private void exportHistoryButton_Click(object sender, RoutedEventArgs e)
{
string data = ExportDataGrid(true, historyDataGrid);
[Code].....
I have a string like the following.
<td>aaa</td><td>bbb</td>...
Now, I want to extract each of the <td>...</td> group. How shoud I do this?I tried to use xml to do this. However, since xml doesn't support < and & in the content area and I can't guarantee there is no such two characters.
I have a dgvAssetsSummary which holds data queried from the database, it hold's the AssetType column and Total column, it's grouped by AssetType, giving a summary of all the totals and what assettype they belong to.I'd like the Total column to be formatted so that there are no decimals and with commas, at present each total has four decimal places and no commas, this needs to be able to be read easily by clients. I've tried using the following code to format the column after I query the database, but to no avail.
dgvAssetsSummary.Columns("Total").DefaultCellStyle.Format = "#,#"
how to do this, I've had a bit of a look around but I can't find much. I'm currently looking at a couple of pages from the msdn library about it.
Back on my form with a ton of financial data entry textboxes but I want to have the data formatted at runtime, as I enter the data.I have a format declared as Public Const cFmtCurrency = "##,###,###" ' don't need decimal for the local China currency What would be the least compicated way to have these textboxes (19 of them) format the Long Integer values as I enter the data. I think a Lost Focus event would be silly; there must be a better, more efficient way.Also want to use this format when I retreive records from the db (don't see a reason to mask data in db)
View 7 RepliesI am using VB2010 and have a project set up with a DataGridView that is to display a table of data selected from a SQL 2008 database using a pre-defined dataset. My question is simply how to display the data in the intended format as seen in the attachment. I am attempting to merge rows in the first two columns of like-data. Addtionally, if that can be done, I would also like the user to be able to double-click on a name that would open an editing form.
View 5 Repliesasking a newbie question. Where is the format properties for changing the data display format in VB2010 Express
View 4 Repliesi can retrieve the data from the DB and put it in a vector and then, vector in a JTable, to display data in a tabular format in java, all i wanted to know is there any similar way in vb dotnet?
View 4 Replies