兩個連接字串（分別對應windows身份驗證和sqlserver身份驗證）都不對，在scn.Open();這句出現錯誤。
例外資訊為"Internal connection fatal error."哪里出了問題，應該如何修改？是不是連接字串寫得不對？
using Microsoft.Data.SqlClient;
using System;
namespace SqlDatabase
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
string SqlCon = "integrated security=SSPI;data source='(local)';initial catalog = 'StarsData'";
//SqlCon = "uid='sa';pwd='111';data source='(local)';initial catalog = 'StarsData'";
SqlConnection scn = new SqlConnection();
try
{
scn.ConnectionString = SqlCon;
scn.Open();
SqlCommand scd = new SqlCommand();
scd.Connection = scn;
scd.CommandText = "select ObjectName from dbo.DeepSkyObject where Type='N'";
SqlDataReader sdr = scd.ExecuteReader();
while (sdr.Read())
{
Console.WriteLine("天體：" + sdr.GetString(0));
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
if (scn != null)
{
scn.Close();
}
}
}
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/252884.html
標籤：C#
上一篇：根據關鍵字和范圍值來計算結果（自動計算紙箱裝箱數量）
下一篇：請問怎么計算一組資料的趨勢？