Click here to Skip to main content
14,366,083 members
   

C#

 
AnswerRe: How to perform the content of a variable as a C# instruction Pin
BillWoodruff1-Jun-19 16:33
mveBillWoodruff1-Jun-19 16:33 
GeneralRe: How to perform the content of a variable as a C# instruction Pin
Member 133074841-Jun-19 19:22
memberMember 133074841-Jun-19 19:22 
AnswerRe: How to perform the content of a variable as a C# instruction Pin
jschell2-Jun-19 9:53
memberjschell2-Jun-19 9:53 
QuestionHow To Make This Generic Pin
Kevin Marois31-May-19 12:55
professionalKevin Marois31-May-19 12:55 
AnswerRe: How To Make This Generic Pin
#realJSOP1-Jun-19 6:00
mve#realJSOP1-Jun-19 6:00 
QuestionAsk C# everyone God, about SQLiteHelper increase delete to modify the static to directly call the way Pin
Dhjjf29-May-19 23:15
memberDhjjf29-May-19 23:15 
AnswerRe: Ask C# everyone God, about SQLiteHelper increase delete to modify the static to directly call the way Pin
BillWoodruff29-May-19 23:41
mveBillWoodruff29-May-19 23:41 
AnswerRe: Ask C# everyone God, about SQLiteHelper increase delete to modify the static to directly call the way Pin
Eddy Vluggen29-May-19 23:56
mveEddy Vluggen29-May-19 23:56 
Before you read my complaints at the bottom, it is quite good code; rather readable, and already using parameterized queries. If this were in a project, I would not change it. I do have some suggestions of course.

Dhjjf wrote:
It can be called directly without using instantiation.
That's mostly limiting the existing class. Being able to create multiple connections and commands gives an added flexibility.

private void TextBox2_TextChanged(object sender, EventArgs e)  //新增插入数据      
{    
  using (SQLiteConnection con = new SQLiteConnection(connectionString))
  using (SQLiteCommand cmd = con.CreateCommand())// this way u need not set con. property
  {
   try
   {
     cmd.CommandText = "INSERT INTO KD(postID,ddtime)values(@postID,@ddtime)";
            SQLiteParameter[] cmdParms = new SQLiteParameter[]{
             new SQLiteParameter("@postID", (textBox2.Text)),
             new SQLiteParameter("@ddtime", DateTime.Now)
                   };
      int recordsAffected = cmd.ExecuteNonQuery(cmdParms);
      Debug.Assert(recordsAffected != 1); //should only affect 1 record
   }
   catch (Exception ex)
   {
     Debug.WriteLine(ex.ToString()); // gives the complete message+stacktrace in debug window
     throw; // don't throw ex, just throw
   }
  }
} 
Also, your version would be harder to use than the OO-version; the original I can wrap in a decorator-pattern, extending its functionality without changing the original classes.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

AnswerRe: Ask C# everyone God, about SQLiteHelper increase delete to modify the static to directly call the way Pin
OriginalGriff30-May-19 0:00
protectorOriginalGriff30-May-19 0:00 
AnswerRe: Ask C# everyone God, about SQLiteHelper increase delete to modify the static to directly call the way Pin
#realJSOP30-May-19 5:55
mve#realJSOP30-May-19 5:55 
GeneralRe: Ask C# everyone God, about SQLiteHelper increase delete to modify the static to directly call the way Pin
Eddy Vluggen30-May-19 8:20
mveEddy Vluggen30-May-19 8:20 
GeneralRe: Ask C# everyone God, about SQLiteHelper increase delete to modify the static to directly call the way Pin
#realJSOP30-May-19 8:24
mve#realJSOP30-May-19 8:24 
PraiseRe: Ask C# everyone God, about SQLiteHelper increase delete to modify the static to directly call the way Pin
Eddy Vluggen30-May-19 8:29
mveEddy Vluggen30-May-19 8:29 
SuggestionRe: Ask C# everyone God, about SQLiteHelper increase delete to modify the static to directly call the way Pin
Richard Deeming30-May-19 8:46
mveRichard Deeming30-May-19 8:46 
GeneralRe: Ask C# everyone God, about SQLiteHelper increase delete to modify the static to directly call the way Pin
#realJSOP1-Jun-19 6:02
mve#realJSOP1-Jun-19 6:02 
QuestionFile keeps getting corrupted on just one machine Pin
jkirkerx29-May-19 13:51
professionaljkirkerx29-May-19 13:51 
AnswerRe: File keeps getting corrupted on just one machine PinPopular
Dave Kreskowiak29-May-19 14:11
mveDave Kreskowiak29-May-19 14:11 
GeneralRe: File keeps getting corrupted on just one machine Pin
jkirkerx29-May-19 14:17
professionaljkirkerx29-May-19 14:17 
AnswerRe: File keeps getting corrupted on just one machine Pin
Dave Kreskowiak29-May-19 14:13
mveDave Kreskowiak29-May-19 14:13 
GeneralRe: File keeps getting corrupted on just one machine Pin
jkirkerx29-May-19 14:25
professionaljkirkerx29-May-19 14:25 
QuestionDownload files Pin
Member 1447263829-May-19 1:23
memberMember 1447263829-May-19 1:23 
AnswerRe: Download files Pin
#realJSOP29-May-19 1:36
mve#realJSOP29-May-19 1:36 
AnswerRe: Download files Pin
Pete O'Hanlon29-May-19 1:42
protectorPete O'Hanlon29-May-19 1:42 
GeneralRe: Download files Pin
Member 1447263829-May-19 4:12
memberMember 1447263829-May-19 4:12 
GeneralRe: Download files Pin
OriginalGriff29-May-19 4:14
protectorOriginalGriff29-May-19 4:14 

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.