.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

Item grouping and lot no on a single line

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
I would like to have the items group in a single row, that is not to complicated, however, each items has a lot number (serial) and in the column near the item number, I would like to see these serial number one after the other, on a single line, separated by a comma.à If a customer order a quantity of 2 of a specific item, the software I use create 2 lines because of the serial number attached to it, and on the quantity column it write 2 times 2 so my invoice is out of balance, this is because of the serial number. Example: Item                 Description          Quantity             Serial number 1234                 Item 1234                 2                   50012 1234                 Item 1234                 2           

View Complete Post

More Related Resource Links

How to display TreeViewItems different ways based on the item type under a single node?

Hi, I am having trouble trying to display hiearchical data under each node in two different ways depending on the data.  I hope someone will be able to provide me some help on this since I am rather new to WPF development. Maybe I am going about this all wrong but for now, I am trying to create a customized TreeView to represent data similar to the xml I provided in the code below.  The <ItemsPresenter/> instances listed in the code are not exactly doing what I need.  I will probably need to filter the content that I list with each of the two <ItemsPresenter/> tags based on the type of each item although I have no idea if this is possible.   <Window x:Class="Wpf_treeview_testing.Window1" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="Window1" Height="300" Width="300"> <!-- * The "xmlData" describe roughly the type of data that I require visual representaion of. * Since I could not find a WPF Control that will present a Hierachical Data Template close to what we need, I am trying to setup a TreeView to represent this information by using a ControlTemplate for TreeViewItem. * The preferred result is to present different items types in

disable a single intem in dropdownlist or stop the ddl change event for a single item


hello guys,

I am trying something apart of my boundries, is there any way to disable a single intem in dropdownlist or stop the ddl change event for a single item.

any feadback would be appriciable.

Thanks and Regards

Inderjeet Singh Khalsa

WSS 3 - How do I retrieve a single item from the Web Services?


This is kinda two questions but they are related.

I have successfully used the GetListItems method of the Lists web service to get the items in a list.

Having looked around I can't find the expected easy way to:

1. Get a single list item by ID.  Do I just use GetListItems and use ID in the Query?

2. Get a document from a document library.  The answer might be the same: use GetListItems and use ID in the Query and somehow transfrom the document body into a stream?

Having used CRM web services I was expecting to see GetListItem(ID) and perhaps GetDocument(ID).

Can anyone point me at an example/tutorial or provide a sample.


How to bind data from linq to html table without a single line of loop.




This is the above code i have worked using querysing and displaying the listitem with in  a simple html table. Here I am using foreach statement to bind items. How to bind the data to a simple html table using SharePoint linq without  a single line of loop.

using System;
using System.ComponentModel;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using System.Linq;
using Microsoft.SharePoint.Linq;

namespace QuerystringProgramWithoutLoop.QuerystringProgramWithoutLoop
    public class QuerystringProgramWithoutLoop : WebPart
        string strTitle=string.Empty;
        string strStatus=string.Empty;
        protected override void Render(HtmlTextWriter writer)

FlowDocument: how to convert a Block item to Inline item so they can show at one line?



First, sorry for my poor English, I know this question may sound absurd, but there are many situations like showing several tables in one line, customized List Marker... which may need to show several Block items at one line.

Now I got 3 approaches,

1: use Floater or Figure, but they only provide basic functions for docking, so they cannot display more than 3 block decently, and when processing deeply nested lines, the result got so ugly and very difficult to coordinate.

2: use Table to layout the page, it do has a good result, but as it is a rule in both WPF and HTML that Table should be use to display Tabular data, it should not be used in layout.

3: use InlineUIContainer to wrap each Block in a Control which can display FlowDocument, this may be the worst option.

any ideas? thanks, in advance.

View for a single list item?


I have a SharePoint 2010 list that manages work orders, but I can't find a way to create a view that shows only one record in a receipt-like format.  I have seen that there is the capability to use XSLT to create custom views, but I can't see where I would upload/edit this in SharePoint Designer (I have Visual Studio, but haven't started using it yet for SharePoint development)

Here is an example of what I want to do...

Fields in the List:

Date | Customer Name | Description | Quote

I'd like to print out a receipt that looks like this:

Date: 10/15/2010
Customer Name: Joe Smith
Description: Level 1 Tune-Up
Quote: $200

I'm assuming that a View (which can be printed) would be the easiest way to do this, and that a custom Web Part would be the best but also a lot more work.

Update Single item with EntityFramework


I want to update object via entity framework

For example I have to changed object


I want to save change to the Obj1 Only

   public void Edit(Company _Company)
            //_context.ApplyPropertyChanges("Company", _Company);

I try to Save with ApplyPropertyChanges but the data didn't saved

How can I update object?


change the column type from single line of text to choice



I have created a calendar & there is an inbuilt column location that is single line of text, I want to change from single line of text to choice, but i don't see the option & I am not able to delete the Location column. is there any way to delete the column or change the type from single line of text to choice.


Thanks in advance  

Single Pixel Line Drawing

I have developed small programme with free hand mouse drawing. The line drawing is done with DrawLine method. Now I want to draw a line with single pixel thickness and pixels should be unconnected like one in this website --- http://www.cs.unc.edu/~mcmillan/comp136/Lecture6/Lines.html and it should be free hand mouse drawing. I have tried DDA algorithm method but it too draws line with connected pixels ( here the connected pixels i mean that the pixels should be only connected diagonally not top or bottom). I have tried pen thickness to -1 but still does not work. If any one have solution for this issue please help me.

Set dynamic default value for a Single line of text column type


Hi all,

I have a Project name site column(type is Single line of Text) and need to populate it with site name. Since Site name is not known until site is created, how can I deal with this through XML.No coding should be used.And this column is also being used in Roll up process for the site.The Project Name value that is being populated in the text box should be a default value too.


Grouping/Expanding specific item


Let's say I have a report and the main detail item is FamilyName.  It displays values such as this:





If I want to show a plus and expand ONLY smith, so I could see that the family contains "Bob, Sue, Billy, Mary...", how would I do something like this?

Thanks in advance.


Change data type of library field from Single Line Text to currency


I have an InfoPath 2010 form that has a field listing the amount of currency on a meter. It is a Decimal form in Infopath but publishes to SharePoint as a Single Line of Text.  It will not let me modify the column in SharePoint and it will not let me select the allow edit from the Publishing Wizard.  I need the column as a currency so my Excel Queries work.



Display single item from List using XSLT and show total count of all items in list


I have a simple SharePoint 2010 list named "Tips". Each item consists of a Title and Description. I want to display a single item at a time in a sidebar on my site with arrows to advance to the next or previous item in the list. I've been able to accomplish this pretty easily using OOTB SharePoint XSLT list view web part settings and AJAX. However, when I tell the web part to only display 1 item at a time the pager always says it's showing item "1 of 1" or "2 of 2". It won't show the total number of items from the list. I'd like it to show something like item "1 of 25", etc. How do I get it to display the total count of items from the list?  I've looked at possibly using aggregation attributes on a FieldRef but I've not been able to get anything to work. I'm not even sure that's the right place to be looking. I'm needing to accomplish this without writing a custom web part. 


Playing with Linq grouping: GroupByMany?

One of its features is grouping. Many people understand grouping like it is defined in Sql. Linq is implementing grouping quite the same way. Let's discover this syntax and how to make consecutive groups easier.

Grouping Gridview with jquery

The requirement of the project is to show a table of data with the riskdetails(just for assumption) which have the corresponing values for every month and people used to compare the values for last months.

Building a grouping Grid with GridView and ASP.NET AJAX toolkit CollapsiblePanel

I've posted an update to this post to apply on demand loading of Details data using ASP.NET AJAX PageMethods. I'm demonstrating the usage if CollapsiblePanelExtender client events on the new post. Check it out.

I admit, Matt Berseth is really inspiring me! Few days ago I pass through 2 of his great posts:

.Surrounding your Data Table and Dialog Controls with ComponentArt Styled Panels
.Building a Grouping Grid with the ASP.NET 3.5 LinqDataSource and ListView Controls
The first one is pure design tips one which I used for making good presentation of my demo here. The 2nd post is actually the idea.

Grouping Gridview with jquery in asp.net

The requirement of the project is to show a table of data with the riskdetails(just for assumption) which have the corresponing values for every month and people used to compare the values for last months.
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