Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to put value in parameters in mysqldataadapter

da = new SqlDataAdapter("SELECT * FROM annotations WHERE annotation LIKE @search",
                        _mssqlCon.connection);
da.SelectCommand.Parameters.AddWithValue("@search","%" + txtSearch.Text + "%");
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #put #parameters #mysqldataadapter
ADD COMMENT
Topic
Name
5+7 =