Click here to Skip to main content
15,891,136 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Maintain scroll position Pin
BobbyStrain8-Dec-14 12:19
BobbyStrain8-Dec-14 12:19 
GeneralRe: Maintain scroll position Pin
jkirkerx8-Dec-14 12:47
professionaljkirkerx8-Dec-14 12:47 
Questionconnection string Pin
dinusahu21-Nov-14 6:34
dinusahu21-Nov-14 6:34 
AnswerRe: connection string Pin
jkirkerx21-Nov-14 8:37
professionaljkirkerx21-Nov-14 8:37 
GeneralRe: connection string Pin
dinusahu21-Nov-14 18:51
dinusahu21-Nov-14 18:51 
GeneralRe: connection string Pin
jkirkerx21-Nov-14 18:58
professionaljkirkerx21-Nov-14 18:58 
GeneralRe: connection string Pin
dinusahu21-Nov-14 22:38
dinusahu21-Nov-14 22:38 
GeneralRe: connection string Pin
jkirkerx22-Nov-14 8:32
professionaljkirkerx22-Nov-14 8:32 
dinusahu wrote:
but when we use the sql server as a database then we are using the .mdf file from the App_data folder

I actually think your using Microsoft Access, a file-based-database with the data file stored in App_Data
MySQL is a server-based database, with the data stored in the default MySQL location, and uses a much different file format.

dinusahu wrote:
but at the point of mysql is it possible?

I will plagiarize this persons thoughts here, on the difference between the 2 server types, so you can come up with your own answer, then choose you own path.

What is the difference between a file-based database and a server-based database

First of all databases are stored in files! So a simplified answer would be there is no difference.

But when we refer to file-based databases we mean databases that we interact with/update directly (via an SQL abstraction offered by the JDBC driver) but in essence we just read/write to a file directly. Example would be SQLite

When we talk about server based databases we mean that there is a server process running (bind to some port), that accepts requests (i.e. SQL queries). Your process connects to the server and sends queries to the server which itself is responsible to update the database files. Example is MS-SQL Server.

The server based database could be anywhere (could be accessed via network) while the file-based database must be in a file in the local file-system.

Which one to choose depends on your needs.

Credit goes to the author below
http://stackoverflow.com/questions/10564073/what-is-the-difference-between-a-file-based-database-and-a-server-based-database[^]

MySQL is a server based database, and cannot be used as a file in App_Data.
I refer to MySQL because that's what your first question refereed to.

MySQL Tutorial
http://www.elated.com/articles/mysql-for-absolute-beginners/[^]
QuestionDatagrid vs Generating table and rows Pin
neualex21-Nov-14 2:30
neualex21-Nov-14 2:30 
QuestionASP.net Pin
nikky13.batra@gmail.com20-Nov-14 19:21
nikky13.batra@gmail.com20-Nov-14 19:21 
SuggestionRe: ASP.net Pin
ZurdoDev21-Nov-14 2:23
professionalZurdoDev21-Nov-14 2:23 
Questionsome questions Pin
Member 1124450118-Nov-14 8:27
Member 1124450118-Nov-14 8:27 
AnswerRe: some questions Pin
ZurdoDev18-Nov-14 8:51
professionalZurdoDev18-Nov-14 8:51 
QuestionMaxArrayLength Exception for large data blocks Pin
Tim Mackey (2)18-Nov-14 8:20
Tim Mackey (2)18-Nov-14 8:20 
AnswerRe: MaxArrayLength Exception for large data blocks Pin
Richard MacCutchan18-Nov-14 21:24
mveRichard MacCutchan18-Nov-14 21:24 
QuestionMaxArrayLength Exception for large data blocks Pin
Tim Mackey (2)18-Nov-14 4:23
Tim Mackey (2)18-Nov-14 4:23 
Questionstate management-sessions Pin
Member 1107145116-Nov-14 23:45
Member 1107145116-Nov-14 23:45 
AnswerRe: state management-sessions Pin
David Mujica17-Nov-14 3:19
David Mujica17-Nov-14 3:19 
AnswerRe: state management-sessions Pin
jkirkerx17-Nov-14 8:48
professionaljkirkerx17-Nov-14 8:48 
QuestionCross-page postback to new window Pin
BobbyStrain14-Nov-14 17:53
BobbyStrain14-Nov-14 17:53 
AnswerRe: Cross-page postback to new window Pin
DamithSL14-Nov-14 19:24
professionalDamithSL14-Nov-14 19:24 
AnswerRe: Cross-page postback to new window Pin
Dusara Maulik14-Nov-14 19:57
Dusara Maulik14-Nov-14 19:57 
GeneralRe: Cross-page postback to new window Pin
BobbyStrain15-Nov-14 8:17
BobbyStrain15-Nov-14 8:17 
QuestionCSS positioning issue for IE 11 Suggestion required Pin
Tridip Bhattacharjee14-Nov-14 3:23
professionalTridip Bhattacharjee14-Nov-14 3:23 
AnswerRe: CSS positioning issue for IE 11 Suggestion required Pin
jkirkerx14-Nov-14 8:24
professionaljkirkerx14-Nov-14 8:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.