How can i Select from two different tables in one code?
<p>I'm using two times sqlreader cause i have to select from two different tables how can i do this with one code?Here is my code:</p>

<p>First Sqlreader:</p>

<pre><code> SqlCommand sqlCmd = new SqlCommand("SELECT Name from Customers where name = '"+textview2.Text+"'", con);
        SqlDataReader sqlReader = sqlCmd.ExecuteReader();

        while (sqlReader.Read())
        {
            textview1.Text = (sqlReader["Name"].ToString());


        }
        sqlReader.Close();
</code></pre>

<p>Second Read:</p>

<pre><code>SqlCommand cmd = new SqlCommand("Select Mobile from Informations where Mobile = '"+textview3.Text+"'", con);
        SqlDataReader sqlReader2 = cmd.ExecuteReader();
        while (sqlReader2.Read())
        {
            textview4.Text = (sqlReader2["Mobile"].ToString());
        }

        sqlReader2.Close();
</code></pre>

<p>I want to create one code instead of two.</p>