In this report I put an image box named logo the select image Source is set to EXTERNAL and in the use this image I have Parameters!LogoPath.Value.I would like the users to be able to pick their own logo.
View 1 Replies
I have a RDCL Report called Report1.RDCL.In this report I put an image box named logo the select image Source is set to EXTERNAL and in the use this image I have Parameters!LogoPath.Value.
View 2 Repliespassing multiple values in a parameter field in crystal report viewer, I already set it to allow multiple values. When the code below executed it only displays the last record and not all of the records that appeared. here's my codereally need this one! Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
dt = New DataTable
sda = New SqlDataAdapter("SELECT * FROM KEMPMASTER", sqlcon)
[code].....
I am wondering if datatype can be passed as a parameter in a function..
for example..
Private Function CreateDT(ByVal myDT As DataTable, ByVal myColName As String As DataTable
(
myDT.Columns.Add(myColName, GetType(myColDataType))
)
In my VB.NET project I wanted to run a JAR file in a separate thread. Now the question : Is it possible to pass parameters to a JAR file during run time from VB.NET??
View 1 RepliesVB 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.
I have a SSIS package that just makes a folder (Child package) and i have a second package (parent) that calls the first package using a script task and the code is like [code]I want to pass the XML file as a parameter ,what the XML file does is that it has Variable for a folder name, so that if i like to change the folder name (making new folder), I can change it in the XML file and the parent pakage will call the child pakage with the XML file as a parameter.
View 1 RepliesI have a form with 3 tabs: one tab is for user entry and computations, a second tab shows values that will be used for computations which are read from one database (I call it settings in that the values are constants for calculations but it's not application settings in the way people think of it, to be clear) and the third displays a table from another database. The second tab has a table adapter interface for the dataset that contains values used for calculations that can be changed (to do different scenarios.) Those numbers are read from a single record in a database that has 20 fields and was read once when the data is loaded into the second tab to be displayed.
The problem I am having is that I would like to use the numbers from the second tab (the constants) in computations to be shown on the first tab. I have tried declaring the variables on the second tab as public but they are already "friends" with the form event. However, when I go to use them in calculations, it's like they don't exist.
For example, one calculation I am doing is fuel cost. The user enters miles and this is stored as a variable called mileage. To calculate the result fuelcost, I have to use two other fields that are shown in the second tab: MPG (miles per gallon) and fuelprice (the price of gas). So fuelcost = (mileage/mpg)*fuelprice. These are read from a datatable called testdata which is actually part of the project. I want to be able to use these variables throughout the program but declaring them as public isn't working.
How do I make the variables from one tab usable elsewhere in the program? The other thing I noticed is since the values of the variables are loaded into textboxes and assigned variable names by naming the textboxes, using val([variablename].text) isn't solving the problem either. For example, saying milespergallon = val(mpg.text) is not doing the trick because I am getting a message that 'text' is not an integer when I declare milespergallon.
Update Here the code that is being used:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim mileage = Int32.Parse(Miles.Text)
Dim rate = 0
Dim baserate = 0
[code]....
TabPage2 is where the variables are displayed that I want to use in TabPage1.
Private Sub TabPage2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TabPage2.Click
End Sub
Is it possible to make a procedure have a single parameter but the values for that parameter are more than one? I have this procedure:
Public Sub autoComplete(ByVal cboCombo As ComboBox)
With cboCombo
.AutoCompleteMode = AutoCompleteMode.Append[code]....
Now I was wondering if there is a way to use it like this:
autoComplete(myCombobox1, myCombobox2, myCombobox3)
Or can I use a procedure like this with 'With...End With'?
I am calling a crystal xi report from a windows form and passing 2 date parameters and a customer name. In some cases this customer name contains '&' eg Brown & Williams
In these cases my report fails and errors. if the name doesn't contain '&' it works. How can I pass the parameter with a & in it ?
I created a dataset that is getting data from an access database. Now i would like to go further and make the dataset query accept a parameter from a form datepick value. the query in my table adapter I have changed it as follows to accept a parameter on date1.[code]The code I am using in my form is as below. I get a null reference exception on the second line(Object reference not set to an instance of an object). it seems as if my selectCommand is bringing nothing.[code]
View 4 RepliesI have a bound DataGridView (dgvBuild) that contains data based on a "ProductID" that is derived from selecting the value from a ComboBox. How do I pass the ComboBox Value to the DataAdapter to retrieve records to reload the dgvBuild? Below is the code for theDataAdapter.This is the line that was created when I bound the DataGridView to a DB Table.
View 8 RepliesI need to pass an event as a parameter to a function and I'm wondering if there is any way of doing this.The reason why I need to do this is because I have a sequence of two lines of code that is littered all over my program, where I dynamically remove the handler to an event, then set the handler again. I'm doing this for several different events and event handlers, so I've decided to write a function that does this. As an example, let's say I have a combobox in my code called combobox1, and I have the handler called indexChangedHandler. In several places of my code, I have the following two lines:[code]Now, I don't want to keep on repeating the above two lines of code (or similar) all over my program, so I'm looking for a way to do this:[code]So far, the "evt as Event" part of the argument of the setHandler function is giving an error. Any ideas on the right way to do this will be very welcomed.
View 2 RepliesI need to pass an event as a parameter to a function and I'm wondering if there is any way of doing this.
The reason why I need to do this is because I have a sequence of two lines of code that is littered all over my program, where I dynamically remove the handler to an event, then set the handler again. I'm doing this for several different events and event handlers, so I've decided to write a function that does this.
As an example, let's say I have a combobox in my code called combobox1, and I have the handler called indexChangedHandler. In several places of my code, I have the following two lines:
RemoveHandler combobox1.SelectedIndexChanged, AddressOf indexChangedHandler
AddHandler combobox1.SelectedIndexChanged, AddressOf indexChangedHandler
Now, I don't want to keep on repeating the above two lines of code (or similar) all over my program, so I'm looking for a way to do this:
Private Sub setHandler(evt As Event, hndler As eventhandler)
RemoveHandler evt, hndler
AddHandler evt, hndler
End Sub
so that everywhere where those two lines of code(or similar) occur in my program, I can just replace them with:
setHandler(combobox1.SelectedIndexChanged, AddressOf indexChangedHandler)
So far, the "evt as Event" part of the argument of the setHandler function is giving an error.
P.S I've asked this question on a couple of other forums and keep getting asked why I would want to set the handler immediately after removing it. The reason is because dynamically adding an event handler n-times causes the handler to be executed n-times when the event occurs. To avoid this, i.e to ensure that the handler is executed just once when the event occurs, I first remove the handler each time I want to add the handler dynamically.
You might be asking why the handler would be added several times in the first place... The reason is because I add the handler only after a particular event, say E1, in my form has occured (I add the handler within the handler of event E1). And event E1 can occur several times within my form. If I do not remove the handler each time before adding it again, the handler gets added and thus executed several times.
Whatever the case, the processing occuring within the function is not of ultimate importance to me at this time, but rather just the means of passing an event as a parameter.
I'd like to create a function myFunc with one parameter, which is a delegate. I should be able to call it with a delegate as parameter.E.g.[code]But how do I code myFunc, in other words, how do I enable myFunc to have it passed a delegate so that it can be called using myFunc(addressof test Func)?
View 4 RepliesI'm wondering if this sort of thing is possible in VB.NET.. say I have a routine which accepts an integer array, defined as:
Sub WriteTable(iRows As Integer, arrColumns As Integer())
The arrColumns parameter is an integer array of column widths.
I can pass a value by doing this:
[code]....
sample code for passing parameter to crysatl report dynamically in vb.net ...?
View 2 RepliesI wrote vba function in excel and I want to call this function in vb.net with parameter passing.
View 2 RepliesI am getting error when debugging a project. The error is as below,
"FormatException was unhandled
String was not recognized as a valid DateTime."
Highlighting the following line
[code]...
Assuming I have the following code that is iterating over controls in a panel setting various control information.Private Sub BindDataFields()
[Code]...
Is there a way to pass an optional parameter to a webservice, instead of having to overload the method?If the webservice user is accessing the webservice directly, I want to do ActionA, if the user is accessing the webservice through my web interface, I want to do ActionA + ActionB.
View 1 RepliesCan'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'm calling unmanaged C++ Dll function from VB.Net project by usin dllimport attribute like this;
<DllImport("Injection.dll", CallingConvention:=CallingConvention.Cdecl)> _
Private Shared Sub Injector(ByRef Client As String, ByRef Dll As String)
End Sub
I am using following code to connect to my database.
Dim conStr As String = "Data Source=.SQLEXPRESS; ![enter image description here][1]
AttachDbFilename=|DataDirectory|dbTest.mdf;
Integrated Security=True;
User Instance=True"
Dim sqlQry As String = "SELECT * FROM [tblTest] WHERE ([Name] = @Name)"
Dim dAdt As New SqlDataAdapter(sqlQry, conStr)
Dim dSet As New DataSet()
Then filling adapter with
dAdt.Fill(dSet, "tblTest")
And then I can use the data the way I want.
My question is: How to pass the value of parameter that user will give through a text box on my webform.
Dim sqlQry As String = "SELECT * FROM [tblTest] <b>WHERE ([Name] = @Name)
I mean how to pass the parameter value to my query?
Im using a datatable and i am trying to do a insert statement into an oracle database by passing selected values from the datatable to the insert statement via parameters. I'v traced the parameter collection and it has the correct number of parameters to be passed but it is giving me an error saying a value being passed in is null but it is not, during debug you can clearly see the value of the parameter is not null.
Dim FuelInsert As String = "INSERT INTO table (COMPANY, TRAN_DATE, GAS_GALLONS,DSL_GALLONS,DEF_GALLONS,KER_GALLONS,E85_GALLONS,DDS_GALLONS,WDS_GALLONS)" _
+ "VALUES(:Company, :Trans_Date, :Gas_Gallons, sl_Gallons, ef_Gallons, :Ker_Gallons, :E85_Gallons, ds_Gallons, :Wds_Gallons)"
[code]....
I just wanted to know if there was a easier way of creating the parameters or if i am missing something simple that causing the values of the parameters being passed to get mixed up. The code retrieves the values i need and builds the parameter collection of 0-8 nodes which is correct.
I want to pass a date as parameter in vb to query the data from the table.If I hardcore the value in the query it works fine for me, but if I pass it as parameter to query, like I am getting the data from edit text and trying to send that as a parameter, this does not work.
SELECT *
FROM VehicleAnalogParamDownload2
WHERE Vapd2_Date between 'From_date.Text' And 'To_Date.Text'
I seem to be passing the parameter to the report (I placed the parameter field itself on the report to verify this) but it does grab any information based on this parameter. All of the fields appear with no data but the parameter is showing up correctly.Yes, I have verified that the parameter is in the select statement of the report.The report also is exporting correctly but still without the data.
Below is the code I'm using:
CR Loading
Try
Dim cryRpt As New ReportDocument()
Dim reportPath As String = "MyReport.rpt"
cryRpt.Load(reportPath)
[code]....
From what I understand, when you use AddHandler you're not actually calling a Sub, so you can't pass a parameter. I'm confused on what to do though about this. I've just populated a DataGridView and added a button to it in the codebehind. I'm then using an AddHandler to add a click event to the button. So when I get to the click event, I need to be able to access to the datagridview because clicking the button takes data from the datagridview and loads it into excel. What would I do about this. This is my Method where DataGridView was just populated
Dim btn As New Button
btn.Name = dgv.ToString()
btn.Location = New Point(0, 0)
[code]....
I am working with some code that uses array lists and I am using some of these to pass data back and forth like this: whatFile = (sideLookUp(x)) and its working, BUT when I turn this code into a sub/function then I call it I get problems, like double to string errors, even though its all set to double.
[Code]...
I'm trying to assign some parameters for a stored procedure with some values that are stored in a data table. in the code, I can set the parameter values to the data table, and give a column header or index without issue, but when it tries to execute at runtime it bombs out.the error I get is a variation on "Failed to Convert Parameter Value from a DataColumn to a String" depending on exactly how I try to assign the value.the data types are all correct elsewhere in the code.
my code for this bit is
Try
ConnectionAttempt.Open()
Try
With NewYearCommand_Dates
[code]....
other things I've tried to get this to work are all variations on the .Value=dates bit, such as
.Value=dates(0) (so using column index)
.Value=dates.columns(0) (again using column index)
I've also tried declaring variables, and setting their values to the values in the columns, but the code returns an error saying that "Value of type 'System.Data.DataColumn' cannot be converted to string".I should point out that i'm doing this for 3 tables at once in this sub, 2 of them will only have a single row of data, but the third has an indeterminate number of rows.I'm afraid I don't know what else to do. I'm lead to believe by my mate and my lecturer that this should work, and of course it will work, but the evidence says otherwise.
