Breaking News

Editors Picks

Friday, December 9, 2011

How to hide Gridview column programmatically?


        GridView1.DataBind();
        if (GridView1.Columns.Count > 0)
            GridView1.Columns[0].Visible = false;
        else
        {
            GridView1.HeaderRow.Cells[0].Visible = false;
            foreach (GridViewRow gvr in GridView1.Rows)
            {
                gvr.Cells[0].Visible = false;
            }
        }
Read more ...

how to find and delete duplicate records in oracle

 // For Select duplicate records

select *
from table_Name
group by key1, key2 having count (*) > 1;


// For   delete duplicate records

delete from test a
where rowid <> ( select max(rowid)
from test b
where a.sno = b.sno
and a.sname = b.sname )
Read more ...

Contact Us

Name

Email *

Message *