Friday, February 20, 2009

How to send SQL parameters to sqlDataAdapter?


DataAdapter.SelectCommand.Parameters
.Add(New SqlParameter("@SomeParameter", someValue))

or
DataAdapter.SelectCommand.Parameters.Add("@SomeParameter", SqlDbType.NChar);
DataAdapter.SelectCommand.Parameters[0].Value = SomeParameter;

No comments:

Post a Comment