Deu certo.
Quem quiser a solução.
public frmAgendamento()
{
InitializeComponent();
string strCon = @"Data Source = PC - BRANDAO\BRUNO; Initial Catalog = loja; Integrated Security = True";
dateAgenda.ValueChanged += new EventHandler(btnConsulta_Click);
}
SqlConnection sql = new SqlConnection(Conexao.getConexao());
private void btnConsulta_Click(object sender, EventArgs e)
{
var data = dateAgenda.Value.Date;
sql.Open();
SqlCommand sqlCommand = sql.CreateCommand();
sqlCommand.CommandText = ("SELECT * FROM agenda WHERE convert(date, DataAgendamento) = @DataAgendamento");
SqlParameter parameterdata = new SqlParameter()
{
ParameterName = "@DataAgendamento",
SqlDbType = SqlDbType.Date,
Direction = ParameterDirection.Input,
Value = data
};
sqlCommand.Parameters.Add(parameterdata);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
sqlCommand.ExecuteNonQuery();
dgvAgenda.DataSource = dataTable;
sql.Close();
}
