We are developing this system that's constantly connecting and retrieving records in our Sql Server 2000 database. The problem is. is that when the database is down we can't use the system. So we are tasked to modify the system to have offline access feature without data replication rather making a xml cache or any flat file data cache.
My question is, what is the most optimized way to make this work?
BTW, the offline data should be synchronized when the server gets online.
I have the following code in my config.vb file in app folder and almost all of my pages use this code for permormance issues i need to have it cached for exp use cache.insert to cache each property How should i use caching?
I'm getting some troubles to add data in a access data base with vb.net applicaion. it shows me the exception System.data.OleDb.OleDbException. my code:
I have code/support an application built on .NET framework that has always run on .NET 2. This year we are upgrading the application to use .NET 3.5 (or 4?). In preparing for this change we noticed that that Offline Installer (required for our customer base) for .NET 3.5 is 200+ MBs bigger than the .NET 4 offline installer.
Here are my questions.Why is the dotnet 3.5 installer so much bigger than the 4 offline installer?
Can we TARGET .NET 3.5 but distribute .NET 4. In other words, is .NET 4 backwards compatible? Assuming that .NET 4 was the only installed .NET could application still target earlier frameworks?
IF our application is compiled for x86 CPU (rather than Any CPU) do you still have to distribute the x64/x86 Client Profile or can we just distribute the x86 Client Profile? In other words, can we distribute the x86 Client Profile even though it will be installed on x64 machines if our app is compiled for x86 target CPU? Any risks or gotchas for doing this?
The issue is that if we upgrade our app to target .NET 4 there are a lot of application servers that we also have to upgrade which effects a number of other applications.
I'm working on a windows forms application (.NET 4.0).My form contains a 'Fast Line' chart using the Microsoft chart control included in VS2010.The chart gets filled with about 20,000 datapoints.My application then starts receiving market data from a server via DDE (Dynamic Data Exchange) in real-time and adds it the chart.
I'm creating an occasionally connected application with a local (client) .sdf data cache. I added a new table to my server database and want to include this table in my local data cache and synchronization. Is there an easy way to do this?
I have the following VB.NET code to set and read objects in cache on a per user basis (i.e. a bit like session)
Public Shared Sub CacheSet(ByVal Key As String, ByVal Value As Object) Dim userID As String = HttpContext.Current.User.Identity.Name HttpContext.Current.Cache(Key & "_" & userID) = Value End Sub
[Code]....
I use these functions to hold user data that I don't want to access the DB for all the time. However, when the data is updated, I want the cached item to be removed so it get created again.
How do I make an Item I set disappear or set it to NOTHING or NULL?
We have data that's updated nightly in a database residing in the same instance as my app's database. So to save on database calls, I want to cache this static-for-the-day data into a List(Of MyObject). From a theory point of view, should this cached List(Of ) be cached in the presentation layer code, via a global variable? Should it be in a global variable in the .DLL?I'm thinking in the .DLL, because I created a service layer, which is exposed publicly to the GUI and makes calls to the data access layer inside the .DLL:
Public Shared Function Search(ByVal criteria As Core.Other.Customer) As List(Of Core.Other.Customer) ' TODO: Check the customer cache to see if it has been populated yet. If not, populate it. If 1 = 1 Then
I have programme which contains two list box. when exe is launched it retrieves data from web references [from web services] and immidially it creates folder of cache so when next time exe. is launched it displays data so fast in listboxes. and if cache folder is deleted and exe. is again launched it takes some time to retreave data and again it create cache folder.. how can be this done. if i wish to added controls in cache
New to VB... I am trying to access .SYS (system files) located in the following folder path (example) My Database NameVIEWSSYSTEM VIEWS in the Object Explorer of my SQL Database. In walking through the Data Source Configuration Wizard for data connectivity I select DATABASEVIEWS and the SYSTEM VIEWS sub-folder is not available for selection. In general: What is the best method to access System Files using VB Data Source?
I have been programming vba for some time and am now starting VB.NET. I need to connect to an existing access db file (access 2003). I downloaded VS2010 and found an example on the net. Here is most of the code:
Imports System.Data.OleDb Public Class Form1 Inherits System.Windows.Forms.Form Dim cn As OleDbConnection Dim cmd As OleDbCommand
get the argument for the desktop of the user
I am getting this error message:
1 End of Statement Expected
I have tried to add a reference to System.Data.OleDb but it doesn't appear in the add reference box. System.Data.OleDb is checked in the Imported namespaces window. I have tried changing the .NET Framework but, no help.
I've spent a substantial amount of time trying to figure this out, but I keep getting the same error
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll A first chance exception of type 'System.NullReferenceException' occurred in project1.exe
This happens when I try to use the DataReader.my code is
Public Function Identification() As List(Of Integer) Dim returnIndex As New List(Of Integer) Dim dbCount As String = "SELECT Bookingid FROM bookdetail WHERE Date =" & getCurrentTimeString() & " 12:00:00 a.m." Dim count As Integer = 0
We are thinking about changing our current database system, MS Access 2007 front end and MS SQL Server 2005 backend to using a higher level language such as Visual Basic .Net. I wonder if this is the BEST solution for data management? Currently, among others, we have two big database programs that handle more than two hundred users and it's crashed often. That's the reason we think about changing to something that can handle these database programs effectively preferably using MS technology such as .Net.
i am trying to connect to an MS Access database and I am getting an erro message on the following line of
searchtable_command = New SqlClient.SqlCommand(searchtable_string, testsearch_connection) Error:'System.Data.Odbc.OdbcConnection' cannot be converted to 'System.Data.SqlClient.SqlConnection'.
Here my connection string:
Dim testsearch_connection As New Odbc.OdbcConnection("Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};Dbq=C:CesarAccessdatabase.mdb;Uid=admin;Pwd=;")
Do While rdr2.Read() Dim var1 As String = rdr2.Item("Week").ToString Dim var2 As String = rdr2.Item("L1").ToString Dim var3 As String = rdr2.Item("L2").ToString
It generates the following error: A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll
Interestingly, if I use a numeric value for the variable it for LSArraytemp, it writes to the database no problem at all.
My colleague gave me a DLL that manage all database business. I wanted to invoke a function that uses Stored Procedure and return the search result. In the function receive a parameter type in ystem.Data.IDataParameter[]. Below is my codes.
I added this lines in the form load of DataGridPrinter by Merrion in the codebank..[code]Unable to cast object of type 'System.Data.DataViewManager' to type 'System.Data.DataTable'.
Does anyone know why on earth in my linq to sql designer classes, that I am getting type not exist for any system, system.data, system.data.linq nameapces?I am trying to convert a website to a web application and this has me stumped. In order to create an object I have to use the Global. prefix on all the namespaces.
I am using VS 2008, Office 2007, and Win7 Home Premium on my system.I have a simple application which should be a breeze to build. All I am attempting to do is pull data from an Access database with four small tables into a data grid on a windows project. Should be simple, set up the data connection, choose a datagrid from the table in the data source view, drag it onto the page and done, right?I can't get it to work. It will all work fine until I attempt to run or debug the project. The data will not show up. The data grid does, but I get this error: A first chance exception of type 'System.InvalidOperationException' occurred in System.Data.dll
As I said, the project seems to build fine, but it will not pull the data. After the initial build I get the message that Windows will show this page in Compatibility View. Is it something with Win7 Home Premium, or a setting somewhere?
I have a windows service written in .NET 2.0 that will run every 5 minutes and executes bunch oracle SQL/PLSQL scripts based on time/validation, it throws the above said error some times against some SQLs, the same SQLs run fine at later point without any error, I have no idea what is going on with the app. I am not sure if this has any thing to do with oracle connection pool as I am properly closing the connections after every SQL execution.
Exception:
System.Exception: Unexpected return code: 1 at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString,
I'm trying to install VB8 on an offline computer and I want the iso file. I go to the offline install page and it tells me to download the iso file. Where the ____ do I download it from?
what options do I have for creating a VB.Net application with a mapping framework; obviously I am not going to write my own. So is there any OFFLINE components free or otherwise that I can use?
Application Background : Basically I have a mobile device that sends its location back to a socket server (I am writing using .Net sockets) every 10 Seconds (possibly longer 10min, not decided). The client (which I will also write and need the map component for) will login to the server and download the latest number of GPS points and simply plot them onto a map surface (thus the maps need to be of street level quality). Although the map database can be updated over the internet, I have to assume the user does not have an internet connection. So using something like Google earth is no good. Initially I need the UK only, but will need the option for Europe and possible the USA later on.
I want to disable(or turn off) the Work Offline.Work offline is available in IE or Firefox(File ---> Work Offline). When i run my vb.Net application, i need to disable the Work Offline Mode to disable using the Javascript or vb.net.
