再问个 我这段代码有什么问题吗?为什么提示错误呢?(myconn()行错误)
堆栈跟踪:
[OleDbException (0x80004005): 找不到可安装的 ISAM。]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +19Sub Page_Load(source As Object, E As EventArgs)
Dim myconn As New oledbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource="& server.mappath("data.mdb"))
Dim myAdapter As New OleDbDataAdapter
Dim myOleDbCommandBuilder as OleDbCommandBuilder = New OleDbCommandBuilder(myadapter)
Dim Ds As DataSet = New DataSet
myadapter.SelectCommand = new oledbcommand("select id, 标题, 署名, 正文 from guest order by id desc",myconn)
myconn.open()
myadapter.fill(ds, "guest")
ml.datasource=ds.tables("guest").defaultview
ml.databind()
end sub
堆栈跟踪:
[OleDbException (0x80004005): 找不到可安装的 ISAM。]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +19Sub Page_Load(source As Object, E As EventArgs)
Dim myconn As New oledbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource="& server.mappath("data.mdb"))
Dim myAdapter As New OleDbDataAdapter
Dim myOleDbCommandBuilder as OleDbCommandBuilder = New OleDbCommandBuilder(myadapter)
Dim Ds As DataSet = New DataSet
myadapter.SelectCommand = new oledbcommand("select id, 标题, 署名, 正文 from guest order by id desc",myconn)
myconn.open()
myadapter.fill(ds, "guest")
ml.datasource=ds.tables("guest").defaultview
ml.databind()
end sub
string StrConn="Server=127.0.0.1;uid=sa;pwd=;database=databaseName";
SqlConnection conn=new SqlConnection(StrConn);
string StrSql="select ID from TableName";
SqlCommand cmd=new SqlCommand(StrSql,conn);
SqlDataReader rdr=cmd.ExecuteReader();
2.网上很多,随便找个例子看看,
3.命名空间:相当于Java引用包一样,可以把他当做一个存放东西的地方。
4.绑定简易地说就是让两者之间强制存在某种关系,
很多答案可以去MSDN查找,