Advertisement
Guest User

Untitled

a guest
Sep 18th, 2014
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. id username useraddress location comments
  2. 1 explename expleaddre1 va *NULL*
  3. 2 explename2 expleaddre2 ma mycomments
  4. 3 explename3 expleaddre3 la mycomments
  5. 4 explename4 expleaddre4 ka mycomments
  6.  
  7.  
  8. SqlDataReader dr = cmd.ExecuteReader();
  9.  
  10. while (dr.Read())
  11. {
  12. lbluserid.Text = Convert.ToInt32(dr.GetString(0)).ToString();
  13. lblusername.Text = dr.GetString(1);
  14. lblusertitle.Text = dr.GetString(2);
  15.  
  16.  
  17. lst.Add(unt);
  18. }
  19.  
  20. conn.Close();
  21.  
  22. int ordinalPos = reader.GetOrdinal("Comments");
  23. if(!reader.IsDBNull(ordinalPos))
  24. {
  25. labelComment.Text = reader.GetString(ordinalPos);
  26. }
  27. else
  28. {
  29. labelComment.Text = "No comments found!";
  30. }
  31.  
  32. public static class SqlDataReaderExtensions
  33. {
  34. public static string GetString(this SqlDataReader reader, string colName, string defIfNull)
  35. {
  36. int ordinalPos = reader.GetOrdinal(colName);
  37. return (!reader.IsDBNull(ordinalPos) ? defIfNull : reader.GetString(ordinalPos));
  38. }
  39. }
  40.  
  41. labelComment.Text = reader.GetString("Comments", "No comments found");
  42.  
  43. using (SqlCommand command = new SqlCommand("SELECT * FROM YourTable", connection))
  44. {
  45. SqlDataReader reader = command.ExecuteReader();
  46. while (reader.Read())
  47. {
  48. string comments = reader.GetString(4);
  49. if (comments != null)
  50. Console.WriteLine("Comments is {0}", comments);
  51. // Assign Text property of your labels..
  52. }
  53. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement