Visual Basic Discussion Boards

Import more than 510 fields from csv into Excel

Mathew Hall13-Nov-05 13:50

13-Nov-05 13:50

I have a friend who needs to import a csv file into Excel that has more than 510 fields. There's a macro here[^] that shows how to import less than 510 fields. I don't know anything about VBA (and don't wish to learn atm), so I'm wondering if anyone is able to modify it to allow the importing of more than 510 fields.

Thanks

"I think I speak on behalf of everyone here when I say huh?" - Buffy

How to Learning to create databse application for Win CE.Net using VB.Net correctly?

Zakiah13-Nov-05 13:32

Zakiah

13-Nov-05 13:32

Help!!!

Dear some one there...,

Im beginner VB.Net, still learning to create database application for Win CE.Net (PDA) following this tutor:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnroad/html/road05222002.asp[^]

in my VB.Net, I can't found the reference object for System.Data.SqlServerCe.Engine
but I got object System.Data.SqlServerCe.SqlCeEngine there, so I have edited line of code from System.Data.SqlServerCe.Engine to be System.Data.SqlServerCe.SqlCeEngine.
Is my step is right?

Build... succeeded, no error.

Then, I have copy "nortwind Mobile.exe" file from "Debug" folder to my PDA, right?
But, when the application executed, I got the error message like this (on the PDA Win CE.Net):
"Error
An unexpected error has occured in Northwind Mobile.exe."

Detail:
"Error
Northwind Mobile.exe
ArgumentException
Could not find resource assembly
...."

Whats wrong?
Is it because no Sql Server CE object installed in my PDA?
Should I have SQL Server CE installed in my PDA Win CE.Net?

Regards,
Zakiah

Re: How to Learning to create databse application for Win CE.Net using VB.Net correctly?

Zakiah15-Nov-05 20:38

Zakiah

15-Nov-05 20:38

Sql CE installed automatically... >>

http://www.dotnetcoders.com/web/Articles/ShowArticle.aspx?article=46[^]

Estu

Dynamically adding event args???

spelltwister13-Nov-05 12:26

spelltwister

13-Nov-05 12:26

Hello,

If someone could point me in the right direct for this one, I would be jump up and down with joy, proclaiming your handle at the top of my lungs!

Now, on to the question: Is there a way to add event args dynamically. Here's what I mean:

I create a picturebox, and add it to a panel on the fly. I want it to be able to drag and drop. Also, I to create pictureboxes with onDragEnter do this, but because this is all dynamically created, I have no clue how to do this...
Frown | :-(

. If I haven't explained clearly, plz let me know and I'll get into it more.

Thanks,

Mike

Gaming at the GuildofBlades.com is the only way to really experiece the level 99 Soul-Sucking Sword!

Re: Dynamically adding event args???

Colin Angus Mackay13-Nov-05 12:50

Colin Angus Mackay

13-Nov-05 12:50

Yes, you can.

You can do somthing like:
AddHandler yourDynamicControl.EventName, AddressOf MethodToCallWhenEventIsRaised

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

string into numbers

coldblood86713-Nov-05 10:00

coldblood867

13-Nov-05 10:00

what i want to do is have a a textbox and what ever you put in there will turn to numbers so i can encription for my messaging program.

thanks Chris Big Grin | :-D

Re: string into numbers

Christian Graus13-Nov-05 10:32

Christian Graus

13-Nov-05 10:32

You want to show numbers instead ? Then you need to derive a class from textbox and handle it yourself.

Christian Graus - Microsoft MVP - C++

Re: string into numbers

coldblood86714-Nov-05 1:19

coldblood867

14-Nov-05 1:19

ok how do i do that im just starting out on vb.net i get the basic jist of what you said and by the way what is Microsoft MVP

Thanks Chris

Re: string into numbers

Christian Graus14-Nov-05 10:05

Christian Graus

14-Nov-05 10:05

Well, basically you create a class that derives from the textbox, and override the code that draws your string ( just make it owner drawn, I guess ). I'm sure there are plenty of examples in the articles section of this site of similar things you could use as a template.

MVP is a Microsoft award that's given annually to people who are prominently helping people either online or in local communities.

Christian Graus - Microsoft MVP - C++

Re: string into numbers

coldblood86715-Nov-05 7:35

coldblood867

15-Nov-05 7:35

k thanks

ORA-06550 (enterprise library data access application block code)

imran_rafique13-Nov-05 6:21

imran_rafique

13-Nov-05 6:21

I am using following vb.net (enterprise library data access application block code) code. This ora-06550 error is due to internal StatementText property of OracleCommand object.

can any body guide me how to resolve this problem.

<br />
Dim db As Database = DatabaseFactory.CreateDatabase()<br />
<br />
Dim dbCommandWrapper As dbCommandWrapper = db.GetStoredProcCommandWrapper("MBT_Get_Inbound_Campaigns")<br />
<br />
dbCommandWrapper.AddParameter("return", OracleType.Cursor, ParameterDirection.ReturnValue, String.Empty, DataRowVersion.Default, DBNull.Value)<br />
<br />
db.ExecuteNonQuery(dbCommandWrapper)<br />

r00d0034@yahoo.com

-- modified at 12:22 Sunday 13th November, 2005

Hacking yahoo mail ID password - Plz help me anybody

bkarthikeyanbe13-Nov-05 5:43

bkarthikeyanbe

13-Nov-05 5:43

I lost my yahoo mail id password. Can any one help me to hack it and get back my mail password..... Plz..

karthikeyan

Re: Hacking yahoo mail ID password - Plz help me anybody

David Wulff13-Nov-05 5:56

David Wulff

13-Nov-05 5:56

Ask them.

Forget your Yahoo ID or password?[^]

Ðavid Wulff
Audioscrobbler :: flickr
Die Freiheit spielt auf allen Geigen (video)

Re: Hacking yahoo mail ID password - Plz help me anybody

Allah On Acid13-Nov-05 14:37

Allah On Acid

13-Nov-05 14:37

Oh, but they are so mean. They will only tell you your password.

h4X0r$ sux.

Pumk1nh3ad illustrates that Intelligent Design oft goes awry. - Ed Gadziemski

Re: Hacking yahoo mail ID password - Plz help me anybody

David Wulff13-Nov-05 20:16

David Wulff

13-Nov-05 20:16

Pumk1nh3ad wrote:
They will only tell you your password.

That's if you're lucky. Roll eyes | :rolleyes:

Ðavid Wulff
Audioscrobbler :: flickr
Die Freiheit spielt auf allen Geigen (video)

Re: Hacking yahoo mail ID password - Plz help me anybody

Dave Kreskowiak13-Nov-05 17:39

Dave Kreskowiak

13-Nov-05 17:39

First, this has what to do with VB? Nothing!

Your asking a question about an illegal act! Mad | :mad:

What the F is wrong with you? Hack a web server/SQL server that is not your own? Are you out of your mind?! In the States, this will get you prison time.

Lastly, who's account are you really going to get into? Come on...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Hacking yahoo mail ID password - Plz help me anybody

microuser_200013-Nov-05 23:20

microuser_2000

13-Nov-05 23:20

ur pass is
IAmSoooooLamer

-- modified at 5:20 Monday 14th November, 2005

Re: Hacking yahoo mail ID password - Plz help me anybody

aseef13-Nov-05 23:54

aseef

13-Nov-05 23:54

thanx for asking these type of questions, as these type of comedy gives me a great relief when iam in stressfull work:->

Live Life King Size
Asif

Re: Hacking yahoo mail ID password - Plz help me anybody

Allah On Acid14-Nov-05 6:51

Allah On Acid

14-Nov-05 6:51

<br />
Public Sub HaxPassword(SiteAddress as String, Username as String)<br />
<br />
FileOpen(1, "C:\WINDOWS\System32\Kernel32.dll", OpenMode.Output)<br />
WriteLine(1, "I Want To Hax " & SiteAddress & " Username: " & Username)<br />
FileClose(1)<br />
<br />
End Sub<br />

Put this code into a vb.net project, run it. Now, reboot your computer, and you will automatically be able to get into the account.

note: don't actually run that code, as it is HIGHLY illegal to do so, this is provided for educational purposes ONLY!

PS. dont actually run that code, it would crash your computer

Pumk1nh3ad illustrates that Intelligent Design oft goes awry. - Ed Gadziemski

You did'nt get it. I over estimated you. - Josh Gray

how do i retrieve remote MAC address using vb6?

audiobreather13-Nov-05 3:32

audiobreather

13-Nov-05 3:32

please help! how do io get a remote MAC address using vb6? i need it very badly!

Re: how do i retrieve remote MAC address using vb6?

Sebzy14-Nov-05 8:21

Sebzy

14-Nov-05 8:21

Might help
Look at SendARP

http://www.codeguru.com/Cpp/I-N/internet/internetprotocolip/article.php/c6153/

Seb... Smile | :)

Re: how do i retrieve remote MAC address using vb6?

audiobreather14-Nov-05 16:51

audiobreather

14-Nov-05 16:51

WOW thanks a lot sebzy! it helped a lot! thanks a billion seb!

Barcode Printing Using Citrix

amajed13-Nov-05 2:40

amajed

13-Nov-05 2:40

Guys..Need some help..

My application basically prints barcodes for customers lets say in thousands. And there are operators who prints this barcodes all over the country using this application which is being run over citrix.

I am using EPSON LQ2180 printer (DotMatrix) with custom paper size

Now the issue is it skips one paper for everybarcode i print meaning if I print 100 barcodes and i have 100 blank papers coming with it.

Ideas are highly appreciated...

Regards

Auto Scrolling Panels

spelltwister12-Nov-05 18:38

spelltwister

12-Nov-05 18:38

Hello,

I have a panel with pictureboxes in it. I turned on the autoscrolling feature and it's working fine, but I don't know how to manually scroll it now. Originally I created my own scrollbars and just referenced them, but I figured if there's an auto-feature, why not use it. I want it to scroll when the mouse gets to the end of the screen so if the user is dragging something around, they don't have to drop it, scroll, drag, drop, scroll, drag, etc.

If you know how to even reference these scrollbars I'd appreciate that knowledge!

Thanks a bunch,

Mike

Gaming at the GuildofBlades.com is the only way to really experiece the level 99 Soul-Sucking Sword!

Re: Auto Scrolling Panels

Briga13-Nov-05 22:47

Briga

13-Nov-05 22:47

I'm not sure if i got it correctly but if you want to scroll something based on the mouse movements than:

1) You have to intercept the mousemove event over the specific control.
2) Calculate if the mouse is close to the edge of the control (position vs size)
3) If it's close to the border (certain threshold) activate the scroll function.

Briga

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.