I am building a module using linq to SQL and I am running into some problems. I have been following Michal Washington's tutorial on [URL]. The problem is that VB does not recognize my Complaint Class when I try to create new Complaint object. why I am unable to Dim a Complaint object? Here is my code:
[Code]...
given this function:
Public Function Search(ByVal StartIndex As Integer, _
ByVal MaxResults As Integer, _
ByVal AccountNumber As String, _
ByVal LastName As String, _
[Code]....
instead of what I expected:
Select count(*) from remitline where lastname = "smith"
What am I doing wrong building up the where clause? I'm using Castle ActiveRecord 2.1
I have a listbox which users can select from a list if Towns, I want to be able to build a LINQ query based on the selected items in the list e.g.
[Code]...
I am building an xml file with the help of Linq queries and I'm not sure why the code below doesn't work.[code]
View 1 RepliesI need to build a dynamic linq query with or operators. I have seen PredicateBuilder but that is in C# and my project is in VB. Basically I need to build a WHERE clause similar to this:
Where((this = 1 AND that = 2) OR (this = 1 AND that = 4) OR (this = 2 AND that = 4))
but the problem is the number will have to be determined dynamically at runtime, and added using a loop, like
for each item in myItems
query = query.OR (this = item.a AND this = item.b)
next
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.
I have built a database structure that represents a category tree to help classify some of the data we have stored. The implementation is that each record in the Category table has a nullable foreign key back into the Category table to represent the parent Category of this category (one-to-many), essentially allowing for subcategories within a broader parent level. There is a CategoryMembership table that links a record in the Item table to its respective Category (many-to-many). I have created the DBML for this database, and it has a member access structure that includes the following:
[Code]...
've got a function that takes two parameters (a delegate and an integer) and then creates a LINQ MethodCallExpression, which it uses to gets the results:
Public Delegate Function CompareTwoIntegerFunction(ByVal i1 As Integer, ByVal i2 As Integer) As Boolean
Public Function Test(ByVal pFunc As CompareTwoIntegerFunction, ByVal i1 As Integer, ByVal
[code].....
how we can declare a connectionstring in a module and call that module
View 1 RepliesI have a VB.Net interface that communicates with an Access 2k3 Database using this module:
Module MOD_ENGINE
'Declare Database connections controls
Dim con As New OleDb.OleDbConnection
Dim dbProvider, dbSource As String
[code]....
I want to call EngineConnect procedure from MOD_ENGINE module into popCboBox module so I can ignate the engine!
if there is that much of a performance gain in running a LINQ stored procedure versus a LINQ query?
View 1 RepliesI have a listbox on my xaml form that I bound to a List(Of MyType) property. I populated this list like so:
Dim fields As List(Of CheckableFields) = New List(Of CheckableFields)
Using context As ITIPEntities = New ITIPEntities()
Try[code]....
Now I'm at the point where the user selects the fields they want included in a report and I need to iterate over the required fields. This is my linq query:
For Each checkedField In _requiredFields
If checkedField.IsChecked Then
If checkedField.FieldData IsNot Nothing AndAlso checkedField.FieldData.Trim IsNot String.Empty Then[code].....
Example-I have a person class
Public Class Person
Private _fname As String
Public Property Fname() As String
[Code]...
Forgive my ignorance on this.I have this LINQ Query:Dim ngBikersDataContext As New CarBikeWalkDataContext
bikersList = (From c In ngBikersDataContext.Reg_Bikers _
Order By c.L_Name _
Select New Bikers() With { _
.BikerID = c.BikerID, _
.F_Name = c.F_Name, _
[Code]...
with the error "Overload resolution failed because no accesible 'Select' accepts this number of arguments."
Over the "NEW" I get an error " ')'expected."
I have a search engine that will use a webservice to search through my database to find 3 specific things. I don't even know if it will work like this, but I have a dropdown list on my main page to select Product, Feature, Description. From what the user selects, the webservice should then go to an if statement to use the correct SELECT statement and find results for the search.
Will someone help me figure out how to fix what I've written to make it work? Please don't be too critical, I don't have a lot of experience. I have also been researching SQL Injection because I have a lot of code that is vulnerable so keep that in mind when you look at my code.
I can't get the blue squiggly lines to go away that are underneath the DropdownList1.Value instances on the WebService page.
WebService:
<WebMethod()> _
Public Function GetCompletionList(ByVal prefixText As String, ByVal count As Integer) As String()
Dim Feature As String = DropDownList1.Value
Dim Description As String = DropDownList1.Value
Dim Product As String = DropDownList1.Value
[CODE]..........................
Default.aspx page - Here I need the dropdownlist to tie to the database somehow.
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
[CODE]........................
I was looking at making a program which can then build other seperate .exes, is this possible? For example the user types their mail username/password into my program then this builds a seperate one which just connects to their mail with their username/password.
View 2 RepliesI am doing a project on the CRM application which sending and receiving sms using the vb.net language. I am no where to conclusions of my project because I could not build the application. I have found many examples but the problem some of the examples some uses the sms gateway or the AT commands. I could not differentiate which one to use? I have a dateline to finish this project of mine.Most of the example does not look like a CRM application.
View 2 RepliesI have a little bit of trouble figuring out why I am getting these error messages. Here is the error messages and then the code will follow behind it.The code is taken directly out of the book "ASP.NET 2.0 Everyday Applications for DUMMIES". [code]
View 6 RepliesWanting to know the best method to use if building a small app that will intereact with the web using usernames and passwords, captcha's etc.....
I'm thinking Window's Form but can you use captcha's in a windows form?
relatively new at using Visual Basic, and I'm trying to make a decathlon calculator. My question is how do I make a blank array, and after each person is done calculating their decathlon score it adds the persons name, school,(which are both in text boxes) and score(which is calculated into a textbox) to the blank array
View 4 RepliesI am trying to write simple database application and try to understand ADO.net as well.say I have 2 table
1. table emp with the following field (empId, empName, empPhone, salary, deptId)
2. table dept with the following field (deptId, deptName, deptLocation, deptManager)
emp table is link to dept table via deptId.so I try to build a form with 2 data grids the top will be dept data grid and below it is emp data grid.I try to do this with out using the wizard so I know the flow and understand how to link together step by step.
in the form load section:
dim conn as new system.data.sqlclient.sqlconnection(connectionString)
dim daEmp as system.data.sqlclient.sqldataadapter
dim daDept as system.data.sqlclient.sqldataadapter
[code]....
I am kind of stuck on what to do next, I think the next step is to creat dataview from my understanding before mapping it to the datagrid, but on data grid documentation it say it can only filter datarow, it can't filter data column on the dataview.
I would like to be able to display deptName, deptLocation, no the whole column on the table to data grid, and when user select a record from dept datagrid then the employee info (empname, empphone, empsalary) is display on the second grid (again not the whole emp column table).
the user can update, add or delete emp record from employee data grid by clicing on update button, on update button callback routine I need to put something like.
daEmp.update()
from what my understanding then I need to create update, insert and delete routine and attach it to daEmp so the data grid know how to sync with sql server, so when the user say add new record since the data grid doesn't have all the field display, i.e deptId column is not on data grid, how the table know what the dept id would be? I'd like to learn without the wizard 1st since once I know how everything is link then it is easier to debug since the wizard create lots of file and it's everywhere which make it very hard to understand what is happening for someone new to vb & ado.
Okay Is there a way In vb.net to create an exe from a predefined script, for example rather than writting the methods and subs into the codedom code could I just have a textbox that I could put a script into and then have that built? (obviously omitting button presses and things.)
Im not worrying about ui's at the moment just and exe (hello world style )
Are there any tutorials for this?
Code: None
Possible Duplicate:Building F# library to be used in C#
Let's say I have the following function.
let rec fib n =
match n with
[code].....
building webpages is it possible with vb
View 2 RepliesWhile I'm trying to build a solution after I've changed a little in its code it gave me an error and even when I've removed the code the same error appears.
"Unable to find manifest signing certificate in the certificate store." (That is the Error and it either stop building or run last successful build.)
I'm interested in building a GUI CAD software in VB.NET, but I don't know from where to begin. I've looked in Audesks online help but there are no instructions, neither tutorials on the net for building something like this. When I'm saying GUI, I mean a work area, where you can use blocks from autocad and build a plan/circuit/PCB or other stuff like this.I'll be glad to see is this possible, and what kind of components can be used.
View 3 RepliesI have a problem with building a project. When I build a project and when I create .exe file, I cannot run it on other computers.There is an error: "The application failed to initialize properly (0x0000135). Click OK to terminate the application.".ca i have any chance to solve this error without installing framework 3.5
View 2 RepliesI have a problem with building a project. When I build a project and when I create .exe file, I cannot run it on other computers. There is an error: "The application failed to initialize properly (0x0000135). Click OK to terminate the application.". When I install .NET framework on the computer, than there is no this error. Is there any chance to create a file that will run on the other computers without installing the .NET framework?
View 8 RepliesI 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 RepliesI am successfully building an array list as shown below:
Dim obj1 As paperCutObj = New paperCutObj
obj1.Model = readLine(0)
obj1.IPaddress = readLine(1)
[code]....