c# - Fill DataGridView on condition from database -

c# - Fill DataGridView on condition from database -

i have mysql database , datagridview in c# , fill datagridview following:

schooldataset schl = new schooldataset(); schooldatasettableadapters.studentinfotableadapter adptr = new schooldatasettableadapters.studentinfotableadapter(); adptr.fill(schl.studentinfo); datagridview1.datasource = schl.studentinfo.defaultview;

and undesired columns create them visible = false datagridview properties came problem if want specify info (rows) fill in datagridview such applying status like: fill info in datagridview isactive = 1 can still utilize above code modifications or have write sql query , fill datagridview manually ?

after searching , trying tons of codes got next in simplest code: in code above comment out lastly line datagridview1.datasource = schl.studentinfo.defaultview; or replace following

dataview dv = new dataview(schooldataset.studentinfo, "isactive = 'false'", "id", dataviewrowstate.currentrows);

which creates new dataview , filters according isactive column false value, 3rd parameter id sort based-on, , can write line datagridview1.datasource = dv; tell datagridview load info dataview. hope save someone's time. big goes @karthik ganesan

c# mysql datagridview