Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- #1
- SELECT * FROM my_table
- WHERE CONTAINS(my_column, 'monkey')
- -- #2
- SELECT * FROM my_table
- WHERE CONTAINS(my_column, 'a OR monkey') -- "a" is a noise word
- using (SqlConnection conn = new SqlConnection(...))
- {
- SqlCommand cmd = conn.CreateCommand();
- // setup the command object...
- conn.Open();
- using (SqlDataReader dr = cmd.ExecuteReader())
- {
- if (dr.HasRows)
- {
- // get column ordinals etc...
- while (dr.Read())
- {
- // do something useful...
- }
- }
- }
- }
- bool readerHasRows=false;
- while(reader.reader())
- {
- readerHasRows=true;
- doStuffOverAndOver();
- }
- if (!readerHasRows)
- {
- probablyBetterShowAnErrorMessageThen();
- }
- using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleResult))
Add Comment
Please, Sign In to add comment