₦airaland Forum

segun,
pls since you are a database desiner in sql or my sql i think it is high time u throw more light in the language or you'd better start up a tutorial in this language

hi guys,
i throw the question to Seun and other database programmers in the forum. What is the meaning of  SQL and what is the difference between SQL and MySQL? And also what is the requirements for getting started in SQL or MySQL?

Posted on: June 09, 2006, 10:01:09 PMPosted by: parosky
Insert Quote
You don't seem like a newbie because I've seen some of your contributions. I'm still looking for your email adddress

@ parosky your right in what u said but one must always lets him self down in ohter to learn from the people above him
any way this is mail email address i am waiting for the e-books to be farwarded thanks

parosky:
There are various ways by which you canconnect to a DB. If you are new to VB database programming, I will advise you to use Active X Data Object(ADO). There are 2 means of achieving this.
1. Through a ADO data control (Adodc). Place the adodc on your form and click the ellipses next to the connectionstring property. On the Provider tab of the window shown, select your data provider, e.g select Microsoft Jet OLEDB 3.51(or 4.0) depending on the version of microsoft access you are using, that is if you are connecting to microsoft Acess. On the connection tab, use brose to navigate to the path of your database (the access file*.mdb) This is the simplest you need to do, then click on Test Connection button to see you are connected to your database). Then set the Record source properties to indicatewhether you recordset will be from a table, stored procedure or a sql command. You can then bind controls to displayvalue of each field that will be exposed by your recordset. NB Adodc is not in your tool box by default. You need to add it ( click project>> components then select Microsoft ADO DataControl 6.0 (OLEDB). then click apply button and OK. This show the adodc in your toolbox.

2. Similar to the first but gives you a whole lot of control over your data is to program directly against the ADO Object. You will not need to use the Adodc but you sould set a reference to an ADO object. Click Project >>Reference.
Then
(i) Declare an object variable whose type is ADODB.Connection in the general section of you code or module e.g Dim myConn as
ADODB.Connection. then create the object by writing Set myConn = new ADODB.Connection
ii)Set the Connection object’s ConnectString property to reflect a valid OLE DB provider, or specify the provider string in the next step, as follows:
myConn .ConnectString = "Provider=Microsoft.Jet.OLEDB.3.51;"
iii)Call the Connection object’s Open method. If you didn’t specify the ConnectString property in the preceding step, you need to pass the connection string as the first argument to the Open method, as in the following example. Better still reproduce the following format ( to reduce my typing explanations actually)
dim dbPath as string
myConn.Provider=“Provider=Microsoft.Jet.OLEDB.3.51;”
dbPath="c:\my documents\myDB.mdb"
myConn.Open dbPath
This connect you to the database against which you can now give query to retrieve your recordset. But I feel you are new to database programming. You can ask some more question to let me know I've been helpful and to tell me area where you need more help. I'll check back tommorrow

sorry, for not replying as at when due it was owing to the fact that i've been very very busy with my school.
As you said i'm a newbie vb. and i will also like to know if u have any e-book on vb
do u?
IF reply= true then

pls, send it to my box

Else

End If
once again i would like to thank u for doing me that favour

Oboy,
@Charlisco, u bey guru

Please, can anyone help me by giving out a complete tutorial on the step by step way a connecting to a database using VB?

i am not yet into 3d

charlisco:
belike say na him mooooooooo

@Charlisco
Your funny ,

anyway i think it is "ATI" but if put am "KU" na u sabi

Acknowlegement,
My dear friend in this forum, since we all are hear to learn and discuss our talent, I therefore use this Opportunity to appeal to you all the 3d animations and moddeling field to give me and other newbbies in this forum a general orientation on what 3d animation and modelling is all about, and the job opportunities to gain after studying to course.
waiting for your reply ,

TRy this site below and try me if any of the link is not working

http://www.invano.com.com
http://www.tutorialized.com
http://www.good-tutorials.com

charlisco:
Nigeria Alein

@charlisco,
It that Mr. Vice President, it looks more like him

Afeni:
I have done some work with Maya. It is a very nice and easy to use. I would recommend it if you are new to 3d designing/animation.

pls,
Are those software u recommended in abundant in the market? As in can i purchase them in the market or any computer shop

Going Into 3d And Creating Animated Movies

Please,
i am thinking of going into 3d, 2d, 4d i need to some advice on the software recommended to buy
(Segun, charlisco, and many others help me out)

eezeebee:
I'd appreciate an opportunity to contribute my meagre skills in visualization, texturing and animation to this project. Samples of work I've done are linked below:



I've attempted to register on the other site and I'm awaiting Administrators approval.

Thanks.

eezeebee

what software are u using for you 3D stuff?

although,
Photoshop is used for graphic it can as well be used in creating site templates

[b]1. Opening the Liquifying Filter[/b]There is one very cool filter in Adobe Photoshop which is called "Liquify". Open it with Filter -> Liquify. You will notice a whole new environment.

On the right you will see Tool Options. Set the brush size to the size that will approximately cover the person's head like this
https://img20.imageshack.us/img20/873/20vw.th.jpg

2. Bloating the Forehead

Now we all know aliens have a huge brains so we enlarge the top of the person's head. Pick the Bloat Tool and click on the middle of the forehead. Now hold the left mouse button or click repeatedly, whichever you prefer, the effect is the same. You will notice the top of the head getting bigger and bigger. Stop when you are happy with the result.
https://img20.imageshack.us/img20/5129/45wd.th.jpg

3. Shrinking The Chin

Now select the Pucker Tool which has the opposite effect than the Bloat Tool. Place the brush on the person's chin and hold left button or click repeadetly untill you have shrinked the lower part of the head to the appropriate size (for an alien.

https://img20.imageshack.us/img20/4350/64bq1.th.jpg

4. Shrinking the Ears, Nose and Mouth

For the smaller parts change the brush size to a smaller size. Shrink the ears, nose and mouth using the same technique as in step 3

https://img20.imageshack.us/img20/3540/eye9os.th.jpg
<br>eye</br>
https://img20.imageshack.us/img20/5983/nose8jx.th.jpg
<br> nose</br>
5 Big Eyes
Now pick the Bloat Tool again and make the eyes a little bigger.

It adds to the smartness but also to the cuteness (babies are cute because they have big eyes).

"Ok, but he still looks creepy", I hear you say. We will fix that in the next step
https://img74.imageshack.us/img74/7586/130ki.th.jpg
6. Smiling Mouth
Pick the Forward Warp Tool, select a quite small brush size and drag the mouth corners up to make him smile.

Now he should look cute.

Offcourse, if you are playing with your enemy's photo you can leave him creepy

https://img74.imageshack.us/img74/5751/140fv1.th.jpg
7. Green Hue
Now we will add a green hue.

Return from the Liquifying filter by clicking on OK.

Click on Image -> Adjustments -> Hue/Saturation and drag the Hue indicator to the right untill you get a green hue you like. For an alien I think a slight yellowish-green will be great.
( I used +50 for Hue)
https://img63.imageshack.us/img63/2015/endresult4ay.th.jpg
Final result

it thing i will restructure the tutorial by making it easier by using and method
this is the image i will use for this time
https://img240.imageshack.us/img240/8853/myimage8xs.th.jpg

Original image

https://img240.imageshack.us/img240/2017/finished1wm.th.jpg

final result

ok,
i am about doing dat

charlisco:
What a good effort, but the tutorial is complex, please insert an a image instruction so that we can learn and see the procedure step by step with image
use www.imageshack.us to host it

What exactly did u say i should do with the link
give give the clue in details what i should do exactly.
it is my pleasure to make ppls in this forum happy most especailly you(charlisco) that made me go in to this graphics stuff
i never now i have something up stair in Graphic
i always liked programing and never gone to the Graphics forum
once angin i say thanks

Chiboy is trying indeed
we that dewell in Enugu will testify for him

so segu what would you say

PLs,
once again to rephrase my question how can i send MMS with my motorola T720i
pls, my phone it mms ready but up till now i can't send mms with my phone some one should pls help

Step 1 - Load Image
Load the image of the person you want to turn into an alien.


Step 2 - Make the Image Black and White
Image - Adjustment - Hue/Saturation (Ctrl+U)
Change the saturation to -100


Step 3 - Remove the Background
Select Filter - Extract (Alt+Ctrl+X)
Select the Edge Highleter Tool (B) and tick the Smart Highlighting box.
Run around the head with the Edge Highleter Tool
Then select the Fill Tool (G) and fill the head
Click Ok


Step 4 - Remove Eyes
Select the Erase Tool (E) and remove the eyes


Step 5 - Remove Nose
Select the Clone Stamp Tool (S)
Change the brush to Soft Round 45
Holding down Alt click on the guys forehead and paint over the nose.
Dont worry about making it look perfect we will hide any defects later.


Step 6 - Enlarge Forehead
Select - Filter - Liquify
Select the Forward Wrap Tool (W)
Set the brush size to 150
Push the forehead up


Step 7 - Enlarge Eye Sockets
Next enlarge the eye sockets
Select - Filter - Liquify
Select the Forward Wrap Tool (W)
Set the brush size to 90
Push the eyesockets out


Step 8 - Add Eyes
Copy this image
Edit - Paste
Move the layer behind the face, dupilcate it and postion it


Step 9 - Remove T-Shirt
Remove the T-Shirt and using the liquif tool reshape the neck

hope,
every one belive that this one is true so no need of doing it again
i guess all i need to do is give out the tutorial
it's coming very soon

The tutorial comes at last
to brighten one pics, do the following

step 1 Name the pics myImage
Open the pics

Step 1b Go to Layer>Duplicate layer

To this new layer we will call ImageEffect and will define it's Blending Mode as "Screen"

Step 2 Select ImageEffect and active a BlurFilter on the layer
Filter>Blur>Gaussian Blur
Filter dialog box will appear
Where we will choose a radius of 5 pixel
(the hiher the radius the higher the blur)

well my tutorial is coming up in less than few minutes

Now,
I used the famous Nigerian gal pic which all of us know
lay ur comment on this pic
is she not a star

Photoshop brings out the star in you

Alright,
I'm going to use the picture of the hotest female to do one now

yes ur right but i am just a beginner
i started with that

heello
no need of taking check out thing for ur self

turning Mr President into an alien

hi,
finally i tried to make out my own effect on photo shop look at what i did
make a very dull picture to look more lovely

Pls,
Can any one give me a clue on how to send mms using T720!