I just wondering can Itext done the following function before i dive into it.I want to develop a window application, and schedule this application in my server. This application should query the data from (oracle) and with itext help (i hope it help), generate pdf report. Then insert back to oracle as blob.
View 2 RepliesTrying to insert a large audio file into an Oracle 10g database and keep getting this error:
ORA-01460: unimplemented or unreasonable conversion requested
The byte array length of the audio file is 2702577. The procedure works with smaller array lengths, but not the larger ones.
Here is my code:
Dim oracleConnection As New OracleClient.OracleConnection
Dim Cmd As New OracleClient.OracleCommand
Dim oracleDataAdapter As New OracleDataAdapter
oracleConnection.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("MasterConnectionODT")
[Code] .....
I'm having problems with an Invalid Cast Exception when I try and read a PDF from a database as a BLOB. I am able to write the files into the database no problems at all,however, when I try to retrieve them I just get InvalidCastException.Here is the code I'm using:
Protected Sub btnPDF_Click(sender As Object, e As EventArgs) Handles btnPDF.Click
' Request.QueryString["docid"].ToString();
Dim docuid As String = "b39a443d-ccfd-47f4-b333-f12cd94683d6"
[code].....
I would like to insert several PDF files into oracle. I have been looking for some examples but i didn't find it.
View 1 RepliesI need to add a download counter to know how many times my BLOB data is read and displayed from the database (to determine traffic). How and where can I add this counter?
I have a dynamically generated list of links such as <a href="page.aspx?DocID=IDhere">Document filename</a> which direct to a display page.My display page code looks like:
Protected Sub Page_Load
Dim DocID As Integer = Convert.ToInt32(Request.QueryString("DocID"))
Dim connStr As String = conn string here
[code]....
I'm trying to read a BLOB from a SQLite Database.
View 3 RepliesHow do I store BLOB data (e.g. image, document) into the database?
View 1 RepliesASP.net app inserts Microsoft Windows 2007 .docx file into a row on DB2 OS/390 Blob table. A different VB.net app gets the DB2 OS/390 Blob data. VB.net app kicks off Microsoft Word to open the .docx file but then Microsoft Word pops up a message that the data is corrupted. Word will allow you to fix the data so the file can be viewed but it is extra steps and users complain.I've seen some examples where .docx can be converted to .doc but they only talk about stripping out the text. Some of our .docx have pictures in them.
View 1 RepliesI am recieving an error when I am trying to write a blob file to MySQL. figure out what I am doing wrong. Here is my code:
[Code]...
I have a mySQL table(IMP_SCANS) holding the file, it's name and size for every document:
scan_1 blob
description varchar
filesize int
doc_no varchar
doc_date date
I managed to insert a file to the table. Now I need to save the file to disk.
So I have the code:
Dim conn As New MySqlConnection
Dim cmd As New MySqlCommand
Dim myData As MySqlDataReader
Dim SQL As String
Dim FileSize As UInt32
Dim fs As FileStream
[CODE]............
I all works fine up to the line: myData.GetBytes(myData.GetOrdinal("scan_1"), 0, rawData, 0, filesize) Where it says "Object reference not set to an instance of an object". I cannot figure out why I receive this error.
I'm trying to zip a file that is stored on SQL Server as a blob image field and when downloading the zip file it says the file is corrupted.. or the file will open but contains some crazy characters. I've tried WinRAR and 7zip and no luck. I checked out [URL] and tried to kind of combine the browser attachment code and the memorystream/byte array code and no luck.
Here is my code snippet:
Try
BinData = DirectCast(dt.Rows(0)("ImageField"), Byte())
Catch ex As Exception
End Try
Dim blen As Integer = BinData.Length
[Code] .....
I'm trying to read a binary file from a FileMaker 11 container field using Filemaker's own ODBC driver. I was able to write files to the database and this works fine. retrieving them manually works fine and the files look OK and are not corupted. However when retreiving them using VB.NET, and if the file size is approx > 5MB, I get the following "uncatchable" error (yes thats right, I cant "Try Catch End Try", it just crashes):
System.AccessViolationException was unhandled
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
[code].....
I am creating a txt file which containing some data. I wish to create a form using vb.net with the browse button which browse my txt file into my sql server database. Can i know how can i do that?Besides, I can i insert picture as well using txt.file ? If not, can i know what is the alternative way ?
View 8 RepliesIve been trying to find a example for using itextsharp to create a barcode in vb.net. i have found a few C# examples. And apperently im not smart enough to convery the code myselfHere is an example. Perhave someone could tell me what to do to convert itI however would like to save the file as a jpg.
Quote:
# dfContentByte cb = writer.DirectContent;
Barcode39 code39 = new Barcode39();
[code].....
I need to insert data from Text File to SQL server database use VB.NET/ ASP.NET.
View 2 RepliesI have problem with my application I have a table with 3 columns: column1(numeric(18,0), allow null), column2(nvarchar(255), allow null), column3(datetime, allow null). I want to read data from a .csv file and insert it into database. I use 'bulk' to insert data from file .csv into database instead of inserting query. But the problem is: the .csv file have to be formatted as:
[Code]....
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[code]....
I am trying to achieve the following. I have a web page that I want users to upload a .csv file to, that places the file on a local server and then after that the file is then bulk inserted to a sql database. I can't get the file to save in the location mentioned in the script and I would like to do the bulk insert cleaner.
I just realized the OLD tutorial here is still works. Here is the webpage link But that one is iText 2005. And now is 2011, I wonder if there's any nearest version of iText for vb.net ? didn't found the iText for vb.net in 2008 version.... is there anyone could clarify this?
Because that 2005 version is using .Net framework 1 or 2. Very old... now I'm using version 3 & 4.
I have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
I'm about to pull my hair out on this guys I do not know where I'm going wrong but basically I receive a web request response formatted in XML and I need to insert that data into an SQLCE database. I have tried using LINQ queries but there are no matching ID fields to Join or Group.
View 3 RepliesI followed an example from a VB 2008 Wrox book on creating, binding and updating a data set but I am having a problem. The code is supposed to automatically generate the update/insert/delete statements for me (according to the book) but when I call the update command, the data is not saved.
Here is my code
Code:
Imports System.Data
Imports System.Data.SqlClient
Public Class FrmAddExpenses
[Code]....
After the form is loaded, I change the EntryDate field (which is a DateTimePicker) and close the form which should save the change but it doesn't work.
How do i create a pdf document in vb.net? which references must i add for my project to be able to create a pdf document? Does vb have it's own iText if yes how can i download it and where?
View 1 RepliesI have a text file data to insert into a database for report
ITEM01,Toy
ITEM02,Card
Let me briefly list down the steps i took to achieve my result.
1) Insert data into Database using text file
2) Display the records from the NEW Database(Item2) using DataGridView
3) Using datagridview, i use to checkboxes to determine the selectedRow
4) Once the selectedRow are selected. I press on Delete Button
Delete Button - Update the Item2 Table field 'Deleted' to 1 - Delete the ItemID by using datagridview selectedrow cell value Which means in 1 loop, i process two database transaction.. Is there something wrong? How do i shorten the process to just delete the item without querying two database.
How to correctly insert image data from XML file to database table using sql server CE and openxml,XML file is written by vb.net DataSet.WriteXml method?image data is stored in database table is :
0x89504E47.my XML file Content after written by WriteXml method is :
<?xml version="1.0" standalone="yes"?>
<Data>
<Table>
<image>iVBORw0KGgoAAAANSUhEUgAAAcIAAAGuCAYAAAADLg..</image>
</Table>
</Data>
but after inserting with openrowset and openxml using stored procedure to another database table its value changes to this :0x2F0039006A002F00340041004100510.and is not the first value and raises an error in vb.net for opening image from database.
I am looking at Visual Basic 2008 Step By Step. I need to read a flat file and insert the records into my SQL database. My code so far:
[Code]...
The INPUT line needs to be fixed. From what I can see, I need to move it all to a single field and use a split to parse it, correct? As I look at the entries on this site, all the code seems to use stream readers. Why would the book not do that? Am I missing something?
could someone tell me what i am doing wrong in this codeProtected Sub insert_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Insert.Click
[Code]...
Visual Studio 2008VB.NETFramework 3.5Windows Application
I have a SQL database names TestSQLVB
In it a table called tblTest2, with a three fieldstest2id , int, pk, increment by 1field1, varchar(50)field2, varchar(50)
I have a dataset named Dataset2.xsd
A tableadapter named tblTest2TableAdapter
A insert query names InsertTest2 with fields @f1, @f2 and ExecuteMode = Scalar
When I run the following code per MSDN [URL] the database does not get updated.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim testds As New DataSet2TableAdapters.tbltest2TableAdaptertestds.InsertTest2("One", "Dog")
End Sub
im in the middle of doing sql queries i can search my data base usingGetDateFrom (Select, from, where) Me.nameTableAdapter.FillBy(namenDataSet.descip, Me.box1TextBox.Text,Me.box1TextBox.Text, Me.box2TextBox.Text, Me.box2TextBox.Text)i have this working fine im struggling with inderting data to my databse i have made the query ..
INSERT INTO `details` (`Forename`, `Surname`, `Username`, `Password`)
VALUES (''& ForenameTextBox.Text &'', ''& SunameTextBox.Text &'', ''& UsernameTextBox &'', ''& PasswordTextBox &'')
[code]....
I will get an Excel 2003 file everyday via email. This file has 5 columns. The first for columns have static headers and text in them. The 5th column is the date of the report and below that is a list of values in the same column, followed by an empty row, and then the sum of all the values in the column.I would like to clean it up in the following manner:
Directly import the first 4 columns, without changing it. The date, which is the header of the 5th column, should be extracted and should form the entire 5th column in my table in the database. The values in the 5th column should form the 6th column in the database and the sum of the values should be ignored. Also, the number of rows is variable and so how to make the code relative? This is a file to which I will not have direct access to, nor can the format be changed.
why my insert doesn't insert into mysql database
[Code]...