Asp.net - Store Blobs / Rich Text Memos As Rtf Programmatically On Server Hard Disc Instead Of The Database?

Jan 14, 2011

is there a way to store blobs / rich text memos as rtf programmatically on server hard disc instead of the database ?

Update (1)

i want to write in a memo field and store it using identifiers like sessions and time stamps for example writing a memo with the session "subject" and session "dateANDtime" to be stored as "mysubject-12/12/2010-11:56pm.rtf"

how to retrieve the file. can i build hyperlink programmatically?

View 3 Replies


ADVERTISEMENT

Using A Rich Text Box To Store 10 Values?

Apr 8, 2009

I have a rich text box and i want to enter 10 values and I want to use this button I have to store it. How can I do this? Or can anyone link me to the Microsoft site with information about this? (this is visual basic in Visual studio 2008)

View 3 Replies

Rich Text Data To Store In Mssql Using .net?

Jul 23, 2009

I want to store rich text from vb.net to mssql database. My question is what will be data type in mssql to store rtf information.Also is there any free control availble to show basic buttons to conntrol formatting for rich text box like colors , fonts, etc. as i found standard rtf control in vb.net just show the text box and no way to format the text in rich text box.

View 2 Replies

VS 2008 Migrate BLOBs Out Of Database

Apr 27, 2009

I have a suite of programs that currently store PDF files as BLOBs in a SQL Server database table. The purpose of this design is to take advantage of Adobe's PDF iFilter and Microsoft's Full-Text Search functionality to allow other modules of my suite to run queries against the contents of a PDF file.This has been a huge headache, however, resulting in databases that are gigantic and unwieldy. We have also run into problems getting the Adobe PDF iFilter to play nice at times. Further, re-creating the entire full-text index on an 80 GB database can take a looooooong time (when it works at all!).So, the new idea is to use the open source XPdf library to extract a copy of the textual contents from each PDF file, and instead of storing the entire BLOB, merely store that textual data for the full-text functionality. Then, instead of storing the whole PDF file in the database, it will be stored somewhere on the server's file system.My issue relates to that last bit, storing the file on the server's file system, and the subsequent serving of that file out to remote users. Currently, with the entire BLOB residing inside of SQL, it has been very simple (though not easy) to manipulate the BLOB from the server to the client and vice versa. Sending the files across the network in chunks worked out well, too. I'm not sure how to do what I want to do now, though. I'm thinking that it's not a good solution to simply make a network share where all of the PDF files are stored and let the remote user view them by issuing a: Process.Start("{remote file share}filename.pdf")What I would LIKE to do is the following:

1. A Search is run, and the end user selects a file for viewing.
2. The SQL Server knows where the file resides on the local file system.
3. Something (on the server) issues a command to create a temp copy of the file at a safe location that is shared over the network.
4. The client's program then opens the file using a web browser.

Advantages:

1. The main body of the PDF files are protected and hidden from the prying eyes of those who shouldn't see them.
2. PDF files with Fast Web View enabled will load in a linear fashion, improving user experience.

Drawbacks:

1. I don't know what the "something" is in #3 above.
2. I don't know what happens when a file type other than ".pdf" is the target of the URL in a web browser. I know simple image formats will just open, but what if the file is ".doc/x". What about any other file type? Is it the same as issuing a "Process.Start("") to the UNC path?

View 5 Replies

Load Xml File In A Rich Text Box From A Remote Server To Program Form?

Dec 1, 2010

I have a windows app in vb.net , i am trying to read a xml file from my server(url...).I am able to read abc.xml . now i have a requirement to show abc.xml in a rich text box in vb.net and then i have to show node and its value in combobox. I am able to do this with a directory(suppose that file is in C:/abc.xml)[code]...

View 1 Replies

VB - Programmatically Checking A Hard Coded Checkbox?

Jan 18, 2009

OK, to make a long story short, programmatically generated data is taken back to the original page and the goal is to have this information cause checkboxes (hard coded into the aspx page) become checked.

Using feedback, the exclamation below confirms that I want the found control ctl to be checked:Dim ctl As Control
For Each ctl In form1.Controls

[code]....

I'm not sure what to put for XXX and my gut feeling is this is really easy. ading my question. I went through pages of search results on "VB Programmatically check checkbox" and found pages that should have had an answer that worked

View 7 Replies

Store And Retrieve Images In Sql Server Database?

Sep 9, 2009

SQL Server supports the ability for clients to store objects within tables.Create Field that data type Image and Initialize byte array with a null value initially.Use FileInfo object to get file size.Open FileStream to read file.Use

View 2 Replies

Unable To Load Rich Text Files Into Rich Text Box?

Jan 12, 2009

I am unable to load rich text files into my rich text box. It worked fine yesterday, would there have been anything I could have changed by accident?

With OpenFileDialog
.Filter = "Text format (*.txt)|*.txt|Rich Text Format (*.rtf)|*.rtf|All files (*.*)|*.*"

[Code]...

but I am getting the error File format is not valid when i attempt to open any Rich Text file

View 4 Replies

Store And Retrieve Images In Sql Server Database Using Picturebox?

Apr 22, 2012

store and retrieve image in a SQL Server database with vb.net.:Well, the application in vb.net seems to have a database which can accessed by the LAN computers so the SQL Server 2005 database allows remote computers to share its database once the other computer application requests database from the server.So, every other computer has to store and retrieve images in SQL Server 2005. For example, comp1 has to store images taken into the server and retrieve it like tableadapter.

I am using bindings and tableadapters to store the details in database and retrieving information from db. Please if you have code or anything which is working for me, please post it here... how to store image and retrieve it SQL Server through vb.net provided there's LAN computers who are also sharing the SQL Server database.

View 1 Replies

Forms :: Can VB Read Data From The Disc And Upload It To A Database

Apr 28, 2009

I'm developing an application that will take the data from a cd. This cd stores a .csv file. Can VB read this data from the disc and upload it to a database? Im not sure exactly where to start looking. Can someone point me in the right direction, as to what compnents i should be looking at.

View 9 Replies

Compare A Text Box Value With A Table (store In Sql Server)

Mar 31, 2011

i am working on a web site. i need to validate a text box value with a Column ( in table A, using sql server) .

well, the situation is. When user enter in textbox1 = 45 , before user go to textbox2 , textbox1 check in database if 45 is there. If not give error .

View 2 Replies

Store User Passwords In Sql Server Express Database In Encrypted Form

Sep 2, 2009

I use AES encryption in my vb.net 2008 windows forms apps to ....

1. Store user passwords in sql server express database in encrypted form

2. decrypt the encrypted Sql server express connection string password on the fly when connecting to SQl Server over a vpn or direct to web based sql server database

3. decrypt the encrypted ftp site password on the fly when my application connects to my ftp site to upload client's database backups

The issue I have is that the secret key for the encryption / decryption is hard coded within the encryption/decryption functions. So anybody who decompiled my application would be able to generate the same encryption, as they would have the encryption secret key How can you hide the encryption secret key so that if anybody decompiled my app they could not reproduce the decryption function

View 1 Replies

Rich Text Box - Load Specific Text In The Rich Text Box When The User Load The Form?

Apr 4, 2010

I have a rich text box which I use in order the user is able to add pictures, coloured writing, different font etc... however I need to load specific text in the rich text box when the user load the Form.how I can add (I guess) the HTML to load this every time the user load the form.

P.S the text will change depending on who loads the form so I can not do a simple

RichTextBox1.LoadFile("C:Documents and SettingsDesktopSigniture.rtf")

View 2 Replies

Store The Settings In A Text File Or Database?

Jan 2, 2010

I'm working on a project right now that basically prints a string to the field that has focus in internet explorer and there's quite a bit of user specified information that needs to load when the vb program loads. Should I use a text file to store and retrieve the settings or a database? I'm a new programmer and I don't really have a clear idea on when I should use a text file compared to a database or the registry to store info. Also, if I use a database like access 2007 for example, wouldn't an end user run into an exception if they don't have that software installed on their comp? Is there a universal database format? I've linked some screenshots of the prog if you want to get an idea of how much info I need to store.

[URL]

View 3 Replies

.net - Use A Nchar Column - Store Czech Text In An IBM819 Database?

Mar 2, 2012

switching our database over to UTF-8 (multi-byte char, unicode) encoding from IBM819 (single-byte char, Latin1 subset), because of a new requirement to support text entry of Czech characters.I've just been reminded by a colleague of the nchar and nvarchar column types, which neither of us has actually ever used.

If I were to define the relevant columns as nchar and nvarchar instead of char and varchar, what would I have to do to allow my currently-IBM819 database to work with this new IBM819-incompatible text coming in from my .net application?Would all conversion be automatic? Would I need to write some scary conversion code?

EDIT: Right, I defined an "nchartest" table containing a single column, "ntest" of type nchar(500).I connected to that via .net code and confirmed that 500 chars of lorem ipsum could be entered:

Dim insertString As String = "INSERT INTO nchartest VALUES (?)"
Dim insertCommand As New IfxCommand(insertString, cConnection, tTransaction)
insertCommand.Parameters.Add("incident_recno", IfxType.NChar).Value = "[lipsum]"
Return insertCommand.ExecuteNonQuery

I then replaced the lipsum string with 100 or so chars of Czech text, and attempting to insert that caused an IfxException to be thrown by the .net Informix interface, with the message ERROR [HY000] [Informix .NET provider]Unspecified System Error = -21005.

Following up on some research I did yesterday, I tried setting my CLIENT_LOCALE setting in my connection string to en_US to match that reported by Threading.Thread.CurrentThread.CurrentUICulture, but that connection could not be opened due to ERROR [HY000] [Informix .NET provider][Informix]Unable to load locale categories.

Following that, I tried setting CLIENT_LOCALE=en_US.unicode, which produced an ERROR [HY000] [Informix .NET provider][Informix]Unspecified System Error = -31142.

View 1 Replies

DB/Reporting :: OLE Database Access - Move My Programs And The Database To Another Computer And Hard-disks

Apr 21, 2008

I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?

View 3 Replies

Sql Server - Convert A SQL Database To A DBF Database Without Provider Using Text File?

Jun 8, 2011

I work with vb.net I have a sqlServer database and i need to migrate to a DBF database.I know that a dbf file sctructure is a hexadecimal text file.I want to generate this file without a provider...building this file with this hexadecimal structure.

View 1 Replies

Format Text - Rich Text Box - Where The User Will Be Entering Information - The Text Is Black

Aug 11, 2011

On the main form of my application, I have a Rich Text Box which is where the user will be entering information. The text is black. then, i have a button which calls the dialogue "Notes" A dialogue appears, with a rich text box. the user should then be able to enter text into the box, click "OK", and the text entered into the Notes dialogue be inserted to the rich text box on the main form -- with the font colour "Red". The rest of the text in the main rich text box on the main form should remain black.

View 2 Replies

Store Whole Numbers And That A String Is A Varialbe Used To Store Any Text?

Feb 19, 2009

i know that integer is a variable to store whole numbers and that a string is a varialbe used to store any text, but what variable type would you use to store a number that has decimals?

View 7 Replies

Store All These Files On The Server As Text Files?

Dec 14, 2010

I'm doing a project where we are re-creating a very old system.The client wants the same base functionality and some improvements.One of the things I'm currently working on is the note-system. These are used as flags of some sort, but are also used as a comment field for some products or client profiles.In the old system you could write the text and save it like you would get in a .txt file. They want the new one to be able to do word formatting such as:

Different font sizes (Only some parts of the text)
Different font colours (Only some parts of the text)
Underlining of words
Bolding
Italics
Tab-spaces

Those are the specs they want. What I need to know is the following:

1) How do I do that?

2) Currently they store all these files on the server as text files and the database have paths that refers to each file. I want to be able to save a text file with that formatting to the HDD of the server like in the old system.

3) If possible I would like to save that text to the database with the formatting.

View 1 Replies

VS 2010 - Rich Text Box - Getting User Text In The Text Changed Event

Jan 20, 2011

I'm Making a Simple syntax highlighter and I'm Doing the highlighting in the text Changed event of a RTB and for obvious reasons I can't re highlight the whole document each time someone presses a key so i highlight one line each time the text changes. But this creates a Problem. If someone pastes code into the RichTextBox It only highlights the last Line. So is there a way to get if the user typed the text in with his keyboard or pasted it from the clipboard in the text Changed event?

View 6 Replies

Winforms Saving Images To SQL Server Without Creating A File On The User's Hard Drive?

Jun 22, 2011

This is my first attempt at creating a Winforms application, and I have been developing in the .Net Framework (Silverlight, ASP.Net, WPF) for about 6 months. So, my appologies if this is a newbie question.

Basically what I am doing right now is taking the drawings of a stylus-based input, and storing them into an image field in a SQL Server database. Then, in another form, I go and get that image out of the database, and load it into a picture box. It works, but it is rather "sloppy" how it got there.When the user clicks save, it stores that image into a temporary folder, then converts it to a byte array and throws it into the database that way. Then, it deletes the file from the temporary folder. When retrieving it, it pulls it out of the database in a byte array, then converts it to an image in a temporary folder, thus displaying it on the form.

Is there a way that I can just bypass the storing of the file onto the user's harddrive both times, and go from byte array to picturebox?

View 2 Replies

Reading Blobs From Access Db?

Jun 14, 2009

i have to store and read pdf files in an access db. it seems not to work with larger files

the code for reding fom db:

[code]
Dim cn As New OleDbConnection(constr)
Dim cmd As New OleDbCommand("SELECT ....., cn)
cn.Open()

[Code]....

View 3 Replies

Insert Text To Rich Text Field At Text Cursor?

Mar 28, 2010

I have a question, how would i have a button, then when you click it, it puts the text at the text cursor in the RTF?

View 5 Replies

Simple Inventory - Program Using Classes Hard Coded - Database Named "DATABASE" In Ms Access 2003

Sep 29, 2010

I want to create program in vb2008 express with ms access database. Can somebody help me so i can learn how to program using classes hard coded. I have learned vb6 before but it has a big difference on vb2008.

I have a database named "DATABASE" in ms access 2003 and the details are: Table :

EMPLOYEE(EmpNo, EmpName), DEPARTMENT(DeptID, DeptName), CATEGORY(CategoryID, CategoryName), SUPPLIER(SupplierID, SupplierName), ITEM(ItemID, Itemname), ITEMLIST(ItemListID, ItemID, ItemDescription), INVENTORY

[CODE]...

All the CAPITALIZED name are Table and all items inside the parenthesis are fieldnames. I don't know where to start on working on this RECORDS. I was able to understand visual basic 6 a bit, and i am trying to apply the coding to VB 2008 but all i get is errors. I am hopeless now and i need help to be able to start my programs. If someone can give me a sample code, i think i would be able to trace the line of code to be able to understand it. I am currently an inventory manager on the small company i was working with and i like to organize my record by using database.

View 1 Replies

When Using MODI Printer / Sometimes It Prints 'blobs'

May 6, 2009

I have written a VB.NET program to open a word document and generate a .TIF file by printing it using the MODI printer. Usually the documents print fine. But, sometimes it appears as though all of the letters on each line are printed on top of each other which produces little square "blobs".[code]

View 1 Replies

Hard Coding Database Connection To My Application

Jun 18, 2012

how to hard code my database connect to my application . Example, i want to connect to my application using[code...]

View 3 Replies

One Sub Procedure / Change Text Color In Rich Text Box / Without Button Handler?

Oct 8, 2010

everyone! I've been at this for a while, and I'm not sure how this issue can be resolved:I'm working on a project in VB.Net, and I have a form with a rich text box. I have a groupbox with 4 radio buttons inside that are intended to change the font color of the text. Coincidentally, I have to repeat this same functionality for a 2nd set of radio buttons that would change the text font family.

At any rate what I've only been able to do is the following to successfully change the font color of whatever text I highlight in the rich text box:

Private Sub rbtnBlack_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles rbtnBlack.CheckedChanged
rtbxTextEditor.SelectionColor = Color.Black
End Sub
Private Sub rbtnRed_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles rbtnRed.CheckedChanged

[Code]...

Is there a way that I could write a sub (I'm assuming I would use a sub, since I don't think I need to return anything, thus eliminating the use of a function) that would handle the action of changing the selected text color in the rich text box without having to use a separate sub for each radio button? Mind you, per my teacher's specs, she doesn't use a button handler for any of this.

View 1 Replies

Make First 60 Characters In A Rich Text Box A Different Color Than The Remaining Text?

Feb 7, 2009

is it possible to make first 60 characters in a rich text box a different color than the remaining text?

View 25 Replies

Define Where MDB Database Is Stored In Local Hard Disk

Jun 10, 2009

VB.net seem to place my database file into/userprofile/local settings/apps/2.0/data/random/random/appname/data/ folder.Can I define easier location for my published app. I am also worried that when upgrading this database is ignored or something bad happens?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved