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(); }