Sunday, 11 December 2011

data for dropdown and listbox

public DataSet PopulateControls()
{
    SqlConnection myConnection = new SqlConnection(con);
    SqlDataAdapter ad = new SqlDataAdapter("SELECT [department] FROM department",
                                                            myConnection);
    DataSet ds = new DataSet();
    ad.Fill(ds, "department");
    return ds;
}
public DataSet PopulateControlslist()
{
    SqlConnection myConnection = new SqlConnection(con);
    SqlDataAdapter ad = new SqlDataAdapter("SELECT [projectname] FROM projects",
                                                            myConnection);
    DataSet ds = new DataSet();
    ad.Fill(ds, "projects");
    return ds;
}
       

No comments:

Post a Comment