DataTable _dt = new DataTable();
DataColumn col1 = new DataColumn("fkEmployeeid");
col1.DataType = System.Type.GetType("System.String");
_dt.Columns.Add(col1);
if (sel_list.Items.Count > 0)
{
for (int i = 1; i < sel_list.Items.Count; i++)
{
_dt.Rows.Add(sel_list.Items[i].Value);
}
}
public static string GetXMLOfDataTable(DataTable dtToProcess)
{
string strOutput = "";
try
{
dtToProcess.TableName = "Table";
StringWriter sw = new StringWriter();
dtToProcess.WriteXml(sw);
strOutput = sw.ToString();
}
catch (Exception ex)
{
}
return strOutput;
}
ED.strxmlData1 = GetXMLOfDataTable(_dt);
@xmlLanguage2 xml,
IF (@xmlLanguage2 IS NOT NULL)
begin
SELECT ISNULL(cast(Colx.query('data(fkEmployeeid)') as varchar(max)),'0') as fkEmployeeid
INTO #TMPLanguage1 FROM @xmlLanguage2.nodes('DocumentElement/Table') AS Tabx(Colx)
insert into tb_tab_OthereEmployeeInvoled(
Employeeid,
EmployeeReportId
)
select fkEmployeeid,@RID from #TMPLanguage1
end
DataColumn col1 = new DataColumn("fkEmployeeid");
col1.DataType = System.Type.GetType("System.String");
_dt.Columns.Add(col1);
if (sel_list.Items.Count > 0)
{
for (int i = 1; i < sel_list.Items.Count; i++)
{
_dt.Rows.Add(sel_list.Items[i].Value);
}
}
public static string GetXMLOfDataTable(DataTable dtToProcess)
{
string strOutput = "";
try
{
dtToProcess.TableName = "Table";
StringWriter sw = new StringWriter();
dtToProcess.WriteXml(sw);
strOutput = sw.ToString();
}
catch (Exception ex)
{
}
return strOutput;
}
ED.strxmlData1 = GetXMLOfDataTable(_dt);
@xmlLanguage2 xml,
IF (@xmlLanguage2 IS NOT NULL)
begin
SELECT ISNULL(cast(Colx.query('data(fkEmployeeid)') as varchar(max)),'0') as fkEmployeeid
INTO #TMPLanguage1 FROM @xmlLanguage2.nodes('DocumentElement/Table') AS Tabx(Colx)
insert into tb_tab_OthereEmployeeInvoled(
Employeeid,
EmployeeReportId
)
select fkEmployeeid,@RID from #TMPLanguage1
end