从SQL server生成CSV文件并检索数据

我试图生成一个excel，我可以得到excel，但一些数据(实际上一个单元格内容)丢失。例如:在sql server查询(它应该显示在建议列下的一个单元格中，就像在excel中一样):

建议类型:恭维类别:医生名称:Hey

然而，在我的excel中，在专栏建议下，它只显示我-类型:赞美，然后类别:医生名称:嘿不见了。也许我的预测是错误的，或者我检索数据的方式是错误的。

    private DataTable GetData(SqlCommand cmd)
    {
        DataTable dt = new DataTable();
        String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnStr"].ConnectionString;
        SqlConnection con = new SqlConnection(strConnString);
        SqlDataAdapter sda = new SqlDataAdapter();
        cmd.CommandType = CommandType.Text;
        cmd.Connection = con;
        try
        {
            con.Open();
            sda.SelectCommand = cmd;
            sda.Fill(dt);
            return dt;
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            con.Close();
            sda.Dispose();
            con.Dispose();
        }
    }
    protected void GenerateCSV_Click(object sender, EventArgs e)
    {
        //First file Inpatient
        StringBuilder sb = new StringBuilder();
        //fill up DT here
        string strQuery ="Select * from table AND Date BETWEEN @FDT AND @TDT"
        SqlCommand cmd = new SqlCommand(strQuery);

        string fromdate = tbStartDate.Text;
        DateTime fdt = Convert.ToDateTime(fromdate);
        string todate = tbEndDate.Text;
        DateTime tdt = Convert.ToDateTime(todate);

        cmd.Parameters.AddWithValue("@FDT", fdt);
        cmd.Parameters.AddWithValue("@TDT", tdt);
        DataTable dt = GetData(cmd);
        //end
        for (int k = 0; k < dt.Columns.Count; k++)
        {
            //add separator
            sb.Append(dt.Columns[k].ColumnName + ',');
        }
        //append new line
        sb.Append("'r'n");
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            for (int k = 0; k < dt.Columns.Count; k++)
            {
                if (dt.Columns[k].ColumnName.Equals("CommentsSuggestions"))
                {
                    //add separator
                    sb.Append("'"" + dt.Rows[i][k].ToString().Replace(",", ";") + "'"" + ',');
                }
                else
                {
                    //add separator
                    sb.Append(dt.Rows[i][k].ToString().Replace(",", ";") + ',');
                }
            }
            //append new line
            sb.Append("'r'n");
        }
         File.WriteAllText(@"C:'ExportCSV'Inpatient.csv", sb.ToString());

Select * from table WHERE Date BETWEEN @FDT AND @TDT

Select * from table AND Date BETWEEN @FDT AND @TDT