此网页创建一个表,一个按钮,一个文本框,在文本框内输入一个索引号,单击按钮。从表中显示出现表中相应的记录内容,如无则不显示。此表能正确读数据库。主要是个小例子。
文件名:test_1.aspx
<%@ Page Language="C#" Debug=true %>
<script runat="server">
// Insert page code here
//
System.Data.DataSet MyQueryMethod(int id) {
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=E://wwwroot//adat" +
"a.mdb";
System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);
string queryString = "SELECT [one].* FROM [one] WHERE ([one].[id] = @id)";
System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
System.Data.IDataParameter dbParam_id = new System.Data.OleDb.OleDbParameter();
dbParam_id.ParameterName = "@id";
dbParam_id.Value = id;
dbParam_id.DbType = System.Data.DbType.Int32;
dbCommand.Parameters.Add(dbParam_id);
System.Data.IDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter();
dataAdapter.SelectCommand = dbCommand;
System.Data.DataSet dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataSet);
return dataSet;
}
void Button1_Click(object sender, EventArgs e) {
//DataGrid1.DataSource = GetOrderDetails(CInt(TextBox1.Text));
//DataGrid1.DataSource = GetOrderDetails(Convert.ToInt32(TextBox1.Text));
DataGrid1.DataSource = MyQueryMethod(int.Parse(TextBox1.Text));
DataGrid1.DataBind();
}
</script>