convert DATATABLE or dataset data to arraylist using asp.net

public ArrayList ConvertDatasettoArrayList()

{

DataSet ds = new DataSet();

// List<UserDetails> details = new List<UserDetails>();

ArrayList list=new ArrayList();

using (SqlConnection con = new SqlConnection("Data Source=vivasample;Initial Catalog=MySampleDB;Integrated Security=true"))

{

using (SqlCommand cmd = new SqlCommand("select TOP 10 UserId,UserName,Location from UserInformation", con))

{

con.Open();

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds);

foreach (DataRow dtrow in ds.Tables[0].Rows)

{

list.Add(dtrow);

}

}

}

return list;

}

/// <summary>

/// This method is used to convert datatable to arraylist

/// </summary>

/// <returns></returns>

public ArrayList ConvertDataTabletoArrayList()

{

DataTable dt = new DataTable();

// List<UserDetails> details = new List<UserDetails>();

ArrayList list = new ArrayList();

using (SqlConnection con = new SqlConnection("Data Source=vivasample;Initial Catalog=MySampleDB;Integrated Security=true"))

{

using (SqlCommand cmd = new SqlCommand("select TOP 10 UserId,UserName,Location from UserInformation", con))

{

con.Open();

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);

foreach (DataRow dtrow in dt.Rows)

{

list.Add(dtrow);

}

}

}

return list;

}

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email