积极答复者
用C#连接Access,请问有没有直接写一个update或insert语句然后执行它的方法?

问题
答案
-
你好
你的意思是不是想sql server一样,c#连接access然后update和insert?
string ConnString= @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\WindowsFormsApplication2\forumArt.accdb"; Update:
string SqlString = "Update Contacts Set FirstName = ?, LastName = ?"; using (OleDbConnection conn = new OleDbConnection(ConnString)) { using (OleDbCommand cmd = new OleDbCommand(SqlString, conn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text); cmd.Parameters.AddWithValue("LastName", txtLastName.Text); conn.Open(); cmd.ExecuteNonQuery(); } }
Insert:
string SqlString = "Insert Into Contacts (FirstName, LastName) Values (?,?)"; using (OleDbConnection conn = new OleDbConnection(ConnString)) { using (OleDbCommand cmd = new OleDbCommand(SqlString, conn)) {
cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text); cmd.Parameters.AddWithValue("LastName", txtLastName.Text); conn.Open(); cmd.ExecuteNonQuery(); } }
Cookie Luo[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- 已标记为答案 Martin_XieModerator 2011年8月8日 8:45
全部回复
-
Hi~
你可以參考
http://j796160836.pixnet.net/blog/post/26514348
http://www.c-sharpcorner.com/UploadFile/mimrantaj/Database102102008130743PM/Database1.aspx
http://www.dotblogs.com.tw/yc421206/archive/2009/07/15/9504.aspx
都可以達到你的要求目的
逐步學習,逐夢踏實;腳步要踩穩,這樣下一步才不會跌倒。 http://www.dotblogs.com.tw/nobel12 -
你好
你的意思是不是想sql server一样,c#连接access然后update和insert?
string ConnString= @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\WindowsFormsApplication2\forumArt.accdb"; Update:
string SqlString = "Update Contacts Set FirstName = ?, LastName = ?"; using (OleDbConnection conn = new OleDbConnection(ConnString)) { using (OleDbCommand cmd = new OleDbCommand(SqlString, conn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text); cmd.Parameters.AddWithValue("LastName", txtLastName.Text); conn.Open(); cmd.ExecuteNonQuery(); } }
Insert:
string SqlString = "Insert Into Contacts (FirstName, LastName) Values (?,?)"; using (OleDbConnection conn = new OleDbConnection(ConnString)) { using (OleDbCommand cmd = new OleDbCommand(SqlString, conn)) {
cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text); cmd.Parameters.AddWithValue("LastName", txtLastName.Text); conn.Open(); cmd.ExecuteNonQuery(); } }
Cookie Luo[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- 已标记为答案 Martin_XieModerator 2011年8月8日 8:45