.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

Linq Ouery / Code / Logic for Finding Best Selling Products

Posted By:      Posted Date: September 05, 2010    Points: 0   Category :ASP.Net
Hello ExpertsPlease do reply as i am a beginner ..This is a table Named Products .. I want to show Best Selling products in a Datalist .. kindly tell me the logic for doing so by providing some examples or code by using LINQ ... Kindly help me .. [ProductId] [int] IDENTITY(1,1) NOT NULL,    [Name] [nvarchar](400) NOT NULL,    [ShortDescription] [nvarchar](max) NOT NULL,    [FullDescription] [nvarchar](max) NOT NULL,    [AdminComment] [nvarchar](max) NOT NULL,    [ProductTypeID] [int] NOT NULL CONSTRAINT [DF_Nop_Product_ProductTypeID]  DEFAULT ((1)),    [TemplateID] [int] NOT NULL,    [ShowOnHomePage] [bit] NOT NULL,    [MetaKeywords] [nvarchar](400) NOT NULL,    [MetaDescription] [nvarchar](4000) NOT NULL,    [MetaTitle] [nvarchar](400) NOT NULL,    [SEName] [nvarchar](100) NOT NULL,    [AllowCustomerReviews] [bit] NOT NULL,    [AllowCustomerRatings] [bit] NOT NULL CONSTRAINT [DF_Nop_Product_AllowCustomerRatings]  DEFAULT ((1)),    [RatingSum] [int] NOT NULL,    [TotalRatingVotes] [int] NOT NULL,    [Published] [bit] NOT NULL,    [Deleted] [bit] NOT NULL,    [CreatedOn] [datetime] NOT NULL,  

View Complete Post

More Related Resource Links

Review It: Expert Tips for Finding Security Defects in Your Code


Reviewing code for security defects is a key ingredient in the software creation process, ranking alongside planning, design, and testing. Here the author reflects over his years of code security reviews to identify patterns and best practices that all developers can follow when tracking down potential security loopholes. The process begins by examining the environment the code runs in, considering the roles of the users who will run it, and studying the history of any security issues the code may have had. After gaining an understanding of these background issues, specific vulnerabilities can be hunted down, including SQL injection attacks, cross-site scripting, and buffer overruns. In addition, certain red flags, such as variable names like "password", "secret," and other obvious but common security blunders, can be searched for and remedied.

Michael Howard

MSDN Magazine November 2003

Locations in XML Format ... code example ... LINQ ..

Hello Experts ...As i am begienner ..Kindly Help in Finding the Solution ---- i am using a webservice ,api which will return data in XML Formant .. I will pass IP Address in WebService / API . This will return this data ....<Locations>  <Location id="0">     <Ip></Ip>     <Status>OK</Status>     <CountryCode>US</CountryCode>     <CountryName>United States</CountryName>     <RegionCode>06</RegionCode>     <RegionName>California</RegionName>     <City>Mountain View</City>     <ZipPostalCode>94043</ZipPostalCode>     <Latitude>37.4192</Latitude>     <Longitude>-122.057</Longitude>  </Location> </Locations>Problem is I want to Show data  CITY,COUNTRY,STATE in  Label .. Kindly tell me the logic .. how to read data from this XML Format ..How to Match them .. Kindly Provide me the Code , as this XML is generated by API ... Thanks a lot ..

Linq query in code behind

Hii would like to figure out this LinqDataSource in code-behind in vb.net<asp:LinqDataSource                 ID="lds" runat="server"                ContextTypeName="dbDataContext"                TableName="vKommentarUnion"                  Select="new(Key, Count() as Count, It as Items)" GroupBy="themen"                 where="isdrin=0"                AutoPage="true" AutoSort="true"            /> I found only samples in C#.How can i figure it out in vb?this does not run, what is wrong? Dim db As New dbDataContext Dim kommentare = From c In db.kommentar _ Group c By c.kursid Into Group _ Select key = c.kursid, count = Group.count, _ Items = From item In Group Select item lv.DataSource = k

Finding value in code

Hi,I am trying to copy a snippet of code from a block of code and display it somewhere, according to text within the code..E.g. the block of code below, I would want to copy and display a snippet from 'onclick' to 'class' of only the top line, because it has a '..' value of 1, not 0. i wouldnt want to copy and display the other two lines, because they have a value of 0.How can i select it like that? and they display it in a display? i am using visual web developer 2008 and c#..onclick="javascript:this.getAttribute('hello_eee'),'','1');hello_eee="10" do hello_eee="3.14" class="b"onclick="javascript:this.getAttribute('hello_eee'),'','0');hello_eee="10" do hello_eee="3.14" class="b" onclick="javascript:this.getAttribute('hello_eee'),'','0');hello_eee="10" do hello_eee="3.14" class="b"thanks so much if you can help

Adding logic to the Search Core Results web part - Manipulation in code or XSL?

Hi,I need to manipulate the search core results web part, so that:- It will display a check box for each result- It Will have an additional button. When clicking on this button the checked results should be copied to a grid view.Do you have any idea how it can be done?I am not sure what is the correct way to do it – in the client side via the XSL Editor or in the server side with the C# code.Thank you so much for your help,Regards,SP beginner.

VB code behind the Business Logic Layer ???


Hello. I was hoping for some general help and comments.

I went through a lot of the ASP.Net Web Forms Tutorials.

I also went though the whole "ASP.Net in 24 Hours" book by Scott Mictchell. I followed everything that went on in that book and built the final project successfully. I also used the tutorials here to better understand the whole Membership Provider/User tables setup that was going on in the book.

Next, I thought I would learn more about accessing data for ASP.Net since that is what most application do.

I went through the first Data Tutorial here. I seemed to understand what was going on just fine.

The second Data Tutorial seemed to just show a lot of VB code to build the Business Logic Layer. There was not much explanation about how to do it yourself.

I think I can keep going in the tutorials here. I downloaded the code from the second tutorial and went through it.I am guessing that the code in the second tutorial was given just to proceed with the overall project that is being built throughout the tutorial sequence.

I just wish I understood what is going on in those long lists of VB code. I can see some of what is going on. I don't know VB very well at all. So, what is the next step?

I have started working through a VB book. Will learning VB help me understand the code in that tu

Annoying SQL exception, probably due to some OO/linq code done wrong


I started working on this "already started" project, and I'm having a really annoying error when trying to execute some interactions with SQL Server 2008:

The server failed to resume the transaction

One of these errors I get in this specific method call:

The aspx.cs Call:


busProcesso openProcess = new busProcesso(pProcessoId);
        if (openProcess.GetDocument() == null)
            //Irrelevant code.
    catch{ //... }

The Business class (relevant part):
public class busProcesso : IbusProcesso
        public Processo vProcesso { get; set; }

        RENDBDataContext db;

        public busProcesso()
            vProcesso = new Processo();

        public busProcesso(decimal pProcessoId)
            db = new RENDBDataContext();
                 vProcesso = db.Processos.SingleOrDefault(x => x.Id == pProcessoId);
            catch (Exception ex)
                throw new Exception(ex.Message, ex);

        public string GetDocument()

how can i transform this sql code into linq


i am new with linq and i wanna do something like this in linq:

SELECT  distinct t.TC_GPI_Name, t.TC_GPI_Key,  m.Drug_Name                  
FROM    TC_GPI_NAME  t inner JOIN(
									SELECT     Drug_Name, Generic_Product_Identifier
									FROM         MEDNAME
									WHERE     (Brand_Name_Code = 'T')
									GROUP BY   Drug_Name, Generic_Product_Identifier
								  ) m 
on   (left(m.Generic_Product_Identifier, 8) = left(t.TC_GPI_Key, 8))                     
where  t.tc_gpi_key like '4014306010%' and t.Record_Type = 4

how can i do this?

how to use autocomplete in Textbox using LINQ code


Hi Everyone!


I'm a newbie in C# then i want to know about my concerns in textbox autocomplete from database using LINQ. Can u cite me an example on how to code it and where should I place it? Is it in Form_Load or Textbox_TextChange?


Tnx man and more power!

If or Case in a LINQ SQL code, How to Use Count() Request.QueryString("imageidentity")



If i want to get some diffrent data from a DB
and its by using Request.QueryString("SortBy")

What do u use !?
If The Else or Case !?

What i want is that if SortBy in the Url link is NameUP, then its sorts by A, B C and so on
and if NameDown then the other way.

Im using this LINQ code.

    Public Sub linqdb()

        Dim DBconn As New GetProductListDataContext()
        Dim Q = _
        From p In DBconn.GetTable(Of Product)() _
        Where p.IsEnabled = "1" _
             Order By p.PName Descending _
        Select p
        Dim L = Q.ToList
        MyRep.DataSource = Q
        PValue.Text = L.Count().ToString()

    End Sub

 How do i also get this code to Count the outgoing records !?
I cant get any number from PValue.Text = L.Count().ToString()
from my CB to my .ASPX site with a <asp:Label ....

Code Optimized Web Development Profile (VS 2010 and .NET 4.0 Series)

When you first run VS 2010 it prompts you to select an IDE profile to use. The profile you select will configure how tool windows are displayed/docked in the IDE by default and set the default keyboard shortcuts. You can then customize any of these settings by using the Tools->Options menu within the IDE and then override/change them. You can also later reset your profile and pick a different one by choosing the Tools->Import and Export Settings menu command.

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.

LINQ : Implementing IN and NOT IN

I got tried of typing

var result = from s in source
where items.Contains(s)
select s;and so I implemented the IN and NOT IN methods as extension methods:

101 LINQ Samples Tutorials

101 LINQ Example with sample code snippets....This sample prints each element of an input integer array whose value is less than 5. The sample uses a query expression to create a new sequence of integers and then iterates over each element in the sequence, printing its value

Free Code Snippets - ASP.NET

You Can Find Useful ASP.NET Related Posts on the above link.

Free Code Snippets - C#

Free C# Code Snippets

Linq: how to share parameters between lambda expressions ?

When using Linq to objects, you will quickly feel the need to pass some parameters from a method to another but it's not so easy because each Linq method is not calling the following one. In a Linq sequence, each method is using the result computed by the previous one. So, local contexts are not visible from one method to another.
The compiler is using two technical different ways to let parameters go out of a method.
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