No database, data storage table c #-CodePudding

Recently at a machinery industry calculation procedure, which involves some of the parameters of the query problems, such as the strength of various steel, section properties, such as how to store the data in c #, and I in the calculation of time can query, use the select statement how many times do I have to choose, use Excel or Access to table, save on machines without installation of Excel and Access, can't open the data file, how to do, beg big help!!!!!!

CodePudding user response:

SQLite

CodePudding user response:

reference. 1/f, Beijing NET - six years of reply:

SQLite

Thank you, I am not doing IT industry, now write a calculation software has been studied for a long time

, very not easy, know about database is only a concept, Sqlite does not need any client deployment can also query, and I find that Windows system comes to the net Access drive, the client does not need to install the Access can also open the MDB file? SQlite is this principle?

CodePudding user response:

SQLite need not install what of, is also a small database, SQLite is to generate a DLL, the DLL is the database data

CodePudding user response:

XML text EXCEL etc

CodePudding user response:

references a wise man should know already take good karma, 4/f, response:

XML text EXCEL can

XML I know, but haven't learned the XML syntax, excel file client hadn't install Office should be related to the third party components to open it

CodePudding user response:

reference ManBOyyy reply: 3/f

SQLite need not install what of, is also a small database, SQLite just generate a DLL, the DLL is the database data

Wow, a little understood, that is not going to study the sqlite

CodePudding user response:

The structure of the XML if a table is not very complicated, so, to save and read only a few words of simple code.
https://blog.csdn.net/xianfajushi/article/details/11742249

CodePudding user response:

TXT

CodePudding user response:

Is a lightweight database sqlite3, very simple, vs nuget install packages, website next drive, and even can be directly built in vs database and table, then use sqliteconnection and sqlitecommand
Write SQL access, reload a ef package,, sqlite can ef

CodePudding user response:

If the data volume is not large, as long as is a text format can save!
From already set format

CodePudding user response:

the wise know already quoted 7 floor should good karma response:

XML if the table structure is not very complicated, so, to save and read only a few words of simple code.
https://blog.csdn.net/xianfajushi/article/details/11742249

Wow, look at the XML file, opened the door of the new world, again ask next XML file query is convenient

CodePudding user response:

references 9 f ilikeff8 response:

is a lightweight database sqlite3, very simple, vs nuget install packages, website next drive, and even can be directly built in vs database and table, then use sqliteconnection and sqlitecommand
Write SQL access, reload a ef package,, sqlite can ef

See, it can be used

CodePudding user response:

references 9 f ilikeff8 response:

is a lightweight database sqlite3, very simple, vs nuget install packages, website next drive, and even can be directly built in vs database and table, then use sqliteconnection and sqlitecommand
Write SQL access, reload a ef package,, sqlite can ef

To consult the bosses, Access files without installing Access client can realize open and query

CodePudding user response:

11 references DQYDXT response:

Quote: wise men know already quoted 7 floor should good karma response:
XML if the table structure is not very complicated, so, save and read only a few words of simple code.
https://blog.csdn.net/xianfajushi/article/details/11742249

Wow, look at the XML file, opened the door of the new world, is it convenient for you to ask query XML files

Use linq query, very convenient, search LinqToXml

CodePudding user response:

reference 13 floor DQYDXT reply:

Quote: references 9 f ilikeff8 response:
is a lightweight database sqlite3, very simple, vs nuget install packages, website next drive, and even can be directly built in vs database and table, then use sqliteconnection and sqlitecommand
Write SQL access, reload a ef package,, sqlite can ef

To consult the bosses, Access files without installing Access client can realize open and query?

Should install excel comes with it

CodePudding user response:

Save. Json format, using serialization 10 lines of code, the serialization, speaking, reading and writing does not need to learn;
Simple usage:
https://blog.csdn.net/i1tws/article/details/93137339

CodePudding user response:

TXT without any installation

CodePudding user response:

The ini, XML, if the data is how to play casually, under the condition of direct serialization to TXT

CodePudding user response:

Storing data into XML

CodePudding user response:

Where did the strength data of different steel?
I think you should write a function of data read, try to read into automation, such as download format is what is what, don't to do the import database, these things, is converted to XML into a collection, not what the database,

CodePudding user response:

reference HZTLTGG 20 floor response:

the strength data of different steel is in where?
I think you should write a function of data read, try to read into automation, such as download format is what is what, don't to do the import database, these things, is converted to XML into a collection, without what database,

Manual data is steel structure, the problem is how to save and query, mainly need an efficient way of query, such as through the cross section width lookup section moment of inertia and bending heart position

CodePudding user response:

XML, or even text can also

CodePudding user response:

The old man think query, what is the most convenient way, linq to XML and Sql statements, or how to query, people who want to everything, I just want to find a table and,,,

CodePudding user response:

refer to 21st floor DQYDXT response:

Quote: refer to the 20th floor HZTLTGG response:
the strength data of different steel is in where?
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull