public DataTable GetData() { string connectionString = System.Web.HttpContext.Current.Application["solarsearch_dbConnectionString"].ToString(); SqlConnection commandString = new SqlConnection(connectionString); commandString.Open(); string SQL = "select * from enquiry"; SqlCommand objCommand = new SqlCommand(SQL, commandString); SqlDataAdapter adapter = new SqlDataAdapter(); DataSet DS = new DataSet(); adapter.SelectCommand = objCommand; adapter.Fill(DS); DataTable dt = DS.Tables[0]; return dt; }
string connectionString = System.Web.HttpContext.Current.Application["solarsearch_dbConnectionString"].ToString();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)