Operation must use an updateable query

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
    - Could not determine which columns uniquely identify when i try to use the DataAdapter wizard and use a view instead of table i get this error. any help that can solve this problem? thanks in advance Tag: Operation must use an updateable query Tag: 76568
  - 2
    - Reading Excel via ADO.Net: IMEX=1 ignored when HDR=Yes I noticed that when I tried to use ADO.Net to read an Excel workbook (actually a Named Range called Data) that includes headers (thus HDR=Yes), I notice that a purely numeric value in the first column is treated as a Double, despite being told (via IMEX=1) to treat all columns as Text. Is this a bug? Broken As Designed (B.A.D.)? Or am I not interpreting the meaning of IMEX=1 correctly (W.A.D.)? My only work-around was to open up the Excel workbook, put an 'X' in front of the number in the first nine rows, add code to strip it back out (stringVar.Remove(0,1)), which seemed to fool ADO.Net into treating the column as pure Text instead of a Double. A portion of the connect string: Extended Properties="IMEX=1;HDR=Yes;" Tag: Operation must use an updateable query Tag: 76562
  - 3
    - OleDbCommandBuilder Isnt Building... I am trying to write to a text file using JET and ADO.NET, however I am getting the "syntax error in insert into statement" even though my column names are all original. I think the problem is with the OleDbCommandBuilder as when I build an INSERT statement for the OleDbCommand manually it writes successfully to the text file. Is this a known problem? Here are my details; Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\Aurora\bin\Data\;Extended Properties=Text;Persist Security Info=False [Body for Tesco Events.prn] Format=FixedLength Col1=Event Text Width 6 Col2=Junk Text Width 2 Col3=Description Text Width 29 Col4=Type Text Width 1 Thanks, Robby Tag: Operation must use an updateable query Tag: 76558
  - 4
    - Deployment,ADO.net and paths (what's best/preferred method?) Hi there. I am working on a large project (for me, anyway) where I am creating many connections/adapters to an Access database. I started using the IDE to create all my connections and adapters which was very convenient and easy to update (I like just checking boxes and removing entries when I change the database). Now I am getting ready to deploy the project and I am wondering what the best method is for letting the connection string know where the database will be on the machines I deploy the project to. I'm wondering what the best way (or what your favorite way) to deal with this problem is. All of these options involve using Application.StartUpPath and looking for my program folder and then creating a string where my data folder will be. For example... while debugging if my StartUpPath is: C:\Adam\bin\debug I do an indexof search on the Startup path and look for "Adam\" then add "\data\adam.mdb". This should work when the program is deployed in say: "C:\Program Files\Adam" . My only concern is that the user may not accept the "Adam" folder and may name it something else in which case my indexof search will be useless. Is there a better way at getting at the path? As for dealing with all my adapters and connections. I'd like to do this only once so I'm wondering what the best method would be: option 1: get rid of all the generated code and code by hand using commandbuilder for the update,insert and delete logic. option 2: copy the update,insert and delete commands that Visual Studio created for me and delete the objects from the designer. Code the adapter by hand and instead of using commandbuilder use the copied code which I had deleted. option 3: Is there some way to just use the code generated by visual studio and point it to the folder where the access database resides? When I look at the code that the connection object has created it seems to be hardcoded to the directory on my machine. Sorry for the length of this post but it is my first. Thanks In Advance. Adam. Tag: Operation must use an updateable query Tag: 76556
  - 5
    - problem with update statement Hi, I am new to visual studio.net, hence the stupid questions! 1. In a form,i created 2-3 text boxes, and created a databinding between them and the corresponding tables in the database (sql). And generated an 'update' statement using the query builder while creating the oledbdataadapter. Now whenever I put in a name and the 'search' button returns matched results from the dataase (like i put int he last name and the person's address, phone number etc comes ). Now if I make any changes in the information and try to save that by hitting the 'update' button, it does not save the changes, the same old record comes up! Also I do not know how to use the 'add' statement. I want to add a new name, hsi address etc directly from the user interface to the database. Below is the code I used for the update statement: private void btnupdate_Click(object sender, System.EventArgs e) { oleDbDataAdapter1.Update(custinfo1); } Please tell me whatr I am doing wrong! Also I created a mock databse, and just declared the 'name' column as the 'primary key'. Any help is appreciated!.thanks a bunch Shweta Tag: Operation must use an updateable query Tag: 76555
  - 6
    - Newbie: Need Help Please... :-( All, I'm pulling what little hair I have left on figuring out the concepts of DataSets, DataAdapters and what I find in all of the various books and samples I've accumulated of late. Here's the Interface I'm trying to make work: 1. WinForm containing Grid and Buttons. Grid contains a selection of existing records in a table. If I double click on a record in the grid, I open another window showing all of the details for that specific record. (this form has ALOT of fields that need to be displayed, so screen real estate is at a premium) 2. If I click on a 'New' Button, then I open the same window without any data loaded with empty fields. I can then enter the new data, I click on the Save button, then I close the detail record and repopulate the grid on the calling form. So, where I'm banging my head, is getting the the darn Insert & Update to work as I see NO changes making it to the database. Question 1: For a 'New' record, it seems that using a Dataset is overkill as I should simply use a Command Object, load the parameters with the form values and simply do an ExecuteNonQuery. This seems like it would be faster and not have a lot of overhead. I've tried doing a dataset bit, but simply CAN'T get the InsertCommand associated to the DataAdapter to perform the Insert as it doesn't show up in the database. Frustrating and I feel I'm missing a key bit of understanding here. Question 2: I'm using VS.Net 2003 and have gone through the various tutorials and so have gone through the process of using the wizard to generate Connections, DataAdapters and Datasets but all of these items are located in a section of code that says not to mess with it. Unfortunately, most of the books seem to show examples where they are generating most of the code by hand. What are most of you out there doing? The click and drag bit, or laying code out the old fashioned way? Sometimes, I feel like the IDE is doing so much for me, I'm just not understanding how things are really working under the hood. Not a good thing in my book. Sorry this is so long, but I'm really stymied right now and desparately need to have some forward motion here. Thanks to any that may extend a helping hand....Bobbo Tag: Operation must use an updateable query Tag: 76554
  - 7
    - Creating DSNless connection to MS SQL Server Hi all, I was wondering is someone could help me on this. I have a VB script with the following code to create a connection to a MS access database. Is there a way I can make a connection to a SQL server database without changing the entire script. The code below is the current code to the access database and works fine. I would just like to now connect it sql. Sub subConnectionOpen Set objCon = CreateObject("ADODB.Connection") Set objRS = CreateObject("ADODB.Recordset") sProviderName = "Microsoft.Jet.OLEDB.4.0" iCursorType = 1 iLockType = 3 sDataSource = "MitInventory.mdb" objCon.Provider = sProviderName objCon.Properties("Data Source") = sDataSource objCon.Open End Sub Thanks in advance Dave. Tag: Operation must use an updateable query Tag: 76553
  - 8
    - DataView.Dispose Is it a good idea to call DataView.Dispose() after an allocated DataView falls out of scope? Relatedly, if the DataView is Bound to a Control, is it safe (or necessary) to call Dispose()? We've found that not calling DataSet.Dispose can cause problems, but didn't realize that there was a dispose function on the DataView till today. Any information you can provide on the bestpractices on this subject would be appreciated. Thanks, Alex Tag: Operation must use an updateable query Tag: 76546
  - 9
    - Question about a DataSet In my application, i use the dataset writexml method to persist the dataset. When I load the dataset data from the xml file everything works fine however the data is all strings even though the dataset had some data that was double values. How do I get around this? Do I have to write the schema to xml? Thanks Tag: Operation must use an updateable query Tag: 76542
  - 10
    - DataGrid: knowing when the displayed table changes Hello, I have a DataSet of multiple related tables that I display in a DataGrid. When the user drills down to a child table, or when he "drills back up" to the parent table, I want to populate a ComboBox with the names of the columns in the currently-displayed table. Any suggestions for how to attack this? I'm stumped. The problem is with finding out when the user has changed the table he is viewing (and determining what the new table is). I can handle getting the info into the combobox. Many thanks, Fred Noltie Tag: Operation must use an updateable query Tag: 76541
  - 11
    - Child Relationship If I create a Foreign Key relationship between a field in 2 tables, does this now allow me to use parent/child relationships? Tag: Operation must use an updateable query Tag: 76538
  - 12
    - Binding Manager Position not changing I have a peculiar problem. I have a dataset with two records in it. When I am positioned at the first record and try to navigate to the second on a form which uses data binding, the binding manager position does not change. Any ideas as to what could be happening? Has anyone else come across this? I will add that if I bind the same dataset to a datagrid, both records show up without any exceptions being thrown. Here is the code for the event handler that I'm using: private void btnNext_Click(object sender, System.EventArgs e) { BindingManagerBase bmb; bmb = (BindingManagerBase) this.BindingContext [dsPolicies,"Table"]; bmb.Position += 1; UpdateDisplay(); } private void UpdateDisplay() { BindingManagerBase bmb; bmb = (BindingManagerBase) this.BindingContext [dsPolicies,"Table"]; this.txtPosition.Text = (bmb.Position + 1).ToString(); this.txtPosition.Text += " of "; this.txtPosition.Text += bmb.Count.ToString(); } The Locals window shows that that the dataset has 2 records, the BindingManagerBase has a count of 2 and a position of 0 which does not seem to change at all. I hope someone out there can tell me what is going on! Tag: Operation must use an updateable query Tag: 76536
  - 13
    - DataSet Limitation? I have a SQL table that has a column defined as Sql Data Type decimal(38,15). In case you are wondering, the precision and scope are that large because it contains 'scientific' numbers which require a range of that size Anyway, if I try to fill a DataSet with a DataAdapter, with a simple "select * from table", I get System.OverflowException: Conversion overflow when it gets to a row that has a column over some value (and I'm sure under some value as well) For instance: "1000000000000000.000000000000000" produces the erro Does anyone know what this value is? And is there anyway around this, or is it simply the case that .NET DataSet can't handle a Sql Data Type decimal with a precision and/or scope of that size TI Tag: Operation must use an updateable query Tag: 76535
  - 14
    - DataGrid Problem I am trying to create and load a datagrid at runtime. I am not having any luck. The Datagrid shows up and one column which is about 50 wide shows up with no header. What am I doing wrong? Here is my code. dgcColLeft1 = new DataGridTextBoxColumn(); dgtsGridLeft = new DataGridTableStyle(); grdLeft = new DataGrid(); // Make the Grid grdLeft.Location = new System.Drawing.Point(6, 6); grdLeft.Size = new System.Drawing.Size(300, 300); grdLeft.Dock = DockStyle.Fill; grdLeft.CaptionVisible = false; grdLeft.DataMember = ""; grdLeft.DataSource = dv; //dataview grdLeft.Name = "GridLeft"; grdLeft.TableStyles.Add(dgtsGridLeft); // add table styles // make the styles dgtsGridLeft.DataGrid = this.grdLeft; dgtsGridLeft.MappingName = "Services"; dgtsGridLeft.GridColumnStyles.Add(dgcColLeft1); // add the column // make the column dgcColLeft1.Format = ""; dgcColLeft1.FormatInfo = null; dgcColLeft1.HeaderText = "Test this"; dgcColLeft1.MappingName = "ColumnLeft1Name"; dgcColLeft1.NullText = ""; dgcColLeft1.Width = 125; Tag: Operation must use an updateable query Tag: 76529
  - 15
    - Performance It is my understanding that in SQL2000, stored procedure are no longer compiled. If that is true is there really any performance advantage to using sp's for .Net datasets or datareaders? -- Barry Fitzgerald Tag: Operation must use an updateable query Tag: 76528
  - 16
    - Data Analyzer with many users We have the potential of 500 users for DA, need to know if that is reasonable, if there is a web-component that we could employ that would let the report remain dynamic, instead of static, when posted, how other organizations have used this product. Tag: Operation must use an updateable query Tag: 76526
  - 17
    - Update ... Where with a DataSet/DataTable I am trying to do something that I would expect to be very easy but I am not having much luck finding the solution. I have a DataSet containing one data table of potentially 10000's of rows of data. Using ADO.NET I need to programmatically perform the equivalent of the following SQL Statement: UPDATE DataTable1 SET Field1 = 987 WHERE Field2 = 'XYZ'; Is there a way of performing this function directly against the DataSet or DataTable without iterating through all of the Rows and examining the value of each field? Please note that I must perform the updates against the DataTable and not the original data source. Any help would be appreciated. Thanks John Tag: Operation must use an updateable query Tag: 76524
  - 18
    - Assign a string value a null date in one line? Hello, I'm pulling dates from a dataset and then assigning that to a textbox. These dates can be null, that is where my problem comes in at. I guess there is no such thing as an "empty date", I'll have to deal with the nulls, but I'm having trouble assigning them. I'd prefer to do it in one line of code if at all possible, just because I'm assigning like 80 fields out of the dataset, and would rather not have that many if then else's out there. Does anyone have a good way to take a null value from a dataset and assign it to a string value? Thanks, --Michael Tag: Operation must use an updateable query Tag: 76518
  - 19
    - RowViewFilter and Nulls If you are trying to set a filter where a particulare column is null or not null, how do you do this? MyDataView = string.Format("MyField1 = '{0}' and MyField2 = '{1}'", "Fred", System.DbNull.Value). Would that be correct? Value.ToString()? Tag: Operation must use an updateable query Tag: 76515
  - 20
    - Some Thoughts On Connection Strings I am seeing way too many connection strings not being properly protected. This morning an indiviual asked me to help him with an unrelated issue and I was shocked to see his password/username of his SQL Server shown in a XML file with absolutely no protection whatsoever. Any user could have opened the file and had access to his entire database. Even those who have the connection in code are not safe because of those who can decompile applications. I think in the next release of ADO.NET MS has to do something about this. I think this is a timebomb that is going to come back and bite some people. I am trying to write a paper on encryption and connection strings that is easily understandable. It is not easy to do. Hopefully will have it done soon. Tag: Operation must use an updateable query Tag: 76511
  - 21
    - Dataset Insert Parameters... Hello I have a strong typed dataset, and when the add btn on the toolbar is clicked I do the following - which basiscally defines the strongly typed row, creates a new one & adds it to the dataset datarowcollection. drow As ds_studies.sp_retrieve_studiesRow drow = ds_studies.sp_retrieve_studies.Newsp_retrieve_studiesRow ds_studies.EnforceConstraints = False ds_studies.sp_retrieve_studies.Addsp_retrieve_studiesRow(drow) The user finds a blank screen and proceeds on filling values into the textbox controls / combo boxes etc. When the user clicks on the save button, I do the dataset update and all the usual stuff like checking for a successful update / retrieving the newly added row. My problem: when I reach the line of code in the save btn i.e. dataadapter.Update(dataset), I expect to have my adapter.InsertCommand.Parameter Collection filled with the user entered values: The parameters look right, the source column in each of them is the colum specified in the table mappings However none of the parm values are filled in. I dont think I should be filling in these values programatically. For your info my datasource is a stored proc and the parms are exactly mapped to what the proc requires. If anyone can shed some light on this, I'd appreciate it. Thanks, Nisha Tag: Operation must use an updateable query Tag: 76507
  - 22
    - Retrieving Text data type - help I have a stored procedure in SQL Server: procedure proc_xxx @textOut Text output As Declare @ptrval varbinary(16) Select @textOut = someTextField From myTable Where... READTEXT myTable.someTextField @ptrval 0 0 I'm also using the MS Data Access Application Block, which I doubt is the problem here, with the following code snipet: parms[1] = new SqlParameter("@someTextField", SqlDbType.Text); parms[1].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(_connectionString, CommandType.StoredProcedure, "proc_xxx", parms); When executing, I get the following error message: Parameter 1: '@someTextFieldof type: String, the property Size has an invalid size: 0 Where am I going wrong? in the stored procedure? in the SqlDbType setting? Thanks Alex Dinu alex_dinu@adp.com Tag: Operation must use an updateable query Tag: 76506
  - 23
    - I don't know how... I want to add a column to a dataset and then update my Access XP database with the dataset changes. Anyone knowns how to do it?? Thanks! Andres Tag: Operation must use an updateable query Tag: 76500
  - 24
    - how to update a ds in aspx, and implement this code? I found some sample code (below) that will handle all the update logic for a dataset. All you need to pass is the dataset, the tablename, & the name of the table in the db. Problem is, in our ASP.NET app, our dataset is bound to a grid. But how is it updated? If I send it to the SaveDataSet function below, the dataset will have the same original data that was retrieved into the grid. How does one update the dataset :) ? Thats my rediculous question. Thanks for any help! -- Jason Shohet public override int SaveDataSet(DataSet ds, string Tablename, string DatabaseTablename) { int RowsUpdated = -1; this.SetError(); if (!this.Open()) return -1; this.LoadDataAdapterCommands( new OleDbCommand("SELECT * FROM " +DatabaseTablename), ref this.DataAdapter); if (this.Transaction != null) { this.DataAdapter.InsertCommand.Transaction = this.Transaction; this.DataAdapter.UpdateCommand.Transaction = this.Transaction; this.DataAdapter.DeleteCommand.Transaction = this.Transaction; } /// update & return # of rows updated try { RowsUpdated = ((SqlDataAdapter) this.DataAdapter).Update(ds, ds.Tables[Tablename].ToString()); } catch(Exception ex) { this.SetError(ex.Message); return -1; } return RowsUpdated; } public override bool LoadDataAdapterCommands(IDbCommand SelectCommand,ref IDbDataAdapter Adapter) { if (Adapter == null) Adapter = this.CreateDataAdapter(SelectCommand); SqlCommandBuilder CommandBuilder= new SqlCommandBuilder((SqlDataAdapter) Adapter); Adapter.SelectCommand = SelectCommand; Adapter.DeleteCommand = CommandBuilder.GetDeleteCommand(); Adapter.UpdateCommand = CommandBuilder.GetUpdateCommand(); Adapter.InsertCommand = CommandBuilder.GetInsertCommand(); return true; } Tag: Operation must use an updateable query Tag: 76495
  - 25
    - Paradox, BDE and ODBC -- OH MY! Hi! If this is not the place to post this, I apologize in advance... I am connecting to a Paradox 4.X database using ODBC. I have the latest version of MDAC loaded and have BDE 5.11 loaded. When I run the following query: select * from mytable I get the following results back (sorry for any bad tabbing): Code Sub Code Value 001 A 1 001 A 2 001 A 3 ... However, when I run this query: select * from mytable where [Code] = '001' I get only the first row back. Any ideas? Thanks in advance, cj Tag: Operation must use an updateable query Tag: 76492
- Next
  - 1
    - ANN: Strong typed dataset schema generation template Hi, I've put together a template that generates strong typed dataset schema (xsd) content for a given selection of tables. *It includes primary and foreign keys*. Template is run with CodeSmith (free template based code generator - to download go to http://www.ericjsmith.net/codesmith/ and download *CodeSmith 2.5 Release Candidate Available*). Template can be obtained from my website: http://www.rthand.com/default.aspx?Page=2&SubPage=1#5 Comments are welcome either to forum http://www.ericjsmith.net/codesmith/forum/?f=9&m=2219 or by e-mail. -- Miha Markic - RightHand .NET consulting & software development miha at rthand com www.rthand.com Tag: Operation must use an updateable query Tag: 76487
  - 2
    - problem referencing field in sqldatareader I have a db with 4 fields (id,field1, field2,field3). I populate a datareader (named dr) with this sql select * from table where id=2 Now i want to pre-set a textbox with the info in field1. Seems like this should work TextBox5.text=dr("field1") i keep getting this error Exception Details: System.InvalidOperationException: Invalid attempt to read when no data is present. So the first assumption is i've selected a row that doesn't exist or that has no info in field1 BUT if i bind the datareader to a datagrid i see the following info id field1 field2 field3 2 sdf dgfsdg Choose where isn't my reference working? Tag: Operation must use an updateable query Tag: 76485
  - 3
    - Inputoutput Params I guess this is bad practice but i have an SQL 2000 SP that uses a single varchar(100) parameter for input and output. I would like to use an SQLcommand object to call it but this doesn't seem to work, here's my code: SqlParameter ParamSessionID = new SqlParameter("@SessionID", SqlDbType.VarChar, 100); ParamSessionID.Direction = ParameterDirection.InputOutput; Comm1.Parameters.Add(ParamSessionID); Comm1.Parameters["@SessionID"].Value = m_currentPage.Session.SessionID; Comm1.CommandType = CommandType.StoredProcedure; Conn.Open(); Comm1.ExecuteScalar(); The error i get is 'System.Data.SqlClient.SqlException: String or binary data would be truncated.' Using the debugger i can see the value of the parameteris as a 25 charected string. SQL profiler shows the following command being issued: declare @P1 varchar(100) set @P1=NULL exec sp_CevasSessionCreate @SessionID = @P1 output select @P1 This seems to suggest that SQLClient doesn't implement InputOutput as expected, i could get the data by setting the commandtype to text and using ExecuteScalar but it would be nice to do this via the command object. Any ideas? Micky Tag: Operation must use an updateable query Tag: 76478
  - 4
    - DataAdapter Config Wizard misery We tried using that Config Wizard, but when a query changes, all the update logic goes haywire. So we went back to manually doing things: 1. We have no datasets dragged-and-dropped in Visual Studio. They are all defined in the code, generated at runtime. 2. when a user updates or hits a 'delete' button next to a row in a datagrid, we call a webservice. In there, we coded insert, update & delete functionality. THE PROBLEM: I am looking for a way to have .NET generate its own update / delete / insert statements. BUT, I don't want to use that DataAdapter Configuration Wizard because if we change around a field in the db, everything breaks and there's too much going on under the hood to fix it. If a query changes in our dataset, I would like the update logic to automatically change as well. I've been looking at CommandBuilder -- is this something good to use? In order to use it, do I need to define the dataset at Design Time (visually drag it on to the web service etc) ? Any other suggestions would be appreciated TY Jason Shohet Tag: Operation must use an updateable query Tag: 76477
  - 5
    - ChildToParent and ParentToChild navigation? The question to the ADO.NET gurus: Is it even possible to navigate from child table to parent table without looping through untyped arrays of datarows? Also, maybe someone can tell, what's wrong in my code when I try to navigate from parent to child (syntax exactly from .NET Framework Tutorials and Samples): private Standardization.Standardizer.Main localParent; //my main MDI parent form private System.Data.DataRow[] foundExperts; ... this.localParent = (Standardization.Standardizer.Main)(this.MdiParent); this.cboName.DataSource = this.localParent.dsBase; this.cboName.DisplayMember = "entityLVExpert.attrName"; this.cboName.ValueMember = "entityLVExpert.attrID"; ... // this works fine, but following code raises that... this.foundExperts = this.localParent.dsBase.entityLVExpert.Select("LVCommitteeExpertLVExpert_FK. attrCommittee = '" + this.txtTC.Text.ToString() + "'", "attrName", System.Data.DataViewRowState.CurrentRows); ...VS.NET2003 tells that it cannot understand object child at position 1... Thanks in advance for any constructive comments! Tag: Operation must use an updateable query Tag: 76476
  - 6
    - Null problem We've a typed dataset which has a number of datatables. After some computing we insert rows to these datatables. My question is, we want to insert null value to an integer column in this datatable. How can this be done? What should we do to do sth. like below; myTypedDataSet.myDataTable.addmyDataTableRow(strValue1, intValue2, intValue3, null, /*this column is an integer column*/ intValue5); Thanks, Tag: Operation must use an updateable query Tag: 76466
  - 7
    - Error Message -- Help I built and ran my program. I got a Microsoft Development Environment message saying "An unhandled exception of type 'System.ArgumentException' occured in mscorlib.dll Additional information:Invalid URL." Plus it is highlighting 'MyBase.NEW()' in the Public Sub New() subroutine in the Declarations. What do I do to fix this problem? Would someone please help me. I went thru ADO.NET to my ACCESS database to get my records and I have an DataFrom1.vb form out there that does no come up now because of this message. Mathew Tag: Operation must use an updateable query Tag: 76465
  - 8
    - Sort, Filter and Restrict RecordCount in a DataSet before Transformation Hello Group, I have a DataSet with one DataTable filled. Before transforming the DataSet into a CSV-Format I have to Filter, Sort and restrict the Number of Records. Any suggestion how to archive this Step? Please remember that it is not possible for me to Filter, Sort and Restrict when filling the DataSet. It must be done with the existing DataSet... Code for Filling the DataSet and Transforming it is already done. Thanks4Help Tag: Operation must use an updateable query Tag: 76461
  - 9
    - Writing XML file Hi all, I have a small problem in writing XML file from VB.net. I am trying to write the XML file using dataset. I am able to write the XML in sequential way(one node after other). I can write in the hierarchial(tree) structure also but only by using datagrid. But I would like to write the XML file without using datagrid but just the grid. I am sending the sample. Could u please tell me how I can write hierarchially using dataset but without using the datagrid. Best regards, Kelly Tag: Operation must use an updateable query Tag: 76447
  - 10
    - Using OracleType.Clob Parameter ? Hello, I'm considering the option of using OracleType.Clob Parameter in .net applications. 1. Is it correct that this Parameter type is supported only under Framework 1.1? 2. Are there any performance problems when using Clob with large strings ? thanks. Tag: Operation must use an updateable query Tag: 76445
  - 11
    - Problem using OLEDB connector Hi, I am trying to insert data into an Excel sheet using Microsoft Jet OLE DB 4.0 driver. One of the fields is exceeding 255 characters. I get the error: "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data" This is surely not a problem with Excel since I put in the data manually. Please let me know if we have a solution/workaround for this. Thanks, Pranav. Tag: Operation must use an updateable query Tag: 76443
  - 12
    - Correct SP:s not executing I often use ADO.NET and SP:s, but now I'm stuck after spending all yesterday on two issues 1) ARITHABORT A form calls SP to insert a record, but executing it only results in the following message :"Insert failed becase the following SET options have incorrect settings 'ARITHABORT'". I've checked the SQL Server documentation and can't see how it at all applies in this case. Tracing the command in SQL Profiler this is what it looks like exec insertReportPeriodExchangeRates @FromCurrencyID = N'GBP', @ToCurrencyID = N'USD', @ExchangeRate = 1.600000, @ReportPeriodID = N'2004Q3', @ReportPeriodExchangeRateID = @P1 output, @TimeStamp = @P2 output If I execute that command from SQL Analyzer it works just fine. No error message 2) .SP does not execute at all Another form calls a SP to delete a record, but the SP is never executed! How is that possible? Tracing the command in SQL Profiler this is what it looks like exec deleteReportPeriods @Original_ReportPeriodID = N'2003Q5', @Timestamp = 0x00000000000083C1 If I execute that command from SQL Analyzer it works just fine. All in all about 200 SP:s are called in the application, and these are the only one that failing. Again, if I run them from SQL Analyzer they execute correctly, so there is something odd happing in ADO:NET. All the commands are executed from inherited forms. Any ideas where to look? Kind regards, Kenneth Bohman Tag: Operation must use an updateable query Tag: 76442
  - 13
    - Concurrency violation: the DeleteCommand affected 0 records ----------------------------------------------------------------- The PK in the oledbdeletecommand.parameters collection *appears* to have the appropriate Primary Key to look for to delete, so I'm not sure why it's not able to find the record to delete... After reloading the master form, the datarow deletes and the dataadapter.update(me.ds) goes just fine. ----------------------------------------------------------------- I have two forms in a master/detail relationship, with the master form's dataset shared with the detail form. I use the form's currencymanagers to synch the detail record, add a new row, etc. The database is Access, using the Jet driver. After creating a new record with "cm.AddNew()" in the detail form, the following gives me the "affected 0 records" error: 1. update the database with the dataadapter via "masterForm.da.update(masterForm.ds)" 2. use "@@Identity" to get the database's primary key just generated on this database connection for my new row, and alter our dataset row's PK field to conform with database by using "drCm.Item("PK") = newPK" 3. call cm.EndCurrentEdit() & drCm.acceptChanges() to set the row's state from "Modified" to "Unchanged". 4. back in the master form, delete the new record via "dr.Delete()" ////////////////// This throws the Exception ////////////////// 5. attempt to synch the datarow delete w/ the database by using the dataadapter via: "me.da.update(me.ds)" Here are some code snippets: mngUsers.vb ------------------------------------- Private cmEmployees As CurrencyManager Private Sub mngUsers_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.cmEmployees = CType(Me.BindingContext(Me.DsUsers1.Employees), CurrencyManager) '// some code snipped from here End Sub Private Sub btnNew_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNew.Click Dim myUser As New mngUsersNewEdit(mngUsersNewEdit.formAction.newUser) Me.AddOwnedForm(myUser) myUser.Show() End Sub Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click Dim drCm As DataRow drCm = CType(Me.cmEmployees.Current, DataRowView).Row Try drCm.Delete() Me.OleDbDataAdapter1_Users.Update(Me.DsUsers1.Employees) Catch ex As Exception MessageBox.Show(ex.Message + vbCrLf + vbCrLf + ex.StackTrace) End Try End Sub mngUsersNewEdit.vb ----------------------------------- Private m_actionToTake As formAction Private m_parent As mngUsers Private cmEmployees As CurrencyManager Private cmOwner As CurrencyManager Private Sub mngUsersNewEdit_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.m_parent = Me.Owner Me.cmEmployees = CType(Me.BindingContext(Me.m_parent.DsUsers1.Employees), CurrencyManager) '// If appropriate, Synchronize our Form to the record currently selected in parent form If m_actionToTake = formAction.editUser Then '// set a currency manager for the owner form to find Form1's current record position cmOwner = CType(CType(Me.Owner, masterdetailDeleteTest.mngUsers).BindingContext(Me.m_parent.DsUsers1.Employe es), CurrencyManager) '// synchronize the table record positions between form1 and form2 Me.cmEmployees.Position = Me.cmOwner.Position Else '// create a new itemOption cmEmployees.AddNew() '// set up default data so avoid DBnull conflicts '// casting the currency manager and accessing it's 'row' object allows us to access an item by column name. Dim drNew As DataRow = CType(cmEmployees.Current, DataRowView).Row drNew.Item("IsActive") = True drNew.Item("Birthdate") = "1/1/1970" End If '// Set our databindings Me.tbEmployeeID.DataBindings.Add("text", Me.m_parent.DsUsers1.Employees, "EmployeeID") Me.tbFirstName.DataBindings.Add("text", Me.m_parent.DsUsers1.Employees, "FirstName") '// etc. w/ the databinding End Sub Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click Me.cmEmployees.EndCurrentEdit() Try Me.m_parent.OleDbDataAdapter1_Users.Update(Me.m_parent.DsUsers1) If Me.m_actionToTake = formAction.newUser Then '// To avoid having the autogenerated primary key in dataset out of synch with database, '// retrieve the newly created database PK and update our dataset's PK with it. '// Include a variable and a command to retrieve the autogenerated primary key value '// (identity value) from the Access database. '// cf. ms-help://MS.VSCC/MS.MSDNVS/cpguide/html/cpconretrievingidentityorautonumber values.htm Dim newID As Integer = 0 Dim idCMD As OleDbCommand = New OleDbCommand("SELECT @@IDENTITY", Me.m_parent.OleDbConnection1) '// Retrieve the identity value. newID = CInt(idCMD.ExecuteScalar()) '// Assign retrieved autonumber to our new row's primary key. Dim drCm As DataRow = CType(Me.cmEmployees.Current, DataRowView).Row '// datarow to inspect our current row drCm.Item("EmployeeID") = newID '// push DB's new PK to row's "Current", "Original", and "Default" values '// Roll our PK value change into the row's "original version." '// The deleteCommand uses the original row PK values to do the deletion, '// which may be out of synch with the database. If so, the dataset would throw an '// exception when the database (looking for the wrong PK) could still not find the row to delete. cmEmployees.EndCurrentEdit() '// allow this row's changes to remain drCm.AcceptChanges() '// set row's state from "Modified" to "Unchanged" to prevent unneccessary labor End If Catch ex As Exception MessageBox.Show(ex.Message + vbcrlf + vbcrlf + ex.StackTrace) End Try Me.Owner.Focus() Me.Close() End Sub Tag: Operation must use an updateable query Tag: 76440
  - 14
    - How to create dataview from two datatables Hi is there any way to create a dataview from two different datatables. My purpose is to display a datagrid. some columns from one table and some other columns from other table. i am using commandbuilder for automatic query. so i am not able to join query from datasource. Thanks in advance. Regards H. Mahadevan Tag: Operation must use an updateable query Tag: 76436
  - 15
    - Select a Row in A DATAGRID Hai All, I have a Datagrid in a help Screen. How I can select more than one row (HIGHLIGHTS). Help me to get the selected rows from that datagrid. I am awiting for your earlier valuable reply. Thanks in Advance, Regards, Karnan.S Tag: Operation must use an updateable query Tag: 76434
  - 16
    - how to do transaction hiye, is there a nice sql script example out there which shows how t-sql transaction is done? Tag: Operation must use an updateable query Tag: 76432
  - 17
    - how to return stored procedure error? hiye, does anyone know how to return a stored procedure error to vb.net? any or all error capture in stored procedure i want em to be return to vb.net. thanks for the help.. Tag: Operation must use an updateable query Tag: 76428
  - 18
    - "One or more accessor flags were invalid." -- VFPOLEDB I am trying to do a simple Asp.Net update using the same OleDb code that has worked for Access databases, and I get this error message when using a Visual Foxpro database: "One or more accessor flags were invalid." It retrieves data ok, but won't update it. Anyone know why? Thanks. Tag: Operation must use an updateable query Tag: 76418
  - 19
    - Table Names with Spaces I wrote a program that inserts records into a table in a MS Access database. For some reason, it works only for tables without spaces in their names: There are four tables: "test 1" "test2" "test 3" and "test4" each with fields word, pos, and meaning. The following code works only for test2 and test4, the tables whose names do not contain any spaces. string tableName="test 1"; //place table name here OleDbConnection conn=new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=lists.mdb"); OleDbDataAdapter da=new OleDbDataAdapter("select * from ["+tableName+"]",conn); OleDbCommandBuilder cb=new OleDbCommandBuilder(da); DataSet ds=new DataSet(); da.Fill(ds); conn.Close(); DataTable dt=ds.Tables[0]; DataRow dr=dt.NewRow(); dr["word"]="myword"; dr["pos"]="mypos"; dr["meaning"]="mymeaning"; dt.Rows.Add(dr); try { da.Update(ds); } catch(OleDbException ole){Console.WriteLine(ole.Message);} Tag: Operation must use an updateable query Tag: 76415
  - 20
    - OleDb versus (Sql,Oracle,Odbc etc..) Is there a peformance difference when using OleDB classes instead of SqlServer? Or are the differences mainly functional, for example SqlServer lets you perform more of its proprietry functions using it's classes. Any help appriciated! This question is the same for Oracle, Odbc and any other specific .NET provider... Thanks, Robby Tag: Operation must use an updateable query Tag: 76410
  - 21
    - possible to step into a stored procedure Hi- when debugging, is it possiblt to step into a stored procedure? For example, if I have a method in my DAL class called AddProduct() and it makes a call to SqlCommand.ExecuteNonQuery() can I step into that sproc that it will be calling? I hope so, that would be the coolest! OK, if this is possible and you know how, please do share. Thanks, Steve Tag: Operation must use an updateable query Tag: 76404
  - 22
    - Why aren't there any interfaces?? I'm working with DataSets in my code and cannot find a suitable Interface to reference. As a work-around, I've written an Interface (IDataSet) that defines all of the public method signatures of a DataSet class. A custom class (DataSetExt) implements that Interface and delegates public method calls to *base*. I know that in taking this approach I've left myself open to a slew of potential problems especially if the signatures of the DataSet class change. However, the System.Data.DataSet class has no primary interface....???? Any thoughts on this? thx Tag: Operation must use an updateable query Tag: 76399
  - 23
    - SqlParameter SqlDBType.text size What is the correct way to address the size of a SqlDBType.text field in a SqlParameter The Data Adapter configuration wizard does this cmdUpdate.Parameters.Add("@myvar", SqlDbType.Varchar, 2147483647) Is that right (I'm assuming so), but could I also do this? (using SqlDbType.Text) cmdUpdate.Parameters.Add("@myvar", SqlDbType.Text, 2147483647) or even this, as the size is defined in Sql server cmdUpdate.Parameters.Add("@other_accident_cause", SqlDbType.Text, 16) Little confused here.. :) --Michael Tag: Operation must use an updateable query Tag: 76397
  - 24
    - Speeding up a Directory Search Process This is a multi-part message in MIME format. ------=_NextPart_000_00D6_01C3D46F.A23E0DE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I having trouble querying for users that have changed, when I have a = node that have over 750 users. It takes way to long over 1 hour, if it = does return users. How can I improve this? objADSDirEntry =3D New DirectoryEntry(sInADSADsPath, strADSUserName, = strADSPassword, AuthenticationTypes.ServerBind) ObjADSDirSearcher =3D New = DirectoryServices.DirectorySearcher(objADSDirEntry) Err.Clear() ObjADSDirSearcher.Filter =3D = "(&(|(objectClass=3Duser)(objectClass=3Dgroup)(objectClass=3Dcontact))(&(= uSNChanged>=3D" & LastMod & ")(uSNChanged<=3D" & NewLastMod & ")))" 'ObjADSDirSearcher.PageSize =3D 1000 ObjADSDirSearcher.ServerTimeLimit =3D TimeSpan.FromMinutes(3) For Each objSearchResult In ObjADSDirSearcher.FindAll objadsDirEntry2 =3D objSearchResult.GetDirectoryEntry Thanks Robert ------=_NextPart_000_00D6_01C3D46F.A23E0DE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I having trouble querying for users = that have=20 changed, when I have a node that have over 750 users. It takes way to = long over=20 1 hour, if it does return users. How can I improve this?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>objADSDirEntry =3D New = DirectoryEntry(sInADSADsPath,=20 strADSUserName, strADSPassword, = AuthenticationTypes.ServerBind)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>ObjADSDirSearcher =3D New=20 DirectoryServices.DirectorySearcher(objADSDirEntry)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Err.Clear()</FONT></DIV> <DIV><FONT face=3DArial size=3D2>ObjADSDirSearcher.Filter =3D=20 "(&(|(objectClass=3Duser)(objectClass=3Dgroup)(objectClass=3Dcontact)= )(&(uSNChanged>=3D"=20 & LastMod & ")(uSNChanged<=3D" & NewLastMod &=20 ")))"</FONT></DIV> <DIV><FONT face=3DArial size=3D2>'ObjADSDirSearcher.PageSize =3D = 1000</FONT></DIV> <DIV><FONT face=3DArial size=3D2>ObjADSDirSearcher.ServerTimeLimit =3D=20 TimeSpan.FromMinutes(3)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>For Each objSearchResult In=20 ObjADSDirSearcher.FindAll</FONT></DIV> <DIV><FONT face=3DArial size=3D2>objadsDirEntry2 =3D=20 objSearchResult.GetDirectoryEntry</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Robert </FONT></DIV></BODY></HTML> ------=_NextPart_000_00D6_01C3D46F.A23E0DE0-- Tag: Operation must use an updateable query Tag: 76392
  - 25
    - ConnectionString: set ANSI NULL on/off I want to know if there is a way to specify ANSI NULL processing ON/OFF, based on a ConnectionString parameter. This will take care of processing "x = NULL" and "x IS NULL" kind of SQL expressions appropriately based on the ON/OFF setting. I expect to set this like: ConnectionString="Provider=...; ANSI_NULL=no"; OR ConnectionString="Provider=...; Extended Properties="ANSI_NULL=no;" This is for connecting to Sybase, using Ole DB classes. TIA Raj "Operator... Get me outa here." Tag: Operation must use an updateable query Tag: 76385

I have a small ASP.NET Web App using VB.NET and am trying
to utilize an Access database, but cannot perform any
updates, inserts or deletes to the database. Only SELECT
clauses work. It throws the error on the following lines
that I have tried with an OleDbCommand object:

Error:
Operation must use an updateable query

Lines Attempted:

objDataComm.ExecuteReader()
objDataComm.ExecuteNonQuery()
objDataComm.ExecuteScalar()

I have read resolutions on changing the process model of
the ASP.NET worker process, but have no idea how it is
done, or if there are any other clear solutions to this.
Thanks.

Blueshift

Top

Re: Operation must use an updateable query by Teemu

Teemu
Sun Jan 11 23:16:43 CST 2004

Hi,

see the following thread at ASP.NET Forums. All the information you need is
located there
http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=154273

--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist

"Blueshift" <anonymous@discussions.microsoft.com> wrote in message
news:07eb01c3d59b$048f8e70$a301280a@phx.gbl...
> I have a small ASP.NET Web App using VB.NET and am trying
> to utilize an Access database, but cannot perform any
> updates, inserts or deletes to the database. Only SELECT
> clauses work. It throws the error on the following lines
> that I have tried with an OleDbCommand object:
>
> Error:
> Operation must use an updateable query
>
> Lines Attempted:
>
> objDataComm.ExecuteReader()
> objDataComm.ExecuteNonQuery()
> objDataComm.ExecuteScalar()
>
> I have read resolutions on changing the process model of
> the ASP.NET worker process, but have no idea how it is
> done, or if there are any other clear solutions to this.
> Thanks.
>
> Blueshift
>

Top