|
|
|
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 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 DataReader, hardcoding column number. why not col name? Posted by Michelle Stone at 9/19/2003 10:54:57 PM I am new to asp.net
after filling a DataReader object with some records from
a table, i want to check if the sPassword field of the
first record matches what the user has entereed. I use
the following:
if (reader.GetSqlString (4) == PasswordEdit.Text)
Response.Write ("pass");
else
R...more >>
poor performance of managed data providers. Posted by dyk at 9/19/2003 9:31:40 PM Hello!
I'am trying to run T-SQL query based on stored procedure and I was surprised
by essential diferences in the time of execution of the same query using
..NET application & SQL Query Analizer.
The results of analyzing my query (using SQL Profiler) are bellow:
1.-------------------------...more >>
Best way to find EOF Record using OleDbCommand ? Posted by ItsMe at 9/19/2003 6:29:59 PM Hi,
I want to check whether the record exist or not based on my query, so i'll
be using OleDbCommand.
What is the best way to check on a huge table ? I used to write like this in
VB6.0...
---------------------------------------------------
Public Function SaveOrUpdate() As Boolean
sSQ...more >>
How to get selected value from DataGrid ? Posted by ItsMe at 9/19/2003 6:23:50 PM Hi,
I filled up DataGrid using dataset. I've two Columns CountryCode,
CountryName.
When the user double clicks on the grid, I need to show the selected row
values.
example: AU - Australia.
Can anyone give me simple example.
Thanks
...more >>
<NULL> in DataSource Posted by Bob Day at 9/19/2003 5:58:13 PM Using VS 2003, VB.net and SQL MSDE...
This is driving me nuts!
I would love to find a simple way to translate any column with a <NULL>
value that is a datatype string to a string.empty (i.e. ""). Is there any
command that says "To make life easy, automatically translate any <NULL> in
a STR...more >>
Access Stored Procedure (Query) problem Posted by Tom Vukovich at 9/19/2003 3:02:02 PM I have an existing VB6 program that i am porting to VB.NET. It is a real
time data collection program that stores the data in an access database. The
program uses stored procedures to insert or update the data. The code is
below.
var(0) = byID
var(1) = intIndex
var(2) = intMPI
var(3) = lngC...more >>
Table not found error Posted by Jim Mesara at 9/19/2003 2:47:47 PM I have the following bit of code. What it does it query the database for
address information, and there can be multiple addresses for each person.
For
each person, the repeater creates a row. Each repeater row can display as
many addresses as are needed (usually one, but it can be more.)
For ...more >>
checking a record for highest number in a column Posted by Brian Henry at 9/19/2003 2:39:39 PM how would i do this in ado, im reading from an access db which has a column
with numbers.. i want to find the top 5 highest numbers's rows... i have
SELECT TOP 5 * FROM LINKSLIST;
what would i do to find the ones with the highest numbers in the viewed
column? thanks
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Getting at 2 recordsets returned by SP? Help? Posted by Christopher Ambler at 9/19/2003 2:33:17 PM I have a stored procedure that one of the DB guys wrote for me. It's going
to return two recordsets in its output.
Normally, I'd use ExecuteReader() and just loop inside of a while
(reader.Read()) loop.
In this case, I need to get the data into a couple of DataSet objects so I
can set prope...more >>
Why update of Text type column no work? Posted by Woody Splawn at 9/19/2003 2:13:09 PM I am attempting to update the database with an update command in code. The
backend is a SQL Server database and the field happens to be a Text field, a
field that can hold very large amounts of data. When I do the update I get
the following error:
"The query processor could not produce a que...more >>
Connection Strings and SQL Server 2000 Named Instances - How To? Posted by Ben Fidge at 9/19/2003 12:54:53 PM How do I specify which named instance of a multi-instance SQL Server 2000
installation to connect to from within a ADO.Net connection string?
...more >>
Remote DB Access Posted by Chris Kennedy at 9/19/2003 11:44:47 AM Is there a straight forward equivalent of RDS that I can use to access a
database remotely via ADO/ADO.net
...more >>
Connection Pooling Issues Posted by Ed Crowley at 9/19/2003 11:16:32 AM Are there any issues with connection pooling in a VB.NET Windows Forms app
and SQL Server security?
I would like to implement pretty much all the security using SQL Server
roles and Windows Authentication. Will I encounter any issues with this?
Thanks for your time.
...more >>
Looking for an example Posted by M. Craig at 9/19/2003 9:40:21 AM I'm trying to display multiple resultsets, returned in a SQLDataReader, in a
single table. The number of resultsets returned is variable, usually 3 or 4.
Basically, each resultset has 1 row and I'd like to display each row as a
row in the same table. I'd like to use the DataGrid if possible.
H...more >>
IDataAdapter taking too long Posted by Robb Smith at 9/19/2003 8:34:32 AM I am using a SqlDataAdapter to retrieve a DataSet from the database. When I
Trace the creation of the SqlDataAdapter object, it is taking more time than
it does to retrieve the DataSet! Here's my code:
Dim da As New SqlDataAdapter(sSQL, cn)
Dim ds As DataSet = da.Fill
where sSQL is the SQL ...more >>
load simple XML into ADO recordset Posted by google NO[at]SPAM brasch.info at 9/19/2003 7:44:10 AM Folks,
I've been trying to get this to work for more than a day now. It
drives me crazy!!
This is example code from MSDN and it just doesn't work for me:
Dim adoConn As ADODB.Connection
Dim adoRS As ADODB.Recordset
adoConn = New ADODB.Connection()
adoRS...more >>
SQL Command parameters Posted by Ryan Wade at 9/19/2003 7:07:02 AM using SQL Server 2000, when I execute a SP through the sqlcommand, if I
don't declare all the input and output parameters, it crashes. Is there
anyway to give it only the parameters I need and execute?
...more >>
.NET and DB2 Posted by Max Frecci at 9/19/2003 5:41:19 AM Hi,
I must develop a web application whose database is IBM DB2.
Can anyone give me some hints about OLE DB / ODBC .NET
Data Provider?
Which one I have o use? Is there a specific driver for DB2?
Thank you in advance,
Max...more >>
How to use transaction with Dataadapter Posted by KWOK at 9/19/2003 4:12:56 AM Hi All,
I want to add some records in three tables in dataset. I
add new reocrd and update dataset everyTime before add
another table.
So if I get errors while I'm updating the third table. How
can i use transaction.rollBack to undo every thing in
first table and second table??
How c...more >>
About DATASET OBJECT. Posted by KWOK at 9/19/2003 3:58:29 AM Hi all,
if I add a new object dataset.xsd rather than use
system.data.dataset object. So Dose a system performance
improved??
And if I add a new xsd dataset, How do i update data to
database.
Thanks,
KWOK
...more >>
DataRowBuilder and custom DataRow Posted by soljemo NO[at]SPAM telia.com at 9/19/2003 3:40:04 AM Hi!
I need to create a custom DataRow like strongly typed dataset.
This because i need one extra property. In this post called
"ExtendedProperty".
My datatable class C_MyTable inherits the DataTable class and
implements the function NewRowFromBuilder as follow:
Protected Overrides Functi...more >>
How to delete a row (code included) Posted by Markus at 9/19/2003 3:18:12 AM My code at btnDelete doesn't work. Can you help?
And I'm new to all this programming stuff but 'm
learning :-)
Public Class frmSuradnici
Inherits System.Windows.Forms.Form
Dim objConnection As New OleDb.OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=C:...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |