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

GRIDVIEW ON ROW DATA BOUND EVENT

 Database Create  Student : roll , name , city , cost  Fix 6 Value  in Database Record  ====================================================...