hi, can i use count and top 6 in the same sql command ?? and also, how can i use inner joins to link guest id in reservation table with guest name from guest table
missc
0
Junior Poster in Training
Recommended Answers
Jump to PostThe easiest way would be to get all and then count top 6 from the dataTable.
//create connection, command (cmd) DataTable table = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(table); //select top 6: //you can even sort datra if you want!! for(int i = 0; i …
Jump to PostSo you would like to create a sql Query?
All 6 Replies
Mitja Bonca
557
Nearly a Posting Maven
missc
0
Junior Poster in Training
Mitja Bonca
557
Nearly a Posting Maven
missc
0
Junior Poster in Training
BitBlt
452
Practically a Master Poster
Featured Poster
missc
0
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.