Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/mono/mono.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDaniel Morgan <monodanmorg@yahoo.com>2003-01-26 20:15:39 +0300
committerDaniel Morgan <monodanmorg@yahoo.com>2003-01-26 20:15:39 +0300
commit726fef391cc423f85f0dd1a40a00c63cdfb7a570 (patch)
treea2bf2ee9a60d2184587baa5b9db31ace65b9da95 /web/sqlclient
parent004900840b85a18fbe942de1684c44f613962cb4 (diff)
2003-01-26 Daniel Morgan <danmorg@sc.rr.com>
* doc/index * doc/ado-net * doc/firebird * doc/ibmdb2 * doc/mysql * doc/odbc * doc/oledb * doc/oracle * doc/postgresql * doc/sqlclient * doc/sqlite * doc/sybase * doc/tdsclient: corrections svn path=/trunk/mono/; revision=10921
Diffstat (limited to 'web/sqlclient')
-rwxr-xr-xweb/sqlclient12
1 files changed, 8 insertions, 4 deletions
diff --git a/web/sqlclient b/web/sqlclient
index df76f9d620a..df4f49dc9e2 100755
--- a/web/sqlclient
+++ b/web/sqlclient
@@ -55,6 +55,8 @@
<li>Uses TDS Protocol Version 7.0</li>
<li><a href="http://www.go-mono.com/tds-providers.html">Design of the Microsoft SQL Server, Sybase, and TDS Providers in Mono</a></li>
+
+ <li>Works in the SQL# command-line and GTK# GUI version</li>
</ul>
** Action plan
@@ -77,7 +79,9 @@
<li><a href="http://www.microsoft.com/sql/default.asp">Microsoft SQL Server</a></li>
</ul>
</li>
-
+ <li>If using Microsoft SQL Server 2000, make sure
+ you are using at least Service Pack 3 for Microsoft SQL Server 2000</li>
+
<li>Located at mcs/class/System.Data/Test is a test for System.Data.SqlClient
named SqlTest.cs and you could use this as a basis for your test.</li>
@@ -94,15 +98,15 @@
string connectionString =
"Server=localhost;" +
"Database=pubs;" +
- "User ID=sa;" +
- "Password=;";
+ "User ID=myuserid;" +
+ "Password=mypassword;";
IDbConnection dbcon;
dbcon = new SqlConnection(connectionString);
IDbCommand dbcmd = dbcon.CreateCommand();
string sql =
"SELECT fname, lname " +
"FROM employee";
- dbcmd.ConnectionString = sql;
+ dbcmd.CommandText = sql;
IDataReader reader = dbcmd.ExecuteReader();
while(reader.Read()) {
string FirstName = reader["fname"];