ASP。NET SQL
皮熊熊 2011-05-25 11:51:51 我写了段程序,往数据库中加入数据,程序执行完了,也弹出了MESSAGEBOX,但是数据库中显示表数据没有,这是为什么
private void button1_Click(object sender, EventArgs e)
{
string dateDir = AppDomain.CurrentDomain.BaseDirectory;
if (dateDir.EndsWith(@"\bin\Debug\") || dateDir.EndsWith(@"\bin\Release\"))
{
dateDir = System.IO.Directory.GetParent(dateDir).Parent.Parent.FullName;
AppDomain.CurrentDomain.SetData("DateDirectory", dateDir);
}
using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;
AttachDbFilename=|DataDirectory|\软件工程.mdf;Integrated Security=True;User Instance=True"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into bookshop(ID,name,writer,price,publisher,[key],rest,sold,kind) values ('1','明白之神','赵恒(译)','26','中信出版社','162869351','34','34','社科')";
cmd.ExecuteNonQuery();
}
conn.Close();
}
MessageBox.Show("OK");
}