I am trying to develop a report that displays the result of a query that returns two tables. The first table is always a single row of values, the second should be a grid. I can get a report to display either independently, however it will not allow me put them both on the same report.
View 1 RepliesI want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
I am working on a Visual Basic 2008 program using an Access 2000 database. My SQL codereturns no records, but I know the table has a record. A simplified example of the code looks like this:
SELECT Table1.Field1, Table1.Field2, Table1.Field3, Table1.Field4, Table2. Field1, Table2.Field2 FROM Table1 INNER JOIN Table2 ON Table1.Field1 = Table2.Field1 AND Table1.Field2 = Table2.Field2 WHERE Table1.Field1=@Field1 AND Table1.Field2=@Field2;
[code].....
I need to write and SQL query that three from three linked tables. Basically there is a 'case_id' column in each table with matching values.
What I have is:
Code:
declare @archiveYears int
set @archiveYears = -7
delete from cw_ht_bacase where case_id in (
[Code]....
As you can see I have the same query in the "in" clause for each statement. Is there a way to normalise this, sort of like C macro. Basically I'd just to define the inner select statement once and use it multiple times.
I 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]...
Lets assume that I have 2 tables:
First one is customer table and has primary key called cusid ( auto increment)
Second one is order table and has foreign key custid
How I can connect them, what I mean exactly when insert the record in the customer table I need the foreign key get the same value as primary key in customer table. I'm using sql server 2008 and vb.net 2008.
I have an application which upon a save button needs to save data to 8 different tables. 7 of those tables will have multiple new records added to them, while 1 will have just one new record. I want to encapsulate this giant Insert operation in a Transaction so that it will not complete unless I can save successfully to all tables.I have considered using Insert commands to a command statement, but adding what amounts to like 50 parameters, and the fact that using a parameterized query means it becomes very difficult to troubleshoot problems such as invalid values in the SQL statement (since I cannot figure out what the statement looks like with values in it
View 3 RepliesI am trying to load a crystal report from two tables but it seems that is not working.Here is the code to load the crystal report:
Code:
Private Sub InvoiceLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]......
A suite of apps will be using various tables out of the same sql server database.Regardless of which app is being used, the database structure must stay current. (ie:contain all the tables/fields to run any/all of the apps)So, when the user starts any of the apps, it needs to check the database, for the existence of all the tables and fields it needs, then update if necessary.
View 1 RepliesI want to make relationship between them Where In the F column of Table2 will sum the numbers in F column of table 3 according this condition ( show in the pic.)For the same data in columns(B,C,D) between two tables Example: Table 2 include in B,C,D data HH XX FF There are many data (HH XX FF) in tables3 in same columns(b,c,d) so it will sum the numbers in F column that in the same row with the data (HH xx FF), and insertded the results in the in table2 in F colmn in the same row with (HH XX FF)
View 10 RepliesI have one dataset with two tables and when some values from tables are changing I need somehow to change the values from table 2. Table one is conected to an SQL server. One table 1 receives a message from sql service broker it automatically reload all the information. I need in that moment to compare what I have new in table 1 and put it in table 2. I have made with <br />For i=1 to ..<br /> </p>
View 6 RepliesI would like to copy tables at A specific position from a dataset and insert them into another dataset at a specific position.
View 1 RepliesI 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 have need for a database in my latest app, i quickly realised it had been a long time since i last used a database and am in fact very very rusty on the subject. So i decided to create a simple DataSet using the designer, i created 2 tables as follows
Table 1 is Named Map and contains a 2 dimensional array each cell containing an array of object id's of anything in that cell, and a level ID.
Table 2 contains data about these objects ie size weight and a z-order, again referenced by an object id (matching Table1)
This i did with no issues, when it came however to actually populating these tables i drew a blank. Do i have to locate the database file and edit with notepad? I presume not. Maybe i have to use an external app like sqlmanager? I seem to recall from my past that i added table rows from within the designer but i cannot find this in 2010 express
I have been answering question about updating Table or DataBase Using DGV. Most the people still having problem about it. Being honest with all of you, I don't know why?
View 10 RepliesI am working on a database application. I had used Dataset to link my VB programme to a database and selected specific tables. However, I created more tables in the database and I wanted to add the new tables to the dataset. I could not find a simple way to do this, so I deleted the existing dataset and created a new one. This move has broken my VB codes. I can no longer run them as errors are shooting up. In fact, I connot view the forms in my programme anymore. I have a backup of the codes to rerun, but then I need to add new tables to the dataset.
View 4 RepliesI have some problem with working with tables which were created on previous form. Say we have a form Customers in which Customers are displayed in datagridview.Now to create or add ne customer to this customer table on sql server, another form is opened.In this form user enters all data like customer name, phone number etc. when changes are made to the sql server using a stored procedure this form is closed now I want to show this newly added customer in the datagridview of the previous form.Right now what I am doing is creating data set and command et. and again fetching data for all customers from sql server.
View 2 RepliesSo Im working on updating our company's program from Visual FoxPro to VB and this is the first step. I can access and read data from the table
Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
Code:
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].....
I build xml in memory from the file, separate that into nodes for binding to different grids, works fine except the dataset is missing two tables and I can't find out why, the code below uses a stream but I've tried a ton of stuff by now, and, just using ds.ReadXml(path) doesn't work to get the proper nodes and drops all but the first major node: vs2008/vb.net project.
I believe what's going on is that the nodes have attributes ... none of the nodes that do come through have them, the "author" and "entrydate" nodes are being dropped from the string:
If (My.Computer.FileSystem.FileExists(pPath)) Then
xmlDom.xmlArchMaster(pPath, xml)
_default.ActiveSiteID = xmlDom.siteheaderNode.Attributes("id").Value
[Code]....
I have a VB.Net dataset that contains data from multiple tables. how to query data out of the dataset. I want to run SQL-like queries on a dataset to extract data that fits a certain "where" statement.
View 3 RepliesI pass it a valid dataset that has the department name and the Department id as a number..20, 40, 30..... I want to get the department number.. I pass it HR(which is in the ds.table) but I am getting an error on the rows.find() "Input string was not in a correct format" it is a string.. what else could i be doing wrong here...
Public Function GetDeptID(ByRef ds As DataSet, ByVal strDepartment As String) As Integer
'Dim dr As DataRow
' Check to see if date is already in the table
[code].....
The situation: I have a small application where i store customers and orders.. In my database i have a tabel called Customers and a tabel called Orders. These 2 dabases are joined on Customer ID - every Order record contain a row with the customer Id.
[Code]...
I have a Dataset with 2 different tables. What I have to do is to display those tables in a DataGridView.What I have done with a reference is given below.
[Code]...
I have an XML file that has a basic hierarchical structure about horse racing. It has a summary of the tracks, some data about each track, then a list of all the races at each track racing that day. So lets say there are 10 tracks, and for each track there are 8 races. This is a snapshot of the data....
HTML
-<Meetings xmlns="" Jurisdiction="VIC">
-<Summary MID="MR_20110801">
<VenueName>ECHUCA (VIC)</VenueName>
<Type>R</Type>
<Events>10</Events>
<Track>DEAD </Track>
[Code] ......
I have written the code to pull down the data into a data store, but I dont know the BEST way to put the data into a set of tables. My first thought was to traverse the nodes and add rows into tables but I figure there must be a native VB process that reads the xml and puts it into the the appropriate table. How to code up the process for getting the data into a set of tables that match the xml. So lets say I have a Summary table, I would like all the data about each track to go into that table. Then I would have a Races table and have the data for each race go into that. What I have done already is import the xml into Access to create the tables (which was a breeze!) and then link that data source to my project. So I have the tables already built.
I have an office project which shoudl basically do the following:
1) take different TEXT files of fixed-length fields and put them in separate tables.
2) use the data from the different tables and compile them to a master table in a mdb.
3) display data in compiled mdb in datagrid 4) allow editing in datagrid 5) save the data in datagrid into the mdb 6) save the data in datagrid in a csv file i did some googling and came up with the following code:
[Code]...
First off I'm a newbie to VS but hopefully my question isn't terribly clueless. I've been searching endlessly for an answer but I don't find much relating to VS 2010 I'm running VS2010 Ultimate and I'm creating a Windows Form app in VB .net 4. I'm connecting to SQL Server 2005.
[Code]....
In my VB.Net desktop application, I have several places where I am accessing a table, both for reading and for updating. For example:
Dim tempCount As Integer = Glbl.GlobalDataSet.Tables("Profiles").Rows.Count
The above does not work. However, the following does:
Dim tempCount As Integer = Glbl.GlobalDataSet.Tables(4).Rows.Count
I am pretty sure it was working in th past (I have recently switched to VS 2010 - could this have anything to do with it?) but it is not working now.
How can I make the first statement work, so can access tables by table name instead of by index?
How to bound this dataset to datagridview?
[Code]...
I created a typed dataset and my database guys are constantly updating and adding columns to tables.. is there a way to do a comparison
View 1 Replies