同时执行多条sql语句提高性能

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class test : System.Web.UI.Page
{
    protected override void OnLoad(EventArgs e)
    {
        //using (SqlConnection sqlcon=new SqlConnection ("Data Source=.;Initial Catalog=mytest;Integrated Security=True"))
        //{
        //    sqlcon.Open();
        //    SqlCommand sqlcmd = new SqlCommand("pro_insertStu", sqlcon);
        //    sqlcmd.CommandType = CommandType.StoredProcedure;
        //    SqlCommandBuilder.DeriveParameters(sqlcmd);
        //    sqlcmd.Parameters.RemoveAt(0);
        //    sqlcmd.Parameters[0].Value = "软件中国";
        //    sqlcmd.Parameters[1].Value = "cccccc";
        //    SqlDataAdapter sdar = new SqlDataAdapter(sqlcmd);
        //    DataSet ds = new DataSet();
        //    sdar.Fill(ds);
        //    Response.Write(ds.Tables[0].Rows[0][0].ToString()+"<br/>");//第一个结果集的数据
        //    Response.Write(ds.Tables[1].Rows[0][0].ToString() + "<br/>");//第二个结果集的数据
        //    Response.Write(ds.Tables[3].Rows[0][1].ToString());//第四个结果集的数据
        //}
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        using (SqlConnection sqlcon = new SqlConnection("Data Source=.;Initial Catalog=mytest;Integrated Security=True"))
        {
            sqlcon.Open();
            SqlCommand sqlcmd = new SqlCommand("select *from StuInfo;select * from  t2", sqlcon);
            //sqlcmd.CommandType = CommandType.StoredProcedure;
            //SqlCommandBuilder.DeriveParameters(sqlcmd);
            //sqlcmd.Parameters.RemoveAt(0);
            //sqlcmd.Parameters[0].Value = "软件中国";
            //sqlcmd.Parameters[1].Value = "cccccc";
            SqlDataAdapter sdar = new SqlDataAdapter(sqlcmd);
            DataSet ds = new DataSet();
            sdar.Fill(ds);
            Response.Write(ds.Tables[0].Rows[0][2].ToString() + "<br/>");//第一个结果集的数据
            Response.Write(ds.Tables[1].Rows[0][1].ToString() + "<br/>");//第二个结果集的数据
            //Response.Write(ds.Tables[3].Rows[0][1].ToString());//第四个结果集的数据
        }

    }
}