public void BindProdGrid()
        {
            SqlConnection  con     = new SqlConnection(connection);
            SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM prod_table", connection);
            DataSet        dataSet = new DataSet();

            adapter.Fill(dataSet);
            GridProd.DataSource = dataSet;
            GridProd.DataBind();
        }
 private void carregarGrid()
 {
     GridProd.DataSource = Prod.retornarListaProd();
     GridProd.DataBind();
 }