Consider that you are assigned to a project to create a very cool application which captures the name, age and date of birth of the user and saves all the data to the database. Yay!
So you go ahead & design a cool form, complete with two text boxes to capture the name & age and add a date picker control to select the date of birth. Sweet!
Now comes the tough part - saving the values to the database. The DBA's really out-did themselves on this one and designed a table which could hold all this information like so:
CREATE TABLE Users (Name VARCHAR(50), Age INT(3), DateOfBirth DATETIME)
Oh, the wicked people! You quake in fear, since your controls expose only a text property and return the values a text. Surely the DBA's could have designed with this in mind. But they work in a different world that you don't quite understand (or control) & so grudgingly you look at what you could do to convert your string values to the types the table expects.
After burning the midnight oil, you come up with a solution like so:
private void saveUser()
{
try{
string name = txtName.Text;
int age = Convert.ToInt32(txtAge.Text);
DateTime dateOfBirth = Convert.ToDateTime(txtDateTime.Text);
// Code to save to the database
}
catch(System.Exception ex){
// Code to do something with the error
}
}
Nice, so you managed to convert the values to the types needed by the database and you threw in the try-catch block to handle anything going wrong in your code. You think you are almost done so you call in the new fresh-out-of-college-dude who joined your team last week to show off your master-peice. One look & he has the nerve to mention Validation controls on the client-side so that you would save the server round-trip if the data is invalid.
You throw him a few dagger looks and put in some Validator controls so that the data can be validated on the client. You can hear the drums beating, the bugles sounding as you push out your code to your manager for some review & feedback while you head out for a celebration. Surely, he would be impressed.
Join the conversation! Your thoughts help the community grow.