Error Trapping dataAdapter.update

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
    - How to Distribute Interop.ADOX.dll? I am including a reference to ADOX in a C# project by doing the following: In Solution Explorer, right-click the References node and select Add Reference. On the COM tab, select Microsoft ADO Ext. 2.7 for DDL and Security, click Select to add it to the Selected Components, and then click OK. This creates a dll in my debug and release directory named Interop.ADOX.dll. However if the executable is placed in a different path it requires this dll. If I copy the Interop.ADOX.dll to the same path where the executable resides all is fine. The question is what must be done during an installation? Can the file Interop.ADOX.dll just be copied to a directory or is there some type of registration that must take place? Thanks in advance for any help, Scott Tag: Error Trapping dataAdapter.update Tag: 113188
  - 2
    - Problem using LIKE in a command object Hi everyone, I'm trying to use a select command as the CommandText of an ADO.NET SQLCommand object (I'm using SQL Server as the database). From the Query Analyzer I can run the query and get the correct result, but in my program, the command using this query returns no rows. My code looks like this... Private Const availFutureRes = "SELECT Id from AlcResIndx WHERE ResType IN ('PF','PW') " & _ "AND Date <= @Date AND SKU LIKE @SKU AND HasBalance = 'Y' " & _ "ORDER BY Date DESC" Dim dr as SqlDataReader Dim cn As SqlConnection = New SqlConnection(connectStr) Dim cmd As SqlCommand = New SqlCommand(availFutureRes, cn) cmd.Parameters.Add("@Date", SqlDbType.DateTime, 8, "Date") cmd.Parameters.Add("@SKU", SqlDbType.Char, 18, "SKU") cmd.Parameters("@Date").Value = r.StartDate cmd.Parameters("@SKU").Value = RTrim(key) & "%" cn.Open() Try dr = cmd.ExecuteReader() So what's wrong with this? I've tried setting up the "@SKU" value so that it's enclosed in single quotes (like it would be in the Query Analyzer like 'AA127%'). Didn't help. Any help is appreciated. BBM Tag: Error Trapping dataAdapter.update Tag: 113187
  - 3
    - Updating DataRow I'm splitting a csv file into records and then into string fields. Then I load the string fields into a new DataRow using ItemArray property. I set the DefaultValue of the fields to the approprate type. This part is very fast but then I have to load the columns based on the datatype and convert the string to the correct column datatype and check for string.empty. This is very slow. Is there a faster way to do this process? Tag: Error Trapping dataAdapter.update Tag: 113186
  - 4
    - Connection Pooling Hi guys, I am not too sure if I understand the connection pooling or not. But I am implementing an application where in one page I open connections a few times each time I close connection properly. My question is thanks to the connection pooling the first opened connection will stay in the memory and reused for the rest? Am I correct? If not, my ASP.NET application has 3 tiers. Client application layer (HTML and code behind), business layer and database layer. Now on business layer, in most of functions we open a connection and close. Something like for instance Publisher class public static dataset getPublisherDetails(int publisherid) { connection.open(); connection.close(); return resultdataset; } public static dataset getItemsByPublisherID(int publisherid) { connection.open(); connection.close(); return resultdataset; } and in Customer layer we say dataset publisherDetails = Publisher.getPublisherDetails(publisherid) dataset publisherItems = Publisher.getItemsByPublisherID(publisherid) as you can see we open connection twice here. But this is a very brief way of describing all layers I actually use. but just assume that according to our current application architecture it is really hard to open connection once to process one page. Is it really bad way of constructing application architecture so that we will have to reconstructing it or ?? Look forward to hearing from you guru!!! Thanks *** Sent via Developersdex http://www.developersdex.com *** Tag: Error Trapping dataAdapter.update Tag: 113184
  - 5
    - How do I requiry a dataset? I have a form with 2 tabs. 1 tab contains a data entry screen and the second tab contains a datagrid with a listing of the entered data. I fill the datagrid when I load the form. I want to requiry or refill the datagrid when the tab is made active. Is there a refill command for the dataset? I have tried dataset.fill() and dataset.getchanges() and dataadapter.Update. Thanks Tag: Error Trapping dataAdapter.update Tag: 113174
  - 6
    - Create SQL Tables From an XML Schema Hello, Does anyone know how to create a SQL table from an XML schema programmatically? I have an xml dataset that needs to update the SQL structure. I have no problem going from SQL to XML. But what if I want to go the other way? Thanks, Dolph Tag: Error Trapping dataAdapter.update Tag: 113173
  - 7
    - How to populate DataSet from List Box? I want to store the result sets for the 10 drop-down list boxes in a DataSet object. How I can do it? Tag: Error Trapping dataAdapter.update Tag: 113166
  - 8
    - XML Partitioning hi, i have a problem , I have a database which inserts bulk of data onto the sql and oracle database from excel sheets , I was juss planning to create threadpools and activate multiple threads to insert data onto the database from the excel. i am thinking of creating a XML sheet for which first gets inserted from excel sheet and and from there use XML sheet to insert onto the database as we can never work efficiently with excel as with XML, Now i need to know...how can i partition a XML sheet , i mean i need to create 3 or more threads for a single process which partitions the process as 1st half and 2nd half and excutes two threads simultaneusly, I ll appreciate if u guys can help me in this Thanks Mahesh Manas Tag: Error Trapping dataAdapter.update Tag: 113157
  - 9
    - Executenonquery I have wrote this code and my DB server is Sql Server 2000 SP4 Dim cnSql as new SqlClient.SqlConnection Dim cmdSql As New SqlClient.SqlCommand cnsql="Data Source=ced2; User ID=sa; Password=;Initial Catalog=NGN;Persist Security Info=True;" cnsql.open cmdSql.CommandText = "create view VISTAGIACENZE as select codice,sum(giacenza) as Giacenza from giacenze where magazzino='001' or magazzino='500' group by codice" cmsql.connection=cnsql cmdSql.CommandText = strsql cmdSql.ExecuteNonQuery() When I try to execute method executenonquery Visual Studio return this error System.Data.SqlClient.SqlException - Incorrect syntax near the keyword 'VIEW'. It's very strange because executing the same string in query analyzer works fine without errors. Could you help me??? Thanks in advance. Antonio. Tag: Error Trapping dataAdapter.update Tag: 113152
  - 10
    - Sorting Child Tables in a Data View Hello folks This seems relatively quite easy but I cannot put my finger to it. I have a form with 5 tabs. I also have a dataset with 5 tables, (1 parent with 4 child). I have a data View of the dataset which is bound to the form. So my form has a listview, with first name & last name (in that sort order) so that they can be easily found. now on each tab, the records are sorted as they are entered (I guess by id). But what I want is, each tab, (which is bound to its respective child table which is in the same dataview), to be sorted based on another field. I can easily create another dataview and bind, but then I lose the binding, and when a record is changed on the main form, the records will not be changed in the tabs. So how do I do this ?! Thanks Tag: Error Trapping dataAdapter.update Tag: 113150
  - 11
    - Code for retrieving/updating data in Oracle database using ASP.NET Can anyone help me out from the above by giving a code snippnet including the import namespace directives. Regards/CS Tag: Error Trapping dataAdapter.update Tag: 113141
  - 12
    - Can someone please explain this behavior? I can't find any answers, I have no idea why this is happening. I have a dataset. In this dataset there are three tables RO ROParts, ROLabor ROParts and ROLabor are related to the RO table one to many relationship PKEY on RO is the RO#, ROLOC, RODATE these three fields are replicated in each of the child tables. The relationship works fine, however when I bind them to a data grid and drill to the child rows it includes all of the child fields plus all of the parent fields (in the same row as the child data). I am not sure why this is happening. Any thoughts? Tag: Error Trapping dataAdapter.update Tag: 113132
  - 13
    - Update MS Access Database Records First of all, thanks for the help on my previous VB.NET/MS Access questions. This time I need do the following 1. Connect to a table 2. step through each of its records 3. read the value of two of the records fields 4. pass those values to a function 5. write the value returned by the function the same record in a third field Hope this makes sense. Basically I want to read records and based on values of two of their fields I want to update another of their fields. Thanks Thomas -- Posted via NewsDemon.com - Premium Uncensored Newsgroup Service ------->>>>>>http://www.NewsDemon.com<<<<<<------ Unlimited Access, Anonymous Accounts, Uncensored Broadband Access Tag: Error Trapping dataAdapter.update Tag: 113131
  - 14
    - export dataset to excel I written myself some small generic class to export any dataset to an excel spreadsheet: public static void Export(DataSet data, String excelFileName) { System.IO.File.Delete(excelFileName); string strConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.IO.Path.GetDirectoryName(excelFileName) + @"\" + System.IO.Path.GetFileName(excelFileName) + @";Extended Properties='Excel 8.0;HDR=YES'"; using (System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(strConnectionString)) using (System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("", objConn)) { objConn.Open(); foreach (DataTable dt in data.Tables) { cmd.CommandText = "CREATE TABLE [" + dt.TableName + "] ("; String valueNames = "("; Boolean first = true; foreach (DataColumn dc in dt.Columns) { if (!first) { cmd.CommandText += ",\r\n"; valueNames += ", "; } cmd.CommandText += " [" + dc.ColumnName + "] NVARCHAR(100)"; valueNames += " [" + dc.ColumnName + "]"; first = false; } cmd.CommandText += ")"; valueNames += ")"; cmd.ExecuteNonQuery(); foreach (DataRow dr in dt.Rows) { String values = "("; first = true; foreach (DataColumn dc in dt.Columns) { if (!first) values += ", "; values += " '" + dr[dc] + "'"; first = false; } values += ")"; cmd.CommandText = "INSERT INTO [" + dt.TableName + "$] " + valueNames + " VALUES " + values; cmd.ExecuteNonQuery(); } } } } This does work quite ok for my uses, the only problem is: After export the first character in every single cell of the excel spreadsheet is the quotation mark ' Somehow the export does not strip the leading quotation marks from my values - anyone can give me a hint how I do get rid of these? thanks, Sam Tag: Error Trapping dataAdapter.update Tag: 113124
  - 15
    - DataReader and DataAdapter relation Hi All, I often get the same error when filling data adapter. There is already an open DataReader associated with this Connection which must be closed first myda.Fill(newds, "Employee") But the same type fill command is working in other forms without error. When filling data adapter it internally opens the executereader but it is not closing. How the OledbDataAdapter with fill works? When will it executes the reader. Why there is a difference in filling with datasets? Thanks in Advance ______________________________ S. Viswanathan Tag: Error Trapping dataAdapter.update Tag: 113109
  - 16
    - Constraint error when dataset.GetChanges() invoked I'm running into a puzzling exception when I attempt to update a modified row in a table with a foreign key constraint. System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints My application has a single dataset with five tables that gets loaded from an Access database. The error occurs along the way to propagating a (trivial) change back to the .mdb file, and _seems_ to be related to my attempt to update a single row of a single table (call it TableB) which has a foriegn key constraint pointing back to another table (call it TableA). These look like the following: TableA: pk_a (autonumber primary key) [other columns, none required] TableB: pk_b (autonumber primary key) pk_a (foreign key to TableA) [other columns, none required] These tables are loaded into a common DataSet which has been set up witht he following constraints for TableB: fkc_fd_pr = new ForeignKeyConstraint( "TableATableB", dataset.Tables["TableA"].Columns["pk_a"], dataset.Tables["TableB"].Columns["pk_a"] ); fkc_fd_pr.DeleteRule = Rule.Cascade; fkc_fd_pr.UpdateRule = Rule.Cascade; fkc_fd_pr.AcceptRejectRule = AcceptRejectRule.Cascade; dataset.Tables["TabelB"].Constraints.Add(fkc_fd_pr); The dataset then is filled: dataadapter.Fill(dataset,"TableA"); dataadapter.Fill(dataset,"TableB"); ...etc. The user edits the contents of TableB through a form with lots of TextBoxen. When he/she/it clicks on a [Save] button, the code goes through the following steps: - Prompt for confirmation (Are you ReallyReallySure(tm)?) - bindingmanager.EndCurrentEdit() - If dataset.HasErrors, exit the update procedure. - If dataset.HasChanges(), then - temp_dataset = dataset.GetChanges() The exception is raised in the middle to the GetChanges method, with a stack trace that looks like the following: (Exception message) at System.Data.DataSet.FailedEnableConstraints() at System.Data.DataSet.EnableConstraints() at System.Data.DataSet.set_EnforceConstraints(Boolean value) at System.Data.DataSet.GetChanges(DataRowState rowStates) at System.Data.DataSet.GetChanges() After spending some time checking my Access table definitions, and much more time getting Google-eyed trying to find someone else who had seen a similar problem, I patched my code to try to figure out exactly what was being objected to. I added code similar to the following right after the check for .HasErrors and before invoking .GetChanges(), and then issued a simple [Edit] [Save] (no actual changes) on TableB. DataTable dt1 = dsPgtDb.Tables["TableA"].GetChanges(); DataTable dt2 = dsPgtDb.Tables["TableB"].GetChanges(); DataTable dt3 = dsPgtDb.Tables["TableC"].GetChanges(); DataTable dt4 = dsPgtDb.Tables["TableD"].GetChanges(); DataTable dt5 = dsPgtDb.Tables["TableE"].GetChanges(); Those all executed flawlessly (although all but the "TableB" result were null). DataSet ds1 = dsPgtDb.GetChanges(DataRowState.Added); DataSet ds2 = dsPgtDb.GetChanges(DataRowState.Deleted); DataSet ds3 = dsPgtDb.GetChanges(DataRowState.Detached); DataSet ds4 = dsPgtDb.GetChanges(DataRowState.Modified); DataSet ds5 = dsPgtDb.GetChanges(DataRowState.Unchanged); The first three of these worked just fine (null results, but no ConstraintException). The fourth line, the one checking for Modified datarows, tripped the ConstraintException. Still no clue as to _why_ ADO.NET is unhappy, but at least it confirms that it _is_ the one row I "modified" (opened up for editing but made no changes to) which is being objected to. This row was happily loaded from the Access .mdb file into a DataSet with constraints already in place. So why, when it gets flagged as Modified, does GetChanges have a hernia trying to locate it in one DataSet and stuff a copy into a fresh, brand-spanking-new Dataset? Does anyone see any really obvious steps I'm leaving out that might contribute to the problem? Alternatively, can anyone suggest an approach for nailing down exactly _which_ constraint I'm rudely violating? Clues, hints, and suggestions will all be appreciated. I really don't have all that much hair left to pull out... <grin?> Frank McKenney, McKenney Associates Richmond, Virginia / (804) 320-4887 Munged E-mail: frank uscore mckenney ayut minds pring dawt cahm (y'all) -- It's not what we don't know that gives us trouble, it's what we know that ain't so. -- Will Rogers -- Tag: Error Trapping dataAdapter.update Tag: 113103
  - 17
    - Beating a dead Horse: Which Language Hi, I know that I'm an extreme newb by asking this overly beaten question, but I am leaning toward C#, becuase the perception is that it is better to learn than VB.Net. I guess it makes you cooler.:-) Anyhow, I am a novice programmer, and I will remain one as well...I have no plans to make programming my life ambition, but I think that it would be fun to make my databases do some cool tricks and maybe write a simplistic client to access the database over the LAN, and by internet as well. My programing will be centered around Data manipulation, i.e. collecting, sorting, and reporting on this data to myself..... I want to know which language you find most compelling to accomplish my mission. It may be that it doesn't have anything at all to do with the language, from my understanding they are close to equal, but everyone I come in contact with prefer C# over VB.net Please, NO FLAMES; just logic Thank you in advance! Tag: Error Trapping dataAdapter.update Tag: 113085
  - 18
    - So, how do I monitor *open* connections? I can look at performance monitor for pools, pooled connections etc. What I don't see is a way to tell, say, of the 25 pooled connections in the pool, how many are active and open. Anyone know of any tools for this? Any ideas? Anyone ... Tag: Error Trapping dataAdapter.update Tag: 113081
  - 19
    - DataSet not releasing memory Hello - I've developed an application which uses DataSets which are local to specific methods - so they should go out of scope when the form they are on is closed. I am finding that while monitoring the memory usage through task manager, the memory will increase while the dataset is filled, but memory is never released when the form is closed. Even when using the Dispose() method of the DataSet, as well as explicitly calling GC.Collect() and GC.WaitForPendingFinalizers(). After searching the web for hourse, I cannot find anyone who can solve this problem. Does anyone know how to fix this? Thanks, -Peter Tag: Error Trapping dataAdapter.update Tag: 113073
  - 20
    - Data design question I have a Windows Forms applications with a SQL Server back-end. There is a main form which shows a list of selected columns from a table (all rows are to be shown), and a dialog form which opens a detailed view of the selected record in the list and lets the user modify it; I'd also like to use the same dialog to add a new record, without rewriting the same code twice. The question is: what is the proper way to handle this? Possible solutions I've devised: 1) Using a query (SqlReader or DataSet + TableAdapter) to populate the list with all the needed data, then using the selected item index to get the table ID for the record; then passing the ID to the dialog form, which will create and populate an internal DataSet and act upon it; upon clicking "OK", it will save the modified DataSet to the DB (if any modifications were made). A special ID value (-1 ?) will be used to mean "create a new record and save it if the user clicks "OK". The DataSet will be discarded as soon as the dialog form closes. 2) Same as 1), but the DataSet will be populated inside the main form and passed to the dialog form; the form will modify it (eventually), and return it back to the main form, wich will save it or reject it based on DialogResult. This approach lets me populate it with a new row and pass it to the dialog, so there is no need to handle special cases in the dialog form. The DataSet will be created, filled and then discarded each time. Both of these approaches work on single rows of data, which are to be extracted from the DB upon request; but the whole amount of data will be relatively small (one or two hundreds of records, at most), so I thought it could also make sense to fully read it, put it in a DataSet and work with it, saving modifications when they're made; so, here's approach 3: 3) Fill a DataSet with all the data, including detailed data not shown on the main form; manually build the main list with the required info (which is to be built manually anyway, since some columns are to be grouped into text rows) and use it to select the row to modify; upon clicking the "Modify" button, pass the DataSet object and the row ID (which is easy to obtain since the whole table is available in the DataSet) to the dialog form; when clicking "New" instead of "Modify", add a new row to the DataSet and pass its ID to the form. When the user clicks "OK", save the data back to the DB and do a DataSet.AcceptChanges(); otherwise, if "Cancel" is clicked, do a DataSet.RejectChanges(). This seems to be the better approach, but there are some points I don't quite understand. First: I can't do AcceptChanges() or RejectChanges() inside the dialog form, since the main form would be unable to know if rows where modified; so, I must either save the changes inside the dialog form (which I don't want to do, since DB update logic doesn't belong there as in #1) or have the main form guess what happened using DialogResult; this last one seems OK, but is this good OO practice? The form receives a DataSet, shouldn't it be its responsibility to modify it or leave it untouched? Can I solve this using EndEdit() or CancelEdit() on the single row? Second: what happens if the user clicks "New" and then decides he doesn't want to add a new record and clicks "Cancel"? Will RejectChanges() delete the new row, or should I manually handle this? More generally: will RejectChanges leave the DataSet exactly as it was when the last AcceptChanges() was called? Side question: I have to use the same approach (main form with summary data, dialog form with detailed data) in some other parts of the application; again, the whole database will be quite small (maybe five tables, at most one-two hundred records each, plus some smaller ones (10-20 records)); also, some of these tables are linked with relations, which I'd like the program to enforce before trying to update the DB. Will it be a good design to put all of the tables into one big DataSet, fill it and use it as in #3? What is the practical limit for using a single DataSet, and when is it better to partially fill small ones with ad hoc queries? Thanks for any suggestion. Massimo P.S. I'm using Visual Studio 2005 beta with SQL 2005, so the framework version is 2.0; I don't think this should be of any relevance to this design question, but if the new framework offers better approaches than the other ones, feel free to let me know :-) Tag: Error Trapping dataAdapter.update Tag: 113071
  - 21
    - SQL server 2000 transation deadlock in a cluster environment hi all got a situation here, there are 3 app server that are running this application to delete records in the sql server periodically. what happen is that they all start up at the same time.(this could be fixed by varying the start up time on each app server for that application, but it's not a good solution.) to delete records on the same table. so there is: transaction (process ID #100) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction." now I have read some article online saying putting a "with (UPDLOCK)" after the FROM <some table> will fix the problem. does anybody have the similar experience? what would be a perfect fix? thx Kevin Tag: Error Trapping dataAdapter.update Tag: 113070
  - 22
    - A quick question: How to use variables in the SQL insertion string Hello, I am new to ADO.NET and SQL. What I am trying to do is very basic - to insert some variable values into database. The following is the C# code: private static void InsertIntoSqlDb(OleDbDataReader reader) { string insStr = ""; string list_no = reader.GetString(0); string item_no = reader.GetString(1); string description = reader.GetString(2); string priceStr = reader.GetString(3); insStr = "INSERT INTO dliTestDb (list, item, description, price) VALUES (list_no, item_no, description, priceStr)"; SqlCommand cmd = new SqlCommand(insStr, conn); //Insert // try { cmd.ExecuteNonQuery(); } catch(Exception ex) { Console.WriteLine(ex); } } Upon execution of the above, I got exception: System.Data.SqlClient.SqlException: The name 'list_no' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names ar e not permitted. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() Doesn't any one know how to use variable names exactly in the SQL insertion string? Thanks. Tag: Error Trapping dataAdapter.update Tag: 113069
  - 23
    - Time is Stripped off When Saving DateTime to MS Access All, Using C# with ADO.NET I am trying to save a date time to an Access database. After the saving occurs I open Access database and only see the date not the time. I know the time was part of the DateTime object prior to saving it. Also while in Access I tried changing the format of the date time field to see the time, which showed it as 12:00 AM and is incorrect. See code snippet below: DataRow newRow = dataSet12.Table1.NewRow(); newRow["Index"] = 5; newRow["Column1"] = "Added"; newRow["MyDateTime"] = DateTime.Now; // <== Time is in object dataSet12.Table1.Rows.Add(newRow); Does anyone know who to have the time saved ad well? Thanks in advance for any help. Scott Tag: Error Trapping dataAdapter.update Tag: 113059
  - 24
    - need help on basic save!!! I am having some problems with getting squgglie lines under stringbuilder and ConfigurationSettings what am I doing wrong, is this even close to working? help. ------------------------------------------------------------------------------------ Imports System Imports System.Data Imports System.Data.SqlClient Imports Microsoft.VisualBasic Public Class Locations Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Private Sub Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click Dim mySQLConnection As New SqlConnection(ConfigurationSettings.AppSettings("DSN")) Dim strSQLCommand As New StringBuilder, mySQLCommand As SqlCommand strSQLCommand = New StringBuilder With strSQLCommand .Append("INSERT INTO Locations (Loc_Name, Address, ContactName, Phone) ") .Append("VALUES ('" & txtName.Text & "', '" & txtAddress.Text & "', '" & txtContactName.Text & "', '" & txtPhone.Text & "');") End With mySQLConnection.Open() mySQLCommand = New SqlCommand(strSQLCommand.ToString, mySQLConnection) mySQLCommand.ExecuteNonQuery() mySQLConnection.Close() End Sub End Class -- -- Adam S Tag: Error Trapping dataAdapter.update Tag: 113054
  - 25
    - Unable to reconnect to SQL Server after the server is restarted I am using C#, SQL Server 2000 and ADO.NET in my application. The Database Server and the application are running on seperate physical machines. If the database server and the application lose connection (possibly because the server was restarted, or a network failure of some sort) the application fails to re-connect. The application will periodically attempt to re-connect to the server. It seems that I am unable to connect for a period of time after the server is restarted. I receive the error message "SQL Server is unavailable or access is denied". I have seen this error message for as long as 45 minutes after the server has been restarted. Does anybody have any ideas on the cause of this? I am using connection pooling with the default connection pool size. Sample code is provided below. Thanks in advance for your help, Trevor SqlConnection conn = new SqlConnection( conString ); if ( waitForConnection && AllowWaitForConnection ) { // Retry the connection to the database periodically until successful while ( conn.State != ConnectionState.Open ) { try { conn.Open(); } catch ( SqlException e ) { conn.Close(); ThreadSupport.Sleep( connectionRetryInterval ); } catch ( InvalidOperationException e2 ) { conn.Close(); ThreadSupport.CheckAbort(); } } } else { ... } Tag: Error Trapping dataAdapter.update Tag: 113052
- Next
  - 1
    - Pivoting DataSet- Hyperlinkcolumn+Sorting http://weblogs.sqlteam.com/jeffs/articles/5091.aspx provided an excellent insight for pivioting DataSet. As things stand, the example could happily pivot Something SQLServer returns as: frmInstanceID frmName Department Status 1 formA IT Complete 2 formB IT Complete 3 formC IT Incomplete 4 formA HR Missing 5 formB HR Inomplete 6 formC HR Complete with the invocation of Pivot(dataReader,"frmInstanceID","frmName","Status"), pivotted data into frmInstanceID Department formA formB formC 1 IT Complete 2 IT Complete 3 IT Incomplete 4 HR Missing 5 HR Incomplete 6 HR Complete What I really really want is: Department formA formB formC IT Complete Complete Incomplete HR Missing InComplete Complete With each of the form status being a hyperlink with the frmInstanceID as a parameter: e.g. <a href="showStatus.aspx?id=7">Complete</a> I managed to "fool" the system into displaying the above with the invocation of Pivot(dataReader,"Department","frmName","Status") (i.e. changing the keyColumn parameter to the Pivot method). Could someone assist with helping me set a hyperlink column and managing sorting with this example at http://weblogs.sqlteam.com/jeffs/articles/5091.aspx ? Many Thanks Tag: Error Trapping dataAdapter.update Tag: 113047
  - 2
    - clear connection pooling i face prob. of connection pooling, i want to know how to clear the pool size in ado.net, i know that there is a facility in ado.net to clear the max pool size, Any one can give me the code about that. thanks. *** Sent via Developersdex http://www.developersdex.com *** Tag: Error Trapping dataAdapter.update Tag: 113042
  - 3
    - Concurrency violation where there shouldn't be one I have the following error message and I can't see where in code it could of came from or what could of caused it. It happened randomly for one of our users and no one else ever, and I am unable to reproduce it at all. System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 records. Now this was caused during the update method of a data adapter that is tied to a table alled Categories... On the form where the data entry takes place we have a brand new record called coverage, This is stored in the dataset's coverage table. At this point this is in thet table as a new record with a uniquely generated ID Primary key that gets changed when the dataset is updated to the database (that part works fine, SQL Server returns the new ID and the local dataset updates approperiatly to match)... the problem though seems to of occured on the referenced table Categories... This table has records that are dynamically generated based on what a user checkes in a check listbox. So if the user unchecks an item, the corresponding record is removed from the datatable in teh categories table, if they check one a record gets added... here is an example piece of code... Private Sub chklstCategories_ItemCheck(ByVal sender As Object, ByVal e As System.Windows.Forms.ItemCheckEventArgs) Handles chklstCategories.ItemCheck ' update dataset in memory to reflect changes If Me.b_refillingData = False Then Select Case e.NewValue Case CheckState.Checked Dim dr_catItem As DataRow = ds_formData.Tables("CoverageJunCategories").NewRow If Me.fs_FormViewState = bdb.Business.FormStates.AddNew Then 'dr_CoverageRow dr_catItem("coverageid") = Convert.ToInt32(dr_CoverageRow("CoverageID")) Else dr_catItem("coverageid") = Convert.ToInt32(Me.lstvCoverages.SelectedItems(0).Tag) End If dr_catItem("categoryid") = DirectCast(Me.chklstCategories.Items(e.Index), CategoryItem).ID ds_formData.Tables("CoverageJunCategories").Rows.Add(dr_catItem) Debug.WriteLine(ds_formData.Tables("CoverageJunCategories").Rows.Count) Case CheckState.Unchecked Dim rowKeys(1) As Object If Me.fs_FormViewState = bdb.Business.FormStates.AddNew Then rowKeys(0) = Convert.ToInt32(dr_CoverageRow("CoverageID")) Else rowKeys(0) = Convert.ToInt32(Me.lstvCoverages.SelectedItems(0).Tag) End If rowKeys(1) = DirectCast(Me.chklstCategories.Items(e.Index), CategoryItem).ID Dim dr_catitem As DataRow = ds_formData.Tables("CoverageJunCategories").Rows.Find(rowKeys) dr_catitem.Delete() Debug.WriteLine(ds_formData.Tables("CoverageJunCategories").Rows.Count) End Select End If End Sub as you can see this is a junction table which joins the list of categories and the list of coverages together.. In our dataset we also have the coverages and this table referenced like this ds_formData.Relations.Add("CoveragesJunCategories", ds_formData.Tables("Coverages").Columns("CoverageID"), ds_formData.Tables("CoverageJunCategories").Columns("CoverageID")) to me this code all seems to be correct, but I can't figure out what is wrong... prior to this we were getting a "Missing update command" error for the data adapter that handles the coveragesjuncategories table's... I figured since all I was doing was adding and removing rows I only would need a Select, Insert, and Delete command... Since it seemed like no real updateing was occuring (unless when coverages gets its new primary key from the server when a coverage row is created, it changes the category junction's table also since they are referenced together with a primary/foreign key, but if this is a update how would the row be created to start with? just a little confused on the procedure for a new row in one table that references a new row in another when the primary key gets updates on the parent, what happens to the row the foreign key is on is it still an insert or is it now an update (i assumed insert because the row does not exist yet in the database only locally in the data table since the update method as not been called yet on the categorys junction table (child table) but only on the coverages one (parent table))... anyone that can help me out would be great! thanks! Tag: Error Trapping dataAdapter.update Tag: 113040
  - 4
    - concurrency violation where it makes no sense to have one I recieved the following error pretty much randomly (haven't been able to reproduce it or see what caused it in code at all) Tag: Error Trapping dataAdapter.update Tag: 113039
  - 5
    - =?Utf-8?Q?Is_there_a_way_to_set_=22Jet_OLEDB?= Hi, I'm using OleDb Provider for Jet and ADO.NET to connect to an Access 2000 Database. My application spans various transactions and issues various commits in sequence to this database (physically on a network share). Right after a transaction is committed I need to read the information on the database. The fact is that the commit "still not committed" in my next read. I recently discovered that Jet works by default in asynchronous mode. To guarantee the commit, I need to set the provider specific option â??Jet OLEDB:Transaction Commit Modeâ?? to 1. The problem is that I canâ??t find a way to do that in ADO.NET. The KB article 318161 says thatâ??s not possible. Could someone confirm that itâ??s really not possible? Thanks. Tag: Error Trapping dataAdapter.update Tag: 113027
  - 6
    - Dynamically Populating a SqlParameter object I'm using the SqlHelper object model from MDAAB, which requires that I pass in a SqlParameter object if I have more then parameter when calling a Stored Procedure. My current code seems verbose in the setup of this parameter and I'm trying to figure out if there is a better approach to populate this object. Here is a sample in VB that uses SqlHelper to call a Stored Procedure: Public Shared Sub GatewayRecordCreate(ByVal GatewayName As String, _ ByVal ResponseString As String, _ ByVal UserEmail As String, _ ByVal TranAmount As String) ' Public Consts used to store element position in String Array, used in other classes Const PositionGatewayName As Short = 0 Const PositionResponseString As Short = 1 Const PositionUserEmail As Short = 2 Const PositionTranAmount As Short = 3 Const PositionMaxElement As Short = 3 Dim returnVal(PositionMaxElement) As String ' String Array returned by function Dim parms() As SqlParameter = New SqlParameter(PositionMaxElement) {} 'Used to hold Details from DB ' @GeneratedBy Input Parameter parms(PositionGatewayName) = New SqlParameter("@GatewayName", SqlDbType.VarChar, 200) parms(PositionGatewayName).Direction = ParameterDirection.Input parms(PositionGatewayName).Value = GatewayName ' @ResponseString Output Parameter parms(PositionResponseString) = New SqlParameter("@ResponseString", SqlDbType.VarChar, 5000) parms(PositionResponseString).Direction = ParameterDirection.Input parms(PositionResponseString).Value = ResponseString ' @UserEmail Output Parameter parms(PositionUserEmail) = New SqlParameter("@UserEmail", SqlDbType.VarChar, 100) parms(PositionUserEmail).Direction = ParameterDirection.Input parms(PositionUserEmail).Value = UserEmail ' @TranAmount Output Parameter parms(PositionTranAmount) = New SqlParameter("@TranAmount", SqlDbType.VarChar, 20) parms(PositionTranAmount).Direction = ParameterDirection.Input parms(PositionTranAmount).Value = TranAmount ' Call ExecuteNonQuery static method of SqlHelper class ' Pass in database connection string, command type, stored procedure name and an array of SqlParameter object SqlHelper.ExecuteNonQuery(Global.ConnectionString, CommandType.StoredProcedure, "spGatewayTranInsert", parms) End Sub My primary goal is to improve the code so that I don't have to setup Constants and hard code the PositionMaxElement value which is used SqlParameter object. Any thoughts? Please post or point to VB source code if you are replying. I learn best by example. Thanks. Tag: Error Trapping dataAdapter.update Tag: 113025
  - 7
    - The asp services blocked I have a problem about asp.net and databases in Access. Every time the asp service is blocked. When this happens i must phone to my ISP provider of hosting in order to begin the service again. The tell me it is a problem of access with asp.net. ¿How can i solution it? I detail below the connection line of the web.config, maybe I am doing wrong. Thank you very much. <add key="Connection" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\bd\bd1.mdb;Persist Security Info=True" /> Tag: Error Trapping dataAdapter.update Tag: 113020
  - 8
    - debug suggestion for connection pool problem with Oracle using daa Hi We have a asp.net web application with oracle 9.1. Data access layer we use is DAAB 2.0. We use connection pool and set max pool size = 150. But we always get the following error almost every month ( we have to restart web server to make it work): Timeout expired, The timeout period elapsed prior to obtaining a connection from the pool. This may have occured becasue all pooled connections where in use and max pool size was reached. As many perople said, after I went though whole implementation, I did not find any connections we did not close. Anyone have good advice for how to debug such issue? or recommend some tool? I have seen lots of similar questions and topics, and found many answers are extremely confused. Can anyone make clear for my some questions? 1. We use USING to dispose connection and OracleDataReader in most cases, but also there are some exceptions, we use close() to close connection in Catch block of try-catch. here is example: ============================================== OracleConnection cn = new OracleConnection(connectionString); cn.Open(); try { return ExecuteReader(cn, null, commandType, commandText, commandParameters, OracleConnectionOwnership.Internal); } catch { cn.Close(); throw; } ========================================== Is anything wrong for these pieces of code? 2. In many cases, we opened connection in one function, and call another to process the real operation of DB., example: =================================================== using (OracleConnection cn = new OracleConnection(connectionString)) { cn.Open(); return ExecuteNonQuery(cn, commandType, commandText, commandParameters); } =================================================== if ExecuteNonQuery() got exception, the USING still can dispose connection? 3. =================================================== using(OracleDataReader r = OracleHelper.ExecuteReader(ConnectionManager.GetConnStr(), CommandType.Text, sql.SQLString, pa)) { ArrayList al = QueryResultsParser.Parse(r, request); r.Close(); //Force the OracleDataReader to be closed return al; } ==================================================== (we have add For these pieces of code, we use datareader to get data, I wonder: 1. is it necessary we explicitely close the datareader? 2. if answer yes for 1., and if OracleHelper.ExecuteReader() falied, does it mean we cannot close connection? 4. for some objects, do we need to displose them as soon as it is not used? example: ================================================= OracleCommand cmd = new OracleCommand(); PrepareCommand(cmd, connection, (OracleTransaction)null, commandType, commandText, commandParameters); //create the DataAdapter & DataSet OracleDataAdapter da = new OracleDataAdapter(cmd); DataSet ds = new DataSet(); //fill the DataSet using default values for DataTable names, etc. da.Fill(ds); cmd.Dispose(); da.Dispose(); ======================================= Tag: Error Trapping dataAdapter.update Tag: 113017
  - 9
    - datagrid webcontrol in C# Hi, I just have a simple question regarding dataGrid in ADO.NET. I developed the web application by ASP.net and C#. I want to implment a dataGrid for the product list. The product list display the product name, size, type, price .... But for the specfic product category, its size column may not has any data. So i want to write the code in back-end by C# to determin whether every item in the size column in dataGrid has data. How I can write it in C# ? is there methods I can use to determin every item in size column contains data ? Thank you, H. Tag: Error Trapping dataAdapter.update Tag: 113016
  - 10
    - Add Record to MS Access Database Is there anyone that knows how to add a record to a MS Access database with VB.NET. I have search for 3 days for some code that works. I have gathered bits and pieces of code and put it together, but I have not found a solution that works. If anyone has some code that works please reply. Thanks Thomas The following gives an Invalid SQL Statement at: oAdapter.Update(ds, "LCMR") Dim oAdapter As OleDb.OleDbDataAdapter Dim cb As OleDb.OleDbCommandBuilder Dim dr As DataRow Dim ds As DataSet Dim strSQL As String = "Select * from LCMR" Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & strAppPath & "TAM.mdb;Persist Security Info=False" ds = New DataSet() oAdapter = New OleDb.OleDbDataAdapter(strSQL, strConn) oAdapter.Fill(ds, "LCMR") Try dr = ds.Tables("LCMR").NewRow() dr.BeginEdit() dr("ID") = 1000 dr("ADate") = "6-JUN-5" dr("ATime") = "01:00" dr("POO") = strPOO dr("POO_Alt") = 22 dr("POI") = strPOI dr("POI_Alt") = 22 dr("Distance") = 1000 dr("Direction") = 100 dr("Target_NO") = "KT1001" dr("Weapon Type") = "sasdf" dr("Confirmed") = 1 dr.EndEdit() ds.Tables("LCMR").Rows.Add(dr) cb = New OleDb.OleDbCommandBuilder(oAdapter) oAdapter.InsertCommand = cb.GetInsertCommand oAdapter.Update(ds, "LCMR") ds.AcceptChanges() Catch oException As Exception MessageBox.Show(oException.Message) End Try -- Posted via NewsDemon.com - Premium Uncensored Newsgroup Service ------->>>>>>http://www.NewsDemon.com<<<<<<------ Unlimited Access, Anonymous Accounts, Uncensored Broadband Access Tag: Error Trapping dataAdapter.update Tag: 113008
  - 11
    - Oracle transaction rollback problem I have problem with transaction. When I try to rollback transaction commit happend and record is updated. Can anybody tell me, where I made a mistake. Thanx, S. Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types private sub mWriteOnOra() Dim inFile As System.IO.FileStream Dim binaryData() As Byte inFile = New System.IO.FileStream(p_datoteka, _ System.IO.FileMode.Open, _ System.IO.FileAccess.Read) ReDim binaryData(inFile.Length) Dim bytesRead As Long = inFile.Read(binaryData, _ 0, _ inFile.Length) inFile.Close() Dim cnStr As String = "Data Source=Oracle8i;User ID=" & gsUser & ";Password=" & gsPwd & ";Data Source=" & gsDs & ";" Dim sErr As String Dim cn As OracleConnection Dim myTrans As OracleTransaction Dim cmd As New OracleCommand("SP_LOAD", cn) cmd.CommandType = CommandType.StoredProcedure With cmd.Parameters .Add("BLOB_LOAD", OracleDbType.Blob, binaryData.Length, ParameterDirection.Input).Value = binaryData End With Try cmd.ExecuteNonQuery() myTrans.Rollback() ' file shouldn't be in the table, but it is there ' myTrans.Commit() Catch ex As Exception myTrans.Rollback() DoLog(1, ex.Message) Finally If cn.State <> ConnectionState.Closed Then cn.Close() End Try end sub Tag: Error Trapping dataAdapter.update Tag: 113005
  - 12
    - Query Result Paging with different Ordering Hi, I have posted to multiple groups - I hope this is ok. For the past week or so I have been trying to find out how to perform a search against SQL Server, and have the results sorted on a choice made by the UI (ASP.NET), and supports paging. I have trawled the net a number of times, and have spent hours looking through peoples examples which just dont seem to cut it, due to all their caveats. Can someone offer good, useful links on how I can do this type of functionality? Vry much appreciated, after so much reading and playing I am still little further forward. I am not a DB person, which is causing part of the problem. Thanks j.r Tag: Error Trapping dataAdapter.update Tag: 113003
  - 13
    - problem in uploading and downloading files from DB in ASP.Net hi, Can anybody tell me that thru asp.net using c#, how can we upload and download physical files in any table of SQL Server Database. the uploading part is running successfully but the problem arises in the retriving part of the code. i am not getting that how will i able to download the file which is there in the SQL Server database in the field type "image". here is the code by which i am uploading any file to the my SQL Server database private void btnUpload_Click(object sender, System.EventArgs e) { HttpPostedFile filPosted = filUpload.PostedFile; int intFileLength = System.Convert.ToInt32(filPosted.ContentLength); byte[] byteData = new byte[intFileLength]; filPosted.InputStream.Read(byteData, 0, intFileLength); Conn.OpenConnection(); string sql="Insert into HRRecruitmentMaster(CandidateName,HighestQualificationID,JobFieldID,TotalExperienceInYears,CandidatePresentLocation,FileName,CandidateResume,type,length) Values (@CandidateName," + cmbHighestQuali.SelectedValue + "," + cmbJobField.SelectedValue + "," + txtTotalExp.Text + ",'" + txtPresentLoc.Text + "',@FileName,@CandidateResume,@Type," + intFileLength + ")"; SqlCommand Cmd = new SqlCommand(); Cmd.CommandText=sql; Cmd.Connection =Conn.Cn; Cmd.Parameters.Add("@CandidateName",txtCandidateName.Text) Cmd.Parameters.Add("@FileName",System.IO.Path.GetFileName(filPosted.FileName)) Cmd.Parameters.Add("@CandidateResume",System.Data.SqlDbType.Image,intFileLength); Cmd.Parameters["@CandidateResume"].Value=byteData; Cmd.Parameters.Add("@Type",filPosted.ContentType); Cmd.ExecuteNonQuery(); Conn.CloseConnection(); } so pls. help me out in this matter i'll be very much grateful to u Regards Himanshu Saxena Sahara India India Tag: Error Trapping dataAdapter.update Tag: 113001
  - 14
    - Using UPDATE I con't write the dataset back to datasource It works fine with the datagrid but with the sqlAdapter. Here is the code I was using. if State is always undefined. so it skips the logic, but the Textboxes hold the changed information. I am learning, please advise. Thanks Tag: Error Trapping dataAdapter.update Tag: 112995
  - 15
    - ODBC Data Sources Hi All, Is there a method that I can call to return a list of available database drivers? If so, is there then a way to get the list of fields that are required for those the database drivers? L. Tag: Error Trapping dataAdapter.update Tag: 112989
  - 16
    - TNSPING Doesn't Do Much I have TNSPING on my Windows laptop, ver 8.1.7.3.0. It was showing good when the database was down for maintenance. Looking at the output, it doesn't appear to be sending a SID as the later versions do. Is this so? If so, then its just checking for a port? Won't it miss a large class of outages? Thanks. Tag: Error Trapping dataAdapter.update Tag: 112985
  - 17
    - Connection Won't Die Application - give Oracle DB connection status on an ongoing basis Technique--thread is fired off by a timer every minute. It attempts to open a connection. It catches an open error as a failure, and otherwise indicates success. It then disposes the connection and ends. The status indicated seems to be good the first time. However, subsequently, it seems to get stuck in the old status, and doesn't always see the connection as transitioning to good from bad or vice-versa. Here's a snippet --- private void testDev(Object state) { try { oracleConnection1.Open(); oracleConnection1.Dispose(); devStatus.ForeColor = Color.Green; devStatus.Text = "DEV UP"; devErrorTxt.Text = ""; } catch (Exception e) { errorMsg = e.Message.ToString(); try { oracleConnection1.Dispose(); } catch (Exception e2) { errorMsg += (" Dispose: " + e2.Message.ToString()); } devErrorTxt.Text = errorMsg; failureMode = true; devStatus.ForeColor = Color.Red; devStatus.Text = "DEV DOWN"; } TimerCallback timerDelegate = new TimerCallback(testDev); t = new System.Threading.Timer(timerDelegate,null,60000,-1); } Suggestions?? Tag: Error Trapping dataAdapter.update Tag: 112982
  - 18
    - Convert _Recordset to DataSet/DataTable I have a Visual C++ .NET function that is calling an unmanaged function that returns an ADO _Recordset* object. I want to be able to convert that into an ADO.NET DataSet (or DataTable). I tried to use the OleDbDataAdapter.Fill method, but I could only get that to work if I gave it an ADODB::RecordsetClass object. I couldn't figure out how to get an ADO _Recordset into an ADODB::RecordsetClass. Any ideas? I don't want to have to rewrite all of our existing unmanaged code. - Brad Tag: Error Trapping dataAdapter.update Tag: 112981
  - 19
    - There is a way to set "Jet OLEDB:Transaction Commit Mode"? Hi, I'm using OleDb Provider for Jet and ADO.NET to connect to an Access 2000 Database. My application spans various transactions and issues various commits in sequence to this database (physically on a network share). Right after a transaction is committed I need to read the information on the database. The fact is that the commit "still not committed" in my next read. I recently discovered that Jet works by default in asynchronous mode. To guarantee the commit, I need to set the provider specific option â??Jet OLEDB:Transaction Commit Modeâ?? to 1. The problem is that I canâ??t find a way to do that in ADO.NET. The KB article 318161 says thatâ??s not possible. Could someone confirm that itâ??s really not possible? Thanks. Tag: Error Trapping dataAdapter.update Tag: 112977
  - 20
    - Could not find installable ISAM Using William Ryan's articles as a guide (excellent help, is William) I am trying to connect to my Excel data source. However, I am running into a "Could not find installable ISAM." error message trying to connect to the datasource. Does anyone have any tips as to how this is overcome? Thanks! Tag: Error Trapping dataAdapter.update Tag: 112975
  - 21
    - How DataRelation object is updated After the VS 2003 creates a strongly typed DataSet object that contains a couple of tables and serveral many-to-may data relations among all the tables, and the data got populated, I am wonder how the DataRelation object of the DataSet object is updated when some new rows are added to some of the tables. Do I have to update the relation of the added rows or in somewhere the relations are added automatically? Can someone explain this for me or point me to some resources? Thanks a lots. Tag: Error Trapping dataAdapter.update Tag: 112967
  - 22
    - ADO or String.Format bug ? ...... Hi It seems that String.Format method, when use a ***ZERO VALUE*** object coming from a SqlDataAdapter Fill method works fine, while if the same query is runned using an SqlDataReader ExecuteReader method, the formatted result is wrong .... For my tests i've used the Sql Server 2000 Northwind database and i've updated the Orders.Freight Column to zero (UPDATE Orders SET Freight=0). My general objective is to format all significative decimal values (value > 0)using a mask: #####0.00 and format all zero values using another mask: #####.##. This is obtained with: String.Format("{0:#####0.00;-#####0.00;######.##}", VALUE-TO-FORMAT) The VALUE-TO-FORMAT is obtained either using a server-side cursor (DataReader) and a client-side cursor (DataTable). In the first case it display ",00" (!!! ???) .... ... while using a DataAdapter it (correctly) display "" ..... The complete VB.net code is the following: ============================================================================= Dim Cn As New SqlClient.SqlConnection("uid=sa; pwd=; database=northwind; server=xdev99") Dim Cmd As New SqlClient.SqlCommand("SELECT Freight FROM orders", Cn) Cn.Open() Dim Dr As SqlClient.SqlDataReader = Cmd.ExecuteReader If Dr.Read Then Console.WriteLine(String.Format("{0:#####0.00;-#####0.00;######.##}", Dr.Item("Freight"))) End If Dr.Close() Dim Dt As New DataTable Dim Da As New SqlClient.SqlDataAdapter("SELECT 0 FROM orders", Cn) Da.Fill(Dt) If Dt.Rows.Count > 0 Then Console.WriteLine(String.Format("{0:#####0.00;-#####0.00;######.##}", Dt.Rows(0).Item("Freight"))) End If Cn.Close() ============================================================================== What's your idea ? Thanks. Nicola. Tag: Error Trapping dataAdapter.update Tag: 112963
  - 23
    - "Object is no longer valid" exceptions Hi, we have a .NET application that uses ADOMD to query a MS analysis OLAP cube. In a typical query, we get data for about 3 dimensions (800 x 15 x 2 entities) and then iterate over the resulting cell set to extract information. Occasionally, we see "Object is no longer valid" exceptions being thrown. The object (whose access usually throws this error) is of the type "ADOMD.Position". Sometimes the error appears while executing Cell.Get_Item(). We have a mechanism to retry the query if these exceptions are thrown in a (vain) hope that on the retry the whole thing will go off successfully. This works sometimes, but not always, so this isn't satisfactory. Does anyone have any idea why this would be happening? Is this something to do with garbage collection? Are there any workarounds/fixes? I would be grateful to know. Thanks, Ramanand [P.S. Apologies if this is the wrong newsgroup for purely ADOMD queries] Tag: Error Trapping dataAdapter.update Tag: 112957
  - 24
    - connection question I'm getting an error while running an aspx page on a production server. The error is that either the server can not be found or the access is denied. The following code fails at line 36. Line 34: str = "Driver={SQL Server};server=sallyserver;database=school;uid=www_intra;pwd=www_intra" Line 35: C.ConnectionString = str Line 36: C.Open() Line 37: Dim R As New ADODB.Recordset Other aspx pages that don't talk to the data server run correctly. The same page run on the development PC (WinXp Pro) connects and dispays the data correctly. (SQL server is on another box) If I alter the code to run in an Access 2000 database on the same production server, it runs correctly. Thus I'm not sure how to go about getting this up and running. Any thoughts would be appreciated. Cheers Mike Tag: Error Trapping dataAdapter.update Tag: 112936
  - 25
    - MSDE, ASP.NET, Visual Studio .NET, and connectionstrings I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I have created an empty database using Visual Studio .NET's Server Explorer. However, I am having trouble connecting to the database using ASP.NET. I think the problem is somewhere in my connection string, but because I do not know much about connection strings, I am not sure what it should look like. Can someone please help me determine what my connection string should look like? I am using the version of IIS that comes with XP Pro. Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: Error Trapping dataAdapter.update Tag: 112929

I have a data grid that keeps changes on a post back but does not persist the
changes to the underlying database. I dropped a sqlconnection and
sqldataadpater control at design time on to an ASP.NET page.
Here is my code:

Try
dataAdapter.Update(dataSet, "table")
Catch ex as sqlException
sError = ex.Message
End Try

Stepping through the code does not generate any errors. How can I find out
the reason the data does not save to the database? Any suggestions will be
appreciated.

Dan

Top

Re: Error Trapping dataAdapter.update by Miha

Miha
Wed Jun 29 03:36:14 CDT 2005

Hi,

"DLS" <DLS@discussions.microsoft.com> wrote in message
news:449F28BD-F3C6-40EB-803B-5DCFDF1BCABB@microsoft.com...
>I have a data grid that keeps changes on a post back but does not persist
>the
> changes to the underlying database. I dropped a sqlconnection and
> sqldataadpater control at design time on to an ASP.NET page.
> Here is my code:
>
> Try
> dataAdapter.Update(dataSet, "table")
> Catch ex as sqlException
> sError = ex.Message
> End Try
>
> Stepping through the code does not generate any errors. How can I find out
> the reason the data does not save to the database? Any suggestions will be
> appreciated.

It is probably your table that doesn't have any suitable rows for update
(RowState == DataRowState.Unchanged).
You might try looking at dataSet.GetChanges() - it returns you all rows that
are pending update.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

Top