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
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?
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
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
project, 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:
passing 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 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.
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'
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:
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()
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.
I 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
I 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], " & _
I'm trying to setup a WCF web service to be consumed by JavaScript using JSON and jQuery.I've noticed that you can send JSON without a DataContract if the service method parameters match the naming structure of the JSON object:
I am making use of a 3rd party dll and am encountering some strange behavior in VB, which doesn't occur in C# Perhaps someone can explain what is going on. Anyhow, I am making use of a method in this 3rd party library which accepts an array parameter ByRef. The end result is the variable should remain null after the method call, but it is returning initialized for some reason.
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
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.
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 = ""
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.
I occasionally find myself passing this or Me to a child object. Such as this condensed real-world example...
Public Class Entity Private mValidator as New EntityValidator() Readonly Property IsValid()[code]....
I'm concerned about .Validate(Me).I get no warnings or Code Analysis violations, but it just feels wrong. I get nervous about infinite recursion and garbage collection.
In a VB 2010 program we have two classes Aclass and Bclass.In Bclass we need all values of an Aobject.How could we pass the Aobject to Bobject?[code]Is there any VB entity that could be defined as including all the properties of a given class?
I am creating a procedure and would like to know if I can pass the name of a property. I.e ComboBox1 so I can change the properties of that object. What I have done is create a procedure to populate a Combobox from my MySQL database. What I want to do now is populate the relevant Comboboxes without having to create a new procedure specifically for each combobox. I can create a procedure for each Combobox but the whole reason for procedures and functions are to minimize repetitive code and to make code easier to manage.
At the moment my procedure is ProcedureName(ComboBox1, "DatabaseName", "DatabaseField").
What I want to be able to do is do ProcedureName(ComboBox1, "DatabaseName", "DatabaseField1"). ProcedureName(ComboBox2, "DatabaseName", "DatabaseField2"). ProcedureName(ComboBox3, "DatabaseName", "DatabaseField3").
I am having some difficulty getting my head around passing objects between forms and hoped someone might put me on the right track... I have five forms: frmMain, frmLogin, rmAdminMode, frmUserMode, frmUserMode, frmUserModeDeepThere are two main use-cases: admin mode and user mode.Admin Mode: As the project starts it runs frmMain. Clicking a button stops the autologin (simple timer) and will invoke frmLogin (using .ShowDialog). The user is prompted for the users' ID number (four digits) and pass-code (again four digits).frmLogin will query a back-end database to authorise or reject the login attempt (this bit is all working fine) and then return control to frmMain. If the user is a valid admin frmMain will then invoke frmAdminMode.