关于MySqlDataAdapter
mySqlCommand.CommandText = "select * from formula where 类型= '塑料'";
MySqlDataAdapter reader1 = new MySqlDataAdapter(mySqlCommand); //执行命令对象实例
reader1.Fill(table); //填充数据
MySqlDataAdapter mda;
DataSet ds;
mda = new MySqlDataAdapter("select * from formula_for_show", mysql);
ds = new DataSet();
mda.Fill(ds, "st"); //这句话很重要,它会把你在DataSet增加的数据转化为SQL语句用来更新数据库
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["展示"].ToString() == "0")
{
table.Columns.Remove(ds.Tables[0].Rows[i]["材质"].ToString());
//Console.WriteLine(table.Columns[i].ColumnName);
}
以上语句不太明白,特别是for循环语句,最好每句都解释下,万分感谢