Try to convert your xml string variable into XmlDocument and then pass that xml object to your Sql query as parameter.
protected void UploadXML(object sender, EventArgs e)
{
string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string filePath = Server.MapPath("~/Uploads/") + fileName;
FileUpload1.SaveAs(filePath);
string xml = File.ReadAllText(filePath);
XmlDocument xd = new XmlDocument();
xd.LoadXml(xml);
string constr = ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("InsertXML"))
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@xml", xd);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
This may helps!