如何将参数传递给ms访问以获取数据 [英] How to pass parameters to ms access to get the data back

问题描述

我是新的ms访问..可以任何人帮助我发送参数的查询和获取数据（以一个例子）..我使用C＃作为编码语言（Asp.Net）

I am new to ms access..Can anybody help me in sending parameters to queries and get back the data(with an example)..i am using C# as coding language(Asp.Net)

提前感谢

推荐答案

您需要使用以下语句：

using System.Data.OleDb;

示例：

string ConnString = "Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|Northwind.mdb";
string SqlString = @"Select * From Contacts 
                    Where FirstName = @FirstName And LastName = @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();
        using (OleDbDataReader reader = cmd.ExecuteReader())
        {
            while (reader.Read())
            {
                Response.Write(reader["FirstName"].ToString() + " " + reader["LastName"].ToString());
            }
        }
    }
}

这篇关于如何将参数传递给ms访问以获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！