Grid view bind method no repeated the fields?

make auto generate colums to false !

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

can you attach sql query output here and attach the result screen ?

Thanks,
Sanjay

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

hi,

this is my sql query output...

1 Websit Manager Domain Manager 1
2 Table Reservation Restaurant Manager 1
3 Costomer Manager Team Manager 1
4 Urbane News & Events 1
5 Discover Careers 1
6 Vehicle Maintanance Customer Feedback 1
7 Sales Photo Gallery 1
8 Reports Manage Videos 1
9 Manage Users Health Tips 1
10 Websit Manager Food Menu Manager 1

chandru

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

can you also attach an image what you get as output and an image how you want your output be?

Thanks,
Sanjay

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Hi,
Do you want to combine website managers i.e shows one website manger and two sublinks, domian manager and food menu manager? if so Can you give your table structure

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

You just modify your query then you can get no repeated data.
Your Modify query is
SELECT a.sno,a.menuname,b.submenuname,b.sno from submenu as b inner join topmenu as a on a.sno=b.menuid INNER JOIN Submenulist as c ON b.sno=c.submenuid group by a.sno,a.menuname,b.submenuname,b.sno

If you think still repeated rows coming on your Grid you just run the query on sql server and see there is different sno in your output.
So to Show on Grid You just remove a.sno and b.sno from your select statement.
Your Modify query is
SELECT a.menuname,b.submenuname from submenu as b inner join topmenu as a on a.sno=b.menuid INNER JOIN Submenulist as c ON b.sno=c.submenuid group by a.menuname,b.submenuname

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

hi,

i want no repeat websitemanager show.

example:

Mani menu: Websitemanager
submenu:
Domain Manager
Restaurant Manager
Team Manager
this type of output i want

Advance thanks to all
 Download source file

chandru

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

hi,
CREATE TABLE [dbo].[topmenu](
[sno] [int] IDENTITY(1,1) NOT NULL,
[menuname] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[submenu] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[submenu](
[menuId] [int] IDENTITY(1,1) NOT NULL,
[sno] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[submenuname] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[menuurl] [nvarchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status] [nvarchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[showmenu] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[Submenulist](
[submenuId] [int] IDENTITY(1,1) NOT NULL,
[sno] [int] NULL,
[SubmenuList] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MenuUrl] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShowMenu] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

Advance Thanks to all

chandru

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Hi

Which field was repeated.use distinct in front of the field.
Ex:

SELECT DISTINCT City FROM Persons

P.Magesh
Software Engineer
Colan Infotech

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator