C#

<br />
dgvAllData.DataSource = myDataSet;<br />
dgvAllData.DataMember = "ID";<br />

Assaf82 wrote:

from the dataset
if you want the to do the same from the datagrid:

txtUsrName_pca.Text = dtg.Rows[i].Cells["CreditCardOwner"].Value.ToString();

// Cleaner less controll over the dictionary
private Dictionary<<string, double>> innerTable;
private Dictionary<<string, Dictionary<<string, double>>>> outterTable;

public DataAccessLayer()
{
  innerTable = new Dictionary<<string,double>>();
  outterTable = new Dictionary<<string, Dictionary<<string, double>>>>();

  innerTable.Add( "stringKey", 12312.012 );
  outterTable.Add( "anotherStringKey", innerTable );
}

// Longer but you'll define both dictionaries
// and how all the methods work.
public class UsingMyNewCollections
{
  // default constructor
  public UsingMyNewCollections()
  {
    InnerDictionary inner = new InnerDictionary();
    inner.Add( "StringKey", 1213.0123D );


    OutterDictionary outter = new OutterDictionary();
    batchTable.Add( "SomeKeyString", outter );
  }
}

public class OutterDictionary : IDictionary<<string, InnerDictionary>>
{
  // private field for the class
  private Dictionary<<string, InnerDictionary>> m_outterDictionary;

  // default constructor
  public OutterDictionary()
  {
    m_outterDictionary = new Dictionary<<string, InnerDictionary>>();
  }

  public void Add( string key, InnerDictionary value )
  {
    // Validation on passed in values
    // ...

    // Add your value
    m_outterDictionary.Add( key, value );
  }

  #region IDictionary<<string,MyTable>> Members
  // code
  #endregion

  #region ICollection<<KeyValuePair<<string,MyTable>>>> Members
  // code
  #endregion

  #region IEnumerable<<KeyValuePair<<string,MyTable>>>> Members
  // code
  #endregion

  #region IEnumerable Members
  //code
  #endregion
}

public class InnerDictionary : IDictionary<<string, double>>
{
  // private field for the class
  private Dictionary<<string, double>> m_innerDictionary;

  // default constructor
  public InnerDictionary()
  {
    m_innerDictionary = new Dictionary<<string, double>>();
  }

  public void Add( string key, double value )
  {
    // Validation on passed in values
    // ...

    // Add your value
    m_innerDictionary.Add( key, value );
  }

  #region IDictionary<<string,double>> Members
  // code
  #endregion

  #region ICollection<<KeyValuePair<<string,double>>>> Members
  // code
  #endregion

  #region IEnumerable<<KeyValuePair<<string,double>>>> Members
  // code
  #endregion

  #region IEnumerable Members
  // code
  #endregion
}

else if (propertyType.IsEnum)
{
    result = Enum.Parse(propertyType, value);
} // solved

<br />
string conect = ConfigurationManager.ConnectionStrings["CON"].ToString();<br />
SqlConnection conn = new SqlConnection(conect);<br />
SqlDataAdapter da = new SqlDataAdapter ("Select * From MyTable",conn);<br />
DataTable dt = new DataTable();<br />
da.Fill(dt);<br />