private void fill()
{
dataSet1.Reset();
MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM respuestas", dbConnection.Connection);
DataTable table = new DataTable();
adapter.Fill(dataSet1);
table = dataSet1.Tables[0];
listRespuestas = Convertions.ConvertoToListResp(table);
}
private void SimpleButton1_Click(object sender, EventArgs e)
{
dataSet2.Reset();
MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM respuestas WHERE IV = '" + textBoxSearchCedula.Text + "'", dbConnection.Connection);
DataTable table = new DataTable();
adapter.Fill(dataSet2);
table = dataSet2.Tables[0];
if (table.Rows.Count == 0)
{
return;
}
List <Respuestas> listRespuestas2 = Convertions.ConvertoToListResp(table);
//table.Columns.Remove("numero");
table.Columns.Remove("III");
table.Columns.Remove("V");
table.Columns.Remove("VI");
table.Columns.Remove("VII");
table.Columns.Remove("VIII");
table.Columns.Remove("IX");
table.Columns.Remove("X");
table.Columns.Remove("XI");
table.Columns.Remove("XII");
table.Columns.Remove("XIII");
table.Columns.Remove("XIV");
table.Columns.Remove("XV");
table.Columns.Remove("XVI");
table.Columns.Remove("XVII");
gridControl1.DataSource = table;
}
