Hi,
I'm selecting a list of results from a table called 'slots'. In a different table, called bookings, I have 3 important fields, 'booked', day_id, and week_num. Now, what I want to do, using SQL or ASP.NET logic, is get the slots from the table 'slots' where booked is not equal to 1, day_id is equal to 3, and week_num is equal to 41. How can I do this?
Thanks very much!
your question is ambigious, there is nothing called like asp.net logic. drag and drop an sqldatasource, then create your sql query using the opening wizard. then drag and drop a gridview, set its datasource property to your sqldatasourceID, you will be all set
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.