You searched for the word(s): userid:304361

More Search Options

RSS Available

• Re: How to fix the position of controls, so table expands into whitespace and doesn't push lower controls down (invoice report in SSRS 2005)

  Thanks for that. I found a similar solution using rectangles here: SQL Server 2005: Report Design Best Practices and Guidelines Here's the relevant part (see underlining): Using Rectangles to Keep Objects Together Rectangles in Reporting Services can be used either as graphical elements or as containers of objects. As object containers, they keep objects together on a page and control how object move and push each other. To keep multiple objects together on a page, put the objects within a rectangle

  Posted to SQL Server Reporting Services (Forum) by lneville on 11/4/2009

• How to fix the position of controls, so table expands into whitespace and doesn't push lower controls down (invoice report in SSRS 2005)

  I am designing an invoice report. There are some controls at the top of the report (company logo, date, invoice number etc), followed by a table listing the items in the invoice, followed by some controls at the bottom (subtotals, returns address etc). The report should always print onto a single page. I want the controls at the bottom to have a fixed position on the page. There is sufficient whitespace between these controls and the table above for the table to expand to list many items. However

  Posted to SQL Server Reporting Services (Forum) by lneville on 11/3/2009

• Re: Can you pre-load related tables (in ContextCreated of LinqDataSource) when Selecting calls a method based on a SQL Table Valued Function?

  I am just curious why you keep suggesting to use stored procedures, because I don't think that will work. I do understand that I can include multiple queries inside the stored procedure. However what I want to do is create something (stored procedure, function, view, whatever) that returns the data for my OrderDetail class and allows Linq to join it to the data for the other classes (Order, Product, Customer etc). Maybe you are suggesting writing a stored procedure that returns all of the data

  Posted to Data Access and ObjectDataSource Control (Forum) by lneville on 10/20/2009

• Re: Can you pre-load related tables (in ContextCreated of LinqDataSource) when Selecting calls a method based on a SQL Table Valued Function?

  How do I use a stored procedure to generate a single SQL select query instead of dozens and dozens?

  Posted to Data Access and ObjectDataSource Control (Forum) by lneville on 10/19/2009

• Re: Can you pre-load related tables (in ContextCreated of LinqDataSource) when Selecting calls a method based on a SQL Table Valued Function?

  My original attempt actually was with a stored procedure. But it suffers from the same problem - Linq can't create a single query joining it to the related tables, so it issued multiple queries to get all the related values. I actually rejected the stored procedure approach in favour of the table valued function because I could still pass in parameters and it (in theory) could be joined to the related tables. Any other ideas?

  Posted to Data Access and ObjectDataSource Control (Forum) by lneville on 10/16/2009

• Re: Can you pre-load related tables (in ContextCreated of LinqDataSource) when Selecting calls a method based on a SQL Table Valued Function?

  Ok here are some more details. Suppose we were looking at the familar ordering system data model: There are 5 related tables - Orders, OrderDetails, Products, ProductCategories & Customers. Using the Linq to SQL .DMBL designer I have created 5 corresponding classes: Order, OrderDetail, Product, ProductCategory & Customer. Now, my problem is with a particular page, which is for searching order detail records using a wide variety of fairly complex search criteria. In other words they are not

  Posted to Data Access and ObjectDataSource Control (Forum) by lneville on 10/15/2009

• Can you pre-load related tables (in ContextCreated of LinqDataSource) when Selecting calls a method based on a SQL Table Valued Function?

  I am trying to reduce the huge number of SQL queries generated when databinding a grid that is bound to a LinqDataSource. The grid displays a number of attributes from related tables (e.g. if the grid is based on the Orders table, Order.ProductName is shown). Currently one query is generated for every row in the results to fetch the ProductName. Very inefficient and I thought it could be eaily solved by using the technique of specifying related tables to pre-load during the ContextCreated event

  Posted to Data Access and ObjectDataSource Control (Forum) by lneville on 10/5/2009

• Re: General access denied error creating user on local machine, but running as administrator

  Actually I think I spoke to soon about fixing the issue :( Something very wierd is going on .... I have now tested several different user & group management functions, and some work and others don't. Whether they work or not is affected by 2 things: (i) whether the SAM store on the same server as your ASP.NET app or on a remote server, and (ii) whether the machine/host name or machine IP address is specified in the PrincipalContext. Here are my findings. If anyone can explain this and suggest

  Posted to Active Directory and LDAP (Forum) by lneville on 6/30/2009

• Re: General access denied error creating user on local machine, but running as administrator

  After weeks of frustration I finally found out that there was nothing wrong with my original code. It seems there is something "wrong" with my Windows XP dev machine. At least when I ran the same code on another XP machine and on a Win 2003 server it worked fine. What exactly is wrong with my machine I don't know. The problem in a nutshell is that, even though a username & pwd are specified in the PrincipalContext to connect to the local machine's security store with, and that

  Posted to Active Directory and LDAP (Forum) by lneville on 6/25/2009

• Re: General access denied error creating user on local machine, but running as administrator

  One other thing I found out, which might help someone: If the machine name is set to an IP address in the PrincipalContext, some functions (like creating a user) work, but others don't (like finding out if a user is in a group). For example, the following always returns false (even though the user1 and group1 objects are found): UserPrincipal user1 = UserPrincipal . FindByIdentity ( _PrimaryPrincipalContext , IdentityType . SamAccountName , username ); GroupPrincipal group1 = GroupPrincipal

  Posted to Active Directory and LDAP (Forum) by lneville on 6/25/2009