Visual Basic

Tom Deketelaere17-Sep-07 23:37

17-Sep-07 23:37

you want to copy certain text I presume.

this will usualy work without any code (if windows is the OS)

if you want another action to happen you'll need to catch the keydown event and check wether the control key and the c key are pressed.

Another way (perhaps better/easier) is to add a menustrip to you'r form (put it invisible)

and then in code (or design):

Dim mnuselectie As New ToolStripMenuItem("selectie")
        mnuselectie.ShortcutKeys = CType((System.Windows.Forms.Keys.Control Or System.Windows.Forms.Keys.C), System.Windows.Forms.Keys)
        AddHandler mnuselectie.Click, AddressOf mnuselectie_Click
        msAlgemeen.Items.Add(mnuselectie) 'msalgemeen=menustrip on the form

then add code to mnuselectie_click

hope this helps

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistaks.

Prakash_Mishra18-Sep-07 0:07

Prakash_Mishra

18-Sep-07 0:07

hi

I want to perform a the action like
1) select a file.
2)click the button ( here i want to perform 3 actions CntrlA + CntrlC + CntrlV) that is select all + Copy + Paste.
3) The output will get paste in a specified word file.

So i want on a button click these 3 action to get performed. Pl help

Prakash Mishra(Banglore,India)

Tom Deketelaere18-Sep-07 0:18

18-Sep-07 0:18

I'll need a bit more information to answer this

the file is in wich format??
the file is on the hdd and you select it in you're programme or just in windows explorer??
the word file is specified in you're programme??
all the actions have to perform in sequence without any further user input??
you work with a button or a shortcut??
once the button is pressed you know the filepath and the word path??

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistaks.

Prakash_Mishra18-Sep-07 0:25

Prakash_Mishra

18-Sep-07 0:25

thanks lot for your patience.

1)the action ( CntolA + ControlC) i want o perform on a pdf file
2)I want to create a browse button which will give the path of the pdf file)I think i have to open the file before performing the CntolA + ControlC action.
3)Then the i want a button say the name is action ( which will perform the events sequentially select all(pdf) + Copy + Paste(in word)

Hope i am clear to u this time
Regards

Prakash Mishra(Banglore,India)

Tom Deketelaere18-Sep-07 1:13

18-Sep-07 1:13

in the button action you'll need to do the following:
access the pdf file (don't know for shure but I think you need a component for it and it's not cheap)
these articles might be of help for this:
http://www.codeproject.com/showcase/TallComponents.asp[^]
http://www.codeproject.com/cs/library/iTextSharpTutorial.asp[^]

once you can read the pdf file you should be able to select everything then you can add it to the clipboard:
Clipboard.SetText(pdf.selectedtext(or somthing))

then you'll need to open the word file (there are enough examples about this)
and paste the text:
word = Clipboard.GetText()
some articles for help:
http://www.codeproject.com/office/DocumentMaker.asp[^]
http://www.codeproject.com/office/WordInDotnet.asp[^]

hope this helps

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistaks.

what the options...

neo_bags17-Sep-07 20:39

neo_bags

17-Sep-07 20:39

hi friend,

i have a big problem which i dont know how to solve it,, it say's when i run the application "parameter is not valid"..and i look the error details that vb.net raise it about system.drawing.stream i run in visual studio .net 2005 i made it in vb.net then i deploy it to another laptop which is vaio model and windows xp prof. version 2002 sp 2 and it coz error..how can i fix that..is there a way to fix the problem...here's my code..

Public Sub LOAD_PICTURE_FROM_DBASE(ByVal i As String)
'Dim myconnection As New SqlConnection(My.Settings.CNString)
'Dim cmd As New SqlCommand("SELECT BLOBID, " & _
'"BLOBData FROM BLOBTest WHERE BLOBID=", DataGridView1.CurrentRow.Cells(0).Value)
Dim appRdr As New System.Configuration.AppSettingsReader
Dim myconnection As New Clsappconfiguration
'Dim myconnection As New SqlConnection(My.Settings.CNString)

Dim cmd As New SqlCommand
Dim da As New SqlDataAdapter
Dim ds As New DataSet

cmd.CommandText = "select * from Temployee_picture where idnumber=" & "'" & i & "'" 'i & "'"
cmd.CommandType = CommandType.Text
cmd.Connection = myconnection.sqlconn
myconnection.sqlconn.Open()

da.SelectCommand = cmd
da.Fill(ds, "Temployee_picture")

Dim c As Integer = ds.Tables("Temployee_picture").Rows.Count
If c > 0 Then
Dim bytBLOBData() As Byte = _
ds.Tables("Temployee_picture").Rows(c - 1)("picturedata")
Dim stmBLOBData As New MemoryStream(bytBLOBData)
emp_pic.Image = Image.FromStream(stmBLOBData)

Else
emp_pic.ImageLocation = Application.StartupPath & "\SplashScreen v3.jpg"
emp_pic.Load()
End If
myconnection.sqlconn.Close()
End Sub

that's the code that load picture from database...please reply me how to solve the this problem..parameter is not valid...

jhols

Re: what the options...

DanB198317-Sep-07 22:16

DanB1983

17-Sep-07 22:16

Hey

Firstly I cannot see where you are passing any parameters (only had a quick look are you planning on inserting them into the cmd string?) secondly you may be better using a stored procedure then adding the parameters eg:

cmd.Parameters.Add("@DOB", SqlDbType.DateTime).Value = DOB.Date;

Hope this helps

Dan

Re: what the options...

Tom Deketelaere17-Sep-07 23:09

How , when and where and why use DALL and BLL in VB.net

17-Sep-07 23:09

the error suggests that there is something wrong with the sql string.

did you try the sql string directly into the server?

my first idea would be to check the datatype of idnumber if it is a number (as the name suggests) then there is you'r mistake since you are trying to pass a string to it.

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistaks.

Vimalsoft(Pty) Ltd17-Sep-07 20:14

Vimalsoft(Pty) Ltd

17-Sep-07 20:14

i was new in vb.net,and have explored and grew because of CodeProject and the books i bought and articles on the net. previous i got small projects that did not need a Dall and Bll, am afraid because i have been moved to large projects.So i need to learn BLL and DAl, how they work , how they commnicate, structuraly where and how to code them, and where to place them. i was looking at ASP.net DAL and BLL code, i understood, but am building desktop Applications. i would like anyone to point to an article or E-book to explains Dal and BLL for vb.net Desktop Application, that has to do with Database Programming.

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com

Re: How , when and where and why use DALL and BLL in VB.net

DanB198317-Sep-07 21:58

DanB1983

17-Sep-07 21:58

The DAL and BLL will be the same as if you were doing a web app (pretty much) so for example you will have user inputs a string and clicks ok, this will get passed to say a user BLL object that in this case may format it (over simplified) which will then pass it to a user DAL object that will persist the data to your data store. No doubt the tutorials you looked at where at www.ASP.net so you can do the same with a desktop app but replace the User Interface (thats the beauty of an n-tier approach)

Hope this is of use

Dan

Re: How , when and where and why use DALL and BLL in VB.net

Vimalsoft(Pty) Ltd17-Sep-07 22:17

Vimalsoft(Pty) Ltd

17-Sep-07 22:17

Thanks

very much it helps

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com

export data from sql Server into Excel in text format with Visual Basic 6.0

suveenmohan17-Sep-07 20:08

suveenmohan

17-Sep-07 20:08

Hi All,
I want to export data from sql Server into Excel in text format with Visual Basic 6.0. Becoz there are some value which are convert into date at export time, but actual value like 1144/05-06. If any one have some idea plz help me.

Thanx & Regards
SMK

Re: export data from sql Server into Excel in text format with Visual Basic 6.0

Dave Kreskowiak18-Sep-07 5:53

Dave Kreskowiak

18-Sep-07 5:53

A little Google goes an awfully long way[^].

A guide to posting questions on CodeProject[^]

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

ToolStrip Control has to work like vs2005 ToolBox

VB 8.017-Sep-07 19:42

VB 8.0

17-Sep-07 19:42

Thanks For Replying ,

Now i am able to move the runtime controls on the form and place any where , no problem with that .Now i am in doing the things like these::

1) Setting the properties of those runtime controls
2) When i mouse down on that particular runtime control it has to display rectangles on edges of the control and able to resize the control.

I am searching the net . i got some answers ,But Trying if u have any resource links Give to me please ..

Regards

D.V.Sriram

Re: ToolStrip Control has to work like vs2005 ToolBox

Dave Kreskowiak18-Sep-07 5:49

Dave Kreskowiak

18-Sep-07 5:49

There is no property to turn any handles on. You'd have to embed the control you dropped in a container control, bigger than the control you dropped, and draw the handles yourself on the container control.

A guide to posting questions on CodeProject[^]

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

Removing tables froma pdf file using VB application

Prakash_Mishra17-Sep-07 19:04

Prakash_Mishra

17-Sep-07 19:04

HI all

I am working on a application where i am taking PDF file as source and writing it into a text file. My problem is i don't want the tables from the pdf file, I just want the paragraphs.

My final output in text file should only contain paragraphs ( i just want to escape the table part). Can any one help me out, I tried in Google searching for any solution but all provides way to extract the data. I want some kind of filter mechanism in my VB application. It would be great if any one can provide the code.

PL help
Regards

Prakash Mishra(Banglore,India)

Re: Removing tables froma pdf file using VB application

Dave Kreskowiak18-Sep-07 5:50

Dave Kreskowiak

18-Sep-07 5:50

I'd imagine this kind of functionality would be exposed by the PDF library you're using??

I don't use any of them, so I really couldn't tell you. But I'd probably start by researching how the PDF document is exposed by the library and search for anything that might describe the document in sections or if it exposes any kind of Select and/or Copy methods that allow you to specify text only.

A guide to posting questions on CodeProject[^]

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

Tab Control

vidya11017-Sep-07 18:58

17-Sep-07 18:58

I have a Tab Control with 3 tabPages i have a button in first Tab page when i click the button it has to show me the 2 tab page
Could anyone help me

Thanks in Advance Blush | :O

Vidya

Re: Tab Control

helelark12317-Sep-07 19:55

helelark123

17-Sep-07 19:55

I don't think that is it possible.
'Enabled' and 'Visible' TabPages in Tabcontrol don't exist.
I search for this a lot and in some site they say same thing.

One solution for you could be to work with frames instead.

Shay Noy

Re: Tab Control

vidya11017-Sep-07 20:07

Re: Tab Control [modified]

17-Sep-07 20:07

Thank u for ur reply

But we have a option like the code below

Me.TabControl1.TabPages.Item(2).Show()
this is not working can u help me out to know what may be the problem
I am trying this because in Vb.net 2003 its possible Blush | :O

vidya11017-Sep-07 20:19

hiding mouse cursor in window form

17-Sep-07 20:19

Thanks a lot for trying
I got the Solution

TabControl1.SelectedTab = TabControl1.TabPages.Item(1)

or

TabControl1.SelectedIndex = 1

Blush | :O

Re: Tab Control

helelark12317-Sep-07 20:25

helelark123

17-Sep-07 20:25

following your reply, I understand right now your question.
I thought that you want to make visible the 2 others tabs after clicking on the button, and that is not possible.

When you said visible you mean select them.

Try to be more clear at next time, you may saved time because I knew how to do it before.

Shay Noy

Abbhie17-Sep-07 15:47

Abbhie

17-Sep-07 15:47

hey guys,
kindly help me here. i'm a beginner in using vb.net. so i'll just ask a very simple question,hope you can help me here..

How can i hide my mouse cursor on one of my forms. I add a splash screen on my project, then my mouse cursor still shows even if i already inputted use showcursor(false) on my form's code. i think i had a problem with my code i got from the internet that says "use the API".

Can you give me a full code and on how will i use it on my project?

Thanks a lot guys.. Big Grin | :-D

Re: hiding mouse cursor in window form

vidya11017-Sep-07 19:37