title: Asp.Net datetime SQL parameter
body: <p>I'am selecting some data from SQL table.Table has a column  which type of datetime (SQL type).</p>
  
  <p>Stored procedure is using this </p>
  
  <pre><code> where CONVERT(varchar(10),post_tarihi,105)=@post_tarihi(event_date)
  </code></pre>
  
  <p>I have a method has a parameter which type of string (Asp.net type)</p>
  
  <pre><code> &lt;asp:ControlParameter  ControlID="txtDate" Name="post_tarihi" DefaultValue="13-11-2013"  PropertyName="Text" Type="String"/&gt;
  </code></pre>
  
  <p>When I execute sp from sql managment studio,returns some results
  But when I run asp.net application returns nothing.
  Is there a problem about type ?</p>
  
  <p>if you ask "why you used textbox fot date",I used because using datepicker(jquery)</p>