نیاز به کمک برای بررسی کد sql

[yuttrim20]

این کد چرا کار نمی کنه؟

public partial class NewFolder1_ادامه_سانس : System.Web.UI.Page

{

    SqlCommand cmd = new SqlCommand();

    SqlDataAdapter ad = new SqlDataAdapter();

    DataSet ds = new DataSet();

    SqlConnection con = new SqlConnection();



    public void connect()

    {

        SqlConnection con = new SqlConnection("data source=ZEGOND-PC;initial catalog=sinama;integrated security=true; ");





    }



    protected void Page_Load(object sender, EventArgs e)

    {



    }

    protected void Button3_Click(object sender, EventArgs e)

    {

        cmd.CommandText = "select id from sans";

        cmd.Connection = con;

        ad.SelectCommand = cmd;

        con.Open();

        SqlDataReader dr = cmd.ExecuteReader();



        TextBox1.Text = (String.Format("{1}",dr[1]));

        con.Close();

    }