You must Sign In to post a response.
  • Category: SQL Server

    Sql query based on northwind db

    Hi,


    Table structure in following web page link:

    https://northwinddatabase.codeplex.com

    using northwind db.

    My query is to get list of all the orders processed based on category name.
  • #766426
    Hi

    So what?

    What is your issue . Can you share your problem .

    post your code then explain your problem then only who saw your questions reply soon thats better for you.

    Name : Dotnet Developer-2015
    Email Id :kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #766429
    Hi,

    Whatever database you may use, logic are same.

    Kindly share at where you found problem.

  • #766431
    What is your database structure, Please post it so that we can help you better in order to resolve your issue. post your data that already enter in database so that we can help you
    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #766439
    Hi,

    Whatever the database it is, you should pass appropriate connection string for open the connection to sql server, for NorthWind database you need to download Microsoft free sample Northwind database and Install the same, refer below link to understand more about downloading and installing.

    http://www.aspsnippets.com/Articles/Install-the-Northwind-and-Pubs-Sample-Databases-in-SQL-Server-Express.aspx

    Once Installing done successfully then you need to open connection string for fetch the data from database and bind the same to your controls.

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/


Sign In to post your comments