Alternative To SQL CE?

Jul 15, 2010

I've created an app (VB.NET) where each installation of the app works with a single local database on the PC. No multiuser and no ability for the user to change databases - the database is effectively part of the app, with a fixed scema, only the data will change.At the moment the database is SQL CE. It has about 30 tables with some simple relationships between the tables.

I'm wondering if there is an alternative to SQL CE that might be faster in this scenario. Although SQL CE is excellent and easy to use, I get the feeling there is perhaps an unecessary overhead when using it for something simple - and it does seem a little slow when my app is doing complex stuff that interacts a lot with the DB. In my prototype I actually loaded the 'database' tables from text files into Arrays and developed subs and functions to perform the database searches etc. It was blindingly fast but I realised it wasn't a scaleable solution because it was an 'in-memory' database. A compromise would be to 'page' data into array when needed, but it all gets horribly complex and that's probably why some very clver people have created SQL CE !

View 3 Replies


ADVERTISEMENT

.net - Namespace With An Alternative Name?

Jan 27, 2011

Using VB.net, I have a namespace which I'd like to rename for the future. However, I'd also like to keep the old obsolete namespace for a time to ensure backward-compatibility for our consumers for awhile. Is there a way in .NET to have two namespaces, one ordinary and one that merely is an alternative name for the other?

[Code]...

View 2 Replies

Alternative DateTimePicker?

Apr 2, 2009

From the WINDOWS Date & Time settings FORM is this accessible as an alternative

View 1 Replies

Alternative For Each - In Loop ?

Mar 31, 2012

Below is the code for a linked list search I have tried to implement in to searching through each of the elements of htmlelements .For some reason If element.InnerText = (item) will only work if if is only a string ("example") .Are there any other ways of Implementing the for each loop to search through my item linked list?

Original code for searching for 1 string

Private Sub block()
Dim elements As HtmlElementCollection = webBrowser.document.All
Dim word_found As Boolean
word_found = False

[CODE]...

This is the Loop for item I have tried to implement but is not working ,because of the for each loop .The value of element.Innertext = "" or null when I try to use one of the linked list item[If element.InnerText = (item)] is used and only have a value when a string is used to [If element.InnerText = (google)]

Private Sub block()
Dim elements As HtmlElementCollection = webBrowser.document.All
Dim word_found As Boolean
word_found = False
Dim item As LinkedListItem = words.Head

[CODE]...

View 1 Replies

Alternative To A Combo Box?

Apr 28, 2010

I've encountered a problem in a application that I inherited. It contains a combo box that loads information.The problem is that there are more data that the control will hold (32767

View 2 Replies

Alternative To Uri.EscapeDataString?

Nov 6, 2011

Is there an alternative to Uri.EscapeDataString? I'm trying to upload an image, by converting it into a base64 string, but I need to use Uri.EscapeDataString on it first, and if the image is big then Uri.EscapeDataString will say that the URI is too long.

View 2 Replies

Asp.net - Alternative To TidyCOM

Dec 31, 2011

My clients web application is using TidyCOM to clean up dynamically created XML files from a SQL database query. With this TidyCOM, they are not able to upgrade the web application to .Net 4.0 framework. Is there an alternative to using TidyCOM so that these dynamically created XML files are validated correctly?

View 1 Replies

Best Alternative For QueryString?

Feb 28, 2009

We heard a lot about the vulnerabilities of using QueryStrings and the possible attacks.Aside from that, yesterday, an error irritated me so much that i just decide to stop using QueryStrings, i was passing something like[code]....

View 8 Replies

Getting Alternative For Outlook?

Jul 11, 2010

My VB application also needs to manage simple appointments in an agenda, however one user has no MSOutlook. Someone knows of an alternative calendar tool, with which I can do this?

View 2 Replies

Is There Alternative For Timer

Jun 9, 2011

is there an alternative for timer?

View 4 Replies

Looking For A Alternative To SendKeys?

Jun 8, 2010

So I've been doing a lot of reading today and apparently SendKeys isn't very reliable anymore.Does anyone know of another alternative to it for what I need:

The application works by the form being positioned over a open window, notepad, word, excel etc and it then determines what it is over, notepad, word, excel etc and then reads the file, and does some processing using SendKeys at the moment.Though I do believe I could probably change the later at some point. The problem I'm having right now is when I try to send the Alt + Tab to change focus it's working roughly 12% of the time.If you are wondering I ran it 50 times and it worked 6 of those,thus the 12%.I'm thinking that is rather unacceptable.This is what I'm using which should work: SendKeys.SendWait("%{TAB}")

XP Service Pack 3 and vb.net 2005

View 16 Replies

Sendkeys Or An Alternative?

Aug 30, 2010

First off, using VB2010. I'm in the process of upgrading some applications from VB6 to 2010 and haveing a great time of it. The current application I'm working on is using Sendkeys of which I have changed over to the WSH.Sendkeys of which is pretty decent. Basically the program is copy and pasting the current open file, reading some data and saving it as a different file type. It also has to change xls files to csv and then saving it to the format as well as a smiliar thing with word. Thus the reason for the copy and paste as it's changing the extension to a dot date (for example, test.830).This is the flow of how it works for a text file (most basic)

1. changes focus to notepad

2. Select all Copy to ClipBoard

3. Open Programmers File Editor and a blank file

4. Paste in text

5. Save as code.date extension to the directory

Excel files obviously have a few extra steps.

View 5 Replies

System.Web Alternative In The .NET

Sep 22, 2011

I need a good alternative for System.Web that is included in the .NET 4 Client Profile. Currently all of my frameworks are included in the client profile, except System.Web. What is a good alternative?

View 7 Replies

What Is The Best .net Alternative To Dde For File Associations

Aug 13, 2009

I have an MDI Windows Forms application (.net 2008) that allows the user to associate various file types with the application. I currently do this with a registry entry something like this, that causes the application to load and access the file name via the command line:[code...]

In the pre-.net version of the application, I used DDE (ddeexec in the registry). If an instance of the application was executing when a file was double-clicked in Windows Explorer, it would open the file without starting up a new instance of the application.

Now that DDE has been deprecated by Microsoft, what is the best way in .net for an executing MDI application to open an additional file when the file is double-clicked in Explorer, as opposed to starting a new instance of the application?

View 1 Replies

Alternative For INKEY Command?

Sep 23, 2007

I'm running Visual Basic.net. I used to use the INKEY command, available in older DOS versions of Basic, to allow the user to change the flow of a program by touching a keyboard key. It seems to be available only in Visual Fox Pro. Is there an alternative for Visual Basic?

View 4 Replies

Alternative To InnerHTML/outerHtml?

Oct 24, 2011

If I wanted to make changes in page site (using with WebBrowser, and only the user will see it) I would do it:

Dim Rstring As String = WebBrowser1.Document.Body.InnerHtml
Rstring = Replace(Rstring, "Some Text To Replace", "<B>Some Text To Replace</B>")
WebBrowser1.Document.Body.InnerHtml = Rstring

View 10 Replies

Alternative To Transaction Lock?

Mar 20, 2012

In my project i am using begin transaction commit or rollback changes. but this causes lock to the tables in that particular functionality.

So if the any other user does any other functionality those locked table are not available until the transaction is completed. I want to know if there is any alternative to transaction which insures data security but the tables are not locked out.

View 1 Replies

Alternative Way To Display Rows From A DB

Mar 14, 2003

I assume that this is not possible.Could somebody please suggest an alternative way to display rows from a DB in a nice way. (with word wrap)

View 10 Replies

Alternative Way To Save File?

Mar 15, 2010

in my database i have an admin form, where it allows you to do admin stuff.Example: Allows you to enter price per membership, and change it.Problem i'm having is how would i save it, since all previous files had more than 1 records, so it would be in the form of:

FilePut(1, OnePerson, NumberOfRecords + 1)

Since this file will only cosist of one record, i don't know how i would save it.i tried FilePut(1, OnePerson, Index) But it doesn't work.

View 3 Replies

Any Alternative Available For Control Array?

Aug 16, 2009

I was just wondering if there is and alternative for control arrays in .net as these were quite handy in vb6?

View 8 Replies

Application.DoEvents Alternative?

Jun 6, 2011

Any good alternative to using DoEvents in VB.NET

View 6 Replies

Find The Out Parameter Alternative?

Jun 10, 2010

im a C# dev trying to convert some code to VB.net so I can use the Interop Toolkit 2.1. Im trying to find the out parameter alternative, Ive found that its ByRef but I cant quite figure out how to implement it.

private static string status;private static string statusDetail;private static webserviceAPI.Customer[] GetCustomerMethod()

[Code]...

View 7 Replies

Getting An Alternative To AddRange For A LIST( Of T )?

Jul 4, 2011

Here is an extension method you may like for use with VB.Net 2008 / VB.Net 2010 and onwards.Instead of doing the following:>>

Dim newList As New List(Of Integer)
newList.AddRange(list1)
newList.AddRange(list2)
newList.AddRange(list3)
newList.AddRange(list4)

View 3 Replies

Make A Dreamweaver Alternative?

Apr 12, 2011

I just got an idea to make a dreamweaver alternative software . I wil require some help . We need to break the whole process into algorithms first . So if you want to participate please do tell.

remember I am not spamming and asking for help . I just thought we can make a vb.net dreamweaver project . If you see the stats dreamweaver is a brilliant software but now days it is becoming less popular because it has become so advanced that it sometimes confuses programmers also .

View 10 Replies

Managed Alternative For GetBestInterface?

Apr 27, 2012

I have absolutely no background on programming in C (or any other unmanaged languages for that matter) yet I would like to use the GetBestInterface function from the IP Helper API in my .NET application. I tried to understand how P/invoke calls can be used to make calls to native methods, but there are many things that just don't make sense to me (like how types in managed code map to unmanaged types).

Is there an alternative function somewhere hidden in the System.Net namespace that does roughly the same thing? Or could I write my own alternative using existing base classes combined with some magic? Because that's basically what it seems to me: magic. There is no real explanation for how the method accomplishes what it does as far as I can tell...

I just discovered the LocalEndPoint property on the System.Net.Sockets.Socket class which I think could be quite useful in this. To my understanding it will do the best-interface-picking on my behalf and I'll just need to get the NIC that corresponds to the local endpoint.

View 1 Replies

Sync Folder Over FTP Or Alternative?

Jan 7, 2012

i'm interested in syncing a remote folder and a local one over FTP but I don't want to use 3rd party components since this is not going to be a public build so I see no reason to invest on something like this now any code snippets or so available? PS. remote folder includes folders also that can change so I want to keep an update of the remote folder on my PC.

View 3 Replies

VS 2008 Need A Database Or Alternative?

Feb 27, 2010

Im currently developing an app, in which there is a list box which will contain between 200 and 3000 items. These items are loaded into the list box from a .txt file. Now on the same form i have Picture boxes x 6 Textboxes x 5..The contents of which changes with each list item selected, and to do this i have the code attached to the list box, heres a snippet of the [code] but at the moment with 178 items on the list the total code is pretty big, and i get the feeling it would run faster if loaded dynamically.Am i right in thinking that? Especially when the list has 3000 items, thats alot of code to have attached to a listbox.And how do i go about making the code dynamic, im looking round the forum and seeing ADO database mentioned alot and that seems to be the answer at least for the text fields, would that also work for the picture box fields?

View 1 Replies

VS 2008 Sendkeys Alternative?

Nov 10, 2009

hey been looking around for an example of Sendmessege to send keys, but all you find is the basic notepad example, can anyone please show me the way to use Sendmessege to sendkeystrokes to any application (i have the hwnd)

View 3 Replies

Alternative Button Controls For Winform?

May 21, 2010

Where can I find alternative button controls for vb.net Winform?

View 3 Replies

Alternative For TextChanged Event In MaskedTextBox

Mar 11, 2011

I need to know this because I am in a situation that I cannot find a alternative. I am using MaskedTextBox and has a Mask of "__/__/____". Obviously, It's a date format. Now, I cannot get if the MaskedTextBox is string.empty because it is not an empty. I cannot use "If MaskedTexBox.Text = "__/__/____" then " condition also because It never captured. If I used MaskTextBox.MaskFull = false, It gives an error on creating form. So I came up with an idea that would subtitute to TextChanged Event.

[Code]...

View 6 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved