VB.NET different format date insert into SQL Server
<p>I want to insert data into SQL Server, but I have different format in datagridview data from is "dd/mm/yyyy" and after I see in my SQL Server format is "yyyy/mm/dd" that why I can't use where for update data.</p>

<p>In my SQL Server, the datatype is <code>Date</code>, and in my insert query </p>

<pre><code> cmd.Parameters.AddWithValue("@Date", Convert.ToDateTime(row.Cells("Date").Value))
</code></pre>

<p><a href="http://i.stack.imgur.com/cz9ms.png" rel="nofollow">vb format</a> , <a href="http://i.stack.imgur.com/SjIXK.png" rel="nofollow">sql format</a></p>