
G12 ComProg Quiz#1
Quiz by Imelda Zapanta
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
The Datatype Integer can be set to Long Integer on the Field size Setting
What is the default Field Size of a Short Text ? (number)
It displays rows and columns of data in a grid that you can customize.
It is a customizable screen that will appear for a few seconds as your application loads up.
It executes a commands such as SQL INSERT, DELETE,UPDATE, and SET statements
Arrange the Steps in connecting to the database in MS Access and execute commands in VB.net
In the DataGridView Task, you CANNOT set (check) the enable Adding, Editing, and Deleting of Data.
What are the Steps in Adding Splash Screen in your Program?
Complete the Code....Â
Private Sub Button1_Click ………
       Dim connectionString As String ="Provider=Microsoft.Jet…….
       Dim sql As String = "SELECT * FROMSem2dBaseAct1"
       Dim connection As NewOleDbConnection(connectionString)
       Dim dataadapter As NewOleDbDataAdapter(sql, connection)
       Dim ds As New DataSet()
       _____________________
       dataadapter.Fill(ds, "tblStud")
       connection.Close()
Complete the code:
Private Sub btnUpdate…
       IftxtStud_ID.Text <> "" And txtStudent.Text <> ""And ……
           cmdUpdate.CommandText = "UPDATE tblStud SET [Student] = '"& …….." ;"
           cmdUpdate.CommandType = CommandType.Text
           cmdUpdate.Connection = cnnOLEDB
Â
           ----------------------------------
           MsgBox(txtStud_ID.Text & " Record updated.")