asp.net gridview

Question

i have table student with 5 columns that is student_idstudent_namestudent_classstudent_genderstudent_position i only want show 3 columns that is student_namestudent_class student_position i use this query select student_namestudent_class student_position from studentthe issue is whenever i come to load my gridview i got the rest two columns what will i do to hide the have tried this but not working gdvstudent.Columns[1].Visible=false; but not working anybody with idea help please using asp.net c#

Bhuvanesh Mohankumar · Answer

You should make the Auto Generate Column option in grid to false so what ever you specify only those columns will be displayed in grid view. ID = GridView1 AutoGenerateColumns = false runat = server > DataField = Column1Name HeaderText = field1 name /> DataField = Column1Name HeaderText = field2 name /> Mark as answer if found helpful.

Bhuvanesh Mohankumar · Answer

Yes you can use. You can also use any Jquery date picker controls also.

Carlos kambui · Answer

Is there a way i can use datepicker in asp.net instead of using terelik

Bhuvanesh Mohankumar · Answer

Try this HeaderText = Created On > # DataBinder.Eval(Container.DataItem Created_Date {0:dd/MM/yyyy}) %> Reply if this code works.

Carlos kambui · Answer

now tell me whenever i save date in my sql i save date only but when i load to gridview it gives me date and time i want date only to show how will i go about it

Carlos kambui · Answer

thanks for your support it works very well

Bhuvanesh Mohankumar · Answer

Hi Carlos You are binding the data to the grid using databind in code behind .aspx.cs file How you have made your gridview in UI i.e. aspx pagehave you tried this gridview code in the aspx page?

Carlos kambui · Answer

hello am using databind that is datagrid is loading from database