title: How to pass property value in SqlDataSource selectCommand where conditon?
body: <p>I have a property in my page2.aspx.cs page</p>
  
  <pre><code>public int? Id
  {
          get
          {
              if (ViewState[Page1.Id] != null)
                  return Convert.ToInt32(ViewState[Page1.Id]);
              else return null;
          }
          set
          {
              ViewState[Id] = value;
          }
      }
  </code></pre>
  
  <p>and I am using asp: data sourse:</p>
  
  <pre><code>&lt;asp:SqlDataSource ID="SqlDataSourceGridView" runat="server" 
     ProviderName="System.Data.SqlClient" 
     SelectCommand="SELECT [Name],[Address] FROM [Table_Emp] where Id = need to pass property value &gt;" 
     OnSelecting="SqlDataSourceGridView_Selecting"&gt;
  &lt;/asp:SqlDataSource&gt;
  </code></pre>
  
  <p>I want to pass Id in my where condition. how is it possible.</p>
  
  <p>Please some one help me.  </p>