- 最后登录
- 2013-6-14
- 注册时间
- 2012-8-17
- 阅读权限
- 30
- 积分
- 714
 
- 纳金币
- 714
- 精华
- 0
|
mono中有操作sqlserver的相关dll,可以直接引用。下面例子共参考:
using System;
using System.Data;
using System.Data.SqlClient;
public class Test
{
public static void Main(string[] args)
{
string connectionString =
"Server=local;" +
"Database=pubs;" +
"User ID=UserName;" +
" assword=Password;";
IDbConnection dbcon;
using (dbcon = new SqlConnection(connectionString)) {
dbcon.Open();
using (IDbCommand dbcmd = dbcon.CreateCommand()) {
string sql =
"SELECT fname, lname " +
"FROM employee";
dbcmd.CommandText = sql;
using (IDataReader reader = dbcmd.ExecuteReader()) {
while(reader.Read()) {
string FirstName = (string) reader["fname"];
string LastName = (string) reader["lname"];
Console.WriteLine("Name: " +
FirstName + " " + LastName);
}
}
}
}
}
} |
|