Update data table on ASMX Service side

Question

Hi, I need advice. On Web Service side a I hav this method :

    public DataSet GetDs(string id)
    {
        SqlConnection conn = null;
        SqlDataAdapter da = null;
        DataSet ds;
        try
        {

            string sql = "SELECT * FROM Tab1";

            string connStr = WebConfigurationManager.ConnectionStrings["Employees"].ConnectionString;

            conn = new SqlConnection(connStr);
            conn.Open();

            da = new SqlDataAdapter(sql, conn);

            ds = new DataSet();
            da.Fill(ds, "Tab1");

            return ds;
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (conn != null)
                conn.Close();
            if (da != null)
                da.Dispose();
        }
    }

It return dataset to client app. I client application is dataset binding in datagridview. Client can insert,update,delete row from table. If client finish his work, I want accept change in data table on web service side.

I can sent clients all dataset na update table on web service side, but I want sent only changed data. Any advice? Thank u.

Answer 1

You can use DataSet.GetChanges() method to retrieve a copy of the DataSet containing only changes made since last time AcceptChanges() was called.