Post New Web Links

Data Import issues: Access 2003 .mdb to sqlce 3.5 on mobile device

Posted By: Posted Date: August 28, 2010 Points: 0 Category :Sql Server

I am trying to download wirelessly or cradled, data from 3 Access 2003 tables into my SQLCE 3.5 datatables. I already have a successful method + web method that uploads data from my sqlce datatables into the Access 2003 tables. I just need feedback to know if I'm headed in the right direction. Web method: Public Function UpdateSqlCeData(ByVal downloadSet As DataSet) As Boolean ' Connect to Access DB here, execute command and populate data set with returned data. Me.Server.ScriptTimeout = 600000 Dim strSql2 As SqlCeCommand Dim oleDbDataset As System.Data.DataSet = New DataSet Dim sqlParam As New SqlCeParameter Dim fhAccDt, fhCeDt As New DataTable strSql2 = Nothing sqlParam = Nothing 'Connection string to connect to access DB Dim FHLiveDB As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\testpre\testservertest.mdb") Dim Pbrd As New OleDb.OleDbDataAdapter("SELECT * FROM tblProductBrand", FHLiveDB) FHLiveDB.Open() Pbrd.Fill(oleDbDataset) With strSql2 .CommandTimeout = 600000 .CommandText = "INSERT INTO Product_Brand ([BrandID],[Brand_Name]) VALUES (@Brand_ID,@Brand_Name)" sqlParam = .Parameters.Add("@Brand_ID", SqlDbType.NVarChar, 50, "Brand_ID&

View Complete Post

More Related Resource Links

Access via mobile device on claims based site

Hello,

I have a claims based site with FBA setup. I have two problems:

- I use a custom made login page instead of the default FBA login. This works fine in the desktop browser, but it gives me a 403 error on my mobile device.
- I checked which page should be the mobile login. That seems to be /_layouts/mobile/default.aspx. I can access that page with my mobile device, but when I try to login, it throws an error on the server: "The security token username and password could not be validated" and I cannot log in.

I know quite sure the security token service has been configured properly, since I can login via desktop browser. I've tried entering my loginname as username, domain\user and even the claims based user id (i:0#.w|domain\username); they all fail.

MCTS in Web Application Development in .NET 2.0

Import Data from Excel/Access to Sql CE 3.5

Is there any free tool I can use like SSIS I can define column mapping and import data to Sql CE?

Thanks

Hardy

Welcome to help me with my open source project at http://code.google.com/p/batch-image-watermark-processor/

Cannot Import application Definition to Business Data Catalog (BDC) -- Error: Access Denied

I want to import an application definition to my Business Data CatalogÃÂ (BDC).

I log into my Shared Service and select Import application definition.

I am redirected to page that says Error: Access Denied

My account is:

1. An Administrator on the windows server running sharepoint
2ÃÂ A member of the Farm Administrators
3. Added individually with Full Control to Central Administation
4. Added individually with Full Control to my shared service.

John Bailo

data exchange between server an mobile device

Hello!

I have a huge problem with the data exchange of a server database and a mobile database( sdf ). At first I load the data with a normal select from the server to my DataSet and then i set the table rows to added and use the DataTableAdapter.Update() command to fill the mobile database.

The problem appears if I do it a second time because I get an exception with a primary key violation. Before i fill my mobile db I delete the whole table with the delete-command.

Why do i get such an exception if no data is in my mobile database??

Kind regards, thomas

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

Creating a Smartphone Application and Using Data from SQL Mobile

In this exercise, you will use Visual Studio 2005 to create a Smartphone application. You will associate commands with a mobile device's soft keys, and you will add the ability to scroll through the list of available products (a list of images). You will create a data source for an existing SQL Mobile database, and then test the application in the Windows Mobile 5.0 emulator.

In the following procedure, you will create a new Windows Mobile 5.0 project in Visual Studio.

How to create a windows mobile (Smart Device) .Cab installer

A Cab file is the default setup format for Windows CE and Windows Mobile devices (similar to windows .msi files). You probably already have installed several application using .cab files, and are familiar with the concept. One point which is often unknown is that .cab files are processed by wceloader.exe, and it can only install one .cab file at a time. That means we cannot have nested .cab files. It doesn't mean we cannot have .cab files contained by another .cab, but the contained .cab files will not be installed during the installation of the container .cab. We should install it manually after the container .cab file installation has been completed.

There are two ways to create a cabinet (.Cab) file. The traditional one, and the friendly VS Smart Device Cab project which doesn't require additional coding, but which also relies on the traditional one at low-level.

How to transfer files between computer and mobile device using bluetooth

What is Bluetooth? How can I have it on my computer?

Bluetooth wireless technology is a communication technology that allows two devices to communicate wirelessly. Most of the notebooks are nowadays equipped with bluetooth. For those notebooks or computers that don't, you can use a bluetooth dongle to add the functionality and it just costs you around $5. Although higher price range bluetooth dongles are available but it makes no sense of buying them if you just plan to connect your mobile device to the computer. Look for one that has Bluetooth v2.0 + EDR (Enhance Data Rate) supporting speeds of upto 3Mbps and with Vista support. You can easily have one of that kind in just $5.

Setting up bluetooth to work on your computer

Just Insert the bluetooth dongle in the USB.
It should get detected by your Operating System and should be ready to use. In case it is just detected as a new hardware, you need to install drivers for it that came with your bluetooth dongle (You can try Google to find the drivers).
Once drivers are installed, a bluetooth notification icon will appear in your system tray.
Right Click on it to access Settings (This may vary with your bluetooth dongle).
Make sure you have turned Discovery On (It allow others to see your computer).
Switch On the bluetooth on the mobile device.

Microsoft Application Block for Data Access in .NET

Hi all,

I was rummaging the internet learning aspx and came across the concept of: Microsoft Application Block for Data Access in .NET

It seems great of course. The articles are all early 2003-5 such as

http://www.codeproject.com/KB/database/MS_Application_Blocks.aspx

So the question is - is this tech still relevant and should I be using it?

Thanks,

Mat

data access library v4.1

Ive just started a project that will use the enterprise library 4.1 data access code blocks. Its been years since ive used them, can anyone tell me what assemblies I need to reference in my project in order to use them ? Ive referenced

Microsoft.Practices.EnterpriseLibrary.Data

are there any others I need ?

Runtime development for All mobile device

Hi,

I am planning to implement a runtime or Environment . which allow any Mobile application to run on top of IT.

Please give me couple of links or materials to help me out.

Thanks in advance.

Nihar

Device detection: standard & mobile web applications

Background:

I would like to host standard web pages as well as mobile web pages on a single website/virtual directory.

Questions:

Is there a simple way of sniffing out the machine type and then presenting either web or mobile application depending on the device?

Or is there a better solution other than creating separate website?

Many thanks

Create web site specific to mobile device, how to detect?

Hi

I have a website that is written in .Net 2.0 which uses all the nice rich functionality of the web (Ajax, javascript etc..). However I have noticed that the site does not display very well on mobile devices.

So therefore I would like to create a more streamlined version of my site that is better tailored to these devices. However how do detect that the user has come to the site via a mobile device and how can i redirect them to my tailored page

Many thanks in advance

Obtain mobile device screen size

I am trying to get the screenHeight and width:

 // Get MobileCapabilities from current Request.Browser
        MobileCapabilities currentCapabilities = (MobileCapabilities)Request.Browser;
        // get a property of the  browser 
        Response.Write(currentCapabilities.ScreenPixelsHeight +  " <br>");
        Response.Write(currentCapabilities.ScreenPixelsWidth  + " <br>");

but this is always show that the Height is 480 & the width is 640

I am trying on HTC with Opera Mobile 9.5

Any Advice?

Data Points: Deny Table Access to the Entity Framework Without Causing a Mutiny

Julie Lerman shows database administrators how to limit access to databases from the Entity Framework by allowing it to work only with views and stored procedures instead of tables-without impacting application code or alienating developers.

Julie Lerman

MSDN Magazine August 2010

Data Access: Building a Desktop To-Do Application with NHibernate

Building an NHibernate-based desktop application isn't any harder than building a web application, and in many cases NHibernate simplifies elements of session handling and concurrency.

Oren Eini

MSDN Magazine December 2009

EF Data Access: EF v2 and Data Access Architecture Best Practices

Developers deploy a wide variety of development philosophies and architecture styles. This article explores three common perspectives on application development and describes how the Entity Framework can be employed in each. Specifically, the article looks at the forms-centric, model-centric, and code-centric development styles and their relationship to the Entity Framework.

Tim Mallalieu

MSDN Magazine August 2009


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All