InfoPath Dev

 I just need an Auto number created in my InfoPath form which then can be submitted into SQL. I do not have any repeating table.Can someone help me?  

UnbelievableIt is working fine now. I really appreciate your help.Thanks everyoneKajal  

Hey Thanks! I did everything you asked me to do but I am still having some problems. When I click on my button I am getting an error message saying some rules were not applied Details: InfoPath cannot submit the form. An error occurred while the form was being submitted. The following location does not use the HTTP or HTTPS protocol: ...

Thanks to you both for your reply I know how to create the data connection to submit the data but I want to submit the data in both SQL and SharePoint library at the same time. Is this possible?  

Is it possible to submit data into both SQL and SharePoint document library?