protected void submitsearch_Click(object sender, EventArgs e)
{
//remove unwanted chars
Utility util = new Utility();
string srch1 = util.CleanInput(search1.Text);
string srch2 = util.CleanInput(search2.Text);
//search twitter
MyTwitterObj MyTwitter = new MyTwitterObj();
MyTwitter.search_1 = srch1;
MyTwitter.search_2 = srch2;
Twitter twitter = new Twitter();
MyTwitter = twitter.GetData(MyTwitter);
//store in DB
DBInteractions DBI = new DBInteractions();
DBI.StoreInDB(search1.Text, MyTwitter.tweets_1, search2.Text, MyTwitter.tweets_2, MyTwitter.seconds_1, MyTwitter.seconds_2);
//go to next page
HttpContext CurrContext = HttpContext.Current;
CurrContext.Items.Add("srch1", search1.Text);
CurrContext.Items.Add("srch2", search2.Text);
CurrContext.Items.Add("tweets1", MyTwitter.tweets_1);
CurrContext.Items.Add("tweets2", MyTwitter.tweets_2);
CurrContext.Items.Add("seconds1", MyTwitter.seconds_1);
CurrContext.Items.Add("seconds2", MyTwitter.seconds_2);
Server.Transfer("Results.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
//Populating a DataTable from database.
DBInteractions DBI = new DBInteractions();
DataTable dt = DBI.GetData();
//Building an HTML string.
StringBuilder html = new StringBuilder();
//Table start.
html.Append("<table border = '1'>");
//Building the Header row.
html.Append("<tr>");
foreach (DataColumn column in dt.Columns)
{
html.Append("<th>");
html.Append(column.ColumnName);
html.Append("</th>");
}
html.Append("</tr>");
//Building the Data rows.
foreach (DataRow row in dt.Rows)
{
html.Append("<tr>");
foreach (DataColumn column in dt.Columns)
{
html.Append("<td>");
html.Append(row[column.ColumnName]);
html.Append("</td>");
}
html.Append("</tr>");
}
//Table end.
html.Append("</table>");
//Append the HTML string to Placeholder.
PlaceHolder1.Controls.Add(new Literal {
Text = html.ToString()
});
}
}
