asp.net gridview

Carlos kambui

10y837.NET

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#

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhuvanesh Mohankumar10y ago
Accepted 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 Mohankumar10y ago
Yes, you can use.
You can also use any Jquery date picker controls also.
Carlos kambui10y ago
Is there a way i can use datepicker in asp.net instead of using terelik

Bhuvanesh Mohankumar10y ago

Try this,

 HeaderText="Created On">

<%# DataBinder.Eval(Container.DataItem, "Created_Date", "{0:dd/MM/yyyy}")%>

Reply, if this code works.

Carlos kambui10y ago
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 kambui10y ago
thanks for your support
it works very well
Bhuvanesh Mohankumar10y ago
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 kambui10y ago
hello am using databind that is datagrid is loading from database,