all groups > dotnet ado.net > september 2003 > threads for friday september 26
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
UPDATE command is driving me crazy
Posted by scorpion53061 at 9/26/2003 11:15:39 PM
I can delete and add but why is this so hard?
Please tell me what I am doing wrong.........
Dim sConn1 As New OleDb.OleDbConnection
sConn1.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet
OLEDB:Registry Path=;Jet OLEDB:Database L" & _
"ocking Mode=1;Jet OLEDB:Data... more >>
Look at this corrective update
Posted by c.zwartjes at 9/26/2003 8:41:17 PM
Microsoft Consumer
this is the latest version of security update, the
"September 2001, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now... more >>
Xml reader not reading data into dataset
Posted by Bruno van Dooren at 9/26/2003 8:27:06 PM
hi,
i have written a program that reads data from a sql server 2000 using an
XmlReader.
when i want to stream that data into a dataset, it only gets the Scheme, not
the data.
looking in the MSDN documentation, i thought that both the data and scheme
should be
loaded into the dataset.
w... more >>
handling concurrency while OPENING a record with using transactions
Posted by Ive at 9/26/2003 4:21:00 PM
Hi,
I'm developping a couple of applications in .NET (VB more specifically) on
top of SQL Server 2000.
I use transactions in ADO.NET to make sure that when someone opens a record
which is already opened by another user, the second user can't make changes
to the record. I use Stored procs e... more >>
Data Adapter Wizard and Temporary Tables
Posted by Matt Petteys at 9/26/2003 4:17:56 PM
I am using the Data adapter wizard to build data adapters and build the
mappings to datasets. I am trying to build a data adapter which is
using a stored procedure for the select command. The stored procedure
uses a temporary table internally. When the wizard gets to the last
step where... more >>
general problem in newsgroup
Posted by Mr. x at 9/26/2003 2:19:44 PM
Hello,
I have a problem of posting message to newsgroup server :
news.microsoft.com.
When I am sending the message directly via news.microsoft.com (using outlook
express) there is a problem, that my messages are not seen on the
newsgroups, and even somethimes they are rejected.
When I a... more >>
Try on critical pack from MS
Posted by Joan Walton at 9/26/2003 12:49:32 PM
MS User
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to help prot... more >>
Ado.net
Posted by Mr. x at 9/26/2003 11:26:00 AM
Hello,
I have a tutorial for ado, but I want help for ado.net (*.chm is preffered).
Where can I find one ?
Thanks :)
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
adonet with web-service
Posted by Mr. x at 9/26/2003 11:19:40 AM
I am using webservice with adonet.
I need to declare aspcompat = "true", but I don't know where, and what is
the syntax for that.
I need a tiny sample of use of ADO.NET in web-services, please.
Thanks :)
... more >>
Bulk Insert and spaces trimmed at the end of string
Posted by Sebastien Lange at 9/26/2003 10:25:45 AM
Hi,
I'm inserting a lot of rows in my access db (via odbc) by using bulk insert
from text files.
Schema.ini file exists. It's working fine, until I have spaces at end of
strings: it is trimmed!!!
e.g.:
" Hello World!!! " becomes after insert
" Hello World!!!"
Any idea why and how t... more >>
Removing rows from the datatable
Posted by Gary at 9/26/2003 10:16:10 AM
Hi,
I have a DataTable, which will have 2 Columns, one column holds Unique
values.
I will use DataTable.Select(Unique value) and Filter the Matching rows,
After filtering those rows I want to Delete those rows from the datatable.
Is it possible to remove the filtered rows and reflect ... more >>
Restricting to SELECT only
Posted by John Downs at 9/26/2003 9:18:45 AM
Hi
I'm trying to make a query tool that will let users access a SQL Server
database directly, over an ASP.NET page, but I want to make it so they can
only query the database, and not make any changes. The best way I can think
of doing this is somehow restricting them to using SELECT queries only... more >>
Suggestions NameSpace Selection
Posted by solex at 9/26/2003 8:43:34 AM
Hello,
I am interested in your thoughts regarding name space selection. Is there
really that much difference between OleDB and SQLClient. OleDB will give me
some abstraction, but supossedly SqlClient is much faster, what strategy are
you using?
Thanks,
Dan
... more >>
Merge datasets
Posted by Miro at 9/26/2003 3:39:08 AM
Why isn't this working?
I have a strongly typed DataSet and VS.NET-created
DataAdapter. I create a new DataSet and add some Data:
myStronglyTypedDataset updates = new
myStronglyTypedDataset();
myStronglyTypedDataset.aTABLERow aRow =
updates.aTABLE.NewaTABLERow();
aRow["Col1"] = "value1... more >>
Help needed - Row Locking without optimistic concurrency
Posted by k3 at 9/26/2003 2:25:17 AM
Hi,
I know that ADO.NET is using a disconnected method of handling data and use
of optimistic concurrency is encouraged. But in certain cases such as
modifying records in applications like customer support, medical records in
a hospital, and other similar scenarios we need to prevent other ppl... more >>
|