protected void Page_Load(object sender, EventArgs e)
{
/*
* String sqlStatement = "select Id AS 'Company Order', CompanyName AS 'Company Name', HttpAddress AS 'URL', ";
* sqlStatement += "NumberOfUser AS 'Number Of User' , CompanyValue AS 'Company Value (million dollars)', ";
* sqlStatement += "CONVERT(VARCHAR(10), LaunchedDate, 103) AS 'Launched Date (DD/MM/YYYY)' from Companies ";
* sqlStatement += "order by Id";
*
* loadGridView(sqlStatement);
*/
CompaniesView.DataSource = null;
CompaniesView.DataBind();
}
protected void loadGridView(String sqlStatement)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\SocialNetworks.mdf;Integrated Security=True");
SqlCommand cmd = new SqlCommand(sqlStatement, con);
con.Open();
SqlDataReader wan = cmd.ExecuteReader();
CompaniesView.DataSource = wan;
CompaniesView.DataBind();
con.Close();
}