{"id":1895,"date":"2012-01-16T18:52:08","date_gmt":"2012-01-16T22:52:08","guid":{"rendered":"http:\/\/www.iowawebnet.com\/ein\/?p=1895"},"modified":"2012-01-16T18:53:01","modified_gmt":"2012-01-16T22:53:01","slug":"vb-net-sql-statement-like","status":"publish","type":"post","link":"https:\/\/www.iowawebnet.com\/ein\/2012\/01\/vb-net-sql-statement-like\/","title":{"rendered":"VB.NET &#8211; SQL statement &#8220;LIKE&#8221;"},"content":{"rendered":"<pre>\r\nInput box\r\n<code>\r\nPlease enter customer first or last name:<br \/>\r\n&lt;asp:RequiredFieldValidator ID=\"ReqSearchfor\" runat=\"server\" \r\n    ErrorMessage=\"&lt;font color='red'>Input box can not be empty!<br \/>&lt;\/font>\" \r\n    ControlToValidate=\"SearchFor\" >\r\n&lt;asp:TextBox ID=\"SearchFor\" runat=\"server\">\r\n&lt;asp:Button ID=\"SearchBtn\" runat=\"server\" Text=\"Search\" \/>\r\n<\/code>\r\n<\/pre>\n<pre>\r\nSQL DataSource Design\r\n<code>\r\n&lt;asp:SqlDataSource ID=\"SearchResults\" \r\n        runat=\"server\" ConnectionString=\"< %$ myConString %>\" \r\n        SelectCommand=\"SELECT * FROM [CustomerTbl] WHERE \r\n                      ([customer_name] <strong>LIKE '%' + @customer_name + '%'<\/strong>)\" \r\n        &lt;SelectParameters>\r\n             &lt;asp:ControlParameter ControlID=\"SearchFor\" Name=\"customer_name\" \r\n                 PropertyName=\"Text\" Type=\"String\" \/>\r\n        &lt;\/SelectParameters>  \r\n&lt;\/asp:SqlDataSource>\r\n<\/code>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Input box Please enter customer first or last name: &lt;asp:RequiredFieldValidator ID=&#8221;ReqSearchfor&#8221; runat=&#8221;server&#8221; ErrorMessage=&#8221;&lt;font color=&#8217;red&#8217;>Input box can not be empty!&lt;\/font>&#8221; ControlToValidate=&#8221;SearchFor&#8221; > &lt;asp:TextBox ID=&#8221;SearchFor&#8221; runat=&#8221;server&#8221;> &lt;asp:Button ID=&#8221;SearchBtn&#8221; runat=&#8221;server&#8221; Text=&#8221;Search&#8221; \/> SQL DataSource Design &lt;asp:SqlDataSource ID=&#8221;SearchResults&#8221; runat=&#8221;server&#8221; ConnectionString=&#8221;< %$ myConString %>&#8221; SelectCommand=&#8221;SELECT * FROM [CustomerTbl] WHERE ([customer_name] LIKE &#8216;%&#8217; + @customer_name + &#8216;%&#8217;)&#8221; &lt;SelectParameters> &lt;asp:ControlParameter ControlID=&#8221;SearchFor&#8221; Name=&#8221;customer_name&#8221; [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,17,16,67],"tags":[30,19,27,61,146],"class_list":["post-1895","post","type-post","status-publish","format-standard","hentry","category-access","category-applications","category-net","category-sql","tag-access-2","tag-asp-net","tag-form-validation","tag-select","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/1895"}],"collection":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/comments?post=1895"}],"version-history":[{"count":12,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/1895\/revisions"}],"predecessor-version":[{"id":1908,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/1895\/revisions\/1908"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=1895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=1895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=1895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}