Hi Patrick
Thanks for your quick reply, i m passing it as just parameter here is the code of my WS, its calling my stored procedure and inserting one record only which it is the first record in the repeating section in my InfoPath and stop, do i need to do loop here or do anything in InfoPath?
[WebMethod]
public bool UpdateHREducation(String EmplID, String Education, String Desc, DateTime StartDate, DateTime EndDate)
{
string strCommandText = "dbo.ALS_spUpdateHREducation";
using (SqlConnection conn = new
SqlConnection("server=10.0.11.47 ;database=DynamicsAX1;uid=info;pwd=info123456"))
{
SqlCommand cmd = new SqlCommand(strCommandText, conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramEmplID = new SqlParameter("@EMPLID", SqlDbType.NVarChar);
paramEmplID.Value = EmplID;
cmd.Parameters.Add(paramEmplID);
SqlParameter paramEdu = new SqlParameter("@Education", SqlDbType.NVarChar);
paramEdu.Value = Education;
cmd.Parameters.Add(paramEdu);
SqlParameter paramDesc = new SqlParameter("@Desc", SqlDbType.NVarChar);
paramDesc.Value = Desc;
cmd.Parameters.Add(paramDesc);
SqlParameter paramStartDate = new SqlParameter("@StartDate", SqlDbType.DateTime);
paramStartDate.Value = StartDate;
cmd.Parameters.Add(paramStartDate);
SqlParameter paramEndDate = new SqlParameter("@EndDate", SqlDbType.DateTime);
paramEndDate.Value = EndDate;
conn.Open();
int i = 0;
i = cmd.ExecuteNonQuery();
conn.Close();
if (i > 0)
{
return true;
}
else
{
return false;
}
}