Posted on: 8/1/2013 3:09:16 AM | Views : 228

In my gridview i have this following things as shown in my binding of sql with gridview in the page_load as i want it to load upon opening the page.
SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Data Source = localhost; Initial Catalog = MajorProject; Integrated Security= SSPI"; conn.Open(); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter("SELECT memberreportid, typeofcrime, crdatetime, address, detail, incidentdate, incidenttime, property, victim, suspect from memberreport", conn); da.Fill(ds); GWCase.DataSource = ds; GWCase.DataBind(); conn.Close();


However, i'm trying to prevent property, victim and suspect column from appearing in the gridview. I used
Visible = false;


in my gridview but it totally remove my gridview( of course ).
I tried using boundfield as shown below in my ...

Go to the complete details ...