Comments by spankyleo123

spankyleo123 8-Jul-15 6:13am View

Deleted

Any suggestions anyone?

spankyleo123 19-Jun-15 7:16am View

Hi thanks for your response.I have attempted your suggestion but unfortunately if the where clause is outside the group it does not fetch any rows in this case.

spankyleo123 2-Jun-15 8:34am View

Hi yes you are right, I had to change that as well. Thanks

spankyleo123 29-May-15 10:51am View

Many thanks, i've got it to work now.

spankyleo123 29-May-15 9:22am View

I'd prefer option 2 above although it may have performance drawbacks, but please can you let me know how to perform the join in client-side ? Thanks

spankyleo123 29-May-15 9:20am View

Hi ML, as per my understanding the issue lies in these lines

 Join p In progs On p.P_Id Equals sp.P_Id
                    Join u In users On u.S_ID Equals s.S_ID
                    Join uri In userRoleIn On uri.U_ID Equals u.U_Id
                    Where uri.P_Id.HasValue.Equals(15)
                    Where uri.Role_Id = 13

When i remove any references to users, userRoles and programmes I get no errors.

spankyleo123 29-May-15 7:27am View

Hi thanks for your reply, when i use _dctx.Programmes in the query it gives me the error
Additional information: The specified LINQ expression contains references to queries that are associated with different contexts.

spankyleo123 29-May-15 5:37am View

It doesnt say which line ...but the whole query is highlighted in green with a dialog box giving the details of the error.

error in Dim query = (From swt In _ctx.Workflows

spankyleo123 23-Jan-14 4:55am View

Hi thanks bro,

This is definitely achievable using jquery UI, but I am using Bootstrap to design the UI, adding jquery UI would be like adding another dependency. I was hoping if a similar functionality is achievable using bootstrap?

spankyleo123 26-Apr-13 8:07am View

Hi, thanks for your response

heres the CSS that I'm using.

<pre lang="CSS">

input[type=text], input[type=password], input.text, input.title, textarea, select
{
font-family: Arial, Helvetica, sans-serif;
font-size: 0.9em;
border-style: inset;
border-width: thin;
vertical-align: middle;
}
select
{
padding: 5px;
}
</pre>

spankyleo123 8-Mar-13 11:21am View

no luck bro.

spankyleo123 8-Mar-13 9:34am View

Thanks, I have tried putting in semi colons but still didnt work.

spankyleo123 8-Mar-13 9:33am View

Thanks I have added the meta tag. In my case IE in quirks mode executed the above jquery perfectly, but in IE9 Standard its doest work. I have stepped through the debugger and when it gets out of the loop. this line returns max=0, wonder why that is.?
<pre lang="Javascript">
$(this).find('label').width(max);
</pre>

spankyleo123 8-Mar-13 8:29am View

Thanks will try that.

spankyleo123 8-Mar-13 8:21am View

Your no good anyway.

spankyleo123 1-Mar-13 4:44am View

Deleted

Are you just an advisor here or someone who helps with queries?

spankyleo123 28-Feb-13 12:05pm View

Deleted

@Sandeep Mewara

This is my grid set up

<asp:gridview id="GridView1" runat="server" datasourceid="EntityDataSource1" xmlns:asp="#unknown">
DataKeyNames="Person_ID">
<columns> <asp:boundfield datafield="Person_ID" headertext="ID" readonly="True">
Visible="false" />
<asp:boundfield datafield="Forename" headertext="Forename" readonly="True">
/>
<asp:boundfield datafield="Surname" headertext="Surname" readonly="True">
SortExpression="Surname" />
<asp:boundfield datafield="EmailAddress" headertext="Email Address" readonly="True">
SortExpression="EmailAddress" />
<asp:templatefield insertvisible="False" showheader="False">
<itemtemplate>
<asp:linkbutton id="lbName" commandargument="<%# Eval("Person_ID") %>" text="Edit">
OnClientClick="showDialog('editPerson');" runat="server" />

And this is the div with the fields.

<div id="editPerson">
<asp:updatepanel id="upEditUpdatePanel" updatemode="Conditional" childrenastriggers="true" xmlns:asp="#unknown">
runat="server">
<contenttemplate>
<asp:textbox id="txtEditId" visible="false" runat="server">
<label class="label-class">
Forename:</label>
<asp:textbox id="Text1" runat="server" />
<br />
<label class="label-class">
Surname:</label>
<asp:textbox id="Text2" runat="server" />
<br />
<label class="label-class">
Email:</label>
<asp:textbox id="Text3" runat="server" />

</div>

and this is the script to show the dialog

$(document).ready(function() {
//setup new person dialog
$('#newPerson').dialog({
autoOpen: false,
draggable: true,
title: "Add New Person",
open: function(type, data) {
$(this).parent().appendTo("form");
}
});

//setup edit person dialog
$('#editPerson').dialog({
autoOpen: false,
draggable: true,
title: "Edit Person",
open: function(type, data) {
$(this).parent().appendTo("form");
}
});
});

function showDialog(id) {
$('#' + id).dialog("open");
}

function closeDialog(id) {
$('#' + id).dialog("close");
}

It brings up the dialog but has no data in it.

spankyleo123 7-Feb-13 11:55am View

Had to delete coz of lack of feebback. Thanks

spankyleo123 29-Jan-13 12:00pm View

Thanks I'll give it a try.

spankyleo123 29-Jan-13 12:00pm View

Thanks

spankyleo123 29-Jan-13 11:59am View

Hi thanks for your reply. I will give it a try.

However by examples I meant..code examples.

Thanks again for your reply.

spankyleo123 14-Jan-13 9:15am View

Hi many thanks for your answer. The blog is really helpful and informative.

However in my case. I have more than 2 tables joined to the parent table. The DOB field in your example is repeating depending on the number of 'Dependants'.

What I wanted is .

Emp Name : Anil

DOB
01-01-1980

DependandName DependandAge
Sam 18
John 7

Emp Name : Ajay

DOB

DependantName Age

Wondering if this is possible rather than 'repeating DOB each time there is a dependant'

Thanks

spankyleo123 9-Jan-13 4:39am View

Thanks.. Do I just have to include the itemDataBinding event and call

Page.DataBind()

from within it?

spankyleo123 22-Nov-12 9:33am View

how?

spankyleo123 22-Nov-12 9:10am View

Deleted

If i remove <pre><sitemapnode url="" roles="*"> <\pre> from the sitemap...i get an error. it says that the items should be within the sitemap node.

Comments by spankyleo123 (Top 25 by date)