Thursday, June 7, 2012

ASP.NET Gridview Column Hide

If you want to hide any column Of a grid you have hide it after load the grid.

Now i want to hide the id Column which contain 1,2,3,4.....

then the code will be on load event of the grid :

 private void LoadDivisionGridData()  
       _divisionslist = new List<Division>();  
       _divisionslist = _divisionManagerObj.GetAllDivisionInfo();  
       divisionGridView.DataSource = _divisionslist;  
       divisionGridView.Columns[0].Visible = false;  

after hide the Id column it will be look life

 Thank you.

SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...