Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected void Page_Load(object sender, EventArgs e)
- {
- string connStr = ConfigurationManager.ConnectionStrings["iWork"].ToString();
- SqlConnection conn = new SqlConnection(connStr);
- SqlCommand cmd = new SqlCommand("AvailableCompanies", conn);
- cmd.CommandType = CommandType.StoredProcedure;
- conn.Open();
- SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
- while (rdr.Read())
- {
- string companyName = rdr.GetString(rdr.GetOrdinal("name"));
- string email = rdr.GetString(rdr.GetOrdinal("email"));
- string vision = rdr.GetString(rdr.GetOrdinal("vision"));
- string domain = rdr.GetString(rdr.GetOrdinal("domain_name"));
- string field = rdr.GetString(rdr.GetOrdinal("field_of_specialization"));
- string type = rdr.GetString(rdr.GetOrdinal("type"));
- string address = rdr.GetString(rdr.GetOrdinal("address"));
- LinkButton btn = new LinkButton();
- btn.Click += new EventHandler(company);
- HtmlGenericControl html = new HtmlGenericControl();
- html.InnerHtml = "<div class='list-group'>" +
- "<a href='' runat='server' onServerClick='company' class='list-group-item active'>" +
- "<h4 class='list-group-item-heading'>" + companyName + "</h4>" +
- "<p class='list-group-item-text'><strong>Email: </strong>" + email + "</p>" +
- "<p class='list-group-item-text'><strong>Vision: </strong>" + vision + "</p>" +
- "<p class='list-group-item-text'><strong>Domain: </strong>" + domain + "</p>" +
- "<p class='list-group-item-text'><strong>Field: </strong>" + field + "</p>" +
- "<p class='list-group-item-text'><strong>Type: </strong>" + type + "</p>" +
- "<p class='list-group-item-text'><strong>Address: </strong>" + address + "</p></a>" +
- "</div>"; ;
- btn.Controls.Add(html);
- companies.Controls.Add(btn);
- }
- conn.Close();
- }
Add Comment
Please, Sign In to add comment