Hi Experts
I have a working c# application that users can store files (.doc, .xls,
..bmp, etc) as binary data into an Access database. I now need to extend this
to also store hyperlinks.
First of all I need some way of searching for the hyperlink. In Access there
is an Insert Hyperlink dialog that can be used. Is there a similar dialog in
c#? At the moment I use the OpenFileDialog to select files to be stored,
could this be modified?
If it's possible to store the hyperlinks in the Access database, then I also
need to display these on my c# windows form, so the users can go straight to
a particular website. What is the best way to display the hyperlinks? Could
it be done in a list or DataGridView?
Many thanks 1 1963
Why not just store the string of the URL in the database? In addition
to that field, I assume you have to have another field with the name of the
file, or the type of the data stored in the field. If not, then how do you
know how to process it later?
In that other field, which has what kind of data is in the field, just
have a type in there that indicates the content is a URL.
I don't know how you could use the Insert Hyperlink dialog from Access.
If you are going to display the column contents, I would select the data
from the database, convert it to a string column (since it is binary, and I
don't know the encoding you are going to use), and then display that in a
custom data grid column which will act as a hyperlink. You would have to
create a custom column style for this already.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m
"jez123456" <je*******@disc ussions.microso ft.com> wrote in message
news:41******** *************** ***********@mic rosoft.com... Hi Experts
I have a working c# application that users can store files (.doc, .xls, .bmp, etc) as binary data into an Access database. I now need to extend this to also store hyperlinks.
First of all I need some way of searching for the hyperlink. In Access there is an Insert Hyperlink dialog that can be used. Is there a similar dialog in c#? At the moment I use the OpenFileDialog to select files to be stored, could this be modified?
If it's possible to store the hyperlinks in the Access database, then I also need to display these on my c# windows form, so the users can go straight to a particular website. What is the best way to display the hyperlinks? Could it be done in a list or DataGridView?
Many thanks
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Colleyville Alan |
last post by:
I have an application that has an Access table that stores the locations of
slides in a Powerpoint file. This used to work fine when there were about 4
files and 200 slides. The database would open all four PPT files at once,
and would loop through queriers for ever client and create custom
presentations. Now there are 8 files, nearly 500 slides and the computer is
bogging down with trying to open them all at once.
I know that Access...
|
by: Tim |
last post by:
Access 97: I have a table with a hyperlink field that I display on a form. I can
click on the form field and the hyperlink activates correctly.
However, if I try to activate the hyperlink using VB code, the last
hyperlink that was clicked is the only one that displays.
Background: The database is for providing instruction documentation
for shop-floor personnel in a manufacturing environment. The main
purpose of the database is to provide...
|
by: Seefor |
last post by:
Hi, I want my text hyperlinks to have a dotted border underneath, so I did
this which works fine:
a,
a:link,
a:visited,
a:hover,
a:active {
color: #000;
text-decoration: none;
|
by: Robin |
last post by:
Hello!
I'm having trouble with links and hyperlinks in MS Access 2003 - any
help would be great!
Question 1!
The "insert hyperlink" icon opens a browser window, allows the user to
browse to the desired file and paste the hyperlink on the form (which
obviously remains for on all the records). I am trying to create a
|
by: Gerhard |
last post by:
I have an application that needs to be able to upload documents that can
latter be accessed and opened by a hyperlink. I can do this easliy if I
store the files in a subdirectory in the application, but we will be using
multiple web servers, so the files need to be stored on a common file server.
Saving them is easy enough, but how do I point a hyperlink at a file on a
file server that is different from the web server?
Could you please...
| |
by: Janna |
last post by:
Hello tech savvy gurus! I hope someone can help me!
THE PROBLEM:
"Cannot open specified file" when I click on a hyperlink in an Access database when it is located on our server.
THE BACKGROUND:
I created a folder "Document Library" on my local drive, which contains document sub-folders and the database.
For referential integrity, I designed the database with relative hyperlinks (e.g. Folder\File.pdf). The hyperlinks worked perfectly...
|
by: mforema |
last post by:
Hi Everybody,
I have an Access table with a field filled with outdated hyperlinks. I also have an excel spreadsheet that is the master list for these hyperlinks. The spreadsheet will be updated by someone else whenever the links change. However, I don't always want to have to manually update my links whenever the spreadsheet is changed. Instead of manually updating 100's of hyperlinks, I would like to create a macro or something that will...
|
by: prinsipe |
last post by:
Hi all,
what i'm doing is showing/hiding hyperlinks depending on the hyperlink clicked. it is partially working. when i call step1, all hyperlinks are hidden. but then i call step2, single and mulitple is visible. the problem is when i call step1 again, it does not hide single and multiple hyperlinks. any idea to solve my problem? thanks in advance! below is my sample script...
function Step1()
{...
|
by: Frustratee |
last post by:
Sorry guys, this is killing me.
I have been fighting this issue for several weeks, to no avail. I am exporting the results of a query to an excel sheet, with one of the columns being from a field of hyperlinks that link to files on the shared drive.
I CANNOT get the hyperlinks to be assigned. I can change the field name, but not the hyperlink address. Can't figure it out.
1) I have a header row
2) Column 16 is where the hyperlinks are...
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
| |