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


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

Find individual customers how have not ordered a product

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
 
I need to find any and all customers who have not ordered a product or products. For example, If I have 5 products, I need to know who did not order which products? I have 2 tables: OG table with fields: Line #, Prod Nbr, Desc and Price and Orders table with fields CustName, Cust#, Prod Nbr QtyShipped I am not an SQL expert. Thank you very much for any help you can provide.


View Complete Post


More Related Resource Links

How to Get Total Sales for Customers that ever bought Product X

  

Hi,  does someone know ?
A) How to Get Total Sales for Customer(s) that ever bought Product X     ?  (including/excluding Product X)
B) How to Get Total Sales for Customer(s) that never bought Product X   ?

How to do this in MDX and in Excel Pivot ?

Thanks,

 


How Does the Association Model Predict the Products for Individual Customers?

  

Dear All,

I have built an Association Model , now i am applying this model to the same data on which the model is built.

For many of the customers there is no products getting suggested , for few customers products are getting suggested, Please let me know how the model is suggesting products for few and nothing for most of the customers.

 

Thanks in Advance


How to find the max version of a Product stored in a table?

  

Hi,

I have a table in which column name is Product_Verion, whcih stored a string value of the versions released in that product. eg like

Product_Version (Column) in Table Product_Details

1.0.33.18

2.2.0.19

10.2.45.67

9.3.5.89

7.1.18.259

10.1.56.987

10.2.43.76

10.2.45.81

 

how to get the latest version? I know we need to parse the "." and check the max version. I am thinking of replacing the ('.') and then take only the numbers in as single digit and get the max digit. Will it give the max version. Please let me know if you have any other better way.

Thanks,

Krishna.


Krishna

Can not find TUTORIAL directory after downloading the "SQL Server 2008R2 product code samples" pack

  
Any ideas on how to optain the TUTORIAL directory that should be in C:\Program Files\Microsoft SQL Server\100\Tools\Samples? I installed the 2008R2 product samples package several times? What is up with it?

Edit GridView Individual Cells in ASP.NET

  
The ASP.NET GridView allows for a row of data to be edited by setting the EditIndex property of the GridView, placing the entire row in edit mode.

You may not want the entire row in edit mode if you are using DropDownList controls for several columns in the EditItemTemplate. If each DropDownList has many options then loading them all at once may result in a sluggish page. Also, if your data structure is more like a 2 dimensional array rather than a set of rows, you may want to edit each cell individually.

Here I will demonstrate how to achieve this and also how to deal with event validation without disabling it.

Edit Individual GridView Cells in ASP.NET

  
The ASP.NET GridView allows for a row of data to be edited by setting the EditIndex property of the GridView, placing the entire row in edit mode.

You may not want the entire row in edit mode if you are using DropDownList controls for several columns in the EditItemTemplate. If each DropDownList has many options, then loading them all at once may result in a sluggish page. Also, if your data structure is more like a 2 dimensional array rather than a set of rows, you may want to edit each cell individually.

find a Control inside a GridView using jQuery

  

I have databound GridView in my page and I have a hidden DIV in all rows. Each row contains a Button that I want it to make the DIV visible for me! how can I use that with jQuery?!


here is the code page: 


<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                                EnableModelValidation="True" GridLines="None" ShowHeader="False" Width="100%">
                                <Columns>
                                    <asp:T

Is there any way to find out the reason for session expiry?

  

Dear All,

is there any way to find out the reason for session expiry?

Regards

Denny


Cannot find ASP.NET tab on IIS6+2003,how to choose .NET framework 4.0?

  

Hi all,

I just wanna setup a .net framework 4.0 on my VPS for a new site. While I could not find the ASP.NET tab on properties. I did some research find some similar problems but haven't fixed it yet.

Any suggestion would helpful.

Thanks.

 


Individual field - MySQL

  

Hi


I was wondering how to recieve an individual field from my MySQL database.

I have been able to get a row, but what I am trying to do is get a name from my database and set it into the HeaderText in my DataGrid.

The way I am trying to do it at the moment is

using (OdbcCommand cmd = new OdbcCommand(formQuery, con))
            {
                con.Open();
                formDataGrid.Columns[0].HeaderText = cmd.ExecuteReader(
                    CommandBehavior.CloseConnection |
                    CommandBehavior.SingleResult).GetValue(0);
            }

This doesn't seem to get a value from the GetValue, but if use

using (OdbcCommand cmd = new OdbcCommand(formQuery, con))
            {
                con.Open();
                formDataGrid.DataSource = cmd.ExecuteReader(
                    CommandBehavior.CloseConnection |
                    CommandBehavior.SingleResult);
                formDataGrid.DataBind();
            }


it will bind my data into the grid.

I just want to be able to change the HeaderText in the first coulmn of the DataGrid from one table and have the DataGrid be filled from another table.

I can fill the DataGrid its just changing the HeaderText that I am having trouble with.

Any help?


Default page for my Forlder(product)?

  

Hai all,

         I need to show the URL like this http://www.saffronrouge.com/face/moisturizers

for me  http://www.mysite.com/products/

i need to list all the products. please help me on this.


Using loginName to find ADInfo from an outside class

  

Hi,

I wrote a class to pull adinfo and for the life of me I can't seem to figure

out why it says "Invalid Login Name" no matter what I type in. If I leave

it blank it seems to work properly but it doesn't seem to be actually searching

the AD. I'll drop the whole class here, it's being initiated by a button click

on an outside form.

 

Thanks in Advance for any help Offered,
Postholes

 

 

Imports System.DirectoryServices
Imports Microsoft.VisualBasic
Imports System.String
Imports System.Collections
Imports System.Security.Principal
Imports System.Security.Permissions

Namespace LoginButton
    Public Class LoginButton

        'Class Variables
        Dim UserID As String = Nothing
        Dim DomainDN As String = ConfigurationManager.AppSettings("myConnectionString")
        Dim ADEntry As DirectoryEntry = New DirectoryEntry(DomainDN)
        Dim objSearch As New System.DirectoryServices.DirectorySearcher(ADEntry)
        Dim oResults As DirectoryServices.SearchResultCollection
        Dim oResult As DirectoryServices.SearchResult
        Dim RetArray As New Hashtable
        Dim page As Page = DirectCast(HttpContext.Current.Handler, Page)
        Dim TextLogin = DirectCast(page.FindControl("

LDAP - Can't find server

  

Hey people,

I would like to get a persons name from their username - a common query on forums i know, but i haven't managed to get mine working yet and any help would be appreciated.

I currently have this code that I found here: http://www.vbforums.com/showthread.php?t=612655 (Thanks Chris128)

I have adapted it from VB into VB.net. The page renders but when i enter my username into the Username textBox and hit the submit button (Which calls IsUser) I just get "The specified domain either does not exist or could not be contacted." I have tried lots of other code but I always get this response...

If anyone can help by posting links to a tutorial or another post for code that they know works, i will give it a go.

Cheers,
Jim

Imports System.DirectoryServices

Partial Class UserInfo
    Inherits System.Web.UI.Page

    Private Function GetRealNameFromAd(ByVal UsernameToFind As String) As String
        Using searcher As New DirectorySearcher(New DirectoryEntry())
            searcher.PageSize = 1000
            searcher.SearchScope = SearchScope.Subtree
            searcher.Filter = "(&(samAccountType=805306368)(sAMAccountName=" & UsernameToFind & "))"
            Using Results A

Could not find default endpoint element that references contract 'CurrencyProxy.CurrencyServiceSoap

  

Hi,

I created 2 projects in my solution:

  1. Classic asp.net web service (asmx)
  2. Class library project which references service
  3. web site project which references class library project
  4. Windows app project which references service.

Both projects were created in 3.5 framework and in Visual Studio 2008 Beta 2.

I added web service reference to Class library project. When it asked for namespace I typed "CurrencyProxy". Projects build ok, but when I run web app, Class library throws an error: Could not find default endpoint element that references contract 'CurrencyProxy.CurrencyServiceSoap' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element.

I believe it has something to do with app.config in Class library project. Here is part from app.config:

 <system.serviceModel>
<bindings>
<basicHttpBinding>
<binding name="CurrencyServiceSoap" closeTimeout=

Asp to asp.net cant find Msxml2.XMLHTTP

  

Hi all i have this following code in asp and when i try this in .net it asks me to run in aspcompat=true mode which i dont want.
So i tried to DIM x as Msxml2.XMLHTTP but its not defined any suggestions on this. Thanks

xmlhttp = Server.CreateObject("Msxml2.XMLHTTP")
        On Error Resume Next
        xmlhttp.Open("POST", "https://xxxxx.cgi", False)
        xmlhttp.setRequestHeader("Content-Type", "application/x-www-form-urlencoded")
        queryString = "xxxRequestMode=X&xxxRequestData=" & Server.UrlEncode(xmlStr)
xmlhttp.Send(queryString)


 


Cant find vsi file for CSS Friendly Control Adapters

  

Hi guys

This is driving me crazy... I cant find the .vsi file for installing the CSS Friendly Control Adapters Project. Does anyone know where I can get this?

The following link: http://www.asp.net/cssadapters/ only leads to the CodePlex wiki where I can download the dll and a partial solution. Essentially, I'm looking for the source code to implement the Menu adapter.

Any help is much appreciated!


Editor's Note: Find Your Anchors

  

This month, Howard Dierking explores the value of maintaining a few discrete technology interests in order to avoid being swept away in a sea of buzzwords and new technologies.

Howard Dierking

MSDN Magazine September 2009


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