Create A Form That Allows U To Query Tables In Access?
Mar 18, 2009Im trying to create a form in VB that allows the user to perform queries on a number of tables which are in access.
View 3 Replies
ADVERTISEMENT
SQL Data Access: VB2008 / VB2010 - WinForms - Create A Datasourse And Drag / Drop Fields Or Tables On A Form To Create A Grid
Oct 22, 2010I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
Create Temp Tables In Access DB In .NET?
Aug 2, 2010I am using Access DB.I want to create Temp Tables in My DB.What is the Syntax for Crate Temp tables in VB.NET??
View 5 RepliesCreate Temporary Tables In MS ACCESS?
Oct 10, 2010Is it possible to create temporary tables in MS ACCESS using VB.NET?
View 3 RepliesCreate Access 2007 Database And Tables At Runtime?
Jun 5, 2011I have a requirement to create n Access 2007 database & some related tables from my application at runtime.
I used to be able to do this ages ago in VB5 but having difficulties doing it in VS (VB) 2010.
Create A New For Open The Dataset Drag And Drop The Tables To Form?
Dec 31, 2009i have a few questions about seting up a form.when you creat a new for open the dataset drag and drop the tables to form it creates a top menu bar with pages plus sign and x and save.now when you run the app you need to press the plus sign to add data in the database..is there a way to make it that you dont need to press the plus sign?
View 3 RepliesTimeout Using SQLite - Create A Database And Several Tables - To Populate The Tables With Data From Arrays
Jul 25, 2012I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
To Add More Tables - Access All My Tables Togather At A Time
Mar 25, 2009I have a 5 tables in my database and i want to access all my tables togather at a time.e.g.I have a code for one table i.e. rs.Open "select * from Group_info", con, adOpenDynamic, adLockBatchOptimistic. instead of Group_info table i want to access 5 tables also as Login_table,User_info table,group_name table etc. How i do that
View 11 RepliesQuery Access Database And Display Data On New Form?
Sep 6, 2010I have a program in which I want to have the user enter two percentages and display the data matching the criteria on a new form. The query would be:
Select *
From Corrosion
Where corrpct1 >= {column in database} OR
corrpct2 >= {column in database}
The way I currently have it written is to display only one row of data. I need to display any number of rows that meet this criteria. My current code is:
Private Sub btnDetails_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDetails.Click
Dim form As New frmDetails()
Me.Hide()
[code]....
1. How can I do my query to incorporate the user entered criteria (in the where statement)?
2. How can I display ALL of the data instead of just one line?
VS 2008 Embed A Window On A Form Like Access Query Builder?
Dec 18, 2009In Access, when you build a new query, you can add tables to the view, which is then represented by individual windows that are somehow embedded/constrained to the upper portion of the query designer. I know then typically, windows are free floating anywhere on the screen, but somehow they manage to keep it confined to a certain container area. It also appears that the windows never get a real "focus" as the title bar is always a faded shade of blue, yet, you can still click on them and move them around.
View 3 RepliesSQL Query From 3 Tables?
Aug 15, 2011I am having difficulty with a SQL query in my project.I have 3 tables.
T1:
- Date
- ID
- Location_ID
[code]....
From this I need the T1.Date and T3.Result based on Location in T2.So my I need a query to compare a known location, get the Location_ID. Then Use that Location_ID to get the Date and ID. Use the ID to get the Result from T3. (Value is a variable with the known Location)
This is what I have tried:
"SELECT T1.Date,T3.Result _
FROM T1,T2,T3 _
WHERE T1.Location_ID = (SELECT T2.Location_ID FROM T2 WHERE T2.Location = '" & Value & "') AND T3.ID = (SELECT T1.ID FROM T1 WHERE
T1.Location_ID = (SELECT T2.Location_ID FROM T2 WHERE T2.Location = '" & Value & "'))"
I get the error 'Sub query returns more than 1 value...'
Sql Query With Many To Many Tables?
Dec 22, 2010I'm using VB.Net express with an Access file, and I have the following tables:
table Formula
id | name
-------------------
1 | formula 1[code]....
So each formula have one or more components.Which query will I use if I want all the formulas with for example Component A AND Component D (Result: formula 1, formula 2)? I try something with intersect, but it seems it doesn't work in VB...
Sql - Update Query Using Two Tables Asp.net Vb?
Jun 13, 2012I COMPLETELY understand how redundant this is but I NEED it.Upon users creating a User account which only contains the ID, Username, Password and CustomerID I must also have a record in Customers create itself but null everything and the User.User_Customer_ID must update to the newly created Customer.Customer_ID
I have everything working but this pesky update query. The ONLY thing it needs to do is change User.User_Customer_ID to Customer.Customer_ID I managed to story the User.User_ID in an integer called UserID and Customer.Customer_ID in an integer called CustomerID I have tried a million different ways with no success
[Code]...
DB/Reporting :: Query On Related Tables?
Nov 15, 2008I have a simple "two-tables" database (SQL EXpress) and a very simple application (VB 2008 Express). The two tables are customer and order and their structures are:
customer(IDcustomer, LastName, FirstName) IDcustomer=primary key orders(IDord, Number, Description, IDcust)
IDord=primary key the tables are related (IDcustomer-->ID cust)
In VB2008 environment I create a dataset, by means of Data Source Configuration Wizard, which encompass both customer and order tables (xsd file). By opening xsd file I set the relationship in the following manner:
"Both relation and foreign key constraint"
Update Rule = Cascade
Delete Rule = Cascade
In my form I show customer table in detail-mode and orders table in datagridview-mode. Two Fill method are created in the Load event and they work correctly.In "CustomerTableAdapter" I create, with QueryBuilder, a search query (say LastName query) and I write the following code:
Private Sub frmSearch_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.CustomerTableAdapter.FillByLastName(Me.CustomerOrdersDataSet.custom er, "D") 'All Lastnames with first letter = D
[Code]...
Select Query For Selection From 3 Tables?
May 3, 2010there are three tables in dbf , table1,2,3 respectively all are contains similar structure but different data Structure : S.no Quiz Question i want the query which select the Quiz Question/records through user given Range from Textbox1.text to Textbox2.text
View 3 RepliesUpdate Two Tables By Single Query?
Jul 28, 2011I want to update two tables by single query
View 2 RepliesAccess Database And Using A Parameter Query With The LIKE Operator To Return All Rows That Match Query?
Apr 28, 2010I am connecting to an Access database and using a parameter query with the LIKE operator to return all rows that match query. The string to search for is taken from a Textbox
sql =
"Select * FROM Allview WHERE Info Like" &
"*" &
CStr(TextBox1.Text) &
"*"
The query does not return any data in vb, but when run from access with same string, there is data returned.The connection to the database is done correctly, as I am able to return data with various other queries.
Partial code :
Dim
con As
New OleDb.OleDbConnection[code]....
Running A Query On Access From VB, Passing Variable Or Function As Query Parameter
Apr 7, 2012I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
Create A Data Access Form?
Sep 16, 2009To create a data access form
View 3 RepliesExecute My Query To Insert Records In Tables?
Aug 17, 2009How can i execute my query to insert records in tables?[code]...
View 7 RepliesQuery Multiple Tables In A VB2008 Program Using SQL?
Dec 13, 2009I have a 4 table database and need to query at least 2 tables (the single table query works fine). The output goes in textboxes / labels on an existing form.
I'm trying something like this:
Private
Sub AddCustomer_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
SQL Query With Three Tables And Sum Of The Product Of 2 Columns Of One Table
Sep 10, 2011I am having 3 tables in my DB Challans, Challan_Details & Customers. They are as follows
Table Challans:
Customer_ID (Related with Customer_ID in Customers Table) Challan_ID (Key) Challan_VchNo (Voucher No.) Challan_Date Invoice_ID
Table Challan_Details
[Code]....
Updating 3 Tables In One Query Without Using Stored Procedure?
Jul 1, 2010i have 3 tables t1,t2,t3..if i update t1,t2 and t3 must also be updated.i have just been tried
UPDATE t1,t2,t3 SET t1.f1='sample',t2.f1='sample',t3.f1='sample' WHERE t1.f1='test' and t2.f1='test' and t1.f1='test'
using this,update fails if t2 and t3 could not find 'test' in their fields,if i use OR all records will be..i have also tried JOINS
Update tbl_maincat AS m LEFT JOIN tbl_maincat AS m2 ON m.cTitle = m2.cTitle,
tbl_main AS c LEFT JOIN tbl_main AS c2 ON c.MainCat = c2.Maincat,
tbl_subcat AS s LEFT JOIN tbl_subcat AS s2 ON s.csCat = s2.csCat
[code]....
VS 2010 SQL Query 2 Tables - Getting Info Loaded In RTB
Oct 16, 2011I have 2 tables. I'm getting info from table1 which is loaded in an rtb.
vb.net
]Dim cmd_info As New MySqlCommand("SELECT kan_info FROM kan_info WHERE kan_id= '" & kt_id & "'", conn)
reader = cmd_info.ExecuteReader
While reader.Read
beslag_kanton_info.Text = _
"RB_REF: " & vbNewLine & _
"KT_REF: " & vbNewLine & vbNewLine & _
reader.Item("kan_info").ToString
End While
This works great, but I need to add extra info after "RB_REF:" and "KT_REF:" (e.g: RB_REF: 12345 / KT_REF:6789) Those values are located in another table. How do I change the code/query so it also get the necessarily records from that table? Obviously there is a column "kan_id" with same values. I can't merge the tables btw.
Create A Backup Form For Ms Access Database?
Feb 8, 2010i need to make a professional form in vb 2008 to make a full backup and restore for my database file with progress bar and ability to write my backup in CD-room so
View 5 RepliesDB/Reporting :: Optimize Query (aggregates On Multiple Tables)?
Feb 20, 2008Code:
Tables:
- Company
- Department
- Employee
- CertificationA
- CertificationB
I am trying to return a recordset that gives some summary information about each company. The fields in my returned recordset should look like the following.
Company.Name, NumberOfDepartments, NumberOfEmployees, NumberOfCertificationA, NumberOfCertificationACompleted, NumberOfCertificationB, NumberOfCertificationBCompleted
There are actually about 10 different Certification tables but, with Certification A and B you should get the hang of it. When an employee starts a certifaction, a record is added to the that certification table.Below is a query I wrote that works (gets me the data I need), but I am unsure if it is the most efficient way. There will be quite a lot of data so performance is an issue.
Code:
Dim sqlNumberOfDepartments As String
sqlNumberOfDepartments = _
"(SELECT COUNT(*) " & _
"FROM DEPARTMENT " & _
[code].....
Equivalent To JOIN Query With Dataset Multiple Tables?
Dec 21, 2011How to Query multiple tables in a dataset to form single consolidated table without using any external database. I know this can be done using 'JOIN' in SQl.
Now my condition is I have multiple tables filled with data in a dataset and each table is interrelated with a common 'column'. For example ,
Table 1
ID
Name
1
[Code].....
Here I mentioned only two tables but in my case there are many tables. I need a generic answer for this dynamic query .
Forms :: Input Data In Mysql Different Tables With One Query?
Jan 21, 2012how to input data in mysql, different tables with one query?is it possible to do in gridview in vb.net 2008?
View 4 RepliesIterate Through LINQ Query - Results From Multiple Tables
Dec 7, 2010I have a VB .Net linq query that I want to return values from two tables. I currently have this:
Dim query = (From c In db.Client _
Join u In db.Users _
On u.UserID Equals c.UserID _
Where (c.ClientID = 1)
Select c, u).ToList
query (System.Collections.Generic.List(Of )) returns several rows as expected each item containing a c and a u.
How do I iterate through the queries collection?
LINQ Query - Join Tables On Nullable Columns
Apr 17, 2011How to JOIN tables on nullable columns? I have following LINQ-query, RMA.fiCharge can be NULL:
Dim query = From charge In Services.dsERP.ERP_Charge _
Join rma In Services.dsRMA.RMA _
On charge.idCharge Equals rma.fiCharge _
Where rma.IMEI = imei
Select charge.idCharge
I get a "Conversion from type 'DBNull' to type 'Integer' is not valid" in query.ToArray():
Dim filter = _
String.Format(Services.dsERP.ERP_Charge.idChargeColumn.ColumnName & " IN({0})", String.Join(",", query.ToArray))
So I could append a WHERE RMA.fiCharge IS NOT NULL in the query. But how to do that in LINQ or is there another option?
The problem was that the DataSet does not support Nullable-Types but generates an InvalidCastException if you query any NULL-Values on an integer-column. The modified LINQ-query from dahlbyk works with little modification. The DataSet generates a boolean-property for every column with AllowDbNull=True, in this case IsfiChargeNull.
Dim query = From charge In Services.dsERP.ERP_Charge _
Join rma In (From rma In Services.dsRMA.RMA _
Where Not rma.IsfiChargeNull
Select rma)
On charge.idCharge Equals rma.fiCharge _
Where rma.IMEI = imei
Select charge.idCharge