Advertisement
ShahrinAzuan

Masalah GridView Tak Muncul

Sep 21st, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.35 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Data.SqlClient;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Threading.Tasks;
  10. using System.Windows.Forms;
  11. using Dapper;
  12.  
  13. namespace AplikasiSistemDatabase
  14. {
  15. public partial class FormSistemAplikasiMaklumat : System.Windows.Forms.Form
  16. {
  17. SqlConnection sqlCon = new SqlConnection(@"Data Source=SHAHRIN87\SHAHRINSQL;initial Catalog=BarangDB;Integrated Security=True;");
  18. int BarangID = 0;
  19. public FormSistemAplikasiMaklumat()
  20. {
  21. InitializeComponent();
  22. }
  23.  
  24. private void label1_Click(object sender, EventArgs e)
  25. {
  26.  
  27. }
  28.  
  29. private void groupBox1_Enter(object sender, EventArgs e)
  30. {
  31.  
  32. }
  33.  
  34. private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
  35. {
  36.  
  37. }
  38.  
  39. private void btnSave_Click(object sender, EventArgs e)
  40. {
  41. try
  42.  
  43. {
  44. if(sqlCon.State == ConnectionState.Closed)
  45. sqlCon.Open();
  46. DynamicParameters param = new DynamicParameters();
  47. param.Add("@BarangID", BarangID);
  48. param.Add("@NamaBarang", txtNamaBarang.Text.Trim());
  49. param.Add("@TarikhMasuk", dtpTarikhMasuk.Value.Date);
  50. param.Add("@TarikhKeluar", dtpTarikhKeluar.Value.Date);
  51. param.Add("@Kuantiti", txtKuantiti.Text.Trim());
  52. param.Add("@Harga", "Rm"+txtHarga.Text.Trim());
  53.  
  54. sqlCon.Execute("BarangAddOrEdit", param, commandType: CommandType.StoredProcedure);
  55. FillDataGridView();
  56. }
  57.  
  58. catch (Exception ex)
  59. {
  60. MessageBox.Show(ex.Message);
  61. }
  62. finally
  63. {
  64. sqlCon.Close();
  65. }
  66. }
  67.  
  68. void FillDataGridView()
  69. {
  70. DynamicParameters param = new DynamicParameters();
  71. param.Add("@SearchText", txtSearch.Text.Trim());
  72.  
  73. List<Barang> list = sqlCon.Query<Barang>("BarangViewAllOrSearch",param,commandType:CommandType.StoredProcedure)
  74. .ToList<Barang>();
  75.  
  76.  
  77. dgvBarang.DataSource = list;
  78.  
  79. }
  80.  
  81. class Barang
  82. {
  83. public int BarangID { get; set; }
  84.  
  85. public string NamaBarang { get; set; }
  86.  
  87. public TarikhMasuk { get; set; }
  88.  
  89. public TarikhKeluar { get; set; }
  90.  
  91. public int Kuantiti { get; set; }
  92.  
  93. public string Harga { get; set; }
  94. }
  95.  
  96. private void textBox1_TextChanged(object sender, EventArgs e)
  97. {
  98.  
  99. }
  100.  
  101. private void FormSistemAplikasiMaklumat_Load(object sender, EventArgs e)
  102. {
  103. try
  104. {
  105. FillDataGridView();
  106. }
  107. catch (Exception ex)
  108. {
  109. MessageBox.Show(ex.Message);
  110. }
  111. }
  112.  
  113. private void btnSearch_Click(object sender, EventArgs e)
  114. {
  115. try
  116. {
  117. FillDataGridView();
  118. }
  119. catch (Exception ex)
  120. {
  121. MessageBox.Show(ex.Message);
  122. }
  123. }
  124. }
  125. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement