Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008


all groups > dotnet ado.net > november 2004 > threads for friday november 12

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Parameters.Add
Posted by vb at 11/12/2004 7:18:01 PM
I am new to .Net. I have a windows form in which I am using a Stored Procedure to get the data. I am successful in retrieving the data, however after closing the form and reopening the form I landed in a problem . The error is too many parameters.What I did was I included a line SqlCmd.Par...more >>

WriteXml & XmlDataDocument questions
Posted by Jamie Owens at 11/12/2004 5:45:41 PM
Hi everyone, I have a question regarding DataSets and the WriteXml method. Specifically, I'm having trouble writing out my DataSet, then reading the contents back in to an XmlDataDocument. For instance, my code reads like this: ///////////////////////// StringWriter l_strWrite ...more >>

Select Top 10 from a DateTable???
Posted by vl_yes NO[at]SPAM hotmail-dot-com.no-spam.invalid at 11/12/2004 1:57:11 PM
Hi! I want to select only 10 rows from a dataTable each time, just as from a database("SELECT TOP 10 FROM orders WHERE ID <100 ORDER BY ID"). for example: DataTable myTable = new DataTable("orders"); DataRow[] rows = myTable.Select("TOP 10 ID < 100"); 1)How can I write the correct statement. ...more >>

how to determine logged on user?
Posted by djc at 11/12/2004 1:27:07 PM
I have MSDE2000 using integrated authentication. How can I determine the username of the logged on user from my asp.net app? ...more >>

MSDTC Wrap Directly?
Posted by localhost at 11/12/2004 12:04:57 PM
Looking for any sample code on using MSDTC directly, without inheriting from ServicedComponent. I want to use MSDTC with xcopy deployment, so nothing can be hard-installed into the COM+ catalog or require Administrator rights. OS is XP and Win2003. Thanks. ...more >>

Update Command
Posted by Steven Licciardi at 11/12/2004 11:58:53 AM
I am using parameters etc when populating a dataset using a DataAdapter. I have an Update command of the folllowing form : UPDATE projects SET ID=@ID,Address1=@Address1,Address2=@Address2,Postcode=@Postcode WHERE ID=@ID Where ID is my primary key. When I change Addres1 etc.. then use D...more >>

Performance of Find?
Posted by Jesper at 11/12/2004 11:50:13 AM
I was wondering what kind of algorithm is behind the DataRowCollection.Find method, where you are searching by the primary (and unique) key. Can I expect "table-scan"-like performance O(n) or is there some sort of indexing that makes it constant or logarithmic in performance? I'm currently ...more >>

Performance counters SqlConnection vs ODBC vs OLE DB
Posted by John S at 11/12/2004 11:14:48 AM
I'm trying to monitor connection pooling in a web app on our development web server. The connection string is a .Net SqlConnection string. I'm trying to monitor connection pooling via the .Net CLR data SQLClient counters but I am not seeing any connections being made in the pools. (pooling is ...more >>



msde error
Posted by Dave at 11/12/2004 10:52:54 AM
Hi, I install msde 2000 using the command line like this => setup SAPWD="pass" But when I try to create a new database using access sql server database wizard he ask me for a login id and password! First if my password is pass what is the login id? When I try the login id of my computer user na...more >>

Concurrency violation: the UpdateCommand affected 0 records.
Posted by harrisjr2001 NO[at]SPAM yahoo.com at 11/12/2004 10:38:45 AM
Wanted to post my scenario about this error message for others to benefit from... I was getting this error on a certain table and could not figure out why to save my life. I use the same data access strategy for all DA objects and was not having the problem with any other object/table. Here...more >>

DataBind problem
Posted by Haytham at 11/12/2004 9:52:02 AM
i made tow combobox one of them filled in page load and the other one fill when the user select a value form the First one but i got this error: "The Column prefix 'System.Data' does not match with a table name or alias name used in the query" and this my code: the First Combobox: SqlC...more >>

Calling a Mdi child Form from a modal one
Posted by Katty at 11/12/2004 9:52:00 AM
The application loads the main form (mdi parent) and then it shows a modal form for validation porpuses. After the user writes the password the validation form closes, and then I need to call a Mdi child form. How can I do this? ...more >>

Still Problem with Dataview.Find
Posted by Charles A. Lackman at 11/12/2004 9:06:26 AM
Hello, When I Do Desc, It works but everything is backwards. All the records go from Z - A. I need them to go from A - Z and grab the first one it finds. ASC reproduces the behaviour stated below: I am retrieving data from a database "Order By LastName", when I use a dataview to find...more >>

DataSet can't determine 'childs'
Posted by Egbert Nierop \(MVP for IIS\) at 11/12/2004 8:16:52 AM
Is it true that XML in this form is **unusable** for usage by DataSet.ReadXml([file], XmlReadMode.Fragment) and [DataRow][DataColumn].GetChildRows()? Because I found that GetChildsRows() does not work. I am talking about a DataSet which has a xsd schema. Im suspecting currently, that GetC...more >>


DevelopmentNow Blog