Visual Basic

Re: How to acccess database through VPN using Symbol Scanner phone.

5-Jun-09 4:33

The VPN connection should not be done in your app at all. This would tie your application to that specific VPN provider and make it pretty much impossible to change the VPN your company uses without changing your app.

Start the VPN connection from outside and seperately from your app, then start your app and it'll connect to the database without even knowing the VPN is there.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Clanguage5-Jun-09 4:36

Clanguage

5-Jun-09 4:36

It seems that I was going about it the wrong way. I will try that and see what happens. Many thanks to all. Thumbs Up | :thumbsup:

clanguage
Software Engineer

Is Data control or plain coding good for data accessessing in VB.Net ?

tiagu5-Jun-09 2:29

tiagu

5-Jun-09 2:29

I have a couple of doubts and need clarification

1) Is Data control or plain coding good for data accessessing in VB.Net ? Books said it was not good to program using data control (back in vb6 and so I was good at plain coding).

2) If Data control is okay can I use both Data control and plain coding (seperately, ofcourse) in the same project ?

It is my doubt for a long time and someone please clarify.

Thank you.

Suspicious | :suss:

Re: Is Data control or plain coding good for data accessessing in VB.Net ?

Dave Kreskowiak5-Jun-09 4:29

Re: Is Data control or plain coding good for data accessessing in VB.Net ?

5-Jun-09 4:29

tiagu wrote:
) Is Data control or plain coding good for data accessessing in VB.Net ? Books said it was not good to program using data control (back in vb6 and so I was good at plain coding).

Are you trying to learn VB.NET using an old VB6 book?? Don't. Pickup a book on VB.NET. It's VASTLY different and far better than VB6.

I have no idea what you're talking about when you say "Data control" and "plain coding". You're going to have to explain these for us to give you any kind of meaningful answer.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Henry Minute5-Jun-09 5:08

Henry Minute

5-Jun-09 5:08

tiagu wrote:
Is Data control or plain coding good for data accessessing in VB.Net ?

For a lot of data access scenarios, it is far better to use the inbuilt VB.Net Controls, as the coding effort required to implement their traffic reducing features and security alone , would be enormous. The .Net versions are far and away better than previous versions.

tiagu wrote:
can I use both Data control and plain coding (seperately, ofcourse) in the same project

Yes. But you will need to learn about the Currency Management features of .NET, at the very least, to ensure no interaction problems.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: Is Data control or plain coding good for data accessessing in VB.Net ?

tiagu8-Jun-09 1:10

tiagu

8-Jun-09 1:10

Dave and Henru, in VB6 we can add a data control to the form and then write little coding to make it work effeciently.   By plain codeing i meant interacting with database without using this data control.   I was reading VB.Net books and still assumed data control has to be dragged to the form like in VB6.

I am new to VB.Net.   And I naturally assumed I had to add a data control to the form for data interaction.   In the past 4 or 5 days   I have learnt through VB.Net documentation (this time carefully) that with inbuilt data control (as Henry said) we can code using data adapter, dataset and so on.

Now I think i am beginig to understand the answer to my own question (ofcourse with your help).

Thank you both for taking time to answer my pretty vague question.

Thank you once again with hearty gratitude.

Thank you Henry for your encouraging and sympathetic answer.   Thank you.

partial search in multi-column listview

atk88775-Jun-09 2:12

atk8877

5-Jun-09 2:12

hai everyone ,
well , i am trying 2 find a code in vb 2005 about how 2 search 4 string in a listview contains 4 column , whaterver if the complete (exact) word or a part of it , or even a single character , or a digit in each of these columns .
really i tried some codes but i cant figure it out , so if any one have a right code or example 4 this .. please tell me
thanx guys.

Re: partial search in multi-column listview

Dave Kreskowiak5-Jun-09 4:27

Re: partial search in multi-column listview

5-Jun-09 4:27

First, don't use TXTSpeak in the forums. It makes your posts hard to read and understand.

Next, You have to iterate through each item in the ListView yourself and probably use a Regular Expression to find the test your want.

No, I'm not writing your code for you.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Zaegra5-Jun-09 10:57

Zaegra

5-Jun-09 10:57

As Dave said, and you might find the .Contains(String) function of a string useful. Also, because if only one character matches (in your case), you can iterate through each character in a string and see if it matches any character in the given string. Good Luck! Big Grin | :-D

Zaegra

Motivation is the key to software development.

Crystal report using ttx in vb.net

Ageesh4-Jun-09 23:57

Ageesh

4-Jun-09 23:57

hi..

i am trying to develop a report using crystal report with ttx using vb.net 2005, in the first stage i created the report with data source as Field Definition Only. problem am facing is that how should i insert values to the ttx file. plz help me out in solving this..

How to access Word pages ?

Agarwaen594-Jun-09 23:14

4-Jun-09 23:14

Greetings !!!

I'm writing an app which has a WebBrowser where I'd like to open things like Word documents, pdf and djvu files etc.

The really BIG thing that I need would be to, say, open a file in the app's WebBrowser on a specific page.

How can I do it? Essentially I need to be able to access the document that is currently opened in MyWebBrowser and set it's page to, say, 4.

Any help would be greatly appreciated.

Christian Graus4-Jun-09 23:18

4-Jun-09 23:18

I'm not sure that you can. You would do better to use Word directly via the tool for office, instead of putting it in a web browser.

Christian Graus

Driven to the arms of OSX by Vista.

Please read this[^] if you don't like the answer I gave to your question.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

Agarwaen594-Jun-09 23:25

4-Jun-09 23:25

Unfortunately I HAVE to do it via the WebBrowser =(
But I can't seem to figure out how to get at the opened document's parameters. Maybe this info can be foun in WebBrowser.Document after I call WebBrowser.Navigate("C:\file.doc") ?

Christian Graus4-Jun-09 23:37

Re: How to access Word pages ? [modified]

4-Jun-09 23:37

I doubt it, that's going to give you a HTML document. I believe that Word is just opening inside the browser as a COM object, so that's probably empty. You realise that the user still needs to have Word installed ?

Agarwaen595-Jun-09 0:00

5-Jun-09 0:00

Thank you for your fast and meaningful replies.

Yes I do realise that the user would have to have Word, Adobe Acrobat etc installed in order to open the documents. However, this issue will be dealt with in the program requirements =)

Here's what I've tried to do and the results of my actions:
Bits of code:

Dim doc As HtmlDocument
wb.Navigate("C:\1.doc")
doc = wb.Document
MsgBox(doc.GetElementsByTagName("EMBED").Count.ToString)

And the result returned by msgbox is ZERO !!! So it seems your were right. So I guess I'd need to somehow get inside the MS Word that opens the document inside my WebBrowser and figure out the page that the document is currently on, is that right ?

EDIT: Hmm, MsgBox(doc.Body.InnerText) returns an empty string as well. So methinks the issue is inside the Navigate method and the way it opens documents.

modified on Friday, June 5, 2009 6:14 AM

Christian Graus5-Jun-09 0:14

5-Jun-09 0:14

Agarwaen59 wrote:
So I guess I'd need to somehow get inside the MS Word that opens the document inside my WebBrowser and figure out the page that the document is currently on, is that right ?

It's always good to know what you're talking about when you're defining requirements, so you can tell the client if what they want is possible. Yes, Word is still running, just inside the browser. You may be able to use the Office Tools to access your document ( I confess I've never used them )

Agarwaen595-Jun-09 0:20

5-Jun-09 0:20

Ok, i'll look into the Office Tools and see what I can do.
However, what should I do if user decides to open a pdf or djvu file on specified page ??? (A: shoot myself ?! $Shucks | :-\$ )

Dave Kreskowiak5-Jun-09 4:24

How to refresh datagridview?

5-Jun-09 4:24

Inside the web browser, you have no access to the viewer or the document it's showing. As far as I can find out, you cannot show a specific page.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

JC.KaNNaN4-Jun-09 20:59

JC.KaNNaN

4-Jun-09 20:59

hi,

i have one gridview,textbox and button in form
In Db contain Id,Name,Address

when i click the button show all information from db.
its working good.i need sort list the datagrid.
for example i have to enter A in textbox its automatically
sort list A names only(using like query). this also working good.

but already gridview contain 10 records.then added new search result also.
so i need to refresh datagrid n after search text.

thanks in advance

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Mail To : foreverkans@gmail.com

Christian Graus4-Jun-09 22:28

4-Jun-09 22:28

You just reset it's datasource to the new data you want to show.

JC.KaNNaN5-Jun-09 1:54

JC.KaNNaN

5-Jun-09 1:54

thanks..
i got solution....

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Mail To : foreverkans@gmail.com

Agarwaen594-Jun-09 23:27

4-Jun-09 23:27

Try this:
datagridview.Update()

JC.KaNNaN5-Jun-09 2:16

JC.KaNNaN

5-Jun-09 2:16

not working this method..

reset the data set. now perfectly working

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Mail To : foreverkans@gmail.com

Dave Kreskowiak5-Jun-09 4:22