How to compare a dataBase value to retrieve data

Question

          

                string SearchWord = "SELECT FileNames FROM  Notices WHERE Notices.DocType = @WordDocument";
                cmd.CommandText = SearchDoc;
                SqlParameter param = new SqlParameter();
                param.ParameterName = "@WordDocument";
                param.Value = System.Data.SqlDbType.VarChar, 50,"Word2003 Document"; //How to define that it has to look on the value in the database?             

               //Word2003 Document is a value in the database.

Answer 1

Not sure what you mean here. 
 
Check your variable names, first.  SearchWord != SearchDoc here.

That last line should simply read:

param.Value = "Word2003 Document";

Then add one line after it..

cmd.Parameters.Add(param);

That's it.

---

Coding Light - Illuminated Ideas and Algorithms in Software
Coding Light Wiki • LinkedIn • ForumsBrowser

Answer 2

Just this is what I was looking for.

thx