Visual Basic

Christian Graus29-Sep-09 22:14

Christian Graus

29-Sep-09 22:14

I'm speechless. Please re-read my post. You need to buy a library, or find a library, or write a library. The end. There's no 'basic idea' I could put into a forum reply, except perhaps to type 'buy PDF library VB.NET' into google. Atalasoft has one.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Richard MacCutchan29-Sep-09 22:17

Richard MacCutchan

29-Sep-09 22:17

eg_Anubhava wrote:
Please send me basic idea for writing pdf document.

Christian already answered this. You need to either buy some converter software, or find a free version on the web. Search google and you will find many possibilities. If you wish to do it yourself through programming then you need to get a copy of the latest PDF specifications from the Adobe website. Either way it requires some small effort on your part.

Christian Graus29-Sep-09 22:29

Christian Graus

29-Sep-09 22:29

Richard MacCutchan wrote:
Either way it requires some small effort on your part.

And it's clear how that's likely to turn out....

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Richard MacCutchan30-Sep-09 0:12

Richard MacCutchan

30-Sep-09 0:12

Christian Graus wrote:
And it's clear how that's likely to turn out....

You have to Laugh | :laugh:

honymumu14-Mar-10 20:13

honymumu

14-Mar-10 20:13

Hi,you can convert word file,html to PDF file by pdf converter.Last week,a friend recommend Advanced pdf converter 6.0 to me,I am quite satisfied with it.It is very good in preserving the formatting. It also allow us to convert a lot files at the same time.
http://www.advancedpdfconverter.com/products/pdfconverter.html[^]

Anubhava Dimri14-Mar-10 20:41

Anubhava Dimri

14-Mar-10 20:41

Do You have any help of source related in vb.net or c# ?

If you can think then I Can.

Adding images from database to word document

Anubhava Dimri14-Mar-10 20:46

Anubhava Dimri

14-Mar-10 20:46

This application is develop by .net plateform.

If you can think then I Can.

krishnapnv29-Sep-09 16:44

krishnapnv

29-Sep-09 16:44

Hello All

I have my requirement as follows.
I have a MSAccess table with 4 columns(of text type)and another column of Oletype. I have programmed in VB.NET such that a query will returns a dataTable with all the columns from that table
What im trying is to put those contents on a word document with all the columns. For which I have tried to loop through the contents of dataTable and tried to attach all those values of all columns to a string and then I have added that string to a WordDocument Bookmark as shown below.

oDoc.Bookmarks(

"Questions").Range.Text = qest

But Im unable to get that image which was stored in database column in the above fashion. so can anybody suggest a solution for my problem

Thanks in advance

Re: Adding images from database to word document

Dave Kreskowiak30-Sep-09 1:57

Re: Adding images from database to word document

30-Sep-09 1:57

krishnapnv wrote:
oDoc.Bookmarks("Questions").Range.Text = qest

First, is an image a String?? Obviously, not. So this one line of code is not going to do it. You have to add the image to the document seperately. How do you do that?? i have no idea. I don't normally do Office Interop and am not very familiar with the Word Object Model.

A quick Google for "vb.net insert image into word document" reveals this list of examples[^].

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

krishnapnv1-Oct-09 5:13

krishnapnv

1-Oct-09 5:13

I agree that image is not an string ofcourse its obviously not. But what I was trying to explain is my requirement was like ...... I will explain it again

My MSAccesstable is having 5 columns of which 5th column is an image(it will be a small image like an icon etc and which was saved with the help of binary array i.e. after converting the image into a binary and then inserting that binary data into a oleobject type column) and rest are text columns. I have to get the contents of the table based on a query into a DataTable and then I have to place the content of the DataTable on a plain word document row by row

So what exactly I want is how to add that fifth column which is an image onto a word document

Re: Adding images from database to word document

Dave Kreskowiak1-Oct-09 6:16

Crystal Report Loading Failed.

1-Oct-09 6:16

You can repeat your requirements all you want. My answer does not change.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

read excel cell

viewsonic1229-Sep-09 15:28

viewsonic12

29-Sep-09 15:28

hi,
i want to have a program which can read specific excell cell. i am using VB2008.

for example, the user will have to enter the row and column and a messagebox will pop up with the result.

for example:
row : b
column: 2

the value in b2 will have to pop up in a messagebox.

thanks

Re: read excel cell

freakyit29-Sep-09 21:26

freakyit

29-Sep-09 21:26

private string GetCellValue(Excel.Worksheet sh,string col,string row)
		{
			// get value from the cell (column,row) 
			Excel.Range excelCell = (Excel.Range)sh.get_Range(col, row);
			if (!string.IsNullOrEmpty(excelCell.Text.ToString()))
				return excelCell.Text.ToString();
			else
			{
				return string.Empty;
			}
		}

waner michaud29-Sep-09 8:58

waner michaud

29-Sep-09 8:58

Hi,
Can anyone guide with this error message?

NewreportButton_click

dim rpt as new reportdocument
rpt.load("c:\report1.rpt")
crystalreportviewer.reportsource = rpt
crystalreportviewer.refresh

It throws an exception....Load report failed..

thanks,

Re: Crystal Report Loading Failed.

Paramhans Dubey29-Sep-09 22:27

Paramhans Dubey

29-Sep-09 22:27

Hi,

Have a look at this. it might help

http://social.msdn.microsoft.com/Forums/en-US/vscrystalreports/thread/a6e12469-2bf1-4c4f-b291-0cf06465b740[^]

Send Hex code by UDP

phil241529-Sep-09 6:02

phil2415

29-Sep-09 6:02

Hello,

I'm pretty au fait with VB.NET but a complete novice to programming anything to do with networking. I'm trying to replicate the behaviour of one small part of an application we have so that I can build my own application which will be much simpler for our staff to use to perform that one function. The application is a server program.

Anyway, using various network sniffers I've identified the packets that the application sends. It seems that when it starts up it broadcasts a UDP packet over the network, and then the clients respond with ICMP echos, after which further TCP packets are sent to the clients. Well, I'm stuck at the first hurdle!

I need, to begin with, to replicate that initial UDP broadcast. Using .NET and lots of Googling I've been able to produce code which will send a UDP packet to the right IP and port. What I'm struggling with is the data of the packet. Because I have the packet as captured in SoftPerfect Network Protocol Analyser (much more user-friendly than Wireshark for my money) I know exactly what the packet should look like and I can even copy the hex of the original packet.

I can't then simply stick this hex code into a string and send it over UDP, it doesn't work. Presumably it needs to be in some kind of array, but all the references I can find to this online seem to involve CONVERTING a string to hex or hex to bytes. Surely since I already have the hex no conversion should be necessary? I just want to send it exactly as it is! When I did convert it to a byte array (if that's the right term, this is very new to me) and then sent it the network sniffer picked it up and the data in the packet was very different and much longer than the original one I'm trying to replicate.

Any help or advice would be greatly appreciated, from general tips about replicating network packets to actual code I can copy!

Thanks in advance.

Dave Kreskowiak29-Sep-09 6:23

29-Sep-09 6:23

All packet data is just an arrray of bytes. Since you have the value of every byte, all you have to do is recreate that data in an array. It's that data that is going to get sent in the packet. Even if you supply a String, each character in the string if converted to a byte or set of bytes and sent as part of the packet. You have to values for each byte, they're just presented to you in Hexadecimal form.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Luc Pattyn29-Sep-09 6:26

Luc Pattyn

29-Sep-09 6:26

Hi,

there is nothing in TCP/IP or UDP that uses hex. It is all bytes, representing numbers; numbers aren't decimal or hex or octal, they are just a bunch of bits. Hex/decimal/octal is a human way to look at numbers, and it only exists as a string. Your sniffer is getting bytes, and showing them to you using a hex string (because that has a fixed length of 2 characters per byte), you should read each 2-character hex number as one byte value.

So if your sniffer sees "12CD" that would be two bytes, one with hex representation "12" (hence decimal value 18), and one "CD" (i.e. 205). So you would need a 2-element byte array, initialize it with 18 and 205 (or &12H and &CDH) and send it.

Smile | :)

Luc Pattyn

Local announcement (Antwerp region): Lange Wapper? Neen!

phil241530-Sep-09 0:42

phil2415

30-Sep-09 0:42

That's really useful, I think I understand now, thank you. But given what you've said what code would I need to actually convert my long string of hex code into a byte array that I can send by UDP?

phil241530-Sep-09 23:41

phil2415

30-Sep-09 23:41

Ok, with a lot more Googling and trial and error I think I finally cracked it!

Dim sText As String = "00 00 84 00 00 00 00 02 00 00 00 00 0A 4D 61 67 69 63 69 6E 66 6F 53 06 4D 4C 49 4E 4B 53 04 5F 75 64 70 05 6C 6F 63 61 6C 00 00 0C 00 01 00 00 00 00 00 1E 1C 31 33 38 32 35 33 31 35 32 30 39 31 30 30 39 32 30 37 4D 61 67 69 63 69 6E 66 6F 53 00 C0 17 00 0C 00 01 00 00 00 1E 00 02 C0 34"
Dim sData() As String
Dim iByte As Long, lByteCount As Long

sData = Split(Trim(sText), " ")
lByteCount = UBound(sData) + 1

Dim BData(lByteCount - 1) As Byte

For iByte = 0 To lByteCount - 1
    BData(iByte) = CByte("&H" & sData(iByte))
Next iByte

VS 2008 Setup

εїзεїзεїз29-Sep-09 4:40

εїзεїзεїз

29-Sep-09 4:40

Thanks in adv.

i have made one setup in VS 2008 to deploy a project having sql server 2005 as a back end and VS2008 as front end with default Crystal reports

I am getting this error when trying to run application but it runs fine where VS2008 is installed and no error comes

a network-related or instance-specific error occurred while establishing  connection to sql server , the server was not found or was not accessible, verify that instance name is correct and SQL server is configured to allow remote connections (provider : Named Pipes  Provider , error:40 could not open a connection to Sql Server)

Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

Dave Kreskowiak29-Sep-09 5:40

29-Sep-09 5:40

It would appear that either the SQL Server is not configured to accept network connections (which is default in a new installation) or the connection string is wrong somehow. Which version of SQL Server are you using? Is it an Express Edition? Does the database exist on the server?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

εїзεїзεїз29-Sep-09 6:24

εїзεїзεїз

29-Sep-09 6:24

Sql server 2005 , no its not express edition , problem is that on a same network it works fine and no error comes where vs2008 is installed and it could not connect on the PC where vs2008 is not installed

Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

Dave Kreskowiak29-Sep-09 7:34

29-Sep-09 7:34

What does the connection string look like?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...