title: Bind grid view data from existing code, current date
body: <p>I want to using the code below and display in GridView.
  The situation is, when user click on GET CURRENT DATE TRANS, GridView will display the today date as the result. I already insert the GridView id as GridView1</p>
  
  <pre><code>string connetionString = null;
          SqlConnection connection;
          SqlCommand command;
          string sql = null;
  
          connetionString = "Data Source=AXSQL;Initial Catalog=UniKL;User ID=aten;Password=pass@WORD1";
          sql = "Select * FROM [UniKL].[dbo].[BudgetPlanning_Transaction] WHERE [SubmmitedDateTime] = cast(getdate() as date)";
  
          GridView1.DataBind();
  
          connection = new SqlConnection(connetionString);
  
          connection.Open();
          command = new SqlCommand(sql, connection);
          command.ExecuteNonQuery();
          command.Dispose();
          connection.Close();  
  </code></pre>