hello.does anybody know ..
how to make an image database by using VB.NET 2005 and Microsoft Access
i want to make an application ( VB.NET 2005 ) that prompt a user to put his picture into database (Mic. Access)
the database i've set have a pictures field , staff name , address and so on..
so in the VB i know how to build a connection to the database ..
the problem is how do i make image uploader .. into database.
hope anybody can help me.
2 4048
Hi there,
my suggestion is not a solution to your question, more a workaround...
First of all there is the question: is it really necessary to put the image data inside your database?
The answer is usually NO, until you are planning sophisticated solutions including replication and the like. Image data can not be used for sorting, indexing or anything else what makes handling data in a database efficient.
Suggestion: use another "database system" already on your computer, the file system.
Suppose your users are listed in a table named USERS and indexed with a primary key named UserID.
Simply create a subfolder named PICTURES where your database resides and put your users images there with a fixed name derived from UserID, like Picture17.JPG.
Then you can use the frameworks standard commands like Image.Save and Image.FromFile to access your picture data and there is no need to fiddle with binary data in access tables.
Hi there,
my suggestion is not a solution to your question, more a workaround...
First of all there is the question: is it really necessary to put the image data inside your database?
The answer is usually NO, until you are planning sophisticated solutions including replication and the like. Image data can not be used for sorting, indexing or anything else what makes handling data in a database efficient.
Suggestion: use another "database system" already on your computer, the file system.
Suppose your users are listed in a table named USERS and indexed with a primary key named UserID.
Simply create a subfolder named PICTURES where your database resides and put your users images there with a fixed name derived from UserID, like Picture17.JPG.
Then you can use the frameworks standard commands like Image.Save and Image.FromFile to access your picture data and there is no need to fiddle with binary data in access tables.
are there any tutorial link .. like like you said ?
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Chris D |
last post by:
I'm doing some work with submitting graphics via ASP.net page to SQL 2000
server using VB.
I know how to get a graphic into the database from a filefield control. I
also know how to pull it out of the database and thumbnail it on the fly.
Creating thumbnail on the fly seems extremely inefficient to me as this has
to be done every time the image is requested. What I want to do is get the
image from the filefield control, thumbnail it...
|
by: seeni |
last post by:
I have tried retrieving the image data from NorthWind database and print in
the asp page using Repeater control. But instead of showing picture, the
browser is showing "System.Byte"
My code is
In codebehind file.
private void Page_Load(object sender, System.EventArgs e)
{
|
by: Neo Geshel |
last post by:
I have examined about 80+ different upload scripts on the 'net, both in
VB and C#, and none seem to do what I need them to do. Perhaps someone
here can point me somewhere that Google hasn't reached yet (I have gone
all the way to page 50 on Google's results!!). Here are my requirements:
• I have a DataGrid. Everything will be done from here. Everything. No
exceptions. Everything will also be done in VB, without any code-behind
to...
|
by: John Rivers |
last post by:
Here is an example of what I am talking about:
asp.net takes what is a very simple, powerful and flexible
concept, http request/response with html for presentation
and turns it into a ridiculously over-complicated kludge
which causes way more problems than it solves by attempting
to turn it into a flat, "event-driven" paradigm
for example:
|
by: mattmerc |
last post by:
Hi all,
I have an web application where security staff can enter incidents.
Part of the form allows the user to describe person(s) involved in an
incident. My company just so happens to have a sql database will all
employees as well as a picture. I have created a lookup tool so someone
can enter in a first or last name and then get a list of matching
employees. They can then select which one from the datagrid and all the
information I...
| |
by: Stan Sainte-Rose |
last post by:
Hi,
What is the better way to save image into a database ?
Just save the path into a field or save the image itself ?
I have 20 000 images (~ 10/12 Ko per image ) to save.
Stan
|
by: Lindsey Howell |
last post by:
Hello,
I've encountered a problem when trying to display BLOB images from a SQL
database using VB.NET. This is the code which generates the error:
Dim mySqlConnection As SqlConnection = New
SqlConnection(connectionString)
Dim mySqlCommand As SqlCommand = New SqlCommand(queryString,
mySqlConnection)
Dim ms as MemoryStream = New MemoryStream
|
by: michael |
last post by:
Hi,
I am trying to write an ASP.NET web app, in Visual Basic.NET, using
Visual Studio.NET 2004, .NET framework 1.1.4322 SP1
Running the project/app on localhost while in dev/write/debug stage
When I say "trying", I do have it written, and it works ... sort of,
for some cases.
The problems/issues?
|
by: Auto |
last post by:
Hello,
I would like to know how do display an image into a Gridview (ASP.NET 2.0)
taken directly from a DataBase, NOT using an URL, like described in this
article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/GridViewEx06.asp
I have NO URL, i have the binary image inside the DB, like the field "Photo"
in the table "Employees" of the "NWIND.MDB" DataBase.
|
by: asharda |
last post by:
Hi,
I have an ASP.Net application with the back-end as VB.Net. I have a
combo control and on the selection changed event of the combo control
I need to get the selected image from the database and display it on a
Image control on the asp.net page.
I get the image from the db as a byte array. Can anyone please help,
as to how to show the image on the page in that image control?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |