I have a problem trying to capture data from a database to a label. I am trying to display a list of values from my database when i press a button.
This is my code for my database
[ CODE]Dim strDBFileName As String
strDBFileName = "My DocumentsCDRecord.sdf"
If File.Exists(strDBFileName) Then
[Code]......
I have a VB app and it has a login feature installed. Now when someone logs in into the app I want the users First Name and Last Name to be displayed on my second form where the user gets redirected on a sucesfull login. I don't know how to accomplish this as I am quite new to VB. I have provided my login code below (btw it uses an online database):
MySqlConnection = New MySqlConnection
MySqlConnection.ConnectionString = "server=;Port=; user id=; password=; database="
MySqlConnection.Open()
[Code].....
I think the code which provides the first name and last name need to check the users username which was provided on the first form and search through the DB. Then when it has found the record it should recieve the First Name and Last name.
I was wondering how to get a certain data from a MS database and display in a label. Example(Database entries)
[Code]....
The name will be displayed in the label depending on the year and number typed in two text boxes. So if typed 2009 and 1001, the label should display name2. I don't have any background on SQL. The only thing I did for now is that I added the database in the data sources and added a TableAdapter.
I have a lookup table that contains a label that describes the data to be written back to my database. For example:Label = Manufacturing Repair Issue (This is what the user see's in my front-end windows app)Data = Mfg_Repair (What I want to save to the database when the user choses the label)
View 13 RepliesI have a form that I am loading text (strings) from a database into a label.text (so the text from the database shows up into the label) I have done this code in a class that keeps all my database stuff seperate.
Public Function getQuestions() As List(Of String)
Dim question As New List(Of String)
objConnection.Open()
objReader = objcommand.ExecuteReader
[CODE]...
Within the form that the label is in I have done this code
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Label1.Text(db.getQuestions().ToArray)
End Sub
I am basically making a quiz, so that when the form loads, question 1 is on there is 4 possible answers. You then press next button and it goes to the next question.
I have a label printer (Argox 1000-x) and i want to print some datas on it. And this printer is connected to my computer via the COM1 port. I can open/write COM1. And when i send some data to printer through COM1, Label Printer's Ready Signal Led will be ON/OFF. But it does not print anything or any label..
View 5 RepliesI'm currently working on web application using VB in ASP.NET.Right now I have 1 page with panels that we are using to show/hide depending on the flow. When the user first comes in, he/she is presented with a gridview containing a list of clients. Then the user, clicks a link from a row and is presented a form where he/she can update the clients' info.Originally, I had a HYPERLINKFIELD that put the clientId in the url, then I'd grab the url and do the code appropriately
<asp:HyperLinkField Text='<%$ Resources:Resource, ManageClient %>' DataNavigateUrlFields="CLIENT_ID" DataNavigateUrlFormatString="~/clients/manage.aspx?clientId={0}" />
[code]....
Is there an easy way for me to capture some system data when I except? Particular memory information. I have a service that has been running fine for years, but lately it keeps having System.OutOfMemory exceptions being thrown at random. I want to determine what memory the system is actually using then if possible to see if I am really out of memory.
View 4 RepliesJust trying to capture some text data flowing in on COM1. The port opens but the data does not flow in. I have a textbox on the form and a SerialPort in the tray.
Public Class Form1
Private Sub IncomingData(ByVal sender As System.Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles SerialPort1.DataReceived
[code].....
where I'm going wrong with my circular DirectSound Capture buffer here? If I just capture sound into a big non-circular buffer it works fine, but with a 1 second (44100 bytes) buffer and a 100ms timer to poll the read position it goes haywire. No error messages, just long blocks of zeros with short bursts of valid data. calculation of the number of bytes to read and/or the read position.
Here is the code. gBuffer is defined elsewhere as a big byte array. In this example I am just trying to copy the captured sound data from the small temporary byte array (tempBuffer) into the big gBuffer byte array. Obviously this must be done so that every byte is read and copied into the byte array with no gaps or duplication of values. Timer1 is set to 100mS:
Dim McaptureBuffer As CaptureBuffer
Dim MiLastReadPos As Integer
Dim MiBufferOffset As Integer
[Code].....
I have several UserControls in an ASP:Repeater. They are 'Add to basket' User Controls with a text input for quantity and a button to add the item to the basket.
My problem is the value is being reset to 1 whenever I enter a value into the quantity text box. I think this is happening because the containing page reinitialised the repeater (which holds the UserControls) and the quantity is one again before the UserControl's click event is fired.
how to capture the value in the textbox before the Postback occurs, I am happy to stick this data in a session for now.
I am thinking I need something along the lines of PreLoad? But that didn't work for me
ok the scale is a truck scale connected to a terminal (cougar 8530) that was connected before via Rs232 now the pcs doesn't have a serial port so someone attach a usb adapter to it the thing is i cant capture any data from it. im an developing a small program that can capture the weight of the truck (trucks are weight with the product and then re-weight with out it so they can find how much the product or products weight) so any ideas? suggestions?
View 1 RepliesThere is Bitmap data on the clipboard from a screen capture. If I paste it into a RichTextBox it works OK. That is, if I remove the first two lines below.
Dim clipboardDataO As DataObject = CType(Clipboard.GetDataObject(), DataObject)
Clipboard.SetDataObject(clipboardDataO)
RichTextBoxTxt.Paste(DataFormats.GetFormat(DataFormats.Bitmap))
However, If I capture the clipboard data and restore it before I paste I no longer get my bitmap displayed in the box. My problem is, in the real situation I need to use the clipboard before I paste which is why I save it and restore it above.
1) Do you know why restoring doesn't appear to work here?
2) I can't paste before the save/restore. Is there something else I can do?
In a Windows XP Pro environment, my system uses a mainframe emulator in a window in which a scanning application is running. The data populating the mainframe app comes from various instruments, scales, barcode scanners, etc.. The data inputs are captured by a winwedge type RS232 data aquisition software.
When all the data is processed correctly, the mainframe application sends an "operation completed" message and creates an exclamation system event associated with a specific sound to inform the user.
My goal is to create a MS Access application that would use the Exclamation system event to validate writing the barcode that was just read to a database without further querying the mainframe, creating a local database. I only want to write the barcode when the mainframe application completed and therefore played the sound.
I'm trying to find the right RegEx to capture some (potentially) repeating data. I don't know how many times it will repeat. If I give an exanple of the data and what I want to capture can anyone point me in the right direction? It's the .Net regex engine (Visual Basic)
[Code]...
I want to capture images and store it in access data base in vb.net 2005
View 4 RepliesI'm somewhat of a novice at VB.I have a DataGrid that I am manually populating from a SQL query-based dataset (see code below). Question: How do a capture the value of a specific column of the selected row (mouse click in the row) to use as a variable in other parts of the overall solution?Also, how do I add cell padding around the contents of the data grid cells?
[Code]...
I have written an application which extracts a list of URL's (currently in Internet Explorer cache) from an XML file and displays them in a data grid view. From here i would like to launch Internet Explorer in a hidden mode and capture an image for each of the selected URL's in the data grid view. Is this possbile? If so what is the best way to go about it?
View 2 RepliesI'm trying to make a rs232 serial data logging program, that accepts a 12 bit hex RFID tagID from an RFID module. My end objective is to save this RFID tagID into a database and assigned to a person for a personnel management system.I had to use button3 to add the value of the variable 'msg' into textbox1 because I was getting the following error "Cross-thread operation not valid: Control 'TextBox1' accessed from a thread other than the thread it was created on". It is a temporary workaround.When I do press button3, I get the incomplete hex number, instead of "4C00A2C82A0C", I get "A2C82A0C", and sometimes I get random digits like 1,A,C etc etc.
Public Sub OpenPort()
Try
If SerialPort1.IsOpen Then
SerialPort1.Close()
[code]....
So I am hacking together an app which listens to traffic using SharpPcap library, it reconstructs the packets from sessions using the code from TpcRcon.
Listening and reconstructing part work on their own . What I want is on each packet arrival main window gets an event so it can display the packet , and when session is reconstructed display a complete packet (I am interested in HTTP ones) . -That is where it breaks with weird symptoms: for example right now it does not stop on invoking stop listening method - the sharppcap library function hangs there forever waiting on this line of code : m_pcapThreadEvent.WaitOne();//wait for the 'stopped' signal from thread
I also had it not working and crashing in sharppcap function because I had omitted one parameter in form delegate- which makes no sense, because form delegate does not deal with packet capture at all and only reacts on "New Packet" event from my "Listener" class (which is only there to notify main form)
My app starts as module main instancing class "Listener". MainForm has it
registered as friend with event and handles even "New Packet"
Main Form:
Private Sub uiListenStart_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btListenStart.Click
aLogger.AddMessage("Started Listening")
[Code]....
I got a system which i want to insert, delete, update the data into my database and the data from database will be display using datagrid. The below is the coding for one of my button, delete.
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Try
btnSearchEmpNo.Enabled = False[code].....
Now I wanna set when user click on this button to delete a employee (for example) then the datagrid that i have in my application will not show the data of the deleted employee but in the background, the employee haven't been deleted from database.The employee only will be deleted from database when the user click on SAVE button.I know this application have to use RowState but how?
What I want to happen is that the button from my system will remove the previous data from database and then insert new data to database from text file. Im done with inserting new data. The thing is that I dont how to control or where to put the Delete Command from my code.
[Code]...
Im developing in VB using a SQL Database, the thing here is that i am new to SQL. What Im trying to do is when i capture a "MT Number" (in the Borrow Applicator Part) the Initial Counter Textbox shows the respective Counter for the MT number i entered. Those fields are in the same table but i dont know what to do.
Heres a picture of the form.
how can i call data from database that newly updated(into row) to be inserted into a labels, here is the screenshot:
View 2 RepliesI want to get a value from my database and display it in a label. For example I have a table named customers and one column of it is called Cust_ID, now I want to get the value of the column Cust_ID and place it in my label. I used lastName as a search condition to get just a specific Cust_Id. [Code]. The only problem I have is how will I transfer the cust_ID to my label, I have no idea how I will do this.
View 2 RepliesOn my form, I have many labels. Each label's name is like 23SW001, 23SW002..and so on. Then i also have an access database that has a table name tblWorkstation. Then what i want is, if the form loads, it will compare all of the label names to my database. If the label name does not exist in my database. I will change the labels background property.
View 1 RepliesWhat I am trying to do is update a label with a value from a sql table using a combobox.this is a record from the table concerned
Species_ID (PrimaryKey) | Species | Genus_ID | Avg_Length | Avg_Height | Est_Weight | Diet_ID
1 rex 1
46 18 14000
1
On my form I have a combo box that is bound to this table with Species_ID as the Value Member. When I select a value from the combo box I want to update 3 labels with data from the Species_ID row corresponding to that value.
I have a form to add new records with label at the top to show the ID (number of row suppose to be newly as soon as save/update button is press). Eg: There had been 20 rows, ID counts to 20. The next row should be 20+1, and i want it to be appeared in the lblIDnumber.
View 1 RepliesHow do you insert label values to database? here is my code..
[Code]....
The label never get updated when it is assigned a new value from DB. I try with label.refresh method and also update method but the label still never get updated.
View 2 Replies