Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Go Back  Xtreme Visual Basic Talk > > > Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s


Reply
 
Thread Tools Display Modes
  #1  
Old 08-31-2004, 02:45 PM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Question Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s


Hi All,

I want to perform a SQL statement that uses two tables and store the results into a dataset or should that be datasets.

For example
Code:
Select table1.field1, table1.field2, table2.field1, table2.field2 FROM table1, table2 WHERE table1.field1 = 10
How do I store the result? Into a data set or into datasets? I have tried a few attempts of my own but I managed to lock up the application for example:
Code:
Dim MySQLSelect As String = "SELECT bc_stock.st_code, bc_stock.st_desc, bc_stock.st_locn FROM bc_stock, stktrn WHERE st_qty = 94"
Dim MyConnectionString As String = "data source=(local);initial catalog=wen;integrated security=SSPI;"
Dim MyConnection As New SqlDataAdapter(MySQLSelect, MyConnectionString)
Dim MyDataset As New DataSet
MyDataset.Clear()
MyConnection.Fill(MyDataset, "bc_stock")
MyConnection.Fill(MyDataset, "stktrn")
Please help if you can.

Thanks, Dave.
Reply With Quote
  #2  
Old 08-31-2004, 04:00 PM
randy_belcher randy_belcher is offline
Centurion
 
Join Date: Dec 2003
Posts: 122
Default

You need to either join the two tables in the select statement or do two select statements. The select statement you have listed is very inefficient because it does not join the two tables on indexed fields. The select statement is probably where your problem is ocurring.

MySQLSelect As String = "SELECT bc_stock.st_code, bc_stock.st_desc, bc_stock.st_locn FROM bc_stock, stktrn WHERE st_qty = 94 (should include - and bc_stock.key = stktrn.bc_stockKEY)"
Reply With Quote
  #3  
Old 08-31-2004, 07:34 PM
MKoslof's Avatar
MKoslofStoring Results Of SQL Statement That Uses Two Tables Into Dataset/s MKoslof is offline
Cum Grano Salis

Retired Moderator
* Guru *
 
Join Date: Jul 2002
Location: Baltimore, Maryland
Posts: 14,636
Default

To add to what Randy has said, if you want to join these tables, based on a data relation, just create an explicit JOIN. Depending on what data you need to return from both tables you could conduct an INNER, LEFT or RIGHT JOIN. And, you can also look into using the JoinedView() class. This is a very handy way of viewing data from two or more tables.

http://support.microsoft.com/default...en-us%3B325682
__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown
Reply With Quote
  #4  
Old 09-03-2004, 03:14 AM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Question

Ok.

So let's say I had this:
Code:
Dim MySQLSelect As String = "SELECT bc_stock.st_code, bc_stock.st_desc, bc_stock.st_locn FROM stktrn LEFT OUTER JOIN bc_stock ON stktrn.ch_key == bc_stock.bar_code WHERE st_qty = 94"
Dim MyConnectionString As String = "data source=(local);initial catalog=wen;integrated security=SSPI;"
Dim MyConnection As New SqlDataAdapter(MySQLSelect, MyConnectionString)
Dim MyDataset As New DataSet
MyDataset.Clear()
MyConnection.Fill(MyDataset, "What goes here?")
What code goes in the parameters of the line MyConnection.Fill(MyDataset, "What goes here?")?

Last edited by Davearia; 09-03-2004 at 07:10 AM.
Reply With Quote
  #5  
Old 09-03-2004, 07:39 AM
MKoslof's Avatar
MKoslofStoring Results Of SQL Statement That Uses Two Tables Into Dataset/s MKoslof is offline
Cum Grano Salis

Retired Moderator
* Guru *
 
Join Date: Jul 2002
Location: Baltimore, Maryland
Posts: 14,636
Default

You can put nothing and a default name will be given to table by .Net. Or you can pass your own name. Or, used a JOINED view if you want one distinct dataset per table, look at the link I posted.
__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown
Reply With Quote
  #6  
Old 09-07-2004, 01:00 PM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Question

Hi MKoslof,

Sorry I did not reply earlier, some pleb cut through my telephone line, so I have been without the internet for a week.

I have read the link about using the joinview class which seems like a great way to deal with this type of situation.

But could you give me some code to finish off the way I was trying to do? Although using the joinview class is a great idea I would like to know how to did it in a more straight forward way. I would prefer to set up one dataadapter and use a join in the sqlstatement like this:
Code:
Dim MySQLSelect As String = "SELECT bc_stock.st_code, bc_stock.st_desc, bc_stock.st_locn FROM stktrn LEFT OUTER JOIN bc_stock ON stktrn.ch_key == bc_stock.bar_code WHERE st_qty = 94"
Dim MyConnectionString As String = "data source=(local);initial catalog=wen;integrated security=SSPI;"
Dim MyConnection As New SqlDataAdapter(MySQLSelect, MyConnectionString)
Dim MyDataset As New DataSet
MyDataset.Clear()
MyConnection.Fill(MyDataset, "What goes here?")
So what would I do with the line: MyConnection.Fill(MyDataset, "What goes here?") If I leave the second arguement out (MyConnection.Fill(MyDataset)) I get the error message: An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.


Please help, thanks, Dave.
Reply With Quote
  #7  
Old 09-07-2004, 07:17 PM
MKoslof's Avatar
MKoslofStoring Results Of SQL Statement That Uses Two Tables Into Dataset/s MKoslof is offline
Cum Grano Salis

Retired Moderator
* Guru *
 
Join Date: Jul 2002
Location: Baltimore, Maryland
Posts: 14,636
Default

The first thing I would do is verify that this SQL Syntax is valid..typically this error signifies that there is a native error within the sql statement. If you run this query hard coded in the Enterprise Manager or SQL Server directly does it work properly?
__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown
Reply With Quote
  #8  
Old 09-08-2004, 01:31 AM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Question

Ok MKoslof,

I will check the syntax out, however the error message was for the line MyConnection.Fill(MyDataset, "What goes here?") . The syntax of SQL statement was based on code I easily found in books etc. The problem I had was finding examples of how to use the Fill() method for more than one table in the same select statement.

Please help.

Thanks, Dave.
Reply With Quote
  #9  
Old 09-08-2004, 05:53 AM
MKoslof's Avatar
MKoslofStoring Results Of SQL Statement That Uses Two Tables Into Dataset/s MKoslof is offline
Cum Grano Salis

Retired Moderator
* Guru *
 
Join Date: Jul 2002
Location: Baltimore, Maryland
Posts: 14,636
Default

But that syntax error is most likely related to your actual sql statement.

Because if I do this:

Code:
sSQL = "SELECT Clients.First_Name, Clients.Last_Name, Action_Client.Client_ID" _ & " From Clients INNER JOIN Action_Client ON Action_Client.Client_ID = Clients.ClientID"

And then simply fill a dataAdapter with this information and assign a default name, I get the proper results:

Code:
olapCommand.CommandType = CommandType.Text olapCommand.CommandText = sSQL olapAdaptor.SelectCommand = olapCommand olapAdaptor.Fill(ds)

Now I can assign a default name to this new data set table, such as "myTable" by doing:

Code:
ds.Tables(0).TableName = "myTable"

Now note, you are basically creating a read only data set at this point. If you want the ability to update and delete records, the easiest way to use the .relations method of the dataset or a JOINEDVIEW so you can make a distinction between your tables. Even in standard legacy VB 6 it is not advisable to try to update or delete records from a JOIN. But to simply display them, the above code works fine..the problem is most likely within your sql statement.
__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown
Reply With Quote
  #10  
Old 09-08-2004, 12:31 PM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Thumbs up Thankyou MKoslof

Hi MKoslof,

I checked SQL statement and as you said it was wrong. I have changed it to SELECT bc_stock.ST_CODE, bc_stock.ST_DESC, bc_stock.ST_LOCN FROM stktrn LEFT OUTER JOIN bc_stock ON stktrn.CH_KEY = bc_stock.BAR_CODE WHERE bc_stock.ST_QTY = 94 which verifies ok in the SQL verifier.

The code looks like this:
Code:
Dim MySQLSelect As String = "SELECT bc_stock.ST_CODE, bc_stock.ST_DESC, bc_stock.ST_LOCN FROM stktrn LEFT OUTER JOIN bc_stock ON stktrn.CH_KEY = bc_stock.BAR_CODE WHERE bc_stock.ST_QTY = 94"
        Dim MyConnectionString As String = "data source=(local);initial catalog=wen;integrated security=SSPI;"
        Dim MyConnection As New SqlDataAdapter(MySQLSelect, MyConnectionString)
        Dim MyDataset As New DataSet
        MyDataset.Clear()
        MyConnection.Fill(MyDataset)
Unfortunately I get this error similar to this:
Query Engine Error: 'C:\Docs\temp_bvccdd.rpt'
I suspected that the SQL statement was correct but it did not generate any results due to the criteria set in the select statement and therefore the report had no data to use. But as I have run SQL statement in the Run Query section of SQL Server I know that the statement does actually returns results. So I would like to know what this error is being caused by?

Oh well I'll keeping plugging away.

Any replies gratefully received.

Thanks, Dave

Last edited by Davearia; 09-08-2004 at 12:40 PM.
Reply With Quote
  #11  
Old 09-09-2004, 03:11 PM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Exclamation Still no luck!

I still haven't had any luck with this as yet. The thing that I find confusing is there are loads of examples of such SQL statements that use two tables. But none of the ones that I have seen so far go on to put the result into a dataset. THe suggestion that MKoslof gave using the Joinview class seems like a good idea don't get me me wrong. However I would much rather learn a more traditional way to start off with if you know what I mean.

Any help is always appreciated.

Thanks, Dave.
Reply With Quote
  #12  
Old 09-10-2004, 07:32 AM
MKoslof's Avatar
MKoslofStoring Results Of SQL Statement That Uses Two Tables Into Dataset/s MKoslof is offline
Cum Grano Salis

Retired Moderator
* Guru *
 
Join Date: Jul 2002
Location: Baltimore, Maryland
Posts: 14,636
Default

Dave:

A little advice. You need to tell us what the actual problem is within your first thread . You never said anything about using an .rpt file until the 10th post. This changes everything

1) What version of Crystal is this
2) What is the report's default datasource
3) Where is your actual Crystal Reports code

It is hard to help when you don't give us all of the relevant facts.
__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown
Reply With Quote
  #13  
Old 09-10-2004, 11:55 AM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Thumbs up Hope This Helps!

Hi MKoslof,

1.What version of Crystal is this?
I am running CRYSTAL REPORTS FOR VISUAL STUDIO .NET 2003 is this the same as Crystal Reports 10?

2.What is the report's default datasource?
See code below.
Code:
Dim MySQLSelect As String = "SELECT bc_stock.ST_CODE, bc_stock.ST_DESC, bc_stock.ST_LOCN FROM stktrn LEFT OUTER JOIN bc_stock ON stktrn.CH_KEY = bc_stock.BAR_CODE WHERE bc_stock.ST_QTY = 94"
Dim MyConnectionString As String = "data source=(local);initial catalog=wen;integrated security=SSPI;"
Dim MyConnection As New SqlDataAdapter(MySQLSelect, MyConnectionString)
Dim MyDataset As New DataSet
MyDataset.Clear()
MyConnection.Fill(MyDataset)
Cursor.Current = System.Windows.Forms.Cursors.WaitCursor
Cursor.Show()
Try
     visual1.SetDataSource(MyDataset)
     CrystalReportViewer3.ReportSource = visual1 'Here is the reports datasource
Catch ex As Exception
     MessageBox.Show(ex.Message, "Could not create report", MessageBoxButtons.OK)
Finally
     Cursor.Current = System.Windows.Forms.Cursors.Default
     Cursor.Show()
End Try
It's probably worth mentioning that this code worked perfectly with one table i.e.
Code:
Dim MySQLSelect As String = "SELECT bc_stock.ST_CODE, bc_stock.ST_DESC, bc_stock.ST_LOCN FROM bc_stock WHERE bc_stock.ST_QTY = 94"
        Dim MyConnectionString As String = "data source=(local);initial catalog=wen;integrated security=SSPI;"
        Dim MyConnection As New SqlDataAdapter(MySQLSelect, MyConnectionString)
        Dim MyDataset As New DataSet
        MyDataset.Clear()
        MyConnection.Fill(MyDataset, "bc_stock")
        Cursor.Current = System.Windows.Forms.Cursors.WaitCursor
        Cursor.Show()
        Try
            visual1.SetDataSource(MyDataset)
            CrystalReportViewer3.ReportSource = visual1
        Catch ex As Exception
            MessageBox.Show(ex.Message, "Could not create report", MessageBoxButtons.OK)
        Finally
            Cursor.Current = System.Windows.Forms.Cursors.Default
            Cursor.Show()
        End Try
3.Where is your actual Crystal Reports code?
By this I am assuming that you mean the code automatically generated by windows, hope so.
Code:
Friend WithEvents CrystalReportViewer3 As CrystalDecisions.Windows.Forms.CrystalReportViewer
Friend WithEvents visual1 As W_D_P_Reports.MyReport2
Me.visual1 = New W_D_P_Reports.MyReport2
Me.CrystalReportViewer3 = New CrystalDecisions.Windows.Forms.CrystalReportViewer
'
'CrystalReportViewer3
'
Me.CrystalReportViewer3.ActiveViewIndex = -1
Me.CrystalReportViewer3.Location = New System.Drawing.Point(208, 24)
Me.CrystalReportViewer3.Name = "CrystalReportViewer3"
Me.CrystalReportViewer3.ReportSource = Nothing
Me.CrystalReportViewer3.Size = New System.Drawing.Size(752, 648)
Me.CrystalReportViewer3.TabIndex = 23
This has been taken from various parts of the form Movements where the report is used. I have left the rest out to save space. I'll zip the form up and attach it to this thread if you need anymore details just ask.

Thanks, again, Dave.
Attached Files
File Type: zip Movements.zip (3.1 KB, 0 views)
Reply With Quote
  #14  
Old 09-10-2004, 07:02 PM
MKoslof's Avatar
MKoslofStoring Results Of SQL Statement That Uses Two Tables Into Dataset/s MKoslof is offline
Cum Grano Salis

Retired Moderator
* Guru *
 
Join Date: Jul 2002
Location: Baltimore, Maryland
Posts: 14,636
Default

OK, let me look this over and get back to you. Off hand, I don't see anything, but it would help if I could see your report definition and compare everything. Let me download your zip file and see what I can find.
__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown
Reply With Quote
  #15  
Old 09-11-2004, 01:51 AM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Thumbs up

Cheers MKoslof,

Let me know if you need anymore.

Thanks, Dave.
Reply With Quote
  #16  
Old 09-11-2004, 07:26 AM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Thumbs up This Seems To Work!

Hi MKoslof,

Here is the latest code:
Code:
Dim MySQLSelect As String = "SELECT bc_stock.ST_CODE, bc_stock.ST_DESC, bc_stock.ST_LOCN FROM stktrn LEFT OUTER JOIN bc_stock ON stktrn.CH_KEY = bc_stock.BAR_CODE WHERE bc_stock.ST_QTY = 94"
        Dim MyConnectionString As String = "data source=(local);initial catalog=wen;integrated security=SSPI;"
        Dim MyConnection As New SqlDataAdapter(MySQLSelect, MyConnectionString)
        Dim MyDataset As New DataSet
        MyDataset.Clear()
        MyConnection.Fill(MyDataset, "stktrn")
        MyConnection.Fill(MyDataset, "bc_stock")
        Cursor.Current = System.Windows.Forms.Cursors.WaitCursor
        Cursor.Show()
        Try
            visual1.SetDataSource(MyDataset)
            CrystalReportViewer3.ReportSource = visual1
        Catch ex As Exception
            MessageBox.Show(ex.Message, "Could not create report", MessageBoxButtons.OK)
        Finally
            Cursor.Current = System.Windows.Forms.Cursors.Default
            Cursor.Show()
Using the fill method twice, firstly for the stktrn table, secondly for the bc_stock table. There are more complex ways of doing this, as I am aware that on a live system the second table could altered by a user whilst the first query is being carried out. But for now I am quite content that this works, that is after I have tested the results a bit more.

Thanks, Dave
Reply With Quote
  #17  
Old 09-11-2004, 09:51 AM
MKoslof's Avatar
MKoslofStoring Results Of SQL Statement That Uses Two Tables Into Dataset/s MKoslof is offline
Cum Grano Salis

Retired Moderator
* Guru *
 
Join Date: Jul 2002
Location: Baltimore, Maryland
Posts: 14,636
Default

You should really join these tables via the .relations method or a JOINEDVIEW as we discussed before. All you have done here is created a dataset with two distinct tables..meaning they have no relation at the .Net interface level. If these tables need to be related or conduct data integrity rules, I highly suggest you relate your tables.
__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown
Reply With Quote
  #18  
Old 09-11-2004, 09:57 AM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Smile Not Quite Right!

I really thought I had got it how I wanted, alas no dice.

Here is my latest code:
Code:
Dim MySQLSelect As String = "SELECT bc_stock.wo_num, bc_stock.st_qty, bc_stock.ch_prod_da, bc_stock.bar_code, bc_stock.ST_CODE, bc_stock.ST_DESC, bc_stock.ST_LOCN, stktrn.mm_date FROM stktrn LEFT OUTER JOIN bc_stock ON stktrn.CH_KEY = bc_stock.BAR_CODE WHERE bc_stock.ST_QTY = 94"
        Dim MyConnectionString As String = "data source=(local);initial catalog=wen;integrated security=SSPI;"
        Dim MyConnection As New SqlDataAdapter(MySQLSelect, MyConnectionString)
        Dim MyDataset As New DataSet
        MyDataset.Clear()
        MyConnection.Fill(MyDataset, "bc_stock")
        MyConnection.Fill(MyDataset, "stktrn")
        Cursor.Current = System.Windows.Forms.Cursors.WaitCursor
        Cursor.Show()
        Try
            visual1.SetDataSource(MyDataset)
            CrystalReportViewer3.ReportSource = visual1
        Catch ex As Exception
            MessageBox.Show(ex.Message, "Could not create report", MessageBoxButtons.OK)
        Finally
            Cursor.Current = System.Windows.Forms.Cursors.Default
            Cursor.Show()
I can use all of the fields from bc_stock without any problem. However the field from stktrn mm.date as soon as I attempt to put it into the report it crashes (see the attached picture). So it seems as though the second fill() method MyConnection.Fill(MyDataset, "stktrn")does not appear to work.

Mkoslof if you can spare a minute and give us clue here it would be great.

Thanks, Dave.
Attached Images
File Type: jpg Fault.JPG (82.3 KB, 4 views)
Reply With Quote
  #19  
Old 09-11-2004, 10:51 AM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Default

I dont understand why this is so, but I cannot use stktrn table at all to acces data for my report. If I replace the SQL with some much simpler i.e.
Code:
Dim MySQLSelect As String = "SELECT stktrn.mm_date FROM stktrn "
Dim MyConnectionString As String = "data source=(local);initial catalog=wen;integrated security=SSPI;"
Dim MyConnection As New SqlDataAdapter(MySQLSelect,MyConnectionString)
Dim MyDataset As New DataSet
MyDataset.Clear()
MyConnection.Fill(MyDataset, "stktrn")
If attempt to put the field mm.date in the report the report gives an error similar to the last one I posted.

This seems like a basic error that I have made but I can't spot what I have done wrong. In my actual SQL statement in my code i.e. "SELECT bc_stock.wo_num, bc_stock.st_qty, bc_stock.ch_prod_da, bc_stock.bar_code, bc_stock.ST_CODE, bc_stock.ST_DESC, bc_stock.ST_LOCN, stktrn.mm_date FROM stktrn LEFT OUTER JOIN bc_stock ON stktrn.CH_KEY = bc_stock.BAR_CODE WHERE bc_stock.ST_QTY = 94" stktrn is sucessfully used in the join. But yet I cannot access anything from stktrn even in the really simple example shown above.

Any help appreciated.

Thanks, Dave.
Reply With Quote
  #20  
Old 09-11-2004, 11:17 AM
Davearia's Avatar
Davearia Davearia is offline
Junior Contributor
 
Join Date: Jul 2004
Location: In A Perfect Cadence
Posts: 358
Default

Looking through my project to spot diiferences between the two tables I found that there is a bc_stock.vb file but not any stktrn.vb file.
I have attached the bc_stock.vb file if it is any use.

Thanks, Dave.
Attached Files
File Type: zip bc_stock.zip (5.1 KB, 0 views)
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
 
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
Storing Results Of SQL Statement That Uses Two Tables Into Dataset/s
 
-->