weblion -11 Newbie Poster Banned

base class

public class supplier
    {
       
        public string suppid { get; set; }
        public string suppname { get; set; }
        public string dispname { get; set; }


    }

method for binding data in gridview using a list

List<arun> ss = new List<arun>();

            string connectionString = @"Server=AKBT-TM\SQL2008;Database=us;User ID=sa;Password=turner;";
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                using (SqlCommand cmd = new SqlCommand("dbo.aruns"))
                {
                   
                    cmd.CommandType = CommandType.StoredProcedure;
                    conn.Open();
                    cmd.Connection = conn;

                    using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
                    {
                        while (rdr.Read())
                        {
                            arun n = new arun { suppid = rdr.GetString(0), suppname = rdr.GetString(1), dispname = rdr.GetString(2) };

                            ss.Add(n);
                        }

                        rdr.Close();
                    }
                }
            }

            GridView1.DataSource = ss;
            GridView1.DataBind();
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.