I have a form which contain Two textbox control. When I passing the Form to Procedure the textbox controls of the form not getting say I am giving Exaple.
Code:
Public Class Myform
'This Form Contains Two Controls TextBox1 And TextBox2
'Calling the Procedure
[code]....
I am in great trouble. I have a form which contain Two textbox control. When I passing the Form to Procedure the textbox controls of the form not getting say I am giving Exaple
Public Class Myform
'This Form Contains Two Controls TextBox1 And TextBox2
'Calling the Procedure
[code]......
In a tic tac toe game I am making there are two blocks of code that are identical except that they access different arrays:[code]Arrays plyrTaken and plyrPairs are used in the first block and cmptrTaken and cmptrPairs are used in the second. Is it possible to wrap these blocks into one Sub Procedure passing the different arrays when the procedure is called?
View 5 Repliesproject, but have decided to take another direction on it, after much and continued struggling.I started out trying to use data binding, but was advised to use straight SQL statements in the code. So what I'm trying to do now: I have 2 forms, frm1 and frm2. frm1 has a combobox, which is showing all the data fine from a table, and an OK button. Upon clicking on this button, I need frm2 to load, correctly populating its textboxes and comboboxes with the corresponding data, based on the selection made on frm1. This is what I have so far:
View 14 Repliespassing a variable to a sub procedure by reference. Not sure I understand how it works. Here is the code.
Private Sub bntcompute_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bntcompute.Click
Dim x, y As Double
getnumbers(x, y)
displaysum(x, y)
[code]....
Is the newly modified variable actually being Passed back? and If so where in the statement is it passed back. is it being passed back to the call getnumbers or is it passed back to the statement displaysum?
I need to write a procedure which will allow me to set readonly attributes for certain objects, for example:My form contains two text boxes box1, box2.My sub procecdure will contain code which sets box1.readonly() = true, but i dont want to name the "box1" in the sub procedure but pass it as a parameter....I thought this could be achieved using :
private sub disableobject(byval inobject as system.object)
inobject.readonly() = true
end sub
I am trying to complete a homework and seem to get stuck at the last point of passing arrays and avriables to a sub to do the calculations to produce the desired result of sales tax but can;t seem to accomplish that so far.
Public
Class
frmSalestax
Dim
[code]....
Can't seem to figure out why this is not working.
Dim Myspcmd As New SqlCommand("spDataImport", myConnection)
Myspcmd.CommandType = CommandType.StoredProcedure
Myspcmd.Parameters.Add(New SqlParameter("@FileName", Data.SqlDbType.NVarChar, 100)).Direction = ParameterDirection.Input
Myspcmd.Parameters("@FileName").Value = "Import_File.dtsx"
myConnection.Open()
[Code]...
I am confused about how to pass parameters to a stored procedure. The stored procedure is written in sql server 2005 and the code is in vb.net.
I have included the sub that I am working on. I know that my use of parameters is wrong.
Public Sub AddRecipe()
Using myDBconnection As New SqlConnection(setConnstring)
Using SQLcmd As New SqlCommand()
[Code]....
This 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]...
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 i.e.:
where dateadd (n, Timestamp, '12/31/1899') - ([LoggedIn]/1000)/60/1440+1 Between '10/3/2010' and '10/10/2010'
Here is my code for the form that will be passing the variables payPeriodStartDate and payPeriodEndDate to the stored procedure:
Code:
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], " & _
"dateadd(dd, ((datediff(dd, '17530107', MAX(payrolldate))/7)*7)+7, '17530107') AS [Sunday]" & _
"from dbo.payroll" & _
[Code] .....
And lastly since I'm calling those variables payPeriodStartDate and payPeriodEndDate, I assume that my sql query will have to change as follows:
where dateadd (n, Timestamp, '12/31/1899') - ([LoggedIn]/1000)/60/1440+1 Between payPeriodStartDate and payPeriodEndDate
Is that correct?
I would like to create a stored procedure that will call any webservice by passing to the stored procedure the webservice name/url and its parameters. I would like this instead of adding web refference each webservice one by one.
View 7 RepliesI have three items in my checkbox list, what I want to do is for the user to select either one of them in any combination and pass these values to my sql server stored procedure which then returns data according to the values passed to it in the where clause and binds this data to a gridview. However, at the moment in my sp I have three I parameters, in the case of the user selecting one item from the list not enough arguments will have been passed to the procedure. I'm not sure how to go about doing this
View 2 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].....
my issue could be found simple but I'm founding it difficults in regard of dealing with array concept in oracle and vb.netI will start by showing to you a code done in oracle side1-this script should be executed in hr schema2-create a table and call it job_testas
create table job_test as
select * from jobs
where 1=2
[code].....
i have a stored procedure to insert data into table create procedure insertdata
[Code]...
I have a radgrid bound to a SqlDataSource that includes a hidden, readonly column that stores a pk. I want to pass the value bound to that column to a stored procedure for Updates but the default behavior when the column is readonly is not to pass the parameter to the sqlDataSource. My question is whether there is a way to pass that value without having to go into the code behind. Here is a snippet of my asp markup.
<telerik:RadGrid ID="rgEmployees" runat="server" AutoGenerateColumns="False"
DataSourceID="sdsEmployees" GridLines="None" AllowAutomaticUpdates="true" AllowAutomaticDeletes="true">
[Code]....
If I set readonly="false" on the It works fine but then the user can edit the primary key value which is not desired. I know work arounds in code behind but is there any way to do it straight in the markup?
VB Imports System.Data.SqlClient Public Class frmMain
[Code]...
I have three ways of adding parameters to my query commented out above. The all seem to return 1781 records (which is all of the records) and will not filter out to what the UserName variable equals which should reduce it to 32 rows.
I use a Console.WriteLine to show that the UserName is indeed my username. But it seems to not be getting passed to the query properly. I tested the Stored Procedure before even starting in on the program, so I know it functions properly. I just don't know what I'm missing from a VB.NET perspective to get the same results into my DataTable.
In a nutshell, I am selecting values from a checked box column in a grid view. After checking the boxes I have a function that concatenates each customer number into a string called @CusList to use a parameter for a stored procedure Public Function SelectCusList()
Dim CusShow As String
Dim CusStr As String
Dim CusList As String
CusStr = ""
[Code]...
I have a sql query something like below,
create procedure test
(
@param1 nvarchar(max)
)
[code]....
Now I need to pass the value of @param1 from my .net application in such a way that the above query works.how from my vb.net code i can pass a value which is similiar to below
'1','2','3'
how do I structure value of parameter like above example from my .net application.
In VB.NET I've got two forms, on first one I have button, on second - two textboxes and "OK" button. I want to run procedure (Sub) on first form, then stop in the middle of it and wait for input on the second form. After that i want to process the data received from second form.
It looks something like this:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Open form2 for input
[CODE]...
The question is how to call the Form2 so that procedure is stoped till the second form is closed?
I'm upgrading a project from VB6 to VB2008.I have a routine that clears a combo box, named 'cmbDataTable' which could be on any form. I pass the form and the combo box is cleared.
[code]...
I assumed it would be the same in VB2008 but I get the error.'cmbDataTable' is not a menber of 'System.Windows.Forms.Form'I am working my way through the project, first updating the global procedures - this is one - I haven't written the calls so cmbDataTable doesn't yet exist.
This is what I have..Dim frmSettings As New frmOptionsfrmSettings.ShowDialog(Me)frmSettings is a settings form that you can choose the color for background of form1(Me)
View 1 RepliesI am trying to pass information to parent form from modal form in vb.net winforms application.
1.) I created a copy of a form and displayed it using following code.
dim f=new frmParent()
f.show()
2.) Depending on conditions a button on frmParent opens a modal child form and asks for some informations. I used following code for that:
dim f = new ChildForm()
f.showDialog()
Both code works fine. When user press saves in child form i need to close childForm and use the user types values in parent form. I know how to close the childform but not sure how to pass info from childform to parent form.
The code below is what I have in one form. Login_prompt is the name of the other form.In this code snippet I am displaying another form that prompts the user for a username and password.I then want to open the website and auto populate the fields. The populating is not the problem.I cannot seem to call on the other form's sub procedure correctly.
View 3 RepliesThere are 2 forms open for the user in a school attendance program. The 1st. form is called FormBrowseClasses and the other form is called FormBrowseGrades. On the 2nd form is a procedure called PopulateTheDataGridWithData. That procedure loads data into a DataGrid.We would like to call PopulateTheDataGridWithData from within FormBrowseGrades so the data in the DataGrid will be refreshed.
We already tried:
' Refresh DataGrid data on FormBrowseClasses
'-------------------------------------------
objFormBrowseClasses.PopulateTheDataGridWithData()
but this only runs on a new instance of the form, not the currently open form. how to set this up correctly?
Is it possible to write the procedure (Private Sub hello() for ex.) in somewhere else, like in another file, and call it like we usually do?
I just don't want my main Form.vb to be filled with lots of codes, I want it to call procedures and run them
i am try to pass the text input into the text boxes in form ( OrderScreen) into the text boxes in ( PrintOrderScreen)I don't get any error it just does not pass the text over to the second screen.
[Code]...