|
virendra_007 wrote: Hi! All,
Anybody help me to suggest some method to read from large csv files having 20 columns and atleast 5000 rows in a single file.I cant use DTS packages for some reason. I am reading data from CSV file then Updating and inserting data in some tables. Right now I am reading these files line bye line and upadating database but it is taking hell lot of time.
What is the target database?
|
|
|
|
|
HI all..
A small help 4m u ppl...
I know how to build exe's for a Vb.net application.My doubt is how to add shortcut to the desktop atomatically .
I saw on Userdesktop Option ..but I dont know how to use it ...
pls help me ..its urgent..
Thanks in advance
Bino Varghese
|
|
|
|
|
Hi . What do U really want?
Regards,
Arun Kumar.A
|
|
|
|
|
pls see my ealier message I have explained u in detail...
|
|
|
|
|
Sorry, when I saw the first message , it just contained "hi".
Click Here.
Regards,
Arun Kumar.A
|
|
|
|
|
|
Have U seen the link "Click here" in my previous post?
Regards,
Arun Kumar.A
|
|
|
|
|
sorry Arun I think i was not too specific....saw ur reference mail...
let me explain u clearly now.....
with the help of setup project wizard I have created an Exe ..it is working fine... The problem with this exe is, I always want to go to my Programfiles and set a shortcut to the desktop...
there is an option User's Desktop how to use this??/
plz help me in this ....Im scratching my head 4m morning ....
|
|
|
|
|
The setup project in visual studio 2005 allows you to do this, google it. If you don't have visual studio 2005, then click once is pretty much only option other then 3rd party deployment software.
Posted by The ANZAC
|
|
|
|
|
yes Anzac I have learned of how to use setup project....
can u plz tell me how to add shortcut to desktop???
its urgent....
i went thru this article
http://www.startvbdotnet.com/extras/deploy.aspx[^][^]
but I didnt get the last point.....
pls guide me dude..
|
|
|
|
|
if you use Setup And Deployment Wizard to make your setup project then In the File System Window you will find a User's Desktop folder under File System on Target Machine.
1.Click it.
2.On the righthand Pane Right click > then click on Create New Shortcut A shortcut will appear....Rename it...You may set an Icon for it also......
Tirtha
Miles to go before I sleep
|
|
|
|
|
I have a vb.net application in which i have an add-in in the powerpoint. Now when i insert a new slide and right click on the "click to add title" or "click to add subtitle" i get a context menu pop up. I want to add my own menu items to this pop up. Can anyone suggest me how to do tht. I will be writing the code to add the menu items in the right click event of the pptapplication i.e
Private Sub pptApplication_WindowBeforeRightClick(ByVal Sel As Microsoft.Office.Interop.PowerPoint.Selection, ByRef Cancel As Boolean) Handles pptApplication.WindowBeforeRightClick
End sub
chakor
|
|
|
|
|
hi,
i want to store picture/image in MSAccess Database. Presently i store only path of the picture.
Do anybody have idea about what is the datatype for store the picture ?
any help will be appreciated
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
All you have to do is type "vb.net save image to access database[^]" into Google and you'll come up with dozens of examples.
But, since Access has a limited database file size, how you're doing it now would probably be the best way to do it. Of course, that's subject to your projects specifications and expected usage. For example, if you do a bunch of adding/deleting of the image records, it increases the need to compact and reapir the database on a regular schedule to keep the database file size down.
-- modified at 10:04 Friday 4th May, 2007
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
I'm having trouble bringing the other tabs of my TabStrip Control to the
front so I can work on them. VB Help says to use ZOrder or Hide/Show
(depending on source), but the sample code doesn't fix the problem for the
design view.
I have 4 tabs in my control and can only get to the first one. None of my
other references cover this.
What am I missing?
Vuyiswa
|
|
|
|
|
It's been about 6 years since I've touched VB6, so I may get this wrong. But, IIRC, all you had to do was click on each tab to get it to show it's page, in design view.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
Thats my problem,if you put a textbox, it will apear for all tabs. and when you draw a label, it wil not come on top of a Tab control
Vuyiswa
|
|
|
|
|
Vuyiswamb wrote: if you put a textbox, it will apear for all tabs.
Then the TextBox wasn't put on the page of the tab. It's actually sitting over the top of the entire TabControl.
This is usually caused by double-clicking the control in the ToolBox, then trying to move the control over the top of the TabControl. You MUST single-click the control in the ToolBox, then draw the control on the TabControl page. Click and hold the mouse button down on the TabControl and drag to draw the new control to size.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
i was doing some validations on textbox keypress function.The characters , i wanted to get typed is from 0 to 9.This got implemented by the code
if(e.keychar="0" or e.keychar="1".......... till 9)
e.handled =false
In addition to these , i wanted to remove the character , it it get wrongly typed .... and for that i am using the back space key.
Now my question is what should i assign to e.keychar= ???
so as to validate the back space key for keypress function of textbox.
|
|
|
|
|
hi Nilish , use followin code on keypress event of text box
If( (Not System.Char.IsControl(e.KeyChar)) And (Not System.Char.IsDigit ( e.KeyChar ) ) ) Then
e.Handled = True
End If
Hope this help
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
but where it is saying that on backspace key press i am making the e.handled=false.
|
|
|
|
|
hi Nilish,
note following line
not System.Char.IsControl(e.KeyChar))
Here IsControl include checks for all control key like Del,backspace etc.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Put this code in key press event of the textbox which has to control the input....
If Char.IsLetter(e.KeyChar) Then
e.Handled =
True
MessageBox.Show("blocking alphabets,plz enter only Numerics")
End If
If Char.IsNumber(e.KeyChar) Then
e.Handled =
True
'MessageBox.Show("blocking numbers,plz enter only Alphabets")
End If
hope this vl be helpfull to u
Regards
Bino Varghese.
|
|
|
|
|
actually i wanted to allow typing for 0-9 and for backspace key
for 0-9 have been implemented
but for back space to happen , still there exist a problem.
i don't know the code.
-- modified at 6:22 Friday 4th May, 2007
|
|
|
|
|
hi NIlish ,
i m not 100% sure .but try these values
BackSpace Key Value -8
Delete Key Value-46
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
