开发者

Update data table on ASMX Service side

开发者 https://www.devze.com 2022-12-23 19:12 出处:网络
I need advice. On 开发者_StackOverflow中文版Web Service side a I hav this method : public DataSet GetDs(string id)

I need advice. On 开发者_StackOverflow中文版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.


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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号