|
You might try something like this:
connStr = My.Settings.ConnectionString
Works for me.
I don't speak Idiot - please talk slowly and clearly
|
|
|
|
|
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
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
|
|
|
|
|
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
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
|
|
|
|
|
Your app.config has a seperate section for connection strings. Have a google.
|
|
|
|
|
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: <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
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
|
|
|
|
|
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...
|
|
|
|
|
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
|
|
|
|
|
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
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 )
|
|
|
|
|
Set the Datamember and valuemember property of the combobox.
|
|
|
|
|
Hi,
how to avoid creating temp file after run the exe. of window application.
why temp files are created after running the exe
Thanks!
|
|
|
|
|
Sorry, what temp files are you talking about?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
swami samarth wrote: why temp files are created after running the exe
They aren't, unless your code creates them.
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 )
|
|
|
|
|
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
|
|
|
|
|
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.
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 )
|
|
|
|
|
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 
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
Hard to answer. How are you setting up a DB ? What DB is it ?
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 )
|
|
|
|
|
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
|
|
|
|
|
You can't run a program 'in a panel', this code just runs it.
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 )
|
|
|
|
|
Hi,
I am working on a software in VB.Net where I am dynamically making .Htm files.
The .Htm file has been generated from Excel. Then I am changing tags/data in the file from a database.
I am experiencing something completely weird. When I open the dynamically created file in Mozilla, it shows me the complete stuff and adjusts Row heights according to the Data inserted.
But the IE refuses to change the format, no matter what I do.
I am attaching a text file which contains the HTML code.
If you rename the text file to .Htm, and open it up with Mozilla, you will notice that it shows you the complete stuff.
However, with IE, the embedded cell size does not change.
I don't know if there is anything that could be done.
Please let me know at the earliest.
Thankx
Kazmi
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<title>CLSID : 1122334455
Technical
Support Soft-Skill Coaching Sheet | CLSID | 1122334455 | Case ID | 5544332211 | Call
Date | 5/9/2008 5:08:53 PM | Case Reason | Stat - Wiring | Audit
Date | 5/9/2008 5:16:30 PM | Product Family | Thermostats - Retail / Residential | | Auditor Name | S. B. A. Kazmi | Customer Name | S. B. A. Kazmi | | A | Call Flow | Score | Reason for Defect | | A.1 | Greeting & Customer
Data/Opening the Call | 6 | | | A.1.1 | Opening was professional and
upbeat. | 2 | | | A.1.2 | Zip code, Phone Number &
Full Name | 2 | | | A.1.3 | Product Name/ Model Number/Date
Code | 2 | | | A.2 | Call Purpose/Identifying
Customer Needs/ Major Facts | 4 | | | A.2.1 | The purpose/issue of the call
was clearly understood.
Elicits enough information from the customer, Clarifying questions were
asked if purpose is not understood, Summarizes key facts
Identified possible cause of issue or problem as appropriate.
| 0 | He took a lot of time to Understand and react to the situation.
He also was not able to get the Complete wiring and called HD twice for no apparent reason. | | A.2.2 | Questions were logical and
relevant to the problem of the customer. (Major facts gathered) | 4 | | | A.3 | Call Resolution (There is a
clear and correct resolution, solution, and action plan to the call) /
Response to Customer Needs | 12 | | | A.3.1 | Was methodical in responding to
customer. (Explained sequential steps of action plan to resolve issue &
desired result.) | 12 | | | A.3.2 | Appropriate reasoning provided | 0 | He said "Give me the wiring on the thermostat". When the caller asked him to repeat it, he repeated it thrice without even once saying that we need the wiring on the Old thermostat and/or terminals wired/unwired. | | A.4 | Miscellaneous | 4 | | | A.4.1 | Literature retrieved from the
web or faxed if applicable | 2 | | | A.4.2 | PCC referral initiated as
appropriate | 2 | | | A.5 | Call Closure and Documentation
(Call is correctly coded for reporting purposes) / Closing the Call | 10 | | | A.5.1 | Case Reason, Case Type
(Technical/Order/Literature), as
appropriate | 3 | | | A.5.2 | Issue was understood as a
tracking issue, Call Marking | 2 | | | A.5.3 | Complete Notes logged as
appropriate to the issue | 3 | | | A.5.4 | x:str="Closing was professional and upbeat. ">Closing was professional and
upbeat. | 2 | | | A.6 | Compliance | | | | A.6.1 | Adherence to Policy and
Procedure | 0 | | | A.6.2 | Misleading Information | 0 | | | A.6.3 | Usage of Abusive & Rude
Language (Harrasment) | 0 | | | A.6.4 | Disclaimers were provided on
call. | 0 | | | B | Call Taker Attributes | Score | Reason for Defect | | B.1 | Communication Skills | 10 | | | B.1.1 | Was easily understood by the
customer (Pronunciation, Rate of Speech / Clarity of speech, Appropriate
sentence formation (Basic Communication skills)) | 6 | | | B.1.2 | Verbal nods and repetition | 2 | | | B.1.3 | Energy / Modulation | 2 | | | B.2 | Soft Skills | 5 | | | B.2.1 | Attitude was consistent, patient
and helpful. Displays willingness to be helpful ("I Can…")
Built Rapport with the Customer, Used customer name
Empathized appropriately
| 0 | He was impatient and tried to overpitch a couple of times. | | B.2.2 | Followed Hold & Transfer
Procedures, (Asked Customer to hold, Checked back & Thanked customer for
holding, if applicable) / Mute or Hold time kept to minimum (2-3 mins) | 5 | | | B.3 | Technical Competency | 15 | | | B.3.1 | Understanding of products,
applications, features, functions, benefits, operation of controls, wiring,
programming, troubleshooting (Basic understanding of how HVAC controls
interact within a system. (Covered in process training) | 15 | | | B.4 | Resource Utilization: | 5 | | | B.4.1 | Identified best resource for
specific information needs and retrieved accurate information from the
resource | 3 | | | B.4.2 | HD/SA called as needed &
information flow | 2 | | | Defect Percentage | 29 | What Went Wrong | Good aspects of the Call | Suggestions to Upskill the Rep | | Score Percentage | 71 | The call was resolved however no customer would rate it as a good call since he lacked on basic communication skills. He needs to understand the plight of the customer and then act accordingly, since we are simply not technical wizards, we are also Humans, and should therefore reflect the same in our act and behaviour. | He somehow managed to end the call without getting the customer irate. His way of talking needs serious improvement. | LND should take note here and take the rep for a feedback. The TL should also check that the mistakes committed here should never be repeated and if they are would be marked as PAP defects/Rude Language. | | | | | | |
|
|
|
|
|
Hi,
great post!
1. this clearly is NOT a VB/VB.NET question, hence wrong forum.
2. this is way too long
3. did you care to check your post? all < and > signs are missing, hence no one can
copy and test your code, assuming anyone would be inclined to do so.
|
|
|
|
|
Hello,
I'd like to ask for a little help. I'd like to have code to get all the icons from the system tray and interact with them. If anyone can give me some guide or some sample it would be a great help. I'm using vb2005/2008.
Thanks a lot;
GQ
|
|
|
|
|
Hi,
I did an article on systray icons; it is C# code but the same can be done in VB.NET
|
|
|
|
|
Yeah, i saw that but had troubles when trying to code it in vb.net. Is there any way to create a class from your sample app and give me the source. It would be really appreciated and of course if you want i give you the credits whenever i use the code.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
