I have a problem on my coding here. It should insert the new triggered alert into database but it does not work.
Protected Sub repeaterAlert_ItemDataBound(ByVal sender As Object, ByVal e As RepeaterItemEventArgs) Handles repeaterAlert.ItemDataBound
Try
stockCodeheader.Text = " Stock Code "
plcNameheader.Text = " PLC Name "
[Code] ......
My problem is, I have set the parameter to be 150 in the database. and the alert triggered should refer to the parameter value. if the calculation result exceeds the parameter value, it will turn the box to red colour. however, i notice that it only compares the first three number. for example, if the calculation result is 1778.99 it will turn the box red because its first three digit is more than 150. but if the calculation result is 10234.90, it does not trigger the alert. i assume it only takes the first three digit.
Here is the code for this part;
Dim total1 As Label = CType(e.Item.FindControl("total1"), Label)
total1.Text = e.Item.DataItem("inventories").ToString * 365 / e.Item.DataItem("operating_cost").ToString
[CODE]...
We are Developing A sample Money Management Software For this i want to Develop SMS Alert while inserting Income And Expenditures....For Evert Inert Record I want to Get the SMS Alert is it Possible to Implement this Concept...
View 1 RepliesI am writing a program that has to print an alert message in a textbox if the user inputs invalid data. Invalid data would be a negative number. The textbox is the same textbox as the result would be in provided they input valid data. Here is what I have but it will not print the alert.
[code]...
i want to allow user to select or find access database file when the software is executed/opened for the first time. after user selects the file and as he clicks open the software shows the full path of the file and then stores it with the provider and datasource in a txt file for future use.
View 3 Repliescould someone tell me what i am doing wrong in this codeProtected Sub insert_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Insert.Click
[Code]...
Visual Studio 2008VB.NETFramework 3.5Windows Application
I have a SQL database names TestSQLVB
In it a table called tblTest2, with a three fieldstest2id , int, pk, increment by 1field1, varchar(50)field2, varchar(50)
I have a dataset named Dataset2.xsd
A tableadapter named tblTest2TableAdapter
A insert query names InsertTest2 with fields @f1, @f2 and ExecuteMode = Scalar
When I run the following code per MSDN [URL] the database does not get updated.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim testds As New DataSet2TableAdapters.tbltest2TableAdaptertestds.InsertTest2("One", "Dog")
End Sub
im in the middle of doing sql queries i can search my data base usingGetDateFrom (Select, from, where) Me.nameTableAdapter.FillBy(namenDataSet.descip, Me.box1TextBox.Text,Me.box1TextBox.Text, Me.box2TextBox.Text, Me.box2TextBox.Text)i have this working fine im struggling with inderting data to my databse i have made the query ..
INSERT INTO `details` (`Forename`, `Surname`, `Username`, `Password`)
VALUES (''& ForenameTextBox.Text &'', ''& SunameTextBox.Text &'', ''& UsernameTextBox &'', ''& PasswordTextBox &'')
[code]....
why my insert doesn't insert into mysql database
[Code]...
here is my code so far:
Public Sub cmdSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSave.Click
Dim i As Integer
[Code].....
when i click the button, i get a error message saying "Syntax error in INSERT INTO statement". as far as i can tell, i have everything i need to insert a new row into the database, and i dont see why this problem is occuring.
item(0) is an autonumber key field, so that should make a new record by itself, and i have declared the input textboxes as the data() array
I created a dataset and i am using OleDbDataAdapter to insert new values to access database. But when i close the program and after open it, values are not in the database. How can i solve this problem? Also, i have another problem. When i write codes that
[Code]...
I'm using a OleDB connection to a access database. I'm entering a row into the database to set some user preferences. What i need to get is get back the row ID of the row I just entered. I'm more familiar with PHP and with PHP I use use this entry
[Code]...
I am currently writing a VB .NET application where I am trying to open 1 database, create a select statement and then post the results into another database file using Microsoft Access database 2003.
The code seems to stop executing at the statement cmdJetDB.ExecuteNonQuery()
I am using the following code:
Dim conn1 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source=C:Sample.mdb")
Dim conn2 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source=C:db2.mdb")
conn1.Open()
conn2.Open()
[Code]...
Question: What is it that I am not doing. I opened both connections, stated my two SQL statements, yet it is still not working. I really need to get this application working. Please Help.........
i have used a aspx page with vb code. the page is not firing any event after some time if the page is kept idle.
any property needs to set in page attribute??
I am using VS 2008 and UltraGrid from Infragistics v 5.2
I have two UltraGrid objects on a Winform. While the AfterRowUpdate event gets triggered for one, it does not get triggered for the other. Here's the procedure of the offending UltraGrid event:
This does get executed:
Private Sub ugPatient_AfterRowInsert(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.RowEventArgs) Handles ugPatient.AfterRowInsert
e.Row.Cells("Courtesy_C").Value = "Mr."
[Code]....
The source file is different from when the module was built. Would you like the debugger to use it anyway?
Even if I rebuild by application, the dialog box does not go away.
I have a HTML page which i am converting it to DOM and in tat i am calling a function, which will find the click button in the DOM and trigger the click button. But for some reason my code is unable to find the control.[code]...
View 1 RepliesI'm having a really annoying issue which I can't get to the bottom of. I've got a NumberUpDown control which has a ValueChanged event. There is only one reference to it in my entire project which I have commented out to prove that it isn't calling the event. Even though the number is not being changed (the control sometimes isn't even in focus!) the ValueChanged event gets called. This is driving me crazy and I wondered if I could back track through the code to see what actually caused this event to trigger?
View 4 Replieshow can i know what event was triggered in picturebox in VBnet? [Code] i want to know what event was triggered whether it is .MouseEnter or .MouseLeave. the reason why i'm making this is to make the code more categorized according to the object that was used.
View 1 Repliesis there a way to trigger a MsgBox by clicking a button within a If and End If paragraph?
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
I have a control that inherits from Panel. I want to override onMouseWheel, but my code is never executed. I put a breakpoint on it, but it never gets hit.
Protected Overrides Sub OnMouseWheel(ByVal e As System.Windows.Forms.MouseEventArgs)
MyBase.OnMouseWheel(e)
.....
End Sub
The event is raised normally in the form containing my control. why this could be, or better still, how to solve it?
We are facing a crash issue in our application. To debug the crash issue we have directly executed the application from code.To trace the error we have removed the checked from "EnableJust My Code" options in Debugging and we have checked the "Enabledunmanaged code debugging" option in project properties Debug tab.
View 7 RepliesI have 2 Database in my VB.net application. I am using 1st database for daily operations. I would like to send one of the table records to online database. How Can I do that? First database is MSSQL Online database is MYSQL. I have created connections already using MYSQL .net connector.
View 2 RepliesI have a combobox sub-routine that is triggered by either a "SelectedIndexChanged" or "Leave" event How can I determine which of the two events triggered the sub-routine
[Code]...
What event trigers when we open file with our exe/program? How to do coding for that?
View 6 RepliesI have a VB.Net system that connect to SQL Server through ODBC.When I try to raiseerror from an IF...ELSE statement, it does not triggered the exception handling.I have done some raise error testing at my side. Below is my finding:
1. RaiseError did not triggered exception:
CREATE PROC xxx
AS
IF 1=1
[code]....
I am facing a issue while using the "validating" event of the maskedtextbox. I have an MDI form, in which there is a main form and a form acting as bottom bar. The bottom bar comprises of buttons for moving to "previous" and "next" forms. If suppose in the main form i have a maskedtextbox and the initial focus is set on it, then on the click event of the button (next; which is on the bottom bar form), it calls the validating event of the maskedtextbox twice. In the validating event of the maskedtextbox, i am checking some validations and if it doesnt pass, then i set [e.cancel = true]. just let me know the reason behind the triggering of "Validating" event twice?
View 1 RepliesIs there any way to make a ValidatorCalloutExtender popup a standard alert box?
View 1 RepliesHow do i create an alert using DateTimePicker1 and MonthCalendar1?
There are two seperate forms. The main one, where the one opens from and the other one where you set the date/time. And how do you integrate the notification with NotifyIcon1?[url]...
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]...