Loading data to datatable
helloWhen I load data from datareader to datatable,the duplicate Id rows are not loading I need to load all rows.Please help me.
public DataTable GetDataTable()
{
DataTable dataTable = new DataTable();
using (SqlConnection conn = new SqlConnection("ConnectionString"))
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "procedure_name";
cmd.CommandType = CommandType.StoredProcedure;
if (conn.State != ConnectionState.Open)
conn.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
dataTable.Load(dr);
}
return dataTable;
}
conn = new SqlConnection(connString);
string query = "SELECT * FROM Customers";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DataTable dt = new DataTable();
dt.Load(dr);