hi...
i have the following code which retrives all duplicate values into my dropdownlist(ddl) but i want the distinct values
if (dtTmp.Rows.Count > 0)
{
if (dtTmp.Columns.Contains(tc.Text))
{
ddl.DataSource = dtTmp.DefaultView.
ddl.DataTextField = tc.Text;
ddl.DataValueField = tc.Text;
ddl.DataBind();
}
}
dtTmp is my datatable where i get the datafrom stored procedure pls tell we how to get distinct values to my dropdown