Using system; using system.data.sqlclient; using system.timers; using system.collections; using system.collections.specialize;
using System.IO; using System.Web; using System.Web.UI; using System.Web.Caching; using System.Configuration; using System.Text; using System.Text.RegularExpressions; using System.Web.UI.WebControls;
Summary description of Namespace C1 {///
// Get the table public static datatable gettable (String Sqlstring) {// The content in the web.config file is shown below //
SqlConnection db = new SqlConnection (mydb.ConnectionString); SqlDataAdapter dp = new SqlDataAdapter ( "select * from subject", db); DataSet ds = new DataSet (); dp.Fill (ds, "table0"); return ds.Tables [0];
// Data Connection Public Static String Connectionstring {Get {Return ConfigurationSettings.AppSettings ["Connectionstring"];}}}}
