c#數據綁定之向查詢中添加參數(.Net銜接內部數據庫)

c#數據綁定之向查詢中添加參數(.Net銜接內部數據庫)。本站提示廣大學習愛好者：（c#數據綁定之向查詢中添加參數(.Net銜接內部數據庫)）文章只能為提供參考，不一定能成為您想要的結果。以下是c#數據綁定之向查詢中添加參數(.Net銜接內部數據庫)正文

在ACCESS數據庫中可以用MSSQL的情勢界說操作字符串，也能夠采取OLEDB的情勢。

MSSQL 情勢

string sqlText = @"SELECT * FROM [User] WHERE UserName= @name";

OLEDB的情勢

string sqlText = @"SELECT * FROM [User] WHERE UserName= ？";

下一步是經由過程 OleDbCommand履行操作。

OleDbCommand dataAction = new OleDbCommand(sqlText,linkDB);

給參數賦值語句采取的辦法為AddWithValue：

dataAction.Parameters.AddWithValue("@name","wangyong");

完全代碼以下：

using (OleDbConnection linkDB = new OleDbConnection(@" Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\AiMeiLi.accdb"))
            {
                linkDB.Open();
                string sqlText = @"SELECT * FROM [User] WHERE UserName= @name";
                OleDbCommand dataAction = new OleDbCommand(sqlText,linkDB);
                dataAction.Parameters.AddWithValue("@name","wangyong");
                try
                {
                    OleDbDataReader scanItems = dataAction.ExecuteReader();
                    if (scanItems.HasRows)
                    {
                        while (scanItems.Read())
                        {
                            MessageBox.Show(scanItems[1].ToString());
                        }
                    }

                }
                catch (Exception ex)
                {
                    MessageBox.Show("Failure" + ex.Message);
                }
            }