Linq - Database Advice Needed: Porting VB6/ADO/JET App?
Jul 22, 2010
I need to update (well, rewrite really) a SMALL VB6 application which uses ADO to access a JET database, to a vb.net app in Visual Studio 2008. My research suggests that I should use LINQ, but it doesn't seem to be possible to connect to JET. If JET is now deprecated, what should I use? Or should I use ADO.NET without LINQ?
Please don't answer SQL Server! - this needs to be an app that end users can install easily in corporate or non-corporate environments, and must not require any ongoing technical maintenance. I started to install SQL Express, but stopped when it required at least 2 system updates, as that will be far too complex for this little app.
View 4 Replies
ADVERTISEMENT
Apr 16, 2011
I had actually getting LINQ to work but I am past that now but I was wandering if anyone could help me what I basically have is a DropDownChecklist user control I made and the contents of the list are filled by LINQ getting a list of company names see below:
'Population for company filter box
Public Function GetCompNames()
Using DC As New DataClassDataContext
Dim comp = (From C In DC.Companies _
[code]....
Would you suggest using a public array or something to store the companyID's when populating the first list box? This just came to me at the end of writing this post. Will try this but not sure if its the right thing to do.
View 1 Replies
Jul 4, 2010
I am trying to port the folling C# Linq statement to VB.NET. I can't seem to find any equlivant for Select((asm, idx) => new { asm, idx })
List<AssemblyReference> assemblies =
(
from asm in loadList.Assemblies.Select((asm, idx) => new { asm, idx })
[Code]....
View 2 Replies
Jun 5, 2010
I am attempting to create a program for a business but i have no idea how to create a database to hold the information and allow me to access it when needed
View 1 Replies
Nov 26, 2010
I am using a vb.Net 2010 and sql server 2005.I want to run a solution that is windows form to another computer.There is No centralized server.
View 1 Replies
Jul 20, 2010
I need advice on how to implement. I have two objects ReceiptLine and Discount. Cashier scans item and a receiptline object is added. If the added ReceiptLine object have a Discount Id then, it has to lookup in Discount object and issues discount after validation. I have problem in validation. [code]
View 2 Replies
Nov 10, 2011
I have handed this assignment in and it works albeit not in the most elegant way. I am taking my second programming class ever and I would love for some feedback and answers to a few questions i have. First, what would be a better way to display the correct image to the corresponding card. Using all those if statements seems ridiculous, but i cant see a way around having card 1 possibly equal each value from every suit, card 2 equal each value from every suit, etc.
Second, my professor wants us to be able to record the seed value so that we could then plug it back in and return the hand that was shown when it was created. i have done this but I am a bit confused. The seed shows up as a value from 0-999, but when you use the combination formula to figure the total possible amount of hands you get over 2.5 million. Since i only have 1000 seed values does that mean that multiple hands might share the same seed value or does that number (0-999) mean something different eache time? Sorry if my explaination seems confusing.
Third, I am always looking for advice on better ways to do things. If anyone has free time and would like to offer constructive critisism I would be grateful.Below is the code. I only left in picturebox display for 1 suit so as to shorten the total amount shown. I also removed code for other buttons and stuff.
Public Class Form1
Private Sub btnShuffle_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnShuffle.Click
' Variable Declarations
Dim intSuit As Integer ' Row
Dim intCardValue As Integer ' Column
[Code]...
View 4 Replies
May 15, 2009
i am looking into web services to be used for a windows forms application that i want to connect to my website and return data from my database. One thing i am concerned about is security. I have only played with web service a little bit but it seems to allow direct access to it by url and then run the service, showing the results in the browser. i guess i could set it up to accept a password in the code. i guess really if i have to pass in the query criteria to the sql from the application then showing the records in a browser should not be a problem. in my web application for the site i can keep all my web services in the app_data folder for no browser access.
i just need some advice in this area. goods, bads, other options if better. i don't have a full grasp on working this way from a client side windows application.
View 9 Replies
Feb 26, 2009
I have a bit of code which is causing me a few problems to port from C# to VB.NET
The C# looks like this
byte[] serverbuff = new Byte[1024];
int count = 0;
while (true)
{
[code]....
View 13 Replies
Sep 24, 2009
I'm working on porting some classic VB6 code to C# and just stumbled across a usage of the PV function.I feels wrong including a reference to the Microsoft.VisualBasic Assembly. Is this something that is commonly done, or should I explore further options. The next idea that pops into my mind is exploring this PV function in Reflector.
View 3 Replies
Jun 24, 2012
Possible Duplicate: Porting VB.NET Winforms Application to C# .Is there any way to convert a vb.net winforms application into c# ? In terms of both code and .vb (forms) files.
View 2 Replies
Mar 22, 2010
I have the following code in a VB 2005 project that works fine:
Imports System.Text.RegularExpressions.Regex
Do While intIndex >= 0 'Or Not boolMatch
If IsMatch(strTitle, Trim(arrTitle(intIndex)),
[Code].....
View 4 Replies
Dec 29, 2009
I've been wondering about this for a while, but is there actually any free way to port VB.net apps to OS X and Linux? I've searched the web for this and couldn't find anything much.
View 5 Replies
Feb 21, 2011
I'm working on some legacy VB5/VB6 code and need to convert a ".bas" file to vb.net. i found several options
Compile the .bas file into a com dll and then reference and use it in my project. (For this I guess I would need vb5 or vb6 which I don't have at my disposal) Copy and paste the contents of the file in to a new module in vb.net and then try solving the errors one by one.The contents of the .bas file reference a particular dll. The .bas file has mostly declarations consts, types, sub's and functions.
What would be the most elegant way of redoing this in vb.net. Is it as simple as option 2.EDIT
I used VS2008 express and ran the code through the upgrade wizard it did the necessary conversion. and the .bas file was converted to .vb. I took that file and decided to rewrite other parts of the code, including some redoing of the converted .vb file. Other questions related to this one are here.
View 3 Replies
Sep 7, 2010
We are looking to port our existing classic ASP application to .NET, but we're unsure of what language to use for the new app. I personally would 'prefer' C#, as I'm more familiar and comfortable with that languages way of doing things, but, the original code is VBScript, so it would possibly be easier to port to VB.NET ... One possible situation I fear would be that, because the code is so similar between the two variants of VB, that we might end up getting stuck on something that is not similar between the two, even though it looks like it would work. A shift to a wholly different language might avoid that kind of situation. Does anyone have any practical examples of this kind of situation? Insights to illuminate the issue with? Do the potential benefits of a complete paradigm shift outweigh the gains from a high degree of 'copy-and-paste-ability' ?
View 9 Replies
Mar 17, 2009
I am porting a vb6 application to VB.net. One of the key forms has a large msflexgrid on it - about a 1000 columns and 50 rows. It has 2 header rows - the first header row has merged cells to form a main header and the second row has sub headings. There is no requirement for any data entry and it's unbound. The code does the work in deciding what to display (if anything) in each cell. It is solely used to display data in the form of a character and a coloured background and to display a tooltip text with more information when you mouse over it. Works beautifully in vb6. I'm trying to decide whether to:
a) use the vb6 msflexgrid in the .net version
b) use the datagridview - which at a first glance seems to have a problem merging the cells on the header row
c) build my own custom control to do the job
View 2 Replies
May 16, 2009
I've got a VB 6 application that I ported over to VS 2005. The application has a toolbar on it. When building it in VB 6, I created all the bitmaps for the toolbar. And they looked just fine.Now I have ported to VS 2005. The toolbar works just fine. But the images in the toolbar look "wrong". The best way to describe them is if you took each bitmap and squeezed it down to about 67% of it's size. So it is missing the detail it used to have. And the smalleer picture still takes up the same amount of space on the toolbar. It is just that each squeezed bitmap now looks like it has a thick, blank pictureframe around it.
View 5 Replies
Mar 21, 2011
I developed an application using VB .NET on a Windows OS. If I want to enable this application for a client who uses Linux , how do I do so? Do they need to purchase VB .NET? I am totally lost on how this works.
View 5 Replies
Oct 23, 2009
I am trying to decode yEnc data using the component found here:[URL]...It all converts fine, except for Line 173 of Decoder.cs which contains the c# keyword "unchecked".Without using unchecked I get an OverflowException.What is the correct way to implement this in VB?
[Code]...
View 6 Replies
Apr 13, 2011
I created an application for Windows XP, now it needs to run on Windows 7. I have had some issues to resolve, but rather small ones. I am now stumped on this one... Here is my code block
vb.net
Private Shared Sub RenameFileAfterDownload(ByVal File As String)
Try
[code]....
The code works perfectly for Windows XP, but the ftpRequest does not work in Windows 7 for renaming. That said, the code runs that entire sub becaues WriteToEventLog get's written, but seems to ignore the ftpRequest lines.
View 4 Replies
Jan 12, 2012
I make loads of programs in visual basic, but it happens that my friends that want to try some, have Windows XP or Vista, when I have Windows 7 on the computer where i create them.I tried to launch the application compiled on 7 on their PCs but it just doesn't work. Is there any way to port programs from Windows 7 to other version of Windows? Or just to find a way to make them run?
View 9 Replies
May 17, 2012
I've been asigned to a new project. I have to mantain an application wich was made in Visual Studio 2003 (VB.NET, Framework 1.1) and Crystal Reports wich came included with the IDE. The application is absolutely what we call "legacy code" :).Just to make the test, today I've tried to convert the application in Visual Studio 2010. The converter is offering me download SAP Crystal Reports, with no cost and no registration.The question is: Does anybody has experience with this components?. Is feasible to migrate an application as described to VS 2010?
View 1 Replies
Aug 26, 2009
I am porting Excel VBA to VB.NET. I have a function that takes a selection of data, and it may be one dimensional or two. VBA code is quite fluid about using a variable as either a 1-D or 2-D array, but VB.NET marks it as an error.
Here is the reduced code:
Public Function Stat(ByVal Data As Range) As Object
Dim Y() As Object
[code]....
View 2 Replies
Mar 2, 2009
I have been utilizing Scott Gu's tutorials on LINQ to SQL to try to learn some LINQ. I have been able to view, retrieve, and update records but I am unable to write new records into the database (MSSQL). Scott starts getting into inserting rows in the fourth section of the set of tutorials. As you can see on that page (or may already know), in order to add a record you must do the following (VB.NET)[code]...
View 1 Replies
Oct 10, 2010
Searching Database using LINQ
View 1 Replies
Oct 10, 2010
I have a database table (Access Database) that contains data under OrderNo field.When user enters new OrderNo, I want to check if that OrderNo already exists or not.If so, a message should be displayed.
How can I do it using LINQ?
View 1 Replies
Apr 10, 2009
I'm having some problems updating the database using Linq...
Public Shared Function Save(ByRef appointment As MyLinq.Appointment, ByRef db As MyEntities) As Boolean
If appointment.id = 0 Then
db.AddToAppointments(appointment)
[CODE]...
So Insert works fine, i have tryed both lines of code for the update with no sucesss... The first one goes ok but no update is performed, the second one throws an exception... Can someone point out what i am missing? I had some internet connection problems...I had to "make it work", so now my update code is fecthing the record from the database, updating and then executing "SaveChanges" method. It works but I am not happy having to query the database to perform an Update... If you have any idea how I could do this without an update.
View 2 Replies
Mar 28, 2012
how to use linq with mysql database in vb.net,I have searched on google but did not find clear tutorial on this?
View 1 Replies
Aug 18, 2010
Very simple update. It simply fails, no error, no change gets made to the database.Dim db As New BarClassesDataContext Dim foo = (From a In db.articles Where a.id = 14 Select a).Single Response.Write("<h3>" & foo.title & "</h3>") foo.title = "This is my new, updated title for article ID #14"
db.SubmitChanges()
Here is the relevent portion of my article class. Also, this is a web form so I have no console. Is there another way to view the T-SQL output?
<Table(Name:="dbo.article")> _
Partial Public Class article
Private _id As Integer
Private _issueid As Integer
Private _dateadded As Date
[Code]...
View 3 Replies
Jul 7, 2010
Is it possible with LINQ to SQL to search the entire database (obviously only the parts that are mapped in the .dbml file) for a string match? I'm trying to write a function that will take a string of "Search Term" and search all mapped entities and return a List(Of Object) that can contain a mixture of entities i.e. if I have a table "Foo" and table "Bar" and search for "wibble", if there is a row in "Foo" and one in "Bar" that contain "wibble" i would like to return a List(Of Object) that contains a "Foo" object and a "Bar" object.
View 5 Replies
