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