I want to query items from countries that are selected from a treeview (with checkboxes). However the number of countries that is selected by the user is not known beforehand. So how can I make a proper query when the number of OR operators is unknown? For example: SELECT DISTINCT Item FROM Countries WHERE Country LIKE @c1 OR @c2 OR @c3 etc� and then add the parameter values based on the selected countries in the treeview. I looked into parameter arrays but can�t make sense out of it really
I am trying to design a Function/Sub that will need to accept a variable number of parameters. Catch is that the parameters being passed are arrays themselves. As i understand it when you pass a variable number of arguments to a method, you pass them via an array. What im looking for is to make a method that would accept this form:
I have a dataset connection to an MS Access database. I want to use IN operator in WHERE clause like: WHERE DepartmentID IN (1,2,3)This means that all record with an ID of 1, 2 and 3 will be filtered. But the problem is I cannot create a parameter like:
I don't know if I worded this properly, but I have a mdb query that I display in a Datagrid on my form. The first column is TransactionNumber, which is the primary key and a running total (ex. RackingTransactionKey=RackingTransactionKey + 1). What I need to do is when the form is opened, find the highest (last) TransactionNumber from the query or Datagrid and assign it to a variable (RackingTransactionKey), so I can can update it (+1), therefore generating a unique number so I can add data to the query.
I am getting the error:"Range variable 'sender' hides a variable in an enclosing block or a range variable previously defined in the query expression."for this
Imports System.Data.SqlClient Imports System.Linq Public Class Form1
[code]....
I can select any other item from the table without the error. "sender" has the same properties as "receiver" in the SQL table.
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ? or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
I have a problem with a sql query. Through the query I am trying to search database for any occurrences of string (can be anything) in a column using the SQL LIKE command. The problem is that it works fine for most of the strings say john, jim, ji"m , but does not work when i include the following characters which are ( ' , { , } , and a single quotation mark). MYSQL query takes care of these special cases by putting them in [] block whenever user enters them .But i am getting the following error when i go to query the database using the GetSelectCommand() in VB.NET
Exception Details: System.ApplicationException: Number of values provided must be equal to the number of placeholders in query.I have checked the query over and over again .. but its fine .My database server is Sql Server 2008.So my application throws the exception in this command:
Using reader As MustDisposeDataReader = _ pmSystem.DatabaseManager.GetSelectCommand(selectStatementBuilder.ToString(), New Object() {})
Where MustDisposeDataReader is an instance of a class in an internally developed library, which inherits from System.Object. pmSystem is an instance of the class PlanManagerSystem which implements the commandlayer. GetSelectCommand() takes the select command
In VBE I have a combobox, a button and a listview. SELECT * FROM table WHERE description = @cmbDescription.text
My combobox has three items: 1 All 2 Item1 3 Item2 4 Item3
When user will select any Item the query will return the data related to that Item. My question is how to implement if user selects the option ALL in the combobox.
Dim connStr As String = "connection string goes here" Dim conn As New Odbc.OdbcConnection(connStr) Dim comm As New Odbc.OdbcCommand("insert into mytable values (0, @P1, @P2, null, @P3, 'n')", conn)
[Code]....
I get "A syntax error has occured." It appears as though my parameters aren't getting replaced with the values I'm telling it to use.
When I run this code : Dim username As String = TextBox1.Text Dim pass As String = TextBox2.Text Dim con As New OleDb.OleDbConnection con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=""C:Documents and SettingsSaeedMy DocumentsVisual Studio 2008Projects [Code] .....
I get these error message: "No value given for one or more required parameters." at the line: dr = cmd.ExecuteReader(CommandBehavior.Default) what is the error.
How do I get Linq to ignore any parameters that are empty? So Lastname, Firstname, etc? If I have data in all parameters it works fine...
refinedresult = From x In theresult _ Where x.<thelastname>.Value.TestPhoneElement(LastName) And _ x.<thefirstname>.Value.TestPhoneElement(FirstName) And _ x.<id>.Value.TestPhoneElement(Id) And _
I'm trying to bind a datagridview to a tableadapter which contains a query that requires parameters (for the WHERE statement of the query). The datasource is a SQL Server database. When I bind the datagridview in design view, it does not let me choose which tableadapter method I would like to use. The way I've been fixing this is to go into the code behind that form, where Visual Studio puts in some auto-generated code that fills a datatable in the dataset and I change the method that it's using there and put in my parameters. I don't think this is the proper way to do it, however, especially because sometimes that code doesn't even get generated! My other solution is to just programatically bind the datagridview to a datatable which I have filled using the tableadapter. This seems like more work than it should be, though.
I'm trying to update an Access database by using an OLE connection, retrieving the information from textboxes where the user enters the new information.All the fields in my Access table are required fields, so I have validated that some info is entered in each one of the textboxes and that is the correct data type.But when I run the update query I get an error message saying something like values haven't been entered for some required parameters (my Visual Studio is the Spanish version, so I can't give the exact error message in English).The bit of code where the error occurs is inside the procedure called by my "Ok" button:
Dim campo1, campo2, campo3, campo4, campo5 As String Dim campo6, campo7, campo8 As Double Dim campo9, campo10 As Integer
[code]....
(I didn't post the whole code inside the procedure, but of course I'm creating the connection and everything)
The table has 10 fields, and the data is read from the textboxes and stored in variables (campo1, campo2, campo3, etc.), which I'm then using in the "set" query command.
"id" is the first field from the selected row in the datagrid, which I'm sending as a parameter to the procedure called by the "OK" button.The error message shows at runtime, so I'm guessing it's something in the query. Am I writing it correctly?
Is it possible to have a class, sub or function declared with an arbitrary number of parameters? And those parameters be a type, like generics? For example
vb.net Public Class Test (Of T1, (Of T2))'The (Of T2) means that after the first parameter can be an arbitrary number of parameters
I have a search function de build.We are using pure ASP.NET w VB.NET We have multiple DropDownLists and we're building a search query with whatever was selected in those DDLs. My question is, how can I handle the blank values (unselected dropdownlist values) with the SQL Query ? I'm using AND operators in the query so if anything is blank it'll fail the search. If the dropdownlist has no selected value, i don't want the value to be part of the search. It would be easy to code with just 2-3 parameters, but we're looking thru at least 10 items and doing a SWITCH CASE or multiple IFs would soon become mayhem.
In one function I have the variable: dim StrProjectNumber = UCase("23-EXP-16284")
However in another form I want to use that same variable in a SQL query, and when I try it says the variable is not declared. Do I have to make a global variable or is there a way around it? If so, how would I go about declaring a global variable?
Is there a way to create a method with unknown number of parameters? And if it this the case: How is it possible to get access to them within this method? Do they have to be from the same type?
GOAL: 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.
In the example below, what would you name the parameter given that it is used to initialize the property FromDate?For class constructor methods, I like to have the name of the constructor parameter variable match the name of the property which is being initialized. For example, the parameter "fromDate" is used to initialize the module level variable "_FromDate" with the statement _FromDate = fromDate. Likewise, I could have alternatively written Me.FromDate = fromDate.
Proponents of C#'s case sensitivity would probably say that using a leading lower cased letter for the param variable name, which I believe is MS convention, is an acceptable approach to distinguish it from the Property of the same name but different casing.
However, VB is not case sensitive, which I generally appreciate. In the following example, I am using a param name that matches the property name, 'fromDate," and VB refers to the local instance when there is ambiguity. However, many would probably argue that this "ambiguity" introduces the opportunity for the developer to get confused and not realize which variable is being used. For example, my intent below was to have TWO params passed in, "fromDate" and "toDate" but I accidentily ommited one and as a result, the VB.NET did not warn me of the mistake because it assumed that the statement _ToDate = ToDate was equivalent to _ToDate = Me.ToDate instead of informing me that the variable on the right side of the assignment statement was undeclared.
Public Class Period Property FromDate As Date Property ToDate As Date
[code]....
In my judgement, we should have a convention for prefixing all parameter variable with a prefix, but hasn't the use of prefixes been discouraged by Microsoft? For example:
Public Sub New(ByVal paramFromDate As Date, paramToDate As Date)
..or maybe it could be shortened to pFromDate, pToDate...
I'm trying to get some data from an access database and show them in a CheckedListBox The sql quary includes a variable('sport') and it's values is passed by the user when I run the following code an exception is thrown at the line adStudentList.Fill(dsStudentList, "Register") and it says 'no value given for one or more required parameters'
Dim adStudentList As OleDbDataAdapter Dim dsStudentList As New DataSet Dim sport As String sport = cmbSportList.SelectedItem
I am trying to get the value of a Query and save it to a variable, The only way i have been successful is through creating a loop and then saving the value of the location...
Below is the
Dim DBConn As OleDbConnection Dim DBCommand As OleDbDataAdapter Dim DSPageData As New DataSet
By this way combobox CmbId is storing above sql query ouput. But now i want to get above query ("Select Name from StudentDetails where Id=10 ") result to store in a variable string. How can i do this ?
I have remplace the keyarr definition by my SQL query: With the code above, I can print both keyarr in a console. What should I change in the _sqlReader.Read() function in order to get keyarr definition like the first code. I would like that keyarr could be interpreted by the rest of my code.
I have 2 public variables that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query. [code]...
