Exclude the last row returned

Hi,

I am just starting with dynamic data. I have an enttity framework called UsersModel.edmx.

It returns a list of all companies in the tblCompany table. This list is really big.

I need to filter the list returned to all user controls on the client so that it only returns the company that have a CompanyTypeId= 2 or CompanyTypeId= 3 and company name != "".

1 - Is it possible to filter the company list returned on the server so that I can filter only once for all the controls that use that on the client?

My ideas was to do something like this using linq and lambda but I am not sure how:

return tblCompanys.Where(c => c.CompanyTypeId == 2 || c.CompanyTypeId == 3 && ).Where(c=>c.CompanyName != "").OrderBy(c => c.CompanyName).Distinct().OrderBy(c=>c.CompanyName);
 

2 - I have created a partial class and a metadata class and added the DisplayColumn attribute to use the company name and sort by company name ascending.

Could I use the code to filter the returned companies in this? where?

namespace MarsMedicalModel
{
    [DisplayColumn("CompanyName", "CompanyName")]
    [MetadataType(typeof(tblCompanyMetadata))]
    public partial class t

For projects such as forms apps and class libraries you can exclude folders which reside in the directory from the project. That menu option does not seem to exist when you create a website in VS 2005, is there any way to do it?

thanks! 

When a sql query returns NULL , I can use the following code to evaluate:

While (dr.Read())
                If IsDBNull(dr(0)) Then
                    signInfo.Add("-1")
                Else
                    signInfo.Add(dr(0))
                    signInfo.Add(dr(1))
                End If
            End While

When a sql query returns nothing, neither IsDBNull nor is Nothing works.  I don't know why some sql queries return null while some return nothing when there are no data returned.  But anyway, can somebody tell me how to evaluate nothing value returned in sql datareader in vb.net?  When I put the cursor over signInfo variable in debug mode, I can see Nothing show as its value.  But the line does not work

if signInfo is Nothing then 

Thank you!

Hi,

How can i prevent author's name to appear in search results. shows many results when i search the "author.name".

I want, MOSS 2007 Search get results from the content only the user sees.

Thanks.

Error:

{System.Net.WebException: The remote server returned an error: (405) Method Not Allowed.
   at System.Net.WebClient.UploadFile(Uri address, String method, String fileName)
   at System.Net.WebClient.UploadFile(Uri address, String fileName)
   at System.Net.WebClient.UploadFile(String address, String fileName)
   at Test.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\WebSite1\Test.aspx.cs:line 35}

Windows application, automated process will run on local user system...
trying to upload a file to website folder. website address: http://1.1.1.1/test/files

System.Net.WebClient wc = new WebClient();
wc.UploadFile(website address, "c:/1.pdf");

Getting error from above line.. Am doing something wrong??
I dont want to use ftp or share folder logic..
is there any other way to upload the files to server??