asp.net gridview

Question

i have table student with 5 columns that is student_id,student_name,student_class,student_gender,student_position, i only want show 3 columns that is student_name,student_class ,student_position i use this query select student_name,student_class ,student_position from student,the 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 page,have you tried this gridview code in the aspx page?

Carlos kambui · Answer

hello am using databind that is datagrid is loading from database,

asp.net gridview

Answers (8)