这段代码有错吗

来源：百度知道 编辑：UC知道 时间：2024/07/01 06:47:29
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("person.mdb");
conn.Open();
string sql = "select * from grade";
OleDbCommand odc = new OleDbCommand(sql, conn);
OleDbDataReader odr = odc.ExecuteReader();
gv.DataSource = odr;
gv.DataBind();
conn.Close();
}

我这里有个vb.net，你改一改

Dim strSQL1, strConn1 As String
strConn1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("..\") & "\MAIN.mdb"

Dim comdTmp1 As OleDb.OleDbCommand
Dim dr1 As OleDb.OleDbDataReader
Dim myConnection1 As OleDb.OleDbConnection
strSQL1 = "select *,BANKNO + ' ' + BANKFNAME AS MIX From BANK"
myConnection1 = New OleDb.OleDbConnection(strConn1)
comdTmp1 = New OleDb.OleDbCommand(strSQL1, myConnection1)
myConnection1.Open()
dr1 = comdTmp1.ExecuteReader()

protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("person.mdb");
conn.Open();
string sql = "selec