I'm really new to any form of VB programming and I am trying to create a form which will allow me to take information from an attached database holding information on:
class names (i.e. Year6 Dragons)
Students names (i.e. Sarah Jessica Parker)
I want the design to look very similar to the form used in MS Access for the query wizard, which will allow me to choose a class and then specific students.
I have a vb.net 2010 application and I would like to get the scanner info (modal name, port, etc.) attached with my PC. I use windows xp SP 3 in my machine and Cannon scanner is attached with my machine.
View 1 Repliesi am creating a booking system for my A2 project but i cant create tables or field in the database and enter information in them. I have created a ms access database in vb but after that im stuck. The database must be created in vb programatically as i get more marks for complex code.
here's my code
Imports ADOX
Module Module1
Sub Main()
[Code].....
I already know how to call insert, update, delete & select procedures in DataSet.xsd window. And I also know how to call queries by table adapters. But I just found out that its not possible to call all functions by queries (such as insert). It works when I test the query but when I try to add it, it says "Failed to get schema for this query". So I built a few stored procedures which do many functions (such as transaction, insert, update etc...). But I am unable to use these stored procedures in VB form. I found some tutorials mentioning that it can be done by defining connections and some other stuffs with which I don't want this to be. I want to call these procedures by writing code in VB code editor window with DataSets, TableAdapters, BindingSource etc...
View 2 RepliesI'm making a database app. I've finish the search, add new, and add function. What I'm trying to do is to expand the functionality of the add new item function.
View 2 RepliesI have develop a wiindows application and it's done in MS Visual Studio 2008 using the VB language and it connect to a 2005 sql database. now i want to deploy my application and want it to be directly attached to my database so that when someone installs it, it comes directly with the database attached to it.
View 1 RepliesI am trying to do is fill out a form with certain info, put the info into an array, and write it to a listbox using loops, arrays, and maybe a function if I need one. This is for VB2010 and here is what I have so far... I think there are ways to make it shorter but I cannot figure it out.... maybe just brain dead from all the coffee I have been drinking!
[code]...
I have a problem with attaching sql server database to an installer file.
View 1 RepliesCould anyone help me to find the template design for the above form ? or any toturial Video that teach step by step on how to develop such the above form please ? (Visual Basic 2010)
View 6 RepliesI have already connected my database and have completed multiple forms and reports.Just discovered that I missed adding ONE field in an Access table.Since it is attached how can I add a field to the database without disconnecting it? If I do disconnect it and reconnect will I have to redesign all my forms and reports?
View 1 RepliesIs it possible to have a voice prompt attached to a textbox on a form so when you tab into the form the user hears "Customer name" or "Amount" or whatever?
View 6 Repliesi want to know how to create a log in form using a database..i've watched some videos but its failed.im using visual basic 2008 and access database 2003...i have created a table for password..
View 9 RepliesI am opening a Second From IN Different Thread and I am using this second form as Progress bar.This second forms opens as another form but I want this not to appear on taskbar instead it should be on top of the original main form.
If ProgressTitle = Nothing Then ProgressTitle = "Batch Process Is Running #1" End If PricingRunning.Text = ProgressTitle PricingRunning.PB.Value = ProgressPB PricingRunning.SB.Text = ProgressSB While running = True PricingRunning.PB.Value = ProgressPB PricingRunning.SB.Text = ProgressSB[code]....
Now I have created this order form but when I click on the ADD button nothing happens. I expect when I click on the item automatically the data is added to my database. i am using SQL Server 2005
View 1 RepliesNow I have created this order form but when I click on the ADD button nothing happens. I expect when I click on the item automatically the data is added to my database. i am using SQL Server 2005
View 5 RepliesI am creating a program for an existing database that stores the info into the database. So can I link an already existing database in MS Access to a GUI?
View 2 RepliesIn my winforms project, some of the forms have a set of ContextMenuStrips defined on them (through the visual studio designer).Some of these contextmenustrips have been attached to controls, but others have not.Now my problem is this: I need to go through all of the ContextMenuStrips at runtime, whether they are attached or not.I've got some code that will recursively go through all controls and check the ContextMenuStrip property and this works fine.... However I can not get to the ContextMenuStrips that haven't been assigned to a control yet.
View 1 RepliesFirst of all let me say im not trying to change the assembly of the main app (done by going to the properties etc..) I have an application which (On press of a button) creates a new file (Newfile.exe) i would like the user to be able to specify the new files version info etc... I have tried a DLL called Flash Dissasembler which I did not like.
View 7 RepliesI'm working on a sales system. I have a form which consist of all the following information (item code, item name, item price, quantity of item) which is display using a data grid. Data input by user using text box and all this information will be stored in a database (sales database) I'm using ms access 2007. the grand total will be displayed in a text box. And amount paid will be input in a text box too, my major problem now is how to I create a receipt that will have all this information of the purchase. I have a receipt button. How to get the reciept done.
View 3 RepliesVisual Basic Project - Student Check In Form using an Access database backend This form needs to draw information from an Access database containg tables for STUDENT, INSTRUCTOR, and SECTION. These all need to have primary keys and ids. When (the user) clicks on the drop down box that displays all the sections:
{Table Tennis 1, Table Tennis 2, Table Tennis 3, Billiards 1, Billiards 2, Billiards 3}This should populate the listbox or datagrid from the STUDENT table with the Students that have the same SECTIONID as the SECTION selected in the drop down menu above.
After the Student list has been populated (the user) clicks on a student name in the listbox/datagrid and this inserts that student into the CHECKEDIN table that has a datagrid/listbox associated with it.
This is a great project to practice connecting a database to Visual Studio 2008 .net and playing with the data that has been pulled in. You could use SQL instead of Access.
[code]......
View 1 RepliesI want to use a form in vb.net 2010, so when I click on a button ,it must show me the info of a specific row in Exel and display info of that row in a text box.
eg.
Name Surname phone
Koos Leeds 08212122392
How do I start with this, any samples.
I'm trying to make a simple game, but i have a question.i have a minimum damage and maximum damage lbl boxes on 1 form and i have a button if clicked it opens a 2nd form with buttons that deal "damage" when clicked
1. Attack (a regular attack that would deal the damage from form 1)
2. another attack ( this deals damage from form1 + 8)
3. another attack ( deals 30% damage for 4 attacks [so 4 attacks that deals 30% damage each])
4. another attack ( this one is great. it deals damage of 2 times of minimum damage to maximum damage and a third label box lblAP (attack power) which each 2 points of attack power you have it adds 1 more damage.)
i can do that math i just have no clue how to bring the info from form 1 to form 2.
i am trying to make a login screen that is connect to a database(NOT MS ACCESS).i keep geting an error when i try geting it to conect to the database
"Value of type MySqlData.mySqlClient.MySqlDataReader cannot be converted to System.data.OleDb.OleDbDataReader
At rdr = MyCommand.ExecuteReader()
dose anyone know whats going on
[Code]...
I created a database in access 2007, linked it to my project in visual studio 2008 (vb). When I enter some data using the UI, it does not save it in the database, and it's gone as soon as I run the program again. I dragged the textboxes from the datasource panel, onto the UI..
this is the code that was automatically generated by vs for the save button:
[code]Private Sub StaffBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StaffBindingNavigatorSaveItem.Click
[Code].....
I have 3 labels I want to populate with info from my database. I have a SELECT statement that works for only one piece of info but I need it to include the other 2 as well.
I have 3 labels: Current, YTD, and MTD My select statement is working for YTD but I don't know how to write the SELECT statement to include the others.
[Code]...
This code is correct...
Do While rdr.Read
issuebook.cbmember.Items.Add(rdr.Item("FName"))
Loop
Suppose i want to add both last and first name..I tried this but getting a error
Do While rdr.Read
issuebook.cbmember.Items.Add(rdr.Item("FName" & " " & "LName"))
Loop
I have selected the info that i want from my database but im unaware of the syntax need to be used to add them to the datagrid.The datagrid has the column...BookName, DateRetun and DateIssued.
cn.ConnectionString = "data source = RayonRayon; initial catalog = library; uid=sa; password=minnie"
cn.Open()
cmd.Connection = cn[codee]....
got a new problem while trying to add a new user into the database. After i've submitted all the data i get an error message saying "Conversion failed when converting the varchar value "Aron" to data type int" to be honest, im totally stumped as to what this could meen, does it meen its trying to convert string type data to an integer? Anyway heres the code im using
[Code]....
im trying to add a new user login to my database through my program, and i've got the procedure worked out, i just dont know how to retrieve the inputted data.
Basically i've got three text boxes that ask for "Name" "Password" "Phone Extension" but how would i work them into his statement?
CreateLogin.CommandText = ("INSERT INTO Users (UserID, Password, Phone) Values How would i follow up after "Values"??