Having Trouble with DataBinding Thru WebService

.NET
1

Hi guys, I’m having trouble in binding data thru webservice. In my code, I created a dataset

public DataSet ViewMembers

but when I run my code, I got an error like

Error 2 Argument ‘1’: cannot convert from ‘MySql.Data.MySqlClient.MySqlDataAdapter’ to ‘System.Data.DataSet’ D:\ASPFILES\prms\App_Code\acWebService.cs 124 28 D:\ASPFILES\prms\

Can anyone help me.

2

Can we see some code? As it seems you are trying to cast a MySqlDataAdapter to a DataSet.

3

Here’s my code


[WebMethod]
    public DataSet ViewMembers()
    {
        MySqlConnection cnDBConnection = new MySqlConnection();
        
        cnDBConnection.ConnectionString = clsFunction.strConnection;
        String strSQL = "SELECT...";
        
        MySqlDataAdapter daRequestList = new MySqlDataAdapter(strSQL, cnDBConnection);
        DataSet dsRequestList = new DataSet();
        daRequestList.Fill(daRequestList,"RequestList");
        return dsRequestList;      
    }
4

I’m very sorry but I just notice this line

 daRequestList.Fill(daRequestList,"RequestList");

I change it to

daRequestList.Fill(dsRequestList,"RequestList");

Thank God