Posted on: 5/15/2014 9:19:19 AM | Views : 229

Dear all, 
I am writing to seek help, in how I can  display weekly data (query) as the page loads but filter results using the enitre database query (whole), from the following code below. 
//weekly data query string cmdstr = "select Name, [price],Cover, UploadDate from [dbo].[database_data] where UploadDate = @value"; cmd.Parameters.AddWithValue("@value", yesterday); //entire data query string cmdstr = "select Name, [price],Cover, UploadDate from [dbo].[database_data]";
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { JavaScriptSerializer jss = new JavaScriptSerializer(); ClientScript.RegisterStartupScript(this.GetType(), "TestInitPageScript", string.Format("<script type=\"text/javascript\">google.load('visualization','1.0',{ ...

Go to the complete details ...