dataset record locking

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
    - TableAdapters are a joke. I have just flat given up on TableAdapters. What a joke. I'm not even going to detail all the nonsense I've gone through trying to get these godforsaken "features" to work properly. The concept was good but usability is worse than bad. They should come with that old warning, "don't try this at home folks". Save your energy for something that can consistently do what you expect: Break out the old SqlDataAdapters and stick with them. Tag: dataset record locking Tag: 133486
  - 2
    - How to change the column type? I have a DataTable. How can I change the the type of one column from bool to int ? Tag: dataset record locking Tag: 133484
  - 3
    - ¦p¦ó±NXP ìª©¥úºÐ¤É¯Å¨ìSP2 ¤p§Ì®Ú¾Úhttp://support.microsoft.com/kb/900871ªº§@ªk §ÚXP ªº¦w¸Ëµ{¦¡§ó·s¨ìSP2¤F ¦ýÁÙ¬O¦³¤@Ó°ÝÃD ¦bµwºÐ¤¤ªºI386¸ê®Æ§¨§ó·s¹L¤F, ¦ýn¦p¦ó§â³oÓ¤É¯Å«áªºXP¦w¸Ëµ{¦¡ °µ¦¨¹³ì¨Ó¦w¸Ëµ{¦¡¤@¼Ë¥i¥H¶}¾÷ªº¥úºÐ©O? Tag: dataset record locking Tag: 133483
  - 4
    - Q: Advice on Client/Server app. Hi! Im developing my first client/server application. So ofcourse i got a cople of questions for you gurus out there ;) Created a simple order/detail, with fields and a datagrid, works excelent. Now, in a walkthru i read in the helpfile it updates the grid in three steps. first it removes deleted orders, then updates updated orders, finaly adds newly inserted orders. why is this? As far as i know i can use the .Update on booth tables to ensure save is done. Is there a specific reason it is done in three steps? Second question. got a simple customer table. When using the wizard to create the dataset, the dataset is filled when form loads. If i enter a customer record on a nother computer i need to close down the view and reopen or just issue a fill to reload data. is there no other way to let the dataset get the new data, besides using a timer to reload the dataset. Or can i work directly on the data in the sql server? Regards Martin Tag: dataset record locking Tag: 133481
  - 5
    - ADO.NET the fastest? My foot! I just benchmarked a query against an Oracle database using three different access techniques (OLDDB, ADO.NET and ODBC) and I found that ADO.NET fared worse than all of them - almost twice as long as OLEDB! Surely something is wrong here. I was under the impression that ADO.NET was supposed to improve retrieval times, not slow it down! The results are as follows - it is an average of five executions of the same query. Code is included in case someone wants to tell me what I'm doing wrong. The query itself is a fairly long select query that I can't post here due to its proprietary nature - the actual query shouldn't affect these results, anyway. Please, someone, what's going on? ----------------------------------------------------------- OLEDB: 1.21 Seconds ----------------------------------------------------------- public String execute_query (String query, DataGridView data_grid) { Int32 rowcount = 0; OleDbCommand command = new OleDbCommand (query, connection); DataTable data_table = new DataTable (); OleDbDataAdapter data_reader = new OleDbDataAdapter (); try { data_reader.SelectCommand = command; data_reader.Fill (data_table); data_grid.DataSource = data_table; rowcount = data_table.Rows.Count; } catch (Exception e) { MessageBox.Show ("Failed" + Environment.NewLine + e.Message); } finally { data_table.Dispose (); data_reader.Dispose (); command.Dispose (); }// try..catch..finally return "Rows returned: " + rowcount.ToString (); }// execute_query; ----------------------------------------------------------- ODBC: 1.274 Seconds ----------------------------------------------------------- public String execute_query (String query) { Int32 rowcount = 0; OdbcCommand command = new OdbcCommand (query, connection); DataTable data_table = new DataTable (); OdbcDataAdapter data_reader = new OdbcDataAdapter (); try { data_reader.SelectCommand = command; data_reader.Fill (data_table); rowcount = data_table.Rows.Count; } catch (Exception e) { MessageBox.Show ("Failed" + Environment.NewLine + e.Message); } finally { data_table.Dispose (); data_reader.Dispose (); command.Dispose (); }// try..catch..finally return "Rows returned: " + rowcount.ToString (); }// execute_query; ----------------------------------------------------------- ADO.NET: 2.056 Seconds ----------------------------------------------------------- public String execute_query (String query) { Int32 rowcount = 0; OracleCommand command = new OracleCommand (query, connection); DataTable data_table = new DataTable (); OracleDataAdapter data_reader = new OracleDataAdapter (); try { data_reader.SelectCommand = command; data_reader.Fill (data_table); rowcount = data_table.Rows.Count; } catch (Exception e) { MessageBox.Show ("Failed" + Environment.NewLine + e.Message); } finally { data_table.Dispose (); data_reader.Dispose (); command.Dispose (); }// try..catch..finally return "Rows returned: " + rowcount.ToString (); }// execute_query; Tag: dataset record locking Tag: 133479
  - 6
    - using DetailsView control, update works, insert fails Here are the commands in the sqlDataSource line. InsertCommand="INSERT INTO T_ADMIN_LOGIN (ALID, LNAME, FNAME, USERID, DOMAIN, STATUS) VALUES (S_ADMIN_LOGIN.NEXTVAL, :Lname, :Fname, :Userid, 'AAC', 1)" UpdateCommand='UPDATE T_ADMIN_LOGIN SET LNAME = :Lname, FNAME = :Fname, USERID = :Userid, STATUS = :Status where alid=:alid'> The update works fine. The insert fails with: ORA-01036: illegal variable name/number Anyone got any ideas? TIA Chris Tag: dataset record locking Tag: 133475
  - 7
    - Process slows when do Re-Query of Database Hi I am taking a db creating a dataset then reading some textfiles for changes to insert into the database After I process a file I requery (I call FillDS) the database to update my dataset to get the new inserted records into my dataset Everything works fine except the requery (I call FillDS) is slowing down the process - If I comment out the calls to the requery between files it speeds right along but with the requery in the code it bogs down. I -Is there a better way to design this?? Thanks private void FillDS(string strSQL, string sTable) { m_strSQL = strSQL; m_sTable = sTable; da = new OleDbDataAdapter(strSQL, cnn); cmd = new OleDbCommandBuilder(da); try { da.Fill(ds, sTable); } catch (Exception e) { } } public void UpdateDS() { da.Update(ds.Tables["Trans"]); } public void InsertTrans(string newvalue, int nType, string sProjName,string form) { string strSQL = "insert into Trans (field1,field2) Values (fieldval1, fieldval2)"; OleDbCommand cmd = new OleDbCommand(strSQL, cnn); if (!isopen) { cnn.Open(); isopen = true; } try { cmd.ExecuteNonQuery(); } catch { } } Tag: dataset record locking Tag: 133474
  - 8
    - Ado.Net and Unicode (N') So, we're converting a large ASP.Net application from ASCII only to Unicode. The only issue we've run into, on SQL Server, is the N prefix for literals. We create all our Sql statements dynamically, and most of the time we do not (yet) use bind variables, we just construct the Sqls. So the questions is: Is it possible to add the N prefix "automagically" somehow? I guess the answer is; No, unless you use bind variables (Parameters). If so; how would I make this happen? Tag: dataset record locking Tag: 133471
  - 9
    - CommandBuilder ConflictOption fallback I've already read the post about "CommandBuilder ConflictOption usage" http://groups.google.ch/group/microsoft.public.dotnet.framework.adonet/browse_frm/thread/e2de6b2ec4fc0f08/3519015bed9c9ba2?lnk=st&q=ConflictOption&rnum=1#3519015bed9c9ba2 Because this option is new, I tried out some of the options: CompareAllSearchableValues: - Behaves always independent of the table. CompareRowVersion: - Takes the Timestamp column if one exists. If no Timestamp column exists, it will fall back to "OverwriteChanges". This behaviour isn't described in the help. OverwriteChanges: - Uses PrimaryKey if one exists, else falls back to "CompareAllSearchableValues" as described in the help. The default option of the SqlCommandBuilder is "CompareAllSearchableValues". This isn't described in the help. MS, can you please confirm the behaviour! Thomas Tag: dataset record locking Tag: 133470
  - 10
    - Creating a datatable on a SQL server from a dataset This is probably covered somewhere, but I am having a total brain cramp. I have a DataSet that gets loaded from an XML file. I want to do some processing on it and then save it to a SQL Server data table. I am currently doing by the brute force expedient of creating a SqlConnection, building a string that contains the SQL statements to CREATE the data table and then executing the SQL via an ExecuteNonQuery. It works, but there is a very nagging loud voice in my head telling me that I am doing it the hard way. If anyone know of an easier way or has a link to some sample code that does a similar type of process, I would be greatly appreciative. TIA, If it ain't broke....fix it anyway! [To Email Replies Remove the nospam from the address] Tag: dataset record locking Tag: 133463
  - 11
    - Help: DataGridView Invalid data DataError Problem I have two tables feeding through one dataset: A main table with a foreign key into a lookup table. Primary keys in both tables are defined as INTEGER UNSIGNED NOT NULL. The foreign key in the main tables is defined as INTEGER UNSIGNED NULL. The main table is displayed through textboxes on the form, and a separate Combobox displays the selected, and list of lookup values from the lookup table. No data relations have been defined in the dataset. A bindingsource is used, as well as a binding navigator. This part of the form works fine. On the same form I have placed a DGV, with a subset of main table columns and one DGVCombobox column. Initially, this worked just fine. However a minor change to the database column names â?? not the data - has generated the invalid DataErrors. I have defined an error handler to trap the error and decode some information. The Column number points to the DGVCombobox, and the Context bits decode to â??Formatting, Displayâ??. Using the debugger to examine the details on the dataset, I noted that the primary key for the lookup table is defined as FullName of System.Int32. The primary key of the main table is defined as the same. However the main tableâ??s foreign key is defined as having FullName of System.UInt32. I have tried deleting the DGV and recreating it. The result is consistent and the same: as each cell of the DGV Combo box is displayed, the error exception is generated. The resulting displayed value is the foreign key value of the main table. Recall: no constructs were changed, only the column names were adjusted, and they have been thoroughly checked. Here is the code to set up the DGV. DgvCpyStatus is the DGV combobox column. dgvCpyList->DataSource = bindingSource1; dgvCpyName->DataPropertyName="CpyName"; dgvCpyPriority->DataPropertyName="CpyPriority"; dgvCpyID->DataPropertyName="idCompany"; dgvCpyStatus->DataSource=dataSet1->Tables->default["tblStatus"]; //The next line ties the DisplayMember to the foreign key dgvCpyStatus->DataPropertyName ="tblStatus_idStatus"; dgvCpyStatus->DisplayMember="StatusName"; //Textual status column dgvCpyStatus->ValueMember="idStatus"; //primary key column in tblStatus Tag: dataset record locking Tag: 133460
  - 12
    - DataGrid - Array List - Ordering Columns Hi, I am using a datagrid in a windows app and binding it to an ArrayList. The columns in the array list were appearing out of order so I fixed that by using the DataGridColumnStyle object in the DataGrid and setting the MappingName of each column appropriately. My question though is on properties in the object that is in my ArrayList that are booleans. Before I created the DataGridColumnStyle object, the boolean properties showed up as checkboxes. Now, they show up as a string type with the value written out as "true" or "false". I'd much rather have the checkboxes. I tried to set the Format value to System.Boolean or Bool in the DataGridColumnStyle object and neither worked. Does anyone know what I should be doing? Tag: dataset record locking Tag: 133459
  - 13
    - ?fill dataTable created at design time with dataAdpter at runtime Hello, I created a dataset and dataTable in the designer (VB2005) as the datasource for a Reportviewer control. Up to now I have been creating dataTables/datasets/dataAdapters on the fly at runtime. But I need to set field properties on the reportviewer at design time - could probably do it at run time - but too much code. So at run time I do this to fill a datatable on the fly dim da As new sqldataAdapter dim ds as new dataset da.selectcommand = new sqlcommand da.selectcommand.connection = conn da.selectcommand.commantext = "select * from tbl1") da.Fill(ds, "tblx") Now my dataset exists at design time along with the datatable. How do I fill the existing datatable? the runtime code above complains if I reference the dataset/dataTable I created at design time. Any suggestions appreciated. Thanks, Rich Tag: dataset record locking Tag: 133458
  - 14
    - Q: Creating a head / detail view, not uppdating correctly? Hi! I am doing my first tries to create a order / detail view. I have created two tables in SQL, set relation from the details table to the head table. In Studio 2005 i use the DataSet wizard to create connection, creating the dataset. I select to add th head as simple fields, and the details as a grid. the wizard adds the, toolstrip with appropriate buttons etc. I run the application, i can add the orderhead, adding details. When i save only the orderhead is saved?!? Am i missing something, i tought it should update the details as well?! Any ideas? Point me in a direction or perhaps a link to neet page that will describe on how to do this. Regards Martin Tag: dataset record locking Tag: 133457
  - 15
    - Multidimension string into DataTable Is there an easy way to move a Multidimension string array (string [][]) into a DataTable? I tried: ru.employerList is a string[][]. DataTable testTable; testTable = ArrayToDataTable(ru.employerList); This gives me an error: The name 'ArrayToDataTable' does not exist in the class or namespace 'integration.WebForm1' I have System.Data defined. Thanks, Tom Tag: dataset record locking Tag: 133453
  - 16
    - Working with table adapters and multiple fills Having done all this untyped and with a lot of typing in the past, I'm trying to make efficient use of table adapters instead of data adapters. I understand that it's just a wrapper. But what I don't understand is how providing multiple fill methods gains me anything. For example, I want to pull both the phone number and the fax number for a particular contact. The value of both come from the PhoneNumber column in the PhoneNumbers table and the select differs only in their phone type. So I set up two fill methods to retrieve. However, clearly the datatable now contains ONLY the second fill. I don't see how this gains anything in terms of usability -- I may as well set up a second datatable in the dataset just for the fax numbers, and set up a separate fill there. this.phoneNumbersTableAdapter.FillOfficePhone(this.dsBrands.PhoneNumbers, _intContactID); if (dsBrands.PhoneNumbers.Rows.Count > 0) { dsBrands.PhoneNumbersRow rowPhone = dsBrands.PhoneNumbers[0]; if (!rowPhone.IsPhoneNumberNull()) { txtPhone.Text = rowPhone.PhoneNumber; } } // this fill would now overwrite the contents of the PhoneNumbers datatable this.phoneNumbersTableAdapter.FillFaxNumber(this.dsBrands.PhoneNumbers, _intContactID); ... Tag: dataset record locking Tag: 133452
  - 17
    - da.update and Bool --> yes/no type In a data grid using Access as the data source.. The da.update is failing with "object reference not set to an instance of anobject" It looks like everything is ok and I was wondering if there is a problem that I have a bool column mapping to a yes/no type. __________________________________ Here is the code: Private Sub PopulateProductGrid() Dim conn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source='C:\Program Files\MyProgramArea\Pricing\Pricing.mdb';Persist Security Info=False") Dim sSQL As String sSQL = "select * from ProductNames" conn.Open() Dim da As New System.Data.OleDb.OleDbDataAdapter(sSQL, conn) Dim cb As New OleDb.OleDbCommandBuilder(da) Try da.Fill(myDS, "ProductNames") DataGrid1.DataSource = myDS DataGrid1.DataMember = "ProductNames" Dim irow As Integer Dim icol As Integer irow = 0 DataGrid1.Select(irow) DataGrid1.SetDataBinding(myDS, "ProductNames") RowCount = DataGrid1.BindingContext(myDS, "ProductNames").Count() Catch ex As Exception MessageBox.Show("Failed to connect to data source") Finally 'conn.Close() End Try End Sub Private Sub ProductTypeSelection_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load PopulateProductGrid() StoreNameOut.Text = StoreName VolumeDiscountOut.Text = VolumeDiscount ' ' Create a Grid Table Style. Map it to the "Product Names" Table. ' Dim aGridTableStyle As New DataGridTableStyle aGridTableStyle.MappingName = "ProductNames" aGridTableStyle.AlternatingBackColor = Color.Lavender ' ' Create GridColumnStyle objects for the grid columns ' Dim aCol1 As New DataGridTextBoxColumn Dim aCol2 As New DataGridTextBoxColumn Dim aCol3 As New DataGridBoolColumn ' With aCol1 .HeaderText = "Code" .MappingName = "CODE_VALUE" .Width = 50 .Alignment = HorizontalAlignment.Center .TextBox.Enabled = False End With ' ' Set column's caption, width and disable editing. ' With aCol2 .MappingName = "CODE_MEANING" .HeaderText = "Prodcut Type" .Width = 515 .Alignment = HorizontalAlignment.Left .TextBox.Enabled = False End With With aCol3 .MappingName = "CODE_Selected" .HeaderText = "Select" .Width = 50 .Alignment = HorizontalAlignment.Center End With ' ' Add the GridColumnStyles to the DataGrid's Column Styles collection. ' With aGridTableStyle.GridColumnStyles .Add(aCol1) .Add(aCol2) .Add(aCol3) End With ' ' Add the GridColumnStyles to the aGridTableStyle. ' DataGrid1.TableStyles.Add(aGridTableStyle) End Sub Private Sub DataGrid1_Navigate(ByVal sender As System.Object, ByVal ne As System.Windows.Forms.NavigateEventArgs) Handles DataGrid1.Navigate End Sub Private Sub NextButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NextButton.Click DataGrid1.DataSource = myDS DataGrid1.DataMember = "ProductNames" Try da.Update(myDS, "ProductNames") Catch ex As Exception MsgBox(ex.Message) End Try PricingForm.StoreName = StoreName PricingForm.VolumeDiscount = VolumeDiscount PricingForm.Show() End Sub Tag: dataset record locking Tag: 133451
  - 18
    - dataview relations hallo i try to fill 3 grids with relational data. customer -> orders -> orderdetail dvcustomer = dvm.createdataview( ds.tables["customer"]);//dvm->dataviewmanager dvorders = dvm.createdataview( ds.tables["orders"]); dvorderdetail= dvm.createdataview( ds.tables["orderdetail"]); foreach( DataRowView drv1 in dvcustomer) { dvcustomer = drv1.CreateChildView(drcustomer_orders); } foreach (DataRowView drv2 in dvorders) { dvorderdetail = drv2.CreateChildView( drorders_orderdetail); } grid1.datasource = dvm; grid1.datamember = "customer"; grid2.datasource = dvm; grid2.datamember = "customer.customer_orders";// relation grid3.datasource = dvm; grid3.datamember = "orders.orders_orderdetail";// relation it works fine , althgough grid3 shows the correct initial rows it is not updated when i change the current row in grid1 or grid2. when i change current row in grid1, grid2 is updated correctly. i have played around with the values for datasources/ datamembers but grid3 will not work as i expected. thanks for help sebastian Tag: dataset record locking Tag: 133439
  - 19
    - rowfilter date formats Forgive me if this is not the right place to post this. I've already had it booted from the vb.database forum. ------------------------------ I'm thoroughly confused. The following expression works fine as a table view rowfilter when locale is set to US. dateField <= "#" & Now.ToShortDateString & "#" It fails when you set your locale to German. (Most embarassing for my client on a recent show and tell to his peers in Europe.:-))) Error is string is not recognized as date. Presumably because the day and month are switched in most of the world from what we do in the US. Luckily we "tested" this after the 12th of the month!!!! The following works: Dim noww As String = Now.ToString("MM/dd/yyyy") dateField <= "#" & noww & "#" At first I was puzzled because noww is e.g. 09.30.2006. On further reading the doco I see that the locale date separator is used. So the question is simple. Have I now stumbled across a formatting of the test string that will work regardless of the locale's date seperator, or have I encountered a bug, or what? More to the point where can i find a good definition of the syntax and semantics of rowFilter when dates are involved? Note MS Lurkers - as usual the VS 2005 help is as useless as <substitute your favorite off color expression for these circumstances>. It only shows an example and has nothing on globalization. (And this only after you follow your nose around the barn to "expressions"!) To use my recurring mantra these days - Yet another reason why VSTS 2005 is not ready from prime time:-) -- Regards, Al Christoph Senior Consultant Three Bears Software, LLC just right software @ just right prices @ 3bears.biz Microsoft Certified Partner (ISV) Coming soon: Windows Mail for Vista. Tag: dataset record locking Tag: 133431
  - 20
    - A connection pooling error has occurred I am trying to clean an object in its Finalize method regarrding connection pbjects as follows : objConnection.Dispose() objConnection = Nothing shCard = Nothing The connection iscreated in another object as follows objConnection = shCard.CreateConnection I get the following error on the line "objConnection.Dispose() or objConnection.close *************************************** {System.InvalidOperationException} [System.InvalidOperationException]: {System.InvalidOperationException} HelpLink: Nothing InnerException: Nothing Message: "A connection pooling error has occurred." Source: "System.Data" StackTrace: " at System.Data.SqlClient.SqlConnection.Close() at System.Data.SqlClient.SqlConnection.Dispose(Boolean disposing) at System.ComponentModel.Component.Dispose() at ConfigBAL.ShoppingCartDB.Finalize() in C:\Inetpub\wwwroot\Configurator\Components\ShoppingCartDB.vb:line 977" TargetSite: {System.Reflection.RuntimeMethodInfo} ********************************************* Does that mean that I can not close or dispose a connection object because of pooling As I said in a previeou post, I have user connections depassing the default, which I think is 100 by default Thanks Tag: dataset record locking Tag: 133424
  - 21
    - Storing data from multiple clients Hi to all. I'm developing a network server application which will be constantly receiving data from mobile GPRS clients and storing them in a centralized database (probably SQL Server or Oracle); from the server's point of view, the clients will just be standard TCP/IP clients, sending data using a custom protocol I'll design. The data will be sent to the server in messages, which will contain very small amounts of data (a bunch of floating point numbers), but will be sent quite often, every second or even faster. The number of client is not pre-determined, but the application needs to be able to scale up to hundreds of clients. The server won't do any processing on the incoming data, just add a timestamp and the client's ID and INSERT a new row in a table. I'm going to use async sockets to handle the connections from the clients, so the data storing actions will be triggered by incoming socket data and will be handled by the socket callback methods; I think this is much better than using worker threads to wait on the sockets, since the number of simultaneous connections can potentially become quite high (am I right on this?). Now, my question is: which is the best way to do an INSERT on the DB every time a data message arrives from a connected socket? I (obviously) don't want to manually open and close a DB connection every time; I could open one when the server starts and do all of my data access using that one, but I don't know how this method works when using a multithreaded application; if I have to use some form of mutual exclusion here, then the single DB connection will become a bottleneck. I've heard about using connection pooling, but I don't actually know how it works and if this is the ideal technique for this scenario. Can someone please help? :-) Thanks Massimo Tag: dataset record locking Tag: 133416
  - 22
    - Marginalizing parameter In case I had a parametric query SELECT Name, Phone from MyFriends WHERE MyFriends.city = @CITY is it possible to specify a string value for @CITY in order to have the query to behave exacly like : SELECT Name, Phone from MyFriends ?? In other word, if this is possible, what is the parameter value which would correspond to eliminate the WHERE condition ? Or do I have necessary to remove the "where" part? -P Tag: dataset record locking Tag: 133414
  - 23
    - Subselect, TableAdapter and MS-Access 1) I generated a Subselect query in MS-Access which works fine there: SELECT (SELECT Name FROM Players WHERE Players.PlayerID = PlannedGames.PlayerID) AS PlayerName, (SELECT Surname FROM Players WHERE Players.PlayerID = PlannedGames.PlayerID) AS PlayerSurname, * FROM PlannedGames This Subselect is recommended in Scott Mitchel's excellent MSDN Article "Creating a data access layer". Then I cut&paste this select statement into the TableAdapter Configuration Wizard. This generates SQL parsing errors. Does the ADO.NET 2.0 provider for MS-Access not support Subselects? 2) In general is there a comparison table which SQL-Server 2005 features / .NET 2.0 classes are not available/working when using ADO.NET 2.0 and MS-Access 2003 ? thank you very much herbert Tag: dataset record locking Tag: 133413
  - 24
    - Timeout expired connection Ihave an application (.Net 1.1, wi2k3 SP1, SQL 2005) that works fine after severalminutes of browsing then I start to get the following error : Servor Error in '/myVirtualServer' Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. Thismay have occured because all pooled connections were in use and max pool size was reached. I have several connections opened/closed that use the same connection string What might be the issue? Is there a parameter to fine tune the number of connection allowed. Thanks Tag: dataset record locking Tag: 133412
  - 25
    - Update Access DB from a Data Grid I have a data grid with three columns Text1, Text2, Bool3. I would like to have the user check/uncheck in Bool3 column and automatically update the Access DB. One other thing I have Text1 and Text2 and readonly and the user can only modify the Bool3 column; is there a way to have the user only in the bool3 column and never in the Text1 or Text2 columns. Thanks, Steve Tag: dataset record locking Tag: 133406
- Next
  - 1
    - Async Ado.Net Operations (Begin/End OpenConnection) We're building high performance database applications, and are trying to use all the new Async ADO.Net 2.0 features. The problem we're having is that we can't find a SqlConnection.BeginOpen/EndOpen method. We can execute everything using the BeginExecuteCommand, but without the BeginOpen on the connection we end up with lots of deadlocked threads, all waiting for SqlConnection.Open. This means things are more-or-less useless. We looked briefly into MARS for doing this, as that might be an option, but we really prefer the more standard Async stuff as it maps much easier into working with other database providers such as Oracle. What's frustrating is that early Whidbey builds, and many old ADO.Net 2.0 articles, refer to these methods so they existed at one point. These methods were obviously removed during the .NET 2.0 RTM process, which seems really strange. Any ideas how to work around this and actually do highly scalable I/O using the Async infrastructure in ADO.NET 2.0? -- Chris Mullins MCSD.Net, MCPD Enterprise http://www.coversant.net/blogs/cmullins Tag: dataset record locking Tag: 133397
  - 2
    - ADO.NET 2.0 Asynchronous Command Execution: Independant of Web Session? I have a small ASP.NET 2.0 application that needs to be able to kick off a long stored procedure (for importing and processing tables ) and then allow the user to continue with the session, perform other tasks, and log out without having to wait for the SP to complete. I read the following article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/async2.asp This looks very promising but I could not figure out what would happen to the thread if the user logged out before it completed. The stored procedure could take several hours depending on the parameters selected so I need the command to be independant of the web Session. Will it keep running or die when the user logs out? If it dies, can anyone suggest a way to set it up so it will run until complete? Thanks for your help! Tag: dataset record locking Tag: 133388
  - 3
    - Getting Oracle Error Hi I'm trying to run a queries on a schema, and I keep getting ORA-00911: invalid character error. If I copy/paste it in SQL/Plus it runs fine. This is what I'm doing in code: //Set session here to ZGK037_MDB string sqlSession = string.Format("ALTER SESSION SET CURRENT_SCHEMA={0}", oDB.DatabaseName); //Note I don't close the Connection Object in this call. It just gets an OracleCommand Object cmdOracle = MiscDataUtils.GetCommandObj(sqlSession, oDB.Connection); //Execute the sqlSession query cmdOracle.ExecuteNonQuery(); //This is what it shows in my logfile...so it looks like the above worked with no exceptions [Logging-DEBUG]-9/29/2006 10:22:45 AM [GetCommandObj] ALTER SESSION SET CURRENT_SCHEMA=ZGK037_MDB Next I try to run a query on this command obj cmdOracle.CommandText = sql; //Set to my new SQL string rdr = MiscDataUtils.GetDataReaderFromCommandObj(cmdOracle); This is what the log file says: [Logging-DEBUG]-9/29/2006 10:22:45 AM [GetDataReaderFromCommandObj] Select RoFm.SymCount as Occ, csd.oid as SymbolOID, csd.m_progID as ProgID, csd.m_version as ProgVersion From CORESymbolDefinition csd, (Select Count(*) as SymCount, fm.m_defname as RoFmID FROM CORERelationOrigin RO JOIN COREFlavorMgr FM ON RO.oidTarget = FM.oid JOIN CORESymbol S ON RO.oid = S.oid Group By fm.m_defname ) RoFm Where csd.m_progID=RoFm.RoFmID Order by csd.m_progID; [Exception] ORA-00911: invalid character Any help is really appreciated. Sunit Tag: dataset record locking Tag: 133385
  - 4
    - TableAdapter vs DataAdapter Hi, I was wondering when to use TableAdapters (TA) and when to use DataAdapters (DA). If I've got a typed dataset containing multiple related tables, I would say use a DA to fill the dataset. Why should I use TA instead? I can imagine situations where may be just one table from the dataset is needed, in that case you might say, use a TA. I agree on that. What about updating a typed dataset containing multiple related tables. In that case I also would use a DA rather than TA's. I presume I will need multiple TA's when updating multiple tables in this typed dataset (i.e. added orderd and orderdetails in the typed dataset). Conclusion: If I want to use just a few tables I would better fill the tables using TA's and if I've got just one table to update I could also use a TA. But when filling a dataset in one operation and when updating multiple tables in a dataset I would better use a DA. Is this correct? P.S.: I will not use SQL in code, just SPROC's Tag: dataset record locking Tag: 133383
  - 5
    - Casting - IDataParameter Is there some way to cast a IDataParameter to a SQLParameter? It's not working and I'm not sure why. Tag: dataset record locking Tag: 133381
  - 6
    - xmltype oracleclient Hi - Does anyone know if the xmltype oracle column data type is supported in system.data.oracleclient? ---------------- Sal .NET 2003 Oracle 9i Tag: dataset record locking Tag: 133379
  - 7
    - Connection pooling parameters not working for Oracle connection I am using OracleConnection to connect to Oracle 9i Database from a VB.NET project the connection string has the parameters "User ID", "password", and "Data Source". my project import System.Data.OracleClient I tried to add connection pooling parameters like "Connection Timeout", "Incr Pool Size" and "Min Pool Size" to the connection string string but for each one I get the error that this parameters is not supported, when I try to open the connection any clue ? Tag: dataset record locking Tag: 133378
  - 8
    - Export Table to dBase 3 (.dbf) Hi! Does anybody know the best way how to export a DataTable to a dBase 3 file? Regards Stephan Tag: dataset record locking Tag: 133377
  - 9
    - InvalidOperationException when changing value in XmlDataDocument I'm using a XmlDataDocument to interface a DataSet. When trying to change the value of a node (I'm actually using InnerXML) I get an InvalidOperationException saying "Please set DataSet.EnforceConstraints == false before trying to edit XmlDataDocument using XML operations.". Is it not possible to make changes in the DataSet without setting EnforceConstrains to false? If I set the EnforceConstraints to false, all values that are constrained may be overrided. I only want to be able to set values that are not constrained. Tag: dataset record locking Tag: 133375
  - 10
    - Remove association between DataSet and XmlDataDocument I have a DataSet that is not cleared untill the application is closed. But I want to associate a XmlDataDocument to the DataSet several times. If I try this I get an ArgumentException saying that a XmlDataDocument cannot be associated with a DataSet that already has an association. How do I remove this association without clearing the DataSet? Another possibility would be to retrieve the reference to the XmlDataDocument from the DataSet, but such a reference doesn't seem to exist? Tag: dataset record locking Tag: 133374
  - 11
    - What happened to SqlConnection.BeginOpen? We're building some very high performance database applications, and are trying to use all of the new Async ADO.Net 2.0 features. The problem we're having is that we can't find a SqlConnection.BeginOpen/EndOpen method. We can execute everything using the BeginExecuteCommand, but without the BeginOpen on the connection we end up with lots of deadlocked threads, all waiting for SqlConnection.Open. We looked briefly into MARS for doing this, as that might be an option, but we really prefer the more standard Async stuff as it maps much easier into working with other database provides such as Oracle. To do this with MARS, we would still need this BeginEnd methodology. What's frustrating is that early Whidbey builds, and many old ADO.Net 2.0 articles, refer to these methods so they existed at one point. These methods were obviously removed during the .NET 2.0 RTM process, which seems really strange. Any ideas how to work around this and actually do highly scalable I/O using the Async infrastructure in ADO.NET 2.0? -- Chris Mullins MCSD.Net, MCPD Enterprise http://www.coversant.net/blogs/cmullins Tag: dataset record locking Tag: 133370
  - 12
    - Oracle connection error when called from web service Hi, I'm having a web service which connects to a Oracle database and gets the results. When running the web service individually the database gets connected and the results are downloaded. I'm calling the same web service from another web service, the Oracle connection is not made, it provides me a exception "ORA-12154: TNS:could not resolve service name". The web services used to work perfectly until for some other purpose i changed the tnsnames.ora file, after that i reverted back with the changes earlier (which was working). But still if there is any problem in tnsnames.ora file, then the first web service should also not get connected to database. I don' t know how it gets connected. Following is the code used, string query = GetQuery( ID ); // Create a Oracle connection. OracleConnection dBConn = new OracleConnection(); // Provide the connection string details. dBConn.ConnectionString = "User Id=XXXX;Password=XXX;Data Source = XXX"; // Frame a Oracle command. OracleCommand cmd = new OracleCommand( query ); // Connect the command to connection for the Oracle database. cmd.Connection = dBConn; try { // Open the connection. dBConn.Open(); } catch( Exception ex ) { } Can anyone provide me a pointer about what is happening and how to solve the same?? Regards, Chandra Tag: dataset record locking Tag: 133368
  - 13
    - Executing an sql script on a remote database from Visual Studio .NET 2005 I am connecting to a remote SQL Server database from Visual Studio .NET 2005. I have an sql script located on my machine containing the sql code I want to use to create several tables, and want to execute it. How can I do this from Visual Studio .NET 2005? I do not like designing the database using the designer because sometimes the designer uses different words, phrases things differently, and causes me to be unsure exactly what the properties of the fields in my database are. If anybody know how to do this, please let me know. Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: dataset record locking Tag: 133367
  - 14
    - Query works in Query Analizer but not as part of a table adapter I'm trying to run a query to return all of the customers who have not placed an order. This query runs fine in Query Analizer but when I try to run it as part of a table adapter it returns all rows (customers with orders AND customers without orders). It appears that the second select is not being utilized. What am I missing? SELECT CustomerID, Name FROM Customers WHERE CustomerID NOT IN (SELECT CustomerID FROM Orders WHERE (OrderMonth = 9) AND (OrderYear = 2006)) Thanks, Tom Tag: dataset record locking Tag: 133364
  - 15
    - DataBindings : wrong data displayed Hello, I'm using databindings to display data from a datatable. When I first fill my datatable, it works perfectly, and displays the current data. If I remove the datatable, and recreate it with new data, it's not working anymore : the displayed data are from the first fill of the Datatable ! (I checked, it's not the same DataTable anymore). Here's my code : SqlDataAdapter sqlda = new SqlDataAdapter("SELECT * From Data",Cnx); if (GlobalDS.Tables.Contains("Data")) { GlobalDS.Tables.Remove("Data"); } sqlda.Fill(GlobalDS, "Data"); txtName.DataBindings.Clear(); txtName.DataBindings.Add("Text", GlobalDS,"Data.Name"); Thanks, Tag: dataset record locking Tag: 133354
  - 16
    - Creating dataset.xsd file programmatically as dragging table from Server explorer fails Visual studio 2003, MySQL database, MySQL odbc 3.51 driver Is it possible to create the file dataset.xsd programmatically? I'm trying to create my dataset1.xsd file for using with crystal reports. The database is mySQL and the data connection is sat in my server exporer bar. The tables and fields are enumerated correctly in the server explorer, but when i try to drag and drop any item onto the dataset1.xsd designer surface I receive a sql error - "The wizard detected the following problems when configuring the data adapter for "users". Details: Error in SELECT clause: exression near "" Error in FROM clause: near "" Unable to parse query text." If I press OK, then i receive the message - "The following unexpected error has occurred: There were errors dropping "users" onto the designer. The XML schema could not be interpreted from this object. " Im stuck and relatively inexperienced so I don't know where to go from here. I thought that it might be possible to create a dataset from code then write it to file. How would I go about this please? Tag: dataset record locking Tag: 133353
  - 17
    - DTSWizard Are there any tools around similar to MSSQLs DTSWizard for importing data into a DataTable? The DTSWizard has many nice features which I would hate to recreate if it's already been done. Thanks, Joe Tag: dataset record locking Tag: 133336
  - 18
    - ado & Active directory I am using ado to connect to active directory in a web application. I create the command: objConnection = new adodb.connection objCommand = New adodb.Command objConnection.Provider = ADSDOObject objCommand.Properties("Page Size").Value = 1000 objCommand.Properties("SearchScope").Value = 2 I have one server, one IIS, 2 directories. All permissions are the same that I can tell on both directories and IIS settings. However, when I run the above on one of the directories, it run fine, on the other I get this error: System.NullReferenceException: Object reference not set to an instance of an object. at System.Enum.InternalGetValue() at System.Enum.System.IConvertible.ToBoolean (IFormatProvider provider) Why would I get this error on one directory and not the other, exact same program, same web.config, everything I can think of is exactly the same. And whatever could be the cause?? Thank you for your help. Tag: dataset record locking Tag: 133335
  - 19
    - How do I connect to SQL database using applicaiton roles and ado.net? My MSDE database uses Application Roles. When I run my asp.net application I cannot open the database, I get a Logon Failed exception. I need to be able to open the DB to run the sp_setapprole stored procedure for my role access. Is there some other way that I can do this? So far the only way I can get this to work is to give the ASP.NET process SYSTEM rights. I would prefer to use the ASPNET user rights. My connection string is as follows: "Pooling=false;Server=(local);Integrated Security=SSPI;Database=MyDb" -- ----------------------------------- Ken Varn Senior Software Engineer Diebold Inc. EmailID = varnk Domain = Diebold.com ----------------------------------- Tag: dataset record locking Tag: 133334
  - 20
    - Trapping for Connection and Command Timeout FW: 1.1 What is the best method for trapping timeout exceptions? There does not seem to be specific exceptions thrown for connection or command timeout. Should I check the message for "Timeout", or is there some other propery in the exception that better identifies a connection or command timeout? Thanks for your help. Tag: dataset record locking Tag: 133333
  - 21
    - SQL Question Hello: I have a SQL question. If this is the improper board to post this question on, please let me know where you would suggest I post it. I have a SALES table with the following schema and structure. ID Status Date -- ------ ---- 1 Open 1-1-2000 2 Open 1-1-2001 3 Closed 1-1-2002 4 Open 1-1-2003 5 Closed 1-1-2004 I want to write a query that returns all the records where it first does a count of all the statuses, identifies where the count status is > 2, then display each record where the status = the status which has been identified as having a count of > 2. So the results I want back are: ID Status Date -- ------ ---- 1 Open 1-1-2000 2 Open 1-1-2001 4 Open 1-1-2003 So I write a query something like this: SELECT count(status), id, date FROM sales GROUP BY status HAVING count(status) > 2 I get a SQL error saying that I have to add "id" and "date" have to be in the GROUP BY clause. But when I put those fields in the GROUP BY, then the count does not calculate right and I get no results back. Could anyone enlighten me as to what I could do to fix this? Tag: dataset record locking Tag: 133320
  - 22
    - pStartInfo in C#.Net Hi all, I want to do the foll. I want to get the process running in the name system, with name "abc", and in turn get their arguments, so that i do some processing later Foll. is my code: Process proc = new Process(); proc.StartInfo.FileName = "notepad.exe"; proc.StartInfo.Arguments = "abc.cs"; proc.StartInfo.UseShellExecute = false; proc.Start(); Process[] p = Process.GetProcessesByName("notepad"); string args = p[0].StartInfo.Arguments.ToString(); Console.WriteLine("args: " + a); //this is retning null - shd retn abc.cs string b = p[0].BasePriority.ToString(); Console.WriteLine("BASE PRIORITY: "+ b); //this comes out correctly With the above code, args is returnin a null string. (Also abc is currently running-obvious 'coz i didnt get any InvalidOperationException). when i try to print the parameters other than that of StartInfo, its working fine-only in case of StartInfo params. Tag: dataset record locking Tag: 133314
  - 23
    - Using crystal reports with MySQL ADO connector I am a developer with limited database and zero crystal report experience. I am very confused. We wanted the ability to switch database providers easily, so I selected to use ADO components with our application. The database we're developing with is MySQL. I downloaded their MySQL Connector/NET components which are ADO compliant. Using .NET connectors, if we want to switch to another provider, there should be minimal code changes necessary to make it run. It all works fine so far. I connect to the remote database at run time using a connection string read from stored configuration information. Now I need to add reporting capabilities to the application, using Crystal reports, and this is where Im confused. http://support.businessobjects.com/communitycs/technicalpapers/rtm_reportingoffadonetdatasets.pdf This example shows preparing data for use in a web project. Ours is a desktop application. So far I've tried to keep all of this as generic and configurable from config files as possible. The example in the above link uses a wizard to link to OLE DB provider registered on the local pc. This immediately ruins the portability as it's done through a wizard. Is OLE DB the "same" as ADO? Do I need to download and install OLE DB drivers from mySQL's site? I wondered if once you've used this wizard, at later dates you can programmatically change server information. Is that possible? thanks :-) Tag: dataset record locking Tag: 133313
  - 24
    - How to keep ALTER SESSION settings Hello All I'm trying to execute queries on a specific schema using ALTER SESSION as string sqlSession = string.Format("ALTER SESSION SET CURRENT_SCHEMA={0}", oDB.DatabaseName); MiscDataUtils.ExecuteNonQuery(sqlSession, oDB.Connection); //Change Session Here //However this one fails since this is another connection rdr = MiscDataUtils.GetDataReader(sql, oDB.Connection); Is there a better way to do this. ?? thanks Sunit Tag: dataset record locking Tag: 133312
  - 25
    - Non English Characters Hi, We are developing a small web interface to a local ERP software, which uses SQL Server 2000 as database. The database uses SQL_Latin1_CP1 collation, and the fields are varchar (not nvarchar), however, the main program inserts and reads non-English (Turkish) characters into these columns. However, when we connect to database with ADO.NET, these characters are not read correctly. (The situation is same when I check tables with Enterprise Manager and Query Analyzer) In a past situation (which was about a Win32 application), I have heard about character conversion behaviour of ADO (and many other DB libraries) and solved that problem using BDE instead of ADO, so that the connection is made via DB-Library instead of OLEDB. But this way cannot be applied to my ASP.NET situation, and there is NO way to change database collation. Must I use a ADO.NET property, or use another provider, or maybe another library? Any advices? Thanks... Tag: dataset record locking Tag: 133310

hello all,

I have a webservice which writes requests to a requests log table in
sql server

I have a windows service with a function that kicks-off every 30
seconds to process the records in the requests log table.

The function retrieves pending requests (STATUS = 0) and adds them to a
datatable using a sqldataadapter
once the record has been processed, the STATUS column is set to 1, so
that it is not processed again.

I know that records can be locked for update, but is there a way to
lock records for select ?

e.g.

The requests log table has 20 pending requests which are picked up and
added to the dataset..
in the 30 second interval between function iterations, only 5 are
proocessed.
The function runs again and 15 of the original requests are added to
the dataset

Is there some mechanism to prevent these 15 requests from being added
to the dataset ?

Thanks in advance

Top