Ado Connection [英] Ado Connection

问题描述

您好我的问题有图片和所有故事是我之前已完成此代码并且它在我的上一个项目中工作但我几天前做了一个不同的代码我使用的代码不工作所以如果你们其中一位主持人可以看看这个并告诉我为什么我会欣赏它。所以，如果你可以去我的网页看看它会很酷

这里


lee123

Hi there my question has pictures and all and the story is i have done this code before and it worked in my last project but i have made a different one a couple of days ago and the code i used is not working so if one of you moderators could look at this and tell me why i would appreciate it. so if you could go to my web page and look at it that would be cool

here

lee123

推荐答案

你好lee123！


你应该保留好项目的副本......你能在这里发布代码吗？当我不得不去另一个地方时我担心...


Hppe你找到你想要的东西:-)


D？k？ll

Hello lee123!

You should keep good copies of your projects... Can you post the code here instead? I worry when I have to go to another site...

Hppe you find what you''re looking for:-)

D?k?ll

是的，我只是想告诉你我的意思，因为每次我试着解释它并没有按照我想要的任何方式解决这里的代码：

yea i just wanted to show you what i mean because everytime i try to explain it doesn''t work out the way i wanted to any way here is the code:

Private Sub DataList1_Click（）

Dim strSQL As String

strSQL =" SELECT * FROM TblChildsInfo WHERE childsID =" &安培; "" &安培; DataList1.BoundText& "''"

Adodc2.RecordSource = strSQL

Adodc2.Refresh

End Sub

Private Sub DataList1_Click()
Dim strSQL As String
strSQL = "SELECT * FROM TblChildsInfo WHERE childsID =" & "''" & DataList1.BoundText & "''"
Adodc2.RecordSource = strSQL
Adodc2.Refresh
End Sub

你好。


你的childsID是一个整数吗？如果答案是肯定的，你应该从你的查询中删除''并将你的DataList1.BoundText转换为整数。


如果不是这样，请告诉我什么样的错误信息你有吗。


希望这对你有所帮助


Rpicilli

Hi there.

Is your childsID an integer? If the answer is yes you should remove the '' from your query and convert your DataList1.BoundText to integer.

If this is not the case, please tell me what kind of error message are you having.

Hope this help you

Rpicilli

这篇关于Ado Connection的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！