I have a windows form application that uses datasets and mySQL. I am wondering how I would get started in making one of the buttons blink dependant upon database status.In short each record has a column where the user marks a received checkbox. I would like for a button to blink if there are any request that are not marked as received.
View 1 RepliesI want to Click Button1 in form2 from form1.Button1. means, when i click form 1 button it also click form 2 button
I wrote a code....but its not working
Button1_Click (Form2, EventArgs.Empty)
And i also tried this
Form2.Button1_Click (Me, EventArgs.Empty)
I want to Click Button1 in form2 from form1.Button1.means, when i click form 1 button it also click form 2 button I wrote a code....but its not working
Code:
Button1_Click (Form2, EventArgs.Empty)
& i also tried this
Code:
Form2.Button1_Click (Me, EventArgs.Empty)
I just read about DataSet in VB.NET, it uses disconnected concept. My question is: if my apps has "List All" button that query data from 1 table in the database, and that table has "very very very" many rows, so my DataSet will be filled with those data and eat up memory. Can I limit the data that being put to the DataSet from that query? But I want to be able to retrieve the next data from the same query if the user want to see it?
For example:
I have 1000 rows in my database, and i query all of them. But I just want 200 rows being inserted to my DataSet, but if the user want to see rows number 201 and so on, I want to be able to retrieve the next 200 rows, and so on. So it just like cutting those data into a group of 200 rows. Can I do this with the concept of "disconnected" of the DataSet?
I want to update contacts in a database from VB, where the field value is N/A. The following will update all fields where phone = @Phone, however I want to update those fields IF they have N/A in already. Can it be done in SQL?
[Code]....
This is very, very simple question, I even posted on another forum, but apparently I didn't get the right answer.
View 3 RepliesIn my .NET application I have to manage bookings for rooms. I enter the room booking via an SQL query to a MS Access database using an INSERT INTO statement.
Before I insert the booking, I need to check if a booking already exists for that time period, and if it does stop the user from being able to book at that time.
I have written code to retrieve a database result on the day and time of the booking they want to book, and the fact that Access would return data would mean that the user is trying to book over someone else.
how I can check if I have a resuklt returned. My code:
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:Databasedatabase.mdb;")
cn.Open()
[Code].....
But this doesn't work, it displays the messagebox regardless of if there is a row returned or not. How can I check if a row was returned?
I created a small databse program, when I created the search field I wanted to display the results in "listbox" which I found some code that work perfectly
For each row in ds.tables("Tablename").rows
me.listbox1.items.add(row(1).tostring())
Next
but I also need to display "row 2" ACCORDING to the selected item from listbox in a textbox.
since the listbox is displaying the result of a search, it's been hard to find, how to do this?
I am trying to read a single result from an SQL table. I tested my query in MySQL Query Browser and it returns a result of USER_ID=4. My query:
SELECT USER_ID FROM aaalogin where NAME = 'administrator'
I believe my error is due to some "double quoting". I have a "txtUsername" textbox on my login form. I want to inject the typed entry from this textbox into my SQL QUERY. Notice the end of this line, I have tried tons of combinations, nothing works.
myCommand.CommandText = "SELECT USER_ID FROM aaalogin where NAME = " & " ' txtUsername.Text ' "
The result is ALWAYS "0" though, which is useless to me.
Full code below:
Imports MySql.Data.MySqlClient
Imports System.Data
Public Class frmLogin
Private Sub cmdCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdCancel.Click
Application.Exit()
[Code] .....
StudentId Marks obtain class
1001 76 NINE
1002 75 NINE
1003 55 NINE
1004 62 NINE
1005 38 EIGHT
1006 56 EIGHT
1007 31 EIGHT
1008 57 NINE
1009 48 EIGHT
1010 55 NINE
1011 49 NINE
1012 49 EIGHT
1013 27 NINE
1014 31 NINE
1015 48 NINE
1016 58 NINE
1017 31 NINE
1018 36 NINE
This is my database now I want to calculate rank from above this. I call this through procedure. If I select id 1001 then it will display the rank from the above data base. If I select 1007 then it must display rank to class eight.
How do i code so my program will give me a message box if there are no result of my database search?
there is the code for the search. [Code]
is there any way to determine if a button is still blinking? because i have programmed it like when the condition is true, the button will light up. This button will stop blinking only when the user clicks on it. Because in my program, each button represents the number of blocks. So if the alarm comes in from the block one and block one button blinks, the user should press on the button to acknowledge the alarm. but while the block one button is blinking,if a new alarm comes in from block 2 before the user click on the button1 to stop it from blinking, button 2 will blink together with button1 because the user has not acknowledged the alarm from button1. Currently, i have written the below code to blink the button. but this one will go with the alarm, that is if the alarm comes in at block 1, the button will lightt up at block one. but when a new alarm comes in at block 2 before the user acknowledge the button1, the button1 will stop blinking and buttton 2 will blink. But i want both buttons to light up. the code is below:
Private Sub Timer3_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer3.Tick
For Each ctl As Control In PictureBox1.Controls
[Code]......
May I know if is there any way to check if the button is still blinking from the button class that I have? Cuz I used this method to check 'which is if the button is still blinking execute this this this...
ElseIf (receivedData.IndexOf("Fire clear") <> -1) And BTN_IsBlinking = True Then
Label4.Hide()
Label5.Hide()
Label6.Hide()
Label8.Hide()
Label9.Hide()
[Code] .....
How do i check if the command insert new data in my ms access database this is my code so far.[code]...
View 12 RepliesThe main problem is I couldn't display the result when I retrieve data from database.
1. On Picture 1 above, for the Dg_Details, I set the Columns in two type, textbox and checkbox. But, for the datagridview1, I didn't set anything.So, when I bind data from database to Dg_Details and datagridview1, the datagridview1 display the data from database, but the Dg_Details doesn't display the data. Below is the code I written in my form :
Try
objCommand = Me.MyConnection_F.open.CreateCommand
objCommand.CommandText = "select Reg_Num, Reg, Golf, Course_1, Course_2, Course_3, Course_4, Course_5 from Invoice_Reg where Receipt_No = '00001'"[code].....
I think that's happen because the Dg_Details already set and it blocked the result data from database.
This is what I am trying to achieve.Lets say you got a database with say 4 colums.. eg.. Name , Acc Num , Amount , TotalThen I need to create a GIF of say 4 slides with the same background , BUT with the merged information as above from the database.
Application as follows :-
I wish to send out BULK MMS's with Client Statements.. Each one being personalised with the info as above. The MMS will contain the personalised GIF above.
I am trying to wrap my head around getting some blinking colored text and lasting for 3 seconds on the screen. I'm creating a game where you hit submit and if the answer is correct a label with popup and blink 3 different colors for about 3 seconds also a groupbox background color change. I have found many different ways on here how to do the blinking text. I just can't figure out how to do it for 3 seconds and then disappear. Here's a general idea of the code
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
i want to blink any of the for labels if the back color is LimeGreen.Timer5 is enabled already and starts at form closing event of another for.so on the timer tick i have below code.
Dim time2 As Integer
Private Sub Timer5_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer5.Tick
If (time2 = 1) And Label17.BackColor = Color.LimeGreen Then
Label17.SendToBack()
[code].....
how to hide the blinking cursor in textbox? after i do this: txtbox.text="X" i want the cursor to be hide
View 1 RepliesHow to make the Button.Text Blinking?
View 7 RepliesIn my form, there are many controls and the people who will use the final program are not very computer literate people. For this reason, I would like to use arrows which blink beside the control in order to show the order of controls to use (just like a visual guide). I also make the controls active-inactive in a proper order but a visual guide will also be musch of use...I guess I can do this by either using picture boxes beside each control or draw method (which I do not yet know how to use). But if I use a picturebox, how will I give the blinking (or fade in & out effect)? For blinking effect, should I use a timer or anything else?
View 3 RepliesI have a VB.net MDI app that contains a modal window (normal window shown as modal). I have a custom title bar button that disappears if the user clicks outside the modal area.Normally, clicking off a modal will cause the system to beep and then flash the title bar of the modal window.
View 2 Repliesmake blinking shape in different colors using for loop?
View 2 RepliesHow do I get a form to open with the cursor positioned on the lowest-tabbed index textbox (assuming there is no other type of control that is lowest in the tab sequence) and with the cursor blinking (assuming the textbox is emply)? I have tried this
View 10 RepliesOn my vb.net 2010 form the textbox which has tab stop 0 does get the focus when the form is opened but the cursor is not blinking. I know textbox 0 has the focus because if you start typing right after the form opens the characters show there. The cursor property of textbox 0 is set to Ibeam. This is my first-ever VB 2010 form. My 2008 forms work fine and my workaround is to do the project in 2008.
View 7 RepliesI am currently having a headache on how to solve this problem that i am facing. here is the situation: I have a combobox and a list box on the main form. The combobox will get the data from the ms access database. In the database, i have the details of a person's IC, Name and DOB say for eg on one entry I have D215311523C,SHAWN,13/04/1987 So now, my combobox on form load will show the list of dates in the database to allow the user to search base on the date itself by clicking on the selected date. So when the user clicks on the particular date say 13/04/1987, people in the database whose birthday is 13/04/1987 will be shown on the listbox.Meaning to say if i have 3 entries whose dates are the same 13/04/1987, 3 entries will appear. If there is only two entry, then two results will be shown. But now, when i do a single click on the date, one result will be shown. That is correct. But the problem is when i click on the same date again, three of the same results will be shown on the list box. that is it will display : 13/04/1987 13/04/1987 13/04/1987 which is not the case. Then it will show more duplicates of the same results if i click more times on the same date which should not be the case.
Dim n As Integer
Dim numbers() As Integer
Dim StartFrom As Integer
Dim EndAt As Integer
[code].....
I am using a datagrid in my where i am having four columns. In first column the parameter values are entered and in the second column measured value is entered and in third column the nominal value is entered.Inthe fourth column the result is displayed by subtracting the measured value and nominal values. I am doing this calculation in Datagrid cell validated event. What i want is,there will be many rows in the grid,when typing the value in the third column the corresponding result will be displayedin the rowof theresult column,save button will be displayed while the form loads,when the calculate part is completed that is there should not any cell of the resut column empty then i should enable the save butto.
View 2 RepliesI am encountering the following issue So i have a device that sends stuff at the serial port, i then parse it and put it into an array of bytes like that:
Dim HCI_Command_Rcvd_Byte() As Byte All good till here What i wanna do is make an array and put this result every time the serial port gives me a new result, for example:
[Code]...
Basically what i wanna do is let the port parse the messages, fill in the array with the result at an empty spot in this array and then i will have a separate thread that will look in into this array in each non empty space and after it looks into the non empty space it will use or discard the info and also mark this space as empty (after it checked)
I am trying to do a blinking cell with red and yellow text in my data grid view. The cell may blink when certain condition meet.May I know how should I write the VB script in VB2008?
View 3 Replieshow can I put the blinking cursor inside a specific cell on form load? I want the effect to be kind of like when you have a form with text boxes and when you set the tab order correctly, the first textbox will automatically have the focus and you can start typing right away. On a related question: how can I make the enter key activate the form's accept button when you're inside a cell?
View 1 Replies