See the screen shot below: Hi Vinz, mabuhay, and thank you for your blog! Assuming that I'm creating an "insert" form similar to the one at the top, but with one of the values required being a foreign key to the table, it would be better to use a drop-down list for the FK. Collin Nunis Hello This blog is so much helpful for me but one thing that i want to know is that if i take "postalcode" datatype to "int" in database then how can i convert this textbox value to int??? Text); Also i want to know the datetime conversion! thanks for tutorial, it really help me, so what about editing data with linq to sql??I would like to know how to code the drop-down list as I keep getting errors. I tried something like this but it is not working:cust. and if there a null value, have a message that the field of..null, please insert,,and if the data is duplicate ex custumer id, have a message could not a duplicate data,,i need your help..thank you...^___^ @mohsin, When converting string to int or datetime type then make sure that the value to be converted has a vaild datetime or int value or else it will fail. Insert On Submit(cust); In the above line of code from where do u get the Insert On Submit(); function????There is also a "hybrid" known as "Precompiled Web Sites" (see the link for the official MSDN overview) where you don't have the single DLL layout of a web application, but all the compile work of the website is done for you.
As an overview, LINQ to SQL is a technology that allow you to query sql server.Web Sites typically have all of the aspx and vb files published to the live server and ASPNET Worker Process recompiles the app every time before presentation.On the other end is the web application, where all of your code behind files get compiled down to a single DLL file and you simply deploy your aspx pages and you bin folder with the DLL file to production.Having an updated version of the DLL file causes a break since the precompilation wants a name and a version of the file.If possible, your best bet would be to convert to a web application, since you can add the additional DLLs into production without a problem. [email protected] I have tried everything and I simply do not have a "Convert to Web Application" option.