C#

kaycey90 wrote:

sb.Append('"'); sb.Append(student.Deleted); sb.Append("\",");
sb.Append(")");

Set the command and add the parameters
Loop
  Set the paramater values
  Execute the command
Endloop

private Students students;

public Students Students
{
    get{ return students; }
    set
    {
        students = value;
        txtName.Text = students.Name;
    }
}

Data datawindow = new Data();
datawindow.Students = stud;
datawindow.ShowDialog();

public Student EditStudent(Student input){
 this.firstNameTextBox.Text = input.FirstName;
 // ... etc to copy data into other controls
 // you could also use data binding
 if(DialogResult.OK == ShowDialog()){
  Student result = new Student();
  result.FirstName = firstNameTextBox.Text;
  // etc
  return result;
 } else return input;
}

public Student Student {
 get {
  Student student = new Student();
  student.FirstName = firstName.Text;
  // etc
  return student;
 }
 set {
  firstName.Text = value.FirstName;
  // etc
 }
}

studentDataForm.Student = someStudent;
if(DialogResult.OK == studentDataForm.ShowDialog(this)){
 // Do something with studentDataForm.Student to store the changed data
}