SQLTeam.com | Weblogs | Forums

DATASET XSD Filter

Hi,

Using parameter query in DataSet XSD which is below.

SELECT Atn_No,Atn_Date2, Atn_Type, Dg_Code, Emp_Name, Emp_Number, Hst_No, Shift_Desc FROM View_AttendanceReport Where Atn_No=@Atn_No

But when i passed the parameter @Atn_No got an error parameter @Atn_No which is not Supplied.

    Dim adap As DailyAttendanceDataSetTableAdapters.View_AttendanceReportTableAdapter = New DailyAttendanceDataSetTableAdapters.View_AttendanceReportTableAdapter
    Dim ds As DailyAttendanceDataSet.View_AttendanceReportDataTable = New DailyAttendanceDataSet.View_AttendanceReportDataTable
    adap.GetData(10068)

Thanks
Basit.