Public CN As New ADODB.Connection
Public oRs As New ADODB.Recordset
Private Sub Show_Grid()
Dim oRs As New ADODB.Recordset
Dim i As Long
CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;Mode=ReadWrite;Persist Security Info=False"
i = grdmain.FixedRows
oRs.Open "select * from 供应商", CN
Do While Not oRs.EOF
grdmain.AddItem ""
grdmain.TextMatrix(i, SupplierIDCol) = IIf(IsNull(oRs!供应商ID), "", oRs!供应商ID)
grdmain.TextMatrix(i, SupplierNameCol) = IIf(IsNull(oRs!供应商名称), "", oRs!供应商名称)
grdmain.TextMatrix(i, ReCol) = IIf(IsNull(oRs!备注), "", oRs!备注)
grdmain.TextMatrix(i, KindsIDCol) = IIf(IsNull(oRs!类别ID), "", oRs!类别ID)
i = i + 1
oRs.MoveNext
Loop
oRs.Close
Set oRs = Nothing
End Sub
上面为使用VSFLEXGRID和ADO 的VB代码。哪位达人翻译,把它翻译成datagridview 和ADO 的 C# 代码,各路神仙,快亮出神通吧
小弟拜谢
Public oRs As New ADODB.Recordset
Private Sub Show_Grid()
Dim oRs As New ADODB.Recordset
Dim i As Long
CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;Mode=ReadWrite;Persist Security Info=False"
i = grdmain.FixedRows
oRs.Open "select * from 供应商", CN
Do While Not oRs.EOF
grdmain.AddItem ""
grdmain.TextMatrix(i, SupplierIDCol) = IIf(IsNull(oRs!供应商ID), "", oRs!供应商ID)
grdmain.TextMatrix(i, SupplierNameCol) = IIf(IsNull(oRs!供应商名称), "", oRs!供应商名称)
grdmain.TextMatrix(i, ReCol) = IIf(IsNull(oRs!备注), "", oRs!备注)
grdmain.TextMatrix(i, KindsIDCol) = IIf(IsNull(oRs!类别ID), "", oRs!类别ID)
i = i + 1
oRs.MoveNext
Loop
oRs.Close
Set oRs = Nothing
End Sub
上面为使用VSFLEXGRID和ADO 的VB代码。哪位达人翻译,把它翻译成datagridview 和ADO 的 C# 代码,各路神仙,快亮出神通吧
小弟拜谢
请各路大仙亮 法宝吧
piblic OleDbDataReader ors;private show_Grid(){
long i;
cn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;Mode=ReadWrite;Persist Security Info=False"");
cn.open();
ors=new OleDbCommand("select * from 供应商",cn).ExecuteReader();
while(ors.Read())
{}}我也只能尽力翻译到这里啦,我对VB不是很了解,希望这些对你已经有帮助,绑定的就你自己去弄吧。
piblic OleDbDataReader ors;private show_Grid(){
long i;
cn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;Mode=ReadWrite;Persist Security Info=False"");
cn.open();
ors=new OleDbCommand("select * from 供应商",cn).ExecuteReader();
while(ors.Read())
{}}