Getting data in dataGridView

The problem is getting the data in my dataGridView from my web service. When I call the getList method from webservice, I get the correct xml code. This is my code: web service:

[WebMethod]
    public DataSet getList()
    {
        SqlConnection connection = new SqlConnection();
        connection.ConnectionString = "server=localhost;" +
                                   "Trusted_Connection=yes;" +
                                   "database=oving1; " +
                                   "connection timeout=30";
        string select = "select * from Person";
        SqlDataAdapter da = new SqlDataAdapter(select, connection);
        DataSet ds = new DataSet();

        da.Fill(ds, "Person");
        return (ds);
    }

the form:

    private void button1_Click(object sender, EventArgs e)
    {

        Service1 webService = new Service1();
        DataSet ds = webService.getList();
        dataGridView1.DataSource = ds;


    }
+3
source share
1 answer

Better Check It Out Avoid DataSet in Web Services

Serializing a Dataset via WebServices Using a DataSet with an XML Web Service

One more thing, try to provide data for the grid, not a dataset:

dataGridView1.DataSource = ds.Tables[0];
+3
source

All Articles