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 layer,Bussiness logic layer,data 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.

stored procedure and creating class in Asp.net c#

Answers (4)