dataAdapter'rs command statements

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
    - SqlDataReader recordsaffected Hi. Just reading about the sqldatareader object I am confused about the recordsaffected property. The example on the help docs use a procedure with some inserts and a select. Can I use a datareader object to run sql commands that does not return records? What is the advantage of using a datareader.recordsaffected instead of command.executenonquery, since the later also can give me the records affected? Regards, Chris Leffer *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: dataAdapter'rs command statements Tag: 65998
  - 2
    - Trouble clearing SqlParameters from my Command object (note - sorry for the crosspost - I sent to .vb thinking i was sending to .adonet). I implemented a very small, basic data access layer for my web application. It works just fine, except for this one bug. One of my methods returns an abstracted dataset. To accomodate X number of input parameters, I created a function signature that accepts a ParamArray of SqlParameters as well as the name of the stored proc. In the body of the function I loop through the param array and append each object to the Parameters collection of my Command object. The problem comes up when I try to append a SqlParameter object that I have already used in a previous call, that is also an argument for the next stored procedure. For example, I have: dim objParam1 as New SqlParameter("@userid", intUserid) dim objDS as DataSet objDS = objDAL.GetDataSet("storedprocname", objParam1) ' do some stuff with the dataset, now try a new query, different proc, same parameter objDS.clear() objDS = objDAL.GetDataSet("anotherprocname", objParam1) The error returned is something like "There is already a parameter named objParam1 in the SqlParametersCollcetion. Prior to adding each parameter, I check its count and, if greater than 0, remove each item before appending the new params. In debugging the count is always 0, so how can there be an SqlParameter object in its collection? ' create our command object with the passed in ProcedureName. ' and sqlparameter object. Dim objCommand As New SqlCommand(ProcedureName, Me.Connection) Dim sqlParam As SqlParameter objCommand.CommandType = CommandType.StoredProcedure Me.LocalCommand = objCommand If objCommand.Parameters.Count > 0 Then ' in case any parameters are hanging around, clear them out For Each sqlParam In objCommand.Parameters objCommand.Parameters.Remove(sqlParam) Next End If objCommand.Parameters.Clear() ' add the parameters passed in from the ParamArray ' into the command's parameters collection. For Each sqlParam In DataParameters sqlParam = objCommand.Parameters.Add(sqlParam) ' ERROR THROWN HERE Next What element am I missing please? This has me bending my brain pretty badly. Thank you in advance. Tag: dataAdapter'rs command statements Tag: 65997
  - 3
    - SqlDataAdatper Bug? I am new to .Net but have been unable to find anything about this in the newsgroups. Using C# and the following SQL stored procedure in my SqlDataAdapter: CREATE PROCEDURE HouseholdNextPrevious @PassedName varchar(150), @Direction varchar(4) AS Set NoCount on if @Direction = 'down' /* next household */ begin SELECT TOP 1 BuildingId, LabelName, Street1, Street2, City, StateProvince, Zipcode, Country, Phone, PhoneNote, Household.CellPhone, Fax, NoNewsletter, NoAppeal, NoCalendarAnnouncement, NoFlyer, Household.InactiveId, FirstConnectionId, Salutation, ICodeId, IncomeId, PrimaryContactId, Household.Note, Household.LastEditDate, SortName = isnull(LastName + ' ' + FirstName + ' ' + isnull(MiddleInitial,'') + Convert(varchar(40),Household.BuildingId),'aaaaa' + Convert(varchar(40),Household.BuildingId)) FROM Household LEFT OUTER JOIN Individual on IndividualId = PrimaryContactId where (isnull(LastName + ' ' + FirstName + ' ' + isnull(MiddleInitial,'') + Convert(varchar(40),Household.BuildingId),'aaaaa' + Convert(varchar(40),Household.BuildingId))) > @PassedName order by SortName asc end else /* previous household */ begin SELECT TOP 1 BuildingId, LabelName, Street1, Street2, City, StateProvince, Zipcode, Country, Phone, PhoneNote, Household.CellPhone, Fax, NoNewsletter, NoAppeal, NoCalendarAnnouncement, NoFlyer, Household.InactiveId, FirstConnectionId, Salutation, ICodeId, IncomeId, PrimaryContactId, Household.Note, Household.LastEditDate, SortName = isnull(LastName + ' ' + FirstName + ' ' + isnull(MiddleInitial,'') + Convert(varchar(40),Household.BuildingId),'aaaaa' + Convert(varchar(40),Household.BuildingId)) FROM Household LEFT OUTER JOIN Individual on IndividualId = PrimaryContactId where (isnull(LastName + ' ' + FirstName + ' ' + isnull(MiddleInitial,'') + Convert(varchar(40),Household.BuildingId),'aaaaa' + Convert(varchar(40),Household.BuildingId))) < @PassedName order by SortName desc end When I generate the dataset based on the above stored procedure, it constructs two tables (HouseholdNextPrevious and Table1) in the dataset which have identical columns. If I use an OledbDataAdapter, it only contructs one table in the dataset (HouseholdNextPrevious). Any insight as to why this is happening? Thanks, Tag: dataAdapter'rs command statements Tag: 65995
  - 4
    - Shouldn't An Exception Be Thrown - Establishing a Primary Key Hello, I was setting the primary key on a table which was a collection of 3 columns. I mispelled the name of the second column when I built the array of collumns when I created the array of collumns for the primary key. When I used the "dt.primarykey(myArrayOfKeys)" no exception was thrown, and rather then the primary key being a set of 3 columns, it was only a single column. When you make this type of mistake when setting foreign keys, that process throws and exception. Why the inconsistency? -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: dataAdapter'rs command statements Tag: 65994
  - 5
    - CommandTimeout property Clarification I have a stored proc that runs and calls others and sometimes the process runs for 3 to 5 minutes depending on traffic. ASP.NET - ADO.NET - Sql 2000 Code - dim cmdV as sqlcommand = new sqlcommand("ValidateUpdatePrograms",cnOAP) cnoAP.Open() cmdV.ExecuteNonQuery() cmdV = nothing cnoap.Close() Does the CommandTimeout property refer to the time to wait until a command starts processing or does it refer to how long a command can process before it is considered overdue? If it is the second case will sql actually stop in the middle of processing? Currently I am getting Application Unavailable in the browser after the Machine.config setting responseDeadlockInterval has been exceeded. I will set this higher. But I am wondering if sql is still processing and the web server times out, will sql continue processing until it is done? I have tested and it seems like it does. It seems like it will also stick with the command until it is done no mater how long it takes. I have not set the CommandTimeout. I am trying to figure out how to make sure sql doesn't stop. Thanks! Tag: dataAdapter'rs command statements Tag: 65991
  - 6
    - Connection Pools I have an app that I have recently been testing to try an determine the cause of this Timeout Expired issue. I am using the performance monitor to check the # of connection pools as well as the # number of pooled connections. When I start the app and the user logs in a pool & connection is created and all is well. However when I shut down the app the pool does not go away. Then if I start the app again another pool and connection are created and soon, and so on?? Does anyone have any idea how I should deal with this? Should the pool created by the app be detroyed when the app is no longer in memory. By the way I am using CLR .Net Data for the specific app, not _global. Tag: dataAdapter'rs command statements Tag: 65983
  - 7
    - DataTable schema changes I need to handle dynamic changes to a table's schema, even when there is already data present. It appears that the only thing supported by DataTable is to remove a column so I am pulling all the data out into a 2D array, performing my manipulations on the raw data, and then clearing out the table's Rows and Columns collections and attempting to recreate them. Basically, Rows.Clear(); Columns.Clear(); RebuildColumns(/*...*/); RebuildRows(/*...*/); Where I rebuild the columns from a separate list of schema parameters that I have available and then rebuild the rows from the 2D array of raw data that I originally pulled from the table. For a simple test I am trying to remove the third column from a four column table (something that I suppose I could have done simply via Columns.RemoveAt, but am trying this way as a test). The problem is that when I'm adding the rows back, I'm getting an exception thrown on adding the second row: System.IndexOutOfRangeException "Cannot find Column 3" System.Data.DataTable.InsertRow Can anyone shed some light on this for me? Thanks in advance. -- Thomas Brown Tag: dataAdapter'rs command statements Tag: 65982
  - 8
    - OleDbConnection.Open very slow on ASP.NET App running under XP??? Does anybody know why when connecting to an Oracle database from a ASP.NET web app running under Windows XP, the connection is very slow. It takes about 2 minutes to open the database connection. The same code running on a NT2000 machine executes in under 4 seconds. To test this, is very simple On an XP machine, create a new ASP.NET app and create a new OleDbConnection object. Assign a valid connection string and execute the Open statement. That is it. The connection string I used was: Private f_cConn As String = "Provider=MSDAORA.1;Password=JJ;User ID=JJ;Data Source=OLT" ANy help is greatly need and appreciated. Tag: dataAdapter'rs command statements Tag: 65981
  - 9
    - The same table (types) cannot be the child table in two nested relations. I have a Schema describing an XML feed i'm receiving. The problem is, when i load it i get the above error. In this schema i have several fields describing an article. Two of these fields(tables) are called videos and sounds. They both contain a complex type (table) called Types which contain from 0-unbound number of "type" elements. So the case is. Both the sounds and the videos nodes have types/type nodes, which won't map to my DataSet. I don't think i can get the xml provider to change the format, but is there any way i can add something to the schema to allow the "same table" twice? Thanks in advance Per Here is an example to describe the problem: <xs:element name="sounds"> <xs:complexType> <xs:sequence> <xs:element name="sound" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence>  <xs:element name="types" > <xs:complexType> <xs:sequence> <xs:element name="type" type="xs:string" maxOccurs="unbounded" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="videos"> <xs:complexType> <xs:sequence> <xs:element name="video" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence>  <xs:element name="types" > <xs:complexType> <xs:sequence> <xs:element name="type" type="xs:string" maxOccurs="unbounded" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> Tag: dataAdapter'rs command statements Tag: 65980
  - 10
    - dataset.haschanges=false allthough change have been made I have the following problem: I have a dataset with one table. I bind the fields of the table to several entities like textboxes etc. Now I change the values of a row of the table through the textboxes. The value in the table of my dataset has changed (I checked it) but my dataset still has the status .haschanges=false??? Why? Regrads, Christoph Tag: dataAdapter'rs command statements Tag: 65975
  - 11
    - SQL String Connecting to MS Access via ADO I have an SQL string that im trying to use to connect to an Access DB im currently using the following string: SQLStr = "SELECT LEFT(LTRIM(RTRIM(Personal.postcode)),LEN(personal.postcode)-1) AS Expr1, LiveTracker.ID, LiveTracker.MortgageAppSubmitted, Closed.ID FROM ((Personal INNER JOIN PendingTracker ON Personal.ID = PendingTracker.ID) LEFT JOIN LiveTracker ON Personal.ID = LiveTracker.ID) LEFT JOIN Closed ON personal.ID = Closed.ID ORDER BY LEFT(LTRIM(RTRIM(Personal.postcode)),6);" the above currently works perfectly and i have no problems but it doesnt do exaclty as i want, what i would like it to do is this statement: SQLStr = "SELECT Left(Personal.postcode,Len(personal.postcode)-2) AS Expr1, LiveTracker.ID, LiveTracker.MortgageAppSubmitted, Closed.ID FROM ((Personal INNER JOIN PendingTracker ON Personal.ID = PendingTracker.ID) LEFT JOIN LiveTracker ON Personal.ID = LiveTracker.ID) LEFT JOIN Closed ON Personal.ID = Closed.ID ORDER BY personal.postcode;" the only difference between the two SQL statements is that the second statement takes 2 charachetrs from the end of postcode whereas the first statment only removes one! when i try to run the second statement I get the following error: An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: The provider could not determine the String value. For example, the row was just created, the default for the String column was not available, and the consumer had not yet set a new String value. any help with this would be greatly appreciated Regards Mike Fellows Tag: dataAdapter'rs command statements Tag: 65966
  - 12
    - difference between output and returnValue sqlParameter ? Hello ! Can someone please explain to me what the difference between "output" and "returnValue" as direction for sqlParameter in a stored Procedure ? Thanks, Lanz Tag: dataAdapter'rs command statements Tag: 65965
  - 13
    - COM+ vs ADO.NET I am a newbie in .NET, I am trying to implement Database access components which need to handle transaction management and concurrency control. I have been seeing that the COM+ provides functionalities on transaction management, but is the difference between the COM+ transactions and the transactions in ADO.NET? And which one should i use to get a better performance or which one is simpler to implement? Tag: dataAdapter'rs command statements Tag: 65964
  - 14
    - DataRow Position How can I find the DataRow position into the DataRowCollection when I have got the DataRow object after a call to DataTable.Find or Select (C#) Thanks Tag: dataAdapter'rs command statements Tag: 65961
  - 15
    - how can export datatable to excel how can export datatable to excel i try to use new excel application then fill data to excel but it very slow how can i to do export datatable to excel fast thanks Tag: dataAdapter'rs command statements Tag: 65960
  - 16
    - Is Data Binding for Drop Down box slow? Project is on ASP.NET+VB.NET. We are using many binded drop down boxes in the project. Page display is slow, is this because of binding of data? What are the alternate approaches please. Thanks, Raghavendra Narayana Tag: dataAdapter'rs command statements Tag: 65949
  - 17
    - Updating a DataTable as opposed to a DataSet Hi, I have loaded up some data into a DataTable as opposed to a Dataset. The DataAdapter allows this. I don't need all the associated stuff with the DataSet and this is why I have chosen the DataTable. However I'd like to update the changes to the DataTable to the database it was loaded from. The DataAdapter can update a dataset but not a datatable. How can I do this then without having to resort to a manual procedure. Does the version of the .NET framework I'm running make a difference. I have 1.0. Does 1.1 support updating of DataTables. Thanks, Nick Zdunic Tag: dataAdapter'rs command statements Tag: 65940
  - 18
    - param array and stored procedure call Is there any way to modify the following code so I can run it with any number of paramNames as well as any number of paramValues? So far it works with an array of paramValues, but since you can only pass a variable number of parameters in the last parameter of a method, I'm stumped. Perhaps the paramValues could be multidimensional? And a (?) has to be present for each paramName as well, correct? Thanks in advance. public DataSet returnStoredProc(string spName, string paramName, params Object[] paramValues) { OdbcDataAdapter _da = new OdbcDataAdapter(); DataSet _ds = new DataSet(); OdbcConnection cn = new OdbcConnection(connectionString); try { OdbcCommand _cmdSel = new OdbcCommand(); OdbcParameter prm = new OdbcParameter(); cn.Open(); _da.SelectCommand = _cmdSel; _cmdSel.CommandText = "{CALL " + spName + " (?)}"; _cmdSel.CommandType = CommandType.StoredProcedure; _cmdSel.Connection = cn; for (int x = 0; x < paramValues.Length; x++) _cmdSel.Parameters.Add("@" + paramName, paramValues[x]); _da.Fill(_ds); return _ds; cn.Close(); } } Tag: dataAdapter'rs command statements Tag: 65934
  - 19
    - Hello I need help about to use the component CrystalResport or Reports in C#......Yuni Tag: dataAdapter'rs command statements Tag: 65933
  - 20
    - ExecuteReader and output params Hi I am trying to run SP using ExecuteReader for SqlCommand object. SP has Output parameters that I add to Parameters collections but it seems that output parameter is always null. Debugging SP return not null values so it is not a problem with SP. Does ExecuteReader skips output parameters? Thanks, Shimon. Tag: dataAdapter'rs command statements Tag: 65925
  - 21
    - Excluding Noise Words from Search How can check if a search phrase contains a noise word and let the user about it so he/she can do search again without the noise word. Thanks, -- Dino Buljubasic Software Developer http://rivusglobal.com Tag: dataAdapter'rs command statements Tag: 65923
  - 22
    - Connection class Hi How can I create and call a class for a connection to my database? Code example would be great. Thanks Regards Tag: dataAdapter'rs command statements Tag: 65922
  - 23
    - RowFilter - Accent Insensitive with Strings Hello Folks! I have a SQL Server table column and two records. One column have "Porão" and the other "Porao". I want filter my dataview using the RowFilter property. example: dv.RowFilter = "column = 'Porao'" datagrid.datasource=dv datagrid.databind(); I need to see two records. But i see only one because the filter use accent sensitive when searching. Is there a way to configure the dataset for accent sensitive? Tks Robson Tag: dataAdapter'rs command statements Tag: 65920
  - 24
    - Wild card search I am trying to simulate wild card search like for example: cran* would return any word containing 'cran' at the begining *cran would return any word containing 'cran' at the end *cran* would return any word containing 'cran' in the middle Here is whay I am doing but it does not work SELECT whatever FROM aTable WHERE this = that AND CONTAINS(aColumn, "cran+%") I am fetching data from an SQL Server using full text indexing Any help will be appreciated -- Dino Buljubasic Software Developer http://rivusglobal.com Tag: dataAdapter'rs command statements Tag: 65918
  - 25
    - DataBinding Dataset from a WebService Hi, I have some problem Binding a dataSet that come from a method in a WebService I created. My Web forms call the function from the WebService and receive the dataSet. How can I bind this dataSet to a dataList and some Textfields. What I want to do is select the result in the dataList then the selected result appears in textField so I can update those field. Does anyone have a clue? CG Tag: dataAdapter'rs command statements Tag: 65912
- Next
  - 1
    - RowState Issue In using a datagrid, when I modify the second row in the grid, the first row is also taking on a rowstate of modified, even though it has not been touched. I am sure of this, as checking rowstate prior to modifying the second row shows the first row to be Unchanged. Anyone have any clues about this issue? Thanks. JT Tag: dataAdapter'rs command statements Tag: 65908
  - 2
    - Dataset and Bindings HI All, 1) I open up a dataset (declared at the module level) 2) I get the data with the .FILL using the DataAdapter 3) I update a DataGrid RecordSource property to the DataSource 4) I update the DataBindings of a Text box to one of those fields. Now, the data loads into the datagrid and the text box just fine. When I move around in the datagrid, it changes the value in the text box. Now, how do I change the current record using code? I've tried using the: me.bindingcontext(dsCustomer, "dtCustomer").position Modifing this values does not modify the control on the screen and changing the record position on the screen does not change the bindingcontext.position value. Any help is appreciated. Dave. Tag: dataAdapter'rs command statements Tag: 65907
  - 3
    - How to Bind ListBox for Windows Form(VB.NET) Hi, 1)I have List Box which displays all user list, When I double click on User , I am displaying User Information on the right hand side Text Boxes , But In Order to Retrive the values I can't query with User Name because there are duplicate names , So I Want to find details about the user with his/her ID#. How would I do that when I bind the ListBox at the FormLoad event. 2)How could I Call another form from other form by using formname.show ( used to be in VB 6). thanks, Saurabh Tag: dataAdapter'rs command statements Tag: 65903
  - 4
    - DataView Filter Not working I am using the following code to filter a DataView and then put the dataview back into a DataSet. I've verified that strFilter contains 683 values. The dataview initially has 1306 records before the filter. However, the resulting dataset that comes out has all 1306 rows. How is this possible since I'm filtering on 683 unique values? I'd appreciate any help -Tim //create a dataview for the dataset //DataTable oDT = oDS.Tables["Results"]; DataView oDV = new DataView(oDS.Tables["Results"]); DataTable oDT = new DataTable(); try { if(strFilter != "") { //filter the dataview with the previous work ids oDV.RowFilter = "WorkID IN (" + strFilter + ")"; } } catch(Exception err) { Response.Write("Error: " + err.Message.ToString()); } //Convert the DataView back to a DataSet oDT = oDV.Table.Copy(); oDS = new DataSet(oDV.Table.TableName); oDS.Tables.Add(oDT); Tag: dataAdapter'rs command statements Tag: 65902
  - 5
    - Book? Looking for a good C# ADO.net book. Any suggestions? Tag: dataAdapter'rs command statements Tag: 65897
  - 6
    - DataAdapter update method fails Hi. I got a problem with the OleDbDataAdapter object in .Net. The case is: I fill a dataset with data from an XML-file. This works fine. I then want to store the data into a database. This also seems to work fine. The problem ouccurs when I try to update the data in the table. If I read the same XML-file into the dataset and perform the Update method of the dataadapter it throws this Exception: ORA-00001: unique constraint (SOME.TABLE) violated Source code: ################################################################ Dim cb As New OleDbCommandBuilder(OleDbDataAdapter1) DataSet1.ReadXmlSchema( _ "H:\temp\foo.xsd") DataSet1.ReadXml( _ "H:\temp\foo.xml") OleDbDataAdapter1.Update(DataSet1) Catch ex As Exception Console.WriteLine(ex.Message) End Try ################################################################ It seem to me that the dataadapter trys to do an insert and fails because there already is a row with the same values in the table. Anyone got a clue how to solve this? Lars Tag: dataAdapter'rs command statements Tag: 65894
  - 7
    - Convert Dataset to ADODB.Recordset In order to reuse UI code in VB6 (for now) while we re- write server components. We want to be able to return ADODB.Recordsets from .NET code. This is what I have found so far http://support.microsoft.com/?id=316337 but I was wondering if there is a better solution. Tag: dataAdapter'rs command statements Tag: 65892
  - 8
    - How to lock a table or a database using VB.NET and ADO.NET with SQL Server 2000? Hi, I have a few question regarding Locking question. I'm using VB.NET and my Database is SQL Server 2000. 1) Certain part of my application, I need to lock the whole table to prevent other user from using it, how should I lock it to prevent user access the table. 2) There's one part of my application, I need to lock the whole database (block user) when I want to transfer the records from the working table to the storage table then release the lock after I'm done. How should I go about doing it? Regards Vanessa Tag: dataAdapter'rs command statements Tag: 65891
  - 9
    - SqlConnection I do an "SqlConnection" open and then a close, but the connection to the SQL server is not released. If I do a SP_WHO on the server I still see the connection. How to I get the connection to drop? Thanks -- CWee Tag: dataAdapter'rs command statements Tag: 65887
  - 10
    - renaming an element in a schema/dataset I read some xml data through a stream, and pass it to a dataset for it to read. First i initialize the dataset with an xml schema. The schema matches the data i get from the stream, but i want to change the name of some of the columns. Normally i would add some mappings to the dataadapter, but since i'm not using a dataadapter (there is no database involved - i get the xml data from a webservice) i don't know how. Is there any way you can define your schema, so it reads the correct data, but renames the column kinda like this: <xs:element name="date" type="xs:string" renamed-to="start-date" /> As far as i can see, there is no such attribute on the xs:element - or any other way to do it? All i want to do, is rename the column name and still (preferably) keep the relations to other tables/columns, without having to loop through the dataset creating a new one with different column names. Thanks! Tag: dataAdapter'rs command statements Tag: 65881
  - 11
    - Deserialize problem with OracleException On August 19, 2003, a reader discovered that he couldn't deserialize an OracleException. He began a thread with Scot Rose of Microsoft where he described the nature of the problem. The reader wrote, "We have narrowed it down to the constructor OracleException (System.Runtime.Serialization.SerializationInfo si,System.Runtime.Serialization.StreamingContext sc), which looks for members "message" and "source", but the GetObjectData (...) method in the base (System.Exception) uses the strings "Member" and "Source". Since the element lookup in SerializationInfo is case sensistive, GetElement() and FindElement() fail and the OracleException deserialize throws an exception." Scot Rose asked for a small project and the reader provided one. There is no record of a response from MS. So here's another project, a console app, that demonstrates the problem. I am running framework 1.0 with a "hotfix" version of System.Data.OracleClient.dll, version 1.0.1088.0 that fixes some of the MANY bugs in this provider. Can someone from MS follow-up on this bug and provide a work-around? Imports System.IO Imports System.Data.OracleClient Imports System.Runtime.Serialization Imports System.Runtime.Serialization.Formatters.Binary Module Module1 Sub Main() Dim conn As New OracleConnection("Data Source=ussxt6;User Id=foresight_mcp;Password=xxx") Dim cmd As New OracleCommand("select * from blah_blah", conn) ' will throw "Table or View does not exist" Dim reader As OracleDataReader Try conn.Open() reader = cmd.ExecuteReader() Catch e As OracleException Dim formatter As New BinaryFormatter() Dim stream As Stream = File.Open ("c:\temp\foo.bin", IO.FileMode.Create, IO.FileAccess.ReadWrite) formatter.Serialize(stream, e) stream.Close() stream = File.Open("c:\temp\foo.bin", FileMode.Open, FileAccess.Read) Try Dim obj As Object = formatter.Deserialize (stream) Catch xx As Exception MsgBox(xx.ToString()) End Try Dim phoenix As OracleException = CType (formatter.Deserialize(stream), OracleException) MsgBox(phoenix.ToString()) Finally If Not reader Is Nothing Then reader.Close() If Not conn Is Nothing Then conn.Close() End Try End Sub End Module Tag: dataAdapter'rs command statements Tag: 65872
  - 12
    - Detach SQL-Server Database from .NET Hi, I want to detach an SQL-Server database; what I'm doing is this: - Define an SQLCommand object with some SQLConnection - Change the database context to 'master' by setting "Database='master'" in the ConnectionString property of the SQLConnection - Set the CommandText of the SQLCommand object to something like "EXEC sp_detach_db @dbname=N'NameOfDatabaseToBeDetached'" - Open the connection - Call the ExecuteNonQuery() method of the SQLCommand object. My problem is: the database to be detached will always be reported as currently in use (error number 3703). Obviously, although I set the database context to 'master' explicitly, the established connection to the database to be detached seems to remain. How can I break the connection to this database? Thanks for an answer! Axel. Tag: dataAdapter'rs command statements Tag: 65871
  - 13
    - Problems with OleDbDataAdapter with parantheses When I try to run a select through the adapter with a parantheses at the start of the select, the adapter will not run the select, and thus returning a empty dataset back. e.g (SELECT * FROM A UNION SELECT * FROM B) UNION (SELECT * FROM C UNION SELECT * FROM D) Even the simplest select will fail if it starts with (. Anyone have a solution for this problem? I use "Provider=MSDAORA.1;Password=test;User ID=test;Data Source=MyTestDB" as connection string The following code Dim objAdapter = New OleDb.OleDbDataAdapter(sPSQL, sConnection) Dim objDataSet = New Data.DataSet() Call objAdapter.Fill(objDataSet, coReturnValue) I can connect to the DB and run the selects without any problems. Thanks! Tag: dataAdapter'rs command statements Tag: 65868
  - 14
    - Typed Dataset issue, Is this a bug IN VS 2003? I genereated typed dataset using several dataadapters in VS 2003. Now if I go to dataset view and click on property of any col. change it (for exsample make col. nullable) and save dataset, VB file associated with datase is gone. According to documentation vb file should be regenerated after each save of the schema. Am I doing something wrong? Is there anyway to manually force VS generate typed dataset based on excisted schema? I believe I was able to change schema in VS UI and VB file got updated automaticaly in VS 2002. Tag: dataAdapter'rs command statements Tag: 65867
  - 15
    - clob into oracle Can any one give me an example of using the microsoft .net managed provider for oracle to insert a clob into the database. We have a stored procedure which takes a clob as a parameter, but are struggling to populate a clob type parameter with the text we want to save. Tag: dataAdapter'rs command statements Tag: 65865
  - 16
    - Simple Timeout question Hello, just been trying to find the answer to what I think should be a rather simple question but can't seem to find a definite yes or no. Anyway question is, are asp dot net pages (aspx) subject to the same script timeout that normal asp pages are? IE after the default 90 seconds would the aspx through a timeout or will they carry on until an error or the page has finished running. I tried the following lowering the script timeout to 30 seconds and then adding the following line Thread.Sleep(120000) (which should tell the thread to sleep for 2 minutes) but it carried on till the sleep command finished and displayed the page as normal. If it is the case that the timeout does not apply to aspx pages, is there some property in the web.config that can set a time or is best practices to have something within the classes that knows when and how to stop a particular process if it appears to be taking to long. are there any msdn articles that discuss these things (I haven't had much luck so far but it is monday morning). Or is asp.net sufficiently different to not require the web server to timout if an action takes too long(in asp it was there to safeguard future requests from having to wait to long). Harry Tag: dataAdapter'rs command statements Tag: 65860
  - 17
    - A possible solution to my own question For the public's interest : I managed to do this by cunstructing a new DataSet , and filling it's rows dynamically , then binding a DataGrid to it. When filling the DataSet , I am using my existing DataSet with foreach , and getting it's parent and child columns when needed. not very efficient , but works 100%. Tag: dataAdapter'rs command statements Tag: 65857
  - 18
    - DataGrid Is it possible to display in a data grid rows from two realted tables ? example : Ther are two tables , ORDERS , and CUSTOMERS Order no.| customer ID| customer name --------------------------------------------------- 4 | 4 | moshe 5 | 4 | moshe etc... Tag: dataAdapter'rs command statements Tag: 65856
  - 19
    - Getting a Delete Command to work using Dataset & Data Adapter I'm using an Infragistics UltraWinGrid. After deleting the ActiveRow from the Grid, I get the following message: ---------------------------------------------------------------------------- ------------- An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: Update requires a valid DeleteCommand when passed DataRow collection with deleted rows. ---------------------------------------------------------------------------- ------------- So I attempted to manually delete the row from the data table after it was deleted from the Grid. dataSet_uGrid.tblItems.Rows[rowID].Delete(); dataAdapter_uGrid.Update(dataSet_uGrid, "tblItems"); But still get the same error message. Why is this so hard to commit the Delete Command to the database?? thanks. Tag: dataAdapter'rs command statements Tag: 65855
  - 20
    - How can I add or Delete records using DataGrid and dataAdapter?? Hi, I want to use datagrid to add/modify/delete record using datagrid. I load some table in dataset then set datagrid.datasourse = dataset. I tried to add record from datagrid, but it didnt work. It shows errors that has not new added records. If I add new row into table, It shows duplicate error. my some code here.. dataadapter.fill(dataset, tb1) dataGrid.dataSource = dataset.table("tb1") then i click add button. dataset.table("tb1").getchanges(rowstate.added) dataAdapter.InsertCommand=("Insert into tb1 (@id,@name,@age)") ******* I've set dataAdapter parameters and value here ******* dataAdapter.update(dataset, "tb1") dataset.table("tb1").acceptChange() Thanks, Kwok Tag: dataAdapter'rs command statements Tag: 65851
  - 21
    - Transaction State Dear M$, I think after paying $$$ for your products I do deserve to have the State propery in SqlTransaction. Please do not waste time on answering how I can overcome this limitation, just give me the State propery. MH Tag: dataAdapter'rs command statements Tag: 65849
  - 22
    - Sql Server CE How i can pull data between Sql Server and Sql Server CE Tag: dataAdapter'rs command statements Tag: 65848
  - 23
    - Copy data from DataTable to another ? Hello, What is the best way to create a new DataTable with data from exists DataTable i have already in my application ? Thanks, Boba. Tag: dataAdapter'rs command statements Tag: 65847
  - 24
    - MS-SQL and Oracle StoredProc In MS-SQL, when I want to use stored proc to query data out from the server and process it in ADO.NET DataAdapter / DataReader stuff. I don't have to bind the "out" parameter for getting the output. However, for Oracle DBRS, I need to create an additional "Cursor" output parameter, and I've to bind one more additional parameter. It makes my data access layer inconsistent. I've to seperate them. Does it has a easier way to solve this problem without duplication of my "query" codes ? Tag: dataAdapter'rs command statements Tag: 65846
  - 25
    - How can i get the size of the datatable? Hi,All: How can i get the size of the datatable(including data in the datatable) in memory? Thanks David Tag: dataAdapter'rs command statements Tag: 65843

Do I need to fill all the 3 commands ( InsertCommand, DeleteCommand
and UpdateCommand), even though I'm using only one of them ?
Like if I wants to update records in db, I'm sure that I have to
assign the UpdateCommand, in this scenario, do I need to assign the
Insert and Delete statements also ?

TIA
Kishore

Top

Re: dataAdapter'rs command statements by Bernie

Bernie
Tue Sep 16 22:35:05 CDT 2003

Hi Kishore,

No, you need only the command that you will be using.

HTH,

Bernie Yaeger
"MeDhanush" <medhanush@yahoo.com> wrote in message
news:15e9d0f4.0309161212.506cd286@posting.google.com...
> Do I need to fill all the 3 commands ( InsertCommand, DeleteCommand
> and UpdateCommand), even though I'm using only one of them ?
> Like if I wants to update records in db, I'm sure that I have to
> assign the UpdateCommand, in this scenario, do I need to assign the
> Insert and Delete statements also ?
>
> TIA
> Kishore

Top

Re: dataAdapter'rs command statements by Jeff

Jeff
Tue Sep 16 23:30:06 CDT 2003

If you are not going to use them then no you should not have to have them,
but you can set the programtically in your code at any time i believe.
Are you getting errors or are you just curious?

"MeDhanush" <medhanush@yahoo.com> wrote in message
news:15e9d0f4.0309161212.506cd286@posting.google.com...
> Do I need to fill all the 3 commands ( InsertCommand, DeleteCommand
> and UpdateCommand), even though I'm using only one of them ?
> Like if I wants to update records in db, I'm sure that I have to
> assign the UpdateCommand, in this scenario, do I need to assign the
> Insert and Delete statements also ?
>
> TIA
> Kishore

Top