求教datdagrid数据显示问题!!!急!!!100分相送
zwm00 2005-11-01 03:38:24 为何直接在数据库输入的数据可以用datagrid显示出来,而通过系统添加程序写进数据库的数据竟然显示不出来,但是可以通过修改界面逐条查询出来,这是什么原因啊?好奇怪啊 !!!高手帮帮忙!!!插入sql代码为:
sqlstr2 = "insert into shbuse values ('" & Me.TextBox1.Text & "','" & CDate(Me.Textbox13.Text) & "','" & Me.Textbox15.Text & "','" & Me.Textbox14.Text & "','" & Me.Textbox16.Text & "','" & CDate(Me.Textbox17.Text) & "')",用到了数据类型转换函数,
查询代码如下:
sqlstr = "SELECT shbbase.shbno as 设备编号,shbbase.shbclass as 分类号,shbbase.shbname as 名称,shbbase.shbkind as 型号," & _
"FROM shbbase,shbuse,shbused where shbbase.shbno like '%" & str1 & "%' and (shbuse.shbno = shbbase.shbno) and (shbuse.shbusedno=shbused.shbusedno)"