Edit Grid Data - Excel Style - Essential Objects, Inc. Support Forum

Welcome Guest

Search | Active Topics | Sign In | Register

Essential Objects Product Support Forum » All Products » Support » Edit Grid Data - Excel Style

Edit Grid Data - Excel Style

Options

Previous Topic · Next Topic

quirtep

Posted: Tuesday, July 7, 2009 11:16:30 AM

Rank: Advanced Member
Groups: Member

Joined: 9/6/2007
Posts: 133

I am trying to implement your "Edit Grid Data - Excel Style" with my own data. I keep running into a problem where the focus event takes the cell into edit mode, but the existing value remains in the cell so that as I type, it shows both the old and new values on top of one another. If I mess with the number of columns displayed, I can make it go away, but I cannot for the life of me isolate a single field that is causing the trouble. Rather, it seems to work if I have only 4 or 5 fields displayed, but it doesn't seem to care which 4 or 5 fields they are.

Note that all I did was copy your sample over, and bind it to my dataset instead of yours.

I tested this with both Firefox and IE8, and it happens in both.

quirtep

Posted: Wednesday, July 8, 2009 7:20:05 AM

Rank: Advanced Member
Groups: Member

Joined: 9/6/2007
Posts: 133

I discovered that the issue I described does not happen with an older version of the EO.Web.dll (version 6.0.51.2).

However, with the new version (7.0.11.2) the issue does happen.

Thank you.

Edit: The issue also seems to happen with the most recent version (7.0.16.2)

eo_support

Posted: Wednesday, July 8, 2009 10:16:31 AM

Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194

Hi,

Please verify if you see the same problem in our sample app. If the sample runs fine, then it would be most likely to be your code because there is no reason when all you did was copying our sample code and it works in our samples but not in your app.

If you still believe it's a bug, please provide a test project that demonstrates the problem. We will look into it as soon as we have that.

Thanks!

quirtep

Posted: Wednesday, July 8, 2009 11:32:39 AM

Rank: Advanced Member
Groups: Member

Joined: 9/6/2007
Posts: 133

Here is a sample of what I am describing:

http://educatorsabroad.org/test.aspx

This is copied directly from your "Edit Grid Data - Excel Style" sample. The only changes that I made were to put it into a web form instead of a user control, minor configuration changes such as increasing the width, and my own code to fill the dataset (as follows):

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
string strSQL = "Select [ID],[TITLE],[LAST_NAME],[BADGE_NAME],[MIDDLE_NAME],[FIRST_NAME],[SIG_OTHER],[GENDER],[BIRTHDATE],[ORGANIZATION],[INSTITUTION],[LastUpdate],[LastUpdater],[LastLogon],[CONTACT_ADDRESS_1],[CONTACT_ADDRESS_2],[CONTACT_CITY],[CONTACT_STATE_PROVINCE],[CONTACT_ZIP_POSTAL],[CONTACT_COUNTRY],[OTHER_ADDRESS],[OTHER_CITY],[OTHER_STATE_PROVINCE],[OTHER_ZIP_POSTAL],[OTHER_COUNTRY],[OFFICE_PHONE],[HOME_PHONE],[MOBILE_PHONE],[FAX],[EMAIL],[SECONDARY_EMAIL],[THIRD_EMAIL],[WWW],[INFO_FROM],[RETURNED_EMAILS],[RETURNED_POSTAL_ADDRESS],[DATE_DUES_PAID],[NOTES] ,[VerifiedDues2006],[VerifiedDues2007],[VerifiedDues2008],[VerifiedDues2009],[VerifiedPresent2009],[ExpressedInterest] From TblISFTEPersonnel";
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(strSQL, conn);
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Members");
Grid1.DataSource = ds.Tables[0];
Grid1.DataBind();

Again, this is a completely isolated sample that is not using my style sheets, etc. It is currently within the directory of a larger project so that I could upload it to the server to show you, but I also tested it locally within a completely "from scratch" ASP.Net 3.5 Web Site as generated by VisualStudio.

eo_support

Posted: Wednesday, July 8, 2009 11:48:35 AM

Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194

Hi,

We need you to have a full test page/project that can run independently. You can try to put a test database online so that we can connect to your DB directly from here; Or you can convert your database to another format (for example, text file), and then change your test code accordingly to use that datasource. In any case, the bottom line is we need a project that we can load and run here in order to troubleshoot such problems.

There are a number of reasons we ask you to provide a test project. Among the most important reasons are that for issues like this, we will need to run and most likely to debug it in our environment; Also without a test project we can not verify whatever fix/workaround we come up does indeed work for you.

http://www.essentialobjects.com/forum/postst3013_I-run-into-a-problem-can-I-send-over-my-code-so-that-you-can-take-a-look.aspx

Thanks!

quirtep

Posted: Wednesday, July 8, 2009 1:06:26 PM

Rank: Advanced Member
Groups: Member

Joined: 9/6/2007
Posts: 133

OK - here is revised code to fill the dataset, including a connection string to a temporary SQL database I set up:

SqlConnection conn = new SqlConnection("Data Source=24.158.19.10;Initial Catalog=temp;User ID=temp;Password=temp;");
string strSQL = "Select [ID],[TITLE],[MIDDLE_NAME],[FIRST_NAME],[GENDER],[BIRTHDATE],[ORGANIZATION],[INSTITUTION],[LastUpdate],[LastUpdater],[LastLogon],[CONTACT_CITY],[CONTACT_STATE_PROVINCE],[CONTACT_ZIP_POSTAL],[CONTACT_COUNTRY],[OTHER_CITY],[OTHER_STATE_PROVINCE],[OTHER_ZIP_POSTAL],[OTHER_COUNTRY],[INFO_FROM],[RETURNED_EMAILS],[RETURNED_POSTAL_ADDRESS],[NOTES],[VerifiedDues2006],[VerifiedDues2007],[VerifiedDues2008],[VerifiedDues2009],[VerifiedPresent2009],[ExpressedInterest] From TblISFTEPersonnel";
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(strSQL, conn);
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Members");
Grid1.DataSource = ds.Tables[0];
Grid1.DataBind();

Here are what my columns look like:

This is running at:

http://educatorsabroad.org/test.aspx

If you would like me to send you my aspx and .cs files, let me know - but again, they are nearly identical to your sample.

Thank you.

eo_support

Posted: Wednesday, July 8, 2009 1:42:21 PM

Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194

Hi,

We are not able to connect to your DB server (we can ping it though). Please check your firewall settings.

Thanks

quirtep

Posted: Wednesday, July 8, 2009 1:58:28 PM

Rank: Advanced Member
Groups: Member

Joined: 9/6/2007
Posts: 133

Please provide your IP so that I can add an exception to the firewall.

eo_support

Posted: Wednesday, July 8, 2009 2:12:48 PM

Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194

Please see your private messages for our reply.

eo_support

Posted: Friday, July 10, 2009 11:32:10 AM

Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,194

Hi,

We have posted a new build that fixed this issue. Please see your private message for download location.

Thanks!

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Message