Retrive Data and Display in GridView

Following Method Retrieves the Table data and Display in GridView.

Call the Following Method in any Event which is Desired and Pass the Required Parameters.

public void FillGrid( System.Windows.Forms.DataGridView dgv , string TableName, string DisplayMember, string ValueMember, Boolean orderby, string orderfield )
{

      DataSet ds = new DataSet();
      DataTable dt = new DataTable(TableName);
      OleDbDataAdapter ad = default(OleDbDataAdapter);

      if (orderby == true)
      {
   ad = new OleDbDataAdapter("Select " + ValueMember + "," + DisplayMember + " From [" + TableName + "] ORDER BY " + orderfield, conn);
      }
      else
      {
            ad = new OleDbDataAdapter("Select " + ValueMember + "," + DisplayMember + " From [" + TableName + "]", conn);
      }
      ad.Fill(ds, TableName);
      dgv.DataSource = ds.Tables[TableName];
      dgv.DataMember = ds.Tables[TableName].ToString ();
}