Questions tagged [local-database]

This tag would be for cases where a database is accessed locally, not over a network.

This tag would be for cases where a database is accessed locally, not over a network. For example, an SQLite database used by a mobile app.

252 questions
1
vote
2 answers

Trouble connecting asp.net web site to local database .mdf file to retrieve data

I have tried everything but I am having trouble getting a basic asp.net site to connect to a database. I'm using Visual Studio and trying to retrieve data from a local database file into a table on a .cshtml page. The database I am trying to access…
STL-Lucas
  • 11
  • 1
1
vote
1 answer

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. when access local database

I have no idea.. why this occurs. In debug mode it is running well . however, now I am trying to run my project in IIS web server and it doesn't runs well. I can access the main page of my project. but when I try to access the local database, the…
1
vote
0 answers

How to execute synchronous queries on local database using javascript in windows phone 8.1 app?

I am using WebSQL plugin https://github.com/MSOpenTech/cordova-plugin-websql for a windows phone 8.1 phonegap app. Below is the code. var db = openDatabase(DATABASE_NAME, DATABASE_VERSION, function () { //showMessage('db successfully opened…
1
vote
1 answer

c# use datatable in other form datagridview

Hi Ive searched many topics, also here in stackoverflow, however none solved my problem This is my main form where I operate with my database and display items in datagridview public partial class Form1 : Form { DatabaseConnection objConnect; …
1
vote
1 answer

Store in memory or in local database

I'm developing an app in which I'll need to collect, from a MySQL server, a 5 years daily data (so, approximately 1825 rows of a table with about 6, 7 columns). So, for handling this data, I can, after retrieving it, store it in a local SQLite…
1
vote
1 answer

how to import excel csv file into a local database(service based database)?

I have a visual studio application which uses a local database with the help of service based database in VS2013. How can I import a csv file into this local database?
1
vote
3 answers

ASP.NET local SQL Server database C# gridview data binding Visual Studio 2013

I need some help because I've been trying different things but nothing seems to work properly the question itself is the one below. How can I bind data to a grid-view in Visual Studio 2013 with a local SQL Server database using the code behind C#…
Guillermo
  • 11
  • 1
  • 3
1
vote
0 answers

Crystal report does not show any data from local .sdf database in c# windows form

I have created a windows form application and added a local database on it and a crystal report and a crystal report viewer. here is the code private void crystalReportViewer1_Load(object sender, EventArgs e) { CrystalReport2…
1
vote
3 answers

Why doesn't DataDirectory change on run time

I am tring to connect to a local database with w winform c# application when i set my connection string to Data: Source=C:\Users\PACKARD BELL\documents\visual studio 2010\Projects\GestionStock\MyApp\Mydb.sdf it works fine but when i set it to Data…
user3336078
  • 53
  • 1
  • 11
1
vote
1 answer

Visual Studio Website: Can't create an SQL Database!

I'm using Visual Studio 2008 SP1 with SQL Server 2008. I'am trying to add an SQL Server File (MDF) in my Website project. Then I get the following error: Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly.…
1
vote
1 answer

call component from form to class and save data back to table

i am working on ado.net project,, i used to have separate classes for codes ,,, now i am trying to learn more about local databases but i am stock when i tried to call class that contain SQL commands ,,, please have a look to my code i commented…
1
vote
0 answers

Windows phone update local database when received toast notification in background

I am using toast push notifications in my Windows Phone 8 app. When I receive these notifications, I would like to update the local database of my app regardless whether the app is in foreground, background or not running. Do you know if is that…
1
vote
1 answer

MVVM and Azure mobile services

All the sample applications and code that I have come across for consuming Azure mobile services don't follow MVVM pattern for simplicity. How would one write an MVVM application that uses Azure mobile services for accessing data in cloud and then…
1
vote
2 answers

Amazon Dynamo DB - Issue in creating table in local database

I am using local Amazon Dynamo DB and trying to create a table as; Id | StartPoint1 | EndPoint 1 | StartPoint2 | EndPoint2 | Speed | Distance I tried using CreateTable() function but finding it difficult to create one. I am making use of .Net…
VJOY
  • 3,752
  • 12
  • 57
  • 90
1
vote
1 answer

Set location of SQL Server Compact database on publish

I have a Winforms application that uses a SQL Server Compact .SDF database to store data. The application runs fine in Visual Studio when debugging, though when I use the "Publish" option of my project and run the program after installation, I…
Daniel B
  • 8,770
  • 5
  • 43
  • 76