Remove Empty rows from datatable using c#

public DataTable RemoveEmptyRowsFromDataTable(DataTable dt)
        {
            for (int i = dt.Rows.Count - 1; i >= 0; i--)
            {
                if (dt.Rows[i][1] == DBNull.Value)
                    dt.Rows[i].Delete();
            }
            dt.AcceptChanges();
            return dt;
        }

Bulk Insert in MS-SQL using c#

using (SqlConnection con = new SqlConnection(consString))
                    {
                        using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
                        {
                            //Set the database table name
                            sqlBulkCopy.DestinationTableName = "PLQualifications";

                            //[OPTIONAL]: Map the DataTable columns with that of the database table
                            sqlBulkCopy.ColumnMappings.Add("QualificationId", "QualificationId");
                            sqlBulkCopy.ColumnMappings.Add("PLQuestionCode", "PLQuestionCode");
                            sqlBulkCopy.ColumnMappings.Add("LanguageId", "LanguageId");
                            con.Open();
                            sqlBulkCopy.WriteToServer(distinctQualifications);
                            con.Close();
                        }
                    }

Removing unrecognized ASCII characters from string c#

var stripped = Regex.Replace("străipped of baâ€d charâ€cters", "[^ -~]", "");

[ -~] matches all printable ascii characters (light blue background)