Disabling EnforceConstraints

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
    - Filling a DataTable causing RowState to change in another table I have 2 separate DataTables in a DataSet. These tables are in no way related to one anohter with Relations. When I Fill one table, it causes a row's RowState in the other table to change from Unchanged to Modified. In the absence of editing the row! Can anyone think of ways to figure out what might be causing this? -- Michael Tag: Disabling EnforceConstraints Tag: 144234
  - 2
    - ADO.NET query execution much slower than SQL Management Studio I have a stored procedure that when called from SQL 2005 Management Studio takes less than one second to execute. The same SP, when called from .NET code takes about 13 seconds. I am using a SqlCommand object with CommandType set to StoredProcedure and I am passing arguments through the parameters collection. I have tried using a SqlDataReader and a DataAdapter to retrieve the data, but both are equally slow. From stepping thru the debugger, I know that the specific statement that takes a long time to execute is either reader.ExecuteReader() or dataAdapter.Fill(dataTable), equivalently depending on the method I tried. I did a trace in the Profiler, and got nearly identical result for either method of .NET SqlClient Data Provider. Here is an example: EventClass: RPC:Completed CPU: 13390 Reads: 559475 Writes: 0 Duration: 13496 Binary Data: (a long hex value) When I copied the TextData (SQL Statement being executed) from Profiler into SQL Management Studio, I get the following trace: EventClass: SQL:BatchCompleted CPU: 437 Reads: 9998 Writes: 0 Duration: 440 BinaryData: (empty) (Immediately prior to this there is a corresponding SQL:BatchStarting trace, with empty CPU, Reads, Writes, and Duration columns.) What could explain the orders of magnitude difference in reads and duration? Is the problem due to RPC? What about the binary data? I have tried using the overload of ExecuteReader(CommandBehavior.SingleResult) with no improvement. What can I try to improve it? Thanks, Dustin Tag: Disabling EnforceConstraints Tag: 144229
  - 3
    - Server Browser accessible from code I'm wanting to implement a tree view in C# that lists user selected servers/databases/fields/etc. I would like to be able to pull up that standard form that I see that allows someone to search for servers, then name the database, then "Test Connection", etc. Is this accessible from within run-time code? Tag: Disabling EnforceConstraints Tag: 144225
  - 4
    - load flat file into datatable Anyone, I'm looking for a way to load flat files into a datatable in vb.net (2005) My flat files are tabbed delimited files with the field names on the first row I could dump the data into a sqlserver via DTS and then query against a table, but I'd like to figure out how to go directly from flat file to datatable/dataset. Any examples out there? -- thanks in advance, georgejetson Tag: Disabling EnforceConstraints Tag: 144224
  - 5
    - Initial opening speed Hi My vb.net seems to be slow on initial loading. My clients are not impressed as they had used the ms access version of the app previously and think that the old app is faster in loading. I understand .net apps need to compile themselves before execution. Is there any way I can speed up this process or in general do anything else to speed up initial loading of the vb.net app? Thanks Regards Tag: Disabling EnforceConstraints Tag: 144221
  - 6
    - OleDB locks excel file Greetings, I use OleDB from my c# application to populate an excel sheet. I open the connection in a using clause (which automatically close the connection after exit) and the excel file is created. However, I am not able to view excel file before I exit the application. It seems that there is a lock on the excel file and that the transaction is not fully completed before application close (or sometimes when I open and close other parts of the application). Does anyone know a way to force Ole Db to release all locks on the file? connectionstring setting..? ConnectionString: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"c:\\temp\ \myExcelFile.xls\";Extended Properties=\"Excel 8.0;OLE DB Services=0;HDR=Yes;Mode = 3;\""; Tried Services 0/-4 Example code: using(OleDbConnection connection = new OleDbConnection(connectionString.ToString())) { connection.Open(); transaction = connection.BeginTransaction(IsolationLevel.ReadUncommitted); CreateInspectionSheet(inspection, connection, transaction); transaction.Commit(); // does not seem to force data written to file } transaction.Dispose(); Any help highly appreciated! -thomas Tag: Disabling EnforceConstraints Tag: 144220
  - 7
    - Populating data set on background thread Hi I have a master data set. I need to populate a copy of this data set in the background (via background thread?) and once filled to replace master data set with the newly filled dataset. Is there a code example of this that can see? Thanks Regards Tag: Disabling EnforceConstraints Tag: 144214
  - 8
    - How import data from SQL Server? What's the best way to import all the tables (w/data) from an SQL Server database (in production) to my SQL Express database (on my local dev machine)? Tag: Disabling EnforceConstraints Tag: 144211
  - 9
    - Creation of table in database based upon ado.net database Part of the application which I am building must support either Access or Sql Server Databases. The code to generate the databases via sql scripts is done. However, I have a set of tables (they will all have the same columns, but have different results since they are doing seperate calculations/modeling that is being written to each table) that need to be created based upon selections done by the user. It is easy to create an in memory table that holds this information and to clone it to hold the results of each individual model. The problem is how do I take this and create a set of tables with that structure within either of the two database types. If I can get a clue on how to take a single in memory table and to then build either an Access or Sql Server table in an already existing database, I can work out the rest. Any help would be appreciated, since I am stuck at not having any good solution for this. Tag: Disabling EnforceConstraints Tag: 144206
  - 10
    - Database access spped issue Hi I have a terrible scenario. I had an ms access front end/back end app that searched on partial strings. I have coded the app in .net (access backend) and am using the below code to search on partial strings;. daCompanyLocate.SelectCommand = selCompanyLocate selCompanyLocate.CommandText = "SELECT Company, [Company 2] as Parent, Type, Tel, [Address 1] as Address, [Post Code], Town, ID " & _ "FROM Clients " & _ "ORDER BY Company" ds.CompanyLocate.Clear() daCompanyLocate.Fill(ds.CompanyLocate) dv = New DataView(ds.CompanyLocate) dv.RowFilter = "Company like '*" & Me.txtLocate.Text & "*' OR [Parent] like '*" & Me.txtLocate.Text & "*'" grdLocate.DataSource = dv Unfortunately client is not impressed with the speed of this ado.net/vb.net version compared to the same feature in access. Could someone please advise me if I can speed this up somehow? Thanks Regards Tag: Disabling EnforceConstraints Tag: 144203
  - 11
    - re-order a dataset Hi, I have a dataset (vb.Net 1.1) that I need to go through and re-order based on the data. I'm wondering if there is a nice relatively automated way to do this, but I kind of doubt it. There is not currently a single field to use in a DataView's order by parameter. The data has two fields that decide the order, node_id and parent_id. The parent_id is the node_id of the row above. If there is no corresponding row to the parent_id then we have row 0. I've messed around a little with looping through the table and I haven't found any elegant (or even not ugly) solutions. Two options that come to mind are cloning the table and copying the rows in order, probably making multiple passes. Another would be to add an "order" column and populating that as I loop through and then use a dataview to order the rows according to that field. Anyone got any better solutions? Could I create a recursive DataRelation to do this? I'd love to hear any ideas! Thanks! Matt Tag: Disabling EnforceConstraints Tag: 144202
  - 12
    - Getting command from LINQ query I want to get a DataReader from a Linq Query so I wrote this Extension Method public static IDataReader QueryToDataReader(this System.Data.Linq.DataContext ctx, object query) { IDbCommand command = ctx.GetCommand(query as IQueryable); command.Connection = ctx.Connection; command.Connection.Open(); IDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); return reader; } Sometimes it pukes because the Query passed in is a Type System.Collections.Generic.IEnumerable<Application> not an IQueryable. Query comes back as a IEnumerable when I call a sproc that returns after a select statement, even though the return type is defined in the datacontext. If my sproc returns a TABLE object, the Query comes back as a IQueryable. I don't understand why I get IEnumerable sometimes and IQueryable others? Is their a way to get my function to work in both cases? Tag: Disabling EnforceConstraints Tag: 144192
  - 13
    - Using Access db for Membership provider Any step by steps (or web links) on how to easily use an Access db for being the membership provider? I am using VS 2008 and .net 3.5. Thanks! Tag: Disabling EnforceConstraints Tag: 144188
  - 14
    - dbml error for Access database Created a new Access mdb file. Created a Data Connection in Server explorer for it. Created a new "LINQ to SQL Class". When I try to drag/drop a table into the designer I get this error: THE SELECTED OBJECT(S) USE AN UNSUPPORTED DATA PROVIDED. Any idea why? Thanks! Tag: Disabling EnforceConstraints Tag: 144186
  - 15
    - Creating table in Access using C# Hello Group I have made an application that can create Mail Merges with Word. The application creates a WordTemplate and set the Document.MailMerge.OpenDatasource's filename to a text (tab spe.) file. Containing all fields and data to merge with. I would like to change the MailMerge.OpenDatasource's datasource to an Access database instead. In another table i have a list of fields that can be used in the mailmerge. These fields can change from time to time, and therefore i will have to change the table that i used as the MailMerge datasource table. So: I'll need to first Delete the table - easy - just Execute the SQL "DROP TABLE [tablename];" Then create the table with the columns matching my merge fields.. How can i create a new table in Access 2003 using C# and Visual Studio 2005 Kind Regards Johnny E. Jensen Tag: Disabling EnforceConstraints Tag: 144183
  - 16
    - MySQL - Error on adding a new data source Hi All! I'm working on Visual Studio 2008 Pro and when I add a new data source from a MySQL database via ODBC I get the following error: <'table'..'field'> Could not get column information for database object named 'table'..'field' Does anyone have this problem? What could I do to solve this problem? Thanks in advance! Vanessa Tag: Disabling EnforceConstraints Tag: 144181
  - 17
    - What is Delphi dotnet Dear Friends, can somebody tell me what is delphi dot net. Rgards Sridhar Tag: Disabling EnforceConstraints Tag: 144178
  - 18
    - Getchunk & Appendchunk When I used VB6 & ADO I used GetChunk & AppendChunk to get/save large image data to SQL Server. In ADO.Net that is not available but I found the below link and it describes what to use as an alternative. Looking at the code I don't see how the data in saved/retrieved in "chunks", is it done natively in ADO.Net? If not, how should I do that now? http://support.microsoft.com/kb/q309158/ Regards, Dan Tag: Disabling EnforceConstraints Tag: 144176
  - 19
    - Tables and columns name can contain accented words? In my language, Italian language, we have words with accent, for example "città" or "perchè"; can I create tables or columns in sql server with names that contain letters with the accent (i.e. "à" "è" "ì" "ò" "ù")? Is this absolutely not recommended? Or is it an acceptable practice? Thanks in advance. Best regards. Tag: Disabling EnforceConstraints Tag: 144175
  - 20
    - Encrypting config files as part of a VS build event Is it possible to create a post build event to encrypt my config file (which holds my connection strings)? The reason I would like to do this is that while we are developing I would like the developers to be able to see/modify the connection strings appropriately, but when we do a release build and deploy the application and config file to a target machine I want the config files (or at least the connection strings with the file) to be encrypted. I realize this can be achieved within the code, and then place the resulting encrypted config file under source control, but any changes to one or more connection strings would be a burden (ie. recontructing the original file, making the changes, then re-encrypting) Cheers Justin Tag: Disabling EnforceConstraints Tag: 144172
  - 21
    - Null Values eliminates the row? I have a TableAdapter linked to an SQL Server 2000 table. Some of the cells have null string values. In VS2005, I can preview the data linked by the TableAdapter in design mode, and all fields are displayed - even the ones with cells containing null values (they just show "null" in the cell). When I run my application, I create a DataTable and use an SqlDataAdapter and fill it using the TableAdapter. To search my data, I use the DataTable's Select method; however, any row that contains a null value will not show up in the DataRows that are returned. Has anyone ever encountered something like this? Why is this happening, and how do I get around it? Tag: Disabling EnforceConstraints Tag: 144167
  - 22
    - SQLOLEDB error I have a remote desktop running SQL (MSDE) connecting to an SQL 2005 server. I do insert and update commands to get the data from one to the other in a VB.NET application. All commands run w/o any issue except for one. That one command is pulling the most data from the biggest file, but other than that it is of the same format as other commands that are working. When I run the command (it is inserting data onto the laptop from the server for data that doesn't exist on the laptop), I receive: Index #0 Message: The operation could not be performed because the OLD DB provider 'SQLOLEDB' was unable to begin a distributed transaction. LineNumber: 2 Source: .Net SqlClient Data Provider But, other commands on the same types of tables (both have identity columns as the key), the insert works fine. I have checked everything, and it is only this table causing an issue. Could this error occur because of a timeout? Darin *** Sent via Developersdex http://www.developersdex.com *** Tag: Disabling EnforceConstraints Tag: 144166
  - 23
    - deleting rows with SQLCommandBuilder I have a task in an ASP.Net page that I think ought to work, but doesn't. It's fairly straightforward. It's an event scheduling site, and I want a user to be able to delete an event. When he clicks the delete button, it posts back to the page with the event id for the deleted event in the query page, and then tries to delete the rwo with an SQLCommandBuilder object. The code looks like this: string qstring = "Select * from Schedule WHERE EventNumber = " + Request.QueryString["EventID"]; System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(qstring, MyConnectionString); System.Data.DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count == 1)//Verify that it returned exactly one row. { DataRow dr = ds.Tables[0].Rows[0];//Select the only row. System.Data.SqlClient.SqlCommandBuilder bldr = new System.Data.SqlClient.SqlCommandBuilder(da); ds.Tables[0].Rows.Remove(dr);//Remove it da.Update(ds);//Update the data set. Response.Redirect("~/allevents.aspx"); } I can verify that the correct dataset is being loaded. It has one table, and that one table has one row. When I call "remove", I can verify that the row leaves the dataset, so that ds now has one table with zero rows. I call Update, and I expect to delete the row from the database, but it doesn't. How do I use the CommandBuilder object to do the delete? Tag: Disabling EnforceConstraints Tag: 144161
  - 24
    - DataRow problem please help Guys, I have declared 2 dataRows and assigned New daraRows as below. Dim aRow as DataRow aRow = OutFormat.DataSet.Tables("demotbl").NewRow '*** Point 1 ---- ---- Dim bRow as DataRow bRow = OutFormat.DataSet.Tables("demotbl").NewRow '***Point 2 --- --- bRow = OutFormat.DataSet.Tables("demotbl").NewRow 'No. '*** Point 3 --- --- Point 1: I have created aRow and assigned some fields to its columns. Point 2:Then I created bRow and assigned some fields (In the debug mode I can see aRow is still active). Point 3:Then I created again bRow and this time It has erased all the contents of aRow. How would that possible? I have not changed anything aRow. Please help. Tag: Disabling EnforceConstraints Tag: 144156
  - 25
    - Targeting for fw 2.0 Hi I have upgraded a vs2003 app into vs2008. How can I tell vs2008 to target this app for framework 2.0 instead of 3.5? I can't seem to find this option anywhere. Thanks Regards Tag: Disabling EnforceConstraints Tag: 144148
- Next
  - 1
    - setup/deployment is SLOW I've got a VB.net app that I'm loading up to a SSVR 2005 server. It was created in Visual Studio 2008, calling upon 3.5 framework. I created a setup file with the deployment wizard, and am trying to install it on the server. This thing is SLOOOOOOOOOOOOWWWWWWW. It's been a couple of hours now, and the 456kb MSI file is only half loaded. Man, what's up? Tag: Disabling EnforceConstraints Tag: 144147
  - 2
    - DataRow Issue Pls help Guys, I have declared 2 dataRows and assigned New daraRows as below. Dim aRow as DataRow aRow = OutFormat.DataSet.Tables("demotbl").NewRow '*** Point 1 ---- ---- Dim bRow as DataRow bRow = OutFormat.DataSet.Tables("demotbl").NewRow '***Point 2 --- --- bRow = OutFormat.DataSet.Tables("demotbl").NewRow 'No. '*** Point 3 --- --- Point 1: I have created aRow and assigned some fields to its columns. Point 2:Then I created bRow and assigned some fields (In the debug mode I can see aRow is still active). Point 3:Then I created again bRow and this time It has erased all the contents of aRow. How would that possible? I have not changed anything aRow. Please help. Tag: Disabling EnforceConstraints Tag: 144146
  - 3
    - oledb + access refresh problem Hi, I'm using ACCESS + oledb with ado.net 2 and I'm having this behaviour when I execute the next sequence: 1. INSERT INTO customer ... 2. SELECT * FROM customer (I execute it inmediately) But the change of step 1 doesn't refresh in step 2, . However if I execute step 2 again after 1 or 2 seconds, the change refresh correctly. Any ideas? Tag: Disabling EnforceConstraints Tag: 144144
  - 4
    - DataView.FindRows out of range problem I'm binding the dataView to a dataset (~400000 rows) and sorting it by a key (long type). I'm retrieving values from the DataView with FindRows(object key) which returns DataRowView[]. The problem is that rarely on Stress modes I get the following error: Source: mscorlib Message: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index The error has no sense since i'm not searching with the index of the array, so I suppose it's some FindRows inner exception. Did anyone had encountered it? Tag: Disabling EnforceConstraints Tag: 144132
  - 5
    - Error running app in production Hi I created a setup file of my app and remotely installed it on a clients machine. The app bombs at start-up with the error; Error while initializing application: Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 8007007e. The application also gave a stack trace which is given below at the end. What's more there is no JIT debugger on the target system. What is the problem and how can I proceed from here specially when I have little or now way to debug the app on the target system. Many Thanks Regards Stack Trace ======== See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at EMS.frmClients.RefrshDropDowns(Boolean FirstTime) at EMS.frmClients.BindFieldstoDataSource() at EMS.frmClients.frmClients_Load(Object sender, EventArgs e) at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.SetVisibleCore(Boolean value) at System.Windows.Forms.Form.SetVisibleCore(Boolean value) at System.Windows.Forms.Control.Show() at EMS.frmMain.OpenForm(String x, Int32 id) at EMS.frmMain.frmMain_Load(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- IV Assembly Version: 1.0.2968.12064 Win32 Version: 1.0.2968.12064 CodeBase: file:///C:/Program%20Files/IV/Events%20Manager%202008/IV.exe ---------------------------------------- Microsoft.VisualBasic Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Runtime.Remoting Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll ---------------------------------------- Infragistics2.Win.v7.3 Assembly Version: 7.3.20073.38 Win32 Version: 7.3.20073.38 CodeBase: file:///C:/Program%20Files/Information%20Vision/Events%20Manager%202008/Infragistics2.Win.v7.3.DLL ---------------------------------------- Infragistics2.Shared.v7.3 Assembly Version: 7.3.20073.38 Win32 Version: 7.3.20073.38 CodeBase: file:///C:/Program%20Files/Information%20Vision/Events%20Manager%202008/Infragistics2.Shared.v7.3.DLL ---------------------------------------- Infragistics2.Win.UltraWinToolbars.v7.3 Assembly Version: 7.3.20073.38 Win32 Version: 7.3.20073.38 CodeBase: file:///C:/Program%20Files/Information%20Vision/Events%20Manager%202008/Infragistics2.Win.UltraWinToolbars.v7.3.DLL ---------------------------------------- Infragistics2.Win.UltraWinExplorerBar.v7.3 Assembly Version: 7.3.20073.38 Win32 Version: 7.3.20073.38 CodeBase: file:///C:/Program%20Files/Information%20Vision/Events%20Manager%202008/Infragistics2.Win.UltraWinExplorerBar.v7.3.DLL ---------------------------------------- Infragistics2.Win.UltraWinStatusBar.v7.3 Assembly Version: 7.3.20073.38 Win32 Version: 7.3.20073.38 CodeBase: file:///C:/Program%20Files/Information%20Vision/Events%20Manager%202008/Infragistics2.Win.UltraWinStatusBar.v7.3.DLL ---------------------------------------- Infragistics2.Win.Misc.v7.3 Assembly Version: 7.3.20073.38 Win32 Version: 7.3.20073.38 CodeBase: file:///C:/Program%20Files/Information%20Vision/Events%20Manager%202008/Infragistics2.Win.Misc.v7.3.DLL ---------------------------------------- System.Design Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll ---------------------------------------- Accessibility Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- Interop.Outlook Assembly Version: 9.0.0.0 Win32 Version: 9.0.0.0 CodeBase: file:///C:/Program%20Files/Information%20Vision/Events%20Manager%202008/Interop.Outlook.DLL ---------------------------------------- Zip Assembly Version: 1.0.0.0 Win32 Version: 1.0.0.0 CodeBase: file:///C:/Program%20Files/Information%20Vision/Events%20Manager%202008/Zip.DLL ---------------------------------------- System.Transactions Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll ---------------------------------------- System.EnterpriseServices Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll ---------------------------------------- Infragistics2.Win.UltraWinGrid.v7.3 Assembly Version: 7.3.20073.38 Win32 Version: 7.3.20073.38 CodeBase: file:///C:/Program%20Files/Information%20Vision/Events%20Manager%202008/Infragistics2.Win.UltraWinGrid.v7.3.DLL ---------------------------------------- Infragistics2.Win.UltraWinTabControl.v7.3 Assembly Version: 7.3.20073.38 Win32 Version: 7.3.20073.38 CodeBase: file:///C:/Program%20Files/Information%20Vision/Events%20Manager%202008/Infragistics2.Win.UltraWinTabControl.v7.3.DLL ---------------------------------------- Infragistics2.Win.UltraWinEditors.v7.3 Assembly Version: 7.3.20073.38 Win32 Version: 7.3.20073.38 CodeBase: file:///C:/Program%20Files/Information%20Vision/Events%20Manager%202008/Infragistics2.Win.UltraWinEditors.v7.3.DLL ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box. Tag: Disabling EnforceConstraints Tag: 144125
  - 6
    - SEHException on opening connection to Access database Hi I moved an ASP.NET website to a new server an suddenly got the following error when connection to my MS Access database: "System.Runtime.InteropServices.SEHException: External component has thrown an exception". Searching the web and newsgroups for a solution I found several pages with this topic, but it seems like it's a very general Exception... hints for my specific problem i did not find. Here's the code which throws the exception (at line 3, cn.Open()): using (OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=C:\Data\MyDataBase.mdb")) { cn.Open(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM Content ORDER BY Title"); cmd.Connection = cn; OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { // do something } cn.Close(); } Thanks a lot for your help. Greets, Dave Tag: Disabling EnforceConstraints Tag: 144120
  - 7
    - LINQ Book Hi All, I think you must be aware with Microsoft's new LINQ You can read about it here: Introducing Microsoft LINQ http://jumbooks.com/books/Computers%20and%20Internet/Introducing%20Microsoft%20Linq/ Tag: Disabling EnforceConstraints Tag: 144118
  - 8
    - How to launch the ole db connection string dialog ? Hello, Someone could send me the code used to launch the standard oledb connection string dialog... I know I must add references to ActiveX libraries but I don't know exactly which ones.. I need it in order to allow to end user to edit the connection string in my app. Thanks in advance Alfonso Moreno Tag: Disabling EnforceConstraints Tag: 144113
  - 9
    - Auto-arrange in data designer Hi If I remember correctly previous versions of vs had some sort of arrange icons command but I can't seem to find it vs2008? What am I missing? Thanks Regards Tag: Disabling EnforceConstraints Tag: 144110
  - 10
    - Help! DataSet.Merge causing duplicates Hello; I've got a problem where DataSet.Merge is causing duplicate records, and then throwing a constraint failure exception because of duplicate primary keys. I've seen a similary problem discussed here where the key fields were set to Auto-increment integers. I am not using this - I'm using GUIDs as primary keys. My scenario: I'm doing a (supposedly) simple remoting app. Note - there is no database server, I'm only using the dataset as a collection, not to do any SQL. Instances of the same typed dataset exist on both sides of the remoting channel (I'll call one "local", the other "remote"). On the remote side, when a row in any table is changed, I call the DataSet.GetChanges() method to extract those changes. I then send this "sub-dataset" from the remote side to the local side, where it is to be merged with it's copy, thus updating it. This is where I get the exception. I can look at the data before the merge, and everything seems to line up. If I only modify one row, I can look at both copies and see that row's state listed as "Unchanged" (with the old data) in the local copy, and "Modified" (with the new data) in what was received from the remote side. I can compare the bytes of the GUID primary key and see they are equal. I can see the field whose data has changed. From the description given on MSDN, I seem to have all the criteria for a successful merge (http://msdn2.microsoft.com/en-us/library/ 4swwh51k.aspx). However, when I look at the local data after the merge blows up on the constraint exception, I can see the duplicate field in my table, with both the old & new data. This has me stumped. I could write my own merge function, but why? If anyone can shed light on this, I'd appreciate it! Derrick Tag: Disabling EnforceConstraints Tag: 144098
  - 11
    - Scratch That... Are They Thread safe? I have dain bramage Tag: Disabling EnforceConstraints Tag: 144095
  - 12
    - Typed Dataset Thread Safety Does anyone know whether typed datasets, as VS 2005 builds them, are type-safe? Tag: Disabling EnforceConstraints Tag: 144094
  - 13
    - How to get original data I'm trying to write my own data provider. I'm almost at the end but one thing is missing. It's not in the demo code. Suppose I fill the grid with data. I change one key field. When I call update, I get into all kind of methods but at some point I need an old value of that key field so that I know which record to change. How do I get this? Or is it that I'm not clear enough how this works? Because in the demo code there is just fixed code that changes second column of the second row to some value. Tag: Disabling EnforceConstraints Tag: 144080
  - 14
    - Reuse of datareader I tried to loop through the datareader to find some data elements one at the time. The first time loop , it's fine. To avoid going to the database, I reuse the same datareader to search for the next element. However, the 2nd search starts from the place where I exit the loop, which causes the search failed if the searched element is located before the first one. The question is how could I make the loop start from row one again by using the same datareader. Here how the code looks like for the search (strTempline is the searched element which changes the value). With drObject If .HasRows Then While .Read If.Item("ref_id").ToString = strTempLine Then strTableName = .Item("related_object").ToString strTblRefId = strTempLine blnExistRefid = True Exit While Else blnExistRefid = False End If End While End If End With Thanks for help Vanny Tag: Disabling EnforceConstraints Tag: 144079
  - 15
    - Using webparts within a database web application Are there any discussions or examples of the best way to use Web Parts to allow users to customise a database web application? I am thinking of the sort of modifications someone would typically want to make to a data-driven application: - additional validation - change the type of control - change the text/label - change the validation message - add a field - make fields read-only - hide fields - move fields - add links I am also looking at how a "designer" can make modifications to an application and then combine the changes they have made into a new "configuration" that can be deployed out to a select group of users. Tag: Disabling EnforceConstraints Tag: 144070
  - 16
    - Strongly-Typed DataSet Woes In ADO.NET 2.0, using VS 2005 Pro., I have visually made a strongly-typed dataset by dragging a SQL Server 2005 table from my Server Explorer window (where I've previously made a connection) onto a blank DataSet designer. This works just fine, and a TableAdapter is generated as well. In code, I can use the TableAdapter's Fill method to populate a new instance of my dataset with no problems. But, if I try to pass the xml representation of the dataset (using the dataset.GetXML() method), the dataset's namespace is rendered as: xmlns=\"http://blah/blah\"> This is causing me to NOT be able to read this XML into a different dataset later. I've tried simply replacing the escape code with nothing or even " to no avial, nothing modifies it. Why is this doing this and how can I change it? -Scott Tag: Disabling EnforceConstraints Tag: 144060
  - 17
    - Fastest way to set a field value in a given table I have some vb6 ado code that needs to be upgraded to .Net: Set rs = CreateObject("ADODB.Recordset") rs.Open "SELECT fieldname FROM tablename WHERE id=" & anyId, oConnection rs(fieldname).value = anyValue rs.close The operation will be repeated many times, so performance is crucial. I've heard that DataTables are slow - what would be the best .Net approach here? OleDbCommand.ExecuteNonQuery(sql_update_statement)? It's an Access database. Tag: Disabling EnforceConstraints Tag: 144057
  - 18
    - Binary Serialization in ADO.NET, which technique DataReader or Hello, Academic question, so I'm not looking for solution code, but rather advice on the technology: If one wants to serialize binary data from a web service to a client, should it be done with DataReader or DataTable? The solution should be efficient and not editable at the client. -pom- Tag: Disabling EnforceConstraints Tag: 144042
  - 19
    - Using embedded file (or stream) as Data Source for Microsoft Jet p Hi. I hava a question, I'm using a connection string like this: "Provider=Microsoft.Jet.OLEDB.4.0; Data source= <filename>", and in works greatly. Now I want to use an embedded file for this purpose, and I have a Stream object for this embedded file, and I want to use it as data source, is this possible in anyway? Tag: Disabling EnforceConstraints Tag: 144041
  - 20
    - wanna return the count(*) through SqlDataReader Hi guys, I'm writing a web service which return the count(*) from database. pls guide me how to do that with thanks in advance Tag: Disabling EnforceConstraints Tag: 144034
  - 21
    - ISNULL() to Integer? Is there a SELECT syntax for returning 1 if a particular column is NULL, or 0 if the column is not NULL? I found ISNULL(), but that returns the column if it is not NULL where I'd want to return 1. I also found IS NULL but couldn't see a way to use that either. Thanks. -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: Disabling EnforceConstraints Tag: 144028
  - 22
    - Remove trailing spaces in string fields? I use the ado.net IdxConnection to connect to an informix database. Unfortunately every field of type String in the dataset has trailing blanks. How can I get rid of them? (In DbExpress (Borland Delphi) I could put "trim char" in the connectionstring.) Tag: Disabling EnforceConstraints Tag: 144020
  - 23
    - Selecting target net version Hi Is there a way to select 2.0 .net as target framework AFTER project has already been created or imported into vs2008? Thanks Regards Tag: Disabling EnforceConstraints Tag: 144016
  - 24
    - DataTable Load Issue Hi, I am having some trouble with a custom IDataReader and the DataTable.Load method when dealing with NULL data, specifically, if a data value is changed in a loaded DataTable from say a double value of 56.23 to a NULL value, the source is updated and the DataTable load is called again using IDataReader, the null value will not be loaded into the updated DataTable, the original value of 56.23 stays. If I call DataTable.Rows.Clear() prior to doing the load, the data is accurately reflected. I did this to verify the data was passing through the IDataReader class successfully. Although we are using this as a work around, it would be preferable to do the load without the clear, as this prevents the UI grids from clearing and re-loading. I verified that the IDataReader is returning a NULL value in the appropriate column; however, when looking at the final loaded DataTable in the debugger, that value change is not reflected. I have also tried all of the LoadOptions, and this did not change the behavior. Finally, I checked the RecordsAffected property of the IDataReader and this is returning a value > 0, I also tried setting this to -1, but this also made no difference. I am not sure what else to try, as something is happening in the DataTable load process that I do not understand..? Tag: Disabling EnforceConstraints Tag: 144001
  - 25
    - SmallDateTime I need to insert a date into sql server via a sproc the table has a smalldatetime field... because we dont care about things before 1900 or after 2079.... or the time for that matter... but when I instert a date into the parameter like this CmdAddRecord.Parameters.AddWithValue("@BillDate", SqlDbType.SmallDateTime).Value = now.date it throws a narrowing error basically on the server... saying it cant convert from datetime to smalldatetime... how do we go about doing this? thanks! Tag: Disabling EnforceConstraints Tag: 143997

Hi

Is there a way to disable EnforceConstraints on a dataset? I have this
statement ds.EnforceConstraints = true in MyDataSet.Designer.vb but I am
reluctant to set it to false as the designer may overwrite the code.

I only wish to do it temporarily to speed up fill operations.

Thanks

Regards

Top

Re: Disabling EnforceConstraints by Rad

Rad
Thu Feb 28 15:36:53 CST 2008

On Fri, 22 Feb 2008 21:59:40 -0000, John wrote:

> Hi
>
> Is there a way to disable EnforceConstraints on a dataset? I have this
> statement ds.EnforceConstraints = true in MyDataSet.Designer.vb but I am
> reluctant to set it to false as the designer may overwrite the code.
>
> I only wish to do it temporarily to speed up fill operations.
>
> Thanks
>
> Regards

You can set it to false just before the call to
DataAdapter.Fill(yourDataSet) call in your code

--
http://www.thinkersroom.com/bytes

Top