UPDATE TOP (1)?
(4 messages)
Date: Thu, 2 Aug 2007 13:26:45 -0600
I'm using the OLEDB provider against an Access Database. I need to update
just one record. Is there any way to do something like this?
UPDATE TOP 1 [Articles] SET [Status]='MyClientID' WHERE [Status]=''
I only want to ...
|
ADO.NET Hangs-up(does not return) when executing SQL Batch Satetme
(1 messages)
Date: Thu, 2 Aug 2007 07:08:02 -0700
I have encountered a wiered problem.
I am using visual studio 2005, Oracle 8.1 and OracleClient.
ADO.NET works fine even for batch statement, but for some reason, it
hangs-up and never comes back, when executing the ...
|
Oracle Client and ADO.NET
(4 messages)
Date: Thu, 02 Aug 2007 06:20:11 -0700
I'm considering using MS .net provider for oracle to connect to an
oracle 10g R1 DB.
I was reading thru some documents and it seems that an oracle client
must be installed so i can use this provider.
However, how do ...
|
Dataset.DataTable.Fill() in .net 1.1
(1 messages)
Date: Thu, 2 Aug 2007 01:30:01 -0700
Hi,
I'm very impress with .net 2.0 which Dataset already combine with Adapter,
so I can do like "Dataset.DataTable.GetData()" in order to get and polulate
data into dataset in specific datatable.
Unfortunately in ...
|
Using DataAdapter.Fill to return a DataTable complete with schema information
(1 messages)
Date: Wed, 1 Aug 2007 11:44:37 +0100
When I use a DataAdapter and call its Fill method to populate data into a
DataTable, most of the DataTable's schema information is missing: all the
column MaxLength values are set to -1, Nullable is set to True for all
columns ...
|
How to contruct a ConnectionString to connect to dataset?
(5 messages)
Date: Tue, 31 Jul 2007 15:37:34 -0000
Hi,
We have bunch of DataObejcts/BusinessObjects those used against
database. Now we fetch some data from database into a dataset. How can
we contruct a ConnectionString to connect to this dataset so we can
use those ...
|
LINQ to SQL: Opposite of SubmitChanges()
(3 messages)
Date: Tue, 31 Jul 2007 01:34:03 -0700
I'm working with the new Beta 2 of VS2008 and LINQ is really great but i'm
searching for an opposite construct of the SubmitChanges() method to discard
changes. Background:
I have a form for editing a single data row and ...
|
Update and Select in the same statement?
(2 messages)
Date: Mon, 30 Jul 2007 20:36:08 -0600
Is there any way to select a record and update a field in that record in the
same statement? I have a table that several threads will be querying. Once
the record has been selected by a thread, I don't want that record to ...
|
Problem with ImageButton.OnClientClick when DataBinding
(1 messages)
Date: Mon, 30 Jul 2007 21:07:30 -0400
I have the following tag in one of my DataList's ItemTemplates:
<asp:ImageButton ID="btnViewQuestion" runat="server" BorderWidth="0"
ImageUrl="images/qmark.gif" Height="27px" Width="26px"
OnClientClick="window.open(<%# ...
|
Love Taboo Forum Now Open to the Public! 5% Off
(1 messages)
Date: Mon, 30 Jul 2007 17:40:35 -0700
Hi Folks,
Is anyone sick of the junk bb's online? I found a new bb
that is amazing to say the least. They have all kinds of
adult topics that you can post to once you register. They
give you all kinds of posting options ...
|
|
Error: data truncated.
(1 messages)
Date: Mon, 30 Jul 2007 23:47:22 +0200
Hello,
When writing a text to a SQL database nvarchar(6) field, I get following
error when the size of the input is larger than the available length of the
textfield (larger than 6).
String or binary data would be ...
|
Typed Dataset: Add expression-based column?
(6 messages)
Date: Mon, 30 Jul 2007 13:26:04 -0700
Hi, I'm creating a typed dataset based off of a SQL Server 2005 DB. There are
2 fields from one table that I'd like to bind to on an ASP.NET dropdownlist.
Since I can't specify two fields in the "Datatextfield" proprety ...
|
Datatable Update method not updating
(3 messages)
Date: Mon, 30 Jul 2007 13:08:26 -0500
I have a dataset containing a datatable. Everything was working OK. Then I changed the definition
of one of the columns from not null to nullable. Now when I update the adapter, the change is not
being written to the DB.
Just ...
|
Using a .net Custom Data Provider and SQL Server 2005 Management Studio
(1 messages)
Date: Mon, 30 Jul 2007 03:45:42 -0700
Hi,
MS have exposed the functionality to use custom data providers in
Visual Studio 2005, I've used this and it works fine.
I would like to know if it's possible to use a custom data provider
from SSMS? I'm not even ...
|
what's the best approach to follow for sql execute
(3 messages)
Date: Sun, 29 Jul 2007 12:31:14 +0100
Hi There,
What's the better way to follow when we use sql
string sql = "Inset into table(f1,f2) values (@f1, @f2)";
then add and passing parameters or in the first place itselef assign the
values to the string
string ...
|
Change connectionstring Typed dataset
(6 messages)
Date: Sun, 29 Jul 2007 03:38:02 -0700
Hi,
I've noticed that if I change my connectionstring in the app.config file,
this isn't enough, a second change in the Global.System.Configuration is
necesary!!!
This means that after deployment and if the SQL server ...
|
Iˤpkk
(1 messages)
Date: Sat, 28 Jul 2007 17:47:45 -0700
KOťIˤpkk!
...
|
What does DataSet.AcceptChanges do?
(3 messages)
Date: Fri, 27 Jul 2007 18:45:06 -0600
If I delete rows in a DataTable and then do a DataSet.AcceptChanges, and
then pass that DataSet to the client, will the client have any idea of rows
that previously existed? I'm hoping not.
If the client would still ...
|
Compare two DataSets?
(2 messages)
Date: Fri, 27 Jul 2007 15:06:01 -0600
Is there a way I can compare two DataSets to see if they are identical?
Thanks,
Ron
...
|
bind variables oracle visual basic
(2 messages)
Date: Fri, 27 Jul 2007 20:51:09 -0000
I have a query that looks up the highest value for column a and then
returns column a and column b. It uses a nested select in the from
clause. I want to use bind variables for my parameters but have found
out i can't use ...
|
