Inserting Data into SQL from .Net Web Form

[kav123]

I am a newbie to ASP.Net. I have created a web form and have created a VB class which inserts data filled in the form using a Stored Procedure into SQL Express. I am using an Array to pass the values filled in the form to the function in VB Class. But i am having loads of problems with the Array. I am getting CastConversionError and what not?? Can anyone tell me any other way of doing this.

 

[ca8msm]

Why use an array anyway? I'd create a Public Property for each database value that you want to read/write.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[kav123]

That's a good idea. That's what i am here for. I ended up thinking that arrays are not easy. But i am not sure how to approach this thing. I am trying to create a VB class which will have all the functions to do everything with the database for all the pages in the applications. That would mean a lot of Property values wouldnt it.??

 

[ca8msm]

I wouldn't mix database access with entities. Instead, have a database access layer and have functions within it that accept the relevant class and add their properties to a parameter.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[culshaja]

You could cheat and use a typed dataset. If you are using VS2005 then the IDe will do most (if not all) of the work creating methods and classes for you.

BTW, I'm not advocating this as the best method, just an easy option to do what is being talked about in this post.

James

James Culshaw