how to insert bulk data using c#.net?

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Bulk : System.Web.UI.Page
{

SqlCommand cmd = new SqlCommand();
SqlDataAdapter adp = new SqlDataAdapter();
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection("uid=srp;pwd=12345;server=kagserver");
SqlBulkCopy bulk = new SqlBulkCopy("uid=srp;pwd=12345;server=kagserver");
protected void Page_Load(object sender, EventArgs e)
{
adp = new SqlDataAdapter("select * from Test", con);
adp.Fill(dt);

con.Open();
bulk.DestinationTableName="Test1";
bulk.SqlRowsCopied +=new SqlRowsCopiedEventHandler(bulkCopy_SqlRowsCopied);
bulk.WriteToServer(dt);
con.Close();

}
void bulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
string str=String.Format("{0} Rows have been copied.", e.RowsCopied.ToString());
ScriptManager.RegisterStartupScript(this,this.GetType(),"",str,true);
}

}