15,898,134 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by hoyice (Top 34 by date)
hoyice
30-Oct-13 2:41am
View
do you have any link for how timer works? I'm new to WPF and VB.NET sir.
hoyice
30-Aug-13 4:43am
View
i am doing my interface to expression blend and i code in vb.net because my data is from SQL. I am not familiar with view model.
hoyice
25-Aug-13 0:44am
View
I've already figured it out.
I used this code:
Imports MySql.Data.MySqlClient
Imports System.Data
Class MainWindow
Private oskProcess As Process
Dim conn As MySqlConnection
Dim sql As String
Dim cmd As MySqlCommand
Dim adapter As MySqlDataAdapter
Dim table As DataSet
Dim reader As MySqlDataReader
Private Sub Window_Loaded(sender As Object, e As RoutedEventArgs) Handles Window.Loaded
conn = New MySqlConnection()
conn.ConnectionString = "server=localhost;username=root;password=;database=kiosk"
conn.Open()
sql = "select name from establishments where category='accommodation' and location = 'town' order by name asc"
cmd = New MySqlCommand(sql, conn)
adapter = New MySqlDataAdapter()
adapter.SelectCommand = cmd
Using reader As MySqlDataReader = cmd.ExecuteReader
While (reader.Read())
Me.listBox.Items.Add(reader("name"))
End While
End Using
conn.Close()
End Sub
Private Sub listBox_SelectionChanged(sender As Object, e As SelectionChangedEventArgs) Handles listBox.SelectionChanged
Dim y As String = listBox.SelectedItem
Dim x As Double
Dim j As Double
Dim k As String
Dim r As Integer
Dim l As String
Dim d As String
Dim a As Image = New Image()
Dim can As New Canvas()
conn.Open()
cmd = New MySqlCommand(String.Format("SELECT * FROM establishments where name='{0}'", y.ToString()), conn)
Using reader As MySqlDataReader = cmd.ExecuteReader
While reader.Read
x = (reader("top"))
j = (reader("l"))
k = (reader("name"))
r = (reader("Contact_Num"))
l = (reader("Distance"))
d = (reader("Description"))
can = Map
a = Bal_Pointer
Canvas.SetTop(a, x)
Canvas.SetLeft(a, j)
can.Children.Remove(Bal_Pointer)
can.Children.Add(a)
tb_1.Text = k
tb_2.Text = r
tb_3.Text = l
tb_4.Text = d
End While
End Using
conn.Close()
End Sub
Private Sub tb1_MouseDoubleClick_1(sender As Object, e As MouseButtonEventArgs) Handles tb1.MouseDoubleClick
oskProcess = Process.Start("osk")
End Sub
Private Sub Tb1_TextChanged_1(sender As Object, e As TextChangedEventArgs) Handles tb1.TextChanged
conn.Open()
Dim lb As New ListBox
lb = listBox
cmd = New MySqlCommand(String.Format("select name from establishments where name like '{0}%' and category = 'accommodation' and location = 'town' order by name asc", tb1.Text), conn)
lb.Items.Clear()
Using reader As MySqlDataReader = cmd.ExecuteReader
While reader.Read
lb.Items.Add(reader("name"))
End While
End Using
conn.Close()
End Sub
End Class
------> THE PPROBLEM IS ----> whenever i typed a in the textbox, list box will show apple and avocado, if i select apple the functions seems to pretty work well. BUT whenever i change the letter in to textbox, the program doesn't work, it says there is a problem in conn.open.
how will i able to run this without problem?
hoyice
24-Aug-13 21:04pm
View
Deleted
what's the appropriate code for the text changed event, if i may ask?
hoyice
24-Aug-13 1:48am
View
Private Sub Tb1_TextChanged_1(sender As Object, e As TextChangedEventArgs) Handles tb1.TextChanged
conn.Open()
cmd = New MySqlCommand(String.Format("select name from establishments where name like '{0}' and category = 'accommodation' and location = 'town'", tb1.Text), conn)
Using reader As MySqlDataReader = cmd.ExecuteReader
While reader.Read
listBox.Items.Add(reader("name"))
End While
End Using
conn.Close()
End Sub
i'm using this code but nothing happens. i don't see the list on the listbox.
hoyice
23-Aug-13 22:01pm
View
thanks. :)
hoyice
23-Aug-13 11:43am
View
how about in vb.net? this is c#
hoyice
23-Aug-13 11:28am
View
i'm still trying...
hoyice
18-Aug-13 4:12am
View
you mean, i don't need to code for button_click handler event? how am i able to show a different user interface if i click a button? I'm lost.
hoyice
18-Aug-13 3:41am
View
I have already read your solution, but i don't know how to do that. do you have tutorial links in which i could follow?
hoyice
18-Aug-13 3:39am
View
I am creating a kiosk application in WPF. There should be only one window opened but whenever a button is clicked the design and the content of the window should change. In windows form application it just form.show and form.hide, i don't know how to run it in WPF.
hoyice
30-Jul-13 5:01am
View
thanks girl. :)
hoyice
28-Jul-13 4:28am
View
how do i check the value in the selected cell?
hoyice
28-Jul-13 4:18am
View
ok. i'm still lost in how will i be able to fire the event with a specific item in a database? I don't know how to code it with an sql query.
hoyice
28-Jul-13 3:59am
View
i will add an event under datagrid view?
hoyice
28-Jul-13 3:41am
View
events sir.
I'm trying to figure out the code for a specific cell selector in datagrid view.
I would like to ask how do i translate this one to a code?
If "select name from establishment where name = 'mcdonalds" in datagridview1 is selected then mcdonalds image will be visible.
hoyice
28-Jul-13 3:18am
View
I'm trying to figure out the code for a specific cell selector in datagrid view.
I would like to ask how do i translate this one to a code?
If "select name from establishment where name = 'mcdonalds" in datagridview1 is selected then mcdonalds image will be visible.
hoyice
27-Jul-13 12:07pm
View
actually, i've already created my design what is driving me crazy is how to code it on vb.net. I've searched for several examples but i can't find one that i'm looking for. I think i kinda lost. :(
hoyice
27-Jul-13 4:10am
View
Hellow Silverio! I am already finished in doing my database and design. I'm having a hard time to display my database (SQL) to wpf datagrid view. I'm using vb.net. what should i do?
hoyice
17-Jul-13 5:37am
View
Silvabot, I am so grateful for your words. Thank you for helping me to come up a better solution to my problem. :)
I think, I'll stick to the static images plan. I'll just have to declare to my hardware specification (monitor) the required screen size for the kiosk and it's resolution since I'll be creating a fixed application.
with regards to new establishment, I'm planning to let the admin of the kiosk to add an establishment (description, and others) plus the admin will draw a path of the establishment and kiosk thru MS paint. It will be saved as an image file without animation though. Meaning, Old establishment will have an animated paths while the new or upcoming establishments will have a still image of a path. It may result to an inconsistent application feature, but thats the only solution in my mind right now.
also, i am intersted on the tutorial link that you given, but the language is C# I'll be using vb.net :(
hoyice
16-Jul-13 11:02am
View
I've talked to my Project Adviser awhile ago she advised me to do the following:
1. To Make a database of the establishments first.
2. To design a a customized map
3. To put objects as point of establishments (PNG file for transparency)
4. When the mouse hover to an establishment to the list, all the objects will turn to invisible except the hovered establishment.
5. When the mouse is hovered to an specified object, the list will show the name of the establishment.
6. when the establishment is clicked, a GIF image of path will pop over the map. (The path has transparent background so that it wont cover the map)
7. I have to create a GIF file of path to each establishment.
Is this idea good? or it this idea too difficult to implement?
hoyice
14-Jul-13 21:59pm
View
Thank you sooo much! Now, i am enlightened on which steps would go first.
questions:
1. How am i able to animate the paths from point kiosk to the clicked establishment? should i use gif? flash? or vb.net allows a feature that may draw a path?
THANK YOU AGAIN!!! :)
hoyice
14-Jul-13 21:58pm
View
Deleted
Thank you sooo much! I am now enlightened on which steps would go first.
Questions:
On higlighting the map? what should i do to animate that? should i create a flash for that? or vb.net doeas allow drawing a path from point kiosk to point of a clicked establishment?
hoyice
13-Jul-13 11:41am
View
Am I going to use X and Y coordinates for this?
hoyice
13-Jul-13 11:39am
View
It is a small town, the people in town just walk the whole place. :)
hoyice
13-Jul-13 11:38am
View
Thank you Silva!!! That is exactly what I'm suppose to do. Out project is not connected in the internet, we cannot use google maps.
I guess, we'll be using custom map for this since our application is strictly offline.
My question now, is on how will start the project? After i draw the map and everything what will be the next step?
Should I turn the establishments into button?
hoyice
11-Jul-13 6:52am
View
yup. because, i already figured out the answer to my question on this thread. I wrote another question, thinking that you might extend help. :)
hoyice
11-Jul-13 5:10am
View
I already posted my another problem on this link -----> http://www.codeproject.com/Questions/619346/Suggestion-for-a-Mapping-System
hoyice
11-Jul-13 4:11am
View
thanks. :)
hoyice
11-Jul-13 3:38am
View
Hi Richard. Thank you for helping me. Is it ok if i email you my project requirement? I've got lots of questions that I want to ask. I want to finish my whole project, but i don't know how to... WPF and expression blend are new to me. Thanks in advance. :)
hoyice
11-Jul-13 3:37am
View
Hi Naz. Thank you for helping me. Is it ok if i can email you with my project requirement? I've got lots of questions that I want to ask. WPF and expression blend are new to me. Thanks in advance. :)
hoyice
11-Jul-13 3:34am
View
Hi. Naz, is it ok if I email you or PM you my whole project requirement? There is a lot of question I want to ask. The university never taught us WPF and expression blend.
hoyice
10-Jul-13 4:40am
View
yes it does, but how am i going to transfer those xaml codes to visual studio?
hoyice
10-Jul-13 4:37am
View
I've already finished designing my application to expression blend... The thing that i should do is to code it in vb.net (visual studio)... how am i be able to transfer the Xaml code from expression blend to visual studio?
Show More