ASP.NET

23-Apr-09 2:42

Good Afternoon All

I have a Gridview that looks like this

http://www.vuyiswamaseko.tiyaneproperties.co.za/images/Problem_Grid.JPG[^]

As you can see in the Description Field there are Duplicates but with Different Cycle Template Field. I want my grid to look like this

DESCR          |CYCLE TEMPLATE  
-------------------------------
Campbell Nancy |"6 10"        |
-------------------------------
Salhab W MR    |"9"           |
-------------------------------

If it Finds a Duplicate it must Add the Cyle Template and Diplay it as a String and if there is no Duplicate , it must be Left with that String like Salhab W MR is "9"

Thank you

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Nyoti Rukadikar23-Apr-09 3:09

23-Apr-09 3:09

I do not know if the way I am telling is a correct way. But I solved this problem for me like this.

1) Fetch the data from the database into datatable.
2) Create another datatable and add new row to it.
3) Get the "Description" Column and add it as a column to the new table. Get the corresponsing Cycle Template solumn and add to table.
4) Loop throught the table with table.Select() to get all the rows having same description.
5) For each such row, get the cycle template and add it to the same column (Cycle Template which you added previously)

In short, create a dynamic table this way and bind it to grid.

Thanks,
Nyoti

Vimalsoft(Pty) Ltd23-Apr-09 3:59

23-Apr-09 3:59

Can you please Give me an T-SQl example ?

Thank you

Nyoti Rukadikar23-Apr-09 4:09

23-Apr-09 4:09

With T-SQL you will return an input from select query, which will look something like this.

Description Cost Template

description1 9
description2 10
description1 29
description3 8
description3 4

Get this into a datatable. You can do it either using adaptor.Fill (Dataset)
and then dataset.Tables[0]

Let me know if I understood your question correctly.

Thanks.

Vimalsoft(Pty) Ltd23-Apr-09 4:20

23-Apr-09 4:20

I wanted to do this in one side , if it can be done in SQl, then The SP should return a Complete data that does not need any manipulation from the C# side, if this can be done from C# side , then the Data can come in Duplicate manner and can be manupilated from C# side only.

Thank you,

Nyoti Rukadikar23-Apr-09 4:28

23-Apr-09 4:28

I think manipulation on C# side is better than looping at the stored procedure level. (Writing cursur,fetching the data and manipulate eaither into a string or temp table is I think expensive)

Thanks,
Nyoti

Nyoti Rukadikar23-Apr-09 4:10

23-Apr-09 4:10

I can post the code may be by EOD today for this.

Thanks,
Nyoti

Vimalsoft(Pty) Ltd23-Apr-09 4:17