How do i re-run the whole form again without losing the values stored as it run?
[Code]...
But they don't seem to work. Once the form reaches the end (after the user press enter), it just display a blank screen. But what i want is for the form to start all over again without losing the values. Is there a way to do that?
I have an application that I'm building which pulls dates from a database. The start value is stored as payPeriodStart date and I add 7 days to get the end date. What I need to know is, is it possible to store those values and pass them to a Stored Procedure? Currently my stored procedures have "static" dates in them ie[code]...
View 14 RepliesI have three forms frmStudent, frmClass and frmMain. I want to add code so that if the user focuses on another form without saving a message box will appear to prompt the user to save. This is necessary because If the user starts entering data on another, related formand assumes that the changes from the first form were saved, then there could be integrity issues.
I have tried formating the deactivate event, but when I hit yes it just deletes the record entered.
Private Sub frmStudent_Deactivate(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Deactivate
If GradebookDataSet.HasChanges Then
[Code].....
I've created a small form that acts like the office notifications (fades inout above the notification icon tray)I'm having problems showing this form, I want to display it without the focus being taken from my main application (or any other form), I've managed to get the attached code doing roughly this, (using Me.Activate to take back focus) But this isn't great - focus switches for an instant plus I want to show the form from various areas in my application...
Dim frm2 As New frmNotification()
frm2.TopMost = True
frm2.Show()
Me.Activate()
Is is possible to prevent a modeless form from losing its focus? I would like to force users to click the exit button of an addin form shown modeless before they wander into the main application. I need to show an user form of an addin modeless, in order to be able to interact with the document of main application. However, I would like to force them to exit this form before going into the main application.
View 5 RepliesHow can i reload/refresh the same form again without losing the data stored along with the form?
View 1 RepliesI want to prevent my application from losing focus, untill I close it. (so that I can not click on ANYTHING else, untill I'm done with it. period.)I've tried using Me.Focus() on a timer, but that doesn't do s***...I've also tried countless API's out there, but I seriously can't get any of them to work.. my form simply does NOT want to stay in focus! It's driving me crazy! What the hell am I doing wrong?
View 2 RepliesI'm trying to fix all my project warning according to Microsoft code analysis (CA:XXXXX) One of the warning is "CA2000: Dispose objects before losing scope" My Code is:
[Code]...
Having some issues with creating a simple control in vb.net.
I create a control with a single label in, I don't change anything except the colour of the control and the label and also making the label anchor to the edges ( with a small border around the edge)
When i then build it and add this control to a form. Some of the edges are cut off and it isn't anchored the way it was in the control.[url]...
as you can see in the second image the control has lost its white border at the right and bottom.
Problem displaying a graphics form from another forms button click event without losing the XY data plot.
If the Startup form is the GraphWindow form the Graphlib.vb calls create a XY data plot.
Code outline (not everything included):
(Sub GraphWindow_Paint(ByVal sender As Object, ByVal e As Sys�PaintEventArgs) _ Handles Me.Paint)
Call Graphscale(xmin, xmax, ymin, ymax)
Call DrawAxis(10,10)
[Code]...
I've been using the following sub in my control that I'm creating to let me modify the pixels in a bitmap faster:
Protected Sub LockForMemory()
idata = ime.LockBits(New Rectangle(0, 0, ime.Width, ime.Height), ImageLockMode.WriteOnly, ime.PixelFormat)
ipoint = idata.Scan0[code]....
This doesn't seem to work right, however.
So i have a DB with 3 tables. User Table with U_ID and U_Name, Class with C_ID, and C_Name and User_Class Table with U_ID and C_ID. Foreign keys are set.I want to display the classes associated with the selected user. The user is identified by their name. I know these are the two SQL statements I need to execute:SELECT U_ID FROM User WHERE U_Name = current_U_name
then
SELECT C_ID FROM User_Class WHERE U_ID = current_U_ID
then
[code].....
I have to design a project for my IT course at college using Visual Basic. The task is to create a program which allows the user to enter the height of a room plus the width of the walls as well as the paint which costs different prices. I have managed to get the program to work out the cost of painting each wall, but I cannot get another label to show the price for painting a full room, when the result is basically adding up the cost of painting all of the walls. how to add up multiple values displayed in labels?
View 6 RepliesThis may not be the place to ask this, if not, you can move this post to the SQL forum but I have an application that I'm building which pulls dates from a database. The start value is stored as payPeriodStart date and I add 7 days to get the end date. What I need to know is, is it possible to store those values and pass them to a Stored Procedure? Currently my stored procedures have "static" dates in them ie:
where dateadd (n, Timestamp, '12/31/1899') - ([LoggedIn]/1000)/60/1440+1 Between '10/3/2010' and '10/10/2010'
and I'd like those values to be
Between payPeriodStartDate and payPeriodEndDate.
I have an application that I'm building which pulls dates from a database. The start value is stored as payPeriodStart date and I add 7 days to get the end date. What I need to know is, is it possible to store those values and pass them to a Stored Procedure? Currently my stored procedures have "static" dates in them ie:
[Code]...
I am struggling with trying to pass values to a stored procedure, I am creating new records on my table by the values are not passing to the table.Here is my persistance class.
Public Function createDMRIssue(ByVal ItemNumber As String, ByVal IssueStatus As String, _
ByVal ProblemDescription As String, ByVal p_AuditResults As String, _
ByVal DMRDate As String, ByVal p_IssueCategory As String, _
ByVal p_DMRInitiator As String, ByVal p_QtyUnacceptable As Integer, _
ByVal p_ProductType As String, ByVal p_OrderNumberm_dmrissue As String)
Me.Connection()
[Code]...
the stored procedure is within a transaction. I want to get the inserted values after calling the stored procedure. My problem is, I don't know if that is possible because the transaction is not yet commited.
View 1 Replieshow to store boolean values in ms access or sql server
View 1 RepliesI am working on a Tag system for a news page designed in ASP.NET. For the system I require a TagExists method to check for tags within the database. The stored procedure I have written is below.
ALTER PROCEDURE [dbo].[Tags_TagExists](
@Tag varchar(50))
AS
BEGIN
[code]....
I have tried switching the procedure to return 0 if the tag exists and 1 if it does not and it still returns 0 despite the exact same testing conditions. I have also returned the actual select query and it has complained of the Tag "news" (my test item) not being an int on execution showing the select itself is definitely properly formed.
On a ASP.net form, I need to add a textbox to update a date field in MS SQL server via stored procedure. I want to verify user input cant figure out the correct syntax to do so (please see below)
If d.Text <> "" Then
cmd.Parameters.Add("@date", SqlDbType.DateTime)
cmd.Parameters("@date").Value = Date.Parse(d.Text)
[Code].....
I have a form that I'm running a stored procedure in and I'd like to pass the results to a datagridview and then offer the user the ability to export those results to a flat text file.
View 1 RepliesI am trying to pass some declared variables to a stored procedure. Here is my
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles startpayrollButton.Click
Dim ssql As String = "select MAX(payrolldate) AS [payrolldate], " & _
[Code].....
i have 31 PAIRS of radio buttons Yes or No in a web form which will insert the value of radion buttons or text of radio buttons in a single table of 31 columns in SQL server. I grouped each pair of radio button (Y and N). How can I retrieve the selected radio button value of the group and insert it into MS sql server database table using one insert command in VB.Net?
View 2 RepliesWhy is this not working for me? What is wrong with my code below? I am trying to read a stored proc and applying values to labels. Getting error that say "Incorrect syntax near CareerInner".........
Private Sub LoadData()
' Define data objects
Dim conn As SqlConnection
[Code]......
I would like to pass to values to a stored procedure. I am using a sqlreader to populate a excel sheet. I need the user to be able to select a range, rather that the whole table.
Dim strSQL As String = "sp_im_select_customerdtl"
Dim data As String = ""
sqlCon.Open()
[Code].....
Using SQL Server 2005 and VB.Net..[code]When I try to run the above query it was showing error.How to execute a stored procedure with conditions?
View 4 Repliesencrypt the string values stored in the code.The problem is that when the code is compiled and the .exe file is generated, anybody can edit the .exe file with an text editor or another program and see the values.This is very important for me, because i have some password stored in string variables?
View 1 RepliesI have two forms in an application. One is he background and then I show another keypad form called with the show() method (not showDialog) because I need to perform some validations on btn click.
The kepad has 10 buttons and an Enter Button. The problem is that the form keeps loosing focus (I checked this with a messagebox which keeps poping up once for focus=true and again for focus=false, it continuously keeps losing and gaining focus) so it does not process any keypress events untill i click somewhere on the form. I tried using me.focus() in form load event but to no avail. The forms TopMost property is also set to true.
I need a code that can allow the login form to search for pin number stored in another form example when a customer enters the pin number and clicks ok button the login form searches if the pin number exists in the bank details form
View 7 Repliesam trying to figure out why my 2nd form is not displaying the value i recived in my first form.The code for the first form is:
Private Sub scannerOnCom_DataReceived(ByVal sender As Object, ByVal e As SerialDataReceivedEventArgs)
responceBack = scannerOnCom.ReadLine
[code].....