weblion -11 Newbie Poster Banned

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;
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.