Administrator

Administrator

  • Tech Writer
  • 2.2k
  • 1.5m

SQL and C# ???

Apr 7 2003 8:57 PM
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?????

Answers (3)