union and Dataviews??

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - .NET and connection pooling in Terminal Services Hi! I'm designing an architecture that will be run on a 16-node Terminal Services (Citrix) cluster. An Oracle 9i cluster contains the data and ODP.NET will be the interface. Everything else is done on .NET 1.1. For this particular apps there are about 20-100 simultaneous users, though design will be stateless multi-tier, of course. The problem is how to find the best trade-off between performance/scalability. One important thing to consider is connection pooling. I understand how it works in a "typical" multitier environment, but this Terminal Services changes things a bit (or does it?). Normally, no new pool is created if: -Connection string is the same -Process ID is the same (is it the same for multiple TS-clients on the same physical server?) -Application Domain is the same (see the question above) -If there are no transactions outside database If the application and all the dependent assemblies (client, BL and DAL) are installed to the TS, will there be 16 connection pools (1 per TS-node) or one pool/user thus no usable pooling? If the pooling doesn't work in above situation, we may need to move the DAL to a centralized server and use .NET Remoting. However, this I would like to keep as the last resort. That question about processes and application domains is the most important ones at the moment, but all suggestions are welcome, too :) Thanks, -- Joni Moilanen MCSD.NET, MCDBA Tag: union and Dataviews?? Tag: 77832
  - 2
    - HELP NEEDED: ADO.NET - DATAADAPTER WON'T UPDATE TO DATABASE Hi, I'm needing assistance with ADO.NET saving a dataset to my database. I have included code that may show you where I'm going wrong. My goal is simple enough: I have two SQL Server 2000 databases with only minor differences. The program I wish to write will automate the process of copying over certain tables from one database to the other. The example I have included here is for tables that have the exact same structure; the only difference between the old and the new is that the old table from the first database has data, and the new table from the second database is blank. I want to copy the data from the old and put it in the new. My problem is that although I can get the data from the old into a dataset supposedly linked to the new (via dataadapters), updating the dataadapter for the new does not submit the data to the actual database. Any assistance would be greatly appreciated. I have commented my sample code to explain what I have done at each step. Sincerely, -- JR Fournier jurfman@yahoo.com -+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+- Private Sub CopyFromOldToNew(ByVal strTable As String) 'strTable is the name of the table passed from outside functions. 'I wish to use a subroutine like this to perform the copy because I 'will not know the structure of the tables in advance. 'strConnOld and strConnNew are globally defined connection variables. 'They are defined as follows: 'Const strConnOld As String = _ ' "Data Source=localhost;Initial Catalog=utility_be_old;" _ ' "Integrated Security=SSPI" 'Const strConnNew As String = _ ' "Data Source=localhost;Initial Catalog=utility_be_v2;" _ ' "Integrated Security=SSPI" 'I then declare old and new datasets and dataadapters. Dim dsOld As New DataSet() Dim dsNew As New DataSet() Dim daOld As New SqlDataAdapter("Select * from " & strTable, _ strConnOld) Dim daNew As New SqlDataAdapter("Select * from " & strTable, _ strConnNew) 'While filling my dsOld dataset is obviously necessary, I don't think 'filling my dsNew is. The actual "new" database will always contain 'the structure only, not any data. Keep in mind, the table name that 'has been passed to this subroutine exists in BOTH the old and the 'new database. The structure is the same. I would use an SQL 'command and perform this copy manually, but my goal is to create a 'function that has no advance knowledge of which table is copied. daOld.Fill(dsOld, strTable) 'daNew.Fill(dsNew, strTable) 'Of all the code involved, the cmdBuilder usage confuses me the most. Dim cmdBuilder As SqlCommandBuilder = _ New SqlCommandBuilder(daNew) 'The following line of code is one of about 5 ways I have tried. 'This merge statement will successfully take my dsOld data and put 'it into my dsNew dataset. Now, I have also done the row by row 'copy, etc, but the end result of getting the data into the new 'dataset is the same. This is a one line solution that achieves 'the same effect. If there is a way to just use one dataset, since 'the data is the same, I would be happy to use it. But any attempts 'to only use the one dataset resulted in "This table [or this column] 'does not belong to that table", etc. dsNew.Merge(dsOld, True, MissingSchemaAction.Add) 'I added a datagrid to display the contents of the new dataset, 'proving that dsNew contains the data that should be saved to the 'database. DataGrid1.SetDataBinding(dsNew, strTable) 'I confess that the cmdBuilder usage confuses me a bit. 'If I am misunderstanding the usage, please assist. daNew.UpdateCommand = cmdBuilder.GetUpdateCommand() daNew.InsertCommand = cmdBuilder.GetInsertCommand() 'Is AcceptChanges actually needed on my dsNew dataset? dsNew.AcceptChanges() 'From what I understand, telling my daNew dataadapter to update 'should commit my added rows to the new database. No error is 'thrown, but no changes are made in the actual database. daNew.Update(dsNew.Tables(0)) End Sub -+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+-+=+- Please help! :) Tag: union and Dataviews?? Tag: 77830
  - 3
    - Binding a Textbox Generated dinamically Hi Folks! Maybe some one can give me a hand with this problem: I'm building one asp.net page that reads data from the table and builds the table and the controls dinamically, I create a dataset and fill it with all the tables needed. All works fine displaying the info but I have problem with the Databinding since it works different in Vb.NET and ASP.NET, the databindings doesn't exist in ASP.NET it only accepts the Databinder.eval. I call the Sub and pass the Table to draw and which panel to display using DrawTable("FinInfo_Income", 1) The line that display the current value is marke {**}, I tried to use the Databinder.Eval without any luck.. Does anyone know the right form to bind the control ...? TIA for any help! Public Sub DrawTable(ByVal Tablename As String, ByVal TableNumber As Integer) Dim numrows As Integer Dim numcells As Integer Dim i As Integer Dim j As Integer Dim r As TableRow Dim c As TableCell Dim CatSum As Integer Dim Colname As String CatSum = 0 For j = 1 To DS.Tables(Tablename).Columns.Count - 1 r = New TableRow() For i = 1 To DS.Tables(Tablename).Rows.Count Dim box As New System.Web.UI.WebControls.TextBox() Dim lbl As New Label() c = New TableCell() lbl.Text = DS.Tables(Tablename).Columns(j).ColumnName.ToString If DS.Tables(Tablename).Rows(0).ItemArray.GetValue(j) Is System.DBNull.Value Then box.Text = "" Else {**}box.Text = DS.Tables(Tablename).Rows(0).ItemArray.GetValue(j) If DS.Tables(tablename).Columns(1).DataType.ToString = "System.Decimal" Then CatSum = CatSum + DS.Tables(Tablename).Rows(0).ItemArray.GetValue(j) End If End If c.Controls.Add(lbl) c.Controls.Add(box) r.Cells.Add(c) Next i 'This code adds the columns to the Panel Select Case TableNumber Case 1 TableFI.Rows.Add(r) Case 2 TableFH.Rows.Add(r) Case 3 TableFFC.Rows.Add(r) Case 4 TableFLE.Rows.Add(r) Case 5 TableFR.Rows.Add(r) Case 6 TableFS.Rows.Add(r) Case 7 TableFT.Rows.Add(r) Case 8 TableFOE.Rows.Add(r) End Select Next j End Sub Tag: union and Dataviews?? Tag: 77829
  - 4
    - Typed DataSet confusion Greetings! I have a database with a table named Holdings. I has VB.Net create a .xsd file for it so that I could use a typed dataset with it. The table has 21 rows. If I use ordinary datasets, I get a DataTable object with 21 rows. If I use a typed dataset, I get a HoldingTable object with 0 rows. What am I doing wrong? Here's the code: Dim holdingsAdapter As New OleDbDataAdapter() Dim holdingsSet As New HoldingsDataSet() Dim holdingsTable As HoldingsDataSet.HoldingsDataTable Dim holdingsRow As HoldingsDataSet.HoldingsRow 'Dim holdingsSet As New DataSet() 'Dim holdingsTable As DataTable 'Dim holdingsRow As DataRow holdingsAdapter.SelectCommand = New OleDbCommand _ ("SELECT * FROM Holdings", mDB) holdingsAdapter.Fill(holdingsSet) holdingsTable = holdingsSet.Tables(0) MsgBox("The holdings table has " & holdingsTable.Rows.Count & " rows.") This code is in a Try block, and no exceptions are thrown. Also, I notice that my HoldingsDataSet object has a member named Holdings. Is that member an instance of type HoldingsDataTable, like I think it is? Thanks very much! Rob P.S. I have already been told that using "Tables(0)" defeats the purpose of a typed dataset. That's not the point here. Once I know I can get the data I need into the typed dataset, I'll switch over to using it the way it's supposed to be used. Tag: union and Dataviews?? Tag: 77823
  - 5
    - Calling a SQL SP in a Stored Procedure Group This function: Public Function RunSP(ByVal SP As String, Optional ByVal Params As Hashtable = Nothing) As Object Dim oConn As New SqlClient.SqlConnection(CONNECTION_STRING) Dim oCmd As New SqlClient.SqlCommand(SP, oConn) Dim SqlParameter As SqlClient.SqlParameter oCmd.CommandType = CommandType.StoredProcedure SqlClient.SqlCommandBuilder.DeriveParameters(oCmd) If Not Params Is Nothing Then For Each SqlParameter In oCmd.Parameters If Params.ContainsKey(SqlParameter.ParameterName) Then If IsDBNull(Params.Item(SqlParameter.ParameterName)) Then SqlParameter.Value = DBNull.Value Else SqlParameter.Value = Params.Item(SqlParameter.ParameterName).ToString End If End If Next End If Dim oDA As New SqlClient.SqlDataAdapter(oCmd) Dim oDS As New Data.DataSet oDA.Fill(oDS) oDA.Dispose() : oDA = Nothing RunSP = oDS oCmd.Connection.Close() oCmd.Dispose() : oCmd = Nothing End Function returns a dataset returned by the specified Stored Procedure with parameters filled in from the supplied hashtable. However, if I try to call a stored procedure from a stored procedure group (e.g. set SP to "spCustomers_Select;2"), it bombs on the "DeriveParameters" line, saying the stored procedure doesn't exist. Is there a fix for this, besides changing this to construct an EXEC statement? (And would that even work?) Tag: union and Dataviews?? Tag: 77819
  - 6
    - Calling a Stored Procedure in a Stored Procedure Group This function: Public Function RunSP(ByVal SP As String, ByVal ReturnType As ReturnType, Optional ByVal Params As Hashtable = Nothing) As ObjectDim oCmd As SqlClient.SqlCommand = WarehouseDBCommand(SP) Dim SqlParameter As SqlClient.SqlParameter oCmd.CommandType = CommandType.StoredProcedure SqlClient.SqlCommandBuilder.DeriveParameters(oCmd) If Not Params Is Nothing Then For Each SqlParameter In oCmd.Parameters If Params.ContainsKey(SqlParameter.ParameterName) Then If IsDBNull(Params.Item(SqlParameter.ParameterName)) Then SqlParameter.Value = DBNull.Value Else SqlParameter.Value = Params.Item(SqlParameter.ParameterName).ToString End If End If Next End If RunSP = RunAndReturn(oCmd, ReturnType) oCmd.Connection.Close() oCmd.Dispose() : oCmd = Nothing Tag: union and Dataviews?? Tag: 77817
  - 7
    - Passing DataSet to remote server: possible bug Our DAL (Data Access Layer as a dll) is hosted by IIS. We use binary serialization to pass a DataSet into the DAL from a client exe. Our client exe calls GetChanges on DataSet and passes the changes to our remoted DAL. On inserts we have an output parameter for the primary key. After the call to DataAdapter.Update, we watch the insert sproc run and return the output param value. We watch the DataRow change from Added to Unchanged. We watch the source column for output param get set to the outparam's value. The DAL then returns the DataSet to the client exe. Once back in the client exe, the DataRow is still marked as Added and the source column is empty. This is exactly the way it looked when it was sent to the remoted DAL. Now, if we run the DAL locally in a private folder, we see the same results in the DAL. However, back in the client exe the DataRow is marked as Unchanged and the source column contains the output parm value. This leads me to believe there is a bug in the Remoting or ADO.NET architecture. Tag: union and Dataviews?? Tag: 77815
  - 8
    - Oracle Lite 9i connection (newbie) I have installed Oracle Lite 9i at: C:\Oracle\OraLite9i\Mobile\sdk\OLD40\polite.odb (virgin install). Have also installed ODP.NET in Visual Studio.NET (Framework 1.1). Now I try to open the database with the following code: Imports Oracle.DataAccess.Client Public Function OpenOracleLite() As DataSet Dim cnOracleLite As String Dim cn As New OracleConnection(cnOracleLite) Try 'Oracle Lite 9i (ODP.NET) cnOracleLite = "Data Source=POLITE;" & _ "User Id=SYSTEM;" & _ "Password=;" cn.Open() Catch exc As Exception Debug.WriteLine(Err.Number, Err.Description) Finally cn.Close() cn = Nothing End Try End Function Getting the following error: Error: 5 ORA-12154: TNS:could not resolve service name This is my first Oracle install. Please note the connection string parameters. Are they correct for after a virgin install of Oracle Lite 9i? What else is needed (probably in the way of database administration) to get the connection to see the oracle lite db in the path above, or another oracle lite database on another drive? Also: does 9i have any GUI user interface, or is it like MSDE? Thanks, Dean Slindee Tag: union and Dataviews?? Tag: 77814
  - 9
    - Character set on an Oracle DB problem Hello all, I have a problem retrieving data from an Oracle 8.1.7 DB. The query execute correctly, but same characters of strings are not correct. These characters are tipically deutch characters (ö et simila). The nls_characterset, both for server and client is US7ASCII, and i can't change it. I tried the "Microsoft Data Provider for Oracle" and the "Oracle Data Provider.NET" too, but I was unable to fix the problem. Please HELP!!! Lorenzo Tag: union and Dataviews?? Tag: 77813
  - 10
    - Here is one Hiya Group, Sorry to be such a pain but .......... I have a little problem, On my Form I have a ListBox, with 5 Options, Each Option relates to a Table in My database, I also have Add, Update, and Delete Buttons, with one DataGrid. My question is how do i populate the datagrid from the Listbox and get the Add, Remove, and Update Buttons working for each Table? Any Code of URL`s? Many Thanks Si Tag: union and Dataviews?? Tag: 77812
  - 11
    - Clone or copy table.. Schema Information.. Generic ado.net connection Hi: Im writing a table designer through an ado.net provider. Im using a generic ado.net provider, so i cant use database specific data (sysobjects or something like that). I can get some information using DataReader.GetSchemaTable(), but is not enoug. I need, for instace, the types the database uses to fill a combobox, so the user can choose and i can create my "create table" and "alter table sentences". At the moment im using some rare practices like: When the user changes the data type or the size of the type for a column, I have to create an auxiliar table, to send the data, drop the current table and then create a new table with the schema selected by the user, update that table, and drop the auxiliar one. (I don't like that, because if the connection fails, there will remain some garbage tables on the database). Another rare thing im doing is to execute many IDbCommand.Prepare () to "create" tables with all the data base data types i know, (int, blob, char.. 45! in total) to discriminate which of them the current database supports.. :-b As you can see, i need real solutions and ideas. Is there some article, or source code available? Do you have any suggestions? Please help Tag: union and Dataviews?? Tag: 77806
  - 12
    - Why do I have TimeOut Hello, In my Global.asax, I have my connection string Application("strDSNSQL") = "SERVER=(local); UID=LOGIVELO_USER; PWD=!ItsAll4Me; DATABASE=Logivelo1" I have thise code in an ASPX page Dim DecisionCompagnie As Compagnie Dim dtDecisionCompagnie As DataTable DecisionCompagnie = New Compagnie() dtDecisionCompagnie = DecisionCompagnie.GetLastDecision(Session("compagnie"), Session("Periode"), Application("strDSNSQL")) If dtDecisionCompagnie.Rows.Count > 0 Then txtNomCompagnie.Text = dtDecisionCompagnie.Rows(0).Item(4) txtNomGroupe.Text = dtDecisionCompagnie.Rows(0).Item(2) txtPeriode.Text = Session("Periode") txtEmissionAction.Text = dtDecisionCompagnie.Rows(0).Item(6) txtEmpruntLongTerme.Text = dtDecisionCompagnie.Rows(0).Item(7) txtRemboursement.Text = dtDecisionCompagnie.Rows(0).Item(9) ... This is the function that I call in my Compagnie Class Public Function GetLastDecision(ByVal pstrId As String, ByVal pintNoPeriode As Integer, ByVal pstrDSN As String) As DataTable Dim strCommande As String = "" Try strCommande = "SELECT * FROM DecisionCompagnie WHERE NoCompagnie = " & pstrId & " AND NoPeriode = " & pintNoPeriode Dim daDataAdapter As New SqlDataAdapter(strCommande, pstrDSN) Dim dsDataSet As New DataSet() daDataAdapter.Fill(dsDataSet, "DecisionCompagnie") Dim dtDataTable As DataTable = dsDataSet.Tables(0) GetLastDecision = dtDataTable dtDataTable = Nothing daDataAdapter = Nothing Catch... When I try this code 10 times, 8 times it is ok and 2 times I have a TimeOut. I have SQLServer 2000 on my computer and I am alone on the network. I want to understand what I do wrong Thank you Marc Tag: union and Dataviews?? Tag: 77805
  - 13
    - How can I use the same data to update many tables Private Sub btnSaveAndClose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSaveAndClose.Clic In one point in my application I allow the user to select some text - say Yom Kippur War - and then click the QuickWord button. That opens up a frmQuickWord. On it appears a single textbox with the word selected QuickWord was meant to create a new Keyword Set. The selected text in this case will be the Keyword Set, the Keyword and the Search Phrase. In cases where there'll more 2 or more keywords and search phrases(Yom Kippur War, Yom Kipper War, October War), the user will click a different button I realized at once that my problem in the following code is that I haven't bound the textbox to the data. If I have to bind a textbox and a checkbox then it seems I'll need a second textbox for the autoincremental ID field. What I'm afraid of is that I'll have to rebind them in the code for the Keyword, SearchPhrase, and KeywordSetAssignments tables. This would be very wordy, and I have a number of forms of this nature to finish. Is there a simpler way Sorry for the slight incoherence. I'm quite handicapped and quite ill, with a high fever. Nevertheless, I want to get this project done, before I expire. Don't have so much more to do dennis Tr MsgBox(cnQWKS.DataSource.ToString cnQWKS.Open( Dim iKSModified = daQWKS.Update(DsQWKS1, "KeywordSets" Dim strOutput As Strin strOutput = "Modified " & iKSModified & " KeywordSet(s) MessageBox.Show(strOutput, "Update succeeded!", MessageBoxButtons.OK, MessageBoxIcon.Information daQWK.Update(DsQWKS1, "Keywords" daQWSP.Update(DsQWKS1, "SearchPhrase" daQWSP.Update(DsQWKS1, "KeywordSetAssignments" Catch ex As Exceptio MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message End Tr cnQWKS.Close( Me.Close( End Sub Tag: union and Dataviews?? Tag: 77799
  - 14
    - DataSet.Select Is there any way to do a DataSet.Select() statement and use more than one selection "query"? For instance, instead of just selecting all rows where the IDNum is greater than 32 with DataSet.Select("IDNum > 32"), select all rows where the IDNum > 32 and the Region = Midwest. Is this possible? Tag: union and Dataviews?? Tag: 77784
  - 15
    - Editing Rows Yellow to al Iâ??m trying to do edit a row of a datatable Dim dataTable As New DataTable("Vencimento" I create four columns Dim colWork As New DataColumn("ABONO", GetType(String) colWork.Caption = "Abono dataTable.Columns.Add(colWork colWork = New DataColumn("VALORAB", GetType(String) colWork.Caption = "Valor dataTable.Columns.Add(colWork colWork = New DataColumn("DESCONTO", GetType(String) colWork.Caption = "Desconto dataTable.Columns.Add(colWork colWork = New DataColumn("VALORDES", GetType(String) colWork.Caption = "Valor dataTable.Columns.Add(colWork Them I populate the first tow columns with a For, like this For I as string = 1 To row = dataTable.NewRow( row("ABONO") = "Ret. Efectiva row("VALORAB") = "10,00 dataTable.Rows.Add(row Nex This code create three equal lines, and the columns â??DESCONTOâ?? and â??VALORDESâ?? have the null expressio What I want to do now is, fill the columns â??DESCONTOâ?? and â??VALORDESâ? With â??IRSâ?? and â??5,00â?? strings The out put must be like thi Abono Valor Desconto Valo Ret. Efectiva 10,00 IRS 5,0 Ret. Efectiva 10,00 IRS 5,0 Ret. Efectiva 10,00 IRS 5,0 Thereâ??s any one how can help me Thank Ana Rita Tag: union and Dataviews?? Tag: 77780
  - 16
    - Compact & Repair in Access from ADO.NET Hi I wonder how can I use Compact & Repair feature in Access 2003 from my C# project using ADO.NET? Thanks for help Kamil Tag: union and Dataviews?? Tag: 77775
  - 17
    - Column types in a System.DataTable Hello, How does a System.DataTable determine the datatypes of its columns when filled using a select statement. If I fill a datatable using the sample table/data, Select * from myTest (MSS 2K), below the test1 column is defined as a decimal. Why wouldn't it be defined as a Int64? Or can this be controlled? Sample Table and Data: ================ Create Table myTest ( test1 numeric(10,0) not null ) Insert Into myTest Values ( 1, 'value 1' ) Insert Into myTest Values ( 2, 'value 2' ) Thanks, Rob Panosh Tag: union and Dataviews?? Tag: 77772
  - 18
    - Calculated Columns in a DataTable Are there any plans to include the ability to have user defined functions in Calculated Columns in data tables? If not do you know who I can contact to put in a feature request? Tag: union and Dataviews?? Tag: 77769
  - 19
    - Find in DataView using a non sorting column Dear Sirs. in VS 2002. was no direct way to find in DataView if you not find by a sorted column. is it enchansed in vs 2003 ? plz provide me an example Thank you in advance. Tag: union and Dataviews?? Tag: 77762
  - 20
    - Validating Data During Row Changes I want to stay on a row in the table until all validations are OK. For this I use RowChanging event of DataTable and throw an exception if validation is not OK. If I throw an exception without catching, the program ends. If I throw an exception and catch this exception the messagebox with error is show and then position changes. How to stop moving to another position ? Thank you Tag: union and Dataviews?? Tag: 77750
  - 21
    - How to enumerate sql server names/instances on the netork Visual Studio 2003, C#, SQL Server 2000 How to enumerate SQL Server names/instances on the network for a WinForm application ? Thank you Tag: union and Dataviews?? Tag: 77749
  - 22
    - multiple recordsets in ms access h i m tring to create multiple recordsets from ms access thru vb.ne my string i str="select name from jobs;select col2 from jobs but it gves me erro "Characters found after end of SQL statement wat to d amrita thnx Tag: union and Dataviews?? Tag: 77748
  - 23
    - GUIDs as keys - definition and use Hello, I want to use GUIDs as keys for records in a number of tables for a database I'm designing. The reason- I want to be able to "merge" records from different site installations in the future and I don't want key conflicts. Starting with the schema design (sqlserver)- what is the best "type" to pick to hold the GUID? I'm thinking varchar of length 36. After I've designed the schema in SQLServer, I plan to use the server explorer and create a dataset definition for use in .Net. - Any tips for dealing with GUIDS with regard to the code the designer generates? i.e for creating/modifying and deleting records? Thanks in advance, Gene Tag: union and Dataviews?? Tag: 77746
  - 24
    - ADO.NET: using xml as a database, adding rows to the xmlfile Hi, I've got a debug/learn function for doing my xml thingie. I simply want to append data to an xml file. This confuses me, i've looked at xmldocument, xmldatadocument and from what i understand a DataSet is a flexible and "easy" (if you know how) way to work with xml files. I've worked alot with ADO in VB6 so this seemed tempting (i'm still a .net noob or NOOB) I've managed to create a schema for my table and i think i know how to add the data correctly but i can't manage to update my data back to my DataSet and write the DataSet as an XMLFile. I've looked on the DataAdapter but i end up wondering how do i make an OleDB conn to my xml file and i resemble nooo this seems stupid and bigfoot print'ed since they say .net and xml is like bread and butter. I just want to use an xml file as a simple database for my app. Would anyone be so kind to help me out with a updatetable thingie ? My Code fails on the AcceptChanges which i suppose is because my DataRow isn't written back to the DataSet but how do i do that ? Please ignore the bad naming convention this code is mixed with a lot copy paste from various examples... none covers how to work with just a dataset and an xml file.. I think i fail to see the wood because of the forest if you know what i mean :) Public Function doCreateNewXmlfile() Dim ds As New DataSet Dim col As DataColumn Dim oDataRow As DataRow 'Create the table structure. With ds.Tables.Add("Routers") col = .Columns.Add("IPAddr", GetType(String)) col.MaxLength = 15 col = .Columns.Add("HostName", GetType(String)) col.MaxLength = 90 col = .Columns.Add("LogFileName", GetType(String)) col.MaxLength = 30 End With ' Save our schema representing our table structure Dim oFileStream As New System.IO.FileStream(Me.setXmlIpTableFileSchemaName, FileMode.Create) ds.WriteXmlSchema(oFileStream) oFileStream.Close() oFileStream = Nothing ' Create some data in our xmldatabase Dim row As DataRow = ds.Tables("Routers").NewRow row("IPAddr") = "192.168.1.1" row("HostName") = "tower" row("LogFileName") = "tower_Log" row.AcceptChanges() oFileStream = New System.IO.FileStream(Me.setXmlIpTableFileName, FileMode.Create) ds.WriteXml(oFileStream) oFileStream.Close() oFileStream = Nothing End Function Thanks a lot /Kai Tag: union and Dataviews?? Tag: 77745
  - 25
    - Dataset binding to comboboxes - As many items as records?? Hi All, I have been having a hard time figuring how to approach a problem and was hoping I might be able to get some assistance. Here is my situation. I have a dataset that is based on a table in my SQL server database. I am using Databinding to bind the dataset to a series of controls on my form. A few of these controls are comboboxes. One of the comboboxes is bound the the field in the dataset that is my primary key (it's called ID). This works well for me because I can scroll through the combobox and select whichever record I want to deal with and all the controls are updated to that record when I select it. The problem however, resides with another combobox which is bound to a field in the database that can only have two (2) possible choices, Yes or No. I was expecting that this combobox would only consist of two possible choices however I am finding that there are as many "items" in the combobox as there are records in the database. Granted there are only two possible "values" (Yes or No) but they are repeated throughout the combobox. Any idea what I am doing wrong? Has anyone seen this before? Thanks in advance for any assistance! - Derek Tag: union and Dataviews?? Tag: 77743
- Next
  - 1
    - Cast DataView as a DataTable I'm using a third-party tool that takes a DataTable as a parameter. I really need to pass it a DataView instead. When I try to explicitly cast the DataView as a DataTable I get an error that they aren't compatible data types. Does anyone have a suggestion on how to do this? My last resort is to create a new DataTable object and copy the rows from the DataView into the DataTable. But this is an ugly hack and I really hope there is a better solution. Thanks. Tag: union and Dataviews?? Tag: 77741
  - 2
    - Multiple Parents Ok, I've already figured out that its not allowed to have 2 (or more) parents to 1 child table in .NET. (unless I'm totally misinformed). http://support.microsoft.com/default.aspx?scid=kb;en-us;325695 So, how do you get around it. Surely there are plenty of you who have run into this. In my case I have 3 tables (more actually but 3 will suffice for now): PurchaseOrders, Tickets, and Items. Should be a pretty classic example. A customer walks into the shop and places an order for various items which come from several different vendors, therefore these items will belong to several different PurchaseOrders. A Ticket is created for the customer, listing all the items. Thus, a Tickets to Items relationship is implied. However, at the end of the day (or end of the week, etc) the purchaser draws up a series of PurchaseOrders. The PurchaseOrder will have all the items from a particular vendor, for all the Tickets that were generated that day (or week, etc). So, the PurchaseOrder Table needs a relationship with Items as well. Thus, 2 parents, same child. How does ADO.NET handle this? How do I handle this? Thanks, Blake Tag: union and Dataviews?? Tag: 77739
  - 3
    - Add new row to Access database Hi all, I wrote a simple application using C# & Ms. Access DB. 1. Read all record from database into dataset and perform searching functionality. (work) 2. I want to add new record into the database if searching fail. (problem) Here is the procedure: MyTable has 2 columns only (myKey | myValue) where myKey is the PK and myValue column is allow null. ...C# coding private OleDbDataAdapter da; private DataSet dsMyTable; AddRow(string newKey){ DataTable dt = dsMyTable.Tables["MyTable"]; DataRow irow = dt.NewRow(); irow[0] = newKey; dt.Rows.Add(irow); da.Update(dsMyTable,"MyTable"); } there was no error. But when I check in MyTable I couldn't find new record added ??!!! Please advices, Sokun Tag: union and Dataviews?? Tag: 77738
  - 4
    - In memory of a friend! Hello all! Not sure how this should be posted. If I understand my reading. i'll need Visual Basic .NET, ASP .NET, and ADO .NET. So I've posted this thread in all three newsgroups. I apologize up front if this was a mistake. A little background. I've got a large collection of movies in VHS and DVD formats. I've been categorizing them like they were in a database (i.e. Movie Title, Director(s), Writer(s), Cast, etc.), but using a simple text file. I have a MS Windows SharePoint Services (WSS) site, and I thought it would be a great idea to finally put the info in a formal database (I'm using SQL Server 2000 as the underlying database for WSS). A very close friend volunteered to take on this project and come up with a way to query for particular movies. His plan was to use Visual Basic .NET and what else I'm not sure. Well, the week before Xmas my friend died unexpectently. And to his memory I'd like to complete the project on my own, and maybe a little help from a couple of newsgroups. I'm just not sure where to start? I've been doing some reading and as I mentioned above, it seems I'm going to need Visual Basic .NET along with both ASP .NET and ADO .NET. Am I right in that assumption? How I envision the movie portion of the WSS site! There'd be a quick-launch link on the main page. This would take you to a page where half would be setup to search the database for a particular movie. You would put in your search criteria, Movie Title (or what you thought the title was), actor(s), or Director(s). Clicking the [SEARCH] button would bring up another page with the search results. The results of course would be hotlinked movie titles, movies that actor(s) starred, or Director(s) directed. Clicking on one of these hotlinks would take you to that particular movie page on the server. Does that make sense? The bottom of this initial WSS page would also list the alphabet. Maybe 4 rows of 5 and 1 row of 6. Clicking on these hotlinks would take you to a page with that particular alphabetical listing of movies with hotlinks to the particular movie page. I've been copying the small movie posters from imdb.com, and I've found a place where I can get movie trailers, both of which this movie page would house along with all of the other movie info. I know I'm being overly long, but I wanted to explain exactly what the plan was. Now, where do I start? I've got a little experience with Visual Basic .NET, probably enough to get me in trouble, but what else do I need to complete this project? Any help would be greatly appreciated! To the memory of JB! TIA Hodgepodge Tag: union and Dataviews?? Tag: 77736
  - 5
    - Related records - is a datarelation necessary I have a table named ProposedCosts and another table named AdditionalCosts. AdditionalCosts has a foriegn key to the ProposedCostID in the ProposedCost table. When I retrieve records out of the database, I use a SQLDAtaAdapter and the .Fill method to fill a 'ProposedCost' datatable and a 'AdditionalCost' datatable, both tables are in the same dataset. From the front end, if I wanted to add a new row to ProposedCost, that isn't any problem except for the fact that it does not generate a ProposedCostID (this is an identity key in the database). The problem is that if I want to create an 'additional cost' record, I have no ProposedCostID. What is the best way to handle a situation like this? I thought about going back to the database with the dataset and somehow adding a row to the datatable that way, but then when I finally do, do an update, won't it think the row I added is a 'new' row and not an update? Thanks. STom Tag: union and Dataviews?? Tag: 77735
  - 6
    - Dump DataTable to text How can I dump my datatable to a comma delimited (or tab delimited) text file in VB.NET? I was thinking I could simply call an (external) SQL 2000 DTS package, but since I have the data in the Datatable, it would be a waste to requery. Div Tag: union and Dataviews?? Tag: 77732
  - 7
    - ms access & ado.net Hello I have been developping datadriven applications for a while now. I used sql server and msde. but I am on the hunt for an integrated database for a web application I want to write: what I mean is I want to have a file based DB engine (if possible) and include the file in a directory of the web app and access it. I just do not want to deal with the install of a service when redistibuting the app. I am considering ms access but I want to know if I could have multiple connections to it via ado.net since the web app will have multiple users hiting it. I guess that my first question. the other one is : Does any body know of an file integrated DB engine ? I am looking at vistaDB and deseperatley looking for some xml based ones ? Tag: union and Dataviews?? Tag: 77727
  - 8
    - 'Convert' is not a member of 'Boolean' I used the designer in VS.NET 2003 to create a dataset. Within that dataset, there is an element "Tags", with a primary key and relationship: <xs:element name="Tags"> <xs:complexType> <xs:sequence> <xs:element name="TagName" type="xs:string" minOccurs="0" /> <xs:element name="TagDesc" type="xs:string" minOccurs="0" /> <xs:element name="System" type="xs:boolean" minOccurs="0" /> <xs:element name="FieldType" type="xs:string" minOccurs="0" /> <xs:element name="FieldLength" type="xs:integer" minOccurs="0" /> <xs:element name="Decimal" type="xs:integer" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:key name="pkTags" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Tags" /> <xs:field xpath="mstns:TagName" /> </xs:key> <xs:keyref name="TagsLabelsTags" refer="pkTags" msdata:DeleteRule="Cascade"> <xs:selector xpath=".//mstns:LabelsTags" /> <xs:field xpath="mstns:TagName" /> </xs:keyref> Nothing special, right? When I attempt to build the project I get a series of compile errors in the code behind: 'Convert' is not a member of 'Boolean'. Public Sub SetTagDescNull() Me(Me.tableTags.TagDescColumn) = System.Convert.DBNull <--- Here End Sub There is one error for each of the non-key fields, all in the Set_Field_Null() subroutines. I'm lost. Any ideas? Tag: union and Dataviews?? Tag: 77726
  - 9
    - SQL Server basics I have a Dataset containing a DataTable (say, 'dt1') that has all the fields that are contained in a SQL Server database's table. In addition, it contains a field (let's call it 'HasItems') of type boolean. I want to populate 'dt1' with all the records in the SQL Server table, and populate the 'HasItems' field with True if matching records exist in another SQL Server table (actually a view), and False if no matching records exist. I could do this easily in Access, but I'm new to SQL Server, and need to know the best way to go about it. (The way I'm doing it now has me thinking, "First the earth cooled, then the dinosaurs came..."). Specific help would be appreciated, but also a reference I could use to ramp up my SQL Server skills would be nice too. Thanks. Tag: union and Dataviews?? Tag: 77723
  - 10
    - Error: Cannot insert a non-null value into a timestamp column Hi, I have a typed dataset with tables including timestamp type field, when ready to commit the change back to the SQL server trough the data adapter and my storeprocedure, I receive the error. How can I force SQL server inside a storeprocedure a NULL value for that timestamp field? Is there a better solution from my c# code? I try the following, ---------------------------------------------------------------------------- ALTER PROCEDURE dbo.InsertUser ( @last_name char(25), @first_name char(20), @phone char(20), @login_name char(30), @email char(100), @last_login datetime, @datemodif datetime, @timestamp timestamp, @user_id uniqueidentifier OUTPUT ) AS SET NOCOUNT OFF; SET @user_id = NEWID() SET @timestamp = NULL INSERT INTO [user] (user_id, last_name, first_name, phone, login_name, email, last_login, timestamp, datemodif) VALUES (@user_id, @last_name, @first_name, @phone, @login_name, @email, @last_login, @timestamp, @datemodif); SELECT user_id, last_name, first_name, phone, login_name, email, last_login, timestamp, datemodif FROM [user] WHERE (user_id = @user_id) Tag: union and Dataviews?? Tag: 77714
  - 11
    - login failure msg Just wondering if anyone knows what might be causing this login failure. I used the data-adapter wizard and selected use an existing connection(also tried new connection that test ok). I selected use existing stored procedure, for the select operation selected the stored procedure I want to use. It created the adapter and also an SQLconnection on the page. So for some reason am getting this login failure. I am able to connect to the dbase in the solution explorer and when I look at the connection string in the data adapter I noticed there is no password value. I have workstation id="xxxxxx";packet size=4096;user id=xxxxxx;data source="xxxx";persist security info=False;initial catalog=Vehicle_Mileage here is the error message. Login failed for user 'MileageWeb'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'MileageWeb'. Source Error:= line 72 Line 70: Me.SqlDataAdapter1.SelectCommand().Parameters("@EndDate").Value() = "1/6/2003" Line 71: Me.SqlDataAdapter1.SelectCommand().Parameters("@StartDate").Value() = "1/1/2003" Line 72: SqlDataAdapter1.Fill(ds_vhist, "VehicleReservation") Thanks Paul. Tag: union and Dataviews?? Tag: 77711
  - 12
    - Converting Recordset to DataView I originally posted this question to the vb.net newsgroup, but it was suggested that I re-post here. I have an application that was converted from VB6 to .Net. The app uses a data access layer that returns data as disconnected recordsets. I'm adding new functionality to the app and want to use .Net controls and data binding. So, I'm converting a recordset to a dataview that can be bound to a listbox control. I'm doing this conversion via a data adapter using the following code: Public Shared Function GetViewFromRS(ByVal pRS As ADODB.Recordset) _ As DataView Dim sAdapter As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter Dim sTable As System.Data.DataTable = New DataTable sAdapter.Fill(sTable, pRS) GetViewFromRS = New DataView(sTable) End Function So far so good. The first time I call this function it works perfectly. However, I need to call it multiple times to update the DataView as the recordset is modified. The problem is that subsequent calls to this function for the same recordset always return a DataView that has no rows (Count = 0). Can anyone explain why this problem is occuring and how I might work around it? Thank you. Kees VanTilburg VanTilburg Enterprises Tag: union and Dataviews?? Tag: 77710
  - 13
    - ReadXML Dataset throws Insert Into error I'm in the process of learning ADO.net with Vb.Net and I've been stumped by the following problem. I created an XML file of an Access Table that is filled with 400 records (using .WriteXml("c:\HospitalList.xml", XmlWriteMode.WriteSchema)). I then purged the table of all the records, I thought I should be simply able to repopulate the table with the XML file, but when ever I try I get a "Syntax Error in Insert Into Statement". I'm allowing the DataAdapter to create the Insert command, here is what is being created: CommandText: "INSERT INTO HospitalList( Index , HospitalName , TransferAgency , Visible , HospCode , StateIndex ) VALUES ( ? , ? , ? , ? , ? , ? ) Thanks for you help, code belo Andy Moye ------Code snipet--- Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:\Working_D\Lists.mdb Dim cn As OleDbConnection = New OleDbConnection(strConnection cn.Open( Dim strSelect As String = "SELECT * FROM HospitalList Dim dscmd As New OleDbDataAdapter(strSelect, cn ' Load a data set Dim ds As New DataSe Dim dsXML As New DataSe ' Set the data adapter object's UPDATE, INSERT, and DELET ' commands. Use the SqlCommandBuilder class's ability to auto ' generate these commands from the SELECT comman Dim autogen As New OleDbCommandBuilder(dscmd 'Simply fills an empty DS with the Select Statemen 'dscmd.Fill(ds, "HospitalList" 'OR Fills the Data set with the Scehma only, no dat dscmd.FillSchema(ds, SchemaType.Source, "HospitalList" dscmd.Fill(ds, "HospitalList" ds.ReadXml("C:\hospitallist.xml", XmlReadMode.ReadSchema dt = ds.Tables.Item("HospitalList" 'Simply do this to see if any records are flagged as change Dim dt2 As DataTable = dt.GetChanges(DataRowState.Added MsgBox("Rows Added " & dt2.Rows.Count dscmd.Update(ds, "HospitalList" Tag: union and Dataviews?? Tag: 77709
  - 14
    - Displaying Enumerated DB Integers as Strings In DataGrid Hi Quite a banal problem... But for some reason I have found no elegant solution.. I have enumerated integer values in my DB, and I would like to use DataGrid for displaying the contents of the DataSet (filled from the DB, of course) including displaying meaningful text strings for the enumerated integer values There are several levels in which this issue may be handled, So.. 1) Is there any way to force use of a specific user-defined type, which can be converted to/from a DB type (Int for instance) when generating typed DataSet? I mean possibility to use a user-defined type (Enum or other class, minding the conversion possibilities) in the XSD schema 2) Is there a simple way to force the DataGrid to perform conversions from integer values to strings, through using enums or something? (Without implementing some custom monstrosity DataGridColumnStyle or something) 3) I hate to think of putting conversions and giving the DataGrid other DataTable with converted string values.. Thank you. Tag: union and Dataviews?? Tag: 77708
  - 15
    - Getting changes from the database I'm using a DataAdapter to Update and Synchronize with the database. When I do a Fill on my dataAdapter I get the changed and new records from the database (changed by other users) into my dataset but not those which have been deleted at the database. Is this the way the DataAdapter should work (don't synchronize the deleted records from the database to the dataset) or is it my fault? If this is the way the DataAdapter act's what can be done, do get completely in synch? If I do a clear on my dataset before invoking the Fill method, my databinding get's lost for a Moment, because the dataset is completely rebuild. Thanks. Tag: union and Dataviews?? Tag: 77703
  - 16
    - insert decimal in Access Hallo Im learning VB.net 2003 and now I like to insert a decimal in Access, but the number 10,25 is in Access 1025. The Access field is also decimal with 2 digets behind. I think it will be on the regional settings, because whenn I try with 10,25 then it works. But my variable is always format as 10,25. What must I do? Can anyone help me? Tag: union and Dataviews?? Tag: 77691
  - 17
    - Datareader passed ByVal - OOP Basics question Hi All, I've a big doubt about reference to object destruction. In the test below I call 2 times a sub passing a datareader in 2 different ways. Who can tell me if datareader is destroyed in both cases and so connection closed (using dr behavior)? *-*-*-* Case 1 *-*-*-* Dim cm As SqlCommand Dim dr As SqlDataReader = cm.ExecuteReader(CommandBehavior.CloseConnection) ' Datareader is passed ByVal to MySub ' I have to close "dr" here and "otherdr" in MySub MySub(dr) dr.Close() dr = Nothing *-*-*-* Case 2 *-*-*-* Dim cm As SqlCommand ' No reference to datareader exist (?) at this level, ' I have only to close "otherdr" in MySub ? MySub(cm.ExecuteReader(CommandBehavior.CloseConnection)) *-*-*-* MySub *-*-*-* Sub MySub(ByVal otherdr As SqlDataReader) While otherdr.Read ' Do something End While otherdr.Close() otherdr = Nothing End Sub -- Giulio Tag: union and Dataviews?? Tag: 77687
  - 18
    - Newbie: Adding new rows to dataset Hi, I have a data-entry type form I created with textboxes bound to a dataset. I can successfully pull all the correct information up and change any existing data, and navigate through each record using the BindingManagerBase.Position. What I'm trying to do now is add a row to the dataset and then move to that row with the form to add new information. I've tried declaring a new row and adding it to the dataset, as well as doing BindingManagerBase.AddNew. Each of these adds a row to the dataset, but I can't get it to show on the form. When I close the form, the database is updated, and the new row appears in the database table correctly. How do I get the form to show the added row? Thanks, Nathan Tag: union and Dataviews?? Tag: 77682
  - 19
    - Databinding question hi all, Can we call our procedures when databinding is in process. I want to check all the checkboxes in a checkboxlist control while data is coming from dataset. I can do this after the binding is done.. and manully loooping through the checkboxlist control and checking all the checkbox.. but i want to ask if there's better way to do it.. thanks Noor Tag: union and Dataviews?? Tag: 77678
  - 20
    - Working with a dataset I have a dataset with tables in it that i have filled from my database. If i want to find the Max value from a column in my dataset how do i do this? ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: union and Dataviews?? Tag: 77675
  - 21
    - UTF8 Character Set issues with Oracle Provider We are building an application with VB.NET on the .NET Framework 1.1 and the .NET Managed Provider for Oracle. We are connecting to an Oracle 9.2.0 server on HP-UX using the 8.1.7 client. The character set on the server instance is "AL32-UTF8". When we call OracleCommandBuilder.DeriveParameters(), we get the following exception: System.Data.OracleClient.OracleException: ORA-06550: line 1, column 72: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated KB 322158 seems to indicate that there are some issues when UTF character sets and NCHAR, NVARCHAR2, or NCLOB data types with the Oracle 8.1.7 client. In our case, we are using standard CHAR, VARCHAR2, and CLOB data types. If the Oracle client is upgraded to 9.2, the exception is not thrown. However, we would like to avoid upgrading the Oracle client, as there is a large number of machines with the 8.1.7 client already installed. Can anyone else shed some additional light on the issue? Thanks, Brian Baker -- Microsoft MVP -- ASP / ASP.NET Please post responses to the group Tag: union and Dataviews?? Tag: 77662
  - 22
    - GROUP BY date I think I need to format the date in the table when I use GROUP by to group the dates. The table has date and time stamp but I need it to group by the date alone without the time stamp. How do I format the date field in the SQL statement using SQL Server? I was able to do it in MS ACCESS but it is different in SQL Server then MS ACCESS or .net then VB6. The old way was "Select sum(tot) as total, dte from tblName group by format(dte, 'mm/dd/yyyy') " Thanks Tag: union and Dataviews?? Tag: 77649
  - 23
    - passing input parameter to sql server sproc I have a very simple Stored Procedure that isn't working for me: CREATE PROCEDURE FindTutors ( @LastName NVarChar ) As ( SELECT fn, ln FROM main WHERE ln = @LastName ) GO Very simple; just trying to pass the @LastName parameter from my ASP.NET code. Still, whenever I click the button that is supposed to show all results in a datagrid, nothing comes up. I have altered the Sproc to just be "SELECT fn, ln FROM Main WHERE ln = 'Damon' " and it works fine then - so I know it's a matter of passing this parameter. Here is my codebehind - anyone have any ideas? Public Sub FindTutors(ByVal sender As Object, ByVal e As EventArgs) Handles btnFind.Click Dim cn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("ConnString")) Dim Cmd As SqlCommand = New SqlCommand("FindTutors", cn) Cmd.CommandType = CommandType.StoredProcedure Cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value() = txtLastName.Text.ToString() 'Cmd.Parameters.Add("@LastName", txtLastName.Text) cn.Open() Dim rdrContent As SqlDataReader gridTutors.DataSource = Cmd.ExecuteReader() gridTutors.DataBind() cn.Close() End Sub ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: union and Dataviews?? Tag: 77648
  - 24
    - Filling dataset from text file. I am getting data from a text file using the folowing code. It uses the schema.ini file to define a structure of the datatable in the Dataset. The default file called schema.ini. I have about 10 or 15 tables i have to populate. Is there a way to specify an ini file i want to use? Dim Conn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FilePath & ";Extended Properties=""text;HDR=NO;FMT=Delimited""") Dim Comm As New System.Data.OleDb.OleDbDataAdapter("select * from " & FileName, Conn) Dim DS As New DataSet Try Comm.AcceptChangesDuringFill = False Comm.Fill(DS) End try Tag: union and Dataviews?? Tag: 77647
  - 25
    - Dataset generation and relation rules In VS.NET 2003 if you use sqldataadapters at design time to create your dataset there is problem : after you regenrate a dataset the relation rules are set all to default. Any quick hint to avoid this? Tag: union and Dataviews?? Tag: 77643

is it possible to create a union multiple tables within a dataview?? Taking
in consideration that both table will look the same but come from different
connections

select * from table1
union
select * from table2

if so can anyone show me how to do this???

Vince

Top

Re: union and Dataviews?? by Miha

Miha
Thu Jan 22 02:41:54 CST 2004

Hi vincent,

Try DataSet.Merge method - it will merge both table records to one table.
You can't do it through DataView though as DataView acts on a single table
only.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"vincent Blain" <vblain@digitalvoicelogging.com> wrote in message
news:O1vDGAI4DHA.876@TK2MSFTNGP10.phx.gbl...
> is it possible to create a union multiple tables within a dataview??
Taking
> in consideration that both table will look the same but come from
different
> connections
>
> select * from table1
> union
> select * from table2
>
> if so can anyone show me how to do this???
>
> Vince
>
>
>

Top

Re: union and Dataviews?? by David

David
Wed Jan 21 18:44:41 CST 2004

"vincent Blain" <vblain@digitalvoicelogging.com> wrote in message
news:O1vDGAI4DHA.876@TK2MSFTNGP10.phx.gbl...
> is it possible to create a union multiple tables within a dataview??
Taking
> in consideration that both table will look the same but come from
different
> connections
>
> select * from table1
> union
> select * from table2
>
You can fill the same DataTable from two different connections.

David

Top

Re: union and Dataviews?? by David

Top