From chapter 3.2 of T-SQL 2008 Joes 2 Pros (www.joes2pros.com). Learn how to find matches and exceptions with outer joins.
Duration : 0:4:54
From chapter 2.2 of T-SQL 2008 Joes 2 Pros (www.joes2pros.com). How to use range and pattern matches in a basic single table query in SQL server 2005 and 2008. Full Video is a free download at www.Joes2Pros.com along with a PDF book sample.
Duration : 0:8:58
From chapter 1 of T-SQL 2008 Joes 2 Pros (www.joes2pros.com). Learn the basic terms or Geek Speak used by SQL Server database professionals.
Duration : 0:4:46
Learn how to create cross-tab reports in Crystal Reports by Business Objects at www.teachUcomp.com. A clip from Mastering Crystal Reports Made Easy v. 11 (XI). http://www.teachucomp.com/tutorcrmain.htm - the most comprehensive Crystal Reports tutorial available. Visit us today!
Duration : 0:9:47
Learn how to use the Template Expert in Crystal Reports by Business Objects at www.teachUcomp.com. A clip from Mastering Crystal Reports Made Easy v. 11 (XI). http://www.teachucomp.com/tutorcrmain.htm - the most comprehensive Crystal Reports tutorial available. Visit us today!
Duration : 0:3:16
www.Joes2Pros.com How to use exact criteria matches in a basic single table query in SQL server 2005 and 2008.
Duration : 0:7:59
Gymjunnky.com Welcome’s you to learn VB.NET 2005/2008 this is tutorial no2 and my name is Gym_
In this short tutorial I’m going to demonstrate popup boxes with variable input as well as the If statement
Please take note that all my tutorials start off vey basic and slowly get more advanced so if you do not understand some of the functions then please revert back to previous tutorials.
So let’s get started,,
Open your 2005 or 2008 Vb.NET edition and select new Project
Then were going to just change the name to popup call your project whatever you like
1st thing we need to do is grab ourselves a button,, and draw a rectangle on our form were we would like it to go
Then were going to double click on the button and inside were going to right
MSGBOX “Welcome to vb.net”
Make shore you use quotation marks as this tells vb that this is an actual quote of what is to be said.
Then click the run or play button
and click on the button we made on the front of the form
Ok there ya have it welcome to vb.net
Ok lets spice this up a little let’s make the text inside this message box variable
One way of doing this is adding a textbox to our form so let’s do that now,,, click the icon textbox and draw a rectangle on the form.
You can choose whether to have mutable lines by clicking the little arrow button and then ticking the multi line box
I’m just going to change the colour of our form here so we can see this a little better
Ok so click the button that we made on the form and erase what we wrote
And let’s see what happens without the quotation marks
Lets write in there MSGBOX (Textbox1.Text)
Then hit the play button
Then we just type in something say 123
And hit bottom 1 and there ya have it,, Msgbox 123
Lets try something ells
Hello how ya doing
So there ya go a way of making the message box variable input which can be handy for heaps of different things like telling you the results of scores and different inputs
Ok let’s try something different again
Lets make 3 check boxes on our form
Then go back and click inside the button again,, erase what we have written and lets a message box with the if statement
Inside the button lets right if checkbox1.checked then
Msgbox ” You have clicked box one
End if
Then we right
If textbox2.checked then
Msgbox ” you have clicked box 2″
End if
If checkbox3.checked then
Visit gymjunnky.com for more vids bit of shameless promotion there..lol
But you notice ive done something wrong.. yerp that’s Wright i did give it the command of what to do so lets fill that in with MSGBOX”
End if
Ok lets see what happens if we remove these and Ifs
As you can see the stamen is underlined saying ya stuffed something up and if you hover your mouse over it it says
If must end with matching end if
So lets replace the end ifs and then run the program
Lest click the button and as you see nothing happens
So lets click number 1 ,, and as you see our statements are showing up,,
Ok so what happens if we click all 3
There ya go shows all 3 of our statements,,
so there ya go you can use that for lots of different things and hopefully get some use outer it if not at lest some better understanding of how the if statement and making the text variable in a message box,,
remember all of my tutorials as well as the source codes to these programs are on my website as well as programming resource programs and help forms for if you have a question then jump on in and ask away,,
this has been tutorials 2 of learn VB.NET my name is Gym and ill catch ya next time peace out ppls
Duration : 0:7:31
www.Joes2Pros.com… Learn how to use basic inner joins to see two tables in one results set..
Duration : 0:8:37
Gymjunnky.com Welcome to learn vb.net this is tutorial 3 and my name is Gym_
In this lesson were going to learn some tricks with duel forms and learn how to do some very basic pass word protected applications
So lets get right to it,,
1st thing is open up VB.net ether 2005 or 2008 if you have Vb6.0 have a look on my channel or website and your will find plenty of tutorials for VB 5 and 6.0
Ok so lets get on with the show shall we.
Going to open up windows form application and change the name to project 3 and click ok
Then im going to draw a button on the form
Then im going to add a 2nd form
Do this by clicking on project link at the top of VB and then the add windows form tab
Then were going to scroll right down the bottom till we see windows form and ether double click on it or high light it and click OK
This is going to add the 2nd form to our project
After that were going to double click on the button we made on our form1 and insert the codes to open and close our forms
Form2.show is used to make our 2nd form visible
And me.hide closes no1 form in vb6.0 you could use form1.hide but in 2005 and 2008 you must use the term ME as reference to the form that the code is being placed into
And that’s it all of 4 words to open and close 2 forms
So let’s run the program and have a quick look
Cool that works
So again let’s try something a little more advanced,,, let’s make form 2 pass word protected
Click on the text box icon and draw a textbox on form 1
If textbox 1 . text = “123456″ then
Ok see the blue line its telling us that there is a error,, and if we hover our mouse over the top of it u can see its telling us there is no end if at the end of the stamen
So after we make shore we have our quotation marks in place let’s put in that end if statement
And lets run the program again
Click the button and nothing happiness
Put in the wrong pass word and click the button
And nothing happens
Enter the correct password and form 2 shows up and form 1 closes
Now that certainly dose the job but how about we make it a bit better
So 1st thing i want to do is change the colours on the forms so it can be seen a lot more easily on video.
Lets change form1 to blue and form 2 to a dark red
Ok to improve the function ability of this pass word protected form let put in a else statement
After form show and hide type in Else
Then Msgbox ” wrong pass”
This means that is the if anything ells what so ever happens besides that pass word being right then the else stamen kicks in and in this case provides us with a message box saying wrong password
Ok so lets see this in action shall we
Run the program click the button with no pass word in we get message box
Type in the wrong pass word,,, and we get message box
Type in the right password and get form 2 appearing and form to leaving
..
what about if we want multiple boxes like how that have the key login on windows and a lot of other software as your instilling it.
Very easy lets put 2 more text boxes on our form
And then go into our code and put
If text1 . text = “123456″ and text2 . text = “123456″ and text3. Text = “123456″ then
Format C drive,,, nar just kidding
Form2.show
Me. Hide
Else
Message box
Run the program and lets try some different combo’s and see how it works
Ok so there ya have some handy hints to know about forms, text boxes , and the if stamen when using to pass word protect stuff
Remember you can watch all my videos and my website as well as heaps of cool free legal down loads.. All the source codes to my projects as well as help forums on
www. gymjunnky.com
My name is Gym and you have been watching learn to program in VB.NET tutorial 3
Duration : 0:8:15
Common data scenarios require developers to write and maintain logic to determine whether to insert, update or delete information (sometimes called upsert) such as:
IF FOUND
THEN UPDATE
ELSE
INSERT
SQL Server 2008 provides the new MERGE statement within the SQL language to enable developers to provide this functionality with a single statement. This allows for code reduction and easier maintainability.
Duration : 0:3:28