Friday, September 7, 2018

All data table connect in listbox dynamic

           Dynamic  database connectivity



           string cs1 = ConfigurationManager.AppSettings["key"];
            cn7 = new SqlConnection(cs1);
            cn7.Open();

            string k = "SELECT name FROM sysobjects WHERE xtype='U' ORDER BY name";
            cm7 = new SqlCommand(k, cn7);
            dr7 = cm7.ExecuteReader();
            ListBox1.DataSource = dr7;
            ListBox1.DataTextField = "name";
            ListBox1.DataBind();
            ListBox1.Items.Insert(0, "Select");


   

No comments:

Post a Comment

ADVANCE 2025

 HTML TABLE SCROLL BAR  <style>      .table-container {             width: 100%;             overflow-x: auto; /* Enables horizontal s...