Click here to Skip to main content
15,905,323 members
Home / Discussions / C#
   

C#

 
GeneralRe: What kind of dll use ftp/sftp mapping drive? Pin
Randor 13-Oct-20 15:49
professional Randor 13-Oct-20 15:49 
GeneralRe: What kind of dll use ftp/sftp mapping drive? Pin
Dave Kreskowiak13-Oct-20 18:58
mveDave Kreskowiak13-Oct-20 18:58 
GeneralRe: What kind of dll use ftp/sftp mapping drive? Pin
Randor 13-Oct-20 19:39
professional Randor 13-Oct-20 19:39 
GeneralRe: What kind of dll use ftp/sftp mapping drive? Pin
Dave Kreskowiak14-Oct-20 5:01
mveDave Kreskowiak14-Oct-20 5:01 
JokeRe: What kind of dll use ftp/sftp mapping drive? Pin
Randor 14-Oct-20 9:22
professional Randor 14-Oct-20 9:22 
Questionhow to insert unknown amount of data into a database Pin
steven_noppe11-Oct-20 7:41
steven_noppe11-Oct-20 7:41 
AnswerRe: how to insert unknown amount of data into a database Pin
Luc Pattyn11-Oct-20 8:32
sitebuilderLuc Pattyn11-Oct-20 8:32 
AnswerRe: how to insert unknown amount of data into a database Pin
OriginalGriff11-Oct-20 8:33
mveOriginalGriff11-Oct-20 8:33 
The problem is that "expanding tables" is a pain - or you waste a huge amount of space on many rows if they don't want to store much.
Instead, I'd use a number of tables:
Master
ID        INT, IDENTITY
this ties all the other data for the row together. You may want other columns, but only if they will always be needed.
RowDesc
ID        INT,IDENTITY
DataType  NVARCHAR
This holds the types of data the user may select
RowData
ID        INT, IDENTITY
MasterID  INT, FOREIGN KEY to Master.ID
RowID     INT, FOREIGN KEY to RowDesc.ID
VALUE     Your type for the data

When your user inserts a row, it creates a row in MASTER, and as many rows as necessary in RowData
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

AnswerRe: how to insert unknown amount of data into a database Pin
jsc4213-Oct-20 3:50
professionaljsc4213-Oct-20 3:50 
QuestionWhy am I not allowed to do this with events Pin
Keith Barrow9-Oct-20 1:20
professionalKeith Barrow9-Oct-20 1:20 
AnswerRe: Why am I not allowed to do this with events Pin
Richard Deeming9-Oct-20 2:12
mveRichard Deeming9-Oct-20 2:12 
GeneralRe: Why am I not allowed to do this with events Pin
Keith Barrow9-Oct-20 3:19
professionalKeith Barrow9-Oct-20 3:19 
QuestionHow to read from serial port until timeout of no more data received? Pin
td17768-Oct-20 13:27
td17768-Oct-20 13:27 
AnswerRe: How to read from serial port until timeout of no more data received? Pin
Luc Pattyn8-Oct-20 14:27
sitebuilderLuc Pattyn8-Oct-20 14:27 
GeneralRe: How to read from serial port until timeout of no more data received? Pin
td17768-Oct-20 15:36
td17768-Oct-20 15:36 
GeneralRe: How to read from serial port until timeout of no more data received? Pin
Luc Pattyn9-Oct-20 1:25
sitebuilderLuc Pattyn9-Oct-20 1:25 
AnswerRe: How to read from serial port until timeout of no more data received? Pin
Gerry Schmitz8-Oct-20 18:27
mveGerry Schmitz8-Oct-20 18:27 
GeneralRe: How to read from serial port until timeout of no more data received? Pin
td17769-Oct-20 11:16
td17769-Oct-20 11:16 
GeneralRe: How to read from serial port until timeout of no more data received? Pin
Gerry Schmitz9-Oct-20 14:10
mveGerry Schmitz9-Oct-20 14:10 
AnswerRe: How to read from serial port until timeout of no more data received? Pin
Richard MacCutchan8-Oct-20 22:55
mveRichard MacCutchan8-Oct-20 22:55 
AnswerMy (temporary?) solution Pin
td17769-Oct-20 11:25
td17769-Oct-20 11:25 
QuestionCOM exception loss Pin
Member 126326017-Oct-20 20:57
Member 126326017-Oct-20 20:57 
AnswerRe: COM exception loss Pin
Richard MacCutchan7-Oct-20 21:35
mveRichard MacCutchan7-Oct-20 21:35 
GeneralRe: COM exception loss Pin
Member 126326017-Oct-20 22:03
Member 126326017-Oct-20 22:03 
GeneralRe: COM exception loss Pin
Richard MacCutchan7-Oct-20 22:25
mveRichard MacCutchan7-Oct-20 22:25 

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.