public void getList(string sql,string type) { jDBUtil jdb = new jDBUtil(ConfigInfo.SQLconn,"SQL"); Dgview.DataSource=jdb.getVector(sql); Dgview.Columns[type+"_STATUS"].Visible = false; foreach (DataGridViewRow x in Dgview.Rows) { if (x.Cells[type+"_STATUS"].Value.ToString()=="0") { x.Cells["STATUS"].Value = 0; } if (x.Cells[type+"_STATUS"].Value.ToString() == "1") { x.Cells["STATUS"].Value = 1; } } jdb.Close(); }