How do I add image or picture field to existing database in sql

Question

0.00/5 (No votes)

See more:

SQL> desc student_record_database
Name Null? Type
----------------------------------------- -------- -------------
ROLLNO NOT NULL NUMBER(5)
FIRST_NAME CHAR(10)
MIDDLE_NAME CHAR(10)
LAST_NAME CHAR(10)
ADDRESS VARCHAR2(25)
CONTACT NUMBER
DATE_OF_BIRTH DATE
MEAL CHAR(4)
GRADE VARCHAR2(5)
BLOOD_GROUP VARCHAR2(11)
TRANSPORT CHAR(10)
CARD_TYPE CHAR(10)
CARD_NO NUMBER
DID NUMBER(3)
AID NUMBER(3)
HID NUMBER(2)
RUTNO NUMBER
BUSNO VARCHAR2(10)
SNAME CHAR(10)
CONTACT1 NUMBER
CONTACT2 NUMBER
DIVID VARCHAR2(10)

This is the structure of table student_record_database

Now I want to add picture of each student in this database....

So how to add picture field and how to insert picture into database table.........

Please help
Thank you

Posted 20-Jan-13 17:53pm

surkhi

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Accepted Answer · 2013-01-20T18:00:00

Solution 1

The picture field would be of type blob or image. You'd pass in the bytes of the image as a parameter to a stored proc or paramaterised query. You'd try to avoid doing it in VB6, a language that always sucked and has been obsolete for a decade or more.

Posted 20-Jan-13 18:00pm

Christian Graus

Comments

surkhi 21-Jan-13 0:16am

You are right sir,but unfortunately My front-end is VB6.....
So isn't it possible to retrieve pictures in vb6???
Please specify how to insert image syntactically because I don't understand what you are trying to say.....
Thanx.....

Christian Graus 21-Jan-13 0:44am

Honestly, VB6 is crap and no sane person should be learning it. I have no clue how easy this is to do in VB6, I would be inclined to write a business layer in C# and expose it through COM. Then there's tons of examples on the web of what you want

surkhi 21-Jan-13 0:51am

kthanx