I am writting a c# code in asp.net for dropdown lists.
as follows:

public void function1()
{

SqlCommand cmd;
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter( );

cmd = new SqlCommand("Sel ect distinct client_name from client_list", cn);

ad.SelectComman d = cmd;
ad.Fill(ds,...