I tried egghead.
Not much help.
I am trying to bind the records from the table to a datalist control in C#
private DataSet BindTBCOMMANDTYPE()
{
   OdbcConnection myConnection = new OdbcConnection("DSN=POS;UID=system;PWD=system");

    // Populate the ddlDataSet1
   myConnection.Open();
   const string strSQLDDL = @"SELECT DT_REF, DT_DESCRIPTION FROM TBCOMMANDTYPE ORDER BY DT_REF";
   OdbcDataAdapter myDataAdapter = new OdbcDataAdapter(strSQLDDL, myConnection);
   ddlDataSet1.Clear();
   myDataAdapter.Fill(ddlDataSet1, "ddlDATATYPE");
   DataSet1.DataSource = ddlDataSet1;
   DataSet1.DataBind();
   myDataAdapter.Dispose();
   myDataAdapter = null;
   myConnection.Close();
   return ddlDataSet1;
}

Just need the correct syntax.


http://www.eggheadcafe.com/forums/Fo...=14586&INTID=6


Let's share our knowledge together!!!
[email protected]
Matt Cupryk
514-685-0449

Knowledge is to be shared.

__________________
Knowledge is to be shared.

:)
you need bind the datalist's property databind to table of the your dataset....

Valeu



Costa, Wellerson
[email protected]
BH-MG-Brazil