Can you perform a join on two tables, one is an Access database and the other is a SQL Server database.I understand that I could perform a SELECT on each database, and then manually join the results. Is this how I'm going to have to do it?
View 1 RepliesI am not sure if the above title is suitable for what I mean, but basically my application has a login table with entry U_ID and I have also created another field in my other table which will store this ID from the login table.
What I want to do is, if a user with say U_ID = 1 downloads data and stores it in the
second table I would also for trackable reasons be able to store the U_ID of that user
in the second table so that I would know who downloaded the information.
How can I acheive this and if there are any example then point to them.
I am having a data set in vb.net with two tables one table is filled by using oracle databse and another one from Sql 2005. How can we join these two tables in the dataset?
View 2 RepliesI am trying to update a datagrid joining two tables with a bindingsource. I keep getting the following error: "dynamic sql generation is not supported against multiple base tables." Any ideas on how to fix the problem? Also, I realize that commandbuilder does not work for more than one table.
View 4 RepliesBasically what I'm having to do is create a program that takes a list of CaseIDs and compares them to a table on a remote SQL server. However, the table holding the CaseIDs on the remote server has nearly 120,000 records.
Currently my plan is to query all records on the remote server, save the query and the current list to tables in an Access DB file and then run an outer join to see which CaseIDs have no matching records on the remote server.
I believe this will be a much slower process than I would like. If I could load both queries into arrays or lists in VB and then compare them (therefore, not having to write 120,000 records to a DB file), it would be much faster.
I have two databases. I need to merge the data from a table in one database with the data in a table from another database. I created two datasets and two dataadapters, and two connection strings as below.
[Code]....
I just don't know how to put it all together, as I have two connections. I searched the internet for days looking for a sample, but couldn't find any.
How do i do sorting for tables of different databases?
say i have 9 columns: Ticket No, Subject, Requester.In the tickets database, i have ID, Subject and tbl_StaffDataRequesterID. And, i have a tbl_staffData table whereby the name of the requester is stored inside.
My problem here is that i can do sorting for columns of the same database but i dont know how to do it for different databases, which in this case here is to sort the requester's name. [code]...
I am tying to build a COMMAND that joins two tables from two different access databases in vb.net,
View 4 RepliesI am looking for the proper code format to rename a table of an SQL file within VB.net.[code]...
View 7 RepliesI have an interesting project.I've been tasked to create utility in VB.Net. So far from what I can see, I will need two tables produced from data in other databases. The mockup was done in Access which has a unique way of treating all tables as local tables that can interact with one another without any serious side effects. Simply put, I can add three tables from three databases and create a relationship and query against them without any problems.I'm not allowed to write or create items on the Server, so I need to do everything within VB.NET. I've created a local MDF file that will be included in the project installation, but as I'm new to .Net. I'm not sure if this is the best practice.I was excited at the prospect that I might be able to avoid having an attached data source when I realized I could create a DataTable and call data from it. When the application shuts down, the table would disappear and the footprint would be virtually 0. But now rather than just selecting data from that table I need to now delete and insert data to the Datatable object based on AdHoc selections on the form.
View 8 RepliesI'm working on becoming familiar with LINQ, and getting my head around the syntax and usage.
[Code]...
i wont to creat application, in wich with file location find tables and use them in my app. as databases
View 1 Repliesi am trying to join 2 tables together and display them in a list view. i have this code so far
[Code]....
i have two bezier curves placed at a distance apart in space.curve 1 has control points A0, A1,A2, A3. A0 and A3 lie on curve and are its end points Curve 2 has control points C0,C1, C2, C3 . C0 and C3 lie on curve.and are its end points
i want to join the two curves A and C with an intermediate bezier curve B. the intermediate Curve B has control points A3 and C0 which lie on the curve and are its end points. the intermediate control points B1 and B2 are unknown to me. also the joining should be smooth enough. please help as to how to proceed. have read alot about beziers but dont know how to do this.
I have a list of object with 3 properties (quantity, service, name)I want to have all names and services in my list (kinda cross join) and the grouped quantity of the row corresponding. Not clear i guess
Quantity Service Name
3 Srv2 Bob
4 Srv2 Paul
2 Srv1 Paul
1 Srv2 Nick
I want as output All the services and all the names and corresponding quantities (0 if none)
Srv1 Paul 2
Srv1 Bob 0
Srv1 Nick 0
[code]....
Here is what I got so far, but I dont even get the expected resultsAnd I am acutally certain there is a pretty easy way of achieving what i want...
Dim services = (From a In interventions Select New With {.Service = a.Service}).Distinct()
Dim months = (From b In interventions Select New With {.Month = b.DateHeureIntervention.Month}).Distinct()
'Dim query = (From s In services _
[code]....
difference between + and & for joining strings in .Net?
View 6 RepliesI recently was working on joining two objects in VB.
processed_files, which is an ObjectQuery(of T)
list_of_file_ids, which is a List(of T.ID)
If I do:
[code].....
I am trying to Join the domain using VB.NET 2005. I cannot see anything I am missing but am getting an error code that hasn't proven much use. I get a return error code of 1332.[code]
View 1 RepliesAll I really want to do is a join. Table 1 and Table 2 both have a number that would link the two together. I want to join two fields from Table 2 onto Table 1. I need to have two datasets because there are two different connections being made.I want to push this onto a DataGridView, which only allows a single datasource. So I'm thinking I would need to make a temp table somehow, but since I'm pulling from two different datasets I don't know if that's possible.
View 1 Repliesi have two bezier curves placed at a distance apart in space.curve 1 has control points A0, A1,A2, A3. A0 and A3 lie on curve and are its end pointsCurve 2 has control points C0,C1, C2, C3 . C0 and C3 lie on curve.and are its end pointsi want to join the two curves A and C with an intermediate bezier curve B. the intermediate Curve B has control points A3 and C0 which lie on the curve and are its end points.
View 7 RepliesI have a datatable that contains 8 columns. To make this more presentable I have managed to pivot three of these columns. That will not do since I then loose 5 columns of information. To overcome this problem, I thought of just joining the two tables in vb.net.This seems more difficult than expected. LINQ are hard to learn compared to SQL. I have tried to pivot the query in SQL but am not able to.Here are the query:
"SELECT t1.Journal,t2.Kunde,t2.Kundenr,t2.Lokalitet,t2.Lokalitetnr,t2.Analyse,t2.Positive,t2.Totalt " & _
[code].....
Inline Code Example Here
con.Open()
cmd.Connection = con
[code].....
The above is my query for my datagrid view nd it keeps saying
Incorrect syntax near '.'.
but when i do it in the query bulider in sql server it is fine?
I'm really struggling with this. I have two XML files. The first one has items, and then sub elements for properties:
[Code]...
i have a program where im trying to split a string from 1 text box and output the values in to 2 different text boxes .
my string username: password which reside in txt1.text
i want to split the string at ":" and have username appear in txt2.text and password appear in txt3.text i have this code but doesn't work for what i want to do.
Quote:
Dim text Array() As String = txt1.text.Split(":"c)
'ALPHA SORT THE ARRAY
Array.Sort(text Array)
[code]....
Also trying to find a way to rejoin the text back to the original string afterward in the username: password format
In my application, I have a search query textbox (txtSearch) that works well with one-word queries with the following LINQ:[code]So how would I make the above query more generic (ie: able to handle any number of words in a query)?I should note that the object being queried is a List of strings pulled from an Access database. As it stands, this application only queries the database once and I'd like to keep it that way if possible.
View 3 RepliesI was just wondering weather it was possible to make it so that if I press the first a item on listbox1 then the first item on listbox 2 is selected aswell. For example I would like to have 2 listboxes lst1 and lst2 and I would like it so that when I select the first item on lst 1 then the first item on lst2 is automatically selected and when I select the 3rd item on lst1 then the 3rd item on lst2 is also selected.
View 7 RepliesI want the strings of RichTextBox1 and RichTextBox2 (strings are separated by newlines) printed to RichTextBox3 along with selected RadioButton's name and ticked CheckBox's name.[code]
View 2 RepliesI have a little issue. I need to be able to concatonate the Row1 with Row2 to another/row/table, and the start again on the 3rd row, Join Row3 on Row4 .. and so forth. The issue i have is that there is no relationship between Row1 and Row2. The only common thing is that Row2 is part of Row1. Can this be done? (Can be done with either by SQL SERVER, SSIS or ASP.NET VB) Below is a sample output of the data in column1 (single column)
[Code]...
im using this code for create view joining tow table but its gived me error on 'INNER JOIN' :
Cmd.CommandText = "CREATE VIEW MyQry As SELECT TblData.Emp_ID,TblData.Emp_Name,TblData.Emp_Bonus,TblData.Emp_Salary,TblData.Emp_Sanction FROM TblData WHERE TblData.Emp_ID LIKE '" & LstEmp.Text & "' INNER JOIN
[Code].....
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:.....................