If you have two text boxes and when you input two numbers it outputs th permutations in a third text box of the two numbers. Example: You put 5 in textbox1 and 6 in textbox2 textbox3 outputs:
5,6
6,5
I know this can be done with nested For loops, but I don't know exactly how.
I need to convert numbers to words, (ex: 123 to one hundred twenty three/ 123.5 to one hundred twenty three point five.I use visual basic express 2010. I intend to create a textbox for the input and use a label to show the result. If I call the textbox "textbox1" and the label "label1", what will the code be?
View 3 Replieshow can i add two excel sheets with numbers and the equal (similar)numbers to save once
View 1 Replieshow I can implement my calendar with VB .net express 2008 and MSSQL 2008 Express. How do I get it to work with datasets, binding source etc.If I go to Properties>settings my connection string is:
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CalendarDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True
and I have a table with fields:-
CalendarID
Subject
Location
Purpose
[code]....
I can Add the event to the calendar I have the necessary items on my form linked to my table and I can save them to my table:
Me.Validate()
Me.CalendarTableBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.CalendarDatabaseDataSet)
But I cant keep the event displayed on my calendar when I close it and open it again.
CODE:
I need to take user input, validate to ensure there's no negative numbers and display monthly fee and check fee in a Label.....with a calculate button_Click
I'm just using the default SQL Server Express in my vb 2008 express edition as my database server for my database operation. When I tried to update the records on my table I got a runtime error which indicates the error on this line 'myCommand.ExecuteNonQuery()'and it highlights a yellow background on it. The runtime error says "SqlException was unhandled: An expression of non-boolean type specified in a context where a condition is expected, near 'Number'. ".
Imports System.Data.SqlClient
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim myConnection As New SqlConnection
Dim myCommand As New SqlCommand
[code]....
I tried to start using VB 2010 Express with a program I originally developed with VB 2005 Express that I moved to VB 2008 Express successfully a couple years ago. It uses a database file (*.mdf) that is on the computer ( not out on a server). When attempt to run the program in debug mode, I get the following error "An attempt to attach an auto-named database for file C:Documents and SettingsTomMy DocumentsQuizzing StuffQuestion Database 2010QuizQuest ionGameQuizQuestionGameinReleaseQuizQuestionDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I first made a copy of the entire project folder that was working in VB 2008 Express and gave it a different name. In VB2010 I opened the project in the copied folder and it said it successfully converted the project. I am able to open the Data Source inthe Designer and see the database structure as I expect. I think the project is still using SQL Server 2005 Express (because it is what is checked in the list of prerequisites on the Publish tab).
Note, I have programmed off and on for many years, but fairly new to using databases and SQL Server.
Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 1 RepliesI am trying to re write a VB6 program using MS Access, many years ago, using VB 2010 express and SQL server 2008 R2 Express. I have a database with several tables, which I created using the designer. I am able to connect to the database and select data and display it in textboxes etc in vb code. What I have not been able to in code is to INSERT rows DELETE rows or UPDATE any data in the tables. I can do any of these operations using the Query Designer, but I want to do it in code. I can post some code if necessiary, but I thought it might just be some property that I had not set in the designer.
[Code]...
there Dream in Code Community! Im an okay programmer as far as skill right now I am still learning as we all are I need some help from some experienced VB.NET programmers in the community, Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords.
[Code]...
The program I am trying to modify was initially written using VB 2005 Express. I have subsequently downloaded the 2008 version. The program creates a monthly spreadsheet from a template. The old code that will no longer (highlighted and underlined) compile is as follows:
[Code]...
I'm using VB 2008 Express for our College Project. I'm also running SQL Server 2008 Express and have installed SQL Server Management Studio and used it to create my database. Both software have been installed and running locally. I'm trying to connect to the database from VB 2008 Express. Database connection wizard have 3 options:
connecting to Access db
connecting to SQL Server 3.5 compact db and
connecting to SQL Server db file.
[code].....
I have SQL 2008 Express and Visual Basic 2008 Express runing on XP Professional SP2. When I select add new data source from VB I don't have the option to connect to SQL Server 2008 express to get at the to SQL Server Database. I also notice that the OLE DB connector is not availble as a data connector. Can somebody please confirm that VB 2008 Express can connect directly to SQL Server 2008 Express and how I can achieve it.
View 5 Replies'm trying to use Visual Basic 2008 Express and connect to a DB of SQL Server 2008 Express but ... you can tell me why in the Database Explorer and the Data menu of VB only have the following options for data source? Microsoft Access Database File Microsoft SQL Server Compact 3.5 Microsoft SQL Server Database File does not have the options Microsoft ODBC Data Source Microsoft SQL Server obs.: I have the Visual Web Express 2008 installed, and there are the options available.
View 10 RepliesI am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 3 RepliesWhere in Visual Basic 2008 Express Edition Software program do you specify a specific installation directory for a program?
c:Program Filesfinished program
I want to publish my program to try it out on another system and I want to ensure its installed in the directory structure I want.
I recently created a very simple project in VB express 2008 to interface with a COM object from an external vendor. I then downloaded the VS2008 90 day trial and found that the identical code in a VS2008 project results in a COMException error "Object is out of scope". Is anyone aware of any differences in how the two packages handle COM object interfaces as I have run out of ideas. Both projects have identical code and all the references are the same. The CreateObject() method correctly creates the object, but any attempt to access methods inside the COM object result in that error. I can even open the VB 2008 Express project inside VS and it still generates the same error.
Here is the code - the vendor dll in question is from Siebel v8.0.0, you'll notice that I have commented out most of the code that comes after the error. Creating a watch in the debugger on the siebApp variable sees it correctly created as {System.__ComObject}type SiebelHTMLApplication. I first tried this by creating the Property Service for variable siebSvcs, but after I started experiencing the COMExceptions, I reverted to using the most basic method inside the COM object I was creating.
Imports
SIEBELHTMLLib
Public
[code]......
using Vb Net 2008 with SQL Express 2008 R2 in windows forms. that being said, I have a syntax problem in this form, form has 2 texbox an a datagridview and also the 4 components DataSet. BindingSource. TableAdapter, BindingNavigator. When I filter by LastName no problem it work fine (it's a String) but when I try to filter by CustomerID (it's alphanumeric) I get an error "Invalid character" here is part of my code: Private Sub surnameFilterTextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles surnameFilterTextBox.TextChanged
[Code]...
I recently installed vb express 2008 and with that download i also installed Sql server 2008. Earlier i have been working in MS Access so i have no experience in SQL server. My first problem is how to start sql server. I can see only following:
Start>All Programmes>MS SQL server 2008>Configuration Tools, Import and Export Data(32 bit)>SQL server configuration Manager,SQL server Error and Usage Reporting,SQL server Installation Centre. Moreover in Programme Files i have two folders:
1. MS SQL SERVER and
2. MS SQL SERVER COMPACT EDITION
how to start to create a database in SQL server with Vb express 2008.
registration code for vb 2008 express edition.
View 2 RepliesI am using VB 2008 express and SQL Server 2008 express on a test basis and I used to connect VB express to a SQL database (created in SQL Server 2008 Express management studio) file and it work perfectly until my hard drive packed up and I had to get a new one, so I had to reinstall both of these again and copied my old databases from a backup I had. Now when I try to connect to the database file it cannot connect. Network related error or the instance name is incorrect. When I look at the advanced options in the connect dialog it shows my instance as .SQLExpress and my correct instance name is .SQL2008Express. I clicked OK on the connect dialog and manually changed my connection string to the correct instance and that worked but whenever I run the application in debug mode it give me the same error as above.
View 1 RepliesI have six textboxes, and upon button press it randomly generates six numbers, one in eact text box e.g. [43] [85] [93] [1] [0] [17]..i create another six textboxes and at the same time allocate these numbers in ascending/descending numbers.I am not looking for any codes whatsoever, as i love the challenge of VB.Net.
View 2 RepliesIm trying to write a program that will do:
1.The average of the four numbers. This answer will be placed into a text box reserved for that value. This text box cannot be changed by the user.
2.The maximum and minimum values. These will be denoted by changing the color of the largest number green and the smallest number red.
3.The range of the numbers. The range is defined as the difference between the largest and smallest numbers. The range will be placed into its own text box, labeled as such. This text box cannot be changed by the user."
Im using visual studio 2008 and it has to be written in VB
So how would I use .next (random numbers) to randomly select something from a list of numbers but it can't repeat the number?I could do:
dim num as integer
dim r as new random
num = r.next(1,5)
if num = 1 then
elseif num = 2 then
etc.
That wouldn't work because it would repeat.If I donwload someone's game can I disect it in VS? :0 I tried going to open project, then I went to the folder and clicked open. It brought me inside of the folder so I tried to open the game but there is no form1 there. It says the games name then .exe in the explorer-like thing in the top right?Also, how would I have a value or something in a label and access it from a button.
Example:This is in a label.
Dim number as Integer
number = 0
Then in the button do
Label.number = 0
How would I do something like that? I want to use that a lot as I did in a different language.
I have a program that allows a user to input numbers from an inputbox and it displays the Total numbers entered, the sum of the numbers entered, and the average of the numbers entered. What I can not seem to find it how to have it display the largest number entered. The code I have so far is,
[Code]...
Is there any way to design and print reports using VB.Net Express 2008 If there is no solution, my backend is Access 2000 - so can I open & print a stored A2000 report from within VB.Net 2008 Express ? How
View 5 RepliesI'm having a virus problem on my PC with VS studio.If I reinstall on another PC, do I simply copy the VS studio folder shown in my documents into the new installation and all is well?Or just "projects and settings"? Or ?
View 4 RepliesI am making a program, where the user enters 6 numbers in 6 different text boxes, and it displays the larger of those 6 numbers. But I also want to make it where if the user enters a string value (like S for instance) in the text boxes, it gives an message and says "please enter the numbers again" and the user gets to enter the 6 numbers again. But when I do try to do that, it gives an error message saying conversion from "w/e the user entered" to Double is not valid. If the user just enters the numbers, it works fine. However, I am trying to make it if the user does enter non numeric value, it gives a message window and the user can reenter the numbers again.
Here is my code Example
CODE:
This is where I am trying to use IsNumeric to show a message if a user does not enter a string so the user can renter the numbers again, but when the user does enter a string value (say in textbox 1) it gives me an error message saying conversion from "S" to 'double' is not valid.
CODE:
Then right here this is where I have my series of ifs statements, this part works fine, it displays the largest numbers of the 6 textboxes every time. Error free.
CODE:
And do this with variable number 2, 3, 4, 5.
I know there are easier ways to do these with arrays and stuff. But I am not there yet. I am still learning about ifs and stuff.
I have just about completed a .NET project to write a program to randomly select numbers for a Bingo caller. Over the last month or so Ive learned a lot about .NET but heres something that I consider to be odd and maybe one of you guys can offer an opinion.
One of the features of calling Bingo in a small local club is that callers often use little sayings to accompany certain numbers, I expect youve all heard of (say) All the sixes, clickety click for 66 or 5 and 9 the Brighton line for 59 etc. My little program gives an option to incorporate these with a prompt for the caller that can be edited outside of the program. One of these conventional sayings is used when a number is reversed 12 followed by 21 or 45 followed by 54 for example, when the caller might call (say) 1 and 2, one dozen, number 12 And the other way round 2 and 1, twenty one.
So, I programmed in a bit of code to detect this and to over-ride whatever might otherwise have been the quote with And the other way round and set about testing it. Ive been through literally dozens of full 90 calls watching for the occurrence of a reversed number, spent a few hours doing it, and not once has it occurred which is to say the least, unusual.
So, Im wondering about the Rand Function, could it be that it isnt possible for a reversed number to be selected? Just so you know, I randomly pre-select the order of all 90 numbers, I fill each of the 90 elements of an array with a random number first checking that the number selected hasnt already been stored, if it has, I just get the next random number (and check that too of course), but I cant see how that could prevent reversed numbers being selected, especially in light of the fact that frequently it's not the 'next' number that's used.
am writing an system application for a company that must generate inquiry id and order id automatically. Whenever a customer makes a new inquiry or new order by clicking the add button, an automatic number should be displayed in the text box and when it's saved, it should be saved in the database access.
View 9 Replies