SQL Server :: Get The Last 3 Tags That Added To The Db

Oct 11, 2010

I want get the last 3 tags that added to the db. My Tag table schema is:

TBL TAG:
CREATE TABLE [dbo].[tblTag](
[TagId] [int] IDENTITY(1,1) NOT NULL,
[Header] [nvarchar](200) NULL,
[IsActive] [tinyint] NULL DEFAULT ((0)),
[Ordered] [int] NOT NULL DEFAULT ((1)),
[Language] [nvarchar](5) NULL,
[DateTime] [smalldatetime] NULL,
[Official] [nvarchar](max) NULL,
[LastUpdate] [datetime] NULL,
[Locked] [tinyint] NULL,
[LastUpdateUser] [nvarchar](256) NULL,
[NumViews] [bigint] NULL,
[AllUserModified] [nvarchar](max) NULL,
CONSTRAINT [PK_tblTag] PRIMARY KEY CLUSTERED
(
[TagId] ASC
)

My TagtoMoudule table:

CREATE TABLE [dbo].[tbl_Module_Tag](
[AutoId] [int] IDENTITY(1,1) NOT NULL,
[ModuleId] [int] NOT NULL,
[ItemId] [int] NOT NULL,
[TagId] [int] NOT NULL
) ON [PRIMARY]

I want get the last 3 items in the tbl_Module_Tag but with no duplicate value, get uniq tags For exemple If the data the query "select tagid from tbl_Module_Tag order by autoid desc" return this values..........

View 5 Replies


Similar Messages:

Render - Server Control Emitting Server Side Tags?

Feb 19, 2010

I'm new to writing custom ASP.NET server controls, and I'm encountering the following issue:

I have a control that inherits from System.Web.UI.HtmlControls.HtmlGenericControl. I override the control's Render method, use the HtmlTextWriter to emit some custom HTML (basically a TD tag with some custom attributes), and then call the case class' Render method.

Using the control:

<dc:Header id="header1" runat="Server" DataColumn="MemberNumber" Width="30%">Member Number</dc:Header >

The problem is that when I view my rendered HTML, the server tag is emitted to the client as well (right after the TD tag):

<dc:Header id="ctl00_ContentPlaceHolder_testData1_testData1_header1">Member Number</dc:Header>

How do I prevent this from happening?

View 1 Replies

Custom Server Controls :: Create Server Control (dll File) From Scratch, To Added In ToolsBox?

May 11, 2010

DI want ask about how to create server control (dll file).

From Scratch, to added in ToolsBox

for example :

create TextBox,Button and Label ; when press on Button the Label show text inside TextBox

Please I need Detailed description

View 4 Replies

AJAX :: Script Tags Rendered Inside The Body Tags?

Jun 26, 2010

i have created a aspx page with the script manager, update panels and so on. Now, when i use some jquery functions which are included inside the head tags, when the page is run, i find the script tags generated inside the body instead of the head tag. i'm using visual studio 2005 only.

View 2 Replies

C# - Forum Tags: Can Regex Be Modified To Grab Nested Tags?

Feb 24, 2011

I am building a forum and I want to use forum-style tags to let the users format their posts in a limited fashion.Currently I am using Regex to do this.As per this question:How to use C# regular expressions to emulate forum tags. The problem with this,is that the regex does not distinguish between nested tags.Here is a sample of how I implemented this method:

public static string MyExtensionMethod(this string text){return TransformTags(text);}
private static string TransformTags(string input)
{string regex = @"[([^=]+)[=x22']*(S*?)['x22]*](.+?)[/(1)]";
MatchCollection matches = new Regex(regex).Matches(input);
for (int i = 0; i < matches.Count; i++)
var tag = matches[i].Groups[1].Value;
var optionalValue = matches[i].Groups[2].Value;
var content = matches[i].Groups[3].Value;
Now,if I submit something like [quote] This user posted [quote] blah [/quote] [/quote] it does not properly detect the nested quote.Instead it takes the first opening quote tag and puts it with the first closing quote tag.Do you guys recommend any solutions?Can the regex be modified to grab nested tags?Maybe I shouldn't use regex for this?

View 3 Replies

How To Use ID Tags On Server Controls

Apr 28, 2010

Some of my servercontrols dont need ID's (i never need to access them from codebehind), removing them is rendering fine without comlaints. Is this ok?

why im dont want IDs? im using a .resx for different languages and from what I understand these must tied to a server control. And im tired of comming up with new pointless unique names. Also the these ID's gets insanly long as clientID.

View 1 Replies

Server Tags Cannot Contain Constructs?

Feb 24, 2011

I have a (image button)

<asp:ImageButton
ID="ImageButton1"
runat="server"
ImageUrl="../Images/checkout/Proceed_To_Checkout_Button.png"
onclick="top.location='<%=string.Format("MyAccount.aspx?action=new&returnUrl={0}",
Web.ProcessFlow.Common.QueryString(Request.QueryString["returnUrl"]))%>'"
/>

I get this error when I push the button:

Server tags cannot contain <% ... %> constructs.

I have tried <# too
it didn't help.

View 1 Replies

C# - Server Tags In Markup?

Feb 4, 2011

Morning all I have frequently used the old

<asp:Label ID="lblWas" runat="server" Text='<%# XPath("FACEVALUE") %>'></asp:Label>

This type of thing. when I first came across it I loved it, i'm using it again today but not quite so simply. I have a number of extra things I would like to achieve.

Apply formatting to the value. Like Text='<%# string.Format(XPath("FACEVALUE"), "{0:c}") %>'>
<asp:LinkButton ID="lnkBook" runat="server" PostBackUrl='/THEATRE/' + XPath("FACEVALUE")>Book</asp:LinkButton>

For option number 2 the URL is not as I would expect, and for number 1 I cannot get the syntax correct if it's even possible.

I have not been able to find something suitable in google. Hopefully what I am trying to achieve is obvious from the example :)

View 3 Replies

C# - .NET Server Tags Are Not Well Formed?

Aug 18, 2010

I want to use some server tags in OnClientClick of LinkButton

<asp:LinkButton ID="lnkbtnID" OnClientClick='<%# "window.open('SomePage.aspx?Id=" + Eval("reqID") + "');" %>' runat="server" Text='<%# Eval("reqID")%>'>
</asp:LinkButton>

how to write this, it is giving the error that Server tags are not well formed.So how to write this correctly?

View 2 Replies

How To Apply CSS Tags To <li> Tags When Using 4.0 Menu Control

Feb 1, 2011

Is there a way to apply your own CSS tags to <li> tags when using ASP .NET 4.0 menu control? For example, say I have an external style sheet that has tags "class1", "class2", "class3", and etc. I want to apply "class1" to the first menu item. Then if menu item is selected, I want to apply "class2" and if it's not selected, "class3". I played with various 'Static' styles, but just can't get it work. I finally gave up and created my own menu control that extends ASP .NET menu control and provides my own custom rendering. This works, but I'm wondering if there is a way to get it work with built-in menu control.

View 1 Replies

Rendering Server Tags At Runtime?

Feb 28, 2010

Is it possible that I reserve a asp.net code in db and load it at runtime. the asp.net code contains server side tags like Text='<%# Eval("Description") %>'

View 1 Replies

Server Removes Spacing Between Head Tags

Jun 11, 2010

I haven't been able to find relevant information through searches. I'm very green when it comes to sever side scripting. I have an ASPX page with a standard form. In the head I have meta tags, the title tag, and a link tag neatly ordered on their own lines. However, when viewing the source code after publishing to the server, the spacing between the tags is removed and it looks quite messy. (There are also <style> and <script> tags that follow, but they remain unaffected.)

I realize this has no practical effect on the site itself (in an SEO sense or otherwise). My project manager shows the source code to our clients to educate them on meta tags and page titles. It would help if it wouldn't become jumbled like this. I wonder if this is a common issue and if it's possible to prevent through better coding practices. HTML as authored, with tags separated on their own lines:

HTML Code:

<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="description" content="Welcome to Lawn Care Waukesha - Cut My Lawn. Cut My Lawn - Lawn Care Services has offered quality lawn cutting, fertilizing, aerating, and much more at affordable pricing since 2002! We currently offer lawn care service to Waukesha, Brookfield, Pewaukee, Menomonee Falls, and surrounding communities." />
<meta name="keywords" content="lawn cutting, lawn mowing, lawn care, fertilizing, aeration, mulching, shrub trimming, lawn mowing, edging, pruning, mulching, weed control, waukesha, Brookfield, Pewaukee, menomonee falls" />
<title>Lawn Care Waukesha — Cut My Lawn, Lawn Care Service</title>
<link rel="shortcut icon" type="image/x-icon" href="favicon.ico" />
HTML after being processed by the sever, with all the tags running together:

HTML Code:
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><meta name="description" content="Welcome to Lawn Care Waukesha - Cut My Lawn. Cut My Lawn - Lawn Care Services has offered quality lawn cutting, fertilizing, aerating, and much more at affordable pricing since 2002! We currently offer lawn care service to Waukesha, Brookfield, Pewaukee, Menomonee Falls, and surrounding communities." /><meta name="keywords" content="lawn cutting, lawn mowing, lawn care, fertilizing, aeration, mulching, shrub trimming, lawn mowing, edging, pruning, mulching, weed control, waukesha, Brookfield, Pewaukee, menomonee falls" /><title>
Lawn Care Waukesha — Cut My Lawn, Lawn Care Service
</title><link rel="shortcut icon" type="image/x-icon" href="favicon.ico" />

I'm not sure it's relevant, but here's the script used to send the form (which I didn't write, by the way). It's the final tag inside the page head:

HTML Code:
<script type="" runat="server">
Protected Sub SubmitForm_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If Not Page.IsValid Then Exit Sub
Dim SendResultsTo As String = "email"
Dim smtpMailServer As String = "smtp"
Dim smtpUsername As String = "email"
Dim MailSubject As String = "subject"
Try
Dim txtQ As TextBox = Me.FormContent.FindControl("TextBoxQ")
If txtQ IsNot Nothing Then
Dim ans As String = ViewState("hf1")
If ans.ToLower <> txtQ.Text.ToLower Or ans.ToUpper <> txtQ.Text.ToUpper Then
Me.CutMyLawnForm.ActiveViewIndex = 3.......................

View 5 Replies

MVC :: Whitespace Stripped Between Server Tags In View?

Jun 28, 2010

I'm rendering a view for the text/plain part of an e-mail. But in some cases, the whitespace is removed between non-output server tags, and I can't figure out why. Can someone explain why the following is missing the line breaks before the final line of output?

[Code]....

But this works - whitespace is preserved between output tags:

[Code]....

This is on MVC 2. It may have been on MVC 1 (or even in Web Forms), but I didn't notice it until today when I went to add a new line to the e-mail, so not sure of the source. Does ASP.NET or MVC have some optimization to try not to output whitespace between server tags?

View 10 Replies

C# - How To Generate Server - Side Tags Dynamiclly

Apr 19, 2010

I have an ASP.net page which contains some controls.

I generate this controls by code, [Actually I have a method which uses a stringBuilder and add Serverside tag as flat string on it]

My page shows the content correctly but unfortunately my controls became like a Client-side control

For example I had a LoginView on my generated code which dosen't work, and also I had read some string from LocalResources which dosen't appear on the page What Should I do to make my generating method correct

here is the code

protected string CreateSubSystem(string id, string roles, string AnonymousTemplateClass, string href, string rolesContentTemplateClass, string LoggedInTemplateClass)
{
StringBuilder sb = new StringBuilder();
sb.Append("<div class="SubSystemIconPlacement" id="");
sb.Append(id);
sb.Append(""><asp:LoginView runat="server" ID="");
sb.Append(id);
sb.Append(""><AnonymousTemplate><div class="");
sb.Append(AnonymousTemplateClass);
sb.Append(""></div><asp:Label ID="lblDisabled");
sb.Append(id);
sb.Append("" runat="server" SkinID="OneColLabel" meta:resourcekey="lbl");
sb.Append(id);
sb.Append("" /></AnonymousTemplate><RoleGroups><asp:RoleGroup Roles="");
sb.Append(roles);
sb.Append(""><ContentTemplate><a class="ImageLink" href="");
sb.Append(href);
sb.Append(""><div class="");
sb.Append(rolesContentTemplateClass);
sb.Append(""></div></a><asp:HyperLink runat="server" CssClass="SubSystemText" ID="lnk");
sb.Append(id);
sb.Append(" NavigateUrl="~/");
sb.Append(href);
sb.Append(" " meta:resourcekey="lbl");
sb.Append(id);
sb.Append("" /></ContentTemplate></asp:RoleGroup></RoleGroups><LoggedInTemplate><div class="");
sb.Append(LoggedInTemplateClass);
sb.Append(""></div><asp:Label runat="server" SkinID="OneColLabel" ID="lblDisabledLoggedIn");
sb.Append(id);
sb.Append("" meta:resourcekey="lbl");
sb.Append(id);
sb.Append("" /></LoggedInTemplate></asp:LoginView>");
sb.Append("</div>");
return sb.ToString();
}

I also use this method on page_PreRender event

View 1 Replies

C# - How To Pass Server Side Tags With JS Parameters

Dec 12, 2010

I have a loop in JS, and I want to pass each parameter in that loop to a function in ASP.NET in the codebehind.

something like that:

for (var i = 0; i < elements.length; i++)
{
}

And I want to pass a function in <%%> the elements[i].

How can I do that?

View 2 Replies

C# - Accessing Code Behind Property In Server Tags?

Dec 10, 2010

Is it possible to access a code behind property for a server tag? I have a property on my code behind page that i want to pass into a javascript function i.e.

<asp:RadioButton onclick="moveToNextPage()" class="inputcell" Runat="server" ID="myRadioButton" Text="No"></asp:RadioButton>

So i want to be able to get the variable out of my code behind page and pass it to the "moveToNextPage()" function. Is this possible?

View 3 Replies

Databinding Template: Escape Tags In A Server Tag?

Jan 28, 2010

I'm doing some databinding inside a ListView ItemTemplate, but I suspect this is a problem for any databinding/template situation. I want to write something like:

<asp:HiddenField runat="server" ID="hidPositionID" Value="<%#Eval("PositionID") %>" />

But I get a YSOD with an error message that the server tag is not well formed. How do I persist non-visible data inside my ListViewItem?

View 1 Replies

MVC :: Why Are HTML Helper Methods In MVC Are Inside Server Tags

Jan 9, 2010

I am new to MVC. why HTML helper methods are inside asp server tags?

for example <%=Html.Textbox("Textbox1")%>

are they equivalnet to asp.net web form server tags. Like in web forms we have

<asp:TextBox runat="server"></asp:TextBox>

If someone can kindly explain.

View 1 Replies

AJAX :: How To Add HTML Div Tags To TabContainer - Server Side

Jan 13, 2011

I'm trying to insert some html 'div' tags inside a tabcontainer from server side. I haven't seen anything similar on the net. Here's the situation:

I have the following TabContainer on a form:

<cc1:TabContainer ID="TabContainer1" runat="server">
<cc1:TabPanel HeaderText="Person">
<ContentTemplate>
<div id="Test">
</div>......

How can I acheive that? If it's not possible, what other alternatives do I have? The most important requirement for me is to allow the user to remove the data by clicking on it.

View 4 Replies

C# - How To Render Children Tags In A Custom Server Control

Nov 17, 2010

I'm working on a custom ServerControl, I've created it like below :

[ParseChildren(true), PersistChildren(true)]
[ToolboxData("<{0}:Menu runat="server"></{0}:Menu>")]
public class Menu : WebControl
{
.....
[DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
[PersistenceMode(PersistenceMode.InnerDefaultProperty)]
public MenuItem MenuItems { get; set; }
}
[ParseChildren(true), PersistChildren(true)]
public class MenuItem : WebControl
{
......
[PersistenceMode(PersistenceMode.InnerProperty)]
public MenuItem SubMenuItems
{
get
{
if (_SubMenuItems == null) return new MenuItem();
return _SubMenuItems;
}
set
{
_SubMenuItems = value;
}
}
private MenuItem _SubMenuItems;
[TemplateContainer(typeof(MenuItem))]
[PersistenceMode(PersistenceMode.InnerProperty)]
public ITemplate Template { get; set; }
}
<%@ Register Assembly="JQueryMenu" Namespace="JQueryMenu" TagPrefix="MdsMenu" %>
<MdsMenu:Menu ID="Menu1" runat="server">
<AnimationItems AnimationSpeed="Fast" AnimationType="Opacity_Height" DropShadow="true"
Delay="1000" />
<MdsMenu:MenuItem ID="MenuItem1" runat="server" Text="MenuItem 01">
<MdsMenu:MenuItem runat="server">
<Template>
<asp:Button ID="Button1" runat="server" Text="Button" />
<asp:CheckBox ID="CheckBox1" runat="server" />
</Template>
</MdsMenu:MenuItem>
</MdsMenu:MenuItem>
<MdsMenu:MenuItem ID="MenuItem2" runat="server" Text="MenuItem 01">
<MdsMenu:MenuItem ID="MenuItem3" runat="server">
<Template>
<asp:Button ID="Button2" runat="server" Text="Button" />
<asp:CheckBox ID="CheckBox2" runat="server" />
</Template>
<MdsMenu:MenuItem ID="MenuItem5" runat="server" Text="MenuItem 05">
</MdsMenu:MenuItem>
<MdsMenu:MenuItem ID="MenuItem6" runat="server" Text="MenuItem 06">
</MdsMenu:MenuItem>
<MdsMenu:MenuItem ID="MenuItem4" runat="server">
<Template>
<asp:Image ID="Image1" runat="server" />
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</Template>
</MdsMenu:MenuItem>
</MdsMenu:MenuItem>
</MdsMenu:MenuItem>
</MdsMenu:Menu>

Now, How can I Parse it and render it in RenderContent method ? !!!
The following method is always throw the first Exception, it means this.Controls is always empty !!! How can I do it and how I can access to the nested children in RenderControl method ?

public class Menu : WebControl
{
....
public override void RenderControl(HtmlTextWriter output)
{
if (!this.HasControls())
throw new Exception("Controls are empty");
....
}
}

View 1 Replies

How To Avoid Adding Runat="server" Destroying Server Tags <%...%>

Jul 30, 2010

Adding runat="server" is not rendering my server tags <%...%>

I have a masterpage with a few <li> for menu and since I have to set class=selected for the current page, I am using a little server tag to find the url and assign the particular class.

I have total of 10 <li> and not all menu is available to all types of user, I need to toggle few of the <li> if the user is not admin, so I have runat="server" added to them so I can set their visible=false through c#

Here is how it is at a glance:

<li runat="server" id="liBlog" class='<%= Request.Url.AbsoluteUri.EndsWith("/Blog") ? "selected" : "" %>'><a href="/Blog">Group Blog</a></li>
<li runat="server" id="liPoll" class='<%= Request.Url.AbsoluteUri.EndsWith("/Poll") ? "selected" : "" %>'><a href="/Poll">Poll</a></li>
<li id="liInvite" class='<%= Request.Url.AbsoluteUri.EndsWith("/Invite") ? "selected" : "" %>'><a href="/Invite">Invite</a></li>
<li id="liFavourite" class='<%= Request.Url.AbsoluteUri.Contains("/Favourite") ? "selected" : "" %>'><a href="/Favourite">My Favourites</a></li>

The <li> without runat="server" works fine, when on correct page the source code shows class="selected" or class="" as appropriate, the other <li> used to work fine too, until I decided to add the runat="server".

Once I added that runat="server", the whole block of class="" is being sent out to the html page, its not processing the server tags at all! I right click on the html and look at the source, it's being rendered as:

<li id="ctl00_ctl00_ContentPlaceHolder1_liBlog" class="<%= Request.Url.AbsoluteUri.EndsWith("/Blog") ? "selected" : "" %>"><a href="/Blog">Group Blog</a></li>

It's pouring out my server tags into the source code!

Why is this behaviour seen? How can I avoid it?

View 2 Replies

Web Forms :: Using Stringbuilder With Html Tags On Server Side Code

Nov 6, 2010

i want make html table in format so i used follwing code but it just print tags(rather than analyze them as html and give appropriate output )

[Code]....

Output got when tried to use TransList.ToString() output got was
<html> <head> </head><body><table><tr><td>1</td><td>11/24/2010 12:00:00 AM</td><td>Paypal</td><td>30</td></tr><tr><td>2</td><td>11/24/2010 12:00:00 AM</td><td>Paypal</td><td>300</td></tr><tr><td>3</td><td>12/10/2010 12:00:00 AM</td><td>Paypal</td><td>240</td></tr></table></body></html>

View 4 Replies

Web Forms :: Populate SEO Keywords And Description Meta Tags From SQL Server Database

Jun 8, 2012

I use these code to show keyword from my data base in metatag
 
SqlCommand _cmd = new SqlCommand("select Keyword1,Keyword2,Keyword3 from House_info", _cn);
_cn.Open();
SqlDataReader _dr = _cmd.ExecuteReader();
while (_dr.Read())

[Code].....

in my page meta tag show above keyword not my keywords from database

View 1 Replies

Remove Style Tags,css,scripts And Html Tags From Html To Plain Text?

Mar 8, 2011

I want regex operation for removing style tags,css,scripts and html tags from html to plain text in asp.net c#...

View 1 Replies

In Reality, Are Server Controls Rarely Added Programmatically To Aspx Pages?

Jan 21, 2011

I mean, it's easy to add a Button programmactically to an aspx page, but a server control's event handler probably has to be set early in the page life cycle (maybe before Control.Load event). As a result in reality, are dynamic controls rarely added to apsx pages?I wish there is a way to call postback at the server, so that a event is never too late.

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved