User Profile

BiffMaGriff · Sep 15 '09, 07:49 PM

Ok I think I solved it... it just took 2 days...
I don't think my deletes were being committed to the DB. At some point I started getting the correct rows in .Net. I think this happened because I was not putting my OracleCommand object within a transaction... I hope.
Anyways to prevent this use this from happening again I am doing this.

Code:

        OracleCommand com = GetCommand(myCommand);
            com.Connection.Open();

...

BiffMaGriff · Sep 15 '09, 07:35 PM

My co-worker says it is a pain in the butt to get a result set returned from an oracle sp.

BiffMaGriff · Sep 15 '09, 07:35 PM

Ok, I think perhaps it might be a commit type issue.

BiffMaGriff · Sep 15 '09, 07:09 PM

Ok, the select * on my mapping table gives different row counts .Net than when in SQl Developer.

Could this be a garbage collection issue?

BiffMaGriff · Sep 15 '09, 06:04 PM

I had a look into the ungrouped data. In SQL Developer I'm getting 193 rows in .Net I'm getting 239 rows :(
Could this be a driver issue? It is like my join is all messed up.

BiffMaGriff · Sep 2 '09, 09:10 PM

Yeah but why would it work on some machines and not others :(

BiffMaGriff · Sep 2 '09, 07:18 PM

I changed
<ajaxToolkit:To olkitScriptMana ger ID="ToolkitScri ptManager1" runat="server"
AsyncPostBackTi meout="36000" />
to
<ajaxToolkit:To olkitScriptMana ger ID="ToolkitScri ptManager1" runat="server"
AsyncPostBackTi meout="600" />

and it all works....

whyyyyyyyyyyyyy yy?

BiffMaGriff · Sep 2 '09, 05:15 PM

try this

<img onclick="window .open('myurl'); " src="myimg" onmouseover="th is.style.cursor ='pointer';" />

BiffMaGriff · Jul 8 '09, 07:42 PM

OK, to solve this I added ModifiedBy and IsDeleted Columns to all my tables.
In my DAL I set it up so that ModifiedBy is automatically set to the user I want.
I also changed my DAL to implement soft deletes and then my DAL automatically performs a hard delete after every soft delete. A soft delete is merely an update where the IsDeleted field is set to 1.
In my trigger I changed the audit username value to the modifiedby field...

BiffMaGriff · Jun 27 '09, 07:07 PM

There is nothing in that website that is related to my question. Thanks for spamming my post dnanetwork.

BiffMaGriff · Jun 19 '09, 03:53 PM

Ok, to solve this I put

Code:

e.Row.Attributes.Add("onclick", ((GridView)sender).Page.ClientScript.GetPostBackEventReference((GridView)sender, "Select$" + e.Row.RowIndex.ToString(), false));

in my OnRowDataBound. I'm not sure why I didn't get the event validation error but whatever it works for now.

BiffMaGriff · May 22 '09, 02:37 PM

Hi, Thanks for the responses.
I solved it using your way sangham with an empty object added onto my object data source collection and then hiding it.

-Biff

BiffMaGriff · Apr 7 '09, 07:49 PM

Awesome Frinny! My 2nd subcontol works perfectly now. Thanks for your help :)

BiffMaGriff · Apr 6 '09, 08:21 PM

I load the values in the prerender for the repeater.

BiffMaGriff · Apr 6 '09, 07:26 PM

Hmm, it doesn't seem to want to work when I put it in there. I lose all my values again.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

OracleConnection not returning correct number of rows

Leave a comment:

Leave a comment:

Leave a comment:

Help! onchange only works if user uses arrows keys for a dropdownlist

Leave a comment:

Auditing with an Oracle back end?

Leave a comment:

Leave a comment:

GridView inside update panel, fun ensues.

Leave a comment:

GridView EmptyDataTemplate Disabling

Leave a comment:

Leave a comment:

Leave a comment: