.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Retrieving posts by their tag

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :ASP.Net
 
Hi, I have the following code in a stored procedure to retrieve all posts:SELECT Blog_Post.PostID, Blog_Post.PostTitle, Blog_Post.PostAuthor, Blog_Post.PostDate, Blog_Post.PostBody, Blog_Post.PostDescription, Blog_Post.Comments, Blog_Post.Publish, Blog_Post.Likes FROM Blog_Post WHERE Blog_Post.Publish = 1; SELECT Blog_Category.CategoryID, Blog_Category.CategoryTitle, Blog_Post_Categories.PostID FROM Blog_Post_Categories INNER JOIN Blog_Category ON Blog_Post_Categories.CategoryID = Blog_Category.CategoryID ORDER BY CategoryTitle; SELECT Blog_Tag.TagID, Blog_Tag.Tag, Blog_Post_Tags.PostID FROM Blog_Post_Tags INNER JOIN Blog_Tag ON Blog_Post_Tags.TagID = Blog_Tag.TagID ORDER BY TagHowever, I am having trouble selecting posts by their tag... Any help will be great. Thanks in advance!


View Complete Post


More Related Resource Links

Retrieving a variable from a previous page

  

Hi,

I'm looking to have a search page where a user will select an item from a listview, then then taken to another page that wil display data based on their original selection.

A user will type in a string and be presented with a list of usernames that are like that string, when they select a user name who's profile they would like to view I would like the page that they're taken to, to be that users profile.

How would I transfer the variable from the search page to the profile page, and when I work on the profile page, how can I access that variable?


Thanks.


How do I preserve __viewstate between cross domain posts or how do I get a __viewstate of a Remote S

  

Here is what I want to do:
I have a local site in which I want to display data from a remote site
Lets say: I want to display data of http://www.abc.com/Default.aspx on my localhost

Now Default.aspx requires some post-data which it sends to itself. Thus the __viewstate and __eventvalidation are posted back to it by itself. I want to directly post the data to Default.aspx from localhost without opening Default.aspx and display the Default.aspx's response on my localhost.

The WebApp on http://www.abc.com is configured for __eventvalidation i.e. I cannot post-data to it from my localhost without getting a __viewstate from it. I also have to post the current __viewstate of http://www.abc.com/Default.aspx to itself

How can I accomplish it?


Problem getting applicaton to run after retrieving it from source control software.

  
Hi;

I am restoring my asp 2.0 app from a source control project to my local drive.

The application was originally created on a different PC but was created with Visual Studio 2005,

ASP.net 2.0.

The source control add-in (Harvest) is not working correctly so I retrieving and saving my web app

outside of Visual Studio.

I finally put all the pieces of the web app back together but now when I compile my app I get the following message:

Build (web): Could not load the assembly 'App_Web_myApplication.master.cdcab7d2'. Make sure that it is compiled before accessing the page.

Will I have to start over ?

Thanks for your insights !


How to display recent blog posts in marquee up tag?

  

I need to display recent blog post in the blog site to the right panel.

i am able to display all the title of the posts using dataview. What i need is that it should scroll up, that is all the contents should be in the : Marquee direction="up" tag.

how can i scroll the recent post's?

 


Blog site Restrictions -- How to set an expiration date on blog posts

  
I just created a new Blog site in Sharepoint 2007, and set permisions to the users and admins.
Now, I have a question on how to set the post life time. Is there any setting to contral how many days that the posts can last in the blog? We want the post include the comments kept in the site for one month.

Please help.

Thanks.
lw

"An error occurred while retrieving data from Oracle Instance..."

  

I have succeffuly Imported the ADF and have also successfully created a Business Data Column. But when I try to query data , I get the following error

An error occurred while retrieving data from Oracle Instance. Administrator, see the server log for more information

And this is what I found in the Application Logs
A Metadata Exception was constructed in App Domain '/LM/W3SVC/81256521/ROOT-1-129217212004078822'. The full exception text is: LobSystem could not be found using criteria 'id=476'.


Failed to generate a user instance of SQL Server due to failure in retrieving the user's local appl

  
Hi ,From the last few days I am struggling with the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."I hav created an asp.net web application with membership shcema. It works fine an my developement machine but when I published it on my web server. It is giving me above error for which I searched but not found any help.Can anyone help me with this.

Retrieving all multiple matches, not just the last one

  
Hello all, I am having a major brain cramp. I need to process a line similar to the following: Price Between 10 And 20 Or Price Between 40 And 50 Or Price Between 70 And 80 (Price Between \d+ And \d+) matches the first one. Then something like ( Or \1)* should match zero or more repeating between statements iwth a preceding Or. But I can't get the pattern setup correctly. Any ideas and/or suggestions would be greatly appreciated!

OWC11.Spreadsheet.11 - Retrieving the COM class factory for component with CLSID {} failed due to th

  
We have a web application (C#) which uses OWC11.Spreadsheet.11 to create excel files. This application works fine on XP 32bit, Windows 2003 server 32 bit versions. Recently we moved our application to a Windows 2008 web server 64bit machine. Now when we run the appication and call the functionality generate the Excel files which uses OWC11.Spreadsheet.11 it throws the following error.Retrieving the COM class factory for component with CLSID {0002E559-0000-0000-C000-000000000046} failed due to the following error: 80040154.In the code we use this library as follows using Microsoft.Office.Interop.Owc11; SpreadsheetClass xlsheet = new SpreadsheetClass();We have registered the Microsoft.Office.Interop.Owc11.dll in the global assembly cash as we have done in 2003 server.  We also tried running owc11.exe to insall all office 2003 web components.Can anyone help us to sort this issue.Thanks in advance.Sam

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local appl

  
Hi,I spend two days looking for an anwser to this problem but no luck. I have a simple ASP.NET 2.0 application which run correctly on my local machine. But After uploading all files including web.config file on a Windows 2003 Server with SQLEXPRESS installed. I have this error. Please Help!!!!!! Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

Function retrieving users by country against (Active Directory) LDAP

  
Hello I've got such openquery SELECT * FROM Openquery(ADSI, 'SELECT EmployeeID, displayname, mailAddress, country FROM '' LDAP://MY-LDAP-PATH '' WHERE country=''coutry_code' '   ') country_code is 3 letters i think sth in format like USA, FRA etc I will need to retrieve users from up to 3 countries let say and i would like to create from this query above a stored procedure (or better a FUNCTION)  where someone calling a function can specify from which country does he/she wants to terieve users - when none country specified a function should retrieve users from all 3 let say. I'm not very advanced in programming in T-SQL yet so my question is -> can the variable be specified inside Openquery ? like for example SELECT * FROM Openquery(ADSI, 'SELECT EmployeeID, displayname, mailAddress, country FROM '' LDAP://MY-LDAP-PATH '' WHERE country=''@country' '   ') ACTIVE DIRECTORY HAS LIMITION OF RETRIEVING 1000 RECORDS AT ONCE - BUT NONE OF THESE COUNTRIES HAVE MORE THAN COUPLE HUNDREDS HOVWEVER summing them in one query this number of course will exceed 1000 recoreds so queries i think should be splitted and joined with union ??? Can anyone provide some example code of such function  The other problem i have is that openquery againt ADSI  above works correctly when i use SSMS localy on the server (connectin

Retrieving lost password for a sdf file

  
i created database using sql server ce a few days ago but i've forgetten its user name and password. is there any solution to find my user name and password of my sql server ce database. thanqs for help.

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local appl

  
Hello everybody.I am working on Login control and I am new in ASP.NET. So far what I did is :1. In Website->ASP.NET Configuration I change the form authentication to internet.2. I created a user profile3. This gave me a ASPNETDB.mdf database.4. I added this code :<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/> </connectionStrings> in web.config file.4. I added login control to my login page :<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" Title="Untitled Page" %><asp:Content ID="MainContent" ContentPlaceHolderID="MainContentPlaceHolder" Runat="Server"> <h1>Please Login</h1> <asp:Login ID="LoginAuth" runat="server" > </asp:Login></asp:Content> 5. And the login.aspx.cs file has :using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.W

Retrieving user profile

  
I am trying to retrieve the user profile details using UserProfileManager class on MOSS 2007 installed machine. I tried with AccountName property using SystemAccount\UserName and  also I passed into  GUID of the known user profile into GetUserProfile method. still I am getting this exception User Not Found: Could not load profile data from the database. any idea?

Post All SP 2010 posts to a SP 2010 forum

  
SP 2010 forums that are available are listed here http://social.technet.microsoft.com/Forums/en-US/category/sharepoint2010FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com Complete Book Lists (incl. foreign language) on each site.

Problem while retrieving data from a lookup column from sharepoint linq.

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend