c# access的sql语句

来源：百度知道 编辑：UC知道 时间：2024/09/22 09:33:32
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections;
using System.Data.Sql;
using System.Data.SqlTypes;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page
{
//private string SQLConnectionString = "data source=88.128.91.178;Database=pubs;uid=sa;uid=sa;pwd=sa";

protected void Page_Load(object sender, EventArgs e)
{
try
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=e:\db1.mdb";
DataSet DS = new DataSet();

OleDbConnection objConnection =

objConnection.Close();
后面接
Repeater1.DataSource = DS.Tables[0];
Repeater1.DataBind();

sql的没报错？

SqlDataAdapter sda = new SqlDataAdapter(qry, conn);
你这个就错了
传的参数是一个string一个SqlConnection
你传的两个string 不报错？

你确定你的access的user表中有数据么？
你的代码是完全正确的
try
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=e:\db1.mdb";
DataSet DS = new DataSet();

OleDbConnection objConnection = new OleDbConnection(strConnection);

objConnection.Open();
Response.Write("连接成功");
string aa = "select * from [user]";
OleDbDataAdapter oda = new OleDbDataAdapter(aa,objConnection);
try{
oda.Fill(DS,"user");
}
catch (Exception ex)
{
Response.Write("连接数据库失败！原因如下：<br>" + ex.Message);
}