Guest User

Untitled

a guest
Nov 24th, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.02 KB | None | 0 0
  1. protected void Page_Load(object sender, EventArgs e)
  2. {
  3. string connStr = ConfigurationManager.ConnectionStrings["iWork"].ToString();
  4. SqlConnection conn = new SqlConnection(connStr);
  5.  
  6. SqlCommand cmd = new SqlCommand("AvailableCompanies", conn);
  7. cmd.CommandType = CommandType.StoredProcedure;
  8.  
  9. conn.Open();
  10.  
  11. SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
  12. while (rdr.Read())
  13. {
  14. string companyName = rdr.GetString(rdr.GetOrdinal("name"));
  15. string email = rdr.GetString(rdr.GetOrdinal("email"));
  16. string vision = rdr.GetString(rdr.GetOrdinal("vision"));
  17. string domain = rdr.GetString(rdr.GetOrdinal("domain_name"));
  18. string field = rdr.GetString(rdr.GetOrdinal("field_of_specialization"));
  19. string type = rdr.GetString(rdr.GetOrdinal("type"));
  20. string address = rdr.GetString(rdr.GetOrdinal("address"));
  21.  
  22. LinkButton btn = new LinkButton();
  23. btn.Click += new EventHandler(company);
  24.  
  25. HtmlGenericControl html = new HtmlGenericControl();
  26. html.InnerHtml = "<div class='list-group'>" +
  27. "<a href='' runat='server' onServerClick='company' class='list-group-item active'>" +
  28. "<h4 class='list-group-item-heading'>" + companyName + "</h4>" +
  29. "<p class='list-group-item-text'><strong>Email: </strong>" + email + "</p>" +
  30. "<p class='list-group-item-text'><strong>Vision: </strong>" + vision + "</p>" +
  31. "<p class='list-group-item-text'><strong>Domain: </strong>" + domain + "</p>" +
  32. "<p class='list-group-item-text'><strong>Field: </strong>" + field + "</p>" +
  33. "<p class='list-group-item-text'><strong>Type: </strong>" + type + "</p>" +
  34. "<p class='list-group-item-text'><strong>Address: </strong>" + address + "</p></a>" +
  35. "</div>"; ;
  36.  
  37. btn.Controls.Add(html);
  38. companies.Controls.Add(btn);
  39. }
  40.  
  41. conn.Close();
  42. }
Add Comment
Please, Sign In to add comment