但是执行的过程中却爆出了错误如下：the multi-part identifier "Card_Info.StudentNo" could not be bound.Invalid column name 'Cardno'

Question

 在DAL层进行了对数据库的查询操作，sql语句里链接了两个表，如下：

Public Function queryBalance(ByVal cardInfo As JFEntity.CardInfo) As DataTable Implements IDAL.IselectDAL.queryBalance
        Dim sql As String
        Dim SQLHelper As New sqlHelper
        Dim sqlParams As SqlParameter()
        Dim dt As New DataTable
        '传参
        sqlParams = {New SqlParameter("@Cardno", cardInfo.CardNo)}
        sql = "select * from student_Info where student_Info.studentNo=Card_Info.StudentNo and cardID=@cardID"
        dt = SQLHelper.ExecSelect(sql, CommandType.Text, sqlParams)
        Return dt
    End Function

第一次在论坛上提出问题，很渴望得到大家的帮助，有这样的一个平台，让我们有更多的机会交流，共同成长，谢谢。

Answer 1

到底是@cardID还是@Cardno?

---

http://feiyun0112.cnblogs.com/

Answer 2

这个SQL可能有问题

select * from student_Info where student_Info.studentNo=Card_Info.StudentNo and cardID=@cardID

可能是

select * from student_Info s ,CardInfo c where s.studentNo=c.StudentNo and cardID=@cardID

---

专注于.NET ERP/CRM开发框架，C/S架构，SQL Server + ORM(LLBL Gen Pro) + Infragistics WinForms