Is there any way to pass multiple values (a list of values) to a query via ODBC Parameters in VB.Net?
For instance, is there a way to create a query along the lines of:
-- vb.net has something like Dim itemNumbers As New List(Of Integer)(SomeCount)
SELECT Cost, Description
FROM MyItemList
WHERE ItemNum IN (<my list of item numbers>)
My Source code is
Imports System.Data.Odbc
Public
Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code] .....
The table1 contains two parameters name and emplyoyee no. I am using Odbc driver. The connection is ok. But I am getting the error
An Odbc Exception occurred : {0}ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
I'm connecting succesfully to an Oracle 10g DB with an the Microsoft ODBC for Oracle driver.Regular queries without parameters work fine, but parameterized queries act as if the parameters aren't getting passed in.ex.
--this works fine
Select * from tbl1 where column1 = 'test'
--this doesn't
select * from tbl1 where column1 = ?
--odbc string parameter 'test'
Here's what my connection string looks like:
"Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
[code]....
I use codes below to inserts values to database by executing stored procedure.
Dim connstring As String = "dsn=test"
Dim oConn As Odbc.OdbcConnection = New Odbc.OdbcConnection(connstring)
Dim com As New Odbc.OdbcCommand("{? = call sp_test1(?,?,?,?)}", oConn)
[Code]...
In VS 2008, VB.Net, I am successful connecting to a local SQL Server (version 8) and seeing all tables/views/procedures in Server Explorer. The local OS is Win XP Pro SP3. I created an ODBC data source to a remote SQL server (also version 8) with a database of the same structure as the local one. The connection tests out ok. The remote computer runs Windows Server 2000 SP4. In the VS 2008 Server Explorer I add this ODBC source. When I click on the plus-signs to expand items, neither the tables nor the views show anything, whereas the full list of procedures appears. Is it the old SQL Server version? Is it the old Server OS version? Something else alltogether?
View 2 RepliesIn VS 2008, VB.Net, I am successful connecting to a local SQL Server and seeing all tables/views/procedures.I created an ODBC data source to a remote SQL server with a database of the same structure as the local one.The connection tests out ok. In the VS 2008 Server Explorer I add this source. When I click on the plus-signs to expand items, neither the tables nor the views show anything, whereas the full list of procedures appears.How can I see the lists of tables and views in Server Explorer for an ODBC source?
View 1 RepliesI'm trying to insert values from my asp.net application into my MySQL database.
On the register page people can fill in Name and Pass and press submit.
Public Function InsertMember(ByVal objMember As Member) As Boolean
[Code]...
Is there a way to get a list of ODBC drivers that are installed on a Windows XP machine from .NET?
I basically would like to see (in .NET) what is in:
Control Panel->Administrative
Tools->Data Sources (ODBC)->"Drivers"
Tab.
Option Explicit
Private Declare Function SQLAllocEnv Lib "odbc32.dll" (phenv As Long) As Integer
Private Declare Function SQLFreeEnv Lib "odbc32.dll" (ByVal hEnv As Long) As Integer
Private Declare Function SQLDataSources Lib "odbc32.dll" _
(ByVal hEnv As Long, ByVal fDirection As Integer, ByVal szDSN As String, _
[code].....
Can anyone tell me how to list ODBC and OLEDB drivers that are installed in the windows system?
I want to display them in a DGV and create a connection string from the users choice.
XP,Vista and Widows 7
I have a small vb.net application that fires a crystal report through crystal viewer.
The report uses an ODBC connection provided by 32-bit software accounts package, which is installed in the ODBC 32-bit This all works fine on 32-bit XP and 32-bit Win7 with no problems, When run on a win7 64-bit machine the application launches ok, but when it comes to running the report, it prompts for a database logon box for the odbc connection.
When the report is run seperate on its own, on the exact same pc through crystal reports desginer it runs fine, Its almost like the application is not picking the 32-bit ODBC set up is it the case that the connection needs to be coded rather than using the report connection,
how to print out and sql statement, with parameter values? here is an example of what i have:
[Code]...
I am writing a alternative to GDI, and rigth now i am working at a logging function. The idea is that while you use the class to draw, it will write a logg of what you have done, which can be used to draw it back later. In that way i would be able to store a drawing with weary little disk usage.
[Code]...
I have a little challenge. I have a report that I declared a parameter called Department that has default values like this: [Code] The problem is that when I test this (with CR10 or on web), and I select multiple values, the thing does not show the values for the multiple values. It only works when I select a single department. What should I do?
View 2 RepliesI have the following test method (VB.NET)
<RowTest()> _
<Row(1, 2, 3)> _
Public Sub AddMultipleNumbers(ByVal number1 As Integer, ByVal number2 As Integer, ByVal result As Integer)
Dim dvbc As VbClass = New VbClass()
Dim actual As Integer = dvbc.Add(number1, number2)
Assert.That(actual, [Is].SameAs(result))
End Sub
My problem is that when the test runs, using TestDriven.Net, the three method parameters are 0 and not the values I am expecting. I have referenced the NUnit.Framework (v.2.5.3.9345) anf the NUnitExtension.RowTest (v.1.2.3.0).
I'm a beginner in VB.NET programming.. Please help me on how to pass SQLParameters in the below function..
This my code:
[Code]...
I'm almost sure that I've seen this somewhere, but I can't find it anymore. Or maybe I'm imagining it, which would'nt be strange either.
When creating a sub or function and adding parameters used when calling it.
-Is it possible to list the parameters that I can enter when using it somewhere in my code?
E.g.
Public Sub MessageMain(ByVal Message As String, ByVal MessageType As String (List of possible values for MessageType)) Same for example as when you have boolean values in a sub/function. As soon as you use that somewhere in your code intellisense will present you with True/False to select.
I'd like the same for parameters in subs or functions I create and calling them from somewhere in my code. Saves me the trouble of remembering which options are available for those parameters.
I gat a problem in the .NET 2 in VB . I would like to use List(Of T).Find method with parameters. in C# v.8 this task is accomplished by using anonymous delegates like:
[Code]...
Impossible in VB.NET 8(?) List.Find Parameters and Anonymous Delegates
View 3 RepliesThe FxCop says in a rule that generic List should not be exposed to the outside world.But I do not understand why and what is the replacement for the generice List? url...
View 4 Replies[url]...base on the thread ive linked.
i am able to pass the checked value of the checked list box to a list box
my current problem is
i am going to save the values [ for instance mat_name ] on the listbox in the database
but i need the id [ for instance mat_id ] of that value
For example, assume that in my assembly, in Namespace A, Class B, there is an instance method with the following signature: void Test(string someString, int someOtherParm, string someOtherString ); This method is called multiple times, from multiple places in the assembly. I would like to be able build a list of all invocations of this method and the value of the someString/someOtherString (assuming they are hardcoded). In other words, I like to extract a list of calls like the example one below, if they happen in the assembly somewhere: Test("some text", 8, "some other text");
View 1 RepliesGOAL: Bind nested ListViews to LINQ generated iQueryable of anonymous type. I want to use LINQ because you can use GroupBy and bind the nested ListView to the 'it' keyword.
SETUP: I have groups of sets of conditions. Each set of conditions is stored in the BillingCodes table. Each group of BillingCodes is stored in the BillingGroups table.
I have a custom object that stores the ID, Name, and NumCodes for each BillingGroup that the user has chosen.I have a collection of these objects called GroupsList that has a list of the groups that the user has chosen.
Problem 1: I can iterate through GroupsList and grab all the IDs. How do I translate the SQL 'WHERE ID IN(a string of comma delineated IDs)' for LINQ to SQL? Is that the best way to do that?
Problem 2: Once I have the list of BillingGroups I need to iterate through each group. For each group, I need to iterate through the BillingCodes. For each BillingCode I need to generate a WHERE clause that has all of the conditions in the BillingCode. I propose something like so:
for each BillingGroup in BillingGroups
for each BillingCode in BillingGroup.BillingCodes
where1 = "..."
next
next
Problem 3: Here's the part where I don't have a clue. I need to dynamically create a query in LINQ to SQL. Keep in mind that I don't know how many groups there'll be or how many codes are in each group.
There are 2 tables:
**transactions**
transaction_id
patient_id
[code]....
i am new to vb .net i just want to ask why is it i don't see the odbc data adapter in the toolbox pane? i just have (under data) pointer, dataset, datagridview, bindingsource, and binding navigator.
View 3 RepliesI'm writing a query to select all records that has any part of parameter. I have one table called Employees. Some people have name like this: John David Clark If the parameter is
[Code]....
I should be able to get result back as long as there's a match in the parameters. If I use Function Contains (q.FirstName & " " & q.LastName).Contains(employeeName), I will not get any result back if employeeName is "John Clark" Function Contains looks only for next words from left to right. It doesn't match a single word at a time. So that's why I used this in the Linq to SQL:
[Code]....
I am getting error [07002] the # binded parameters < the # of parameters makers, i checked both parameters were perfect even though i am getting this error here is my code
[Code]...
I have a listbox that i have generated some values in currency format.
i am trying to write some code that will add the strings and generate a grand total.
the list box can hold from 5 to infinite entries so i need a generic do untill end of item index or some such.
I am trying to code the calculate button on a form to add the values that were entered from the user and displayed in a list box. For example, the user enters grades of 90, 95, 88, 74. I want to get the sum of 347 so that I can continue with my calculation to display the average.
View 3 RepliesI have an array list that stores Hexadecimal numbers, I want to Xor all of the values in the array list e.g. array list contains 3A, 4B, 5C; I want a output textbox, Textbox1.Text = 3A Xor 4B Xor 5C
View 2 RepliesI have been searching everywhere but I am unable to find a reference to what I need.I have a huge number of entries where each entry is composed of three long numbers:
a b c
1 2 40
2 1 40
1 8 12
3 9 13
8 1 12
ect.
in my algorithm I will find that I need to disregard values in column a which will then lead me to disregard values in column b. I initially thought that I may want to use three arrays and just change the disregarded value to a null value with each iteration. find function that would allow me to not have to loop through the entire array every time.This lead me to want to define the columns as lists where I could remove specific values from the list and reduce the size of the list with each iteration of the algorithm. The problem then is how do I say, listb.remove(8) and at the same time have the corresponding values for lista(1) and listc(12) removed?