Click here to Skip to main content
15,890,123 members
Home / Discussions / C#
   

C#

 
AnswerRe: Creating & writing to a text file from two different forms Pin
Dave Kreskowiak3-Nov-18 10:06
mveDave Kreskowiak3-Nov-18 10:06 
GeneralRe: Creating & writing to a text file from two different forms Pin
Member 140427684-Nov-18 4:03
Member 140427684-Nov-18 4:03 
GeneralRe: Creating & writing to a text file from two different forms Pin
Eddy Vluggen4-Nov-18 4:15
professionalEddy Vluggen4-Nov-18 4:15 
GeneralRe: Creating & writing to a text file from two different forms Pin
OriginalGriff4-Nov-18 6:34
mveOriginalGriff4-Nov-18 6:34 
AnswerRe: Creating & writing to a text file from two different forms Pin
Richard MacCutchan3-Nov-18 10:07
mveRichard MacCutchan3-Nov-18 10:07 
AnswerRe: Creating & writing to a text file from two different forms Pin
OriginalGriff3-Nov-18 20:28
mveOriginalGriff3-Nov-18 20:28 
AnswerRe: Creating & writing to a text file from two different forms Pin
BillWoodruff4-Nov-18 6:47
professionalBillWoodruff4-Nov-18 6:47 
Questionbest mothod for save file database C# Pin
arman02-Nov-18 4:40
arman02-Nov-18 4:40 
hi
What is the best method to store files in the database?
Storing large files in the database takes a few seconds
now for this witch method is best to control on insert method
When the size of a file is greater, it should monitor the storage process
Which one is best for you?
backgroundworker
Async
Threading
or ?

string filePath = "";
        string connectionString = "";
        FileStream stream = new FileStream(filePath, FileMode.Open, FileAccess.Read);
        BinaryReader reader = new BinaryReader(stream);
        byte[] file = reader.ReadBytes((int)stream.Length);
        reader.Close();
        stream.Close();

        SqlCommand command;
        SqlConnection connection = new SqlConnection(connectionString);
        command = new SqlCommand("INSERT INTO FileTable (File) Values(@File)", connection);
        command.Parameters.Add("@File", SqlDbType.Binary, file.Length).Value = file;
        connection.Open();
        command.ExecuteNonQuery();

AnswerRe: best mothod for save file database C# Pin
OriginalGriff2-Nov-18 5:16
mveOriginalGriff2-Nov-18 5:16 
AnswerRe: best mothod for save file database C# Pin
Gerry Schmitz2-Nov-18 6:06
mveGerry Schmitz2-Nov-18 6:06 
AnswerRe: best mothod for save file database C# Pin
Eddy Vluggen3-Nov-18 2:07
professionalEddy Vluggen3-Nov-18 2:07 
QuestionList of surrounding points Pin
Bernhard Hiller2-Nov-18 3:16
Bernhard Hiller2-Nov-18 3:16 
AnswerRe: List of surrounding points Pin
Dar Brett2-Nov-18 5:15
Dar Brett2-Nov-18 5:15 
GeneralRe: List of surrounding points Pin
Bernhard Hiller4-Nov-18 21:44
Bernhard Hiller4-Nov-18 21:44 
AnswerRe: List of surrounding points Pin
Gerry Schmitz2-Nov-18 5:50
mveGerry Schmitz2-Nov-18 5:50 
GeneralRe: List of surrounding points Pin
BillWoodruff9-Nov-18 13:28
professionalBillWoodruff9-Nov-18 13:28 
AnswerRe: List of surrounding points Pin
Daniel Pfeffer4-Nov-18 23:53
professionalDaniel Pfeffer4-Nov-18 23:53 
AnswerRe: List of surrounding points Pin
BillWoodruff9-Nov-18 13:26
professionalBillWoodruff9-Nov-18 13:26 
GeneralRe: List of surrounding points Pin
Bernhard Hiller11-Nov-18 21:33
Bernhard Hiller11-Nov-18 21:33 
GeneralRe: List of surrounding points Pin
BillWoodruff11-Nov-18 22:26
professionalBillWoodruff11-Nov-18 22:26 
GeneralRe: List of surrounding points Pin
Bernhard Hiller13-Nov-18 21:57
Bernhard Hiller13-Nov-18 21:57 
GeneralRe: List of surrounding points Pin
BillWoodruff13-Nov-18 22:05
professionalBillWoodruff13-Nov-18 22:05 
GeneralRe: List of surrounding points Pin
Bernhard Hiller13-Nov-18 22:22
Bernhard Hiller13-Nov-18 22:22 
Question[SOLVED] I need help with NIM GAME IN C# Pin
RES7B4-Nov-18 5:23
RES7B4-Nov-18 5:23 
AnswerRe: I need help with NIM GAME IN C# Pin
OriginalGriff1-Nov-18 21:07
mveOriginalGriff1-Nov-18 21:07 

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.