can u help me in inserting values to the table...
stored procedure and creating class in Asp.net c#
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...
sowmya gsPosted Mar 29, 2013, 10:06 AM
i want to use stored procedure to access database...actuall i dont know about stored procedure...
Jignesh TrivediPosted Mar 29, 2013, 9:27 AM
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 gsPosted Mar 29, 2013, 6:49 AM
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 TrivediPosted Mar 29, 2013, 3:54 AM
hi,
while using DatabaseFactory.CreateDatabase(), are you getting error to insert record? kindly share error details
or more code on which you got error.