程序如下:
string dataDir = AppDomain.CurrentDomain.BaseDirectory;
if (dataDir.EndsWith(@"bin\debug\") || dataDir.EndsWith(@"\bin\Release\"))
{
dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
}
using (SqlConnection conn = new SqlConnection(@"Data Source=XIAO-PC\SQLEXPRESS;
AttachDBFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "Insert into Table2 (Name) values('今天vv')";
int count = cmd.ExecuteNonQuery();//int或bool类型要看你是怎么返回的了,我这以int为例
if (count > 0) Console.WriteLine("插入数据成功!");
else Console.WriteLine("插入数据失败!");
//cmd.ExecuteNonQuery();
// Console.WriteLine("插入成功!");
}
}
Console.WriteLine("打开数据库连接成功");
Console.ReadKey();
问题原因:if (dataDir.EndsWith(@"bin\debug\") || dataDir.EndsWith(@"\bin\Release\"))这行代码里debug写错了,应该是Debug。原来就是这么简单的问题,希望自己下次注意!