public DataTable Dal_find_student(BAL_Student obj)
{
try
{
//start connection
con = ProjectConnection();
con.Open();
//insert into table
string query = "Find_Student";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@val_sid", obj.bal_sid);
da = new SqlDataAdapter(cmd);
r = cmd.ExecuteNonQuery();
//close the connection
con.Close();
//Fill the data table
dt = new DataTable();
da.Fill(dt);
}
catch (Exception ex)
{
dt = null;
}
return(dt);
}
public int Dal_update_student(BAL_Student obj)
{
try
{
//start connection
con = ProjectConnection();
con.Open();
//insert into table
string query = "Update_Student";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@val_sid", obj.bal_sid);
cmd.Parameters.AddWithValue("@val_sname", obj.bal_sname);
cmd.Parameters.AddWithValue("@val_sgrade", obj.bal_sgrade);
r = cmd.ExecuteNonQuery();
//close the connection
con.Close();
}
catch (Exception ex)
{
r = 0;
}
return(r);
}
