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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|