protected void Page_Load(object sender, EventArgs e)
{
string connetionString;
SqlConnection cnn;
connetionString = WebConfigurationManager.ConnectionStrings["constr"].ConnectionString;
cnn = new SqlConnection(connetionString);
cnn.Open();
int vw_id = Convert.ToInt32(Session["ids"]);
String sql1 = "Select original_content_id,date,text FROM Comment WHERE Viewer_id=" + "'" + vw_id + "'";
SqlDataAdapter sda1 = new SqlDataAdapter(sql1, cnn);
DataTable t1 = new DataTable();
sda1.Fill(t1);
Table1.DataSource = t1;
Table1.DataBind();
String sql2 = "Select C.*,O.rating From Original_Content O INNER JOIN Content C ON O.ID=C.ID";
SqlDataAdapter sda2 = new SqlDataAdapter(sql2, cnn);
DataTable t2 = new DataTable();
sda2.Fill(t2);
Table2.DataSource = t2;
Table2.DataBind();
cnn.Close();
}
private void LoadTableDemo()
{
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Age", typeof(string));
for (int i = 0; i < 3; i++)
{
int id = i + 1;
DataRow row = dt.NewRow();
row["Id"] = id;
row["Name"] = "Name " + id;
row["Age"] = id * 10;
dt.Rows.Add(row);
}
Table1.DataSource = dt;
Table1.DataBind();
Table2.DataSource = dt;
Table2.DataBind();
Table3.DataSource = dt;
Table3.DataBind();
Table4.DataSource = dt;
Table4.DataBind();
Table5.DataSource = dt;
Table5.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string connetionString;
SqlConnection cnn;
connetionString = WebConfigurationManager.ConnectionStrings["constr"].ConnectionString;
cnn = new SqlConnection(connetionString);
cnn.Open();
String sql = "Select C.ID,U.first_name, U.middle_name, U.last_name,C.years_of_experience,C.portifolio_link,C.specialization From Contributor C INNER JOIN [User] U ON C.ID=U.ID";
SqlDataAdapter sda = new SqlDataAdapter(sql, cnn);
DataTable t2 = new DataTable();
sda.Fill(t2);
Table2.DataSource = t2;
Table2.DataBind();
cnn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
string connetionString;
SqlConnection cnn;
connetionString = WebConfigurationManager.ConnectionStrings["constr"].ConnectionString;
cnn = new SqlConnection(connetionString);
cnn.Open();
int vw_id = Convert.ToInt32(Session["ids"]);
String sql1 = "Select id,description,location FROM Advertisement WHERE Viewer_id=" + "'" + vw_id + "'";
SqlDataAdapter sda1 = new SqlDataAdapter(sql1, cnn);
DataTable t1 = new DataTable();
sda1.Fill(t1);
Table2.DataSource = t1;
Table2.DataBind();
cnn.Close();
}
public void buttonSClicked(object sender, EventArgs args)
{
string contributername;
contributername = contributer_name.Text;
string connetionString;
SqlConnection cnn;
connetionString = WebConfigurationManager.ConnectionStrings["constr"].ConnectionString;
cnn = new SqlConnection(connetionString);
cnn.Open();
// SqlCommand cmd = new SqlCommand("Contributor_Search", cnn);
SqlDataAdapter c1 = new SqlDataAdapter("Contributor_Search", cnn);
c1.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("@fullname", contributername));
//SqlDataReader rd;
//rd = cmd.ExecuteReader();
//cmd.Parameters.Add(new SqlParameter("@fullname", contributername));
c1.SelectCommand.Parameters.Add(new SqlParameter("@fullname", contributername));
DataTable tab = new DataTable();
c1.Fill(tab);
Table2.DataSource = tab;
Table2.DataBind();
//rd.Close();
cnn.Close();
}
