diff options
author | Daniel Morgan <monodanmorg@yahoo.com> | 2003-01-26 20:15:39 +0300 |
---|---|---|
committer | Daniel Morgan <monodanmorg@yahoo.com> | 2003-01-26 20:15:39 +0300 |
commit | 726fef391cc423f85f0dd1a40a00c63cdfb7a570 (patch) | |
tree | a2bf2ee9a60d2184587baa5b9db31ace65b9da95 /web/sqlclient | |
parent | 004900840b85a18fbe942de1684c44f613962cb4 (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-x | web/sqlclient | 12 |
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"]; |