HOME > .NET Framework > Forum > รบกวนช่วยแก้โค้ดให้หน่อยน่ะค่ะมันErrorอ่ะค่ะWHERE a.[Date] >= GetDate() order by a.[Date] asc WHERE a.Status like '%" + Label10.Text + "%'";
รบกวนช่วยแก้โค้ดให้หน่อยน่ะค่ะมันErrorอ่ะค่ะWHERE a.[Date] >= GetDate() order by a.[Date] asc WHERE a.Status like '%" + Label10.Text + "%'";
string strSQL = "select a.AppointID, b.AnName, a.Status, b.FirstName +' '+ b.LastName as [Name], a.[Description], CONVERT(varchar(10), a.[DATE], 110) as [Date], a.[Time] from Appointment a left join Animal b on a.AnimalID = b.AnimalID WHERE a.[Date] >= GetDate() order by a.[Date] asc WHERE a.Status like '%" + Label10.Text + "%'";
string strSQL = "select a.AppointID, b.AnName, a.Status, b.FirstName +' '+ b.LastName as [Name], a.[Description]";
strSQL += ", CONVERT(varchar(10), a.[DATE], 110) as [Date], a.[Time]";
strSQL += " from Appointment as a left join Animal as b on a.AnimalID = b.AnimalID";
strSQL += " WHERE a.[Date] >= GetDate() and a.Status like '%" + Label10.Text + "%'";
strSQL += " order by a.[Date] asc";