https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17278.aspxWed, 17 May 2006 14:21:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17278Abhishek0https://www.infopathdev.com:443/forums/thread/17278.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17278Hi Saba,<br /><br />U need to write code to implement this.<br /><br />Write a query in a webservice to find out whether the "From Time" and "To Time" in ur InfoPath form conflicts with the "From Time" and "To Time" entered in the database for a particular room on that particular date.<br />If there is no conflict,then insert a new row into the database.<br /><br />U can implement this on a single call to a web service.<br /><br />Regards,<br />Abhishek<br />https://www.infopathdev.com:443/forums/thread/16808.aspxWed, 17 May 2006 08:06:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16808saba0https://www.infopathdev.com:443/forums/thread/16808.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16808I want submit my forms data to the sql database but before submission ,the values of the fields must be checked with values in database….in other words imagine a room reservation form, before form is submitted to the database it should be investigated that this room in requested time has been reserved before or not if yes showing a message and do not insert a new row into the database…how can I do that ..what is the solution for checking with database fields and then submit the forms?<br /><br />