public void ListPosts()
{
dataGridView1.Columns[0].Visible = true;
dataGridView1.Columns[1].Visible = true;
dataGridView1.Columns[2].Visible = true;
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
var List = Con.Query("SELECT post_author, post_title, post_content,post_name FROM wp_posts");
dataGridView1.RowCount = List.Length;
for (int i = 0; i < List.Length; i++)
{
var List1 = Con.Query("SELECT user_nicename FROM wp_users WHERE ID=" + List[i].ItemArray[0]);
try
{
dataGridView1[0, i].Value = List1[0].ItemArray[0].ToString();
dataGridView1[1, i].Value = List[i].ItemArray[1];
dataGridView1[2, i].Value = List[i].ItemArray[2];
}
catch { }
}
}
