有关addnew()有关问题,多谢帮解决一下
有关addnew()问题,谢谢帮解决一下
rs1 = New ADODB.Recordset
strsql = "select * from new "
rs1.Open(strsql, conn1, ADODB.CursorTypeEnum.adOpenForwardOnly, ADODB.LockTypeEnum.adLockOptimistic)
rs1.AddNew()
rs1.Fields( "name ") = TextBox1.Text
rs1.Fields( "c_no ") = TextBox2.Text
rs1.Fields( "date ") = TextBox3.Text
rs1.Update()
rs1.Close()
运行后提示,rs1.Fields( "name ") = TextBox1.Text
rs1.Fields( "c_no ") = TextBox2.Text
rs1.Fields( "date ") = TextBox3.Text
item为只读属性,不能赋值
------解决方案--------------------
不是,.Fields(0)里面的序号是数据库中所对应的字段的列值,第一列为0,依次类推
rs1 = New ADODB.Recordset
strsql = "select * from new "
rs1.Open(strsql, conn1, ADODB.CursorTypeEnum.adOpenForwardOnly, ADODB.LockTypeEnum.adLockOptimistic)
rs1.AddNew()
rs1.Fields( "name ") = TextBox1.Text
rs1.Fields( "c_no ") = TextBox2.Text
rs1.Fields( "date ") = TextBox3.Text
rs1.Update()
rs1.Close()
运行后提示,rs1.Fields( "name ") = TextBox1.Text
rs1.Fields( "c_no ") = TextBox2.Text
rs1.Fields( "date ") = TextBox3.Text
item为只读属性,不能赋值
------解决方案--------------------
不是,.Fields(0)里面的序号是数据库中所对应的字段的列值,第一列为0,依次类推