コード例 #1
0
    protected void Button1_Click1(object sender, EventArgs e)
    {
        hostelop h  = new hostelop();
        DataSet  ds = h.dbselect(Places.Text);

        ShowData.DataSource = ds;
        ShowData.DataMember = "hostel";
        ShowData.DataBind();
    }
コード例 #2
0
        protected void BindTable()
        {
            String CS = ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString;

            using (SqlConnection con = new SqlConnection(CS))
            {
                using (SqlCommand cmd = new SqlCommand("select * from tbl_fitness_check", con))
                {
                    using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                    {
                        DataTable dt = new DataTable();
                        sda.Fill(dt);
                        ShowData.DataSource = dt;
                        ShowData.DataBind();
                    }
                }
            }
        }