没有行插入我的数据库 [英] No rows inserted into my database
本文介绍了没有行插入我的数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
请有人帮我吗...
Can anyone help me here please...
private void button3_Click(object sender, EventArgs e)
{
SqlCeConnection con = new SqlCeConnection();
con = utility.createconnection("Database1");
Database1DataSet1 dsCustomer = new Database1DataSet1();
SqlCeCommand Query = new SqlCeCommand("INSERT INTO shop_details " +
"(shop_name,Name,Address,shop_id) " +
"VALUES (@shop_name,@Name,@Address,@shop_id)", con);
Query.Parameters.AddWithValue("@shop_name", textBox8.Text);
Query.Parameters.AddWithValue("@Name", textBox1.Text);
Query.Parameters.AddWithValue("@Address", textBox2.Text);
Query.Parameters.AddWithValue("@shop_id", textBox7.Text);
Query.ExecuteNonQuery();
SqlCeDataAdapter sqlceda = new SqlCeDataAdapter(Query);
sqlceda.Fill(dsCustomer, "shop_details");
}
推荐答案
请参考以下链接：
http://msdn.microsoft.com/en- us / library / system.data.sqlserverce.sqlcedataadapter.insertcommand（v = vs.80）.aspx [ ^ ]
Please refer link given below:
http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlcedataadapter.insertcommand(v=vs.80).aspx[^]
这篇关于没有行插入我的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
