stored procedure
ALTER PROCEDURE [dbo].[arun]
AS
BEGIN
select 'live the code'
END
using the sqldatareader
string firstName="";
string connectionString =
@"Server=AKBT-TM;Database=masterregister;User ID=sa;Password=turner;";
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("dbo.arun"))
{
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("@LastName", "Alexander"));
conn.Open();
cmd.Connection = conn;
using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (rdr.Read())
{
// int contactID = rdr.GetInt32(rdr.GetOrdinal("ContactID"));
firstName = rdr.GetString(0);
//Response.Write(firstName + " (" + contactID.ToString() + ")");
}
rdr.Close();
}
}
}
return firstName;