| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 bind variables and sql Posted by cptkirkh at 8/7/2007 9:38:42 PM I a trying to store certain sql queries in a table to reference
later. I want to perform a sql query to see if they are in the table
and i want to use bind variables. HOw can i do this?
Here is a sample of my code:
Dim sqltorun As String = "select max(ec_export_number) from
event_campaign ...more >>
ADO.NET 2.0 saving single space to SQL? Posted by Donald Joppa at 8/7/2007 10:34:04 AM We're converting from framework 1.1 to 2.0 and something interesting has
popped up. Fields that are being inserted into the database as a zero length
string in 1.1 contain a single space when inserted with 2.0 compiled code.
The code specifies a stored proc to run and set up the parameter co...more >>
Specify DB Location for Auto-generated Dataset Posted by DBM at 8/7/2007 2:38:10 AM I auto-generated a dataset for CRUD DB usage. I did this to save the time in
generating this myself by hand. Bad idea or not I'd still like to use the
code, but I also want to dynamically specify the location of the database,
I'm using Access for now and the connection string is hard coded i...more >>
Detecting database column data type of smalldatetime vs. datetime? Posted by Jen at 8/6/2007 9:54:54 PM Is there a way for C# ADO.NET code to determine whether a SQL Server column
data type is smalldatetime vs. datetime? It looks like DataColumn.DataType
makes no distinction, both return DateTime.
...more >>
DataReader and DataAdapter Posted by Peter at 8/6/2007 1:16:02 PM I want to get a better understanding in using DataReader and DataAdapter to
retrieve data from MS SQL Server 2005. I'm using visual basic 2005 and .net
3.0.
Is there any difference in retrieving data in MS SQL Server using DataReader
and DataAdapter? I used to SQL Server Profiler to trace...more >>
newbie question Posted by ma at 8/6/2007 12:56:25 PM Hello,
I did some database programming in the past and I always used database
controls which were offered by VB to connect to a database (Access
database). One facility that offered by these controls and I like it most is
the record locking. By record locking, I mean the capacity of loc...more >>
Pass Null parameter from VB.NET to Access Query Posted by akter.babu NO[at]SPAM gmail.com at 8/6/2007 5:14:06 AM I have created a access query where if I give parameter value Dept
Code like 41 then the details of this department is shown. But If I
give null then It will show All the detartments details one after
another. But my problem is that I can't pass that Null value to that
query from VB.NET it is no...more >>
Checking for open db Posted by John at 8/6/2007 3:13:58 AM Hi
In my app I am opening a db connection then running a set of queries and at
the end closing the db connection. Once in a while a query fails to run
saying database connection is closed. How can I ensure that db connection is
confirmed open before running a query? Will
dbconn.close
db...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Assigning null to OleDb.OleDbConnection Posted by John at 8/6/2007 2:55:29 AM Hi
How can I assign a null value to a variable of type OleDb.OleDbConnection?
Thanks
Regards
...more >>
Fighting with typed data set and child relation Posted by olympus_mons NO[at]SPAM gmx.de at 8/5/2007 4:54:01 AM Hi,
the problem I have, is that the GetChildRows() method does not work. I
get error:
Unable to cast object of type 'DEBTORRow[]' to type 'DEBTOR_NACERow[]'
>From the database (oracle10gR2 using Oracle .NET provider v2.0.50727)
I generated a typed dataset in VS2005. There is a 1:n-relation ...more >>
Updating and Merging with Order Details Posted by DesCF at 8/4/2007 12:26:37 PM
My question is do merges always take place using the original values of =
=
primary key fields ?
For example using the Northwind Order Details table:
1. The primary key is OrderID and ProductID.
2. The user can change the ProductID which changes the primary key.
3. Both the original P...more >>
SqlDataReader and null fields Posted by Bill Gower at 8/3/2007 11:20:05 PM I am returning data using a SqlDataReader. Here is a snippet of code where
I am having a problem. What is the best way to handle nulls?
private void TGenerateJobSiteList2FromReader<T>(SqlDataReader returnData,
ref List<JobSite> jobSiteList)
{
while (returnData.Read())
...more >>
ADO.NET driver for MySQL? Posted by RAM at 8/3/2007 3:37:09 PM Hello,
I have dowloaded two drivers for MySQL:
- mysql-connector-net-1.0.9.zip
- ByteFX.MySqlClient.76.NI.zip
Which one do you recommend?
Please help
Thank you!
RAM...more >>
ObjectDataSource Posted by Bill Gower at 8/2/2007 10:22:43 PM I am using an ObjectDataSource to populate a GridView. The ObjectDataSource
accesses the data in the table by means of a Stored Procedure using a
SQLCommand.ExecuteReader. Does this mean that I can't easily do sorting,
filtering and paging in my GridView
Bill
...more >>
DataGrids with Multiple tables Posted by edwardo2005 at 8/2/2007 9:46:53 PM Hi, I want to have a DataGrid with two columns - 1 from one table and
one from another. The tables are linked by a key from the 2nd to the
first. I am using a DataSet in .Net and the tables are in the DataSet
and there is a relationship between that tables in the DataSet. I have
been able to get...more >>
Linq group Posted by William Stacey [C# MVP] at 8/2/2007 8:11:02 PM Is this gonna be the place for Linq questions (not the windows forum)?
--
William Stacey [C# MVP]
PowerLocker, PowerPad
www.powerlocker.com
...more >>
UPDATE TOP (1)? Posted by Terry Olsen at 8/2/2007 1:26:45 PM 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 update one record, because i'm going to select that record in
the next s...more >>
Oracle Client and ADO.NET Posted by maz at 8/2/2007 6:20:11 AM 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 I go about installing the client? I have Developer
Suite 10g (9.0.4), but I...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |