| dataset incorrect about HasChanges (2 replies) |
| ASPFriends.com 'aspngdata' list |
| ok, I have a dataset of new,ready to insert relational data in several tables. My code to insert it runs thru the dataset and calls adapter.Update on each table in a parent first fashion. the first table is inserting correctly, and my keys are updating and cascading correctly... but after the first run thru the loop, the dataset claims there are no more changes when every other table has non inser... |
|
| Error in Compilation of Beta 2 Web Services in .NET Framework V1. (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Please help I could not compile my old web service file of Beta 2 in Version 1 of .NET framework. I have the following code in my .asmx file %@ WebService Language "C#" Class "Item" % %@ Assembly name "System.EnterpriseServices" % using System; using System.Data; using System.Data.SqlClient; using System.Web.Services; using System.Web.Util; using System.EnterpriseServices; public class Item : WebS... |
|
| Nulls (12 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Dana Coffey denigma@bellsouth.net !DOCTYPE HTML PUBLIC " //W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP EQUIV 3D"Content Type" CONTENT 3D"text/html; charset 3Dus ascii" META NAME 3D"Generator" CONTENT 3D"MS Exchange Server version 5.5.2652.35" TITLE Nulls /TITLE /HEAD BODY P FONT SIZE 3D2 Hi all, /FONT /P P FONT SIZE 3D2 If I want to insert a null to th... |
|
| SV: RE: Nulls (2 replies) |
| ASPFriends.com 'aspngdata' list |
| How can one check for nulls in a dataset ( it will always be a dataset 20 with 20 one column and one row) and if there is a null then exit sub else carry 20 on 20 with the rest of my code.... 20 20 20 Any ideas 20 20 C 20 20 20 This email and any files transmitted are 20 confidential and intended solely for the 20 use of the individual or entity to which 20 they are addressed, whose privacy 20 sho... |
|
| DataReader / DataTable question... (6 replies) |
| ASPFriends.com 'aspngdata' list |
| I have a SQL sproc that returns 10 result sets. I grab it into a DataReader. I want to loop through the result sets, and for each one, dump the result set contents into a separate DataTable. I can't find a DataReader equivalent to the DataAdapter Fill() method. Can someone show me how this can be done? TIA, Francesco while (dr.read()) { // loop through result sets and dump into DataTables } Join t... |
|
| can't get multiple result sets into a DataSet... (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I am using the code below to try to get a handful of result sets (returned from a single SQL 7.0 sproc) into distinct tables in a DataSet. I get an error when the Fill() tries to happen: Value cannot be null. Parameter name: dataSet. The result sets being returned are not simple SELECT * FROM PersonEmail queries, they are complex JOINS, so maybe a table name is not being passed that maps to the so... |
|
| Reading delimited text files with ADO.NET (13 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi all, I'm looking for a quick way to read a tab delimited text file into a dataset. I've looked for information on this everywhere and all I can find is something related to setting up a DSN (which doesn't work for me). Is there an easy way, outside of writing code to read each value intot he dataset one by one, to load a delimited text file into a dataset? Has anyone else had any success doing ... |
|
| ADO vs ADO.NET Performance Comparison (5 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Does anyone know of some published statistics comparing the performance of ADO and ADO.NET? Dan Green [ http://dotnetdan.com putting the dan in .net ] |
|
| Import access table into sql server (4 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi how to import ms access table to sql server database using ado.net? Vojin Lekovic IT Developer KPMG Consulting Barents Group Internet Crna Gora |
|
| best way to get a single piece of data out of a DataSet? (7 replies) |
| ASPFriends.com 'aspngdata' list |
| I have a set of 10 DataTables in a DataSet, and I need to get one column out of one row out of one table in the DataSet. I have tried the code below but I get an error. Any help? TIA, Francesco Error: Object reference not set to an instance of an object, line 235 Code: 234: DataRow dr; 235: dr newVisitor.MemberData.Tables["PersonAddress"].Rows[0]; 236: Session["test"] dr["profile name"].ToString()... |
|
| error when trying to assign to a DataTable... (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I get an error when I try to return a DT from a DAL method directly to a DT in a DS... Code: myDataSet.Tables["Table1"] SqlService.ExecSPRetDT("mySp", "Table1"); Error: Property or indexer 'System.Data.DataTableCollection.this[string]' cannot be assigned to it is read only. TIA, Francesco Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. |
|
| Selecting Rows From A Dataset (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, I have a cached dataset populated from a database using SqlDataAdapter. I just want to ask how will I select rows from my cached dataset because i dont wanna connect to my database again and select records form there since i already have the records in my dataset. I tried using the Select method of DataTable but it only works for a single filterExpression(e.g "Date 01/01/2001"). What i want is... |
|
| Read DBNull from DataReader (6 replies) |
| ASPFriends.com 'aspngdata' list |
| V2hlbiBJIHRyeSB0byByZWFkIGEgcmVjb3JkIGZyb20gYSBEYXRhUmVhZGVyLCBvbmUgb2YgdGhl IGZpZWxkcyBvbiBzb21lIHJlY29yZHMgYXJlIE51bGwsIGJ1dCBJIGdldCBhIGNhc3QgdHlwZSBl cnJvciBzYXlpbmcgdGhhdCBpdCBjYW4ndCBjYXN0IERCTnVsbCB0eXBlLiAgSG93IHdvdWxkIEkg Z2V0IGFyb3VuZCB0aGlzIHByb2JsZW0sIHRvIGNoZWNrIGlmIHRoZSBmaWVsZCBpcyBEQk51bGw/ IA0KDQpUaGFua3MuDQoNCkRleWxvIFdvbw0KDQo |
|
| which is faster way to populate this DataTable? (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Which is the faster, more efficient way to populate this DataTable? 1. Call my DAL method that returns a DataTable? myDataSet.Tables["Table1"] SqlService.ExecSPRetDT("mySp", "Table1"); 2. Call my DAL method that returns a DataAdapter, and Fill the Table? SqlDataAdapter da SqlService.ExecSPRetDA("mySp"); da.Fill(myDataSet, "Table1"); TIA, Francesco Chat with friends online, try MSN Messenger: http:... |
|
| IIf Function (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by devin devinr@drone interactive.com Hi I'm using the IIf funtion to check whether a value for insertion into an SQL Server DB is NULL. It seems like the False part is being evaluated even if the test expression is true. Code is as follows: IIf(IsDBNull(dt.Rows(I)("TRAVDATE")), "NULL", cString(Format(dt.Rows(I)("TRAVDATE"), "dd MMM yyyy HH:MM"))) If dt.... |
|
| Updating a database from ASP.NET (5 replies) |
| ASPFriends.com 'aspngdata' list |
| When programming in asp, sometimes I would update a field 20 with out using SQL. For Example : If Request.QueryString("chkActive") 3D "1" Then rs("Active") 3D True Else rs("Active") 3D False End If rs.update() rs.close() Can I do the samething with ADO.NET or do I have to always 20 use execute a SQL statement ? Thanks for your help Hector Caban 20 A , Net , MCP SB, MCSA, MCSE, MCT, CCNA |
|
| Retrieving ID after Inserting a record. (10 replies) |
| ASPFriends.com 'aspngdata' list |
| I need to get the ID (from a field) of a new record from a database after I call the ExecuteNonQuery method. How can I get it with out opening the dataset again. Thanks.. Hector Caban 20 A , Net , MCP SB, MCSA, MCSE, MCT, CCNA |
|
| GetChars()? (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi folks! I have been having some difficulty working with a large text field in my SQL Server database. The field could be any length and, in a few cases, is extremely large. It seems that the connection keeps cutting the length of the field, when returned, to 8000 chars. I've been reading up some, and since I can't use GetChunk() in .NET, I think I should do something with commandbehavior.Sequent... |
|
| Datareader.Read() & EOF (8 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Tony Stark IronMan@aspelite.com Hi From what i can gather While myReader.Read() 'do stuff End While Is fine for looping through a datareader. But unlike what ive read in past messages. If Not myReader.Read() Then 'End off file Else 'Do something End If Is not a suitable replacment for classic ASPs IF recordset.EOF Then 'End of file Else 'Do something ... |
|
| ExecuteScalar (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Where is a good complete code sample for use of ExecuteScalar? I've found a few articles online but none that show complete (cut & paste workable) code. I know Charles had a code sample once but I can't find it anymore. Thanks, ~Brad Kingsley Microsoft MVP ASP Windows 2000 MCSE http://www.orcsweb.com/ Powerful Web Hosting Solutions #1 in Service and Support [This E mail scanned for viruses by Decl... |
|
| vijjay chauhan (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Tony Stark IronMan@aspelite.com hello sir, i am having a problem in inserting and retriving image to and from the database. so i want to kowe the classes to implement the same. other wise and how can i extract the image name so that i can insert only the name of image in to the database image feild into the table. need your help regarding the same, an... |
|
| Typed dataset (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Copied from [aspngxml] to [aspngdata] by Michiel van Otegem mvo@mail.aspnl.com I have a typed dataset called dsPart. When I use a dataadapter to fill the dataset with data from a sql database I get a xml representation diferent that the one that I get when I fill the dataset with the method dsPartAux.Part.AddPartRow("x1", "memoria Ram", 60, false, "123") when filling with the dataadapter I get thi... |
|
| How to make multiple queries with the same connection (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Tony Stark IronMan@aspelite.com Hello! Can anyone of you tell me please how can make multiple queries with the same connection object? I open the connection, and then open a DataReader. After that, i need to make another query but i cannot open another data reader because there is the first one still associated with the connection, and i cannot close ... |
|
| unbinding the drop down list (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I have two dropdown list. When I select a value in one the other one changes. I am using onselectedindex "action here()" On the first drop down I have added an extra list called "select a category" then to my sub "action here()" I have added sub action here() If cat id.SelectedItem.Value "Select a category" Then ... (Bind the second drop down with values) End If This works fine If I am selecting a... |
|
