getting a row out of a data set based on a key

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
    - Column is not retrieved correctly in ADO.NET Is there a known bug with ADO.NET returning incorrect data from Microsoft Access on calculated fields? I am not sure if it is the calculated fields but that is what I am thinking. Please note that everything runs correctly directly from MS Access 2000, and it works with ADO in VB6. We are converting this app from VB6 to .NET. Here is what is going on I am calling a union query in a MS Access database through ADO.NET and filling a dataset, then a dataview with the data retrieved (Note: I also get the same problem when I bypass the union and pull in everything directly from the queries that are being called in the Union query). I then loop through the records using a datarowview. All of the columns come in correctly except for one. This column comes in as something totally different than what it should be, for example, if the column is supposed to have a value of .06000000000013097 it comes in as DBNull. It will occasionally come up with the correct value, but normally it comes up with DBNull, and sometimes it comes up with a totally different number. Another question I have related to this is if it runs correctly in Access, why would it not run correctly in ADO.NET? I always thought the way ADO worked is that it called a procedure; the procedure was run in the environment it was called from (SQL, Access, etc.), and then it returns the records back to ADO. Obviously, it does not work that way in this situation, could someone explain that to me? Thanks in advance for all the valuable insight everyone always provides Bo Tag: getting a row out of a data set based on a key Tag: 80451
  - 2
    - Bug/Error when assigning to DataTable the IDataReader.GetSchemaTable. Bug or Error Assigning to DataTable the IDataReader.GetSchemaTable. Used a OleDbCommand to populate the IDataReader with code: OleDBCommand.Create('Select * From [' + sOrig + ']', ConnOrig) There is an error if an MS Access table has a text field size of 254 but 200 works fine. Exact error: "The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still receivable" Tag: getting a row out of a data set based on a key Tag: 80446
  - 3
    - command to auto generate data adapters sel,upd,and delete commands? I cant remember what its called but isnt there a command that will auto generate the select update and delete commands for a data adapter at runtime? based on a query you have... Tag: getting a row out of a data set based on a key Tag: 80445
  - 4
    - Output parameter not fed I'm trying to call the following SP (on a SQL 2000 database CREATE PROCEDURE fsp_NextSequenceCd @Entity as varchar(50) @Sequence as varchar(50) OUTPU A [... Which basically retreive the next sequence ID for the specified Entity. It works fine when called in VB6 or in SQL Query Analyser However, the following VB.Net code will not work (An empty string is always returned in the Output parameter) Public Function GetNextSequence(ByVal Type As enSequenceType) As Strin Dim Command As New SqlClient.SqlComman Command.Connection = mConnectio Command.CommandType = CommandType.StoredProcedur Command.CommandText = Me.CST_SP_NEXT_SEQ_C Dim NewParam = New SqlClient.SqlParamete NewParam.Direction = ParameterDirection.Inpu NewParam.ParameterName = "@Entity NewParam.SqlDbType = SqlDbType.VarCha NewParam.value = "LOT Command.Parameters.Add(NewParam NewParam = New SqlClient.SqlParamete NewParam.Direction = ParameterDirection.Outpu NewParam.ParameterName = "@Sequence NewParam.SqlDbType = SqlDbType.VarCha NewParam.value = System.Data.SqlTypes.SqlString.Nul Command.Parameters.Add(NewParam Command.ExecuteNonQuery( Return Command.Parameters.Item("@Sequence").Valu End Functio Tag: getting a row out of a data set based on a key Tag: 80435
  - 5
    - DataSet -> DataReader Is it possible to get a DataReader object from a DataSet/DataTable ? If so would it be disconnected ? in other words could I return a populated DataReader object from a class that contains a DataSet ? Tag: getting a row out of a data set based on a key Tag: 80425
  - 6
    - CrystalReports.NET and Datasets.xsd When useing a Crystal Report (CR) bound to a dataset.xsd, the paramenter do not show up in the CR Field Exploere. The parameters are defined in the stored proc that I used to create my dataset. file. Yes I can access them via my VB.Net code, but I am unable to access them and their values from within my CR document formula code Is there a way to access these paramenters from within my CR document Formulas Thank Bria P.S. I am able to do this with an ADO bound connection to a SQL SP, but I have a need to use the Dataset.XSD file Tag: getting a row out of a data set based on a key Tag: 80424
  - 7
    - Populating a Typed DataSet with the MS Data Application Block Hello all, Has anyone had any luck populating a Typed DataSet using Microsoft's Data Application Block? If so, could you kindly provide some guidance? My Typed DataSet consists of 5 tables: one un-related to the others, one parent, and 3 direct children of the parent. I can provide more detail if necessary. Thanks for any advice or suggestions, Mike Best Tag: getting a row out of a data set based on a key Tag: 80423
  - 8
    - MySqlCommand timeout Hi, I use the native OleDb driver for MySql from ByteFx in my c# application. When i try to set the command timeout on a MySqlCommand object I get the following exception: Unhandled Exception: System.NotSupportedException: Specified method is not supported. at ByteFX.Data.MySqlClient.MySqlCommand.set_CommandTimeout(Int32 value) Any idea why this functionality isn't implemented or alternatives to shorten the command timeout? Thanks in advance Tag: getting a row out of a data set based on a key Tag: 80421
  - 9
    - ado.net (insert command) I am new to vb.net and ado.net. I am trying to insert some data fom 3 testboxes into an access db and on the form is an add button. This is the code for the add btn: Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click Dim cn As String = txtcn.Text dbmanager.connect() dbmanager.insertsql("insert into carinfo (Car Name) values('pip')") End Sub Tag: getting a row out of a data set based on a key Tag: 80419
  - 10
    - How to insert c# DateTime? Is there some way to insert a c# datetime in a table without dealing with culture? The datetime object probably has som internal representation thats culture independant and the database probably stores datetime internally as a long. If i try to insert like this: insert into x(somedatefield) values ('datestring') then i have to format the datetime object in some culture specific string and make sure the database uses the same format. Is there some way to insert a date without dealing with culture settings on client and db server? Tag: getting a row out of a data set based on a key Tag: 80417
  - 11
    - Format Data in BoundColumns of DataGrid Hi I want to format some columns of my DataGrid control. Example, one of my fields of DataSet is a DATE field and in BD he is Ok, but when I show him in datagrid he comes with hours too. I don´t want that. 2nd Example: Field in BD: DtSegm 17-02-2004 Note: When I save to DB I format Date to put like above In DataGrid shows like this: DtSegm 17-02-2004 10:30:45 How can I change that. -- Thank's (if you try to help me) Hope this help you (if I try to help you) ruca Tag: getting a row out of a data set based on a key Tag: 80414
  - 12
    - Table Mappings and Multiple Tables to XML Hi I understand that a dataadaptor can have multiple tablemappings, but how can I get the schemas and or xml data of multiple tables to be written to the same file, in one action, but have it so each table is separated in its own block? The below code shows 2 tables, but the select statement only retreives all rows from one of the tables. Need some way select all from both tables but when written to xml, they are separate tables? OdbcDataAdapter myAdapter = new OdbcDataAdapter(); myAdapter.TableMappings.Add("Address", "DataAddress"); myAdapter.TableMappings.Add("Products", "DataProducts"); //myConnection.Open(); OdbcCommand myCommand = new OdbcCommand("SELECT * FROM \"Address\"", myConnection); myCommand.CommandType = CommandType.Text; myAdapter.SelectCommand = myCommand; DataSet ds = new DataSet("AllData"); myAdapter.Fill(ds); ds.WriteXml("d:\\AllData.XML", XmlWriteMode.WriteSchema); Thanks in Advance David Tag: getting a row out of a data set based on a key Tag: 80413
  - 13
    - Database independent design... Hi, I'm basically a .NET newbie... My company is going to develop a solution that we would like to be as database independent as possible. I have downloaded the DataAccessManager from www.gotdotnet.com and it seems like a good idea to use this or something similar. - Anyone have any experience with DataAccessManager? I have some problems getting started since I can't find any documentation. - Is there other solutions available? - Can anyone please outline a preferred strategy or direct me to some resources on the topic? I greatly appreciate all help, Trygve Tag: getting a row out of a data set based on a key Tag: 80411
  - 14
    - Change Font Size in the SQL pane using server explorer Hi, please advise how to change teh font size in the SQL pane when using the server explorer. Peter Tag: getting a row out of a data set based on a key Tag: 80409
  - 15
    - DataTable.Select with nested Parent fields I want to make a selection from a DataTable using the Select method with the criteria including a nested parent field. Both of these works fine (Northwind data): DataRow[] drs = ds.Tables["OrderDetails"].Select("Parent(Orders2Details).ShipName LIKE 'A%'"); DataRow[] drs = ds.Tables["Orders"].Select("Parent(Customers2Orders).CompanyName LIKE 'A%'"); But when I try to... DataRow[] drs = ds.Tables["OrderDetails"].Select("Parent(Orders2Details).Parent(Customers2Or ders).CompanyName LIKE 'A%'"); ...it doesn't work! I've looked everywhere without finding any clue on how the syntax for a nested parent reference would look. Any input would be appreciated! Tag: getting a row out of a data set based on a key Tag: 80407
  - 16
    - Merge doesn't merge Perhaps I have the concept all wrong, but based on the documentation and books I have read it seems this should work. I have multiple complex datasets in an access db. They have 2 shared primary keys. I have another dataset that shares one key with them. I need to end up with a single flat dataset comprised of the merged sets. In a simpler world it would be a normal sql join, but that is not an option. Right now, I would love for someone to point out my stupidity and show me the magic setting I have forgotten. An additional complication is that the last dataset - the one with just one key was a "relation" issue because that field in the other table was not unique values. It would be a many-to-one relation. I have tried using both the relation AND the merge to no avail. I am not modifying this data. I just need to read it in, merge it based on the key values, and kick it out as a single table. As a test I tried creating a more simple 2 table set (in ms sql), read them into datasets, and tried to merge. I just do not ever see a merged result. here is the code that goes with a simple webform with one datagrid. Dim ds1 As New DataSet() Dim ds2 As New DataSet() Dim da1 As New SqlDataAdapter() Dim da2 As New SqlDataAdapter() Dim cn As New SqlConnection() cn.ConnectionString() = "server=daddy;database=test;uid=test;pwd=test" cn.Open() da1.SelectCommand = New SqlCommand("select * from table1", cn) da1.Fill(ds1, "tbl1") da2.SelectCommand = New SqlCommand("select * from table2", cn) da2.Fill(ds1, "tbl2") ds1.Merge(ds2, True, MissingSchemaAction.Add) DataGrid1.DataSource = ds1 DataGrid1.DataBind() Tag: getting a row out of a data set based on a key Tag: 80406
  - 17
    - Column Expression question Hello! After filling table into DataSet (ds), I added following line ... ds.Tables(0).Columns("MyColumn").Expression = "<MyFormula>" ... and calculation is working fine - but I need to save this calculated field value into database also because it makes easier to make SELECT queries later and it's quite often needed value in many cases too. This "MyColumn" is as a field in database too, and is used too when making DataAdapter in SELECT-query. When trying to save, I'll get error message ... "The column mapping from SourceColumn 'MyColumn' failed because the DataColumn 'MyColumn' is a computed column." Is it possible to save computed column values into database table at all? -- Thanks in advance! Mika Tag: getting a row out of a data set based on a key Tag: 80403
  - 18
    - SqlDataReader with no rows. I am using a sqldatareader with this command: select max(id) from x If there is no rows in table x then using sqldatareader.read() still return true as if there is a row, which means this code breaks: if (sqldatareader.read()) { ... = sqldatareader.GetInt32(0); // field 0 is null!? } All the examples i have seen on ms website and in books dont take any precautions for empty tables. Right now i am doing this: if (sqldatareader.read() && !sqldatareader.IsDBNull(0)) { ... = sqldatareader.GetInt32(0); } It seems clumsy. I am doing somthing wrong here? Tag: getting a row out of a data set based on a key Tag: 80395
  - 19
    - Problem with OLE DB Provider Hi, I am working on an ASP.NET application. From a page, I am triggering export of a large dataset into an Excel file using OLE DB Provider and after the export is complete the user is redirected to the excel file. Note that the operations here are synchronous. The problem is the data exported is not getting written out to the disk before the user is redirected. So I get an empty excel file in IE while if I check the actual file on the disk, the data seems to be there after a lag of a few seconds. From the KB article, I learnt I cannot set the Max Buffer Size property in OLE DB cannot be set in ADO.NET. How do I ensure that the data is flushed to the disk before I redirect the user to the file? Thanks in advance, Pranav Tag: getting a row out of a data set based on a key Tag: 80390
  - 20
    - Datagrid Column Width I found the following code on microsoft.support.com which is supposed to with of a column '---------------------------------------------- Dim ts As New DataGridTableStyle( ts.MappingName = "tbl_Client DataGrid1.TableStyles.Clear( DataGrid1.TableStyles.Add(ts DataGrid1.TableStyles("tbl_Client").GridColumnStyles("First_Name").Width = 17 '-------------------------------------------------------------------------------------- Where tbl_Client is the Table name and First_Name is the column Name But when I run the code I get the following error Object reference not set to an instance of an objec Thanks for your hel Tag: getting a row out of a data set based on a key Tag: 80389
  - 21
    - PRINT in transact-SQL Hi, I have a question regarding PRINT statement in transact-SQL. The following is my test environment * Vuisual Studion 2003, server explorer * either in SQL pane or using stored procedur The scenerio are like belo * alter procedure myProcedure as PRINT 'HELLO' <===== It work * alter procedure myProcedure as begin PRINT 'HELLO' end <===== It does not work Please advice Peter Tag: getting a row out of a data set based on a key Tag: 80385
  - 22
    - I Have No Identity This has been addressed several times and I've read several articles and posts and I still can't get this to work. (This is VB .NET) My understanding is that if I append a select statement to my DataAdapter's Insert statement that I should be able to get an updated resultset. I've got this: INSERT INTO dbo.FD_Files (FileName, ExpireTime, PostedBy, HashName, FileSize, Description) VALUES (@FileName, @ExpireTime, @PostedBy, @HashName, @FileSize, @Description); SELECT FileID, FileName, ExpireTime, PostedBy, HashName, FileSize, Description FROM dbo.FD_Files WHERE FileID = @@IDENTITY I've also tried using SCOPE_IDENTITY() - reagrdless, I always get the whole table returned. I need to know the identity of the record I just added and I keep getting a whole table. It's making me crazy. I've even tried setting the adapter's select command to SELECT FileID from FD_Files WHERE FileID = SCOPE_IDENTITY() and re-filling the dataset. I get the whole damned table. Why!!!!???? What am I missing? I've tried using the built in wizard which comes up with an insert statement just like the one above and I still end up with the whole table after I update. Can anyone shed some light on this? Thanks. Jerry Tag: getting a row out of a data set based on a key Tag: 80384
  - 23
    - Populate a DataTable (with Aggregation) from an existing DataTable Hi, I have a datatable with 2 keys columns, i need get this datatable with agregate totals. How can i do that? datatable Key1 Key2 Total 1 1 100 1 1 200 1 2 50 1 2 10 2 1 100 i need other dattable agregate totals key1 key2 Total 1 1 300 1 2 60 2 1 100 Tag: getting a row out of a data set based on a key Tag: 80383
  - 24
    - Calling Oracle date functions via ODBC and .NET Hi! I'm using ODBC to connect to an Oracle database. I want to do something like the following: --------- var conn: OdbcConnection = new OdbcConnection("my connect string here"); var sql: String = "update mytable set col1=?, col2=? where keycol=?"; var command: OdbcCommand = new OdbcCommand(sql, conn); command.Parameters.Add("@col1", OdbcType.Int, 22).Value = 1; if (some_test) { command.Parameters.Add("@col2", OdbcType.Date, 7).Value = 'SYSDATE'; } else { command.Parameters.Add("@col2", OdbcType.Date, 7).Value = null; } command.Parameters.Add("@keycol", OdbcType.Int, 22).Value = my_key; command.ExecuteNonQuery(); -------- My question is, how do I do that second parameter? How can I tell it to call SYSDATE, or set the value to null? I admit that I haven't tried this code, because I don't think that the string 'SYSDATE' is a valid date object. Should it work? Thanks, Ricky Morse Tag: getting a row out of a data set based on a key Tag: 80380
  - 25
    - generic function to execute a sql stored procedure hello, In my asp.net projects I like to seperate the database connection and lookups/executes from the code-behind pages using shared functions. I find myself often using a function that returns a datatable given a sql query and it works great. The function is contained in my 'dataaccess' class and is a shared function. I would really like to do the same thing with stored procedures. However, I'm running into problems handling the paramaters since there can be zero or more and of varying types/names. Ideally, the stored procedure's parameters can be defined in the parameters of the function (using an array?) and then the stored procedure is executed using the parameters within the function. Does anyone have code for executing any stored procedure using a generalized function? Is this even possible? Tag: getting a row out of a data set based on a key Tag: 80379
- Next
  - 1
    - Primary Key of string values (trims spaces from the end of strings) causes unique violation I'm loading a key values into a database and two may be identical except for maybe 1 or 2 trailing spaces. This causes a unique constraint error because for some reason it's trimming the string values when checking the unique contstraint I can clearly see in the dataset the string has spaces on the end. I know this is the exact problem because if I append a letter after one of them the exception goes away Why does it trim the string when validating the Primary Key unique constraint Thanks Jeff Tag: getting a row out of a data set based on a key Tag: 80377
  - 2
    - Top SECRET of making huge money!! Discovers the "Secret of making huge money" in just few weeks.... You shall be amazed that how easy 1 can make money on internet just for doing 1 time work..[I GUREENTED U CAN TOO MAKE BIG$$ WITH THIS PROGRAM]........ [Use IE if can't view the site] http://mysiteinc.com/gohar/index.html Tag: getting a row out of a data set based on a key Tag: 80376
  - 3
    - Max Connection Pool Reached ... Hi , " Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. " I am getting this error in my application. All requests to the Database go through the Data Access layer. And I am opening and Closing connections in the Data Access Layer. I cant seem to find out why this is still happening ? The Server Classes that I have are a mix of ServicedComponents and non-ServicedComponents and the Data Access Layer as such is marked as TransactionOption.Supported. How would COM+ affect pooling ? Any tips/pointers on how for further diagnosis would be helpful. Regards , Vikram Tag: getting a row out of a data set based on a key Tag: 80367
  - 4
    - No way to insert large data into oracle Clob??? Does anyone have the same problem? I use follow code to insert a large xml into oracle database. The data is inserted, however shows as "Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿.. xmlRawDom.Load("D:\testActual.xml" dataString = xmlRawDom.OuterXm Dim AE As New System.Text.ASCIIEncodin Dim ByteArray As Byte() = AE.GetBytes(dataString rsConnection = DBClient.OpenDBConnection(_realSuiteDBString, True tx = rsConnection.BeginTransactio Dim rsCommand As New OracleClient.OracleComman rsCommand = rsConnection.CreateCommand( rsCommand.Transaction = t rsCommand.CommandText = "declare xx Clob; begin dbms_lob.createtemporary(xx, false, 0); :tempClob := xx; end; rsCommand.Parameters.Add(New OracleClient.OracleParameter("tempClob", OracleClient.OracleType.Clob)).Direction = ParameterDirection.Outpu rsCommand.ExecuteNonQuery( Dim tempLob As OracleLo tempLob = rsCommand.Parameters(0).Valu tempLob.BeginBatch(OracleLobOpenMode.ReadWrite tempLob.Write(ByteArray, 0, ByteArray.Length tempLob.EndBatch( rsCommand.Parameters.Clear( rsCommand.CommandText = "Realdata_Rxbdoc.InsertXMLtoQ rsCommand.CommandType = CommandType.StoredProcedur Dim oraparameter As New OracleClient.OracleParameter("strXML", OracleClient.OracleType.Clob oraparameter.Direction = ParameterDirection.Inpu oraparameter.SourceVersion = DataRowVersion.Origina oraparameter.SourceColumn = "MSGDATA oraparameter.Value = tempLo rsCommand.Parameters.Add(oraparameter rsCommand.ExecuteNonQuery( tx.Commit( rsConnection.Close( ******************** procedure PROCEDURE InsertXMLtoQ(strXML IN CLOB ) A BEGI INSERT INTO ACTUALJOB (RXBDOC_ACTUALJOB_ID,MSGDATA) VALUES (1,strXML) END **************************** For small data, I can insert data directly like 'Dim conn As OracleConnection = New OracleConnection(_realSuiteDBString 'Dim cmd As OracleCommand = New OracleCommand("InsertXML", conn 'Dim s As FileStream = File.OpenRead("D:\rawActual.xml" 'Dim r As StreamReader = New StreamReader(s 'cmd.CommandType = CommandType.StoredProcedur 'cmd.Parameters.Add("strXML", OracleType.Clob 'cmd.Parameters(0).ParameterName = "strXML 'cmd.Parameters(0).Direction = ParameterDirection.Inpu 'cmd.Parameters(0).Size = r.BaseStream.Lengt 'cmd.Parameters(0).Value = r.ReadToEnd( 'conn.Open( 'Dim i As Int16 = cmd.ExecuteNonQuery( 'Console.WriteLine("{0} rows inserted", i But for large data,this method give error:'ORA-01460: unimplemented or unreasonable conversion requested Tag: getting a row out of a data set based on a key Tag: 80363
  - 5
    - DataSet.Merge question I have a dataset loaded with an xml that looks like this: <associations xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <association> <associationid>{8a3aca06-a7de-41a5-b584-063e7cf391bb}</associationid> <createdon>2004-02-17T12:05:40.3430000-05:00</createdon> <modifiedon>2004-02-17T12:05:40.3430000-05:00</modifiedon> <forwardrelation>Parent</forwardrelation> <backrelation>Parent</backrelation> <forwardnotes>ttt</forwardnotes> <backnotes/> <fromid name="" dsc="" type="1">{8c4a969b-2aa4-4679-b170-d9f6441f7c6d}</fromid> <toid name="" dsc="" type="2">{df3f306f-19de-4f50-9784-623bf6693fa8}</toid> <createdby name="" dsc="" type="8">{2479254f-1dee-41dc-b79b-8de686a4db29}</createdby> <modifiedby name="" dsc="" type="8">{2479254f-1dee-41dc-b79b-8de686a4db29}</modifiedby> </association> </associations> Then I try to merge another dataset loaded with another xml: <resultset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <contact> <contactid>{1323159A-E579-4A9B-95A2-5F9AFC041E28}</contactid> <fullname>Jones, Sally</fullname> <jobtitle>Lawyer</jobtitle> <accountid name="Jones&Jones" dsc="0">{EE22734B-F1A1-4B0F-B874-52FE2A3B1A6A}</accountid> </contact> <contact> <contactid>{DF3F306F-19DE-4F50-9784-623BF6693FA8}</contactid> <fullname>Dodd, Cindy</fullname> <jobtitle>Owner</jobtitle> <accountid name="Suburban Cycle Shop" dsc="0">{D17A8F20-D1D0-4F51-B365-92FDF16EDBE9}</accountid> </contact> <contact> <contactid>{54B82B18-D54D-4B6B-B114-73093D2A0070}</contactid> <fullname>Hayes, Scott</fullname> <jobtitle>Primary Owner</jobtitle> <accountid name="A&M" dsc="0">{3ABC2121-5315-4050-838D-477E04B37CE7}</accountid> </contact> <contact> <contactid>{8929CAD1-E941-4B6E-AAB7-A3D3062A9C71}</contactid> <fullname>Kennedy, Susan</fullname> <jobtitle>Finance Workout</jobtitle> <accountid name="A&M" dsc="0">{3ABC2121-5315-4050-838D-477E04B37CE7}</accountid> </contact> <contact> <contactid>{AADC8B14-27F3-4B03-8901-FC0929D48544}</contactid> <fullname>Block, Larry</fullname> <jobtitle>Sales Turnaround</jobtitle> <accountid name="A&M" dsc="0">{3ABC2121-5315-4050-838D-477E04B37CE7}</accountid> </contact> </resultset> Using the following syntax: associationDS.Merge(resultDS.Tables[0]); // assume the first xml has been loaded into associationDS and the second into resultDS There were no schemas involved and each DataSet is loaded via ReadXml(XmlTextReader) method. Things kind of work out ok as <contact> nodes are inserted right under <associations> root so that it looks like: <associations xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><association/><contact /></assocations> The only problem is that the resulting xml after the merge is missing <accountid> node under <contact>. What am I missing? Do I have to specify explicit schema info or relationship - note that <association> and <contact> are seemingly independant - ? Thanks much! Jiho Tag: getting a row out of a data set based on a key Tag: 80361
  - 6
    - Properties in VB = Parameters in .NET?? Hi! I have this problem... In Visual Basic I am work with ADODB and the next code work perfectly... Dim cmd as New ADODB.Command cmd.Properties(15).Value = 2 ... But in .NET.. OleDbCommand cmd = new OleDbCommand(); cmd.Parameters.add("15",2); ... this code throws an error: "An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: The ICommandWithParameters interface is not supported by the 'GXPublic.GXPublic.3' provider. Command parameters are unsupported with the current provider." How I can work with properties en .NET? thanks... pablo Tag: getting a row out of a data set based on a key Tag: 80357
  - 7
    - Binding INTEGER and use of NULL Hi I bind a textbox to a field in the database through CurrencyManager. Everything works find exept one thing: I cannot type Null, blank, nothing in the textfield. The property in the database allows NULL but I cannot type blank in the textbox. Whatever I type that isn't numeric is changed then I leave the textbox There must be an easy way to solve this - but what? /Raymond Tag: getting a row out of a data set based on a key Tag: 80355
  - 8
    - Stored Procedure Syntax Hi, I am attempting to updata a SQL Server record using the stored procedure's UpdateCommand. Everything works fine if all fields are full, but if a user clears out a textBox that originally contained a number in it, then the update bombs out. The field in the table is setup to accept nulls. What is the proper syntax to store it back? da.UpdateCommand.Parameter[1].value = ???? <a null> ????? Any help is greatly appreciated. Tag: getting a row out of a data set based on a key Tag: 80354
  - 9
    - DB_SEC_E_AUTH_FAILED(0x80040E4D). Hallo I have an import process that crashes after importing millions of data rows suddenly stops working with the error message System.Data.OleDb.OleDbException: No error information available: DB_SEC_E_AUTH_FAILED(0x80040E4D) The exception coccurs when making the connection to the Access 2000 databas objConnection.Open( Has anyone had this kind of error before As next I was going to check if this could be related to MDAC or if there is a problem with the sharing of the database connection. Any ideas would be welcome.. Thanks.. Nigel... Tag: getting a row out of a data set based on a key Tag: 80353
  - 10
    - Isolation Level Hi, We have an Asp.Net applcation with Sql Server as back end. I have a base class function that takes a SqlCommand Object as a parameter and returns a datatable. I want to set the Isolation to "Read Uncommited" (Sql Server's default Isolation Level is "Read Commited") as I am just selecting some data from the tables. When I try to do the following : objSqlCommand.Transaction.IsolationLevel = IsolationLevel.ReadUncommitted The system says IsolationLevel is a Readonly property. So the only option that I have currently is to set the Isolation Level to "Read Uncommitted" in the Stored Procedures. Is there a way to set it in the code so that I don't have to set it for each stored procedure. Thanks a lot. Tag: getting a row out of a data set based on a key Tag: 80350
  - 11
    - Does SqlHelper automatically close SQL connection? Suppose I want to do something like populate a droplist control with some data. I want to use as few lines of code as possible. In the examples for the Microsoft Application Data block, it shows a few ways of doing this. (Note that Global.GetSqlDataSource(string) returns a SQL connection string like this: "server=sqlserver.domain.com; uid=login; password=pass") CASE A: // Execute stored procedure to load list of data labels DataSet ds = SqlHelper.ExecuteDataset (Global.GetSqlDataSource("DATA"), CommandType.StoredProcedure, "usp_DataLabels_List"); dropDataLabels.DataSource = ds; dropDataLabels.DataBind(); In case A, how does the SQL connection get closed? Does the connection get closed after the dataset is assigned to ds? Or do I have to add something? What would I need to add? CASE B: // Execute stored procedure to load list of data labels dropDataLabels.DataSource = SqlHelper.ExecuteReader(Global.GetSqlDataSource("DATA"), CommandType.StoredProcedure, "usp_DataLabels_List"); dropDataLabels.DataBind(); In this scenario, where is the connection closed? Or does it create a leak? If I want to keep code minimal, should I make an object that inherits from SqlHelper, but calls this.Close() when it is finalized? Or do I need to write more code to allocate a connection seperately and then close it. Doesn't that defeat the purpose of the SqlHelper? Thank you very much! David Meet people for friendship, contacts, or romance using free instant messaging software! See a picture you like? Click once for a private conversation with that person! www.SEN.us *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: getting a row out of a data set based on a key Tag: 80347
  - 12
    - Connection recovery problem with OracleConnection Hi, I'm using ADO.Net C# with Oracle9i Release 9.2.0.4.0 when loosing the connection with the Oracle database server the connections doesn't recover and always returning the following exception even when the connection has been restore: "ORA-03114: not connected to ORACLE". I'm closing the connection properly in that it will return to the connection pool. Here is an example code: using(OracleConnection conn = new OracleConnection(connectionString)) { conn.Open(); using(OracleCommand cmd = new OracleCommand(sql, conn)) { object obj = cmd.ExecuteScalar(); } } This should close the connection properly. In the MSDN it is mention that if the connection pooler detect that the connection with the server has been severed it will remove the connection from the connection pool. It appears that this is not happening an I always get bad connections from the pool, even after the connection with the database server has been restore. How can I solve this? What is the proper way to recover from connection lost with database server? Thanks, Michael. Tag: getting a row out of a data set based on a key Tag: 80343
  - 13
    - adodb.connection problems Hello, I am having a problem with ADODB connection class. This was all working fine until I restarted the pc with last known good configuration, which seems to have screwed things up In the code below the conn.open command fails with a "cannot find stored procedure error". and system.runtime.interopservices.COMexception. The specified procedure could not be found. at ADODB.ConnectionClass.Open etc.. How can I fix this problem, do I need to re-install anything. I still have a reference to adodb Regard Robert Dim Conn As ADODB.Connection = New ADODB.Connectio GblConnectionString = "PROVIDER=SQLOLEDB.1;PASSWORD=" & txtPassword.Text & ";PERSIST SECURITY INFO=TRUE;USER ID=" & txtLoginName.Text & ";INITIAL CATALOG=Master" & ";DATA SOURCE=" & txtServerName.Tex Tr Conn.Open(GblConnectionString) '''*********** FAILS HERE******************* Catch e As Exceptio MsgBox(e.Message MsgBox(e.ToString End Tr Dim rs As ADODB.Recordset = New ADODB.Recordse Dim strRowSource As Strin Tr rs.Open("SELECT Name From sysdatabases WHERE Name NOT IN( 'master','tempdb','model','msdb','pubs','NorthWind')", Conn Catch e As Exceptio MsgBox(e.Message MsgBox(e.ToString MsgBox(e.Source End Tr Tag: getting a row out of a data set based on a key Tag: 80339
  - 14
    - Refreshing database cache Dear all I have written a windows service that connects to an Oracle 9 database on start up. I use a DataTable to hold a set of near static data. Recently there have been some overnight external batch updates to this table and my DataTable needs to be refreshed. Since this change of circumstances I have been restarting my service in the morning. I need to find a way to fresh my data object without restarting the windows service. I would be grateful for any pointers. Regards, Wazir Tag: getting a row out of a data set based on a key Tag: 80337
  - 15
    - Array as input parameter Hi all, I need a SQL stored procedure that has an input parameter of type array of datetimes. How to define such a procedure? if possible Thanks, Tag: getting a row out of a data set based on a key Tag: 80330
  - 16
    - need suggestion in Guid autogeneration in dataset Hi al I have PK with Guid type in typed dataset Is anybody have any suggestion how 2 implement autogeneration of P thnks Tag: getting a row out of a data set based on a key Tag: 80326
  - 17
    - System.Data.OracleClient Couldn't understand why following line of code is failing <%@ Import namespace="System.Data.OracleClient" % I am getting following error BC30466: Namespace or type 'OracleClient' for the Imports 'System.Data.OracleClient' cannot be foun Although I can see the System.Data.OracleClient in References and I have v1.1 framework installed. Tag: getting a row out of a data set based on a key Tag: 80325
  - 18
    - Timeout Expired error. Hi there! I am using MSDE 2000 SP3, Sql.Net provider on Win2k server. When I try to execute very simple query of inserting/selecting a row into a table, I am getting following error, "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." This behaviour is not consistent. I have checked my code for not leaving any connection open. Is there any limitation on number of connections on MSDE? Or is it a problem with Sql.Net provider? Please help me. Thanks in advance. Tag: getting a row out of a data set based on a key Tag: 80324
  - 19
    - FoxPro connect problems REGDB_E_CLASSNOTREG I'm using vs.net, clr 1.1, c# web application. I get the following error connecting to foxpro using its oledb driver. I've tried several ways to connect. No error information available: REGDB_E_CLASSNOTREG(0x80040154). [OleDbException (0x80040154): No error information available: REGDB_E_CLASSNOTREG(0x80040154).] [InvalidOperationException: The 'vfpoledb.1' provider is not registered on the local machine.] System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr) System.Data.OleDb.OleDbConnection.Open() Elkhorn.eCatData.Page_Load(Object sender, EventArgs e) in j:\projects\aproject\aproject\webui\data.aspx.cs:45 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain() I downloaded and installed the driver foxpro8 driver from: http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en I don't have any verison of foxprox on the machine. I registered vfpoledb.dll myself from the command line just to make sure. The connection tested ok with the "Test Connection" button when I used the designer. I think the connection string is fine, is as on connectionstrings.com. @"Provider=vfpoledb.1;Data Source=C:\progra~1\aproject\data\data1.dbc;Password=;Collating Sequence=machine"; Any ideas? ??? Tag: getting a row out of a data set based on a key Tag: 80320
  - 20
    - Concurrency violation, I don't understand! [This followup was posted to microsoft.public.dotnet.framework.adonet and a copy was sent to the cited author.] Hello everybody. I have a problem with an exception when I try to modify a row in a mssql db. The exception that I found is Concurrency violation. I read some other posts but I didn't find a solution. In effect with my code I want to replace all the strings inside a "info" attribute with the word "Hello" (This is a test, I know that this is a stupid thing, but I wanna make that). My code update 212 row but give me a concurrency violation in 7 roes. All these 219 rows are selected at the same time e stored inside the same table. The rows that I can't update are like the following: "IST. DI CLIN. CHIR. GEN. E TERAPIA CHIR. PROF.BATTEZZATI" But if I use SQL to replace this string with another one shorter (Like "IST. DI CLIN. CHIR. GEN. E TERAPIA PROF.BATTEZZATI" or "IST DI CLIN CHIR GEN E TERAPIA CHIR PROF BATTEZZATI" ) and then I run my code, it works fine and this line is replaced by the "Hello" word. In the db the info attribute is a nvarchar(90), I don't understand where is the problem. Is there some limit in the dimension of string that can be inserted in a datarow or datatable object? Thanks to everybody Tag: getting a row out of a data set based on a key Tag: 80318
  - 21
    - Stored procs to xsd example I have 3 pre-built stored procs and want to load the results of them into an xsd for processing. I've defined the XSD with different table and column names and would like to map these to each of the procs. I can change the names if necessary, but would rather map it, if for no other reason than to learn how to Does anyone have an example of how to do all this, or a link to an article for it? Thanks Tim Almond Tag: getting a row out of a data set based on a key Tag: 80317
  - 22
    - dataset.getchanges fails to return changes Hi All I'm experiencing the problem of dataset.getchanges returning unmodified rows only : myDs.ReadXml("c:\Parsley.xml", xmlReadMode.Auto) For Each t In myDs.Tables For Each r In t.Rows If r.Item("Deleted").ToString = "True" Then r.Delete() Exit For End If Next r Next t myTmpDs = myDs.GetChanges() myDs.Merge(myTmpDs) myDs.WriteXml("c:\Parsley.xml", xmlWriteMode.WriteSchema) The getchanges call returns the non deleted rows, the merge call adds these rows to the main dataset. I have read elsewhere that I need a primary key? There is one on the SQL table the xml is extracted from but nothing in the xml to indicate this. Ta v'ry much Parsley Tag: getting a row out of a data set based on a key Tag: 80314
  - 23
    - Installation Failure of MDAC 2.1 on Windows Server 2003 Hi, all, I have an application that starts installing with MDAC 2.1. Once the MDAC 2.1 is installed, it reboots the server and then continues again with the installation process once reboot complete. But then again, MDAC 2.1 is installed for the second time, it goes on like this. If I choose Cancel, the installation process has to abort. I understand that the version of MDAC on windows 2003 is at least 2.8. But how can I also install MDAC 2.1 for some application compatibility? Thanks a lot, Jake Tag: getting a row out of a data set based on a key Tag: 80311
  - 24
    - Oracle Connection Pool Performance We are troubleshooting performance problems with our application. There are 30-50 users using an web IE OLTP application against a 3-6GB database, queries often hitting several tables (40,000-1.2M rows but using indexes) foreign key constraints enabled). The architecture is ASP.NET - DOT NET 1.1 which means a connection pool using OLEDB. There are issues with DataReaders not being closed - meaning new connections opening often - sometimes we see 90-120 open connections. The clustered dual server is fairly new with a fast dual cpu, INTEL, WIN2000 server over 9 disks, mostly Raid 5. However there is 1.5GB RAM and little disk I/O activity. Perhaps the issue lies in the SQL, lack of caching and connection pool. However there are no queries with huge buffer gets and the oracle stats do not point to anything specific. Are there inefficiencies with dot net 1.0 with Oracle and many users? Any ideas on next steps - Metalink does not have much that is NT specific. Final info Database is 8.0.5 and no not an option to upgrade that yet, perhaps in 6 months but the issues are here and now :-) Tag: getting a row out of a data set based on a key Tag: 80307
  - 25
    - Configure DataAdapter Changes the Name of a Column in Insert Command I have a SQLDataAdapter that I allow the Configuration Wizard to auto-configure the Select, Insert and Delete commands. During the configuration wizard the Select Statement that I cause to be created is simple: SELECT [ICD-9], Category, Description FROM [ICD-9] ORDER BY [ICD-9]. However, the Insert statement that is created is : INSERT INTO [ICD-9] ([ICD-9], Category, Description) VALUES (@Param1, @Category, @Description); Look at the VALUES. Instead of the first parameter being @ICD_9, it's changed to @Param1. Now believe it or not, the statement works OK but I have no idea where @Param1 comes from and I certainly don't set a value for @Param1. Why did the configuration wizard change the name of the first column to @Param1 instead of using the @ICD_9 the way that I expected. Is it that pesky hyphen in the column name that I never should have placed in a column name in the first place? Tag: getting a row out of a data set based on a key Tag: 80300

How would i get a specific row and a column of that row out of a dataset

say i have a dataset "addresses"

and i want to get the address out of that dataset that has the house number
"123" how would i retrieve that row, then refrence the columns of that row?
thanks!

Top

RE: getting a row out of a data set based on a key by anonymous

anonymous
Fri Feb 20 11:31:05 CST 2004

Take a look at DataTable.Select method

Tu-Thac
www.ongtech.co

----- Brian Henry wrote: ----

How would i get a specific row and a column of that row out of a datase

say i have a dataset "addresses

and i want to get the address out of that dataset that has the house numbe
"123" how would i retrieve that row, then refrence the columns of that row
thanks

Top

Re: getting a row out of a data set based on a key by Kirk

Kirk
Fri Feb 20 14:15:34 CST 2004

assuming a dataset named addresses with a single datatable containing 2
columns, HouseNum and Address where HouseNum is assumed to be a unique
value.
---------------------
System.Data.DataView dv = new DataView(addresses.Tables[0]);
dv.RowFilter = "HouseNum = 123";
MessageBox.Show(dv[0]["Address"].ToString()) ;
---------------------

Kirk Graves
KRGIT Software

"Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
news:uTNgiT99DHA.4080@tk2msftngp13.phx.gbl...
> How would i get a specific row and a column of that row out of a dataset
>
> say i have a dataset "addresses"
>
> and i want to get the address out of that dataset that has the house
number
> "123" how would i retrieve that row, then refrence the columns of that
row?
> thanks!
>
>

Top