DataGridView Column Format not display data in DataGridView

[lenniekuah]

Hi Fellow Good Guys,

I need your help, Please Help me.

Surprising I encounterd another problem which never happened in VB.NET but in C# technique it causing problem.

Here is the explanation :
For testing purposes, Extract data from SQL SERVER NorthWind table Products to display ProductName and UnitPrice on DataGridView and also trying to have specific DataGridView ccolumn format to suit user requirements but it's not working.

Here are the coding:

I have tried both but it doesn't display anything::

 [B]private void FLoadDataGridViewProductDetails()[/B]
   {
      string strSql = "Select  ProductName ,  "
                          + " convert(numeric(10,2), UnitPrice ) as UnitPrice "
                          + " From Products  " 
                          + " Order by ProductName ";
           
        sqlconn = new SqlConnection(connstr);
        sqlconn.Open();
        sqlDA = new SqlDataAdapter(strSql, sqlconn);
        sqlDS = new DataSet();
        sqlDS.Clear();

        sqlDA.Fill(sqlDS, "Prod");
        this.DGVProduct.DataSource = sqlDS.Tables["Prod"];

 [B]  //Format datagrid column[/B]
         FFormatDGVProductColumn();   <----- not working 

          this.DGVProduct.ClearSelection();
          this.DGVProduct.MultiSelect = false;
          this.DGVProduct.ReadOnly = true;
          sqlconn.Close();            
 }  ]

------------------------------------------


// Format specific DataGridView1 columns

 [B] private void FFormatProductDGVColumn()[/B]  
   // format datagridview column
    {
       DataGridTableStyle DGVStyle = new DataGridTableStyle();
       DGVStyle.MappingName = "Prod";

 [B] // initialise column to refresh[/B] 
      this.DGVOrderDetails.Columns.Clear();
      this.DGVOrderDetails.AutoGenerateColumns = false;
      this.DGVOrderDetails.AutoSize = false;

 [B] // create and format column[/B] 
            
[B]//ProductName column[/B] 
      DataGridTextBoxColumn colProductName = new DataGridTextBoxColumn();
      colProductName.MappingName = "ProductName";
      colProductName.HeaderText = "Product Name";
      colProductName.Width = 250;
     DGVStyle.GridColumnStyles.Add(colProductName);
             
[B] // UnitPrice Column[/B]
     DataGridTextBoxColumn colUnitPrice = new DataGridTextBoxColumn();
     colUnitPrice.MappingName = "UnitPrice";
     colUnitPrice.HeaderText = "Unit Price";
     colUnitPrice.Width = 90;
     DGVStyle.GridColumnStyles.Add(colUnitPrice);                          
 }