>Not to be mean or anything, Naomi ... but it's really not a good idea to post several un-related questions in one post.
>
>1) AFAIK, you can't automatically generate a date in a comment
>
>2) The answer I gave before for the parameters applies equally if you're constructing the command with a StringBuilder. Why wouldn't it?
>
>~~Bonnie
>

May be I'm not yet understanding something.

Here is some code:

Command.CommandText = this.RecurrPrograms(ProgramID);

And in the RecurrPrograms method there is a string created

System.Text.StringBuilder RecurrQuery = new System.Text.StringBuilder();

and then

tplEntry = string.Format("INSERT INTO Programs2Times (" +
                "[ProgramID],[TimeOfProgram],[EndTime],[Fee],[VolunteerFee],[VolunteersReq],[Canceled]" +
                ",[Facilitator]) VALUES({0},'{{0}} {1}','{{0}} {2}', " +
                "{3}, {4}, {5}, 0, '{6}')\n", ProgramID, StartTime, EndTime, this.txtbProgFee.Text,
                VolFee, this.txtbProgVolReq.Text, this.txtbPrgFacilitator.Text);

and appended later in the loop.

How can I apply Parameters here?