We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

TIMEOUT when try to save data from datagrid

Thread ID:

Created:

Platform:

Replies:

9325 Dec 13,2003 12:42 AM UTC WinForms 0
loading
Tags: FAQ
wisman
Asked On December 13, 2003 12:42 AM UTC

Hi, I have problem with my datagrid below is part of the script cmdUpd = cnSQL.CreateCommand cmdUpd.CommandText = "UPDATE sa_user_respon SET eff_date_from = @eff_date_from, " & _ "eff_date_to = @eff_date_to, " & _ "description = @description, " & _ "last_update_date = getdate(), " & _ "last_updated_by = @last_update_by " & _ "WHERE user_id = @user_id AND respon_id = @respon_id" prm = cmdUpd.Parameters.Add("@user_id", SqlDbType.SmallInt, 2, "user_id") prm = cmdUpd.Parameters.Add("@respon_id", SqlDbType.Int, 4, "respon_id") prm = cmdUpd.Parameters.Add("@eff_date_from", SqlDbType.SmallDateTime, 4, "eff_date_from") prm = cmdUpd.Parameters.Add("@eff_date_to", SqlDbType.SmallDateTime, 4, "eff_date_to") prm = cmdUpd.Parameters.Add("@description", SqlDbType.VarChar, 100, "description") prm = cmdUpd.Parameters.Add("@last_updated_by", SqlDbType.SmallInt, 2, "last_updated_by") prm.SourceVersion = DataRowVersion.Original daRespon.UpdateCommand = cmdUpd in save button i wrote --------------------------- Me.BindingContext(dtRespon).EndCurrentEdit() daRespon.Update(dtRespon) i debug and see the parameters it happen that parameter has the value, but when tried to save it''s said TIMEOUT, has anyone have any idea how to solve?

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;