Member Avatar for like_bilal02

Dear Freinds

I want to get two rows out of 6 columns in datagrid from database out of 6 columns so kindly give me a query of this programme but give me linq to sql query thanks

  • 3 Contributors
  • 2 Replies
  • 61 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by ShahanDev

Recommended Answers

All 2 Replies

Member Avatar for jlego

select column1, column2 from table

Member Avatar for ShahanDev

You could try like this:

'To select top 2 rows from 2 out of 6 columns
Select Top(2) Column1, Column2 from YourTable

'To select all rows from 2 out of 6 columns
Select Column1, Column2 from YourTable

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.