Basit Khan

Basit Khan

  • NA
  • 336
  • 121.7k

Filter DataSet XSD with Parameter.

Jul 2 2019 2:50 AM
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. 

Answers (1)