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.
You must Sign In to post a response.
Category: SQL Server
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.
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.
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]
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/
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/
Return to Return to Discussion Forum