I am using Visual Basic 2010
i have three tables
Table Names are Students, Customers, Members
fields in Students Table Like Below
StudentID
StudentName
StudentAddress
StudentMobile
[Code].....
I'm using Visual Basic 2010 Express and Access 2003. I'm trying to make sql querys to the mdb file. I'm using OLEDBConnection. The Select query works fine, but I can't insert rows in the table. Here is the code.
Dim connStr As String = "provider=Microsoft.Jet.OLEDB.4.0;data source=" & System.IO.Directory.GetCurrentDirectory() & " pv.mdb;"
Dim con As New OleDb.OleDbConnection(connStr)
con.Open()
[Code].....
How To Copy Specific Records from a Table to TempTable Then TempTable's Content Display in GridView
View 1 Replieshow to display Table Contents in ContextMenuStrip using visual basic 2010
i have a Table "Students" field names are "StudentsID and StudentsName" have 20 Records
now i want to display All students name in ContextMenuStrip work like a popup box
I managed to displayed records from two tables in one datagridview and the first column being a combobox. Now, I would like to get those records displayed and save it to another table. this what I did.
For i As Integer = 0 To dtgLoad.Rows.Count - 1
Using command As New SqlCommand("INSERT INTO tblteachersload (Teacher ,SubjectName) " & _
"VALUES (@Teacher, @Subject)", cnn)
With command.Parameters
.AddWithValue("@Teacher", Me.dtgLoad("Column1", 0).Value)
[Code] ......
I would like to loop through the records of the datagridview and then save the same to a table.
I have a database that has two tables in it. One is a table of items (table1) and the other is the table of current items (table2).On form load I need to generate a random amount of the items from table1 and populate table2 with them. I was trying to do something like this:
[Code]...
I would like to display the multiple records in multiple textboxes Following is my tables and data:
tblJan with these data:
col id
1
2
3
col January
10
20
30
now i want to display the value 10 in one textbox and the value 20 in another textbox and so with the value 30 in another textbox..
I'm doing a simple database thru VS2008 and Msaccess without using any builtin relationship between records, now i need to know how i can retrieve specific data from access using the oledbadapter or any, example seek if the value from the textbox1.text is already existing in msaccess table then msgbox "Record already exists.", note that the code is in keypress event of the textbox1.
View 2 RepliesI would like to install a recent version of Visual Basic in all computer rooms of the IUT.Is it possible to install "Visual Basic 2008 Express" on multiple PCs (using ghost) by activating only the application on the machine used to create the image ? After deployment, the other PC in the room will they work ?
View 8 RepliesIs it possible to run a vbscript using Visual Basic 08 coded to a command button? Also if I have more than one script that I need to run at once but they all have the same variable (url) any way to enter the variable to each script at run time? I'm trying to avoid having to manually editing each script with the new url to submit..thinking that I can code up an app using Visual Basic that will click a button to launch the scripts and then by typing in the url to use the program would inject that each script at run time....
View 4 RepliesI'm trying to connect foxpro table (dbf) to VB.NET. I'm trying to display the records of that table to listview in VB.NET. Here is my
I got an error message here, the error says "cannot open the file"
vb.net
Imports System.Data.SqlClient
Imports System.Data.OleDb
Public Class Form3
[Code].....
I have a table called tbldebt which I am trying to use the binding navigator to display only records that match the curent username the following code works but displays all users records?
Dim dbConnection As New SqlConnection(My.Settings.loginConnectionString)
dbConnection.Open()
' create the data adapter
[code].....
i have create software using visual basic 2008 now i am stuck with several matter
i need a code that can open multiple URL in one time... when i click the button.. the URL also i can easily add or deleted it
I am trying to display *.rpt file in visual basic submit form, how would I do that? I have Report2.rpt and Form1.vb, I like to call Report2.rpt when submit button is clicked, it will then show the report on screen.Private Sub SubmitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SubmitButton.Click.[code]And also how do I get the date to be queried in my crystal report, I don't want all records, I just want the records in between fromDate and toDate.
View 2 RepliesI need to display records from a database in Access in Visual Studio 2010. The project Im looking to create needs to display all of the records from the database and allow the user to navigate throughout the set of records.
I need controls and codes to:
MoveNext
MovePrevious
FirstRecord
LastRecord
Exit
I used the following code to print out my database. but it is print out empty page, I would like to be able to print database from visual basic.I know how to go about it? the following code is print empty page. Private Sub PrintDocument1_PrintPage(ByVal sender As System.Object, ByVal e As
[Code]...
below code gives me an exception telling me that it is an invalid column name. It's taking the input string from "frmMain.txtBadge.Text" and thinking it's the column name. I havesearched for days without any clue.
View 12 RepliesBack in Visual Basic 6.0 and prior I could have a picturebox control and then have multiple images on that and using a gif file; then I'd have some images transparent. For example, I am trying to make a map where each country has it's own layer and the void is transparent so the underlying picturebox contains all the water.
However, in visual studio I've noticed the image control is now gone. I tried using a panel and a picturebox on top of that and it works but I can't use another picturebox on top of that picturebox, nor can I stack multiple panels with the same affect.
How to use multiple rdlc file in one ReportViewer? in same dataset using visual basic 2010
View 1 RepliesI've made sort of a "Game"
I want to add an Item to all accounts. I know HOW to write into files and add the item but it's adding it to ALL accounts.
Accounts Dir: C:DatabaseAccounts"Username"Items.txt
Without adding EVERY Account file as a streamwriter how would I make the streamwriter do all available directorys for the account's name.
I've been working on this project for two weeks now and I'm drained from all the hiccups I've come across. Now I've hit a brick wall.I'm making a "simple" order form in Visual Basic 2010 that calculates the amount due for an order and then from the total determines what the shipping will be. I've been able to accomplish the following tasks:accept customer data (name, address, city, state abbreviation, zipcode)calculate total with shipping costs (accurately, for the most part)clear the order form and exitBut the way I have it right now, a customer can only put in 1 order form.
Problem: I have to figure out a way to allow a customer to place an order form for multiple items. (I'll assume that a customer will not place an order for more than 20 items). So what would be the best way to go about saving the information for multiple items then calculating the cost at the end?If it's multiple form creation, how is that done? Is the keyword "Container" the way to go, and how
Snippet Code:
Private Sub total_mouseleave(ByVal sender As Object, ByVal e As EventArgs) Handles total.MouseLeave
[code].....
I was wondering how to get a certain data from a MS database and display in a label. Example(Database entries)
[Code]....
The name will be displayed in the label depending on the year and number typed in two text boxes. So if typed 2009 and 1001, the label should display name2. I don't have any background on SQL. The only thing I did for now is that I added the database in the data sources and added a TableAdapter.
I have two problems with my datagridview in VB 2005 that I did not encounter in VB6. I would like to add multiple records to a datagridview by allowing the user to tab and type.When they get to the end of a record and tab it should go to the next record like Access does. The user can move to the next record and it even shows the pencil on the left leading them to believe that a new record is being created. But, it will not create the record unless they first click on my button that will add the record with the code BindingSource2.AddNew(). I use a bindingsource to populate the datagridview. Here are some snipits of my code for clarity:
DataGrid2.DataSource = BindingSource2
GetDataDetail(
"Select * from [Order Detail] Where [Order Detail ID] = Null")
[code].....
I've created a table in SQL and inserted specific information into it programmatically. Now I need to export this whole table data, including headers into txt file (tab delimited)- from within Visual Basic project (Windows type application).
View 11 RepliesI want my calculate button to automatically click multiple times upon the user clicking it once because it seems that it only works properly if it is clicked multiple times... I'm not sure if there is an error in my code.
Public Class frmford
Dim Make, Model, InitialPrice, Options, AirConditioningTax, GST, PST, Total, Subtotal, Finance, Months, RoofRack, SunRoof, SideAirBags, TintedGlass,
[Code]......
I'am try to make multiple file deleter in visual basic so here is my code.
Public Class Form7
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
OpenFileDialog1.ShowDialog()
[code]....
But my problem is that if add two or more files it just deletes the last one on the list box. How can i make it delete a the files on the list box?
why cant i display my 2 table records in two datagridviews in windows form? it only display the records of table 1 to the 2 datagrid views
[Code]...
I have a data grid view with data bound. So i would like to edit the data inside the datagridview. but i want to edit the data inside the datagridview cell by choosing combobox with dataset. So how can i add the combobox into datagridview current cell with data bound?
View 5 Replieshow to edit and update in relational table's record in visual basic 2010?
have two tables with Relationship
1, Orders
2, Order_Details
"Orders" Related with "Order_Details" ( OrderID )
now i want to Edit and update. Record in "Order_Details" ( "Pencil" to "Pencils" ) Then Update changes
my code is below
Dim CurOrder_DetailsRow As OrdersDataSet.Order_DetailsRow
CurOrder_DetailsRow = CType(CType(Me.Order_DetailsBindingSource.Current, DataRowView).Row, OrdersDataSet.Order_DetailsRow)
[Code]....
I have th is little programm:
Dim dbOud As ADODB.Connection
Dim rsOud As ADODB.Recordset
Dim strCnnOud As String
[code]....