c# 链接sql server_c#连接局域网server-优快云博客

本文链接：https://blog.youkuaiyun.com/edward_faint/article/details/20043579

本文介绍了如何使用C#编程语言连接到SQL Server数据库。详细步骤包括设置连接字符串、建立SqlConnection对象以及执行SQL命令。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace testConnectionSqlServer
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                string connectionString;
                string queryString;

                //connectionString = "Data Source=192.168.1.1;User ID=*;password=*";
                connectionString = 
                    "Data Source=127.0.0.1;Initial Catalog=Taobao;" + "Integrated Security=SSPI;";
                queryString = "select * from MerchandiseInformation";

                SqlConnection myConnection = new SqlConnection(connectionString);

                SqlCommand myCommand = myConnection.CreateCommand();

                myCommand.CommandText = queryString;

                myConnection.Open();

                SqlDataReader myDataReader = myCommand.ExecuteReader();

                myDataReader.Read();

                Console.WriteLine("编号:"+myDataReader["编号"]);
                Console.WriteLine("拿货地址:" + myDataReader["拿货地址"]);

                myDataReader.Close();
                myConnection.Close();
            }
            catch(SqlException e)
            {
                Console.WriteLine(e.ErrorCode);
                Console.WriteLine(e.Message);
            }

        }
    }
}

http://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqlconnection%28v=vs.110%29.aspx

http://msdn.microsoft.com/zh-cn/library/d7469at0%28v=vs.110%29.aspx