Re: Update Databse with InfoPath Repeating Table

tallfiji — Fri, 03 Apr 2009 14:09:42 GMT

So this will work with more than one Service Area? What do you mean "and execute then ncommand for both tables"? Wouldn't I have to iterate through the relationship table? If I do need to itereate, how do I pass the table in and then itereate through it? Some example code would be extremely helpful.

Re: Update Databse with InfoPath Repeating Table

madhuri — Fri, 03 Apr 2009 07:04:04 GMT

I think you can write another Command text for updating the Service Area table and pass the RequirementID as ServiceRequirmentID and execute then ncommand for both tables.

Update Databse with InfoPath Repeating Table

tallfiji — Thu, 02 Apr 2009 20:06:38 GMT

I need to have an infopath form update a SQL server database with information using a web service. I have already been able to create the form to update the table known as Requirements. I, however, have an associated table called ServiceArea_Requirements that is a relationship between Requirements and Service Areas that also needs to be updated. Can someone help me understand how to update the Service Area to Requirement table from the InfoPath repeating table? The Web Service Code I have built to date is below. This will update the Requirement information. I'm not sure how to do the relationships though. I've also attached a screen shot of what the form looks like right now.

Code:

[WebMethod]
        public bool UpdateRequirement(int RequirementID, string RequirementName, string Description, int Category, int Type)
        {
            try
            {
                ConnectionStringSettings cs = ConfigurationManager.ConnectionStrings["dbConnection"];
                DbProviderFactory pf = DbProviderFactories.GetFactory(cs.ProviderName);
                using (DbConnection c = pf.CreateConnection())
                {
                    
                    c.ConnectionString = cs.ConnectionString;
                    DbCommand cmd = c.CreateCommand();
                    cmd.CommandType = CommandType.Text;
 
                    cmd.CommandText = "uspUpdate_Requirement " + " '" + RequirementName + "' " + ", " + RequirementID + ", " + " '" + Description + "' " + ", " + Category + ", " + Type;
                    c.Open();
                    int recordsAffected = cmd.ExecuteNonQuery();
                }
            }
            catch (Exception)
            {
                
                return false;
            }
           
            return true;
        }

Browser Forms

Re: Update Databse with InfoPath Repeating Table

Re: Update Databse with InfoPath Repeating Table

Update Databse with InfoPath Repeating Table