Hello
In the Code below, How do you implement DataPack?
In the Code below, dataPack = new DataPack(); and dataPack.ToOracleParameters(strQuery); <===============How do you implement DataPack and ToOracleParameters? Is there any sample code similar to this?
In the Code below, How do you implement DataPack?
In the Code below, dataPack = new DataPack(); and dataPack.ToOracleParameters(strQuery); <===============How do you implement DataPack and ToOracleParameters? Is there any sample code similar to this?
C#:
strQuery = @"
MERGE INTO Q_WARRANTY A USING DUAL ON (NW_CD=:NW_CD AND TRIM(NAME)=:NAME AND ITEMCODE=:ITEMCODE AND PRO= :PRO)
WHEN NOT MATCHED THEN
INSERT (NW_CD, NAME, ITEMCODE, PRO)VALUES(:NW_CD, :NAME, :ITEMCODE, :PRO)";
for (int i = 0; i < dtNwList.Rows.Count; i++)
{
string strNW_CD = dtNwList.Rows[i]["NW_CD"].ToString();
for (int j = 0; j < dtWarrnaty.Rows.Count; j++)
{
dataPack = new DataPack();
dataPack.AddProperty("NW_CD", typeof(string), strNW_CD);
dataPack.AddProperty("NAME", typeof(string), strNW_CD);
dataPack.AddProperty("ITEMCODE", typeof(string), dtWarrnaty.Rows[j]["ITEMCODE"].ToString());
dataPack.AddProperty("PRO", typeof(string), dtWarrnaty.Rows[j]["PRODUCT_CD"].ToString());
_agent.ExecuteNonQuery(strQuery, dataPack.ToOracleParameters(strQuery));
}
}
Last edited: