如何把datagridview中的数据全部导入access文件中
datagridview中有多行数据，
要求删除access中数据.
帮帮忙吧，
循环用事务成批导入.
给代码吧
C# code:
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.mdb;Jet OLEDB:Database Password=");
con.Open();
OleDbCommand com = new OleDbCommand();
OleDbTransaction myTrans;
myTrans = con.BeginTransaction();
com.Connection = con;
com.Transaction = myTrans;
try
{
com.CommandText = "delete * from table";
com.ExecuteNonQuery();
for (int i = 0; i < this.dataGridView1.Rows.Count; i++)
{
com.CommandText = "insert into table(col1,col2) values('" + this.dataGridView1.Rows[i].Cells["col1"].Value.ToString().Trim() + "','" + this.dataGridView1.Rows[i].Cells["col2"].Value.ToString().Trim() + "')";
com.ExecuteNonQuery();
}
myTrans.Commit();
con.Close();
}
catch
{
}
4 楼方法当数据多了�
相关问答：
<?php
include("adodb/adodb.inc.php");
$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
要组合4张表的查询，分别是A表，B表，C表，D表；
A表
Game_id Game_Name
1 abc
B表
Category_ID Category_Name Game_id
& ......
我的一个access数据库中的photo字段中的内容是这样的：
|/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg||||/UpFiles/Picture/admin/200910162300187612.jp ......
delphi如何向Access数据表中自定义字段?然后显示到DBGrid中
怎么没人理我呀
分分忒少咧，一般人都懒得进来……*^_^*
SQL
creat table TableName(ID Counter Primary Key,FieldName varchar(20))
ADOQue ......
