title: Sql query for two select statement
body: <pre><code>DateTime startDate = DateTime.ParseExact(txtstart.Text, "MM/dd/yyyy", null);
  DateTime endDate = DateTime.ParseExact(txtend.Text, "MM/dd/yyyy", null);
  
  string n1 = DropDownList2.SelectedItem.Text;
         if (DropDownList1.SelectedItem.Text == "Membership")// here you can add selectedindex as well
          {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ProjectConnectionString"].ToString());
            con.Open();
            SqlDataAdapter adapter = new SqlDataAdapter("select * from Membership_det where updateDate  between @Start and @End and FID ="+n1+"", con);
            adapter.SelectCommand.Parameters.Add("@Start", SqlDbType.Date).Value = startDate;
            adapter.SelectCommand.Parameters.Add("@End", SqlDbType.Date).Value = endDate;
          }
  </code></pre>
  
  <p>……..
  ……..
  Above is a part of a code to display the data in the grid view.I am displaying * from Membership_det and also need to display faculty name from other table…how to add the query with the above query..displaying * from membership _det table  and faculty name from other table</p>
  
  <pre><code>FID MembNo  MembType    Validity    Remarks UpdateDate
  100 23  basn    6   dgag    9/5/2013 12:00:00 AM
  200 566 basn    6   adhu    9/6/2013 12:00:00 AM
  </code></pre>
  
  <p>In this table i need to add Faculty name..it should be fetched from other table..</p>