在C#中用SQL传变量

 

        string con = "Data Source=.\\SqlExpress;Initial Catalog=Web;Integrated Security=True";
        SqlConnection Connection = new SqlConnection(con);
        Connection.Open();
        SqlCommand cmd = new SqlCommand("select admin from Tb_Admin where Admin='sunfor'", Connection);
        string user=Convert.ToString( cmd.ExecuteScalar()).Trim();
        Connection.Close();

        DataClassesDataContext DC = new DataClassesDataContext();
        var query = from Tb_Admin a in DC.Tb_Admin select new { a.AdminID, a.Admin, a.Password };
        GridView1.DataSource = query;
        GridView1.DataBind();

        string aa;
        aa = Convert.ToString(GridView1.Rows[2].Cells[1].Text);
        Label4.Text = user;