Tips & Tricks for ASP.NET - C#

myCon.Open();
        //cmdAns.Connection = myCon;
//        AnswerSql = "INSERT INTO pollAnswer (qid,Answer) values(@qid,@answer)";

        DataTable dtAns = new DataTable();

        DataColumn dcAns;

        dcAns = new DataColumn();
        dcAns.ColumnName = "aid";
        dcAns.DataType = Type.GetType("System.String");
        dtAns.Columns.Add(dcAns);

       
       
        dcAns = new DataColumn();
        dcAns.ColumnName = "qid";
        dcAns.DataType = Type.GetType("System.String");
        dtAns.Columns.Add(dcAns);

        dcAns = new DataColumn();
        dcAns.ColumnName = "answer";
        dcAns.DataType = Type.GetType("System.String");
        dtAns.Columns.Add(dcAns);
       

            
        DataRow drAns;
        drAns = dtAns.NewRow();

        drAns["aid"] = Guid.NewGuid();
        drAns["qid"] = qid;
        drAns["answer"] = txtAns1.Text;

        dtAns.Rows.Add(drAns);

        SqlBulkCopy sbcPoll = new SqlBulkCopy(myCon);

        sbcPoll.DestinationTableName = "pollAnswer_T";

        sbcPoll.WriteToServer(dtAns);

       
        myCon.Close();