初学 内嵌MDF 代码如下,运行成功能输出插入成功打开成功,但是数据库里面并没有插入数据~~~
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
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=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"))
{
conn.Open(); using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "Insert into test (id,name) values (1,'awd')";
cmd.ExecuteNonQuery();
Console.WriteLine("插入成功!");
} }
Console.WriteLine("打开成功!");
Console.ReadKey();
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
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=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"))
{
conn.Open(); using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "Insert into test (id,name) values (1,'awd')";
cmd.ExecuteNonQuery();
Console.WriteLine("插入成功!");
} }
Console.WriteLine("打开成功!");
Console.ReadKey();
}
}
}
你查数据库是怎么做的?查询分析器下做的吧?查询分析器执行sql,所对应的数据库,是不是dataDir\Database1.mdf呢?
Console.WriteLine("插入成功!");其实执行成功和未成功 都显示插入成功加判断
public static int ExecuteNonQuery(string cmdtext, SqlParameter[] para, CommandType ct)
{
int value;
using (cmd = new SqlCommand(cmdtext, GetConn()))
{
cmd.CommandType = ct;
cmd.Parameters.AddRange(para);
value = cmd.ExecuteNonQuery() > 0 ? 1 : 0;
}
return value;
}
if (dataDir.EndsWith(@"\bin\Debug\")|| dataDir.EndsWith(@"\bin\Release\"))
唉 ,浪费了我 半个钟的时间 。