accessing values using ODS. i have no idea how to make this work.
im using ASP.NET VB code.
Imports Microsoft.VisualBasic.FileIO
Imports IP2V2.DataAccess
Public Class LotIDParameterDAL
[Code]....
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 want to make a generic EventArgs sub class that has a write-only property which, when updated by the code that is handling the event, will also update the byref parameter of the constructor of the class.
The code I have so far doesn't work. How do I get the property "Item" to update the "item" constructor parameter so I can retrieve the value that was set?
public class EventArgsSet<T> : EventArgs
{
public EventArgsSet(ref T item)
{
[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.
m using a public variable called globalquery & a global function retriveToDataGrid() it works perfectly fine under same class /form ..... but when i try to access it from a different form , it gives no error and nothing happens
Public Sub retriveDataToDataGrid()
Try
Dim connStr As String = "Database=shahopticals;" & _
"Data Source=localhost;" & _
[code]....
I'm still learning so this might be completely wrong. I have built a multi-user web application for internal purposes. I have split my code up to make it more manageable and have run into some problems. I suspect that I have done something very silly!
I have a class in a separate file (quoteStatus.vb) in App_Code here it is:
Imports Microsoft.VisualBasic
Imports System.Data.SqlClient
Imports System.Data
Public Class quoteStatusHelper
[Code]...
This seems really wrong, as the value seems to be held in the partial class after the first run. So if I have two users accessing the class the public shared dim is changed for both users! There must be a better way to do this. I have looked everywhere and I'm more confused now than when I started off..How can I make QuoteStatus in the partial class unique to every user and access it from my code.
A brief about the foundation of the program: I have created a VB2010 Windows Form application that connects to a Microsoft Access database. A datagridview is used to show all the data of the database. Then, a filter is used to filter the dataview (the BindingSource actually) and show the filtered db's data.
Let's say this is how I filter my BindingSource:
MyBindingSource.Filter = " price > '110' "
This would cause the dataGridView to filter the data (correctly), and let's say 10 rows are now displayed. What I am trying to do now is to get the sum of the values of one column of these new data. For example each of the 10 rows have a 'price' column which contains a double value. I would need the sum of these *filtered* values.
I found on the Internet that I may be able to transform the BindingSource into a DataTable and I could, but now I don't know how to access the values inside this!
I have my app that does some complicated function and adds some values to an array, but then later I need to access the strings, I have the index number but not the string so how can I find that string again?
View 2 RepliesI've almost accomplished getting method parameter name and values. [code] I'm using using vb.net 2005 /Vista/Microsoft Script Control 1.0
View 1 RepliesI am working with Vb.net 2005. I have used Crystal reports in some forms. The Crystal Report on the other hand use parameter field, therefore when you run the application an "enter parameter dialogue box" is loaded.
View 5 RepliesI 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 RepliesI have a question on a datagrid object in vb.net 2008, that I what to be populated with certain values of a parameter from mssql database. The connection is made, the column header are loaded, but I what, when the form is loaded, to populate the datagrid only with certain values, doing a select commnad where id has a value given by me.What is the command to have this select done and display the values in the datagrid?
View 3 RepliesI 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].....
i'm trying to do a filename compare, sort of fuzzy match.Here's what code i have.First of all i load 2 directory's into 2 listbox's as strings and remove the filepath. Directory1
Code:
TextBox1.Text = FolderBrowserDialog1.SelectedPath
If TextBox1.Text = "" Then
Else
Then when i click the compare button i am trying to pass listbox1 and listbox2 through Distance and return the resulting fuzzy file matches.
Code:
Dim MyObject As New StringSift2
Dim ReturnVal As Single
ReturnVal = MyObject.Distance(ListBox1.SelectedItem, ListBox2.SelectedItem)
[code]....
But i get this error.
Code:
TreeView1.Nodes(lb1).Nodes.Add(ReturnVal.ToString())Specified argument was out of the range of valid values. Parameter name: index
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 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].....
My code below will save records to my database as long as all the parameter have values. One of the parameter is @MI (middle initial), however, there are times that student have no middle initial so when I click my button I get error. I want to still save the record even if one of the parameter value is missing.
[code]...
I am running Crystal Reports Basic for Visual Studio 2008.
I would like to dynamically refresh my report based on a parameter.
For instance, I'll have a customer contract and I want to switch between customers based on a VB.NET winform button click.
I was expecting the code below to work, but I keep getting the "Enter Parameter Values" dialog box, why isn't it using the parameter value that I just set it?
CustomerReport1.SetParameterValue("CustomerID", txtCustID.Text)
CrystalReportViewer1.RefreshReport()
I need to execute a stored function in oracle or sql through vb.net. I created a command object. Depending on the database type(oracle or SQL) i am preparing the Command text as Select functionName(?,?,?,?,?,?,?,?) from dual; (For Oracle) Adding the parameter values of the function. Now performing the ExecuteScalar which is not working saying invalid parameter. This works with ODBC connection string. But ODBC doesn't with 64bit. My Requirement: Code should execute a user defined stored procedure by taking the values at runtime.
View 1 RepliesI am trying to export a report but everytime it runs the code to export the crystal report in the crystalreportviewer I get an error message saying "Missing Parameter Values". I've looked through many sources but havent found a solution. I do know that all parameters are filled in because without the export code, the site runs perfectly fine.
Export code
Try
Dim CrExportOptions As CrystalDecisions.Shared.ExportOptions
[code].....
Following code doesnt work and raise error "A parameter is missing. [ Parameter ordinal = 1 ]".What s wrong with it?I am developing pocket pc application in vs 2008 and sqlce 3.5 sp1.
[code]....
I'm Trying to Call the Stored Procedure which has one input Parameter and one output parameter . VB.net code is below
[Code].....
I want to have a "template" function that can receive different parameter and a type parameter, like:[code]But Vb told me that tupeList is not defined... is there a way I can do that?
View 2 RepliesI have a method which requires a parameter to be passed in. I would like to use the Addhandler to call the method through a dynamically created button control's click event.
When I include () in the AddressOf, VS complains: 'AddressOf' operand must be the name of a method (without parentheses).
When I exclude the brackets, VS complains: Method '...' does not have a signature compatible with delegate...
My code:
CODE:
One of the things that I think is really cool about VB.NET is how built-in functions and subs have extra help text in their ToolTips like "Expression: String expression to search for replace string." as well as the usual "Replace(...parameters...) as string" text. So are the pop up boxes with things like "CompareMethod.Binary" or "CompareMethod.Text." And finally I like how some functions and subs have different sets of parameters for the same routine. For example, New FileStream() starts with either a path (string) parameter or handle parameter, but none of the 15 sets of parameters contain both path and handle parameters. Is there a way that I can set up the classes and functions I write to use these things or do they only work with built in classes and functions? If there is a way, what are the proper names for them so I can look them up in the VS/VB documentation? I would be happy enough if someone would give me an example of them, but it would be nicer if I could go through the documentation and find out if there are other cool things that are related or near by.
View 3 Replieshave an idea on what i am doing wrong here:
Compiler Error Message: BC30455: Argument not specified for parameter 'dteRDate' of 'Public Sub New(strOName As String, strOAdd As String, intOPhone As Integer, strVer As String, dteRDate As Date, dteWDate As Date, strONote As String, strOrName As
[code].....
I have a vbscript that runs under asp page. I need convert the code to VB.NET
SET objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = Application(DB)
With objCommand
[code]....
What is the VB.Net that will do exactly the vbscript does? I like paramer(0) and 1 and 2 etc since I don't need to define the parameter(0) as integer or varchar etc. I remembered I have discuss this before and it is possible to do in VB.NET?
Basically in visual basic 6 I could access word tables in existing templates with the code owordactivedoc.tables(1).select() where owordactivedoc refers to the active word document and tables(1) refers to the first table in the template.Trying the same code in VB 2003 just leads to errors. Secondly how do I access bookmarks or alternatively word variables.Furthermore how do one deploy web.services. For example the current program I am building is for another computer. Simply copying the web service to Inetpubwwwroot dont work because it is not picked up by the Internet Information Services program. I have to create the web service in vb2003 on the other computer change msconfig manually. Copy and paste the existing service vb file in the created folder replacing the empty vb file.
View 3 Replieswhere i put the *'s i get the error "The parameter 'address' cannot be an empty string. Parameter name: address".
Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer2.Tick
Dim mail As New MailMessage()
Dim SmtpServer As New SmtpClient
[code].....
I have a DEM file(Digital Elevattion Model File) and I am trying to open the file,where we have Latitude and Longitude values inside the DEM file.And, Now I have opened the file using Filestream and Read the file using BinaryReader.But, I am having a trobule in getting the values of Latitude and Longitude.I am getting Byte values randomly as 1,202,31,271 etc.But, we dont have latitude and longitude values more than 180,and also I am not getting 16 bit UInt values.For example, the values should be like Latitude 20.00416666666667 and Longitude 39.99583333333333.So,read the correct Byte values of the DEM file.The code I have used till now is:
Dim fs As FileStream = New FileStream("C:UsersadminDesktopHeader and DEM fileE020N40.DEM", FileMode.Open, FileAccess.Read)
Dim rd As New BinaryReader(fs)
Dim convertDB As UInt16
For i = 0 To rd.BaseStream.Length
[code]....