In my application I use Linq to SQL to communicate with my SQL database.To setup a connection I added a Linq to SQL class, selected a database and choosen a SQL table.After this I use the following code for showing SQL data:Using aw As New LinqtoSQLDataContext
Dim Data = From c In aw.TestDatabase_TestTable _
Select c.No, c.Description
DataGridView1.DataSource = Data
End Using
Now the link to the SQL database is hardcoded and the databasename must be used in every Linq-statement.Is it possible to make the link to the SQL database dynamic so I can switch easyily between a test and production database?Can the tablename inside the Linq statements be dynamic too?
How to set up a Chart using the new MS Chart control. I want to be able to populate the data via SQL because the user will be able to dynamically change the values via drop downs. The format of the data will be the same (Qty, Time Period) but the Focus of that data will change. I'm honestly not sure where to start, I can draw the chart but I have no idea how to populate it with data via code so it can be changed dynamically. VBE 2010, and I'm hitting an AccessDB
I want to filter records dynamically on user choice. The user may choose to show the debit amount greater than credit or credit amount greater than debit. Accordingly I want to put a condition similar to either totDebit>totCredit orTotCredit>totDebit`
Dim query = _ From product In Bills.AsEnumerable() _ Group product By accode = product.Field(Of String)("ACCODE"), _
I have 290 Group Policy Backup xml files which I need to enumerate in separate folders.
With each Group Policy backup xml file, I need to query the Policy settings.
Anyone who's looked at a Group Policy xml backup file before would know they're chock-a-block full of Namespace declarations.
I want to know, using Linq to XML, as I query each xml file, how can I dynamically query the XML the Namespace and then append the Namespace into the Linq query for the child nodes/values?[code]...
I 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'm developing an application to allow engineers to conduct simple single table/view queries against our databases by selecting Database, Table, Fields.
I get how to use the Dynamic LINQ Library Sample to provide for dynamically selecting the Select, Where and Order by Clauses at runtime but I'm at an impass on how to allot for table choice.
Is there a way to provide for dynamically selecting the "from" table at run time
EDIT
So Both of the answers seem to be saying the same general Idea. I'm going to try to convert the C# into VB and get it to work.
The first answer converts to
NotInheritable Class DataContextExtensions Private Sub New() End Sub
I'm working on my first project using LINQ (in mvc), so there is probably something very simple that I missed. However, a day of searching and experimenting has not turned up anything that works, hence the post.
I'm trying to write a LINQ query (Linq to SQL) that will contain a multiple number of conditions in the where statement separated by an OR or an AND. We don't know how many conditions are going to be in the query until runtime. This is for a search filter control, where the user can select multiple criteria to filter by.
select * from table where table.col = 1 OR table.col = 2 OR table.col = 7 'number of other conditions
Before I would just construct the SQL query as a string while looping over all conditions. However, it seems like there should be a nice way of doing this in LINQ. I have tried looking using expression trees, but they seem a bit over my head for the moment. Another idea was to execute a lambda function inside the where statement, like so:
For Each value In values matchingRows = matchingRows.Where(Function(row) row.col = value)However, this only works for AND conditions. How do I do ORs?
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 want to create a real setup project for my application so when someone want to download it he can run only setup, not default setup that provide me VB . How can I do that?
I am using VS 2008 VB and setup my application software in Win XP without any issue. But after installed in Win 7, it doesn't work well (it show one file not found, but I saw the file in the right folder). Could it be the incompatibility of VS 2008 and Win 7? If I upgrade to VS 2010, will the issue be fixed?
Code: Public Class Form1 Dim NPB As Button Dim x As Integer
[code]....
As you can see, when I open a program from my menu, a new button will be created with text similar to this, "C:Program ". The button it self will not do anything. How can I create the method at the same time the button it is for is created? Also how can I change the text do that it gives me, for example, CCleaner.exe instead of the whole target path?
I'm a Visual Basic beginner. There are many things that I didn't know about Windows software development as I've been a Mac user for 20 years and just started developing Windows programs several days ago.
Anyway, using Visual Studio Installer (File > Add > New Project > Visual Studio Installer), I have two files inside the Release folder - setup.exe and Setup.msi. I've got some information about these files. So when you publish your software, what do you do with these two files? According to one web site, you can put them together into one with IExpress, which produces a file with an extension of CAB. Another web site suggests SFX Compiler. In the meantime, I downloaded a dozen applications at Download.com earlier. If I click on the download button, the final delivery extension is .exe on most of them. I know that you won't go anywhere by double-clicking on setup.exe from the Release folder without Setup.msi. Meanwhile, Setup.msi is a tand-alone application. But nobody uses this file alone to distribute their product.
I've finally got a project compiled and tested and ready to roll out.I have discovered that the "Publish" option is not what it seems, and that we must create a separate "Setup Project" to carry out the task of installing the files.This is not the most intuitive process I've seen, and the online help on that subject is not easy to understand.I was hoping that someone could direct me to a tutorial or guide that would step me through the specific approach I need. Many of the other guides online are vague and address multiple scenarios and do not separate the approaches very well.I have the contents of my project in /bin/release. It runs nicely by iteself with no errors.Here's what I need:
1. To create a setup exe that I can distribute that will install my software, with all of the supporting (resource) files and folders. 2. I need the setup process to force the installer to "agree" to a EULA. 3. I'd would like to provide an image on the installation screen/popup. 4. I would like the software registered in the registry and rely on it being there in the registry. 5. I need it to default to program filesprojectname (it does by default)
I hv deployed my project using "Setup and Deployment" wizard. I hv installed MS VS.NET 2003 Bootstrapper Plugin -> A plug-in for creating deployment projects in Microsoft� Visual Studio� .NET 2003 that contain the .NET Framework version 1.1 and/or Microsoft Data Access Components (MDAC) version 2.7. still it is giving the error The setup requires .NET Framework 1.1.4322. Install the .NET Framework and run the setup again. The .NET Framework can be obtained from the web. Would u like to do this now?
Setup and deploy for my project worked fine for a while allowing you to install my program and uninstall the old version, but now it installs two entries. I don't get it, before I got it do do that it would give an error that it needed to be uninstalled first. Now like I said I get two entries in the programs uninstall window. RemovePreviousVersions = true. I change the version number and update the product code. Even tried changing the upgrade code. I just don't get why it doesn't work anymore, and its really annoying! Also, is there a way that the setup file can just be one .exe rather then a setup file and a data file?
I can usually find the answers to most of my questions via the Google Gods, but not this time.I have a form that has a TabPageControl and on that page a collection of labels and text boxes via a usercontrol.
On the form I have a button that allows the user to create a new tabpage, when the code adds a new page, it automatically adds the UserControl collection. I can't get my head around how to access the objects on the newly created tabpage.
What I need to be able todo is take the index of the tabpage that has focus and translate that against the UerContol name, but I havn't a clue how to do it!
I am adding a grid of buttons to a form at run-time, and all of then use the same Handler.My question is : Is there any way I canadd the TextBox at run-time ?I know how to but without it on the form, the IDE isn't very happy about the "MyClick" Sub - TextBox1 is not declared......
' some logic here to make nice rows and Columns of buttons ' with different .Text and .Name Me.Controls.Add(btn)
I 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].....
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."
We are doing a query against an in-memory collection of LINQ data objects. The wrinkle is that we are ordering by a column in a related table whose records have not necessarily been loaded yet (deferred loading:)
Dim oPkgProducts = _ From b In oBillPkg.BillProducts _ Where b.Successful.GetValueOrDefault(Common.X_INDETERMINATE) = _
The pattern I'm trying to avoid is checking if a string (normally a control's text value) is null/empty, and if it is, comparing it using Contains to a field in my data. Obviously the field isn't hard-coded into my extension, neither is the object type.What I've got works perfectly in Linq to Objects, but I get the generic run-time error "LINQ to Entities does not recognize the method 'System.String Invoke(GenericQueryHelper.Customer)' method, and this method cannot be translated into a store expression." when using an entity framework model.
Here's what I have:
<System.Runtime.CompilerServices.Extension()> Public Function CompareAndFilter(Of T)(source As System.Linq.IQueryable(Of T), expressionField As System.Linq.Expressions.Expression(Of System.Func(Of T, String)), compareTo As String)
[code]....
I want my usage to look something like this:
Dim results = repository.Customers.CompareAndFilter(Function(c) c.FirstName, searchText)
I do need to get this running against a SQL database really, as it is filtering results, so I don't want to be doing that in memory.
How do I add ROW_NUMBER to a LINQ query or Entity? How can I convert this solution to VB.NET?
[Code]...
I'm having trouble porting that last line. I have been unable to locate a VB.NET example. I'm actually not looking for any paging functionality like the example provides, just good old-fashioned Row_Number(Order By X) row index.
