stored procedure and creating class in Asp.net c#

Question

i have created 1 stored procedure and created 1 folder and in that created cs class file, class name is same as table name, in the class function called insert is used in that Created a database object called Database db = DatabaseFactory.CreateDatabase(); ,now i have problem in inserting values to the table...

can u help me in inserting values to the table...

sowmya gs · Answer

By using 3 application layer i.e UI layerBussiness logic layerdata access layer.. i want to use stored procedure to access database...actuall i dont know about stored procedure...

Jignesh Trivedi · Answer

hi are you use which technology for Database access? ado.net or entity framework? to create and call store procedure from C# please refer below link http://www.codeproject.com/Articles/15403/Calling-Stored-procedures-in-ADO-NET http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx this will help you.

sowmya gs · Answer

hai.. actually i'm not getting any error..i think code i wrote that is not correct..and i'm not clear in creating stored procedure...can u tel me step to create a stored procedure..and how this stored procedure will link to the class file how to write in class... i will attach 1 file in that stored procedure code and .aspx.cs file and Class file(.cs) file is der can u tel me where i'm wrong...help me in inserting value to database... thanks

Jignesh Trivedi · Answer

hi while using DatabaseFactory.CreateDatabase() are you getting error to insert record? kindly share error details or more code on which you got error.