C#转化成VBA语句

[yongchengding]

try
{
OleDbCommand cmd4 = new OleDbCommand("", conn1);
string sql4 = @"select * from 各级杆塔对应参数";
cmd4.CommandText = sql4;
OleDbDataAdapter adp4 = new OleDbDataAdapter("", conn1);
adp4.SelectCommand.CommandText = sql4;
adp4.Fill(ds1, "各级杆塔对应参数");
dataGridView4.DataSource = ds1.Tables["各级杆塔对应参数"].DefaultView;

[shawn_yang]

你的conn1不会没写吧

[鸭梨山大帝]

Dim adp as new OleDbDataAdapter(sql4, conn1) --> 如果你说的是VBA..那么需要这样修改 Dim adp as OleDbDataAdapter ser adp = new OleDbDataAdapter(sql4, conn1) 如果你说的是VB.NET,那么这句话是没有问题的.

[鸭梨山大帝]

ser adp = new OleDbDataAdapter(sql4, conn1) --> SET adp = new OleDbDataAdapter(sql4, conn1)

[shawn_yang]

dim sql4 as string="select * from 各级杆塔对应参数" Dim adp as new OleDbDataAdapter(sql4, conn1) dim ds1 as new dataset adp.fill(ds1,"各级杆塔对应参数") dataGridView4.DataSource = ds1.Tables("各级杆塔对应参数").DefaultView

[yongchengding]

哪位大神帮帮忙啊

[yongchengding]

引用 1 楼 shawn_yang 的回复:

dim sql4 as string="select * from 各级杆塔对应参数" Dim adp as new OleDbDataAdapter(sql4, conn1) dim ds1 as new dataset adp.fill(ds1,"各级杆塔对应参数") dataGridView4.DataSource = ds1.Tables("各级杆塔对应……

为什么第二句说编译错误：缺少语句结束