Binding WCF result (List<>) to GridView

Question

User140495362 posted

Hi i have created a service to display oracle table data into gridview in asp page. The service is working perfectly and returning a List<> which contains table data. But on the front-end( asp page) i am unable to bind the list which i am returning through service to GridView. Below is the code of the service.

public List<Employee> getEmployees()

        {

List<Employee> employees = new List<Employee>();

string cs = "DATA SOURCE=172.25.4.115;PERSIST SECURITY INFO=True;USER ID=SAMPLEPROJECT;Password=SampleProject";

OracleConnection conn = new OracleConnection();

            conn.ConnectionString = cs;

            conn.Open();

OracleCommand cmd = new OracleCommand();

            cmd.Connection = conn;

string stmt = "SELECT * FROM MyEmployees";

            cmd.CommandText = stmt;

OracleDataReader reader = cmd.ExecuteReader();      

while (reader.Read())

            {

Employee employee = new Employee();

                employee.EmployeeId =

Convert.ToInt32(reader["EMP_ID"]);

                employee.FirstName =

Convert.ToString(reader["FIRST_NAME"]);

                employee.LastName =

Convert.ToString(reader["LAST_NAME"]);            

                employees.Add(employee);

     }

return employees.ToList();

        }

Above is the service which is returning a List.. Now how can i bind the method with GridView ???

Answer 1

User346117707 posted
You can directly bind a list with grid view

For example you are having the gridview with name "Gridview1" means you can bind like below

Gridview1.DataSource = getEmployees();
Gridview1.DataBind();

you can create the custom column/ autogenerate columns in your gridview.

For more
http://stackoverflow.com/questions/17148583/asp-net-bind-a-list-to-a-gridview
http://forums.asp.net/t/1109165.aspx

Answer 2

User-211766943 posted

Create refrence for service by adding service reference. Create intsnace of refrence you will find your getEmployees() method in that call it and bind output to gridview.

Answer 3

User346117707 posted

Go to your web application.

1.Add Service reference -> Give your service url -> click "Go" -> IF there is no error then your service added into your application -> you can give service name ex(Service1)
2.Create the object of your service in the aspx.cs page (service1."YourClassName" obj = new service1."YourClassName"() ) Example (service1.EmployeesClass = new service1.EmployeesClass())
3.Call your method like -> var employeeList = obj.getEmployees();
4.Gridview1.DataSource = getEmployees(); -> Gridview1.DataBind();

For More

http://msdn.microsoft.com/en-us/library/bb628652.aspx

Answer 4

User140495362 posted

Thanks but when i am using below code it gives error as it says the first field "EMP_ID"(Column name of oracle table) which i have assigned to gridview column1 with DataField property is not found or unknown.

Gridview1.DataSource = getEmployees();

 Gridview1.DataBind();

 

And when i remove DataBind() statement it displays blank page.

Answer 5

User346117707 posted

You should give the Gridview1.DataBind(); property this is only bind your datasource with gridview. 

You said you are getting error. Can you post your code. both gridview and bind...

Answer 6

User-211766943 posted

Use data property EmployeeId  instead of EMP_ID

Answer 7

User140495362 posted

This is the code of asp page -

protected void Page_Load(object sender, EventArgs e)

        {

            DBReference.GetDataClient obj = new DBReference.GetDataClient();

var mylist = obj.getEmployees();

            GridView1.DataSource = mylist;  or    GridView1.DataSource = obj.getEmployees();

            GridView1.DataBind();

        }

and below is the source Code of asp page -

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">

<Columns>

<asp:BoundField HeaderText="Employee Id" DataField="EMP_ID"/>   

<asp:BoundField HeaderText="First Name" DataField="FIRST_NAME"/>

<asp:BoundField HeaderText="Last name" DataField="LAST_NAME"/>

</Columns>      

</asp:GridView>

Where, EMP_ID, FIRST_NAME, LAST_NAME are column names of oracle table

Answer 8

User-211766943 posted

FirstName for FIRST_NAME and LastName  for LAST_NAME 

Answer 9

User-211766943 posted

Set Datafield as EmployeeId 

Answer 10

User-211766943 posted

try this 

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
            <Columns>
                <asp:BoundField HeaderText="Employee Id" DataField="EmployeeId" />
                <asp:BoundField HeaderText="First Name" DataField="FirstName " />
                <asp:BoundField HeaderText="Last name" DataField="LastName" />
            </Columns>
        </asp:GridView>

Answer 11

User140495362 posted

Thanks Shridhar Sir.. i replaced column names with Properties.. Now data is getting displayed.. :)

Thanks everyone..