Dispose

25         public void ExcuteNonQuery(string sql)
26         {
27             SqlConnection con = GetConnect();
28             con.Open();
29             SqlCommand cmd = new SqlCommand(sql, con);
30             cmd.ExecuteNonQuery();
31             cmd.Dispose();
32             con.Close();
33         }

66     public override void Dispose()
67     {
68         try
69         {
70             sock.Close();
71         }
72         catch
73         {
74         }
75         sock = null;
76     }

39   public DataSet GetLoad(string sortfield)
40   {
41
42    System.Data.OleDb.OleDbConnection conn = GetConnection();
43    DataSet ds = new DataSet();
44
45    try
46    {
47
48     // Dim sql As String = "SELECT ID data1 as [Firstname],data2 as [Lastname],data3 as [20],data4 as [EG],data5 as [1st-10%],data6 as [50pt],data7 as [EG1],data8 as [2nd-10%],data9 as [50pts],data10 as [EG2],data11 as [20%],data12 as [100pt],data13 as [EG3],data14 as [30%],data15 as [100],data16 as [EG4],data17 as [2nd-30%],data18 as [PrelimGrade],data19 as [Remarks]FROM Table1 order by " + sortfield
49     string sql = "SELECT STUDENTID,data1 AS Firstname, data2 AS Lastname," + "data3 AS 20, data4 AS EG, data5 AS [1st-10%], data6 AS 50pt," + "data7 AS EG1, data8 AS [2nd-10%], data9 AS 50pts, data10 AS EG2," + "data11 AS [20%], data12 AS 100pt, data13 AS EG3, data14 AS [30%]," + "data15 AS 100, data16 AS EG4, data17 AS [2nd-30%], data18 AS PrelimGrade," + "data19 AS Remarks FROM Table1 ORDER BY ID";
50
51     System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql, conn);
52     try
53     {
54      da.Fill(ds, "grade1");
55     }
56     finally
57     {
58      da.Dispose();
59     }
60     return ds;
61    }
62    finally
63    {
64     conn.Close();
65     conn.Dispose();
66    }
67   }

110   public DataSet SaveItem(string sortfield)
111   {
112
113    System.Data.OleDb.OleDbConnection conn = GetConnection();
114
115    try
116    {
117
118     string SQL = default(string);
119
120     SQL = "INSERT INTO TABLE1 (STUDENTID, DATA1, DATA2, DATA3, DATA4, DATA5,DATA6, DATA7," + "DATA8, DATA9, DATA10, DATA11, DATA12, DATA13, DATA14, DATA15, DATA16, DATA17, DATA18," + "DATA19) VALUES(@STUDENTID, @DATA1, @DATA2, @DATA3, @DATA4, @DATA5,@DATA6, @DATA7,DATA8, @DATA9," + "@DATA10, @DATA11, @DATA12, @DATA13, @DATA14, @DATA15, @DATA16, @DATA17, @DATA18, @DATA19)";
121     System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(SQL, conn);
122     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@STUDENTID", Form1.Default.STUDID.Text));
123     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA1", Form1.Default.TextBox1.Text));
124     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA2", Form1.Default.TextBox2.Text));
125     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA3", Form1.Default.TextBox3.Text));
126     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA4", Form1.Default.TextBox4.Text));
127     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA5", Form1.Default.TextBox5.Text));
128     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA6", Form1.Default.TextBox6.Text));
129     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA7", Form1.Default.TextBox7.Text));
130     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA8", Form1.Default.TextBox8.Text));
131     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA9", Form1.Default.TextBox9.Text));
132     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA10", Form1.Default.TextBox10.Text));
133     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA11", Form1.Default.TextBox11.Text));
134     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA12", Form1.Default.TextBox12.Text));
135     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA13", Form1.Default.TextBox13.Text));
136     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA14", Form1.Default.TextBox14.Text));
137     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA15", Form1.Default.TextBox15.Text));
138     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA16", Form1.Default.TextBox16.Text));
139     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA17", Form1.Default.TextBox17.Text));
140     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA18", Form1.Default.TextBox18.Text));
141     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA19", Form1.Default.TextBox19.Text));
142
143     conn.Open();
144     cmd.ExecuteNonQuery();
145     conn.Close();
146     MessageBox.Show("New data is Added!");
147
148     Form1.Default.TextBox1.Text = "";
149     Form1.Default.TextBox2.Text = "";
150     Form1.Default.TextBox3.Text = "";
151     Form1.Default.TextBox4.Text = "";
152     Form1.Default.TextBox5.Text = "";
153     Form1.Default.TextBox6.Text = "";
154     Form1.Default.TextBox7.Text = "";
155     Form1.Default.TextBox8.Text = "";
156     Form1.Default.TextBox9.Text = "";
157     Form1.Default.TextBox10.Text = "";
158     Form1.Default.TextBox11.Text = "";
159     Form1.Default.TextBox12.Text = "";
160     Form1.Default.TextBox13.Text = "";
161     Form1.Default.TextBox14.Text = "";
162     Form1.Default.TextBox15.Text = "";
163     Form1.Default.TextBox16.Text = "";
164     Form1.Default.TextBox17.Text = "";
165     Form1.Default.TextBox18.Text = "";
166     Form1.Default.TextBox19.Text = "";
167     Form1.Default.STUDID.Text = "";
168
169     RefreshDGV();
170
171    }
172    finally
173    {
174     conn.Close();
175     conn.Dispose();
176    }
177
178    return default(DataSet);
179   }

185   public DataSet navigate(string sortfield)
186   {
187
188    System.Data.OleDb.OleDbConnection conn = GetConnection();
189    DataSet ds = new DataSet();
190
191    try
192    {
193
194     int inc;
195     int MaxRows;
196
197     string sql = "select * from table1";
198     System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql, conn);
199
200     try
201     {
202      da.Fill(ds, "grade1");
203      MaxRows = ds.Tables["grade1"].Rows.Count;
204      inc = -1;
205
206
207     }
208     finally
209     {
210      da.Dispose();
211     }
212
213     return ds;
214    }
215    finally
216    {
217     conn.Close();
218     conn.Dispose();
219    }
220   }

225   public DataSet deldata(string sortfield)
226   {
227
228    System.Data.OleDb.OleDbConnection conn = GetConnection();
229    DataSet ds = new DataSet();
230
231    try
232    {
233
234     int inc;
235     int MaxRows;
236
237     //Dim sql As String = "select * from table1"
238     //Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(sql, conn)
239
240     try
241     {
242
243      string sqldelete = default(string);
244      sqldelete = "DELETE * FROM table1 WHERE STUDENTID=\'" + Form1.Default.STUDID.Text + "\'";
245      System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sqldelete, conn);
246
247      // Gets the records from the table and fills our adapter with those.
248      DataTable dt = new DataTable("grade1");
249      da.Fill(dt);
250      MessageBox.Show("Data has been deleted");
251      clearall();
252
253      Form1.Default.DataGridView1.DataSource = dt;
254
255      RefreshDGV();
256
257     }
258     finally
259     {
260      //da.Dispose()
261     }
262
263     return ds;
264    }
265    finally
266    {
267     conn.Close();
268     conn.Dispose();
269    }
270   }

16         public void Dispose()
17         {
18         }

42   protected override void Dispose( bool disposing )
43   {
44    if( disposing )
45    {
46     if(components != null)
47     {
48      components.Dispose();
49     }
50    }
51    base.Dispose( disposing );
52   }

42   protected override void Dispose( bool disposing )
43   {
44    if( disposing )
45    {
46     if (components != null)
47     {
48      components.Dispose();
49     }
50    }
51    base.Dispose( disposing );
52   }

25         private void btnOK_Click(object sender, EventArgs e)
26         {
27             if (txtUserName.Text == "")
28             {
29                 MessageBox.Show("Please enter user name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
30                 txtUserName.Focus();
31                 return;
32             }
33             if (txtPassword.Text == "")
34             {
35                 MessageBox.Show("Please enter password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
36                 txtPassword.Focus();
37                 return;
38             }
39             try
40             {
41                 SqlConnection myConnection = default(SqlConnection);
42                 myConnection = new SqlConnection(cs.DBConn);
43
44                 SqlCommand myCommand = default(SqlCommand);
45
46                 myCommand = new SqlCommand("SELECT Username,password FROM Registration WHERE Username = @username AND password = @UserPassword", myConnection);
47                 SqlParameter uName = new SqlParameter("@username", SqlDbType.VarChar);
48                 SqlParameter uPassword = new SqlParameter("@UserPassword", SqlDbType.VarChar);
49                 uName.Value = txtUserName.Text;
50                 uPassword.Value = txtPassword.Text;
51                 myCommand.Parameters.Add(uName);
52                 myCommand.Parameters.Add(uPassword);
53
54                 myCommand.Connection.Open();
55
56                 SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
57
58                 if (myReader.Read() == true)
59                 {
60                     int i;
61                     ProgressBar1.Visible = true;
62                     ProgressBar1.Maximum = 5000;
63                     ProgressBar1.Minimum = 0;
64                     ProgressBar1.Value = 4;
65                     ProgressBar1.Step = 1;
66
67                     for (i = 0; i <= 5000; i++)
68                     {
69                         ProgressBar1.PerformStep();
70                     }
71                     con = new SqlConnection(cs.DBConn);
72                     con.Open();
73                     string ct = "select usertype from Registration where Username='" + txtUserName.Text + "' and Password='" + txtPassword.Text + "'";
74                     cmd = new SqlCommand(ct);
75                     cmd.Connection = con;
76                     rdr = cmd.ExecuteReader();
77                     if (rdr.Read())
78                     {
79                         txtUserType.Text = (rdr.GetString(0));
80                     }
81                     if ((rdr != null))
82                     {
83                         rdr.Close();
84                     }
85
86                     if (txtUserType.Text.Trim()== "Admin")
87                     {
88                         this.Hide();
89
90                         frm.masterEntryToolStripMenuItem.Enabled=true;
91                         frm.usersToolStripMenuItem.Enabled=true;
92                         frm.customerToolStripMenuItem1.Enabled=true;
93                         frm.suppliersToolStripMenuItem.Enabled=true;
94                         frm.productsToolStripMenuItem.Enabled=true;
95                         frm.recordsToolStripMenuItem.Enabled=true;
96                         frm.registrationToolStripMenuItem.Enabled=true;
97                         frm.databaseToolStripMenuItem.Enabled=true;
98                         frm.customerToolStripMenuItem.Enabled=true;
99                         frm.supplierToolStripMenuItem.Enabled=true;
100                         frm.productToolStripMenuItem.Enabled=true;
101                         frm.stockToolStripMenuItem.Enabled=true;
102                         frm.invoiceToolStripMenuItem.Enabled = true;
103                         frm.Show();
104                         frm.lblUser.Text = txtUserName.Text;
105                         frm.lblUserType.Text = txtUserType.Text;
106                     }
107                     if (txtUserType.Text.Trim() == "Sales Person")
108                     {
109                         frm.masterEntryToolStripMenuItem.Enabled = false;
110                         frm.usersToolStripMenuItem.Enabled = false;
111                         frm.customerToolStripMenuItem1.Enabled = true;
112                         frm.suppliersToolStripMenuItem.Enabled = false;
113                         frm.productsToolStripMenuItem.Enabled = false;
114                         frm.recordsToolStripMenuItem.Enabled = false;
115                         frm.registrationToolStripMenuItem.Enabled = false;
116                         frm.databaseToolStripMenuItem.Enabled = false;
117                         frm.customerToolStripMenuItem.Enabled = true;
118                         frm.supplierToolStripMenuItem.Enabled = false;
119                         frm.productToolStripMenuItem.Enabled = false;
120                         frm.stockToolStripMenuItem.Enabled = false;
121                         frm.invoiceToolStripMenuItem.Enabled = true;
122                         this.Hide();
123                         frm.Show();
124                         frm.lblUser.Text = txtUserName.Text;
125                         frm.lblUserType.Text = txtUserType.Text;
126                     }
127                     if (txtUserType.Text.Trim() == "Warehouse Worker")
128                     {
129                         frm.masterEntryToolStripMenuItem.Enabled = false;
130                         frm.usersToolStripMenuItem.Enabled = false;
131                         frm.customerToolStripMenuItem1.Enabled = false;
132                         frm.suppliersToolStripMenuItem.Enabled = false;
133                         frm.productsToolStripMenuItem.Enabled = false;
134                         frm.recordsToolStripMenuItem.Enabled = false;
135                         frm.registrationToolStripMenuItem.Enabled = false;
136                         frm.databaseToolStripMenuItem.Enabled = false;
137                         frm.customerToolStripMenuItem.Enabled = false;
138                         frm.supplierToolStripMenuItem.Enabled = false;
139                         frm.productToolStripMenuItem.Enabled = false;
140                         frm.stockToolStripMenuItem.Enabled = false;
141                         frm.invoiceToolStripMenuItem.Enabled = false;
142                         this.Hide();
143                         frm.Show();
144                         frm.lblUser.Text = txtUserName.Text;
145                         frm.lblUserType.Text = txtUserType.Text;
146                     }
147
148                        if (txtUserType.Text.Trim() == "Warehouse Manager")
149                     {
150                         frm.masterEntryToolStripMenuItem.Enabled = false;
151                         frm.usersToolStripMenuItem.Enabled = false;
152                         frm.customerToolStripMenuItem1.Enabled = false;
153                         frm.suppliersToolStripMenuItem.Enabled = false;
154                         frm.productsToolStripMenuItem.Enabled = false;
155                         frm.recordsToolStripMenuItem.Enabled = false;
156                         frm.registrationToolStripMenuItem.Enabled = false;
157                         frm.databaseToolStripMenuItem.Enabled = false;
158                         frm.customerToolStripMenuItem.Enabled = false;
159                         frm.supplierToolStripMenuItem.Enabled = true;
160                         frm.productToolStripMenuItem.Enabled = true;
161                         frm.stockToolStripMenuItem.Enabled = true;
162                         frm.invoiceToolStripMenuItem.Enabled = false;
163                         this.Hide();
164                         frm.Show();
165                         frm.lblUser.Text = txtUserName.Text;
166                         frm.lblUserType.Text = txtUserType.Text;
167                     }
168                        if (txtUserType.Text.Trim() == "Customer")
169                        {
170                            frmCustomerMainMenu frm1 = new frmCustomerMainMenu();
171                            this.Hide();
172                            frm1.Show();
173                            frm1.lblUser.Text = txtUserName.Text;
174                        }
175                     }
176                 else
177                 {
178                     MessageBox.Show("Login is Failed...Try again !", "Login Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
179
180                     txtUserName.Clear();
181                     txtPassword.Clear();
182                     txtUserName.Focus();
183
184                 }
185                 if (myConnection.State == ConnectionState.Open)
186                 {
187                     myConnection.Dispose();
188                 }
189
190
191
192             }
193             catch (Exception ex)
194             {
195                 MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
196             }
197         }