What object in ASP.net should I use to insert multiple records
Posted on 2010-09-05
I want to create a ASP.ney website that will be used as a form for users to input batch files with customer numbers and transactions and amounts.. The users need to be able to paste in 100 customer numbers, transactions and amounts into the form, click a submit button and then be alerted if any of the numbers are invalid.. The info goes into a SQL Server 2008 database table.. So basically they are entering records into a table via a website.. What is the best object to use to do this? Can a datagrid except multiple records? Also, how should I go about alerting the user if the data is not good? For example, if they try to enter a customer and that customer does not exist.... I am a SQL developer for a large Co.. I have ASP.net and we will use it on our intranet site.. I have done a few simple web pages with SQL attached but I'm not sure the best way to tackle this one..