private static void UpdateStudent()
{
//Get db connection string.
DBMSSQL Db = GetMSSQLDB();
//Declare the update statement.
String Query = "UPDATE Student SET LastName = 'Peters' WHERE ID='4';";
//Execute the query
Db.NonQuery(Query);
}
private static void DeleteStudent()
{
//Get db connection string.
DBMSSQL Db = GetMSSQLDB();
//Declare the delete statement.
String Query = "DELETE From Student WHERE ID='4';";
//Execute the query
Db.NonQuery(Query);
}
private static void CreateStudent()
{
//Get db connection string.
DBMSSQL Db = GetMSSQLDB();
//Declare the insert statement.
String Query = "INSERT INTO Student (ID,LastName, FirstName, StreetAddress) Values (4,'Murkel','Cliff','115 Niagara Ave');";
//Execute the query
Db.NonQuery(Query);
}
