C#连接SqlServer数据库

最新推荐文章于 2024-04-29 23:47:34 发布

吉嘟嘟左卫门

最新推荐文章于 2024-04-29 23:47:34 发布

阅读量972

点赞数

文章标签： sqlserver 数据库 c#

本文链接：https://blog.csdn.net/weixin_42662567/article/details/130340883

版权


> using System.Data.SqlClient;
> 
> internal class Program {
>     private static void Main(string[] args)
>     {
>         string ConStr = "Data Source = 192.168.1.3; Database = TEST;"
>              + "User Id = sa; Password = sa";
>         SqlConnection SqlCon = new SqlConnection(ConStr);
>         SqlCon.Open();
>         string str = "SELECT * FROM Stu_table";
>         SqlCommand SqlCom = new SqlCommand(str, SqlCon);
>         SqlDataReader Sdr = SqlCom.ExecuteReader();
>         while (Sdr.Read())
>         {
>             Console.WriteLine(Sdr["Name"].ToString());
>         }
>         Console.ReadLine();
>     } }