How can we define a current path to fetch the database by OleDbConnection - Visual Basic Discussion Boards

First Prev Next

Re: Deployment

Vimalsoft(Pty) Ltd30-Nov-07 7:13

Vimalsoft(Pty) Ltd

30-Nov-07 7:13

hi prubyholl

its Easy, just go to your Projecty Explorer and right click, select a file system, in the file system view, select the Application Folder and if you see your controls , just right click in them and go to their properties and look for Hidden and select "true", and your controls will be hidden.

Hope this helps

Thanks

Vuyiswa Maseko,

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

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: Deployment

plural1-Dec-07 2:07

plural

1-Dec-07 2:07

Thank you very much

phatkin

How can we make setup file in VB.NET 2005 Professional

Selvakumar A.30-Nov-07 0:25

Selvakumar A.

30-Nov-07 0:25

hello friends,

if i want to make a setup file in VB.Net 2005 professional what are the steps i have to do for getting the setup file.

Re: How can we make setup file in VB.NET 2005 Professional

Colin Angus Mackay30-Nov-07 0:42

Colin Angus Mackay

30-Nov-07 0:42

You might want to look at this set of tutorials:

* Creating an installer using Wix v3.0, Votive and Visual Studio 2005/8[^]
* Creating an installer using Wix v3.0, Votive and Visual Studio 2005/8 - part 2, the GUI[^]

Upcoming FREE developer events:
* Developer Day Scotland

My website

Re: How can we make setup file in VB.NET 2005 Professional

Selvakumar A.30-Nov-07 1:04

Selvakumar A.

30-Nov-07 1:04

thnks friends....

thnks for ur help tonight i'll try it and ask if i have any doubt..

thnks a lot....

Re: How can we make setup file in VB.NET 2005 Professional

Frank Kerrigan30-Nov-07 0:47

Frank Kerrigan

30-Nov-07 0:47

There are wizards built into VS2005 which do this.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: How can we make setup file in VB.NET 2005 Professional

Selvakumar A.30-Nov-07 1:07

Selvakumar A.

30-Nov-07 1:07

thnks friend,

but will u specify which wizard will do it. bcZ i am new to VB.Net 2005

How can we define a current path to fetch the database by OleDbConnection

Selvakumar A.30-Nov-07 0:23

Selvakumar A.

30-Nov-07 0:23

hello friends,

i am doing one small project for an company,there they want to store the details of their customer.I finished it.but only thing is in my system i place the Database file in c:\ drive.so,i place the

cn = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\ABS.mdb")
if the company owner wants to change the file location to the current directory means each time he has to change the path or is there any way to tell or define the cuurent directory like VB.

in VB we give &APPPATH& like this any thing in VB.NET.

i am using VB.Net 2005 Professional version. Confused | :confused:

Re: How can we define a current path to fetch the database by OleDbConnection

Tom Deketelaere30-Nov-07 1:41

Tom Deketelaere

30-Nov-07 1:41

I'm not shure but I think you want the 'application.startuppath' this is the location on the hard drive where the exe of the programme is stored

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

The only way we learn is by making mistakes.

Re: How can we define a current path to fetch the database by OleDbConnection

selvabsc6-Dec-07 0:57

selvabsc

6-Dec-07 0:57

hai friend,

thnks but now only i am going to try it. after that i'll tell wheather it is working or not.... if it is not working then i'll tell the reason why it is not working.... what u said is crt in our field mistake will lead us to the crt path..

once again i'll thank u...

Re: How can we define a current path to fetch the database by OleDbConnection

ChandraRam30-Nov-07 1:42

ChandraRam

30-Nov-07 1:42

Selvakumar A. wrote:
in VB we give &APPPATH& like this any thing in VB.NET.

i am using VB.Net 2005 Professional version.

Google it - the first hit gives you an answer

Re: How can we define a current path to fetch the database by OleDbConnection

selvabsc6-Dec-07 0:55

selvabsc

6-Dec-07 0:55

hai friend,

thnks i got it but now only i am going to try it. after that i'll tell wheather it is working or not....

i think it i'll work....

once again i'll thank u...

binding an arry to listbox control

balakpn30-Nov-07 0:10

balakpn

30-Nov-07 0:10

hi i want bind the values in arry to a listbox like how we are going with dataset
could any one help me for this

with regards
Balagurunathan.B

Re: binding an arry to listbox control

Naji El Kotob30-Nov-07 10:05

Naji El Kotob

30-Nov-07 10:05

Hi,

I am not sure if I got you right, but to bind an array to a listbox you can do the following:

Dim arr() as string = {"A", "B", "C"}
Listbox1.Datasource = arr ' -> A, B, and C will be displayed in three items

Hope this helps Smile | :)

NajiCo http://www.InsideVB.NET[^]

It's nice 2b important, but it's more important 2b nice...
http://www.facebook.com/group.php?gid=5932660937[^]

VSTO

Tsepoz30-Nov-07 0:03

Tsepoz

30-Nov-07 0:03

Can someone help me on this one? am developing document management system and what i want to do now is after i deployed may application when am right clicking on the mail messsage or contact list to show me an option of sending that information to my application database.So basicaly i want to and an option on the dropdown menu when am right clicking on the two places i'have mentioned above.

SqlServerCe VISUAL STUDIO 2005 VISUAL BASIC help needed

panagiotis_mallis29-Nov-07 23:27

panagiotis_mallis

29-Nov-07 23:27

SqlServerCe VISUAL STUDIO 2005 VISUAL BASIC help needed.
From an application I get SqlServerCe DATA TABLE with multiple occurrences of the same records. I need VISUAL STUDIO 2005 VISUAL BASIC code to DELETE the records that are written more than once.

Cross-Post (3 forums)

leckey30-Nov-07 3:15

leckey

30-Nov-07 3:15

Current Rant: "CNN Has Some Explaining to Do!"
http://craptasticnation.blogspot.com/[^]

Re: SqlServerCe VISUAL STUDIO 2005 VISUAL BASIC help needed

Paul Conrad30-Nov-07 4:43

Paul Conrad

30-Nov-07 4:43

Don't cross post. It is considered rude.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

How to Bind a label from a Join

Vimalsoft(Pty) Ltd29-Nov-07 23:16

Vimalsoft(Pty) Ltd

29-Nov-07 23:16

Good Afternoon All

i have this an SQl join, and in my Dataset like this

Dim strSQL As String = "select count(p1.Property_ID)from Property p1  " & _
                                   "  where Not Exists" & _
                                   "  (select 1 from  Attribute_codes_test p2  " & _
                                   "  where p2.Attrib_code = Substring(p1.Attrib_code, 1, 8)  " & _
                                   "  and p1.Active= 1) "

.

i want to display it in a label, but i cant convert it to intiger, because i i cannot convert a dataset to intiger, so through a dataset i manage to carry the results of the above to my form, but now, when i try to Display this like this

lblCount.DataBindings.Add("text", mdscount, "Property.??????")

.

on the Above code, i dont know what to put where ???? appears because this comes from join. and i try to put an Existing field in my table like this

lblCount.DataBindings.Add("text", mdscount, "Property.Lis_key")

.

i get this Error

Cannot create a child list for field Property.

.

Thanks

Re: How to Bind a label from a Join

Usharva30-Nov-07 0:27

Usharva

30-Nov-07 0:27

Hi

you can try the below code

lblCount.DataBindings.Add("Text", mdsCount.Tables(0), mdsCount.Tables(0).Columns("ColName").ColumnName)

Re: How to Bind a label from a Join

Vimalsoft(Pty) Ltd30-Nov-07 0:57

Vimalsoft(Pty) Ltd

30-Nov-07 0:57

i get an Error that says

Cannot find table 0.

Thanks

Tree Control

Sipder29-Nov-07 23:10

Sipder

29-Nov-07 23:10

I want ot use tree node in my application and want to check if a particular node is clicked. How to do so?

Re: Tree Control

Christian Graus29-Nov-07 23:12

Christian Graus

29-Nov-07 23:12

What have you tried ? Did you read the MSDN help ? Did you try google ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

terminating VB6 application

"Ondra29-Nov-07 23:10

"Ondra

29-Nov-07 23:10

Hello,
I have a program consisting of four modules and three forms. When I try to terminate it using following sub:

Public Sub END_IT()
Unload Form1
Unload inicializace
Unload tech_krivka
MsgBox "applicaion terminated", vbInformation
End
End Sub

the MsgBox appear, but then the program get stuck and it's neccesary to quit it from TaskManager (where CPU usage 99% for the VB6.EXE is shown).
When made to .exe file, the situation is the same except CPU usage 0%.
thank you for your oppinion

Ondra Pokorny

Re: terminating VB6 application

Sipder29-Nov-07 23:15

Sipder

29-Nov-07 23:15

Why don't u write simply
"End"
insted of unloading all the forms?

Tell me if it works

Last Visit: 31-Dec-99 18:00 Last Update: 8-Jun-24 4:25

Refresh

ᐊ Prev 1...1967 1968 1969 197019711972 1973 1974 1975 1976 Next ᐅ

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