废话不多说了，直接给大家贴代码了，具体代码如下所示：
namespace MyFirstApp
{
class Program
{
static void Main( string [] args)
{
SqlConnection conn = null ;
SqlCommand comm = null ;
SqlDataReader sdreader = null ;
try
{
string ConStr = "server=192.168.1.110;uid=sa;pwd=woaifr0828;database=shudiansuo" ;
conn = new SqlConnection(ConStr);
conn.Open();
string sql = "select * from dbo.Member" ;
comm = new SqlCommand(sql);
comm.Connection = conn;
sdreader = comm.ExecuteReader();
sdreader.Read();
Console.WriteLine( "数据库连接成功！" );
Console.WriteLine( "student表的内容" );
while (sdreader.Read())
{
Console.WriteLine( "sdreader[\"id\"]=" + sdreader[ "Id" ]);
Console.WriteLine( "sdreader[\"name\"]=" + sdreader[ "MemberName" ]);
Console.WriteLine( "sdreader[\"sex\"]=" + sdreader[ "PhoneNum" ]);
}
sdreader.Close();
conn.Close();
}
catch (SqlException e)
{
Console.WriteLine( "A SqlException was thrown" );
Console.WriteLine( "Number = " + e.Number);
Console.WriteLine( "Message = " + e.Message);
Console.WriteLine( "StackTrace:\n" + e.StackTrace);
}
Console.ReadKey();
}
}
}
总结
以上所述是小编给大家介绍的C#连接到sql server2008数据库的实例代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持！
原文链接：http://blog.csdn.net/qq_24675479/article/details/77849532
dy("nrwz");
查看更多关于C#连接到sql server2008数据库的实例代码的详细内容...