vb中用adodc添加记录到sql数据库的问题

Question

请问各位DX我想用adodc向sql数据库中添加记录改怎么添加呀·adodc的属性是怎么设置的？记录源怎么设置呀···

Answer 1

最好用sql语句插入，那样较灵活

Answer 2

用ADODC连接数据库,用insert into插入数据,如
Private Sub Form_Load() 
    '连接字符串 
    Adodc1.ConnectionString = "driver={sql server};server=" + Trim(server) + ";uid=" + Trim(user) + ";pwd=" + Trim(password) + ";database=erp1" 
    '查询businessman表中全部信息 
    Adodc1.RecordSource = "select * from businessman" 
    '用datagrid显示查询信息 
    Set DataGrid1.DataSource = Adodc1 End Sub     '设置insert语句
    sqlstmt = "insert into businessman (businessmanid,businessmanname,country,province,city,address,linkman,telephone,fax)" _
              + "values('" + Trim(businessmanid) + "','" + Trim(businessmanname) + "','" + Trim(country) + "','" + Trim(province) + "','" + Trim(city) + "','" + Trim(address) + "','" + Trim(linkman) + "','" + Trim(telephone) + "','" + Trim(fax) + "')"

Answer 3

 With Adodc1
   .Recordset.AddNew
   .Recordset!时间 = Trim(lblDisplay.Caption)
   .Recordset!地点 = Trim(Complete.Text)
   .Recordset!备注 = Trim(time.Text)
   .Recordset.Update
    End With
 添加记录