I have 10 panels on a form and I was wondering if there is a more efficient way to loop through them to pass the data to my procedure instead of writing out each one the way I am doing
' sample shows only 3 but there are 10
For i As Integer = 1 To 3
Select Case i
Case 1
[Code]....
Im a student doing an assignment, how do i pass the value from a sub procedure to a function procedure....i want to pass the value from decSubtotal to a function procedure named CalculateDiscount; check out my code--
[Code]...
I have a table that I need to insert a set of records into based on user input. IE: Selection from a list of items to choose from. For this example, let's just say it's a collection of int's.
Not a lot of good examples on the internet. There's only one related question here on SO, but it lends no answers either (both answers are dead ends).
How do you setup the call into the Package from .NET? How do you setup the Package Procedure or Function to receive the collection? How do you process the collection once inside of the Procedure or Function?
I have a task to create a web service to receive client-side app's http request(with rpc={json data} in the end), deserilize it and put he parameter in stored Procedure in order to retrive data from sql server. the procedure query and client-side's app are already there and the return data to client-side app is JSON too
View 1 RepliesThis code calls a store procedure that takes input parameters. With this code I'm confused as to how the parameters are passed to the stored procedure. The parameters are first stored into 2 string variables (strCategoryName & strOrderYear). They are then copied/moved to an sql parameter prm.value. But the stored is stored in an sqlcommand (cmd ). I can't understand how the stored procedures knows what the parameter values are.
Private Sub btnWithParameters2_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnWithParameters2.Click
Dim cnn As SqlClient.SqlConnection = _
New SqlClient.SqlConnection("Data Source=SKYROCKET;" & _
"Initial Catalog=Northwind;Integrated Security=SSPI")
[Code] ......
How do I pass a variable to a threaded procedure? The clickedItem.Tag contains a username as a string which I want to pass to Public Sub GetLockoutInfo(ByVal UserID As String) but the AddressOf GetLockoutInfo line doesn't allow for a parameter to be passed to the procedure.
Private Sub CallGetLockoutStatus(ByVal sender As Object, ByVal e As System.EventArgs)
Dim SearchUserDetails As New NiRDs_Functions_OC
[Code].....
I want to create a Procedure that its parameter is also a procedure. I created some procedures to be used as parameters below:
Private Sub Jump(xStr as string)
Msgbox xStr & " is jumping."
End Sub
[code]....
this procedure should call the procedure above:
Private Sub ExecuteProcedure(?, StringParameter) '- i do not know what to put in there
? ' - name of the procedure with parameter
End Sub
usage:
ExecuteProcedure(Jump, "StringName")
ExecuteProcedure(Run, "StringName")
I see this asked many times on hereI'm copying this question that I found on here.Is there any way to pass a null value (I mean a value that the sql will interpret as null) to a stored procedure when using:tableAdapter.Fill(dataSet.table_name, param1 (as string),param2 (as string) etc...Which is the most painless way to do this(assuming that the sp stays inside the database!!)
View 4 Repliesthis is my coding when i run this coding for display the content in textboxes from the database by click event in datagrid. "Procedure or Function 'sp_developer_display' expects parameter '@developerid', which was not supplied."this error will display my sp in sql express is ALTER PROCEDURE dbo.sp_developer_display(
[Code]...
Im trying to pass parameters to a stored procedure in SQL but for some reason its storing the parameter(s) in the columns....
My code
Public Function AddRec(ByVal textbox1 As String, ByVal textbox2 As String, ByVal textbox3 As String, ByRef Creation As Date)
'Adding a new Record to SQL
Dim Conn As New SqlConnection
[code]....
the addwithvalue all the textbox`s have a value in which i would expect but for some reason when i go to db in SQL it actually shows the @Username,@Account,@Password,@DatCreated not the values im passing in please see the attached image.
I am building a three tierd app, and therefore have all my data access methods in a class by itself.This class only calls stored procedures, basically, I need to pass in the following:
1) stored procedure name as string
2) parameters as IDataParameter() -- an array of parameters
3) other fields ( not important to this discussion)
If I use a GridView on my web form and choose an ObjectDataSourceObjectDataSource, and then choose my business object and method, since the method is a call to a stored procedure with a parameter array, I don't know how to pass it values in the IDataParameter format.The Method Signature listed on the wizard is "RunSP(String spname, IDataParameter[] params), returns SqlDataReader" which basically is calling a method called RunSP with two parameters, of which the second parameter is a parameter array for a stored proc.
My application is asp.net with vb. In my page I have a textbox for passing date. If I didn't enter date and on clicking submit, I have to pass null value to the stored procedure. I tried following codes such as DBNull.Value and DateTime.MinValue. In that case instead of null ,"#12:00:00#" is passing. I have to pass Null.
View 3 RepliesI have created a database with on table that is very similar in setup to ProductCostHistory from the Adventureworks database. Using the adventureworks database as an example, when the procedure is given the parameters of date and productID it will change the EndDate of the currently active cost to the date value and insert a new record with productID as the ProductID and Date as the StartDate, leaving EndDate null for the newly inserted record. I am looking for a way to create a simple form with two textboxes and a button. textbox1 accepts the ProductID parameter and textbox2 accepts the Date value. when the button is pressed, the stored procedure is executed and the table is updated. This seems pretty simple and I am very familiar with tieing stored procedures to a table in a dataset when each prcedure handles only a single simple action (either, SELECT, INSERT, UPDATE, or DELETE but not a single procedure that combines UPDATE and INSERT as the procedure described above does). I've done some reading and played with this on myown but can not find the simplest straightforward way of accomplishing this seemingly simple task.
View 2 RepliesI have an asp.net page that contains a javascript function. I am using a vb.net code behind to run a stored procedure against the database to pull back address information. Results can be 1 or more rows. I need to pass the results to the javascript for processing. My code is as follows:
VB.NET
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code].....
How can I pass stored procedure name dynamically to Linq-to-SQL, vb.net and get the result into a datatable.
View 2 RepliesI 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 RepliesTrying to convert XML file to string and pass to stored procedure.
Dim fs As FileStream = File.Open(fileUpload1.PostedFile.FileName, FileMode.Open, FileAccess.Read)
Dim buffer(fs.Length) As Byte
fs.Read(buffer, 0, fs.Length - 1)
txtRawXML.Text = System.Text.ASCIIEncoding.ASCII.GetString(buffer)
When I tried to upload file I got error. The error description is 'A name contained an invalid character.'. Could not find prepared statement with handle 0. Could not find prepared statement with handle 0. sp_xml_removedocument: The value supplied for parameter number 1 is invalid. The statement has been terminated.
how to Pass datatable as a parameter to a SQL Server stored procedure
View 3 RepliesI want to passing field in database to list view with stored procedure.[code]...
View 3 RepliesI 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 a stored procedure which updates a database using the parameters I supply but I'm having trouble passing a NULL to the stored procedure
The field I need to make NULL is a DateTime field
DB.Parameters.AddWithValue("@date", NULL)
This gives me the error 'NULL' is not declared. 'Null' constant is no longer supported; use 'System.DBNull' instead
[Code]...
I am developing a complicated search form, and I would like to know best method of passing search criteria to stored procedures.Possible options that I know are, 1) Create sql statements in Visual Basic and send statements to SP as strings to execute2) Pass search fields to stored procedure and build command in SP (Stored procedure) in database?
View 9 RepliesJust started VB programming this week and have found a wealth of information about what I'm trying to do. Problem is, some of it is more complete than others.Here's what I'm trying to do:In Form1 (my main form), I want to instantiate a class that contains a couple of properties (speed setpoint and position setpoint). When I click a button, I want to pass this data to Form2 and populate two textboxes on Form2 with the properties of this object. I want to manipulate the property values on Form2 and click an OK button which closes the dialog and returns the manipulated data, updating the property values of the object. Here's the algorithm I'm following:1) On Form1, instantiate the class2) On Form1's "Pass Data" button click event handler, instantiate a Form2 object and invoke the ShowDialog method, passing the object as a parameter.
3) On Form2, overload the ShowDialog method to accept the object as a parameter and modify the method so that it returns the manipulated class data.4) On Form2, in the ShowDialog method, populate the textboxes with the class data that was passed in.Here's where I get stuck. If I press the OK button on Form2 (DialogResult.OK), it returns me to Form1, but what hook do I have in Form1 to receive the manipulated class data that the ShowDialog method is returning?Here's an example of what I'm thinking about:
Code:
Public Class Form1
Dim clsController1 As New MotionController
[code].....
I'm sure it's probably a very elementary question, but every explanation I've found seems to be incomplete.
I am trying to click on certain rows in a datagridview and have the information in the rows sent to a textbox. It does not append each row to the textbox though, which is what I want it to do. it just replaces it with the row I click on. What's wrong with my code. I have tried cell click too.
Private Sub dgProducts_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles dgProducts.Click
Dim i As Integer
[Code]....
I�d like to pass data from my VB 2008 project to data fields set in Word. Can it be done and if so
View 10 RepliesI am trying to work out what exactly I am doing wrong. My code looks right but I cant seem to find why I cannot access my arrays from my structure in another procedure. I think perhaps my temp array is not declared correctly to my structure. why I cannot use it from another sub and explain if I an using the structure correctly. In my click_button, I am getting the error:'SuburbString' is not a member of 'System.Array'.
[Code]...
I am having trouble retrieving data from a stored procedure that I have set up as a Data Adapter using VB.NET 2005. The Database is SQL Server 2000, and what I am trying to access is a simple Stored Procedure that will validate a users login access. [code] I have a dataset set up as AdjustmentsDataSetspValidateLogin. I am trying to figure out in code how I can address this using a table adapter or how I can capture from a login form I have created the UserID and pass this value to the stored proc to return the current record, if any of the user.I initially setup a Dataset and dragged the dataset onto a form. Then I deleted the data navigator and the toolbar that was created by default so that I could just pass values to the Stored Proc. I also have the table adapter setup to return a table "LoginData" with the two fields Approver & Admin when I pass a userID.But I am having difficulty addressing the table adapter in code and pulling back the data values for the UserID I'm passing to the DataSet.Does anyone have any ideas on how I can call this stored proc and get the data values returned? I'm new to .net programming. [code]
View 1 Replies[code]i want to write Delta_r(i) in access data and then i want to connect that file to Crystal report for plotting.
View 4 RepliesI am working on a program for work and I am stuck on trying to make a new XML file from VB.NET 2010. I have the old code which was done in C# and it works but even using a C# to VB converter didn't help. I will paste in both the C# and what I have in VB
private void webBrowser1_Navigating(object sender,
WebBrowserNavigatingEventArgs e)
{
[Code]....
It is supposed to not only create the file but launch a program called PowerScribe and find the case in the Field 6 section.
i am trying to find examples of getting data back from a stored procedure that has no parameters sent to it nor has any returned output parameter. Though it does display data.How can i get that from my code im using below?
Dim myCommandSQL As New SqlCommand
Dim myReaderSQL As SqlDataReader = Nothing
Dim intX As Integer = 0[code]....
The @return_value i just put there to see what would happen but i got nothing returned.