Display information in Upper and Lower case from SQL database

In my database table (products) I have a column called items that lists a number of products in sentence case. In order to display them in upper and lower case I do the following :

Open query analyser.
Select the required database.

Upper case

Select upper (item) from products

Lower case

Select lower (item) from products

Get current date and time in SQL

There may be times where you will need to insert the current date and time into a database i.e. to record when a transaction has taken place. The command to display this timestamp is as follows :

select getdate() 'Current Date'

If you type this into query analyser you will get the current date and time in a column entitled 'Current Date'.

How do you copy a database table in SQL using code?

Open Query analyser
Select the required database (Use [databasename])

Type :

SELECT * INTO MyNewTable FROM MyTable

e.g SELECT * INTO Customer2 FROM Customer

C# application that counts the number of characters being entered

This application consists of a textbox and a label. As the user types in the text box the label displays the number of characters that have been entered. The code is as follows :

private void textBox1_TextChanged (object sender, EventArgs e)

{
int charactercount;
string labeloutput;

charactercount = textBox1.TextLength;
labeloutput = charactercount.ToString();

lblcount.Text = "Character count : " + labeloutput;

{

Collect user input from form and change it to upper or lower case in C#

In this example I have a text box on my windows form to collect the user input and a label to display the outcome once a button is pressed. The code is as follows to change the input to upper and lower case.

private void button3_Click(object sender, EventArgs e)

{

label1.Text = textBox.Text.ToUpper();

}

or

{

label1.Text = textBox.Text.ToLower();

}

How do you add a value from a webform to a variable in C#?

In Visual Studio 2005 :

Create a webform with a text field and change it's name to 'txtID'
Create another text field to show the result of the variable and change its name to 'txtResult'
Add a button and then add this code to it's click event.

String info = txtID.Text;

txtResult.Text = info;

When the button is clicked it will take the text that is in the field and add it to the variable called 'info. It will then display the value of the variable in the txtResult field.