Re: Problem Retrieving a Connection String from App.Config - Visual Basic Discussion Boards

Christian Graus17-Jun-08 2:26

17-Jun-08 2:26

Ah... well, it's good to consider the forum you use, and how you word the question, so you can feel sure people will actually understand what you're asking.

Christian Graus

Please read this if you don't understand the answer I've given you

"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 )

Runtime Problem

monika_vasvani17-Jun-08 0:06

monika_vasvani

17-Jun-08 0:06

Hi ALl

I have one windows based application in vb.net.

when i place one button named as "Report" on form,it appears perfectly at design time but when run this application,i have not seen "Report" button on my
form.

what happened excetly?

pls help me

Thanks
monika

Re: Runtime Problem

Ajay.k_Singh17-Jun-08 0:33

Ajay.k_Singh

17-Jun-08 0:33

Check Visible property of button it has to be true, to be sure of it you may also set this property on Form load event.

-Ajay.

Re: Runtime Problem

~Khatri Mitesh~17-Jun-08 2:04

~Khatri Mitesh~

17-Jun-08 2:04

Hii Monika
Just check the button Location,Size,Visible property.
else delete the button and re add the new button.
May be it solve your problem
Thanx
Mitesh Khatri

Problem Retrieving a Connection String from App.Config

Vimalsoft(Pty) Ltd16-Jun-08 22:06

Vimalsoft(Pty) Ltd

16-Jun-08 22:06

Good Morning All

i have the Following App.Config file in VB2003 and a Windows Application.

<?xml version="1.0" encoding="utf-8"?>
<configuration>
	<appSettings>
		<!--   User application and configured property settings go here.-->
		<!--   Example: <add key="settingName" value="settingValue"/> -->
		<add key="timer.Enabled" value="True" />
		<add key="timer.Interval" value="1000" />
		<connectionstring>
		<add name ="Tshwane_Train"
		connectionString = "login=sde;Password=topology;Database=Tshwane_Valuations_Train;
		Server=SGIICORNETGS01"/>
		</connectionstring>
	</appSettings>	
</configuration>

and am Accessing this Connction string from the Vb App, like this

Dim constr As String = Configuration.ConfigurationSettings.AppSettings("Tshwane_Train")

When i compile the Application, i get no Errors ,but but when i try to run the application, i mean the Part that will need to Connect to the Database i get the Following Error.

An unhandled exception of

type 'System.Configuration.ConfigurationException' occurred in system.dll<br />
Additional information: Unrecognized element

What is Wrong

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: Problem Retrieving a Connection String from App.Config

Andy_L_J17-Jun-08 2:05

Andy_L_J

17-Jun-08 2:05

You might try something like this:

connStr = My.Settings.ConnectionString

Works for me.

I don't speak Idiot - please talk slowly and clearly

Re: Problem Retrieving a Connection String from App.Config

Vimalsoft(Pty) Ltd17-Jun-08 3:07

Vimalsoft(Pty) Ltd

17-Jun-08 3:07

hi man

Am i missing Something here, your My(.), intelisense does not recognise it, am creating a Windows Application. Are there any references that i missed ?

thanks

Re: Problem Retrieving a Connection String from App.Config

Vimalsoft(Pty) Ltd17-Jun-08 3:14

Vimalsoft(Pty) Ltd

17-Jun-08 3:14

At First i saw my e-mail with this Code from you

Public Sub initializeDataConnection()

        Dim strConn As String

        Dim settings As ConnectionStringSettings

        settings = ConfigurationManager.ConnectionStrings _
              (WindowsApplication1.My.MySettings.APPProdConnectionString")

        If Not settings Is Nothing Then
            strConn = settings.ConnectionString
            cn = New SqlConnection(strConn)
        End If

    End Sub

and when i click to go to CodeProject, i see a Different Answer, did you change it?

let us look at the above code, i understand what you are doing and in the Following line where you declare like this

Dim settings As ConnectionStringSettings

The ConnectionStringSetting is not recognised, am using VS2003 and VB(Windows App) is this Applicable to it?

Thanks

Re: Problem Retrieving a Connection String from App.Config

Mark Churchill17-Jun-08 3:14

Mark Churchill

17-Jun-08 3:14

Your app.config has a seperate section for connection strings. Have a google.

Mark Churchill
Director
Dunn & Churchill
Free Download:
Diamond Binding: The simple, powerful, reliable, and effective data layer toolkit for Visual Studio.

Re: Problem Retrieving a Connection String from App.Config

Vimalsoft(Pty) Ltd17-Jun-08 4:59

Vimalsoft(Pty) Ltd

17-Jun-08 4:59

i have Resolved the Problem

like this, the App.Congif File looks like this

<configuration>
	<appSettings>
		<!--   User application and configured property settings go here.-->
		<!--   Example: &lt;add key="settingName" value="settingValue"/> -->
		<add key="timer.Enabled" value="True" />
		<add key="timer.Interval" value="1000" />
		<add key="Tshwane_Train" value="User id=sde;Password=topology;Database=Tshwane_Valuations_Train;Server=SGIICORNETGS01"/>
    </appSettings>
</configuration>

and am Accessing it from my code like this

Dim constr As String = Configuration.ConfigurationSettings.AppSettings("Tshwane_Train")

And its working

Thanks for your Answer

Re: Problem Retrieving a Connection String from App.Config

Noctris18-Jun-08 0:39

Noctris

18-Jun-08 0:39

The "key" attribute (or node .. what is this thing anyway ?) does not have a connectiontring atrribute.

Use: <add key="keyname" value="value" /> and it should work...

you can skip the <connectionstrings> <connectionstrings /></connectionstrings> part too...

combobox Problem....

soniasan16-Jun-08 21:25

soniasan

16-Jun-08 21:25

I am working in window based application

funFillCombo_prod(CmbProduct, "select productid,product from product_master where status=1")
CmbProduct.ValueMember = "productid"
CmbProduct.DisplayMember = "product"
CmbProduct.SelectedIndex = 0

In function I fill the combobox ……… by dataset
Public Function funFillCombo_prod(ByVal cmbCombo As ComboBox, ByVal strsql As String) As Boolean
Try
Dim intI As Integer
If con.State <> ConnectionState.Open Then con.Open()
GDataAdapter = New SqlDataAdapter(strsql, con)
GDataSet = New DataSet()
GDataAdapter.Fill(GDataTable)
cmbCombo.DataSource = GDataTable.DefaultView
funFillCombo_prod = True
Catch ex As Exception
MsgBox(Err.Source & " : " & Err.Description, vbInformation, g_MSG_Title)
funFillCombo_prod = False
Finally
GDataSet = Nothing
End Try
Exit Function
End Function

Private Sub CmbProduct_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CmbProduct.SelectedIndexChanged
If CmbProduct.Items.Count > 0 Then
If CmbProduct.SelectedIndex <> -1 Then
MessageBox.Show(CmbProduct.SelectedValue.ToString())
End If
End If

End Sub

Problem is that in CmbProduct_SelectedIndexChanged I want valumember of a combobox

But msgbox which I write in that event is giving me the desired o/p but problem is that…
For two times I got this message System.Data.DatarowView. then I got the valuemember which I require,

Please tell me how to solve this System.Data.DatarowView. Problem

Re: combobox Problem....

Christian Graus17-Jun-08 2:09

Christian Graus

17-Jun-08 2:09

soniasan wrote:
Please tell me how to solve this System.Data.DatarowView. Problem

This means you have not set the ValueMember of the combobox, so it's showing the ToString of the object referred to

Re: combobox Problem....

SamRST18-Jun-08 4:40

SamRST

18-Jun-08 4:40

Set the Datamember and valuemember property of the combobox.

create temp file

Milind Panchal16-Jun-08 20:45

Milind Panchal

16-Jun-08 20:45

Hi,

how to avoid creating temp file after run the exe. of window application.

why temp files are created after running the exe

Thanks!

Re: create temp file

Ashfield16-Jun-08 21:08

Ashfield

16-Jun-08 21:08

Sorry, what temp files are you talking about?

Bob
Ashfield Consultants Ltd

Re: create temp file

Christian Graus17-Jun-08 2:09

Christian Graus

17-Jun-08 2:09

swami samarth wrote:
why temp files are created after running the exe

They aren't, unless your code creates them.

How to Insert and Update DateTimePicker to SQL Database vai DSN with VB.NET

Kosaly16-Jun-08 20:28

Kosaly

16-Jun-08 20:28

Dear All

Everyone can help to give the sample Application using VB.Net and SQL Database for Insert and Update data from DateTimePicker to table(date/time) in SQL Database.
I am looking forward from here as soon as posible

Please contact e-mail:kosal@hosting.com.kh
thanks
Best Regard

Re: How to Insert and Update DateTimePicker to SQL Database vai DSN with VB.NET

Christian Graus17-Jun-08 2:10

Christian Graus

17-Jun-08 2:10

Member 4227473 wrote:
Please contact e-mail:kosal@hosting.com.kh

That's not smart. No-one will email you, except spammers. If you gave CP this email, CP will email you when you get a reply.

The picker has a Value property, which is the date. The rest is sufficiently trivial that if you don't know, you should buy a book or read some articles on basic SQL and basic ADO.NET, I really don't know how to explain this and feel sure you understand me without writing half a book.

How to encrypt and decrypt MS-Access data using blowfish

charanbura16-Jun-08 17:54

charanbura

16-Jun-08 17:54

Hi friends.

I am working on windows application with vb.net Can any one help regarding this "How to encrypt and decrypt MS-Access data using blowfish "

Charan Big Grin | :-D

Re: How to encrypt and decrypt MS-Access data using blowfish

paas17-Jun-08 7:15

paas

17-Jun-08 7:15

I know you can find a variety of blowfish algorithm for .Net downloads on the Internet. Can you not just use what .Net has built-in via the System.Security.Cryptography namespace, or are you converting something that used to be encrypted with blowfish, and you prefer to continue with that encryption?

stup problem

asha_s16-Jun-08 13:02

asha_s

16-Jun-08 13:02

pleas i need help
i make setup to my program and all my content in the database is in English but when i done lode it in computer that its language is arbic all the number appear in arbic and it gives error

Re: stup problem

Christian Graus16-Jun-08 15:01

Christian Graus

16-Jun-08 15:01

Hard to answer. How are you setting up a DB ? What DB is it ?

Run an exe program from my VB application

Assaf8216-Jun-08 11:33

Assaf82

16-Jun-08 11:33

Hello
I want to run an exe program on my pc from my VB.Net application.
I use this code and it work but not in the panel where i want to see it. so any help will be greatly appreciated.
This my code:
"Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim proc As New Process()
proc.StartInfo.FileName = "D:\Program Files\Nero\Nero 7\Nero StartSmart\NeroStartSmart.exe"
proc.Start()
proc.WaitForInputIdle()
SetParent(proc.MainWindowHandle, Me.Panel1.Handle)
Me.Panel1.Visible = True
ShowWindow(proc.MainWindowHandle, SW_MINIMIZE)
End Sub"

And thanks in advance

Assaf

Re: Run an exe program from my VB application

Christian Graus16-Jun-08 11:35

Christian Graus

16-Jun-08 11:35

You can't run a program 'in a panel', this code just runs it.

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