Questions tagged [mdf]

Master Database File (.MDF) is the starting point of a SQL Server database. It is the primary data file and also points to the other files in the database.

See the Wikipedia article on Microsoft SQL Server.

Related Tags:

429 questions
-1
votes
2 answers

How to Get SQL data that contains given data as a part

I need to Display inventory Report that have Fields like BillDate, ProductName,Qty. And I Need Only that product With BillDate Contains Selected Month. If I Selected Month As Jan Only of Jan Month Bills should Be displayed.
-1
votes
1 answer

C# Winform application crash on SqlConnection

I have a Winform program that has a lot of SqlConnection function that interacts with a local MDF database. This is how I create the connection string: String dbPath = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) +…
YosiFZ
  • 7,792
  • 21
  • 114
  • 221
-1
votes
1 answer

How to export MDF to Excel or CSV using Python asammdf

I have one sample sql server DB mdf file .I need to convert the file to excel or csv.i searched but not get correct solution.Finally I found one package from python asammdf I don't know how to do this .i am really new with python and sql server. My…
prasanth
  • 22,145
  • 4
  • 29
  • 53
-1
votes
1 answer

Connection string Error when trying to make Installation

I made EntityFramework (6) CodeFirst WinForms application On my machine it works fine but when I'm trying to make Installation (with VS 2015 Installing projects) of my project and to run it on another machine, I get Expansion of Data Directory…
-1
votes
1 answer

how delete spaces in a data (database) after a word

I have a problem.. When I recup the information in my database, I have a lot of blanks after my word because the size in the cells is 10 and I have a word with a size of 3 (example: "abc" and I recup the world "abc "). Thanks !
Al Kural
  • 1
  • 2
-1
votes
1 answer

Get column description from mdf file in CSharpDbContext.Types.tt

I'm modifying CSharpDbContext.Types.tt file. I want to use column description as comment of fields in entity class. I'd to ask how to get description of columns from mdf file and then set to EdmProperty.Documentation in CSharpDbContext.Types.tt…
NhanQV
  • 81
  • 1
  • 1
  • 8
-1
votes
1 answer

Connection String on Visual Studio 2013 with SQL Server 2014

This is my connection string on my Visual Studio, my database file name is IOOP_Database Data Source=IDEA-PC\SQLEXPRESS;Initial Catalog=IOOP_Database;Integrated Security=True The problem is when I run this system on another laptop, there will be a…
-1
votes
1 answer

How to rollback database only with MDF and LDF files but without backup file?

Is it possible to rollback only with MDF and LDF files but without backup file? I worked days but suddenly it's gone. It's important to me.
Kay Lee
  • 922
  • 1
  • 12
  • 40
-1
votes
1 answer

How can I remove one primary file from an MDF database?

One of the MDF files for a SQL Server database inadvertently ended up with 2 primary files (1 database is pointing to 2 different MDF files). How can I remove the reference to one of these files, so that I may reattach my database and bring it…
M.Clark
  • 57
  • 2
  • 7
-1
votes
1 answer

Can't update/add/remove from/to Entity Framework

the behavior I'm dealing with is kinda weird, I can fetch information from the Database but not add/edit or remove. I'm not receiving any exception. it just won't update my Database : / Any suggestions? I have tried using ID without increment, but…
alentor
  • 27
  • 3
  • 12
-2
votes
1 answer

Importing a .cvs file into a detached .mdf?

I was asked to repost this question, due to the answers were not going the right directions. I have a detached database similar to to Northwind.MDF I want to import a .CVS file into this MDF file. I have the mdf file as part of my Solution Explorer…
StephanM
  • 733
  • 3
  • 22
  • 36
-2
votes
1 answer

How to export data to .dat file using mdfreader library in python?

I have a ABC.dat file which contains many signals along with their corresponding values. I want to select few signals from this ABC.dat file and would like to export these signals to a new XYZ.dat file. How can I achieve this using mdfreader library…
-2
votes
1 answer

need help extracting data from a local .mdf file and send it to my flutter app

i am building a test app that will display all the sales made by a shop. this app will be built with the flutter framework, i do not have any problem when it come to front-end, but as of the back-end side of the app i have no idea where to start. i…
-2
votes
1 answer

How do i check if my number is a valuable id in datatable?

I want to check if my randomly generated number matches [id] from my datatable, this is necessary so that I can take random values ​​from the table by id. what i came up to: Random rnd = new Random(); int card =…
Draconov
  • 1
  • 3
-2
votes
1 answer

Winforms application : How to save .mdf to Windows %USERPROFILE% folder?

I have a Winforms application and I would like to save my database.mdf to %USERPROFILE% folder. Does anyone know what i need to write to the connection string for this to work? Simply using %USERPROFILE% does not work.
Athanasios Emmanouilidis
  • 2,084
  • 3
  • 18
  • 30
1 2 3
28
29