SQL and C# ???

Question

This nice little code works fine in an SQL Query; however C# doesn't seem to like it. It makes my datagrid go wacko while performing this database column, full-text search, on a MS 2000 Server w/ MS SQL Server 2000. Help... SELECT Subject FROM sermons WHERE CONTAINS (Subject, 'mp3') In C# it's like this... sqlConnection1.Open(); sqlDataAdapter1.SelectCommand.CommandText = "SELECT Subject FROM sermons WHERE CONTAINS (Subject, 'mp3') ; sqlDataAdapter1.SelectCommand.ExecuteNonQuery(); sqlConnection1.Close(); BindGrid(); Any idea about this one?????

Administrator · Answer

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.

Administrator · Answer

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

Administrator · Answer

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