SQL and C# ???

Here is a complete data selection and binding:- string sConString = "data source=IZDEV-TEAM;initial catalog=Datenbank;packet size=4096; string sData = "SELECT id, Description, Images from MediaStyle ORDER BY Description"; // specify SQL Server-specific connection string SqlConnection ADMConnection = new SqlConnection(sConString); // Create command for ADM connection SqlCommand ADMCommand = new SqlCommand(sData, ADMConnection); ADMCommand.Connection.Open(); // execute DataReader for specified command SqlDataReader ADMReader = ADMCommand.ExecuteReader(CommandBehavior.CloseConnection); // while there are rows to read while (ADMReader.Read()) { if((bool) ADMReader["Images"]) // This places the desired data into a class called "Styles". aStyles.Add(new Styles((int) ADMReader["id"], ADMReader["Description"].ToString())); } // Now bind the data to the Dropdown list. cboStyle.DataSource = aStyles; cboStyle.DataBind(); // close reader ADMReader.Close(); // close connection ADMConnection.Close(); Good luck with it.

Hi, I've managed to do that sort of thing without any issues....just a few thoughts: - have you run a trace on SqlServer to see what it is sending back to you? - have you tried catching any exceptions to see if something is wrong at your side? - you are doing ExecuteNonQuery...where are you expecting the results to be retrieved from? I have been using the MS SqlHelper application block for a while now, it's at least removed the chance of me making a code error in my DB connection....may be worth looking at. Regards, Liam

Hi, Just a couple of questions to understand your problem: 1. What are you getting from the database? 2. What do you bind you grid to? Mike