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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

WPF: how to make the listview work (apply basic listviewitem style and also apply special data

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :WPF

 We have defined the basic ListViewIItemStyle as following:

<!--ItemContainerStyle with the Trigger for selection x:Key="ListViewItemStyle"-->
 <Style x:Key="ListViewItemStyle"
  TargetType="{x:Type ListViewItem}">
 <Setter Property="Background"
 Value="Transparent" />
 <Setter Property="HorizontalContentAlignment"
 Value="Center" />
 <Setter Property="VerticalContentAlignment"
 Value="Center" />
 <Setter Property="Foreground"
 Value="Black" />
 <Setter Property="Margin"
 Value="5,0,5,0" />
 <Setter Property="MinHeight"
 Value="40" />
 <Setter Property="Template">
 <ControlTemplate TargetType="{x:Type ListViewItem}">
 <Border x:Name="Bd"
 <GridViewRowPresenter VerticalAlignment="{TemplateBinding VerticalContentAlignment}" />
 <!--<ContentPresenter HorizontalAlignment="Left"
  SnapsToDevicePixels="{TemplateBinding SnapsToDevicePixels}" />-->

View Complete Post

More Related Resource Links

CROSS APPLY doesn't work in some databases

I've run across a weird error trying to use CROSS APPLY. Running SQL2005SP2 developer edition on XP2 (but same error occurs on Enterprise running on W2K3).A simple CROSS APPLY always works when run from master, but doesn't work when run from most (but not all) of my other user databases. I can't figure out what could be causing the error, or is there some reason it would only work when the current database is master?Here is the simplest testcase I can come up with:select a.spid,b.text from master..sysprocesses a cross apply ::fn_get_sql(a.sql_handle) bIf this is run while the current database is master, it returns spid and SQL without a problem. If it's run in the other SQL-delivered databases (model, msdb, tempb), it also works fine. However, if it's run in all but one of the user databases, I get back an error:Msg 102, Level 15, State 1, Line 1Incorrect syntax near 'a'.I'm stumped on how to troubleshoot this. There is no difference in the query; the only difference is the current database. The databases are all owned by sa. I get the same results with sys.sysprocesses instead of master..sysprocesses.As another datapoint, the employee/department example in the BOL for CROSS APPLY exhibits the same behavior; it works fine if run with master as the current database (regardless of where the tables are created), it fails withMsg 102, Level 15, State 1, Line 3Incorrect synt

Support paging in custom xslt and apply it to Listview webpart

Hi Gurus, I have a listview webpart. I want to apply a custom xslt to it. I am able to apply a custom xslt to the listview webpart, however I am not able to find a xslt code to support "paging" in the xslt for the webpart. Please bail me out. Thanks in Advance Regards, Bokes

Can't make parameterized query work in data flow task


I have an OLE DB source in a data flow task.  The connection is pointing to a SQL Server 2008 instance.  My SQL works fine when I click the preview button.  Now I need to make it parameterized by adding a question mark in my where clause.  After doing so & clicking the Parameters button, I get the error described in this post .  When I try to do what's described therein to correct the problem (click the "build query" button), I get the error "The PIVOT SQL construct or statement is not supported."

I can't make this query an expression; it's simply too complex to maintain that way (besides, just pasting it into an expression builder window and trying to evaluate as is doesn't work - can't evaluate).

So the question is, how do I parameterize a query?  And why does SQL here work so radically differently from SQL in an execute SQL task?

Trying to apply style to a gridview column programatically..


I have a grid view that is bound from my code behind.   If the text of a label is equal to the value of a querystring, I want to apply a specific class/style that is in my .css.  I've tried this, but doesn't seem to have any affect...  How can I set the class for a column in the gridview if the two values match?   

 protected void gvMenu_RowDataBound(object sender, GridViewRowEventArgs e)
        if (e.Row.RowType == DataControlRowType.DataRow)
            Label lblSubSectionIDForComparing = e.Row.FindControl("lblSubSectionID") as Label;
            Label lblSubSectionNameForComparing = e.Row.FindControl("lblSubSectionName") as Label;

            if (lblSubSectionIDForComparing != null)
                if (lblSubSectionIDForComparing.Text == Request.QueryString["SubSectionID"])
                    e.Row.Cells[2].CssClass = "SubSectionNav";  <-- This is what I thought would work...


Apply Style to checkboxlist Items


Hi ,

How to change colour of CheckBoxList Items Text ?

Ex: chkblstRoleFunc1.Attributes.Add("style", "color:red");

But For above ex, red colour is applied to the Text of all the Items of CheckBoxList. I want it to be applicable for only one Item among all the Items i.e. Red Colour for only one Item and rest all Items in Black Colour(which is the default colour).

Please view the following code that I have Impemented. Is It RIGHT ??
            To change I have to call javascript runtime on CheckBoxList OnLoad event.
Problem is that, below written call to Javascript is not Working.
Please have a look at the below given code :

1) Code Behind :-

if (ds1.Tables[0].Rows.Count != 0)

for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
chkblstRoleFunc1.Items.Insert(i, new ListItem(ds1.Tables[0].Rows[i].ItemArray[3].ToString(), ds1.Tables[0].Rows[i].ItemArray[1].ToString()));

if (Convert.ToInt32(ds1.Tables[0].Rows[i].ItemArray[2]) == 0)
chkblstRoleFunc1.Attributes.Add("onload", "javascript:setCheckboxColor('" + ds1.Ta

Using CROSS APPLY in a data source query causes ARITHABORT error


I have an issue where the following query as an OLEDB data source throws the following error:

SELECT XmlNode.value('SomeValue[1]', 'varchar(10)') as SomeValue

FROM (SELECT CAST('<TestXML><SomeValue>123</SomeValue></TestXML>' AS XML

Apply togglebutton style inside a toolbar



because the togglebutton inside a grid in a toolbar has a different style, i found a way to set the style to the toolbar it's style
I create a invisible togglebutton (base) direct inside the toolbar (tb).

In code I add the line: cc.style = base.style
This will show the togglebuttons as they show up in a toolbar.

My question is: is there a way to automate this? If I now add a new togglebutton inside the grid, i have to add a line in code to set the style.

<Window x:Class="MainWindow"
  Title="MainWindow" Height="350" Width="525">
  <ToolBarTray Background="White" Orientation="Vertical" >
   <ToolBar Name="Tb" Band="0" BandIndex="0" >
    <ToggleButton Name="Base" Visibility="Collapsed" ></ToggleButton>
      <ColumnDefinition ></ColumnDefinition>
      <ColumnDefinition ></C

"Does not contain" condition on a choice field in a SPD Workflow does not apply/work


I am trying to check a multiple choice field on containing a specific value but it doesn't really work. I am not sure if that is because I have a

problem with the logic or if that is a SPD problem.

I created a Content Type "Test CT" (based on the "item" content type) and added two Site Columns of the type "choice", named "Test Column 1" and

"Test Column 2" to that content type. Both choice fields are configured to contain multiple values and can contain the identical values "Product

ABC" and "Product XYZ". Additionally I added Site Column of the type "Single Line of text", named "Result" to the content type. Then I added the

content type to the custom list "Test List".

Now I built the Reusable Sharepoint Designer Workflow "Test WF" that is based on this content type and that works like this:


Set "Result" to String "Start"

If "Test Column 1" contains String "Product ABC"
Set "Result" to String "Test Column 1 contains ABC"

Else If "Test Column 1" does not contain String "Product ABC"
Set "Result" to String "Test Column 1 does not contain ABC"


Then I

don't apply static hover style to siteMapNode that has an empty url property



I was wondering if there is any way to not apply the static hover effect to asp:menu items where their corresponding sitemapnodes don't have a url specified?

It sounds a little confusing so I thought I'd add snippets of what I'm trying to do:

I have a sitemap file with 3 levels:

<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
  <siteMapNode url="~/default.aspx" title="SOME TITLE"  description="">
    <siteMapNode url="" title="Admin"  description="" roles="Admin">
      <siteMapNode url="~/admin/userMgmt.aspx" title="User Mgmt"  description="" />
      <siteMapNode url="~/admin/roleMgmt.aspx" title="Role Mgmt"  description="" />
    <siteMapNode url="" title="Users"  description="" roles="User">
      <siteMapNode url="~/Users/MyAssignments.aspx" title="My Assignments"  description="" />

I then have my sit

Apply conditional formatting to TD instead of to the actual data?


I am trying to assign conditional formatting to a table cell, just like what happens in Excel's conditional formatting.

In SPD 2010, I can select the cells in a column by clicking within a single cell in a column (the white td tooltip pops up and all cells are highlighted) or I can select the actual data items by more carefully clicking on the data instead of the cell's white space (xsl:value-of tooltip pops up and only the data itself is highlighted--not the entire cells).

In the Conditional Formatting task pane, with either the tds or the data items selected, I can use the Create drop down and make a new Apply formatting... condition. The strange thing is the condition never gets added to Existing conditions in the Conditional Formatting task pane if I have the td selected. However, the condition does appear if I have the xsl:value-of selected.

Why can I apply conditional formatting to the values but not to tds?

How to apply style for "Search Options" pop up of People Search Box webpart - Sharepoint 2010

I have added around 10 additional filter properties to the Search Options link available in the People Search Box web part. Now all these properties are coming in a single column. How can change the look and feel for the div which shows the filter property text boxes?

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

ListView DataPager with SQL-Statements that already return only paged data.



As far as I understand the ListView-Control and the DataPager-Control, they work like this: The ListView gets its datarows from its data source, then the DataPager causes the ListView to display only a subset of those rows.

So what, when I want to use custom databinding for the ListView, that *already* gets the certain subset from SQL-Server (for better performance). Can I and how can I use the DataPager then?

Thanx, S.

how to make a css style background image be linked to an image in the resource file


hey guy, i need help in a very troubling matter. I want to make a textbox with a specific style, within this style a set of images as background parts, how can i attach these images to the custom control as whenever i take the .dll file and add it to the toolbar the images do not appear. So i tried to make them as resource files and their property as embedded in .resx file, so how to make the css style background image url to be linked to any of those image.

thanks in advance

Foundations: Easily Apply Transactions To Services


Managing state and error recovery using transactions is the topic of this month's installment of Foundations.

Juval Lowy

MSDN Magazine January 2009

Basic Instincts: Dynamic Data Entry With XML Literals


Learn how to use Windows Presentation Foundation (WPF), XAML, and the deep XML support in Visual Basic to generate user interfaces dynamically.

Beth Massi

MSDN Magazine October 2008

Unit Testing: Apply Test-Driven Development to your Database Projects


Jamie Laflen extols the benefits of TDD when applied to database development-and supplies some useful techniques along the way.

Jamie Laflen

MSDN Magazine Launch 2008

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