给的分太少了点,不过,将就啦,嘿
你用这个试试:Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
s = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;" _
& " Data Source=d:\vb61x\rsg1.mdb"
cnn.Open s
Set rst = New Recordset
rst.Open "职工工资", cnn, 1, 3
你用这个试试:Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
s = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;" _
& " Data Source=d:\vb61x\rsg1.mdb"
cnn.Open s
Set rst = New Recordset
rst.Open "职工工资", cnn, 1, 3
解决方案 »
- CKEditor中的ToolBar设置
- .net orm框架的原理
- 存储过程动态调用表的问题,在线等
- asp.net中web控件如何调用javascript
- 急,怎样解决asp.net中刷新与isPostBack冲突问题
- Description: An application error occurred on the server. The current custom error settings for this
- 怎样将数据库中的数据绑定到DropDownList控件中!!
- 一个建小型查询网站问题
- 求winform的.exe文件混淆工具,用了postbuild混淆工具,但是混淆后的exe有问题,出错了,求好点的混淆工具
- 急求:有关工单流转的流程问题。
- 我安装了SDK,为什么我的.ASPX文件不能正确运行呀?
- 上传文件太大后,页面出错如何处理??
public void InsertRow(string myConnectionString)
{
// If the connection string is null, use a default.
if(myConnectionString == "")
{
myConnectionString = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";
}
SqlConnection myConnection = new SqlConnection(myConnectionString);
string myInsertQuery = "INSERT INTO Customers (CustomerID, CompanyName) Values('NWIND', 'Northwind Traders')";
SqlCommand myCommand = new SqlCommand(myInsertQuery);
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
}
先要导入相关的命名空间
imports system.data
imports system.data.oledbdim cnn as new oledbConnection()
cnn.connectionstring="Provider=microsoft.jet.oledb.4.0;data source=d:\vb61x\rsg1.mdb"
cnn.open()
'创建数据集,在.NET下,不要用记录集了,虽然可以用
dim strSql as string="select * from xxx"
dim objCmd as new oledbDataAdapter(strSql,cnn)
dim objDs as new dataset()
objCmd.fill(objDs,"xxx")大概就是这样了