We have an ASP.NET web service that invokes a stored procedure on our DB (Oracle 11g). The problem is that the call to the procedure blows up every time an empty. We will create a Table and Stored Procedure in Sql Server 2008R2 and data will be inserted and retrieved by using Asp.net using C ; Author: Prakash Lekhak. Hi I am trying to pass a Null value as a parameter to my stored procedure. But Its not working.this is my code. Could you just let me know the error or idea on. How to dynamically page through a large result set in ASP.NET by using SQL Server stored procedures in Visual C .NET This article helps you to create a stored procedure on SQL Server and tells you how to use them in your asp.net applications. Here Mudassar Ahmed Khan has explained how to perform select, insert, edit, update, delete in GridView using a single Stored Procedure in ASP.Net using C and VB.Net. My application is asp.net with vb. In my page I have a textbox for passing date. If I didn't enter date and on clicking submit, I have to pass null value to the. EF 4.0 The selected stored procedure returns no columns, when i try to import my stored procedure inside my asp.net mvc [Answered] RSS Asp.net GridView Crud Operations (Insert Select Edit Update Delete) using Single Stored Procedure Example please give steps to create and call stored proc in asp.net c. instead of hard coding the sql Query I want to use stored proc to insert, Update, Delete record on.