private void Reset() { ScholarshipID.Text = ""; ScholarshipName.Text = ""; Description.Text = ""; Amount.Text = ""; btnSave.Enabled = true; Delete.Enabled = false; Update_record.Enabled = false; ScholarshipName.Focus(); }
private void btnSave_Click(object sender, EventArgs e) { if (ScholarshipName.Text == "") { MessageBox.Show("Please enter scholarship name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ScholarshipName.Focus(); return; } if (Amount.Text == "") { MessageBox.Show("Please enter amount", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Amount.Focus(); return; } try { con = new SqlConnection(cs.DBcon); con.Open(); string cb = "insert into Scholarship(Scholarshipname,Description,amount) VALUES (@d2,@d3,@d4)"; cmd = new SqlCommand(cb); cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.NChar, 30, "Scholarshipname")); cmd.Parameters.Add(new SqlParameter("@d3", System.Data.SqlDbType.VarChar, 200, "Description")); cmd.Parameters.Add(new SqlParameter("@d4", System.Data.SqlDbType.NChar, 10, "Amount")); cmd.Parameters["@d2"].Value = ScholarshipName.Text.Trim(); cmd.Parameters["@d3"].Value = Description.Text.Trim(); cmd.Parameters["@d4"].Value = Amount.Text.Trim(); cmd.ExecuteNonQuery(); MessageBox.Show("Successfully saved", "Scholarship Details", MessageBoxButtons.OK, MessageBoxIcon.Information); st1 = lblUser.Text; st2 = "Added new Scholarship'" + ScholarshipName.Text + "'"; cf.LogFunc(st1, System.DateTime.Now, st2); btnSave.Enabled = false; Autocomplete(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }