Where should I write the database code in asp.net?

Asked by Last Modified  

4 Answers

Learn .Net

Follow 9
Answer

Please enter your answer

Ranjan Panda

Angular Trainer

You should write the Database Code in the Data Access Layer. Hope that helps.
Comments
Dislike Bookmark

Microsoft Azure and .Net Trainer with total 12 years of exp

You can use 3 layer architecture for your simple application and can write database code to your dedicated DAL which is Data Access Layer. It is good idea to keep Database related operation separate.
Comments
Dislike Bookmark

Sr. Software Engineer (Also Part time trainer)

Asp.net page divide into two part one is aspx and another is aspx.cs .so u can write SQL code on cs file .but first you should have knowledge about ADO.net Programming .this is very basic database programming in asp.net
Comments
Dislike Bookmark

Experience Trainer for C, C++, .Net, Java, Python, Php, Networking

You will write that in SQL Server.
Comments
Dislike Bookmark

View 2 more Answers

Related Questions

How MVC works in ASP,net?
The Model-View-Controller (MVC) architectural pattern separates an application into three main components: the model, the view, and the controller. The ASP.NET MVC framework provides an alternative to...
Mukul
U can host an application in ASP.NET using HTTP and File System, what will be the difference? why HTTP requires? is it mandatory to use IIS for latest ASP.NET applications too?
IIS is a deployment server. If you don't use HTTP while creating web application or if you don't install your web application in IIS, visual studio use IIS express IIS express is Development server,...
Pavan

Hi,

I have asp.net project with sql connection.I want connect database with asp.net and run the project and web config file there
In web.config: <connectionStrings> <add name="ConnectionString" connectionString="Data Source=192.168.1.25;Initial Catalog=Login;Persist Security Info=True;User ID=sa;Password=example.com" providerName="System.Data.SqlClient"...
Fathima
Hi, We are starting new asp.net C# SQL Server batches by Microsoft certified Trainers Those who are interested can let me know by reply this post or message as soon as possible. Fee only 8000 Rs with IT project and interview preparation Our Course Detail 1. Asp.net 2. Sql Server 2008 3. C# 5.0 4. Window application 5. WCF 6. WPF 7. Asp.net MVC 4.0 8. CSS 9. Ajax 10. JavaScript 11.Silverlight Basic 12. 3 Tier Architecture 13. One Live IT project Our Strength 1. Trainers are working in MNCs as Technical Lead and have completed many projects successfully in these technologies. 2. In our course we have 30% theory and 70% practical that makes learning more interesting. 3. All topics covered with a Demo and followed by an Assignment to make learning more practical. 4. 100% fee back guaranty within one week without any condition. 5. You will get work on One Live Project with full Project Architecture 6. 100% Interview Preparation and Professional Resume Creation 7. Career Guidance Training - asp.net C# SQL Server Duration – 2 months Fee - Rs. 10,000 Batch Capacity – 12 Maximum
I m interested but i can do only weak end batches bcz i m working in it sector . location of the class ?
Sujit b
0 2
9
How should I prepare IIt I'm in class 8th
You should start with basic programming like C & C++, this will help to make strong foundation of your career after that you could start any language training like .net, C#.net, java android etc...
Om

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Inversion of Control
Problem You have classes that have dependencies on services or components whose concrete type is specified at design time. In this example, ClassA has dependencies on ServiceA and ServiceB. Figure 1 illustrates...

Ranjan P.

1 0
0
advantages of stored procedure in ado.net
The benefits of using stored procedures in SQL Server rather than application code stored locally on client computers include. 1. They allow faster execution: overall request-response...

Suprio Dutta

0 0
0
ValidateAntiForgeryToken used in ajax request in MVC
Today we learn how to use antiforgery token validation Key in ajax reqeust (MVC) first we create a Action with attributes antiforgery key.. Now we add @Html.AntiForgeryToken() in view and then create...

Suraj Ghosi

0 0
0
Steps to fill drop-down value from database to view page in ASP.Net MVC Application
In simple few steps you can fill the dynamic data from database to HTML page in MVC Application Write connection string in web config file Create table related getter setter in model Fetch data...

Jaffrena Michael Thomas

0 0
0
.NET With AngularJS Training Program Syllabus
What You will Learn in .NET with AngularJS Training Program? Introduction to .Net: Features of .Net, CTS, CLS, CLR and MSIL. C# & .Net Basics and Branching & Flow Control. OOPs Concepts,...

Decode Classes

0 0
0

Recommended Articles

What is Applications Engineering all about?

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Find .Net Training near you
.Net Training in Bangalore
.Net Training in Hyderabad
.Net Training in Pune
.Net Training in Chennai
.Net Training in Delhi
.Net Training in Mumbai
.Net Training in Noida
.Net Training in Kolkata
.Net Training in Gurgaon
.Net Training in Jaipur
Online .Net Training

Looking for .Net Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you