public int Insert(Student s) { string query = "Insert into Student (Name,Age,Roll) values('" + s.Name + "'," + s.Age + "," + s.Roll + ")"; int res = base.InsertUpdateDelete(query); return res; }
public List<Student> StdSelectAll() { reader = base.SelectAll("Student"); List<Student> list=new List<Student>(); while (reader.Read()) { Student temp = new Student(); temp.SN = Convert.ToInt32(reader["SN"]); temp.Name = Convert.ToString(reader["Name"]); temp.Age = Convert.ToInt32(reader["Age"]); temp.Roll = Convert.ToInt32(reader["Roll"]); list.Add(temp); } return list; }
private void button4_Click(object sender, EventArgs e) { Student s=new Student(); // s.SN = Convert.ToInt32(SnTextbox.Text); s.Name = NameTextbox.Text; s.Roll = Convert.ToInt32(RollTextbox.Text); s.Age = Convert.ToInt32(AgeTextbox.Text); StudentDb sdb=new StudentDb(); int result=sdb.Insert(s); if(result==-1) { MessageBox.Show("couldn't be inserted"); } else { MessageBox.Show(result+" Row inserted"); } }
public int Update(Student s) { string query = "Update Student set Name='" + s.Name + "',Age=" + s.Age +",Roll=" + s.Roll; int res = base.InsertUpdateDelete(query); return res; }