Asp.net - Building A Valid SQL Query With Optional Parameters For Search Function?
Oct 20, 2011
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.
View 1 Replies
ADVERTISEMENT
Nov 3, 2010
I am interacting with VB code on a different tier, using a client-side c# program. The VB function signature looks like this:
Public Sub toggleExclusion( _
ByVal mouse As Double, _
ByVal study As Integer, _
[Code]....
I get an error saying no overloaded method of toggleExclusion takes 2 arguments?
View 3 Replies
Mar 24, 2011
I am creating a mediaplayer / playlist creator tool that basically imports MP3 songs into playlists (grids). I'm looking to add search functionality where the user can search all open playlists (or a subset of the open playlists). A Playlist is basically a collection of AudioFiles, where an AudioFile is a class that holds the filename of the MP3 file and then exposes the tags (Title, Artist, Album, etc) in public properties.
The idea is that the user can search for a certain expression (for example "the"), and that he can then choose whether to search in the title, in the title and artist, in the title or artist, in the title, artist and/or album, etc. However, I'm having a hard time implementing this and also having it kind of dynamic.
At the moment I am simply gathering all the AudioFiles from the open playlists (or from the subset of playlists the user chooses) and then running a simple LINQ query to find those AudioFiles where the Title contains the search text. Then I display the resulting AudioFiles in a new playlist window:
[Code]....
In case the AND / OR distinguishing is too hard, I would be happy to start with just letting it default to 'OR', so that the user can check Title and Album for example. If he would then search for 'a' then all songs that contain 'a' in their title as well as all songs that contain 'a' in their album should be returned. I guess that makes it easier, but I still wouldn't know how to dynamically create the LINQ query.
View 2 Replies
Apr 10, 2009
I tried out the video tutorial from Beth Messi about how to create a search. The tutorial teaches us how to do it through query builder in which we just have to type LIKE@fieldname = '%' for each field we wish to appear on a toolstrip. A toolstrip menu will automatically be generated and placed underneath the form bar for us after we click ok.
Now, I would like to know how can I do this with code? I can use a code which will move the auto generated toolstrip into the tabcontrol but when I have more than 1 tabcontrol, that's when I start having problems - the toolstrips are starting to cover up the tabcontrol. I know I can move the datagridview lower but that is going to leave a big space above it.
View 4 Replies
Aug 6, 2010
However, I am wondering if there are any workarounds or plans for incorporating this feature into VB.NET in the future?What I'd like to do:
Public Delegate Function Deserializer(Of T)(ByRef Buffer() As Byte, optional ByRef BufferPosition As Integer = 0) As T
'Implementation of a func that matches the delegate'
Class A
Public Function Deserialize(Byref Buffer() as Byte, optional Byref BufferPosition as integer = 0)
....
In the absence of specifying "optional" inside the actual delegate itself, it'd at least be nice to be able to do it in the function implementation only:
Public Delegate Function Deserializer(Of T)(ByRef Buffer() As Byte, ByRef BufferPosition As Integer) As T
'Implementation of a func that matches the delegate'
Class A
Public Function Deserialize(Byref Buffer() as Byte, optional Byref BufferPosition as integer = 0)
....
At least this second way, the functions for the delegate will always have a value mapped to each parameter, although some may come from the function side and not the calling side.
View 2 Replies
Dec 21, 2010
I tried DbNull.Value but no luck. How do I assign a default value as null to a string parameter that is null in VB.NET? Its litte strange to see that VB does not have anything like plain null as most of the other languages do. Also what is the difference between null and DbNull and Nothing.
View 3 Replies
Aug 9, 2011
What is the standard way to implement optional query parameters in a .NET WinForms application?In other words, only query on a field if the value of a corresponding control is not null.
EDIT: I use a FillBy method which calls a query in my Access database. In the TableAdapter query editor, I just used WHERE (field1 = ?) AND (field2 = ?) ... I just can't find the "hook" to bind form controls to the table adapter query parameters and so that if a form uses the default value to not query on it.
View 2 Replies
Jan 21, 2011
Public Function Foo(ByRef a As AClass, _
Optional ByRef b As BClass = Nothing, _
Optional ByRef c As CClass = Nothing) As XClass
Error : Optional parameters must specify a default value.
View 2 Replies
Jan 12, 2010
I would just like to know why. optional parameters cannot have structure types?
View 4 Replies
Mar 22, 2011
I have an object, called 'PERSON' This person object has a title, firstName & Surname property as well as many other which are at the moment irrelevant. It also has a read only property called Fullname which concatenates the two or three parameters mentioned above depending on an optional parameter 'withTitles' passed over when you call PERSON.FULLNAME
PERSON.FULLNAME(true) <- Will add titles if there are any
PERSON.FULLNAME(false) <- Will give the name without the title
Public ReadOnly Property FullName(Optional ByVal withTitle As Boolean = False) As String
[Code]...
I get an error: PERSON does not contain a property of 'FullName'. If I change this to any other property that does not take a parameter it works as expected. Now I'm guessing that the binding procedure can't handle optional or mandatory parameters for object properties, is this right? Is there a better way to do it? I thought about looping through the collection to add them manually but that kinda defeats the object of DataBinding!
View 1 Replies
Apr 27, 2011
Is there an equivalent in Java to VB.NET's optional parameters?Also is it possible to switch on anything other than integers in Java?
View 1 Replies
May 27, 2010
Is it possible to make Color variable parameters in custom classes Optional?Everytime I try, it gives me a "Constant expression required" error.[code]
View 2 Replies
Oct 6, 2009
I was familiar with the optional parameters in vb 6 and it made sense given the capabilities of the language but why the heck does VB.Net support optional parameters when there is method overloading? Which one should I use and is there a difference? If there is a difference when should I use each one?
View 4 Replies
Sep 7, 2010
I have a custom Attribute class where the constructor takes one fixed parameter and two optional parameters. It is my understanding that one can supply one or more optional parameters by using 'named parameters' such as this:
Private Sub CallMethod()
Me.OptionalMethod(-1, z:=1)
End Sub
[code]....
Well, I thought, perhaps Attributes don't support named parameters. I know they can behave a little weird (they don't support all types in their arguments for example I think), so I thought little of it.But then... I noticed something else. If you take a look at my code of the attribute class again. Notice that I am using an attribute on that class as well... And what do you know: named parameters. Working just fine... The AttributeUsage attribute has the exact same configuration: one fixed parameter and two optional parameters. I seem to be able to call them using named parameters just fine, where I cannot call my own attribute constructor with named parameters...
View 3 Replies
Jul 10, 2011
Trying to search a database from vb.net I have the following function
[Code]...
No value given for one or more required parameters. I found the code in a vb.net book someone lent me. It doesnt work at the moment and I wondered if I have everything correct the bit at the top in brackets (Phone LIKE?) is that saying check if there is a row in the 'Phone' column that is the same? Because I am also selecting Phone (the column) in that line? Later I say compare to Form3.Textbox1.Text so I am not sure whether they should both be 'Phone' inthe SQL line? Is it saying that If it finds something display whatever is in the details column to display in the text box?
View 5 Replies
Jan 12, 2010
Most of our code base is in VB.NET. I'm developing a project in C# that uses a lot of the assemblies from the VB.NET code.There are three relevant classes in VB.NET:
[Code]...
View 3 Replies
Sep 16, 2010
I'm using a stored procedure to updateinsert data into a table using MERGE. One of the items being inserted is a VarBinary file. Now if I wish to add a new file it's just a case of using ReadAllBytes as below, to remove the file I pass DBNull. Now what if other fields are being updated but the file is not being changed? I want the field to remain untouched unless I'm replacing the file or deleting it as above. I cannot add the file via the parameter again as it may only exist in the database, unless I read it first and write it back which seems pointless. [Code]
View 1 Replies
May 13, 2011
I'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]....
View 2 Replies
Jan 27, 2010
I have an application that does a search of our database (exposed via EF) for records meeting certain conditions. We have two main tables (Jobs and Recipients). Recipients are linked to the Jobs table by a Job ID.The job record has various fields (Process Date, NameJobType). The recipient has a lot of Name and ID fields (e.g. Account Number, Surname, etc)
View 1 Replies
Apr 25, 2012
I have an application that does a search of our database (exposed via EF) for records meeting certain conditions. We have two main tables (Jobs and Recipients). Recipients are linked to the Jobs table by a Job ID.The job record has various fields (Process Date, Name, JobType). The recipient has a lot of Name and ID fields (e.g. Account Number, Surname, etc)I want to present a search screen where they see a list of fields to search on. The ASP.net code then sees which textboxes the user typed in (or selected), and builds a query based on that. [code] Where I'm stuck is figuring out how to add in additional where clauses. Should I just use Entity SQL?Can this return strongly typed EF objects as well? And is it possible to return both the Jobs and Recipients objects?
View 1 Replies
Oct 2, 2009
Currently working on a web-service with Oracle10g as back-end. Here is my problem.
1. The table I need to populate has 100 columns. I have no control over the design of the table.
2. I wanted to use the "deriveparameters" method of OracleCommandBuilder, but found out that this is "costly" in terms of performance. What I initially planned to do was to derive the parameters from an open connection, close the connection, then maybe cache the parameters obtained but I don't know if this is possible.
I am unsure how big of a hit the performance will get if I continue using the "deriveparameters" method WITHOUT caching the parameters driven. The environment is as follows
-intranet
-around 2000 users
-users spread out in different parts of the country
I am not familiar where they will put the web pages of the application, the web service and the database. I don't know if they'll be putting it in different servers or on one server, but that's something we cannot control too, that's why I am looking for the best approach.
I just don't want to hard-code all that parameters and if, for instance, we need to change some properties/parameters, it will be a pain to maintain the code. It would be nice if someone here can point a way to automate the whole thing w/o the performance of the system taking a hit.
View 3 Replies
Mar 14, 2012
How can i create a optional parameter in C# as we create in VB.Net
Public Sub Demo(ByVal a As Integer,Optional ByVal b as integer=3)
End Sub
I want to declare this in C#
[code].....
View 2 Replies
May 2, 2011
I can't figure out the syntax for having an optional byte array in a .net sub Public SubMy Function(ByValFilename as String,OptionalFileData as Byte())The optional keyword requires me to set a default value - which is understandable, but I cannot figure out the syntax to do that here. Public Sub MyFunction(ByValFilenameasString,Optional FileData as Byte(){0})
View 1 Replies
Nov 3, 2010
how can use color as an optional parameter in a sub/function?This doesn't work.
Code:
Public Sub WriteLog(ByVal sText As String, Optional ByVal lColor As Color = Color.Blue)
'Code
End Sub
View 5 Replies
Oct 19, 2011
I just got upgraded from VB6.0 to VB2010. I'm trying to move some of my program functions over and I'm getting an error on the ones where I use optional... Public Function GetFolder(ByRef FTT As String, Optional InitFile As String)
I get the error at the end of the line, after the close par...the error is "optional parameters must specify a default value".
View 3 Replies
Sep 7, 2010
I want to specify an List(Of String) as an Optional function argument. But i am unable to initialize it in the function declaration.
View 1 Replies
Aug 31, 2009
I have an Excel VBA function that takes a number of optional parameters, including an optional Range:
Function DazBeta(A As Range, Z As Range, _
B As Integer, _
Optional Freq As Integer = 1, _
Optional c As Double = 0, _
Optional r As Range, _
Optional Pct As Boolean = True, _
Optional Label As Integer = 1)
I am translating to VB.NET, and it's the optional Range that is giving me grief because VB.NET does allow optional Ranges. Or rather, optional parameters must provide a default value. What is the recommended way to change the VB.NET function signature so that the code is callable from an Excel cell as a UDF? (The VB.NET implements a UDF, the assembly is registered as a COM server, and the Excel spreadsheet is told of this server and type library, allowing the VB.NET code to be called from an Excel spreadsheet cell.) I have other compilation problems, so I have not been able to explore this. I am thinking that accepting an optional Object (default value Nothing) might work and then I could cast the Object to a Range. Alternatively, if there were a default value that could be specified with an optional Range, that would work, too.
View 1 Replies
Sep 18, 2009
My problem is this (apologies if this is a little long ... hang in there):I can define a function in VB.NET with optional parameters that wraps a SQL procedure:
Sub Test(OptionalByVal Arg1 As Integer _
Optional ByVal Arg2 As Integer _
Optional ByVal Arg3 As Integer
[code].....
View 7 Replies
Jan 4, 2011
I am working on a program. I created a database and used it to create a dataGridView in my program. I clicked the table adapter for the program and tried to create a new query. When I did this, I got the following error messages...Error message-the new command text returns data with schema different from schema of the main query check your query's command text if this is not desired Schema returned by the new query differs from the base query I cannot create a query for the database. What is a base query and what can I do to fix this?
View 7 Replies
Dec 12, 2010
I'm using the code below to search in XML files depending on the values entered in the text boxes, problem is I don't know how to combine the search statement with an "AND" when the users enter data in both textboxes. Can you please help me solve this problem? I am using VB.NET (VS 2008). Error "column can't be found is on line "Dim DV As New DataView(dt, "Receiver like " & "'" & C1TrueDBGrid1Donor.Columns(1).Value & "'" & "", Nothing, DataViewRowState.CurrentRows)"
[Code]...
View 6 Replies
