Bulk Upload Methods in C#

protected void Page_Load(object sender, EventArgs e)
{
    //BulkUpload_Type();
    //BulkUpload_XML();
    // BulkUpload_writeToServer();
}
private void BulkUpload_Type()
{
    DataTable dt = CreateTable();
    string Objcon = System.Configuration.ConfigurationManager.AppSettings["DbConnectionStringMain"].ToString();
    try
    {
        SqlConnection Conn = new SqlConnection(Objcon);
        Conn.Open();
        SqlCommand objCmd = new SqlCommand();
        objCmd.Connection = Conn;
        objCmd.CommandText = "usp_InserEmployeeDetail121";
        objCmd.CommandType = CommandType.StoredProcedure;
        objCmd.Parameters.AddWithValue("@typEmployeeDetail", dt);
        objCmd.CommandTimeout = 10020;
        objCmd.ExecuteNonQuery();
    }
    catch (Exception)
    {
        throw;
    }
}
private void BulkUpload_XML()
{
    DataTable dt = CreateTable();
    string Objcon = System.Configuration.ConfigurationManager.AppSettings["DbConnectionStringMain"].ToString();
    try
    {
        SqlConnection Conn = new SqlConnection(Objcon);
        Conn.Open();
        SqlCommand objCmd = new SqlCommand();
        objCmd.Connection = Conn;
        objCmd.CommandText = "USP_InsertEmployee121";
        objCmd.CommandType = CommandType.StoredProcedure;
        objCmd.Parameters.AddWithValue("@DataTableInXML", ConvertDtToXML(dt));
        objCmd.CommandTimeout = 1020;
        objCmd.ExecuteNonQuery();
    }
    catch (Exception)
    {
        throw;
    }
}
private void BulkUpload_writeToServer()
{
    DataTable dt = CreateTable();
    string Objcon = System.Configuration.ConfigurationManager.AppSettings["DbConnectionStringMain"].ToString();
    using(SqlConnection cn = new SqlConnection(Objcon))
    {
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = cn;
        cn.Open();
        // Delete old records
        //cmd.CommandText = "TRUNCATE TABLE Employee1213";
        //cmd.CommandType = CommandType.Text;
        //cmd.ExecuteNonQuery();
        // Insert new records
        SqlBulkCopy bc = new SqlBulkCopy(cn, SqlBulkCopyOptions.TableLock, null);
        bc.BatchSize = dt.Rows.Count;
        bc.DestinationTableName = "Employee1213";
        bc.WriteToServer(dt);
        bc.Close();
    }
}
public string ConvertDtToXML(DataTable Dt)
{
    try
    {
        MemoryStream str = new MemoryStream();
        Dt.TableName = "XMLData";
        Dt.WriteXml(str, true);
        str.Seek(0, SeekOrigin.Begin);
        StreamReader strnew = new StreamReader(str);
        return strnew.ReadToEnd();
    }
    catch (Exception)
    {
        throw;
    }
}
public DataTable CreateTable()
{
    DataTable dt = new DataTable();
    dt.Columns.Add("Test", typeof(string));
    dt.Columns.Add("Name", typeof(string));
    dt.Columns.Add("Address", typeof(string));
    dt.Columns.Add("Pincode", typeof(string));
    for (int i = 0; i < 10000; i++)
    {
        dt.Rows.Add("T", "0", "1", "01-01-2015");
        dt.Rows.Add("T", "0", "2", "02-01-2015");
        dt.Rows.Add("T", "0", "3", "03-01-2015");
        dt.Rows.Add("T", "0", "4", "04-01-2015");
        dt.Rows.Add("T", "0", "5", "05-01-2015");
        dt.Rows.Add("T", "0", "6", "01-01-2015");
        dt.Rows.Add("T", "0", "7", "02-01-2015");
        dt.Rows.Add("T", "0", "8", "03-01-2015");
        dt.Rows.Add("T", "0", "9", "04-01-2015");
        dt.Rows.Add("T", "0", "10", "05-01-2015");
        dt.Rows.Add("T", "0", "11", "01-01-2015");
        dt.Rows.Add("T", "0", "12", "02-01-2015");
        dt.Rows.Add("T", "0", "13", "03-01-2015");
        dt.Rows.Add("T", "0", "14", "04-01-2015");
        dt.Rows.Add("T", "0", "15", "05-01-2015");
        dt.Rows.Add("T", "0", "16", "01-01-2015");
        dt.Rows.Add("T", "0", "17", "02-01-2015");
        dt.Rows.Add("T", "0", "18", "03-01-2015");
        dt.Rows.Add("T", "0", "19", "04-01-2015");
        dt.Rows.Add("T", "0", "20", "05-01-2015");
        dt.Rows.Add("T", "0", "21", "01-01-2015");
        dt.Rows.Add("T", "0", "22", "02-01-2015");
        dt.Rows.Add("T", "0", "23", "03-01-2015");
        dt.Rows.Add("T", "0", "24", "04-01-2015");
        dt.Rows.Add("T", "0", "25", "05-01-2015");
    }
    return dt;
}