Simplest way to pass an xml file as a store procedure parameter using c# [closed]

[dx2]

I'm looking for the simplest way to pass an xml file as a store procedure parameter using c#.Actually I need to create an xml file for the purpose of save this xml into the sql database.In database store procedure there has a parameter as xml type. I have already created a xml file stated bellow\[code\] StringWriter stringWriter = null; XmlTextWriter writer = null; try { stringWriter = new StringWriter(new StringBuilder()); writer = new XmlTextWriter(stringWriter); writer.Formatting = Formatting.Indented; writer.WriteStartDocument(); writer.WriteComment("Holiday Info"); writer.WriteStartElement("holidayInfo", ""); for (int groupIndex = 0; groupIndex < numberOfGroup; groupIndex++) { for (int religionIndex = 0; religionIndex < numberOfReligion; religionIndex++) { for (int jobStationIndex = 0; jobStationIndex < numberOfJobStation; jobStationIndex++) { writer.WriteStartElement("HOLIDAY", ""); writer.WriteAttributeString("intGroupID", chkGroupList.Items[groupIndex].Value.ToString()); writer.WriteAttributeString("intJobTypeId", "0"); writer.WriteAttributeString("intJobStationID", chkReligionList.Items[religionIndex].Value.ToString()); writer.WriteAttributeString("intHolidayID", ddlHolidayName.SelectedValue.ToString()); writer.WriteAttributeString("dtePermitedDate", DateTime.Now.ToShortDateString()); writer.WriteAttributeString("intReligionId", chkReligionList.Items[religionIndex].Value.ToString()); writer.WriteAttributeString("dteFromDate", txtFromDate.Text); writer.WriteAttributeString("dteToDate", txtToDate.Text); writer.WriteEndElement(); } } } stringWriter.GetStringBuilder().ToString(); return will be what if i want to sent this file to the store procedure parameter?; } finally { if (writer != null) writer.Close(); if (stringWriter != null) stringWriter.Close(); }\[/code\]return type will be what if i want to sent this file to the store procedure as xml parameter?This is my store Procedure\[code\]CREATE PROCEDURE [dbo].[sprHoliday_InsertHolidaysGroupPermission]@intUserID INT =NULL,@xmlHolidayPermissionDetails XML,@insertStatus AS VARCHAR(200) OUTASBEGINDECLARE @intEmployeeID intIF (@intUserID IS NOT NULL)BEGIN SELECT @intEmployeeID = intEmployeeID From dbo.tblUserInfo WHERE tblUserInfo.intUserID = @intUserID END BEGIN TRANSACTIONBEGIN TRY INSERT INTO dbo.tblEmployeeGroupPermissionHolidays (intGroupID, intJobTypeId, intJobStationID, intHolidayID, dtePermitedDate, intReligionId, dteFromDate, dteToDate) (SELECT xmlHolidayPermissionDetails.item.value('@intGroupID[1]', 'INT'), xmlHolidayPermissionDetails.item.value('@intJobTypeId[1]', 'INT'), xmlHolidayPermissionDetails.item.value('@intJobStationID[1]', 'INT'), xmlHolidayPermissionDetails.item.value('@intHolidayID[1]', 'INT'), xmlHolidayPermissionDetails.item.value('@dtePermitedDate[1]', 'DATE'), xmlHolidayPermissionDetails.item.value('@intReligionId[1]', 'INT'), xmlHolidayPermissionDetails.item.value('@dteFromDate[1]', 'DATE'), xmlHolidayPermissionDetails.item.value('@dteToDate[1]', 'DATE') FROM @xmlHolidayPermissionDetails.nodes('//HOLIDAY') AS xmlHolidayPermissionDetails(item) ) COMMIT INSERT INTO dbo.tblHRDataHistory values('Insert','Holiday Permission Data Insert','tblEmployeeGroupPermissionHolidays',GETDATE(),@intEmployeeID) SET @insertStatus = 'Holiday Permission has been iserted succesfully' END TRY BEGIN CATCH Rollback SELECT @insertStatus = 'There was an error! ' + ERROR_MESSAGE() END CATCH END\[/code\]