private void btnAddGuardian_Click(object sender, EventArgs e)
{
SearchForUser GetContact = new SearchForUser(GUARDIAN_ASSOCIATION_REQUEST, this, sqlite_conn);
GetContact.ShowDialog();
Console.Write("{0}{1}", iUser, sRelationship);
SQLiteCommand sqlite_cmd = new SQLiteCommand("INSERT INTO Guardians (id,iStudent,iPerson,sRelationship) VALUES (@id,@iStudent,@iPerson,@sRelationship)", sqlite_conn);
sqlite_cmd.Parameters.Add("@id", SqlDbType.Int).Value = null;
sqlite_cmd.Parameters.Add("@iStudent", SqlDbType.Int).Value = Int32.Parse(txtID.Text);
sqlite_cmd.Parameters.Add("@iPerson", SqlDbType.Int).Value = iUser;
sqlite_cmd.Parameters.Add("@sRelationship", SqlDbType.Text).Value = sRelationship;
try
{
sqlite_cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
LoadGuardians();
}
private void btnAddGuardian_Click(object sender, EventArgs e)
{
SearchForUser GetContact = new SearchForUser(GUARDIAN_ASSOCIATION_REQUEST, this, sqlite_conn);
GetContact.ShowDialog();
Console.Write("{0}{1}", iUser, sRelationship);
SQLiteCommand sqlite_cmd = new SQLiteCommand("INSERT INTO Guardians (id,iStudent,iPerson,sRelationship) VALUES (@id,@iStudent,@iPerson,@sRelationship)", sqlite_conn);
sqlite_cmd.Parameters.Add("@id", SqlDbType.Int).Value = null;
sqlite_cmd.Parameters.Add("@iStudent", SqlDbType.Int).Value = Int32.Parse(txtID.Text);
sqlite_cmd.Parameters.Add("@iPerson", SqlDbType.Int).Value = iUser;
sqlite_cmd.Parameters.Add("@sRelationship", SqlDbType.Text).Value = sRelationship;
try
{
sqlite_cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
LoadGuardians();
}