C#

MyDataTable = New DataTable ();
SqlConnect con = new SqlConnection ("connection string goes here ") ;
SqlDataAdapter SqlDa = new SqlDataAdapter ("SELECT * FROM myTable", conn);
SqlDa.Fill(myDataTable);

foreach ( DataRow dr in MyDataTable.Rows)
{
     dr["ColumnName"] = dr["ColumnName"].toString().Trim();
}

var NameList = (from param_enum_desc in dsPartnertype.Tables[0].AsEnumerable()
                        select new
                        {
                            POS_VALUE = param_enum_desc.Field<string>("POS_VALUE"),
                            POS_DESCR = param_enum_desc.Field<string>("POS_DESCR")
                        });

        stoPartner.DataSource = NameList;
        stoPartner.DataBind();

var NameList = (from param_enum_desc in dsPartnertype.Tables[0].AsEnumerable()
                        select new
                        {
                            POS_VALUE = param_enum_desc.Field<string>("POS_VALUE").Trim(),
                            POS_DESCR = param_enum_desc.Field<string>("POS_DESCR").Trim()
                        });

        stoPartner.DataSource = NameList;
        stoPartner.DataBind();

kienhv_87 wrote:

Hope every body guide to me!