Click here to Skip to main content
15,887,214 members
Home / Discussions / C#
   

C#

 
GeneralRe: Multi Desktop app, Need to take Screen short of a given desktop using handle. Pin
ptr_Electron20-Jan-14 0:40
ptr_Electron20-Jan-14 0:40 
AnswerRe: Multi Desktop app, Need to take Screen short of a given desktop using handle. Pin
Bernhard Hiller20-Jan-14 3:47
Bernhard Hiller20-Jan-14 3:47 
GeneralRe: Multi Desktop app, Need to take Screen short of a given desktop using handle. Pin
ptr_Electron20-Jan-14 7:11
ptr_Electron20-Jan-14 7:11 
QuestionSuggestion required for Accounting Software core infrastructure VS2010 C# MySql Pin
ahmed_one19-Jan-14 18:48
ahmed_one19-Jan-14 18:48 
AnswerRe: Suggestion required for Accounting Software core infrastructure VS2010 C# MySql Pin
Mycroft Holmes19-Jan-14 20:57
professionalMycroft Holmes19-Jan-14 20:57 
GeneralRe: Suggestion required for Accounting Software core infrastructure VS2010 C# MySql Pin
ahmed_one19-Jan-14 21:11
ahmed_one19-Jan-14 21:11 
GeneralRe: Suggestion required for Accounting Software core infrastructure VS2010 C# MySql Pin
Trak4Net20-Jan-14 9:01
Trak4Net20-Jan-14 9:01 
GeneralRe: Suggestion required for Accounting Software core infrastructure VS2010 C# MySql Pin
ahmed_one20-Jan-14 17:05
ahmed_one20-Jan-14 17:05 
Trak4Net wrote:
I am not an accountant nor have I ever worked on any accounting software, but I have dealt with database applications a lot. Your suggested records per year of 50-80K will definitely not be an issue for a database table on platforms like MySQL or MSSQL or Oracle or the likes, unless you are running wide open queries such as (select * from table) without any filter or limitation on rows returned.

Database design can become complicated if you want a very efficient means of storing your data. You may look over your required data several times and see if there are relations to break out into separate tables as much as possible and use primary keys, foreign keys and joins to bring your data together. Such as your "year" you could create a table that contains a primary key, year identifier and other year associated data and then that primary key would be a foreign key in your transaction table to match those transactions to that year etc.

 

Hopefully that kind of makes some sense and helps in some way.


Very nice guidelines, I will definitely follow them, thanks a lot.
Questioncreate and use .DLL Pin
DrooBo19-Jan-14 6:28
DrooBo19-Jan-14 6:28 
SuggestionRe: create and use .DLL Pin
Richard MacCutchan19-Jan-14 6:52
mveRichard MacCutchan19-Jan-14 6:52 
AnswerRe: create and use .DLL Pin
Dave Kreskowiak19-Jan-14 6:57
mveDave Kreskowiak19-Jan-14 6:57 
AnswerRe: create and use .DLL Pin
DrooBo19-Jan-14 7:30
DrooBo19-Jan-14 7:30 
GeneralRe: create and use .DLL Pin
Dave Kreskowiak19-Jan-14 10:22
mveDave Kreskowiak19-Jan-14 10:22 
GeneralRe: create and use .DLL Pin
Richard MacCutchan19-Jan-14 22:36
mveRichard MacCutchan19-Jan-14 22:36 
AnswerRe: create and use .DLL Pin
Ron Beyer19-Jan-14 10:38
professionalRon Beyer19-Jan-14 10:38 
GeneralRe: create and use .DLL Pin
BillWoodruff19-Jan-14 12:58
professionalBillWoodruff19-Jan-14 12:58 
GeneralRe: create and use .DLL Pin
Ron Beyer19-Jan-14 13:18
professionalRon Beyer19-Jan-14 13:18 
GeneralRe: create and use .DLL Pin
BillWoodruff19-Jan-14 15:09
professionalBillWoodruff19-Jan-14 15:09 
GeneralRe: create and use .DLL Pin
Ron Beyer19-Jan-14 15:12
professionalRon Beyer19-Jan-14 15:12 
AnswerRe: create and use .DLL Pin
BillWoodruff19-Jan-14 11:00
professionalBillWoodruff19-Jan-14 11:00 
AnswerRe: create and use .DLL Pin
Mycroft Holmes19-Jan-14 18:07
professionalMycroft Holmes19-Jan-14 18:07 
GeneralRe: create and use .DLL Pin
DrooBo19-Jan-14 22:42
DrooBo19-Jan-14 22:42 
Questionabout suppoted technologies Pin
gupta vipin11118-Jan-14 6:25
gupta vipin11118-Jan-14 6:25 
AnswerRe: about suppoted technologies Pin
Dave Kreskowiak18-Jan-14 6:37
mveDave Kreskowiak18-Jan-14 6:37 
SuggestionDelete an edited answer Pin
agent_kruger18-Jan-14 2:28
professionalagent_kruger18-Jan-14 2:28 

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.