ASP.NET

SELECT table1.*,table2.* <br />
FROM table1, table2<br />
WHERE table1.column = value<br />
AND table1.id = table2.id

SqlConnection c = new SqlConnection(//connectionstring);<br />
c.Open();<br />
DataSet ds = new DataSet();<br />
string sel = " SELECT schauditor_employee "+<br />
" FROM scheduleauditor , schedule "+<br />
" WHERE schedule_no = 1 "+<br />
" AND schauditor_schedule = schedule_no ";<br />
SqlDataAdapter da = new SqlDataAdapter(sel,c);<br />
da.Fill(ds);<br />
//u said sql query return two rows and u want to get values in variables<br />
string value1 = ds.tables[0].Rows[0][//specify index of column by index  or string name].ToString();<br />
string value2 = ds.tables[0].Rows[1][//specify index of column by index  or string name].ToString();<br />
c.Close();

<br />
res = confirm('do something?');<br />
if (res)<br />
{<br />
  document.getElementById('MyASPNETButton').click();<br />
}<br />