ForeignKeyConstraint & GetChanges

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
 - quotes into SQL query I'm writing a class that crawls through a removable media retrieving file info (who didn't make one yet?) and storing in an Access mdb. OleDbCommand fails when the file name contains quotes as in My friend's pictures.zip When building the SQL INSERT query, I tried putting \" before and after as suggested in a MS KB but it didn't work. I'm almost going to escape the entire file name a la http... Should I use stored procs and pass the file name as a parameter? Would it avoid escaping the file name? Many thanks Henrique --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.608 / Virus Database: 388 - Release Date: 3/3/2004 Tag: ForeignKeyConstraint & GetChanges Tag: 81429
 - 2
 - ANN: Data Access Objects 1.3 released (GNU LGPL) Hi all I'm pleased to announce the latest release of my Data Access Objects. The library was released under the LGPL which means that you can use it in commercial applications. At a glance: - Vendor independent relational data access layer - Automation through Persistence Containers that operate upon the data access layer - Object-relational mapping through a Visual Studio add-in (XML files) or custom attributes Visit the project site @ http://dao.sourceforge.net Regards Philipp Tag: ForeignKeyConstraint & GetChanges Tag: 81428
 - 3
 - deleting rows from a table that has a composite primary key hi all i am new to the c# language . i would like to know that how would you delete a row on the basis of its primary key in a table which has composite primary key And also tell me how would you delete rows from a table which is inter-related to the other one , i mean if u have the foreign key in the other tabel and u want to delete the row in the table which has the primary key then how wud u delete the both Is it that u have to delete in the primary key table and the foreign key table separatel Thanx in Advanc Tag: ForeignKeyConstraint & GetChanges Tag: 81427
 - 4
 - Multiple statements with one command using System.Data.OracleClient I am writing a dataaccess layer in which am building my SQL statements dynamically. Currently i am using the Oracle classes in System.Data.OracleClient but executing muliple statements does not seem to work. What i try to do is something like INSERT INTO A (.. ) VALUES (:a ); SELECT * FROM A WHERE .. = :a; INSERT INTO B ( ... ) VALUES (:a) so I have one row in my dataset and want to split this row out into multiple tables reading back the record in between to get the values that are updated using triggers. This is no problem using the SqlClient classes but the Oracle implementation does not seem to support this. It seems to be a limitation in the Microsoft implemetation. Did anyone try to get around this problem using anonymous procedures? So for instance BEGIN UPDATE A SET "a" = :a WHERE (a = :OriginalA); SELECT * FROM A WHERE (a = :OriginalA); END; results in the following error "ORA-06550: ... :PLS-00428: In this SELECT-statement an INTO-clausule must be used. ORA-06550: ... PL/SQL: SQL Statement ignored.". Does anybody have a solution for this problem? Has anyone tried using mulitple statements while making use of ODP.NET (or alternatively with the DataDirect Data Provider?) Any help would be greately appreciated. R. van Poelgeest (just remove the spaces to get my email address) @ metaobjects.net Tag: ForeignKeyConstraint & GetChanges Tag: 81416
 - 5
 - Error Creating TXT File Private Sub find_file(ByVal strFile) Dim Path As String Dim NewFile As StreamWriter strFile = "Extern\" & strFile Path = Server.MapPath(strFile) If Not File.Exists(Path ) Then NewFile = File.CreateText(Path ) NewFile .Close() End If End Sub I have this to find (and create, if not found) a file. The problem is that it's not working. It gives me an error like this: Access to the path "c:\(all path)\Extern\novo.txt" is denied I think that I have to set permissions, but where??? I already put the Read an Write Permissions for that application in IIS, and in the right path too. How can I set this up? It's missing anything? -- Thank's (if you try to help me) Hope this help you (if I try to help you) ruca Tag: ForeignKeyConstraint & GetChanges Tag: 81411
 - 6
 - Could not add to Oracle DB with dynamic SQL Hi all, I want to use dynamic SQL to add a new dataset to an existing Oracle Table. The table is 'CONTENTTYPE' and contains only 1 field named 'CONTENTTYPE' which is Char(100). When I create the SQL-String manually' (see example below, for 'boolDynamicSQL = False') everything works fine and the new value is added. But when I try to use Dynamic SQL it always returns an error: ORA-01036: Variablenname/-nummer ungültig (= ORA-01036: Variable name /-number invalid) I could not find any typing error, and the manual SQL-String works fine :-( I've searched lots of internet sites but without access. Also my 'ASP.NET Codebook' states it should be working this way... Anyone any ideas? Could this be caused by single / double quotes? I did not find a setting in Visual Studio.NET to define which quotes .NET should use for the dynamic SQL. But when I replace the single quotes in the manual SQL string with double quotes, it returns 'ORA-00984: column not allowed here ', so not exactly the same error message. (By the way, one time error message is english, and in other case it's german. Might this be a hint?) Thanks in advance!! Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click REM First check whether Application name is entered Dim cnnORA As OracleConnection Dim comORA As OracleCommand Dim DR As DataRow Dim dtContentType As DataTable Dim ds As DataSet Dim sqlCommand As String Dim sqlInsertCommand As String Dim boolDynamicSQL As Boolean Dim da As OracleDataAdapter Dim boolUpdate As Boolean 'Added for checking Dynamic SQL boolDynamicSQL = True If txtContentType.Text = "" Then boolUpdate = False ASPNET_MsgBox("You have to enter a Content Type!") Else REM Check whether this application name already exists cnnORA = New OracleConnection(Oracle_Connection_String) cnnORA.Open() comORA = New OracleCommand comORA.Connection = cnnORA ds = New DataSet sqlCommand = "SELECT CONTENTTYPE FROM CONTENTTYPE" comORA.CommandText = sqlCommand da = New OracleDataAdapter(sqlCommand, cnnORA) da.Fill(ds, "CONTENTTYPE") dtContentType = ds.Tables("CONTENTTYPE") boolUpdate = True For Each DR In dtContentType.Rows If txtContentType.Text.ToUpper = _ (Convert.ToString(DR.Item("CONTENTTYPE")).ToUpper) Then boolUpdate = False Exit For End If Next If boolUpdate Then REM Add new data to database If boolDynamicSQL Then sqlInsertCommand = "INSERT INTO CONTENTTYPE (" & _ "CONTENTTYPE) VALUES (@CTYPE)" Else sqlInsertCommand = "INSERT INTO CONTENTTYPE (" & _ "CONTENTTYPE) VALUES (" End If Dim comInsert As New OracleCommand comInsert.Connection = cnnORA comInsert.CommandText = sqlInsertCommand DR = dtContentType.NewRow() DR("CONTENTTYPE") = txtContentType.Text For Each objColumn As DataColumn In dtContentType.Columns If boolDynamicSQL Then Dim param As New OracleParameter param.OracleType = OracleType.VarChar param.Direction = ParameterDirection.Input param.Value = "value" param.ParameterName = "@CONTENTTYPE" param.DbType = DbType.AnsiString comInsert.Parameters.Add(param) 'ORA-01036: Variablenname/-nummer ungültig Else sqlCommand = Convert.ToString(DR(objColumn.ColumnName)) sqlInsertCommand = sqlInsertCommand & _ "'" & sqlCommand & "', " 'Mit Double Quotes: 'ORA-00984: column not allowed here End If Next If Not boolDynamicSQL Then sqlInsertCommand = Left$(sqlInsertCommand, Len(sqlInsertCommand) - 2) & ")" comInsert.CommandText = sqlInsertCommand End If Try comInsert.ExecuteNonQuery() Catch ex As Exception LblResponse.Text = ex.Message End Try Else ASPNET_MsgBox("ContentType already exists. Please choose another name " & _ "or update existing data.") End If End If cnnORA.Close() End Sub Tag: ForeignKeyConstraint & GetChanges Tag: 81410
 - 7
 - AS400 invalid token Ji, i've a simple but strange problem. I must connect to an AS400 from a window form in C#. I use the Data Access of IBM as OLE DB driver and it works good but not with a library calle Â§DATAACCOUNT. The error sais "Token error" . Could someone tell me how coding the character 'Â§' to send it to AS400 ? Thanks in advance Tag: ForeignKeyConstraint & GetChanges Tag: 81406
 - 8
 - How do I query a dataset? Hello, I get how to populate a dataset by querying a database server... but once I've populated my dataset, say with several related tables, how can I then select records from the dataset copy of data using SQL statements instead of the database server itself? In some cases I'd say this is preferable to hitting the database server everytime a subset of data needs to be retrieved. Only suitable for small amounts of static data of course. As an example if I have a populated table of employee data in a dataset and I want to populate a temp table with only those records where employee age > 60..... am I limited to filters or can I use SQL statements (which would then mean no extra code if I decided to point back at the database server instead of the dataset itself)....? Hope this makes sense to you guys... cheers Tag: ForeignKeyConstraint & GetChanges Tag: 81390
 - 9
 - INSERT a datetime using convert Hallo I have an SQLCE database into which I want to insert a datetim INSERT INTO ADR_ADDRESS (Last_Edited) VALUES ( Convert('01-FEB-2004 11:12:22','dd-mon-yyyy hh:mi:si') The table was defined wit CREATE TABLE ADR_ADDRESS ( Address_ID integer Primary Key NOT NULL ,Last_Edited datetime Unfortunately this does not work, can anyone see what is wrong Thanks.. Nigel.. Tag: ForeignKeyConstraint & GetChanges Tag: 81388
 - 10
 - DataSet.Update on related tables. Hi all. Could anyone help me with the following "common" chalenge? I have 2 simple tables. Customers and Zipcodes. Customer: CustomerID, CustomerNr, CustomerName, ZipID ZipCodes: ZipID, ZipCode, ZipText I use the ZipID in the Customer table so if it changes I can change it for all Customers with that ID. Everey time I show this data in a grid I JOIN to the ZipID and shows the ZipCode to the users. That works OK. What I want to do i to use a dataset connected to a datagrid where the user kan massupdate zipcodes. As you know the user don't know the ZipID that I need to update the customer field with. He just want to change the ZipCode on all the customers and push Update. I need to find the corresponding ZipID and fill that into the corresponding Customer. Is there anyway this can be incorporated into the dataset so I don't have to check and test and lookup ZipID's. Mabe with some hidden columns or something. Short Version: When the user changes ZipCode in the datagrid I want to save the corresponding ZipID on that Customer. I would thing this scenario is rather common but.... I uses stored prosedures to fill and update all data in the database so I guess I could handle it there based on the ZipCode, but if there are anything within .NET that handles this I would like to use it. Thanks a lott all. -gh Tag: ForeignKeyConstraint & GetChanges Tag: 81386
 - 11
 - Dataset From Textfile question I have created at Dataset from an OleDB connected text file using schema.ini and so forth, so far no problem, now what I need to do is take the data from that dataset and update records in another database, (SQL Server) which has a table that contains the same key as I used in the text file. I have been able to walk through the first dataset and issue update commands to the other database one at a time, but I can't help feeling there has to be an easier way to do this. I am trying to avoid walking through either the file with file IO commands or the dataset one row at a time in favor of a batch operation. The data in the text file will always be used to update records that exist in the target SQL Server database, never to insert a new row. Any suggestions? I am writing this as a Winforms app in VB.Net with 1.1 Framework. Thanks in advance. Bob Porter Tag: ForeignKeyConstraint & GetChanges Tag: 81382
 - 12
 - Oracle stored procedure with db link doesn't work from C#? Hi I am calling an Oracle stored procedure which has no input or output parameters, and only does an insert to a table on a remote Oracle server, like this PROCEDURE Joe_test I BEGI insert into leslie@acc_db2 values ('insert') commit END When I call it from C# using System.Data.OracleClient, I get the exception ORA-02041: client database did not begin a transactio ORA-06512: at "OPS$JOE.JOE_TEST", line ORA-06512: at line If I change it to insert into a local table instead of a remote one, it works. If I run it as is from SQL/Plus, it works. It only fails when I run it from .NET with System.Data.OracleCommand.ExecuteNonQuery() I have tried using "enlist=false" in the database connect string. This actually seems to solve the problem if I use ODP instead of System.Data.OracleClient, but has no effect with the latter. I don't have a good understanding of what it does other than changing the default handling of distributed transactions. System.Data.OracleClient is supposed to handle distributed transactions I would appreciate any help or suggestions! Tag: ForeignKeyConstraint & GetChanges Tag: 81376
 - 13
 - Act! connection I am only able to connect to an Act6.0 db with ODBC Connection (Foxpro DSN). Is there a better way? Tag: ForeignKeyConstraint & GetChanges Tag: 81374
 - 14
 - paging with related records I'm trying to implement paging in a windows form application on about 50 thousand records the problem is I have related records, which is another 20 thousand. I've searched with google and only found paging but with none related data. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconpagingthroughqueryresult.asp Right now I can only think of one solution where I populate the related data by hitting the database after loading the paged data of the first table? Any other ideas? Tag: ForeignKeyConstraint & GetChanges Tag: 81373
 - 15
 - DataAdapter.Update - batch or round trips? Hi - I've seen several clues to this but I wonder if any experts can definitively confirm ...... Does the DataAdapter.Update method pass all updated datarows to the database for some kind of batch process with multiple calls to the update command but only one open and close of the connection, or does it do multiple round trips to the database and multiple connection open/closes, one for each updated datarow? (My specific interest is in the OracleDataAdapter but I'm guessing the answer applies to all DB providers). Thanks for any responses. Tag: ForeignKeyConstraint & GetChanges Tag: 81367
 - 16
 - Update query not working Hi I have wrote a stored proc (Sproc) to update one of my sqlserver tables. This is what the query looks like ALTER PROCEDURE dbo.UpdMea (@NewName nvarchar(50) @NewCost Money @MealType varchar(50) AS UPDATE dbo.Men SET Meal_Type = @NewName, Meal_Cost = @NewCos WHERE (Meal_Type = @MealType I have a combobox that contains a list of meals. When the value is changed a sproc is fired aginst my DB that retrieve the Meal Name and Price based on what is selected in the combobox. The results of this query are then binded to 2 textboxes. The user can then update the values in the textboxes and click the Save button to propogate the changes back to the database The problem i have is the changes do not seem to appear in my database and no message is displayed showing me a possible error. Can anyone see if i am missing anything in the onclick event code for my save button..... If MsgBox("Are you sure you want to save your updates?", MsgBoxStyle.OKCancel Or MsgBoxStyle.Question, "Save?") = MsgBoxResult.OK The Dim cmdUpdMeal As New SqlCommand("UpdMeal", Conn cmdUpdMeal.CommandType = CommandType.StoredProcedur cmdUpdMeal.Parameters.Add("@NewName", TextBox1.Text cmdUpdMeal.Parameters.Add("@NewCost", Convert.ToDecimal(TextBox2.Text) cmdUpdMeal.Parameters.Add("@MealType", CBoxEditMealName.SelectedText.ToString Tr Conn.Open( cmdUpdMeal.ExecuteNonQuery( Catch x As Exceptio MsgBox(x.Message Finall Conn.Close( End Tr End If Tag: ForeignKeyConstraint & GetChanges Tag: 81364
 - 17
 - Help - System.Data.DataTable.InsertRow() throws ArgumentOutOfRangeException I have a C# program that works one time and fails the next on my deployment test system. It does not fail on my development system. The deployment uses the installation procedure created by Visual Studio 2003. The deployment is installing the .NET Framework ver 1.1, MSDE 2000, MDAC 2.7, and my application. I am assuming (bad thing to do) that the install is working, because the application works every so often. In all cases I am adding a records to a database. In both instances it is to an empty database and the data being added is the same. When the windows program fails the error is always an ArgumentOutOfRangeException on the same row add. The output from my try-catch code is: ArgumentOutOfRangeException: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos) at System.Data.DataRowCollection.Add(DataRow row) at WinMCDB.gdsrvmntDataTable.AddgdsrvmntRow(gdsrvmntRow row) at MCLoader.Form1.AddGdsrvmnt(String monumnt_id, Int32 date_adj, Double latitude, Double longitude, Double adj_elev, Double geoid_ht, Double ellips_ht, String localCoordinateSystem) ParamName: index, Value: null Does anybody know why the System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos) method index is null? Or how I can debug this issue with a System.Data.DataTable method InsertRow. Jim Tag: ForeignKeyConstraint & GetChanges Tag: 81363
 - 18
 - Multiple Database Datasets Help I have a case where I am creating a dataset from one database, then I want to issue a series of updates to another database to update data based on a common key between the two tables in two separate databases. eg Database1.Table1 key column2 column3 .... 1232 My Prod 1234.00 Database2.Table1 (To be updated with data from the first table, key already exists. No inserts allowed, just updates. key column2 column3 1232 null null So what is the best approach to this? Create 2 datasets, 1 dataset with a datatable object from each connection, or just brute force update statements to the second database while walking through the first dataset? I am working in VB.NET 2003 and am not very familiar with C# so any examples in VB.NET would be helpful. Tag: ForeignKeyConstraint & GetChanges Tag: 81359
 - 19
 - SqlDataAdapter Not Catching SQL Exceptions I have a SqlDataAdapter that is not picking up Sql exceptions from the SQL Server database such as foreign key constrain violations. When I call the update method of the dataadapter for either inserts or updates, it just fails silently. If I do the update directly from the SQL table the errors are being generated by the server. The ContinueUpdateOnError property for my adapter is set to false. The adapter was picking up SQL exceptions just fine earlier, so I must have changed something by accident. I have another adapter in my project that is picking up exceptions just fine, so it is not of application wide scope Does anyone have any idea what might be causing this behavior? Any help would be greatly appreciated. Tag: ForeignKeyConstraint & GetChanges Tag: 81354
 - 20
 - ID of a newly created record Hi, I'm trying to get the ID of a newly created record into a variable, so I can display it in a Label or something after being created. I know you can use @@identity in the sql statement, but I just can't seem to get it to go. Any help appreciated, Glyn Williams Here is my code:- Public Sub addBike(Sender As Object, E As EventArgs) Dim myCommand As new SqlCommand() Dim myConnection As New SqlConnection ("server=Tron;database=sellmybike;Integrated Security=SSPI") myCommand.Connection = myConnection 'Define insert command myCommand.CommandText="INSERT INTO Details (PostDate,Name,Town,County,Seller,Email,Tel,Make,Model,ManYear,Mileage,Price ,Details) VALUES ( @PostDate,@Name,@Town,@County,@Seller,@Email,@Tel,@Make,@Model,@ManYear,@Mil eage,@Price,@Details)" myCommand.Parameters.Add ("@PostDate", Now()) myCommand.Parameters.Add ("@Name", msgName.Value) myCommand.Parameters.Add ("@Town", msgTown.Value) myCommand.Parameters.Add ("@County", msgCounty.Value) myCommand.Parameters.Add ("@Seller", msgSeller.Value) myCommand.Parameters.Add ("@Email", msgEmail.Value) myCommand.Parameters.Add ("@Tel", msgTel.Value) myCommand.Parameters.Add ("@Make", msgMake.Value) myCommand.Parameters.Add ("@Model", msgModel.Value) myCommand.Parameters.Add ("@ManYear", msgManYear.Value) myCommand.Parameters.Add ("@Mileage", msgMileage.Value) myCommand.Parameters.Add ("@Price", msgPrice.Value) myCommand.Parameters.Add ("@Details", msgDetails.Value) myCommand.Connection.Open() 'update the tape myCommand.ExecuteNonQuery() 'Im sure some code must go here and in the sql statement myCommand.Connection.Close() End Sub Tag: ForeignKeyConstraint & GetChanges Tag: 81353
 - 21
 - Using a Singleton class for data services Does anyone know if implementing a Singleton design pattern class to be used as a data access component would make for a solid architecture for an enterprise-wide .NET system? I'm wondering if having a single point of entry won't become a bottle-neck and reduce performance. If anyone has any information pertaining to Singleton classes, I'd be grateful Tag: ForeignKeyConstraint & GetChanges Tag: 81351
 - 22
 - Data Relations and Ill pay someone now Hey All, I`ll Pay someone to tell me this now, as its doing my head in, I carn`t see out on the net and no one seems to know! I have a form that connects to a Access database, and I have a combo box on this form (this combo box has a list of Access Levels, a user would be able to choose one Access Level out of the combo box). The combo box is serving double duty, as they usually do, it is giving me a list of all of the Access Levels in a drop down, and it is also returning the Access Level of the record that I am retrieving from my Access Database. Everything works perfectly, but. . . When I navigate through my records, the combo box (Access Level) does not change with what the Access Level should be for that particular record, it's almost like it sticks on the same Access Level. The AccessLevelID (different text box) changes with every record but the combo box doesn't. I did some troubleshooting. . . If I put a text box in place of the combo box it works correctly, but this does not solve the problem of the user being able to select a Access Level, hence the need for a combo box. I`ver tryed to explain this before but unforutnatle i don`t think im explaining properly, i have a example project that I could e-mail if anybody could offer me some help? Any links as I don`t mind reading Please help. Thanks. Merlin Tag: ForeignKeyConstraint & GetChanges Tag: 81345
 - 23
 - DataSet vs XML storage Hi everyone, I've heard some (I think wierd) ideas that it is much faster to use XmlDocument then DataSet for storing and updateing data from database. The idea is to use XmlDocument to store data, make add/update/delete operations on it, keep track of changes and finally make changes into database. It assumes that one have to write all methods that will perform these actions on XmlDocument that will act as DataSet. Does anyone has experience with this and what are real performace issues on this? PV Tag: ForeignKeyConstraint & GetChanges Tag: 81341
 - 24
 - Design Forms!!! Hi I'm designing a Webs Forms in VS .NET and when I put any control it adds on form various tables, witch makes a lot of confusion on my code. How can I disable this thing and design as well as I want. I know that tables are very useful to design (I use them too for that), but I think that the code stays very confused with "automatic" design (with drag and drop). Any sugestions?????? -- Thank's (if you try to help me) Hope this help you (if I try to help you) ruca Tag: ForeignKeyConstraint & GetChanges Tag: 81338
 - 25
 - InsertCommand Parameter for columns whith null values Hello folks, CommandBuilder is doing the insert command for inserting into a SQL-server table. In that table there are columns where null values are not allowed however there is a default value specified. Now I want this default value to be applied. Therefore I left the value in the application side table as null, but I get the error "Cannot insert the value NULL into column 'MaxMZr', table 'Proto.dbo.Angebot'; column does not allow nulls. INSERT fails." So, how can I change the Parameters in the insert command to ignore the fact that no null values are allowed in that column Thanks Anton PS: Just not mentioning the column in the select command given to the command builder does not work because the column should not always be filled with the default values Tag: ForeignKeyConstraint & GetChanges Tag: 81337
- Next
 - 1
 - Passing a rowset to a stored procedure? Hi. I have a situation where I would like to check to see if a number of records have been updated in a table. My application store the primary key and the timestamp values internally, and could for example pick out 5 of these and would then need to check if the original records have been updated. I could of course easily create a stored procedure that takes the primary key as parameter and then makes a single select and returns the value. But I would have to call that 5 times meaning 5 times the overhead. Can I create a stored procedure that accepts a rowset, and then pass the rowset with 5 records as a parameter to the stored procedure? And if I can create such a stored procedure, how do I build the rowset in my code and pass it to the stored procedure? Thanks in advance, Pete Tag: ForeignKeyConstraint & GetChanges Tag: 81335
 - 2
 - connection pool weirdness Hi I'm using a data reader and Microsoft's 'data access application block' SqlHelper class. CommandBehaviour.CloseConnection is being used so theoretically the connection should close when closing the reader. However I'm getting "timeout period elapsed prior to obtaining a connection from the pool" The really weird thing is that SQL Server's Management > Current Activity > Process Info say that things are peachy and Performance Monitor reports no abnormal connection activity. And yet time and time, after 90 or so reader executions the error occurs and only goes after restarting IIS - only to return after another 90 or so calls. Using Framework 1.1 and SQL Server developer edition with SP3. Any one got any ideas? Tag: ForeignKeyConstraint & GetChanges Tag: 81324
 - 3
 - Cancelling Row deletion in DataGrid (forms NOT ASP.NET) Hi Gurus, This has been doing my head in so I've come the you guys. I have 2 DataGrids using a DataViewManager to source their data. They are linked via a DataRelation which basically creates a Parent-Child relation between the 2 grids. Now I would like to prevent the deletion of any parent row that has child rows. I have gone down the route of using a 'ForeinKeyConstraint'. (For all the good that did.) Any I set the DeleteRule to 'None' to stop said deletion. However, I kept on getting an 'untrappable' exception (InvalidConstraintException) that always brought everything down whenever a parent row is deleted. OK plan B. Forget the use of constraints. Let's do it manually. So i set up a RowDeleted event (This does not run on the RowDeleting event.) on the underlying DataTable of the parent grid and try "e.Row.RejectChanges()" from there and it seems to work except one problem. The DataGrid is not showing the 'undeleted' (or rejected) row so I need to force the refreshing of the 'CurrencyManager' as in //(tgtGrid = TargetDataGrid) CurrencyManager currMgr = (CurrencyManager)this.BindingContext[tgtGrid.DataSource, tgtGrid.DataMember]; currMgr.Refresh(); When run from a 'Refresh' button all rows are displayed. However, I want the 'Grid Refresh' done 'automagically' when the row delete is aborted in code. Any Ideas people? I can't really dedicate more time to finishing the module until I know there is light at the end of this tunnel ;-) -- I AM MORTOS!!!! (Switch spammer with blueyonder) Tag: ForeignKeyConstraint & GetChanges Tag: 81321
 - 4
 - Finding all tables from schema information Hi there! Can anyone please answer the following question? I'm trying to get a list of tables, which has to work for different databases. A user chooses a database, and then this list is showed. This works. My problem is that in case of an Access-database all tables are showed (because the second restriction argument is set to nothing), and in case of Oracle i just want to show the tables that are available to the user, and NOT all tables. Private Sub GetAllTableNames() Dim conn As OleDbConnection conn = New OleDbConnection(gstrNSConn) conn.ConnectionString = gstrNSConn conn.Open() 'MS Access dtColumns = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"}) 'Oracle 'dtColumns = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object(){Nothing, mstrUserID, Nothing, "TABLE"}) End Sub Can anyone tell me how to solve this generically (some form of detection?) Thanks in advance!! Max Tag: ForeignKeyConstraint & GetChanges Tag: 81317
 - 5
 - newbie question about datasets I'm sure this is a simple question but i haven't been able to figure it out .... I load an XML file to a datatable and I want to select on multiple criteria .... I have figured out how to select on a single criteria, but not multiples. I want to do something likethis SQL statement: Select * from datatable1 where id = '1' and customername = 'Jones' and state = 'AZ' and active = '1'. Is there any way to do this with a datatable in C#? Thanks Tag: ForeignKeyConstraint & GetChanges Tag: 81314
 - 6
 - Frames in WebForms? Hi gurus, Can I have Frames in WebForms? How can I use them? -- Thank's (if you try to help me) Hope this help you (if I try to help you) ruca Tag: ForeignKeyConstraint & GetChanges Tag: 81313
 - 7
 - Null value from dataset I have one dataset populated with data When I am using GetXML() method of this dataset, I am getting the XML representation o the data. But, if a database field has Null value, then that node is not occuring in th XML string How to get that node in XML? (I don't want to use ISNULL in SELECT query while populating dataset.) Tag: ForeignKeyConstraint & GetChanges Tag: 81312
 - 8
 - Filtering table Hello. I have a DataTable variable dt and I want to create another instance of DataTable class - dt2, that will contain: 1. only the rows from dt that meet a criteria strCriteria 2. only the columns from the list of columns columns[]/columns() I don't want to return DataView or DataRow[]/DataRow(), but DataTable object. Any advice about this is very appreciated. Thanks in advance. - Predrag. Tag: ForeignKeyConstraint & GetChanges Tag: 81305
 - 9
 - Unexpected sorting while executing Table.Select() Hi All! I have Table sorted by second ("name") field. When I apply filter: DataRow[] newCopy = request[i].Table.Select(request[i].Filter); I got DataRow List sorted by first ("id") field. But I need no reorder Rows Can somebody help? Thank you, Vitaly Sedov Tag: ForeignKeyConstraint & GetChanges Tag: 81304
 - 10
 - Problems with cascade update in relationship I've got two tables in my DataSet, let's say Customer and Orde Each table has a column with a primary key, with autoincrement set to tru The second table has a foreign key relationship with the first one, with update and delete set to cascade My problem is that this cascade update doesn't seem to work properly when I call the update method of the dataadapter of the first table (in example, while adding a row), at the end of it I get a foreign key costraint exception, like if my dataset was not automatically able to update the datarelation's child column. Both the parent table and the child table rows have a rowstate set to added The strange thing is that in my DataSet I've got other tables with the same property and everything seems to work correctly in other cases What can I do to deal with this problem? Tag: ForeignKeyConstraint & GetChanges Tag: 81302
 - 11
 - DataRelations Hey All, I have a form that connects to a Access database, and I have a combo box on this form (this combo box has a list of Access Levels, a user would be able to choose one Access Level out of the combo box). The combo box is serving double duty, as they usually do, it is giving me a list of all of the Access Levels in a drop down, and it is also returning the Access Level of the record that I am retrieving from my Access Database. Everything works perfectly, but. . . When I navigate through my records, the combo box (Access Level) does not change with what the Access Level should be for that particular record, it's almost like it sticks on the same Access Level. The AccessLevelID (different text box) changes with every record but the combo box doesn't. I did some troubleshooting. . . If I put a text box in place of the combo box it works correctly, but this does not solve the problem of the user being able to select a Access Level, hence the need for a combo box. I`ver tryed to explain this before but unforutnatle i don`t think im explaining properly, i have a example project that I could e-mail if anybody could offer me some help? Any links as I don`t mind reading Please help. Thanks. Merlin Tag: ForeignKeyConstraint & GetChanges Tag: 81301
 - 12
 - Urgent: ActiveX and Java Script Problem Hi, I have two problems in my page. I developed a web application in one computer (my personal) and then I have to copy it to another PC, but happens that one of the pages have two problems in this computer: 1 - I have a javascript run time clock, and the clock do not appear in the page (it shows a blank space) 2 - I have ActiveX controls (in the case are two Data Pickers) and this control don't appears too (in this case appears like I have an image that isn't in speciefied path) How can I resolve this? -- Thank's (if you try to help me) Hope this help you (if I try to help you) ruca Tag: ForeignKeyConstraint & GetChanges Tag: 81300
 - 13
 - System.InvalidOperationException Hi; After LastDay I have error under the error. I search on Internet smilar problem ? I change my connection string is this true ? What are you opinion this problem ? <add key="AKare.DataAccess.ConnectionString" value="server=11.1.1.1.; User ID=sa;Password=;database=a; min pool size=1; max pool size=100;pooling=false"/> Yorumunuz nedir ? 01.03.2004 15:46:49: 1) Exception Information ********************************************* Exception Type: System.InvalidOperationException Message: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. TargetSite: System.Data.SqlClient.SqlInternalConnection GetPooledConnection (System.Data.SqlClient.SqlConnectionString, Boolean ByRef) HelpLink: NULL Source: System.Data StackTrace Information ********************************************* at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCon nection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset (String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset (String connectionString, String spName, Object[] parameterValues) at akare.Components.dacCampaign.get_campaing_items(Int32 CampaignID) at akare.Administration.EditCampaign.dg_ItemCommand(Object source, DataGridCommandEventArgs e) at System.Web.UI.WebControls.DataGrid.OnItemCommand (DataGridCommandEventArgs e) at System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.DataGridItem.OnBubbleEvent (Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.Button.OnCommand (CommandEventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEve ntHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent (IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent (NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain() Tag: ForeignKeyConstraint & GetChanges Tag: 81299
 - 14
 - Manually writing updatecommands for the data adapter This is a multi-part message in MIME format. ------=_NextPart_000_00D5_01C40042.3C5A5110 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have a datagrid in a winform that lets users input "detail lines" of = an order form. I manually create both the dataset and the datagrid (ie: = to have dropdownboxes etc) - but because of this the sqlCommandBuilder = seems to be unable to create the update and insert commands - so I have = to make them manually. This is what I have thusfar, but my problem is that it only updates the = first row that got changed with the new value.. So if I update one row, = it seems to work, but I'm unable to update multiple lines at once. Any = idea's? Or am I taking the complete wrong approach to this? ;) Dim objRow As DataRow For Each objRow In ds.Tables("Details").Rows If objRow.RowState =3D DataRowState.Modified Then Dim strUpdate As String strUpdate =3D "UPDATE Details SET Aantal =3D @Aantal where = Detailnr =3D @Detailnr" da.UpdateCommand =3D New SqlCommand(strUpdate, sqlConn) da.UpdateCommand.Parameters.Add(New SqlParameter("@Detailnr", = SqlDbType.Int)) da.UpdateCommand.Parameters("@Detailnr").Value =3D = objRow("Detailnr") da.UpdateCommand.Parameters.Add(New SqlParameter("@Aantal", = SqlDbType.Int)) da.UpdateCommand.Parameters("@Aantal").Value =3D objRow("Aantal") 'Debug.WriteLine(objRow("Detailnr").ToString()) da.Update(ds, "Details") End If Next Thanks in advance for looking into this, Tim De Vogel S-Data NV ------=_NextPart_000_00D5_01C40042.3C5A5110 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV> Hi, I have a datagrid in a winform = that lets=20 users input "detail lines" of an order form.  I manually create = both the=20 dataset and the datagrid (ie: to have dropdownboxes etc) - but because = of this=20 the sqlCommandBuilder seems to be unable to create the update and insert = commands - so I have to make them manually. This is what I have = thusfar,=20 but my problem is that it only updates the first row that got changed = with the=20 new value.. So if I update one row, it seems to work, but I'm unable to = update=20 multiple lines at once.  Any idea's?  Or am I taking the = complete=20 wrong approach to this? ;) Dim objRow As DataRow   For = Each=20 objRow In ds.Tables("Details").Rows     If = objRow.RowState =3D=20 DataRowState.Modified Then       Dim = strUpdate As=20 String       strUpdate =3D "UPDATE Details = SET Aantal=20 =3D @Aantal where Detailnr =3D = @Detailnr"      =20 da.UpdateCommand =3D New SqlCommand(strUpdate,=20 sqlConn)       = da.UpdateCommand.Parameters.Add(New=20 SqlParameter("@Detailnr", = SqlDbType.Int))      =20 da.UpdateCommand.Parameters("@Detailnr").Value =3D=20 objRow("Detailnr")      =20 da.UpdateCommand.Parameters.Add(New SqlParameter("@Aantal",=20 SqlDbType.Int))      =20 da.UpdateCommand.Parameters("@Aantal").Value =3D=20 objRow("Aantal")      =20 'Debug.WriteLine(objRow("Detailnr").ToString())    &nbs= p; =20 da.Update(ds, "Details")     End If  =20 Next Thanks in advance for looking into this, Tim De = Vogel S-Data=20 NV</DIV></BODY></HTML> ------=_NextPart_000_00D5_01C40042.3C5A5110-- Tag: ForeignKeyConstraint & GetChanges Tag: 81298
 - 15
 - Querying more than two tables with OleDbDataAdapter Hello, When I make a query on more than two tables, using the wizzard of a OleDbDataAdapter, then things go's wrong. Using this query, an error message will be generated. It says that in the SQL code an operator is missing. But the SQL code itself is generated by the wizzard! When I give the SQL code myself by using: OleDbDataAdapter1.SelectCommand.CommandText= "SELECT <fieldlist> FROM <tablelist> ... JOIN RELATIONS" then everything works good. This problem only occurs when I query more then two tables. When I query one or two tables, no erros occur. Can some one help me? Pieter Brouwer (the Netherlands) Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: ForeignKeyConstraint & GetChanges Tag: 81296
 - 16
 - Please Help!How I can find out if the key pressed is the "ENTER" Key I am using VC++ How I can find out if the key pressed is "Enter" key Thanx in advanc Tag: ForeignKeyConstraint & GetChanges Tag: 81295
 - 17
 - How to make a view like this ? Hello! I'm wondering how to do something like this. In database is for example 'QualityClasses'-table containing columns (fields) 'ID' which is primary key (Data Type=int), and 'QualityClass' (Data Type=varchar). I want to make a windows form containing grid with the following view ... | Quality | Qty | | A-Class | 110 | | B-Class | 8 | | Faulty | 2 | ... in this view all 'Quality'-column qualities should be filled automatically of the 'QualityClasses'-table, and it's not possible to add new row or delete existing row - only edit quantities. When user enter quantities, only those rows containing quantities should be saved into an other table which contains fields, 'QualityID' which is related ID for Quality of the 'QualityClasses'-table (child key Data Type=int), and Qty (Data Type=int), and WorkID (Data Type=int) to specify what work is reported. View like this should be possible to retrieve containing quantities when needed. Is this possible to do using bound DataTable, DataView or something like that? -- Thanks in advance! Mika Tag: ForeignKeyConstraint & GetChanges Tag: 81292
 - 18
 - This seems slow...Why??? Hi All I'm just coming up to speed here on .NET and have a C# WinForm App that accesses a database. I've gotta form with the following code in the form_load event private void DocumentsDetail_Load(object sender, System.EventArgs e this.dsDocuments1.Clear() this.daDocuments.Fill(this.dsDocuments1.Documents_Sel) The DataAdapter is using Stored Procedures and I'm seeing dismal performance on my local development machine. To bring the form up _without_ the above code, it displays in under 1 second. Add the above code and it takes a little over 4 seconds to bring it all up with the data being displayed This particular stored procedure is simply a 'Select * from Documents'. Table only contains 3 records and should not have more than 150 records, so not worried about the star. Number of columns is around 15 or so Machine isn't latest and greatest, but certainly not a dog either Is this a typical response time and so should just get used to this, or more a pilot error? Appreciate any comments on this - this just really seems very slow to me and I'm concerned Thanks...Bo Tag: ForeignKeyConstraint & GetChanges Tag: 81282
 - 19
 - Exporting a DataSet to a new Excel file I'm writing a data acquisition program that will be acquiring data and storing it within multiple tables of a DataSet. I'd like to export this data set directly to a new excel file if possible. I'd like each table of the data set to be a new worksheet within excel. My customer doesn't know databases so they are requiring that I use excel. Any help or advice would be great Thank Jeff M Tag: ForeignKeyConstraint & GetChanges Tag: 81279
 - 20
 - C# InputOutput Parameter - Explain This Q: Why does a varchar output parameter need to be explicitly set when an int output parameter can be set implicitly? We have been successfully writing methods to return InputOutput parameters of type int using the following syntax: ... SqlConnection conn = new SqlConnection (ConnectionString); SqlCommand cmd = new SqlCommand ("sp_dothis", conn); string resultTemp; conn.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Param1", strParam1); cmd.Parameters.Add("@Param2", intParam2); cmd.Parameters.Add("@ParamOut", intParmOut); cmd.ExecuteNonQuery(); resultTemp = cmd.Parameters["@SourceResult"].Value.ToString(); conn.Close(); ... However, if the output parameter is of type varchar, the above syntax will not return a value or throw an error -- it just silently returns a null/empty value. To make a similar proc to work with a varchar value the following is required: ... SqlConnection conn = new SqlConnection (ConnectionString); SqlCommand cmd = new SqlCommand ("sp_dothis", conn); string resultTemp; conn.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Param1", strParam1); cmd.Parameters.Add("@Param2", intParam2); // Be explicit when setting the varchar output parameter. cmd.Parameters.Add("@ParamOut", SqlDbType.VarChar, 150); cmd.Parameters["@SourceResult"].Direction = ParameterDirection.InputOutput; cmd.Parameters["@SourceResult"].Value = SqlString.Null; cmd.ExecuteNonQuery(); resultTemp = cmd.Parameters["@SourceResult"].Value.ToString(); conn.Close(); ... So, why does a varchar output parameter need to be explicitly set when an int output parameter can be set implicitly? Tag: ForeignKeyConstraint & GetChanges Tag: 81275
 - 21
 - Union Tables from Different Sources Hi: I am retriving data from a Text File, Oracle and SQL. Is there any way that I can perform a Union of Three data.tables from 3 Different Datasets. Thanks Tag: ForeignKeyConstraint & GetChanges Tag: 81271
 - 22
 - sql with vb.net asp forms how would i go about retrieving the results of a database query.. i know how to open the connection and stuff.. but how would i capture the results of the query to continue using it in the code? here is the code.. thanks for any help... ------------------------------- Dim dbConnStr As String = ConfigurationSettings.AppSettings("dbconnstr") Dim dbConn As New System.Data.SqlClient.SqlConnection(dbConnStr) Dim sendquery As New SqlCommand Dim runquery As String = "select password from bcustomerca where username = '@loginuser'" Dim user As New String user = "testuserid" sendquery = New SqlCommand(runquery, dbConn) sendquery.Parameters.Add(New SqlParameter("@loginuser", SqlDbType.Char, 19)) sendquery.Parameters("@loginuser").Value = user ---------------------- many thanks for any help.. i really appreciate it. cheers bryan Tag: ForeignKeyConstraint & GetChanges Tag: 81269
 - 23
 - Odbc fails with parameters Posted this to 'ado' group earlier but getting no replies... I have a C# app that uses the base "System.Data" interfaces so it can switch between Oledb and Odbc (mostly accessing a Jet database). Everything has worked until I tried using parameters. The code below works perfectly in Oledb mode, but fails under Odbc. The Odbc error is "ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters". Is there something I missed that the Odbc Access driver needs but the Oledb driver doesn't? // create cmd and open connection byte[] data = GetData(); cmd.CommandText = "UPDATE ImageTable SET " + "fFolderInfoArray=@FIA " + "WHERE fImageId=10;"; IDbDataParameter param = cmd.CreateParameter(); param.DbType = System.Data.DbType.Binary; param.Size = data.Length; param.Value = data; param.ParameterName = "@FIA"; cmd.Parameters.Add(param); cmd.ExecuteNonQuery(); Thanks, Brad Tag: ForeignKeyConstraint & GetChanges Tag: 81260
 - 24
 - DataBinding H I am running a stored procedure on the SelectedIndexChanged event of a combobox. this stored procedure retrieves details from a database. i want to bind the results to the controls on my form but it doesnt work!! here is my cod 'Display the caravan details based on the length and the caravan model Dim cmdEditCara As New SqlCommand("SPSelCaraDetailsOnModelLength", Conn Dim da As New SqlDataAdapter(cmdEditCara Dim ds As New DataSet( 'run a command to fill the textboxes et cmdEditCara.CommandType = CommandType.StoredProcedur 'declare the parameter cmdEditCara.Parameters.Add("@CaraModel", SqlDbType.Char, 50 cmdEditCara.Parameters.Add("@Length", SqlDbType.Char, 10 'now set the value cmdEditCara.Parameters("@CaraModel").Value = CBoxEditCaraName.Tex cmdEditCara.Parameters("@Length").Value = CBoxEditCaraLength.Tex Tr Conn.Open( da.Fill(ds, "EditCara" 'display the records in the various control ds.Tables("dtCaravan_Details").Select( Me.txtTotCaraOnSite.DataBindings.Add(New Binding("Text", ds.Table ("EditCara"), "Caravan_Model") Me.txtBeds.DataBindings.Add(New Binding("Text", ds.Tables("EditCara"), "Beds") Me.txtPrice.DataBindings.Add(New Binding("Text", ds.Tables("EditCara"), "Cost") Catch ex As Exceptio MsgBox(ex.Message Finall Conn.Close( End Tr The problem im having is that i keep getting a message that states Object reference not set to an instance of an objec None of the controls display any results Does anyone know what i am doin wrong This is the first time im using the databind method so i need as much advise as poss : Also once the controls are bound to the results of the query can i update the values in them for example i want the user to be able to update the values in the textbox and then push the results back to the database using and u[pdate command. Can this be done through the use of the databinding method Tag: ForeignKeyConstraint & GetChanges Tag: 81259
 - 25
 - New col. in a dataview Hi, I have created a new col. in a dataview of type int. For the value of this col. related to the different records, I need to call a function - GetReports(m_ReportSiteKey, 'value of col["FolderKey"]); where 'value of col["FolderKey"] is the value for each row relevant to col. "FolderKey". How do I get the 'value of col["FolderKey"] ? Thanks Tag: ForeignKeyConstraint & GetChanges Tag: 81258

I've noticed that if I have an update in a child table with a
foreignKeyConstraint that the parent table related row is not brought
over when .GetChanges is called, thus breaking the
foreignKeyConstraint. A full data relation with fix the issue but
other than this scenario I will not make use of the data relation and
was wondering if there was a to get the parent row in the table before
I call get changes. I tried the ImportRow function to get the parent
row into the dataset holding changes and then running
ds.Merge(otherDS.GetChanges) but it still breaks the
ForeignKeyConstraint. Any other ideas, or is the data relation the
only way to go?

Thanks,

AJL

Top