How To Make Database Programming
Jul 30, 2009
I am working with MS Visual Basic 2008 Express Edition and MS Access 2007. I have managed to populate a temporary table with data from a text file containing eight fields. I have applied the namespace System.Data.OleDb What I want to do now is: 1) to order the data by a specific field (let's say Fld4); 2) delete duplicate records; 3) append the sorted data to a main table; 4) write the data from the temporary table to a new text file and save to a folder; 5) clear the contents of the temporary table
View 3 Replies
ADVERTISEMENT
Jan 5, 2011
When my picHero enter a room where a picEnemy exists I should make the picEnemy follows picHero no matter how it moves up, down, right, left and as picHero is moving 5 px i want to make the picEnemy moves 4 px. I've tried to do use a condition as
Code:
if(picEnemy.location.X <> picHero.location.X) then
location = new point (picEnemy.location.X+4, picEnemy.location.Y)
picEnemy.location = location
endif
Also for the Y axis, but it didn't work.
View 18 Replies
Apr 16, 2012
So i learned about classes today and i am totally confused about them. How exactly do they make programming life eaiser? I though Functions and Sub Procedures were making my programming life easier
View 4 Replies
May 11, 2009
i have to make a project for my programming class in VB and this is basically what i want to do in pseudocode form
1. Display initial form
2. Choose from one of two to four choices (my discretion) via Button or radio, whichever is easier
3. once you click next, or the choice button, display next form depending on which choice and close the old form.
View 3 Replies
Dec 19, 2009
Im New To VB and i was wondeing how do you make a picture box bounce from the sides of the form.
View 8 Replies
Jul 8, 2010
I am making a game in vb.net and was wondering how to make question box eg. if a person clicks on a button he gets a message boxs which asks him a question he has to answer. the msgbox should have a text box or something for input and if their answer is the same as the one i have specfied then the message box says correct. if not then says it is wrong.
View 6 Replies
Jan 8, 2010
I'm trying to make a manabar that will drain, using this code
Code:
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Timer1.Start()
End Sub
[Code]...
View 7 Replies
Aug 13, 2009
something like this
pctObject.horizontalPosition += 5
I just dont know the right syntax
View 2 Replies
Mar 22, 2011
I am having some trouble working out how to make the ghosts chase PacMan. I have made all the code and stuff work with needing a grid maker thingy. I have do in all by placing the walls (pb's) myself and also with the pelets (food). Though I have a problem with getting the ghosts doing their job, they only just change image with a timer tick. Any simple way of making the ghosts chase you?
View 4 Replies
Dec 20, 2009
I have a button named cmd_Grunt and a picture box named pb1_Grunt. I want to click the button and have a picture box created.
"Public Class Form1
Dim grunt = (50)
Private Sub cmdGrunt_Click(ByVal sender As System.Object, ByVal e As
[Code].....
This is the code I have so far. I get an error message, "Expression expected." It wants the expression between "CreateObject" and "('pb1Grunt', grunt))".
ie cmdGrunt_Click(CreateObject HERE ('pb1Grunt', grunt))
View 19 Replies
Nov 18, 2008
is ther any way to make my screen follow my sprite? I want the visable area of my game to change when my sprite moves past this X value 284 but i can not figure it out ill post my VB Express code below
Code:
Public Class Form1
Dim Y As Integer
[code].....
View 2 Replies
Jun 16, 2009
i'm new to database programming and am currently learning vb.net and ms sql. I was working on a simple add-edit-delete program and somehow i managed to make the Add button work, with this code:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Try
con.Open()
Dim sqlAddProduct As String
[Code]....
View 1 Replies
Jan 13, 2011
I'm trying to build a login page and I'm having trouble programming the connection to the database.
The page can be found at [URL]
Here's the
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<%@Page Explicit="true" Language="VB" Debug="true" Autoeventwireup="false"
[Code]....
I'm thinking that as long as I have bin/MySql.Data.dll, I should be fine. I'm obviously wrong.
View 7 Replies
Dec 17, 2008
So my question is, I'm wiriting a VERY basic dice rolling program for my computer programming class in high school. I'm using a randomize function to generate numbers but I only want it to do numbers 1 - 6....how do I do this?
Dim x As Integer
Randomize()
x = CInt(10 * Rnd())
Dim Y As Integer
Randomize()
Y = CInt(10 * Rnd())
That is my code for my x and y (each die) to generate code, but how do I make it do 1 - 6 ONLY? Develope a game that in which a player rolls two dice. Each die has 6 faces. Each face contains 1, 2,3,4,5,6 after the dice have come to rest the sum of the spots is calculated, if the sum is 7 or 12 on the first throw, the player wins. If the sum is 2,3, or 11 on the first throw, the player loses, and the house wins. If the sum is 4,5,6,8,9,10 on the first throw the sum becomes the player's point. To win, a player must roll the dice until the plater rolls the point value. The player loses by rolling a 7 before rolling the point. I also have another question, How would I set this up to keep up with points and stuff? and the part that says "The player loses by rolling a 7 before rolling the point." I have no clue what to do on that. I'm not asking for code hand outs. I'm just asking what functions and such I'd use to write the code.
View 6 Replies
Oct 23, 2009
I'm not positive if this should be here or in graphics so I'm sorry if I'm posting it in the wrong section.I'm trying to make a program for the game Go. Now before getting upset that I want to make the game go I just want to say that I have looked for months for this specific thing and I still have yet to find it. I want to make something to simulate go so that two people can play on the same computer. The problem I ran into was capturing stones. Stones are captured when surrounded and then they are taken from the board. The problem is that I don't know how to make the program know when a black stone is surrounded.
I have thought of a grid detecting but the possibilites on a 19x19 area are too high for anybody to sit down and program. I have also thought of using picture boxes and the edges to detect other pictures, but there are ways for stones to group together and the opponent must surround all stones to capture them.
View 3 Replies
May 20, 2012
Close a database that we created by programming?I have created a database with below codes[code]...
View 3 Replies
Jun 24, 2010
I am writing a program which includes access to a Microsoft Accsess database. It is running fine on my work computer (windows xp) but when I transfer it to my laptop (windows 7) to work from home it stops running on the "open" statement. I have stripped out all other code so that I just have a program with this in:
[Code]...
Again this will run fine on my desk computer but will not get past the open statement on my laptop.Interestingly, if I start a brand new project on my laptop and paste this code into it - it runs correctly.
View 9 Replies
Sep 24, 2011
I don't know how to take input from user in sql statements, i'm learning from different sites so i don't know how to do it. Here's the code.
Public Class Form1
Dim con As New OleDb.OleDbConnection
Dim dbProvider, dbSource, sql As String
[code].....
View 3 Replies
Sep 20, 2011
I want to learn database programming with SQL server, so I've have installed MySQL administrator 1.1.9 and MySQL connector net 6.4.3, is it ok with these or should I change?
View 4 Replies
Dec 22, 2010
does anyone know how to make an hpbar that changes color with respect to percent health?ive been trying to come up with an algorithm that would give me r g b values depending on how much the character has left (%).
Supposedly if the character is near death or has low hp, the algo would out put r=255 g=0 b=0 and if mid health r=0,g=255,b=255 (or watever yellow is), and if full g=0. but i need a smooth transition
View 2 Replies
Apr 3, 2008
im trying to make snake in visual basic.net for my major year 12 project in Australia and i cant get it to work?
View 5 Replies
Dec 12, 2011
Well this is a re-post now as nobody replied in the gaming section, and i believe this question could go as a normal VB question, therefore I'm asking in this category instead.I have decided to pick up on programming and want to make a text based RPG Game i will "upgrade" as my programming knowledge grows.I got some ideas that i think i should use, but i want you guys' opinions on it.I assume I'll use different classes for each monster, which will have properties.Should those monsters then be inside a list of all possible monsters, or would i have a monster class which i would use and generate the enemies when needed? And would i use the same approach on items and character stats?
View 4 Replies
Feb 24, 2011
I have a login in system that i'm creating for a game. I have this code for checking to see if the username and password are correct in the text file.[code]I want to know how to make the for loop stop once the username and password have been found correctly.Also, where would I put a message box saying that the username or password are not correct if they don't match up or they're not in there at all?
View 3 Replies
Jul 21, 2009
The Calendar control (the Month Calendar) control in VB 2008. I am creating an attendance timesheet and I want the Calendar to color each date differently like e.g An employee Paul is selected from a list.
On the calendar I select the month. (The dates are not supposed to be selectable). Then lets say it is June. He is late on the 1st and the Second, so those days are supposed to be colored red (the whole block). Let's also say he is absent on the fourth and so I want that date to be coloured black. How do I do this? I tried finding a query and my friend told me that this functionality is not available in the current control and that I was best off making my own control (???).
I have tried selecting specific dates and bolding them (there is a function that allows this) but I am stumped trying to find two different ways to differentiate colours. Second:- How do I link a calendar with an Access Database?
View 10 Replies
Jan 28, 2012
I have recently taken a liking to programming, and have programmed a few games in C#,my friend has asked me to program an application for him to use in his shop. But I have no idea of what language is best suitable?
View 8 Replies
Feb 26, 2011
Iam developing a Windows application using Visual Basic 2008 with a SQL Server database. Throughout the program I give the user as many options as possible and have no problem with either the database or the windows forms. The program does not initially require a Login and I want toprovide the User with the opportunity to add a Login to the system. The default Login form is perfectly satisfactory.
The problem is that I can't figure out how to program the change sothat the Login from isopens the program rather then th form designated as the StartUp form. this forum I am able to prgrammatically change the form but I can't figure out how to make the requirement a permanent factor. I tried using a Constant, but if the User wants to change, you can't change the constant. Its an apparantly simple yes/no situation but if I set a varable to yes and then change it to no the next time the program runs, the change will be lost.
View 6 Replies
Apr 2, 2008
im trying to make a game in visual basic in which your character can move around, jump, and kill things. I can get the picture box with the character to move and everything is fine. but i did run into one problem. when the character moves over a tree (or something) you can see the gray backround of the character as i made in paint. how do i make the backround of the picturebox transparent?
View 4 Replies
Feb 1, 2010
I am trying to make a game which basiclly lets you shoot ducks. i have a picture as a background (set as form image) i then have picturebox's with ducks flying flying around you shoot them the disapear etc.
My problem is the image. i have a picture of a duck and a blue square round it. and i would liketo make it transparant because birds dont fly with blue squares.
Below is an image to illistrate my problem
I have tried adding transparent background, transparant key etc
View 2 Replies
Apr 20, 2010
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
View 4 Replies
Apr 8, 2010
i need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
View 2 Replies
