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();