Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.77 KB | None | 0 0
  1. public formAccounts()
  2. {
  3. InitializeComponent();
  4. BindGrid();
  5. }
  6.  
  7. private void BindGrid()
  8. {
  9. OleDbConnection conn = new OleDbConnection();
  10. conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= G:SanjeevTESTDBDB.mdb;Jet OLEDB:Database Password=Test123; Jet OLEDB:Engine Type=5";
  11. conn.Open();
  12. string constring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:SanjeevTESTDBDB.mdb;Jet OLEDB:Database Password=Test123; Jet OLEDB:Engine Type=5";
  13.  
  14. using (OleDbConnection con = new OleDbConnection(constring))
  15. {
  16. using (OleDbCommand cmd = new OleDbCommand("SELECT * FROM tblAccounts", con))
  17. {
  18. cmd.CommandType = CommandType.Text;
  19. using (OleDbDataAdapter sda = new OleDbDataAdapter(cmd))
  20. {
  21. using (DataTable dt = new DataTable())
  22. {
  23. sda.Fill(dt);
  24. //Set AutoGenerateColumns False
  25. dtGrdAccounts.AutoGenerateColumns = false;
  26. //Set Columns Count
  27. ***dtGrdAccounts.ColumnCount = 3;***
  28. //Add Columns
  29. dtGrdAccounts.Columns[0].Name = "AccountID";
  30. dtGrdAccounts.Columns[0].HeaderText = "Id";
  31. dtGrdAccounts.Columns[0].DataPropertyName = "AccID";
  32.  
  33. dtGrdAccounts.Columns[1].HeaderText = "Account name";
  34. dtGrdAccounts.Columns[1].Name = "Account name";
  35. dtGrdAccounts.Columns[1].DataPropertyName = "AccName";
  36.  
  37. dtGrdAccounts.Columns[2].Name = "AccountNumber";
  38. dtGrdAccounts.Columns[2].HeaderText = "Account number";
  39. dtGrdAccounts.Columns[2].DataPropertyName = "AccNumber";
  40. dtGrdAccounts.DataSource = dt;
  41. }
  42. }
  43. }
  44. }
  45. }
  46.  
  47. string cmdText = "prAddAccounts";
  48. OleDbCommand cmd = new OleDbCommand(cmdText, conn);
  49. cmd.CommandType = CommandType.StoredProcedure;
  50. cmd.Parameters.AddWithValue("AccName", txtAccName.Text.ToString());
  51. //..... other parameters to insert record .....
  52. OleDbCommand cmd = new OleDbCommand(cmdText, conn);
  53. cmd.CommandType = CommandType.StoredProcedure;
  54. OleDbDataReader reader = cmd.ExecuteReader();
  55. BindGrid();
  56.  
  57. string cmdText = "prAddAccounts";
  58. OleDbCommand cmd = new OleDbCommand(cmdText, conn);
  59. cmd.CommandType = CommandType.StoredProcedure;
  60. cmd.Parameters.AddWithValue("AccName", txtAccName.Text.ToString());
  61. //..... other parameters to insert record .....
  62.  
  63. //Clear the binding.
  64. dtGrdAccounts.DataSource = null;
  65. //Bind the new data.
  66. BindGrid();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement