Hi,
how do I perform a simple insert command?
I dont need the SQL syntax, just how do i do it using VS2005.
using SqlDataSource, for some reason, after writing the insert sentence, the "next" button remains gray.
i am using VS2005 and sql server.
Thank you.
Have you defined a SELECT statement? It seems you have to always have a SELECT statement when using the VS SqlDataSource configuration wizard.|||Thanks!I need to perform a join on six different tables to produce a report. The biggest join I have ever done has been four tables. The way I did that query was to join three tables and then to perform the final select on the three table join.
Can anyone give me some advice. Should I use the same approach? Or can I just continue to use the keyword INNER JOIN to perform the joins?
If you need the 6 tables to get the data you want then you have to use the tables. Whether you need to use INNER JOIN or other joins depends on the data. There's nothing wrong in joining 6 tables in one query.
