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);
}
}
