X-Git-Url: http://wien.tomnetworks.com/gitweb/?a=blobdiff_plain;f=doc%2Ftdsclient;h=56629335caf93368be29a7cdadae09129d2efc78;hb=de6d7a5ccedda43516abba47206a2a834ad6a475;hp=c5f494a7c66135a80f88ffa21bfd19c6144ade04;hpb=c40860f8f6073bf2e89beb08857b7e5b1cfb39bc;p=mono.git diff --git a/doc/tdsclient b/doc/tdsclient index c5f494a7c66..56629335caf 100755 --- a/doc/tdsclient +++ b/doc/tdsclient @@ -19,6 +19,13 @@
+ Server=hostname;Database=databaseName;User ID=userid;Password=password ++
using System; @@ -82,15 +103,16 @@ string connectionString = "Server=localhost;" + "Database=pubs;" + - "User ID=sa;" + - "Password=;"; + "User ID=myuserid;" + + "Password=mypassword;"; IDbConnection dbcon; dbcon = new TdsConnection(connectionString); + dbcon.Open(); 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"];