finding child tables

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
    - very rookie VBScript ADO RDS Binding question Looking at what is posted here, I'm afraid this will be a real dumb thing to ask (I'm just getting into web programming after having worked in mainframe programming for a long time). I'm learning about ADO RDS Binding. My (simple) web page finally has been made to successfully retrieve a little data from my sample database (which has a "songs" table and a "users" table - joinable on a field called "username"). I'm now trying to persist the extracted recordset (eventually in XML and in a "stream") and to make a user fiendish (oops - I meant "friendly") "table" with sortable column headers and all that... To help me learn about the topic, I found a very interesting MSDN article that had a great looking VBScript at the bottom. The idea of the script is to present form input fields via the page and you can override defaulted connection info and have the script draw you a simple "table" from one of your database tables... Well - I can't get the VBScript to work... I get the form inputs to show up just fine but when I click the "run" button, nothing seems to really happen (and I sure don't get my MS Access info displayed in a "table" on the screen like is supposed to happen). So, my question is "can someone coach me as to how to get the script really to work?" I can share where to find version of the script if that would help. The MDSN article is at: (except for very minor tailoring like putting my column names in where they had different columns, my script is exactly like the one in the article)http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjaddataconx.asp Some of my connection info is as follows: ' CONNECTION STRING DataBasePath = Server.MapPath("..\db\fpdb\srtestdb.mdb") DatBaseDriver = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" DataBaseSource = DatBaseDriver & DataBasePath ' CONNECTION Set DBConn = Server.CreateObject("ADODB.Connection") DBConn.Open(DataBaseSource) ' Create an ADO recordset object Set rsSRDB = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT [songs].[songtitle], [songs].[songgenre], [songs].[songusername], [users].[username], [users].[emailaddr] FROM users LEFT JOIN songs ON [users].[username] =[songs].[songusername];" ' Open the recordset with the SQL query rsSRDB.Open strSQL, DBConn ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: finding child tables Tag: 85789
  - 2
    - Strongly typed data sets Hello there, How can I automatically create strongly typed data set from existing SQL Server 2000 tables. I know that I can drag and drop a table to generate one, but I'd like to generate strongly typed data set for all specified tables with relations between them ? Is it possible with Microsoft Visual Studio Enterprise Architect 2003 or another tool ? Thank You Best regards Rafal Grzybowski Tag: finding child tables Tag: 85785
  - 3
    - Date Querry Hello, I am working with an Access Database and am trying to return a Querry that is between two specified dates, I have tried the following and none of them work: 1) ADataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Contributions WHERE 'Date' > " & dtpFrom.Text & " and 'Date' < dtpTo.Text & ";", AConnectionString) 2) ADataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Contributions WHERE [Date] BETWEEN DATEPART ('" & dtpFrom.Text & "') AND DATEPART ('" & dtpTo.Text & "')" , AConnectionString) 3) ADataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Contributions WHERE 'Date' > 1/1/2004 and 'Date' < 6/1/2004;", AConnectionString) No records are returned. Any suggestions will be greatly appreciated. Thanks, Chuck Tag: finding child tables Tag: 85783
  - 4
    - Advice on filtering and using a Data View Using vb.net, I created a data view and would like to filter the view and determine if a record or group of records exists. My question..........is there a property I can check to determine if the view contains records meeting my criteria after filtering is performed? Also if the view does in fact contain records, is there a way to loop through view to get certain field values from it? Wil. Tag: finding child tables Tag: 85773
  - 5
    - Error create DataAdapter with Config wizard. hi I was trying to use following query to create Data Adapter SELECT DISTINCT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Customers.CompanyName, Customers.Address, Customers.City FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerI Error always happen with -------------------------- Primary Key Columns Missin -------------------------- The wizard can not automatically create queries for updating the database because your query does not include some primary key columns. Do you wish to add the primary key columns to your query Please suggest how can I fix it rgds Fish. Tag: finding child tables Tag: 85763
  - 6
    - Get "table doesn't have a primary key exception" I get a "table doesn't have a primary key" exception during a .Rows.Find(string); However the table has a primary key. I moved it from one column to an other. But the table designer shows it. What could be wrong? Tag: finding child tables Tag: 85753
  - 7
    - Web Services and SQL Server Stored Procedures I've written a very basic web service that is used by my PocketPC to add two numbers together. It works fine. So next I'm writing a WebService which accesses my SQL Server and returns rows appertaining to a specific OrderId. I have written a stored procedure called spGetConfirmedOrder to which I pass the OrderId and it works okay until I need to reference it in my code then it doesn't recognise it. Is there something that I'm missing out here do I need to get involde with SOAP and WDSL files or can I just use ADO.NET? Regards Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.667 / Virus Database: 429 - Release Date: 23/04/2004 Tag: finding child tables Tag: 85749
  - 8
    - DataGrid master-detail indicator Microsoft make a feaure in Datagrid that support master-detail in the one grid. but for end user i prefer to present MD by tow grids. on the master grids have automatic indicator (+), this is redundant, and end user may confuse with it. can i remove the (+) indicator from master datagrid? how to do that? Tag: finding child tables Tag: 85741
  - 9
    - SqlConnection Question Hi , I have a Dll with few functions and when i m opening a connection by using one of the Dll functions and i m relating the connection to some SqlDataReader then i can't use the connection for other purpose until i will close the DataReader . why is that ? why i can use the connection for other things but for SqlDataReader more then once ? how can i work with the same connection ? should i work with one connection or should i open a new one ? please notice that i need to use the connection while i m in the middle of some loop in the datareader (While DataReader.Read() ...) Best Regards , Tiraman :-) Tag: finding child tables Tag: 85732
  - 10
    - batch query ?! I just watch an overview of ADO.NET 2 on MSDN TV. In that demo the SqlDataAdapter featured a batch mode where you cold submit update of many line with one query. (instead of the line by line update as now) I thought it was a great feature. Now in my own PocketPC database application (www.ihookdb.com :) I have my own "data access layer" and I thought it would be nice to use batch update too. (and because it's my code I could do it today :) And there a few question came to my mind (on about how to do that) 1. I was thinking, oh well man, it's simple, just queue the query with ';' in the middle. but there is a problem if I write UPDATE MyTable (field1, field2) VALUES (@field1_1, @field2_1) WHERE ID=@field3_1; UPDATE MyTable (field1, field2) VALUES (@field1_2, @field2_2) WHERE ID=@field3_2;..... N times (where N is my batch size) (notice I write @field_1 for 1st query, @field1_2 for the second, etc ...) but what if I use a batch size of 100 and they submit only 3 line changes ? should I create the query depending on the number of changes ? how to do that cleanly ? 2. but there is worst ! lest say I do an INSERT with an ID Identity column, I should have a SELECT @@IDENTITY after my insert. but what happened if I do many insert at a time ?!.... Any SQL Admin to rescue me ?!! Tag: finding child tables Tag: 85726
  - 11
    - How To Use Null ? Hi , i would like to init an integer param to Null dim x as integer x = null how can this be done ? -- Best Regards , Tiraman :-) Tag: finding child tables Tag: 85722
  - 12
    - Oracle Client Hi, Anyone out there successfullly used the microsoft client to get data back via a stored procedure? If not, can the oracle client be used on 8.1.7? The proc is simply 'get * from widget' I have a cursor as the output parameter in the proc. My addparameter command in .net is correct: myDBNull = Convert.DBNull strSQL = "proc_GetColWidths" cmdConn = New OracleClient.OracleCommand(strSQL, New OracleClient.OracleConnection(mstrConn)) cmdConn.Parameters.Add(New OracleClient.OracleParameter("xx", OracleClient.OracleType.Cursor, _ 2000, ParameterDirection.Output, True, 0, 0, "", DataRowVersion.Default, myDBNUll)) cmdConn.CommandType = CommandType.StoredProcedure cmdConn.CommandText = strSQL cmdConn.Connection.Open() cmdSource = cmdConn.ExecuteReader(CommandBehavior.CloseConnection) I get ora-06550 error when the executereader fires Appreciate any help to sort this out. Thanks Bob Tag: finding child tables Tag: 85704
  - 13
    - Common Database Interface I am trying to develop a program that would work with any database using ADO.NET. I am having a hard time because of the differences in SQL syntax between databases. One example is when I try to specify the column name, some databases require that I put the name between square brackets, others between quotes, etc. I had a similar problem with data/time fields, but I could solve it by using an algorithm with reflection and tags in the SQL sentences. I would really appreciate if anyone could tell me if there is a standard syntax to specify column names that all the databases should accept. At this point I concluded that I will have to create settings in my program to enable the user to enter with this format, but something automatic (as I found for date) would be much better. My deadline for this project is next week, so I would appreciate if anyone could send me feedback as soon as possible. Regards, Lourenço. Tag: finding child tables Tag: 85703
  - 14
    - DataSet problems - selecting on aggregate functions I have a dataset containing an already-populated single datatable which I which to perform an operation on. The structure of the table is below: Specifically, I want to get the most recent message for every unique {Group, User, Subject} subject to TimeStamp being less than an AsOfDate that is externally specified. I then want to bind this table to a DataGrid. I am having trouble since I am used to Access queries (new to the .NET arena), and do not know where to start. TableName: Messages Fields: Group (String) User (String) Subject (String) Message (String) TimeStamp (DateTime) Primary Key: {Group, User, Subject, TimeStamp} Any help would be most appreciated. Thanks! Tag: finding child tables Tag: 85698
  - 15
    - Adding two a Datagrid Hi all, Ok I have a sub that creates a Datatable loads some values then I bind it to a DataGrid to show the user. I later need to add values to the third Column in that datagrid? Ok I tried a Global datatable but at the line where Datagrid.Datadource = Datatable it takes like 3 - 5 seconds? thanks for any help Gerry Tag: finding child tables Tag: 85691
  - 16
    - Type.GetType of Byte-Array Hello, I want to set the schema of a DataTable. It should have the same structure than my Datatable in SQL Server. The last column is a Timestamp called Stempel. Timestamp is treaten an a Byte-Array. What can I do to set the Type for this column? Dim myDataTable As DataTable = New DataTable("Adressen") myDataTable.Columns.Add("ID", Type.GetType("System.Int32")) myDataTable.Columns.Add("Vorname", Type.GetType("System.String")) myDataTable.Columns.Add("Nachname", Type.GetType("System.String")) myDataTable.Columns.Add("Stempel", Type.GetType("???")) Thank you Steffi Tag: finding child tables Tag: 85684
  - 17
    - Generate ADO.NET DataSet outside .NET Framework Hi All We have a big application server build using Delphi 7. Then, our idea is to build a web tier (client) using ASP.NET / Web Forms. My idea: generate manually a ADO.NET DataSet (XML) in Delphi 7, based in Delphi DataSets. How Can I do this? Thanks Guinther Tag: finding child tables Tag: 85674
  - 18
    - What data object should I use with a DataGrid I am creating a page that will use a DataGrid. It will display a list of people. Each row will have an Edit button that will take the user to another page where they can edit that particular record. Each row will also have a Delete button that will delete the record. Should I use a DataSet as the datasource of the Grid? Tag: finding child tables Tag: 85672
  - 19
    - OracleClient Connection string .. I'm trying to connect to Oracle database in the asp.net app. But keep getting the error: "ORA-12154: TNS: could not resolve service name at System.Data.OracleClient.DBProjectPool.GetObject(Boolean&isInTransaction) at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledconnection .. " ============== Here's the connection string I'm using: dim sConn as string = "Data Source=DSNName;User ID=username;Password=password;Integrated Security=SSPI" Code to connect to the database: imports system.data imports system.data.OracleClient imports system.configuration dim objConn as OracleConnection = new OracleConnection objConn.ConnectionString = sConn 'as defined above Try objConn.open catch ex as Exception response.write(ex.Tostring()) finally objconn.dispose End Try ============== Also, I have given full control to the ASPNET account and the IUSR and the IWAM accnt in the Oracle bin folder. Can someone point out what's going wrong? Thanks Tag: finding child tables Tag: 85669
  - 20
    - Subclass DataColumnCollection Does anyone know how to subclass the DataColumnCollection asy like DataRow where you can use a rowbuilder in the constructor? thanks Gerald Klein Tag: finding child tables Tag: 85666
  - 21
    - Typed DataSet Problem Hi, In my application I am manually adding a datarow (with user data not from db) in a typed dataset. At that time the datarow row state is "Added" which is correct. The problem I am running into is when I modify that row later in the application the row state is still "Added" and not "Modified". Why is this the case? Thanks Tag: finding child tables Tag: 85656
  - 22
    - access query and DataAdapter have different data I have a access query with 3 tables with left joins and some criteria conditions. Viewing the query in access 4 records are returned which is correct. If I use a .NET OLEdbAdapter to read the query I get only the first record in the .NET application. Many onther queries and tables work fine. It appears that the jet 4 connection to access can not be relied upon and access should not be used as an undelying application database. Has anyone seen simular problems or know a solution? Tag: finding child tables Tag: 85642
  - 23
    - Problem calling Fill() method I have several tables involved in my application, but the two in question here are the company and address tables. The company table has business_address_id and mailing_address_id columns, which are both foreign keys to the address table. So, the stored procedure to which my SelectCommand points to reads as: ALTER PROCEDURE dbo.CompanyInfoByCompanyID ( @companyid int ) AS SET NOCOUNT ON SELECT * FROM Company WHERE company_id = @companyid SELECT * FROM Address WHERE (address_id IN (Select business_address_id From Company Where company_id = @companyid)) OR (address_id IN (Select mailing_address_id From Company Where company_id = @companyid)) RETURN Whenever I attempt to add a new row into the Address table using my daAddress dataset, the update works fine and even enters a new row inside the Address table. However, when I attempt to refresh my datagrid by calling the Fill() method on the Address adapter I get the following error: Exception Details: System.Data.SqlClient.SqlException: UPDATE statement conflicted with COLUMN FOREIGN KEY constraint 'Address_Company_FK1'. The conflict occurred in database 'OFS', table 'Address', column 'address_id'. I placed the Find() call in a try/catch block, and upon closer inspection discovered this error message: DataSet errors: dsCompanyInfo Table: Address Row Error: Column 'zip' does not allow DBNull.Value. Now, the zip column is indeed populated upon calling the Update() method, and it is populated in the database. So I have no idea where this error message is coming from. Your assistance would be greatly appreciated, Mervin Williams Tag: finding child tables Tag: 85641
  - 24
    - Clearing the pending results I have a stored procedure. I calls some other procedures and then returns a single result. However, the other stored procs are returning rows that i don't need. How do I clear the results so that the other value returned is the one at the end of my proc? thanks, steven Tag: finding child tables Tag: 85639
  - 25
    - How does a DataReader work ? Hi I have a question on how the datareader work underneath when retrieving the records from the data source Does the DataReader fetch one row of data everytime I call the Read() method or all the rows for the query is available in memory before I call Read() method ?. Tag: finding child tables Tag: 85638
- Next
  - 1
    - Update a Table using transactions Hi all, i have a problem with a transaction.i will tray to explain my problem. i have a Dataset that i have fill using 2 DataAdapter with a simple query ( all tables with an autonumber). i have made code for the dataadapter rowupdate to get the @@identity of my table. everything works fine. now is the problem, i have made a transaction to made this works, when i do the endcurrent edit of my CurrencyManager, i want to submit the row to the DataBase. i have submited the first table and works fine when i try to submit the second table it throws an exception. after that every thing is ok but when i press again the save button when i´m going to submit the first table again it throws an cocurrency violation, and the row state of the row that i´m try to submit have changed the rowstate from Added to Modified. anyone knows why ?? thsk JSB plsea see the code below so i have made some thing like this 'update Function dim cmd as SQlClient.CommandBulider ( DataAdapter) dim cmd1 as SQlClient.CommandBulider ( DataAdapter2) try BD.Open trans = bd.BeginTransaction DataAdapter.update ( Ds,Table) ' some code that mades a error ' bla bla bla ' in this peace of code ocurs an Error that throws an Exception DataAdapter2.update ( Ds,Table2) trans.comit catch trans.rollback finally bd.close end try Tag: finding child tables Tag: 85635
  - 2
    - how remove the + indicator from master datagrid when i release my program with master-detail form, i want to remove the (+) indicator from master datagrid. how to do that? Tag: finding child tables Tag: 85634
  - 3
    - Create an empty datatable Hello, I'm a =2Enet (CF) newbie, and I have the followong problem: I try to create an application in =2ENET CF using data stored in= XML/XSD files for an iPAQ=2E When I load an XSD file into a dataset i want to create an epmty= table which structure was described in the xsd file=2E The only= solution I have found is to load a "dummy" xml file with at= least one record that match the table's structure and then call = the "Clear" method for the table, but it's not very= comfortable=2E=2E=2E thanks for any replies in advance ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>SjnJkud1qECcBYOns4JUbQ=3D=3D</Id> Tag: finding child tables Tag: 85628
  - 4
    - Export to Excel and Single Quote problems? Hi All, I am exporting data from a dataset to an excel spreadsheet via OLEDB. Everything works fine but one part. All my cells have a single quote in the beginning of each piece of data. I realize this is how Excel maintains the data as text; but I am wondering how I can prevent this from happening at all. Thanks, John. Tag: finding child tables Tag: 85617
  - 5
    - difference between Integrated Security=True and Integrated Security=SSPI Hi , Is there any difference between Integrated Security=True and Integrated Security=SSPI? The docs seem to indicate they are the same but i have seen different behaviour when connecting to sql server using each in the connection string. All info welcome. Regards John Tag: finding child tables Tag: 85615
  - 6
    - have a memory database with ability of sql? i need to build program that can connect to large DB or small one, according user needs. but i whant that my program retrive data from tow resource in same code of sql select. i whant to manage data in memory, and save it like xml or somthing else. but i need to use with sql selelect. the dotnet offer only select method. but i want to use with standard sql. in delphi i think that Datastore make this job. in dotnet have somthing like? Tag: finding child tables Tag: 85606
  - 7
    - OracleCommadbuilder: Exception: Parameter 'p1': No size set for variable length data type: String. When updating an Oracle Varchar2 column with an empty string "" using the OracleCommandBuilder generated UpdateCommand the follwing error is thrown: "Parameter 'p1': No size set for variable length data type: String." Is this a bug in the OracleCommandBuilder? Is there an elegant workaround? Updating with DBNull.Value instead of an empty string does not throw the above error. Tag: finding child tables Tag: 85605
  - 8
    - nested table nested table for what? how it's work. i try to raed in msdn, and i make simple parent child table: table aa table bb i drop bb table into aa table, i make simple form with tow datagrid, the first one bind to aa and second to bb table. i run the program, and i not see any liked between tow tables?? Tag: finding child tables Tag: 85598
  - 9
    - Closing Connections using ODP .NET hi I am using ODP .NET to connect to Oracle database. I have about 3000 users concurrently accessing the application. In the Code i am exclusively closing the connection and disposing the object. But sometimes, over 100 connections left unclosed and they all stay in 'INACTIVE' mode. I found this using TOAD. Why is this happening? Do i have to do something else for things to work properly? Please give me suggestions. Thanks -Imayakuma Tag: finding child tables Tag: 85582
  - 10
    - concurrency violation (Type your message here) -------------------------------- From: Adam Sim Hello, I am trying to update the data in an MS Access table using a Visual Basic Windows Application. The way I tried to do it has worked in the past, but now it seems to give a "concurrency violation." if either the starred lines is in the code it produces a concurrency error, if they are not it does not produce an error but, of course, the original data is not changed. I have checked my table in access and it seems that all the formats are correct. Thanks for your help Adam Here is the code: Note: selid is a public variable for the case number of the record being worked upon Sub save_art() Dim strConnect As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _ & "C:\Documents and Settings\Owner\My Documents\Visual Studio Projects\mpqgrammar.mdb" Dim cn1 As OleDbConnection = New OleDbConnection(strConnect) cn1.Open() Dim strSelectOut As String = _ "SELECT * FROM MPQFIN WHERE CASENO = " & selID Dim dsOutCmd As New OleDbDataAdapter(strSelectOut, cn1) Dim dsOutCmdBuild As OleDbCommandBuilder = New OleDbCommandBuilder(dsOutCmd) Dim dsOut As New DataSet() dsOutCmd.Fill(dsOut, "MPQFIN") dsOut.Tables(0).Rows(0).Item("Done") = 1 '************ dsOut.Tables(0).Rows(0).Item("Coder") = userName '************ dsOutCmd.Update(dsOut, "MPQFIN") cn1.Close() MessageBox.Show("Record Saved!", "Save") ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>krPqOcIILU2g4f3FH0aqzA==</Id> Tag: finding child tables Tag: 85578
  - 11
    - Column reordering in DataTable It sounds simple but I couldn't figure a way to do it. All I want to do is re-order the columns on my DataTable. For example, I like to make the second column the last column, make the third the first, etc. When trying to remove a column from the collection and then add it to back, the data inside it is lost. Do you know any simple way to do this? -------------------------------- From: Hanan Taiber ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>q6LLQcJf5E+9zelcYhLYjQ==</Id> Tag: finding child tables Tag: 85577
  - 12
    - New records not showing when using CreateChildView I have a Dataset containing Parent and Child tables=2E If I add a= new record to the Child table for an existing key, I would= expect the CreateChildView method on the Parent row's= DataRowView to return all existing child records plus the new= one=2E However, it doesn't seem to recognise the newly added= record=2E If I create a DataView which is filtered using the foreign key= expression the dataview contains the correct number of records=2E /* Add new child row */ DataRow childRow =3D childTable=2ENewRow(); childRow["brokcode"] =3D "ABED"; childRow["lgencode"] =3D "DUM=2EL"; childTable=2ERows=2EAdd(childRow); childTable=2EAcceptChanges(); /* Print Child Record Count using CreateChildView - Doesn't= include new childRow*/ DataView childView; DataRowView drv =3D childTable=2EDefaultView[0]; childView =3D drv=2ECreateChildView("broker-broker_legal_entity"); Console=2EWriteLine("CreateChildView Record Count: " += childView=2ECount); /* Print Child Record Count using DataView - Does include new= childview*/ DataView dataView =3D new= DataView(childTable,"brokcode=3D'ABED'","",DataViewRowState=2ECurren= tRows); Console=2EWriteLine("DataView Record Count: " + dataView=2ECount); Whilst I can create a DataView using a RowFilter expression I= would rather delegate that functionality to CreateChildView=2E= Does anyone know if this is a bug or is there something else I'm= missing=2E Thanks Paul Greer Barclays Global Investors ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>eQRid+xG20m1LWpdZsRUkw=3D=3D</Id> Tag: finding child tables Tag: 85576
  - 13
    - enter (Type your message here) -------------------------------- From: Huang Xin ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>iP6RNtSzdkW07pQ3z9tsFw==</Id> Tag: finding child tables Tag: 85575
  - 14
    - DataTable.LoadDataRow Below is my code: '---here create my table dim Pt_CodeTable as datatable = New DataTable("CodeTable") With Pt_CodeTable .Columns.Add("ID", GetType(Int64)) ''????? .Columns.Add("CODE", GetType(String)) ''??? .Columns.Add("NAME", GetType(String)) ''???? '.Columns.Add("SHORTNAME", GetType(String)) ''??????? .PrimaryKey = New DataColumn() {.Columns("ID"), .Columns("CODE")} Pi_ID = 37 .Rows.Add(New Object() {Pi_ID, "1", "11"}) .Rows.Add(New Object() {Pi_ID, "2", "10"}) .Rows.Add(New Object() {Pi_ID, "3", "04L"}) .Rows.Add(New Object() {Pi_ID, "4", "04"}) .Rows.Add(New Object() {Pi_ID, "5", "02L"}) .Rows.Add(New Object() {Pi_ID, "6", "05"}) .Rows.Add(New Object() {Pi_ID, "7", "15"}) .Rows.Add(New Object() {Pi_ID, "8", "20"}) End With Pt_CodeTable.AcceptChanges() '-------------------------------------------------------------------- Dim DT As DataTable = Pt_CodeTable.Clone dim LO_ROW as datarow dim LS_ITEM AS ARRAY '------------------------Create new table For Each LO_ROW In Pt_CodeTable.Rows LS_ITEM = LO_ROW.ItemArray DT.BeginLoadData() DT.LoadDataRow(LS_ITEM, False) DT.EndLoadData() Next '-----------------------modify table Pt_CodeTable.Rows(2)(2) = "AAADDDED" LS_ITEM = pt_table.Rows(2).ItemArray DT.BeginLoadData() DT.LoadDataRow(LS_ITEM, False) DT.EndLoadData() '------------------------- 'This time I will get error message, tell me:Adding the row invalidates a constraint 'IN fact, I want to modify column("name") of 3rd row(KEY: ID=37 AND CODE=3) from "04L" to "AAADDDED" 'Tell me how to fix. ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>/0M2D3b7K0GBp9q2Li58WQ==</Id> Tag: finding child tables Tag: 85574
  - 15
    - multiple tables in a single dataset (Type your message here) -------------------------------- From: Joon Park Hi I am very new to ASP=2ENET and database access=2E Ive tried= numerous times however ive beed getting a data type mismatch= error and i am so lost=2E my page is suppose to display records= from a database using dataset with multiple tables here is the= code below <%@ Import Namespace=3D"System=2EData" %> <%@ Import Namespace=3D"System=2EData=2EOleDb" %> <%@ Page Language=3D"VB" Debug=3D"true" %> <html> <SCRIPT language=3D"VB" runat=3D"server" > =09=09Dim objConnection As OleDbConnection =09=09Dim strConnection As String =09=09Dim objAdapter As OleDbDataAdapter =09=09Dim SelectCmd As String sub Page_load() =09=09Dim BID As String =09=09 =09=09strConnection =3D "Provider=3DMicrosoft=2EJet=2EOLEDB=2E4=2E0; Data= Source=3DC:\Inetpub\wwwroot\test\test=2Emdb" =09=09 =09=09BID =3D Request=2EQueryString("BID") =09=09 =09=09If Not BID =3D "" Then =09=09=09B_ID=2EValue =3D Request=2EQueryString("BID") =09=09=09GetName_Click() =09=09End IF =09End sub =09Sub GetName_Click() =09=09=09=09=09 SelectCmd =3D "SELECT B=2ENAME, ((A=2E@Pref1 * =2E6) + (A=2E@Pref2= * =2E3) + (A=2E@Pref3 * =2E1)) AS SCORE FROM SD_CUST_SURVEY AS A,= SD_CONTACT_INFO AS B WHERE (A=2EBUSINESS_ID =3D B=2EBUSINESS_ID) AND= A=2EBUSINESS_ID IN (@BID)ORDER BY ((A=2E@Pref1 * =2E6) + (A=2E@Pref2 *= =2E3) + (A=2E@Pref3 * =2E1)) DESC" =09=09 =09=09objConnection =3D New OleDbConnection(strConnection) objAdapter =3D New OleDbDataAdapter(SelectCmd,= objConnection) objAdapter=2ESelectCommand=2EParameters=2EAdd(New= OleDbParameter("@BID", OleDbType=2EChar)) objAdapter=2ESelectCommand=2EParameters("@BID")=2EValue =3D= B_ID=2EValue =09=09objAdapter=2ESelectCommand=2EParameters=2EAdd(New= OleDbParameter("@Pref1", OleDbType=2EChar)) objAdapter=2ESelectCommand=2EParameters("@Pref1")=2EValue =3D= P1=2EValue objAdapter=2ESelectCommand=2EParameters=2EAdd(New= OleDbParameter("@Pref2", OleDbType=2EChar)) objAdapter=2ESelectCommand=2EParameters("@Pref2")=2EValue =3D= P2=2EValue objAdapter=2ESelectCommand=2EParameters=2EAdd(New= OleDbParameter("@Pref3", OleDbType=2EChar)) objAdapter=2ESelectCommand=2EParameters("@Pref3")=2EValue =3D= P3=2EValue =09=09Dim DS As New DataSet() ' fill data set =09=09objAdapter=2EFill(DS, "SD_CUST_SURVEY") =09=09 =09=09' bind to data grid =09=09MyDataGrid=2EDataSource =3D= DS=2ETables("SD_CUST_SURVEY")=2EDefaultView =09=09MyDataGrid=2EDataBind() End Sub </SCRIPT> HELP! thanks ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>v91SLWEkd0iPFmLWCiI0Pg=3D=3D</Id> Tag: finding child tables Tag: 85573
  - 16
    - Data connection question In Java I would open a connection to the database on each page and close it before leaving the page for connection pooling purposes. Do I do the same with ASP.Net? Tag: finding child tables Tag: 85572
  - 17
    - drilling into filled data adapter Okay, probably another simple question for you experts. I have filled a data adapter with a dataset using a parametized query. This brings down records from a table that includes events spanning three years. I now want to further "drill" into this data adapter table to perhaps show only the records that pertain to this current year or show only those for 2005. Being fairly new with ADO, what do I have to do to "query a query"? I figure it is a matter of setting up another selectCommand, but what table do I use? Is it from the dataSet or the dataAdapter? Or how would I change the selectCommand at run-time? Thanks for the information. Brad Tag: finding child tables Tag: 85563
  - 18
    - Obtaining path for a linked Excel table Anyone know of a way with ado.net to get the path for a linked Excel table in an Access DB? The following code returns a datatable with a column Table_Type which defines whether the table is linked, and a column Table_Name that holds the worksheet name within the Excel file, but I can't find a way to get the name and path of the Excel file lcconn.Open( Dim schemaTable As DataTable = lcconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, Nothing} lcconn.Close( Return schemaTabl Any help is greatly appreciated Tag: finding child tables Tag: 85561
  - 19
    - Odd DataAdapter ? Is there a way to force a sqldataadapter to insert the contents of a dataset just filled into another table for example sqlDataAdapter1.Fill(dsLabels1); sqlDataAdapter2.Fill(dsLabels1); sqlDataAdapter1.Update(dsLabels1); sqlDataAdapter2.Update(dsLabels1); ??? I thought I could use this but none of the records are dirty after a fill and I can't do this on the database side. -- Kate Tag: finding child tables Tag: 85560
  - 20
    - Access web site database VS 2002/xp pro/win forms I want to access an Access database on my website from windows forms. Can this be done? I tried several different ways for the path but can't seem to get it, sometimes creating an error "URI not supported" I tried Dim cnString As OleDbConnection = New OleDbConnection("Provider=MicroSoft.Jet.OLEDB.4.0; Data source= http://www.mywebsite/fpdb/myfile.mdb" Dim cnString As OleDbConnection = New OleDbConnection("Provider=MicroSoft.Jet.OLEDB.4.0; Data source=" & Server.MapPath("\fpdb\Myfile.mdb")) Dim cnString As OleDbConnection = New OleDbConnection("Provider=MicroSoft.Jet.OLEDB.4.0; Data source= //www.mywebsite/fpdb/myfile.mdb" None seem to work. this is the error message I'm getting from adtp.SelectCommand.Connection.Open() An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll Thanks Tag: finding child tables Tag: 85555
  - 21
    - Error In Update Procedure I am able to get this section of code to properly open an Access database and fill the dataset from a table within it. Then after editing certain values in the dataset attempt to update I get an unhandled exception. After trapping the code in a try it returns "Syntax Error in UPDATE Statement" however I have tried all documents and syntax appears correct. I've verified that I am not using any reserved words for column names in the Access database. This problem is quite frustrating. Any help is appreciated. Here is my code ----------------------------- Dim strConnect1 As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "E:\Microsoft Visual Studio .NET\Projects\GrammarMachine\mpqgrammar.mdb Dim cn1 As OleDbConnection = New OleDbConnection(strConnect1 cn1.Open( Dim strSelectOut1 As String = "SELECT * FROM MPQFIN WHERE CASENO = " & selI Dim dsOutCmd As New OleDbDataAdapter(strSelectOut1, cn1 Dim dsOutCmdBuild As OleDbCommandBuilder = New OleDbCommandBuilder(dsOutCmd Dim dsOut As New DataSet( dsOutCmd.Fill(dsOut, "MPQFIN" dsOut.Tables(0).Rows(0).Item("Done") = dsOut.Tables(0).Rows(0).Item("Coder") = userNam dsOut.Tables(0).Rows(0).Item("ACTOR") = RTBSpon.Tex dsOut.Tables(0).Rows(0).Item("ACTION") = RTBAct.Tex dsOut.Tables(0).Rows(0).Item("CONSEQ") = RTBCon.Tex dsOut.Tables(0).Rows(0).Item("BACK") = RTBBack.Tex dsOut.Tables(0).Rows(0).Item("DEFINE") = RTBDef.Tex Tr dsOutCmd.Update(dsOut, "MPQFIN" Catch Ex As Exceptio Console.WriteLine("Error: " & Ex.Message MsgBox("Error: " & Ex.Message End Try Tag: finding child tables Tag: 85554
  - 22
    - why need uniq key on master in relation? why need uniq key on master in relation? (it seem like stupid thing. again and again microsoft going revese) take look in access, when you need to write Master-detail, make subform, and link it parant-child, and not need any key on master! take look in VB6 with DataEnvironment, make it easy without any uniq in master. why is need? who care, if on master have many record, that linked to same record? have sombody to explain as why microsoft make this? Tag: finding child tables Tag: 85546
  - 23
    - [ANN] Gentle.NET 1.0.2 Gentle is an open-source object persistence framework featuring a database-independent SQL factory, automatic SQL generation and object construction, a list class for managing 1:n and n:m relations, concurrency control, result set paging, soft deletions, DataView construction helpers, and reasonably complete documentation. It currently supports Oracle, PostgreSQL, MySQL, Firebird/InterBase, MS SQL Server, MS Access/Jet, and SQLite. Metadata is automatically extracted from most databases, minimizing the amount of configuration required to get started. It includes a NAnt build file, VS.NET project files for building under Windows, and a Makefile for compiling with Mono (still has some incompatibilities). This release adds support for the OracleODP provider. New features include support for paging result sets, optional dynamic tablename associations, and the ability to soft delete (mark) objects. This release also contains a number of minor enhancements and several bugfixes. For more information please visit http://sf.net/projects/gopf Yours, Morten Tag: finding child tables Tag: 85543
  - 24
    - What Is The Best Way To Get A RecordSet ? Hi , i m using the SqlDataReader In order to get a recordset from the SQL . i don't want to work with data set since my web site have lots of traffic . what is the best way to get recordset ? how can i get the number of records ? Best Regards , Tiraman :-) Tag: finding child tables Tag: 85533
  - 25
    - Unofficial SxS poll Hello group, I am trying to get a rough idea of how many people are using Side By Side installations of .net and how it is being used. This is just an unofficial poll but I would like to encourage your participation so that we can ship a better product as we keep coming out with new releases. POLL, please choose the option that more closely describes you: 1) I do not trust side by side installations of .net and do not plan have multiple Visual Studios/frameworks installed. 2) I have installed Visual Studio and/or Visual Studio 2003 and plan to install whidbey Visual Studio on my main machine. 3) I have installed Visual Studio and/or Visual Studio 2003 and plan to install whidbey Visual Studio on my main machine for testing only. I will remove Whidbey when I am done. 4) I plan to install Whidbey when it comes out and uninstall all previous versions if everything works ok. Thank you -- Angel Saenz-Badillos [MS] Managed Providers This posting is provided "AS IS", with no warranties, and confers no rights.Please do not send email directly to this alias. This alias is for newsgroup purposes only. Tag: finding child tables Tag: 85532

Oracle.
1)how to find all the the existing chaild tables of a master table?

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>uQ+Pk5MDTU2Wcrlfzf3Buw==</Id>

Top

Re: finding child tables by Miha

Miha
Mon Apr 26 03:57:04 CDT 2004

Hi,

You might check ChildRelations property (there should be relations definied
within dataset).

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"chandu sekhar via .NET 247" <anonymous@dotnet247.com> wrote in message
news:eZ54eR1KEHA.3596@tk2msftngp13.phx.gbl...
> Oracle.
> 1)how to find all the the existing chaild tables of a master table?
>
> -----------------------
> Posted by a user from .NET 247 (http://www.dotnet247.com/)
>
> <Id>uQ+Pk5MDTU2Wcrlfzf3Buw==</Id>

Top