A) ADO.NET DataAdapter provides 5 overloaded Fill() methods to…

Question Answered step-by-step A) ADO.NET DataAdapter provides 5 overloaded Fill() methods to… A) ADO.NET DataAdapter provides 5 overloaded Fill() methods to retrieve data from theselected table(s), column(s) or record(s). They are:public int Fill (DataSet)public int Fill (DataTable)public int Fill (DataSet, NameofTable)public int Fill (StartingNo, MaxNo, DataTable)public int Fill (StartingNo, MaxNo, DataSet, NameofTable)What is function overloading in object-oriented programming? Give a brief explanation oneach of the fill method in your answer booklet (10 Marks)B) The following source code is extracted from a C# project to delete an existing record ofa database. Some sections of the code have not been commented yet. To clarify the purposeof the code, please give your comment on each section of the code (section 1, 2, 3, 4, and5) respectively in your answer booklet (10 Marks)//Prepares a database connection stringstring dbconnection = “Provider=Microsoft.ACE.OLEDB.12.0;”+ @”data source =BookCSharp.accdb”;//Section 1 string dbcommand = “Select BookKey, Title, Pages from Books;”;OleDbConnection conn = new OleDbConnection(dbconnection);OleDbCommand comm = new OleDbCommand(dbcommand, conn);OleDbDataAdapter adapter = new OleDbDataAdapter(comm);//Section 2OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);…..//Section 3ds.Tables[0].Rows[lstDisplayBooks.SelectedIndex].Delete();//Section 4adapter.Update(dataSetChanges);//Section 5ds.AcceptChanges(); Computer Science Engineering & Technology Object-Oriented Programming CS COMP16121 Share QuestionEmailCopy link Comments (0)