I'm probably doing something wrong but, SQL statement on an access database works fine until I add in the second table. As soon as I do it just hangs....??
sql = "SELECT Candidate.Candidate_Number, Candidate_Name FROM Candidate, Candidate_Counties WHERE Technical_Skills LIKE '%" & Q1 & "%'" ' AND Anywhere_UK = 1"
Technical_Skills is on Table Candidate
Anywhere_UK is on Table Candidate_Counties
I am trying to load some data from a database table into a data grid. However the way it is accomplished is that the user will be able to select the database (i.e. the database can be located anywhere in the hard drive) and once he or she selects the database, a second interface would allow him or her to select the number of tables within that database (can be any number of tables). Once the table is selected the contents of the table will be loaded into the datagrid. It is just like opening an Access (.mdb) file and then click and open a table within the file except that it is done programatically
View 8 RepliesI have about 4 different tables with the exact same column names. What I would like to do is select the top 4 records out of all of these tables combined ordered by date (as date is one of the columns that they all share).
View 1 RepliesI want to insert existing tables in new table stock by selecting from date and to date ..I tried this
cmd = New SqlCommand("INSERT INTO Stock (OpeningStockdate,Productcode,Openingstock,Despatch,Receipt,ClosingStock) (SELECT A.OpeningStockdate as OpeningStockdate, A.PC as Productcode,MAX(A.Openstock) AS Openingstock ,SUM(C.Qty) AS Despatch,SUM(B.Qty)
AS Receipt,MAX(Openstock) + ISNULL(SUM(B.Qty),0) -ISNULL(SUM(C.Qty),0) AS ClosingStock FROM Product A LEFT JOIN Receipt B ON
[code]....
i got this error" Incorrect syntax near the keyword 'Where' "
what i have is 3 text boxes
User
Role
Upgrade To
and a gridview
what i am trying to do is :when i type in the user the system will look in my table cg_security_user and recognise that the current role is "guest". Then in the Upgrade to when i type in "admin" it will update the current role(guest) to admin here is a picture is attached of what i am trying to do as it might paint a better picture the code which i have made so far is
Private Sub cmdupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdupdate.Click
Dim myAdapter As New OleDbDataAdapter
strsql = "update table1 set studname = @field2, studaddress=@field3, studage=@field4 where studid=@field1"
[code]....
I want to select a Particular Row from a DataTable;may i know what is the best way of doing it?
This can be done using the DataView but i want to know the best way of doing the same.
how to move to a specifc row on on a datagrid in VB Express 2005 Windows from?
View 8 RepliesI use a printcode in a Class, and a printcode by the Button in the Form.Olso i have a code for fill the ComboBox, with al printers.Is it possible to do a selecting in the ComboBox, with as results that the print go to that printer.
Class
Public Class formCapture
Private Shared img As Bitmap
[code].....
I tried using keypress event to set the focus to another control after selecting record from combobox and pressing the enter key but it is not working.
View 2 RepliesI would want it that upon pressing the Tab key in the last control of the TabPage then it will go to the next tabpage and focus on the first control there that has its TabStop set to true. I could trap the Tab key in my current implementation but is there be an easier way?
View 13 Repliesi'm doing a desktop application using VS2005 with MSSQL 2005. i have a problem with the where clause in the update statement while selecting the listbox item. this is the code for the listbox in load page:
[Code]....
and this is my update query in the delete button event handler: mySQL = "update Appointment set recordStatus = 'deleted'" how do i put in the where clause in when i have 4 columns in the listbox? so can i do this with listbox or have to do with datagridview?
I have a month calendar on a form. It is showing 2 months, when I select the start date for a range of dates, the month calendar blinks for about 1 second. Here is the code that gets the start date, sets the end date (28 days later), then assigns a date to the text of 28 checkboxes by looping through the control collection.[code]
View 4 RepliesI have a ms access database with 10 tables, a combobox with the tables names and a datagridview.I want to get the datagridview to display the the specific table that is listed in my combobox during runtime.Basically i want to navigate to specific tables using combobox.
View 5 RepliesHow can I connect two tables from MS SQL Server 2005 using vb.net 2008?
View 5 Replies"Deleting rows from multiple tables in SQL 2005". I need to delete all the rows in the multiple rows where it's the same UserId. My Delete command below:
Delete From tableA
From tableA INNER JOIN
tableB ON tableA.UserId = tableB.UserId INNER JOIN
tableC ON tableA.UserId = tableC.UserId INNER JOIN
tableD ON tableA.UserId = tableD.UserId
Where (tableA.UserId = @UserId) AND (tableB.UserId = @UserId) AND (tableC.UserId = @UserId) AND (tableD.UserId = @UserId)
What is happening from the above query is only the rows from tableA is getting deleted.
I have mysql database with one table , and I want to show the columns' names re;taed to the table in combobox in vb 2005
this is my mysql command :
SQL1 = " select column_name from information_schema.columns where table_name='others'; "
this is my code after execute the command and store the data set in variable ( DS ) which its type is "DataSet " :
If DS.Tables(0).Columns.Count > 0 Then
For j As Integer = 0 To DS.Tables(0).Rows.Count - 1
list1.Items.Add(DS.Tables(0).Rows(0).ToString)
Next (j)
End If
I started out with just one table called products but I had problems with doing an update; it said sql to complex which was because the product table had nearly 100 columns in. The products table consists of header information like product quality, colour etc. Then there are 3 blocks of columns which mainly consist of a size as being the column name and a quantity as being the value. I have put these in three seperate tables to get around the SQL update problem. My problem is what is the best way to code this. The tables link to the header table using an autonumber primary key.
[Code]...
I am looking for some advice on this since I know nothing about database projects or sql, except that they have data stored in tables and rows. I have a sql back up text file from my forum, and I would like to bring that in to a VB.net sql db project. What do I need to do, to accomplish this?
View 2 RepliesOne of the things I'm trying to do is work out the total profits for a company, reading from an access database comprising of two linked tables. All the information needed for the calculation in question (Fees, Sold/Bought?, Cost/Income) are found in one form (Financial) and I want to read this information and carry out the required calculations within a sub.
Here is the calculation in Pseudocode I wish to do:
Do
If SoldBought = Sold then
Total = Total + Cost/Income - Fees
Else: Total = Total - Cost/Income
Read Next Record
Loop Until End of Records
[Code] .....
Unfortunately, I encounter an error with the above. I get the following error;
"There is no Row at position 0".
How I could get this in motion - I've been stuck in a rut for days trying different things out and I've come to accept that I can't do this alone.
I am populating a collection from some tables in the database which serves as a look-up from controls (combobox) I am using but what I want is rather than hitting the database each time can I just cache the collection and get the collection from the cache? The look-up table may or may not change all the time so I would want to have a way to validate if the cached collection is still valid or not.
View 2 RepliesI am using TextFieldParser to read a .txt file and create a DataTable I then filter the table and create 4 new tables I then bind those tables to BindingSources Then Bind ComboBoxs to the BindingSource Then bind TextBoxes to BindingSource I like the user to be able to Open a new file without having to close the program So upon opening a new file I have a sub routine that clears the tables the rows and the columns of each table as well the DataBindings to each control The problem is once I do the Text Binding as such
Me.list1_MLStxt.DataBindings.Add("Text", Subject_Values.BindingSource1, Form10.mls_txt.Text)
Then when I open a new file I get an error message conversion from string"""" to type double is not valid.If I never perform the binding I can open and reopen different files without a problem. So this is causing me to think that the problem is with the way I am clear something? But I am obviously not sureIs there something I am missing to clear everything properly in order to open and read and bind a new file?
I've found alot of examples for add/edit/delete a single table. In VB6 ADO you could load multiple tables into a recordset using the join command. Then manipulate or modify the data.
I've found how to retreive multiple tables like,
Da = New OleDb.OleDbDataAdapter("Select groups.groupid,groups.userid,lots.groupid,lots.lotid from groups inner join lots on groups.groupid=lots.groupid order by groups.groupid asc", DB) But the only way I have found to update is to use seperate Update commands for each table.
I am about to commence coding (actually recoding) on a project that accesses 100 tables of a database, more to added at later time. About half of the accesses are queries with joins and unions. I am more of a coder to not use wizards such tableAdapter, but code more by other methods. I have read some post of this site that suggest avoiding tableAdapters, not to use them in an Enterprise environmentl, but no reasons. I would like to hear from willing to bend my ear, pro or con.
View 1 RepliesI'm getting this error 'column' argument cannot be null. Parameter name: column at the bold character instruction. Also I would like to know how to relate two tables with two key columns in each table
Dim connection As New OleDb.OleDbConnection(strTextoConn)
Dim EnPartesdataSet As DataSet = New DataSet("Enpartes")
Dim strsql As String
[Code].....
I need to load a list of tables and linked tables in an MS Access Database into a combo box. I have this.
vb.net Imports System.Data.OleDb
[Code]...
1. How do I load the access tables and the link tables into my combo without the system tables showing up?
I 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:.....................
have a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped)
da.Update(dt) << This line
'da = dataadapter
[code].....
In my datagridview I was fill in using join tables (table1 = pr_employees, table2 = pr_employee_deduction). My problem now is during save button I want to update records from table2 only.[code]
View 3 RepliesWe are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.
Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
I have two questions:
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it