Tuesday, 29 November 2016

Arry Data DataTable Data Xml data insert into Database

 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

No comments:

Post a Comment