代码执行到con.Open()就数据库打开异常
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace Demo2
{
class Program
{
static void Main(string[] args)
{
string conStr = "Data Source=.;Initial Catalog=Myschool;User ID=sa";
SqlConnection con = null;
try
{
con = new SqlConnection(conStr);
string sql = "insert Student values(insert Student values('S1101099','228996247','凌辉','女',1,'353149818'))";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
Console.WriteLine("修改成功");
}
else
{
Console.WriteLine("修改失败");
}
}
catch (Exception)
{
Console.WriteLine("异常");
}
finally
{
con.Close();
}
Console.ReadLine();
}
}
}