how to exeute stored procedure with partmeter in asp.net 1.1(

Following are the stored procedure that will get transaction data from database
and fill it in to the sql adapter and data set. it has four parameter.


SqlAdpt=new SqlDataAdapter("sp_getTransactionData",this.Con);

SqlAdpt.SelectCommand.CommandType=
System.Data. CommandType.StoredProcedure;

SqlAdpt.SelectCommand.Parameters.Add(new SqlParameter("@boid",System.Data.SqlDbType.NVarChar,16) );

SqlAdpt.SelectCommand.Parameters["@boid"].Value=
boid.Trim().ToString();

SqlAdpt.SelectCommand.Parameters.Add(new SqlParameter("@firstdate",System.Data.SqlDbType.SmallDateTime,4));

SqlAdpt.SelectCommand.Parameters["@firstdate"].Value=
firstdate.Trim().ToString();

SqlAdpt.SelectCommand.Parameters.Add(new SqlParameter("@lastdate",System.Data.SqlDbType.SmallDateTime,4));

SqlAdpt.SelectCommand.Parameters["@lastdate"].Value=
lastdate.Trim().ToString();

SqlAdpt.Fill(dt,table);

SqlApdt=SQL Data Adpater
dt=Sql Dataset

Happy Programming

Comments

  1. get some more interview questions on asp.net here:

    http://www.interviewhelper.org

    ReplyDelete

Post a Comment

Your feedback is very important to me. Please provide your feedback via putting comments.

Popular posts from this blog

How to create Rest API(Web API) with ASP.NET Core 1.0

Creating PDF with ASP.Net MVC and RazorPDF

Solution: gulp is not recognized as internal or external command- Visual Studio