Communicating With Database - Matrix Style Controlboard ( Many Pictureboxes Used As Buttons)
Jul 24, 2009
I have built a matrix style controlboard ( many pictureboxes used as buttons) To call on a simple database. Being a beginner, I have not yet found any code for doing a query of sunh simple nature as this database. The Northwind samples are far more complex than what i have, but this is my main program, the reason I got into VB in the first place. 2 pictureboxes say PB1 & PB2. PB @ ontop of PB1. PB2 is invisible, but blocks view of PB1. Clickon 2, & it Hides(). Click on 1, & 2 Shows(). a simple math control box counts the events & turns the group inputs into binary output... 4textboxes per group is the way I chose Ther are roughly 200 pairs of these sporadically placed, this is just 1 pair. Textbox 16, & 18=0 @ form load 17 fixed ="1" 15 sets of these, TextBox42= binary value. This is the one that triggers the events for column "C" in the database. ( Their not in perfect order)
Anyway, this is where I need to get information tfrom the database to the listbox, heres that situation: Database has simply named columns A,B,C,D,E,F, G, H, ect.. Then the rows are equally simplistic row, rowB, rowC,..Any combination is represented here, Each row has several, but not all of the columns values. Since if only 2, or 3 of the variables clicked can = several different groups, a multiple reurn to the listbox is nessessary. I seen some code in an exercise that I think will do that, but how do I query the database to start the listbox load? The lesson shows a completely different situation for loading the listbox, but I think I can amend that easily enough. I just can't ask the simple question to the database.
Question is, if picturebox related to column "C" is clicked, how do I call the group names ( rows ) of those positive in Column "C" to the listbox? The Database is litterally that simple. Just 1 situation of columns & rows, not mutiple as in the lessons. If anything, I fear I'm too much a simpleton. I have added the PB's code
View 2 Replies
ADVERTISEMENT
Feb 15, 2011
Im new to using databases in my programming and to be honeest i am struggling.i need to get the program to communicate with my database to allow the user to login this is the code i have so far as i say i dont know much about it so its a bit bodged.
[Code]...
View 4 Replies
Jan 29, 2009
I download code from PSC which is written by VS2005 and want to run in VS2008. Buttons are XP style in design mode when i run it buttons are changing to flat style? Why?
View 2 Replies
Mar 10, 2009
I have a problem with the style of the button in a messagebox.If I call the following line of code in a current project the button get one type of visual apperance/style. And If I create a new VB.NET Windows Application project it gets a standard Windows apperance/style.
Windows.Forms.MessageBox.Show("Yaay", "Yaay!", Windows.Forms.MessageBoxButtons.OK)
See the difference between the buttons below.I suspect they inherit the visual apperance from it's parent or maybe from some project settings. But I have not been able to find out from where.Both projects are created in VB.NET 2.0, and both have same System.Windows.Forms - dll as reference (c:WINDOWSMicrosoft.NETFrameworkv2.0.50727System.Windows.Forms.dll).
View 1 Replies
Jul 31, 2011
I am writing a small aspx web application that takes in forum information after validation and then opens a database connection and populates the proper columns with data.note: The database is a .sdf file created in web matrix My issue is that even with: Import Namespace="System.Data.OleDb" on the page I am getting:
Type 'OledbConnetion' is not defined. I am extremly new to VB, I am coming from java and honestly I do not have all year to read vb code and take classes and read books. I need to finish this app for a client so I am kind of rushed.
[Code]...
View 4 Replies
Mar 23, 2011
how i can change the native scrollbar style in my application to my custom style. I can adopt a custom scrollbar to attain this purpose but this will not serve my purpose because i want this attribute in entire application. Like it the text in textbox gets longer than its bounds than the scrollbar appers are my custom bar not the formal ones
View 12 Replies
Feb 15, 2012
In data base data is stored as
task line_item Amount
task1 lineitem1 amount
task2 lineitem2 amount
[code]......
View 1 Replies
Apr 12, 2010
I set the cell style progromatically on a condition.. but when that condition is no longer met I want to go back to the grids.cell original (default) style property
if x=y then
row.Cells(column.Name.ToString).Style.ApplyStyle(mystyle)
else
[code].....
View 1 Replies
Sep 11, 2010
I have a form that cycles through a database table with next and prev buttons Database name is "China.accb" and the table is called Users Table Users has two fields, both text.One is called UserID and the otheris Password"am getting an error message when I try to click the next button that states: "Unable to cast object of type "System.String' to type System.Windows.Forms.Textbox'. I've highlighted the line causing the error below
Imports System.Data.OleDb
Public Class frmUsers
Dim intMaxRows As Integer
[code].....
View 2 Replies
Mar 3, 2012
I have a piece of software with two tabs, inside each tab there are buttons (the user can add the buttons when they want). when tab1 is full tab2 should start to fill. I currently know how many buttons fit on the screen so I just say something like if buttons > 150 then start to populate tab 2 The problem i have now though is if the resolution is changed then a different amount of buttons can be displayed. so if I put my screen to 1280x720 some buttons are left of. I was thinking of detecting the resolution and then using different cases for different resolutions but this seems very inefficient im wondering if there is a different way?
View 5 Replies
Dec 24, 2010
I am trying to make a style that only gets applied if the parent element of the element that the style refers to, has another specific style. Kind of like in CSS where you can do ".class1 .class2" to specify that the "class2" theme only applies if it is within an element with the class "class1". I do not wish to use any form of external DLLs or libraries for this task. I want to know if it's possible to implement on my own.
I've tried using MultiTriggers with no luck. I have a style that applies to all TextBlocks. I want the textblock to do the following: If the font-size of the textblock is 11 and the parent element's style is "PinnedSuggestion", set the foreground color to "#FF505050". If the font-size of the textblock is 11 and the parent element's style is "Suggestion", set the foreground color to "#FFCCCCCC". The conditions that I have tried to write to make this work, are as follows (the font-size condition is true, but the other one is not). The conditions are inside a style that applies to all textblocks in general.
[Code]...
View 1 Replies
Jan 3, 2011
I want to code an app with recreational purposes. This should be a Desktop app that detects itself running on other computers on the same LAN and communicates with them. By communication I mean that I should be able to pass anything from on to another. note that although I'm not asking for code (that would beat my purpose, of course) I think some small snippets wouldn't hurt. In any case what I really want is the "recommended procedure", I mean what Microsoft recommends for this environment, and documentation :)
View 3 Replies
Feb 3, 2009
is there a way through vb visual express 08 to ask a printer if it has toner or paper? im not to sure on how to communicate with printers in this way if it is at all possible.i am writing a program to display the status of the printer and this is key.
View 1 Replies
Mar 8, 2012
I've set up this function in my web app to send push notifications to Android devices:
Private Function SendNotification(ByVal authstring As String) As String
Dim request As WebRequest = WebRequest.Create("https://android.apis.google.com/c2dm/send")
request.Method = "POST"
[code]....
However, whenever I call this function, I get the following error message: The remote certificate is invalid according to the validation procedure."
View 1 Replies
Jul 25, 2009
I have VB.net Simple application with form1.vb , UserControl1.vb and a simple Dataset with few records included. In my UserControl1.vb I'll added a Bound DataGridView1 with Products Datasource. My question is.. How can i filter the Products table from UserControl1.vb? The Filter Value ("ProdID") is from Form1.vb with textbox1(receive the value.). here is my Form1 code
[Code]...
View 4 Replies
Aug 20, 2009
Alright today im going to make a chat program in C++ and VB.net VB.net will be the server and C++ will be the chat room. Im doing this becuase some people dont have .net and the program fails so im trying this so then everyone can use it. How would i do this? Like C++ sending information to VB.net and printing it out on a textbox
View 2 Replies
Aug 8, 2011
I need to communicate between multiple applications (one server and multiple clients) in the LAN. While googling I came across 3 concepts (TCP/IP, Named Pipes and WCF). I also understand WCF needs lot of study for a starter like me. I need to have one (server) application running on one machine, the values generated by it should be displayed immediately on the other (client) application which will be running on multiple machines in a LAN. Also when the user pauses the process from the client application, it should pause the process on the server application.
View 2 Replies
Mar 9, 2009
I have an application which the user can open multiple instances on the same machine. However, a section of the app would have sync problems if more than 1 instance has control over it. This is where I thought of transferring control, or sharing, between them. What should I be looking into?
They would have to be able to identify which one of them has control and to send text information over. I thought IPC or Named Pipes could do the trick, but I'm unfamiliar with them and examples seem to indicate only a single server will work. Here, I have multiple instances of the same app and every one of them needs to be able to listen for that request for control.
View 25 Replies
Feb 19, 2010
I am communicating to a device using a USB to serial port (VCP). I am having a problem with the usb failing. When the usb fails my app will lock up and the com port is lost. I have seen a post about this but cannot find it.
View 3 Replies
Sep 23, 2011
I have a Delphi program that communicates with a vb.net dll that I created. The vb.net dll communicates with a Fluke scope meter via an RS232 connection. I have created a program that communicates correctly via RS232, giving me the anticipated value. Though, when I package this up as a dll and access the dll from my Delphi program I always receive a value of "1", rather than the value I was expecting (most cases a value in and around 240).I know that my delphi program is definitely communicating correctly with the dll and that my dll is definitely communicating with the scope meter
Here is my vb.net code:
Public Interface IFlukeComm
Function GetReading(ByVal Command As String, ByVal PortNum As Integer) As String
[code].....
View 1 Replies
Oct 1, 2009
I've been trying for a long time to do what seems to be the most simplest of things..I have a remote host and I need to know if certain posts on that host are open or closed.Many examples on the net that I have found arent complete, and because I havent worked with VB.net for long I dont knowhow to complete them.Here is my code:: The issue is with this it tell me the target port is always closed, when I know that it is open.Code:Dim host As String = "www.google.com" Dim port As Integer = 80 Dim addr As IPAddress =CType(Dns.GetHostAddresses(host)(0), IPAddress) Try Dim tcpList As New TcpListener(addr, port)tcpList.Start() Catch sx As SocketException MessageBox.Show("port is closed") End TryA friend of mine suggested using WinSock.. I've not dealt with it before so I don't know what he's on about.
View 2 Replies
Jan 10, 2011
I have a project in VB .net 2008 and would like to communicate with a Sharepoint site on our companies SP server. Is it possible to interact with the SP site such as:
Create sub-folder
Upload and download files
Change authority levels on folders
View 5 Replies
Sep 25, 2011
I am basically after some information on what you would believe to be the best way to send strings from a mobile device (possibly a windows mobile phone) to a PC and vise versa. Just so you know the distance could be upto 4 miles and no direct line of sight.
View 6 Replies
Jun 20, 2012
I am creating a photo hunt game for grades 6-9 in summer camp. I want them to alter an image in paint then create two picture boxes. I want to put in ovals with no fill color to mark the differences in the picture but VB.net won't let me send the images behind the ovals.
View 5 Replies
Mar 7, 2009
I am creating an application and am very new to VB. I have 4 buttons on my form which is like my applications main menu. I would like that each of the buttons behaves in the following way when there is a mouse rollover: The Button back color is changed from the default to Red The Button text is changed to Blue, Bold, and increases in font size I would also like all the buttons to go back to their initial state when the mouse leaves.
Another thing, instead of me writing code for each of the buttons event handlers (Mouse Hovers, and Mouse Leaves) is there a way I can write this code once, maybe as a function and then always call it for any button that I create from here on so that any new buttons take on this behaviour.
View 2 Replies
Jul 27, 2009
I have created a windows service that monitors power events on the host machine. The next step that i wanted to do was to send custom messages to the service. To do this i have created a windows application and added a service controller control to it (drugged it from the toolbox). Initially i tried to send messages to my machine which worked fine (both the service controller and the service were running on the same machine)
Dim scSL As New System.ServiceProcess.ServiceController("MyFirstService", ".")
scSL.ExecuteCommand(128)
but when i tried to send a message to a remote machine on the network
Dim scSL As New System.ServiceProcess.ServiceController("MyFirstService", "machine001")
scSL.ExecuteCommand(128) i got the following error:
"System.InvalidOperationException: Cannot open Service Control Manager on computer 'machine001'. This operation might require other priviledges. ---> System.ComponentModel.Win32Exception: Access is denied.
Anyone knows what priviledges i need to set on the machine that has the service controller? Alternatively can anyone recommend a solution to this issue?
View 6 Replies
Aug 10, 2011
I am building a client-server type applications and they are communicating over sockets. This is the first time I am doing such a program and I have been learning off a web example and thought I understood it all but it would appear I am missing something as it starts to work then errors. Here is what I have:
VB
Dim serverSocket As New TcpListener(ListeningPort)
Dim clientSocket As TcpClient
Dim netStream As NetworkStream
Dim BytesFrom(1024) As Byte
Dim DataFromClient As String
[Code] .....
All of the above works and if I open up a telnet command window I can connect to my machine running this code on my specified port and in the command prompt window 'IDENTIFY' appears as it should from the above code. But it then gets to this block an errors on the second line:
VB
'RECEIVE FROM CLIENT
netStream = clientSocket.GetStream()
netStream.Read(BytesFrom, 0, CInt(clientSocket.ReceiveBufferSize))
DataFromClient = System.Text.Encoding.ASCII.GetString(BytesFrom)
Now as far as I can tell it shouldn't be processing the first line
[ netStream = clientSocket.GetStream() ]
Until I send something back from the client because then going on to the second line its trying to process something that isn't there yet.
The actual error I get is:
Specified argument was out of the range of valid values. Parameter name: size
On the line:
netStream.Read(BytesFrom, 0, CInt(clientSocket.ReceiveBufferSize))
View 8 Replies
Dec 2, 2009
I have a need to be able to communicate with a VB6 application (I have the source code) whilst it is running. I just need to get it to display some predefined forms. Any tips on how I could achieve it. I was thinking along the lines of using Sockets.
View 1 Replies
Jul 3, 2009
in my form, there's a are few textbox and 2 buttons..these buttons are use to navigate data from the database..and the textboxes will display the data when the database is empty, i want those buttons to be locked..how do i type the codes???.
Private Sub frmUser_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
con.ConnectionString = "PROVIDER = Microsoft.Jet.OLEDB.4.0;Data Source = H:TestingProjectuser.mdb"
con.Open()
sql = "SELECT * FROM Table1"
da = New OleDb.OleDbDataAdapter(sql, con)
[Code]...
View 8 Replies
May 2, 2011
I have 45 buttons on a form, Button1, Button2, Button3 to Button45. Each one has to have a Button?.Text value from a database eg. Button1.Text = "Beef", Button2.Text = "Cabbage", etc. In old VB6 I could use the Index value of each button to reference it, but in VB.Net there's no Index capability.
Is there a more elegant way to populate these buttons other than having a Select Case statement from 1 to 45 as below? [code]....
View 3 Replies