Introduction of ADO.NET Entity Framework with Examples

By // No comments:
We have already Learned how to access data from database through the concepts of ADO.NET, SQL and Language Integrated Query(LINQ) from any applications.
Why do we use ADO.NET Entity Framework in Data centric Applications:-
There are following reasons to use ADO.NET Entity Framework in Data centric application generally.There are some advantages and disadvantages as given below.
Suppose ,we want to develop any database for a project first earlier,a conceptual schema has to be designed based on which the logical schema or model is designed to develop a project.we  first had to design a conceptual model on a paper or a whiteboard.This was a time consuming and error-pron process,where the developer had to remember every details of data on which the conceptual model was based.We could not even work with entities in our application in the executable form.
3

How to implement transaction on website using ado.net

By // 3 comments:
In previous tutorials  tutorial ,i have already  explained transactions in sql server.But now i am going to explain transactions  in real asp.net application.We can provide a save point to divide a transaction into sub logical transaction,Means if there are set of instruction in a transaction which must be executed and a set of statement will be executed or Rollback on dependent on some condition.Here we can provide a save point to those statement which must be committed. 
There are some steps to implement this concepts on website which are given below:-
Step 1:- First open your visual studio -->File-->New-->website-->select ASP.NET Empty website -->OK-->open  solution explorer -->Add a Web Form-->drag and drop Label ,Text Box and Button control from toolBox as shown below:-
3

How to connect database through oleDb in ADO.NET

By // No comments:
In this tutorial,i am going to implement 'How to connect database(sql,mysql,oracal) through oleDb'.we can connect any database through oleDb but we can connect only sql database using Sql .For oleDb uses oleDbConnection but for Sql  uses SqlConnection.We can use Disconnected Architecture in oleDb connection also.
  • For oleDb we use following Namespace which are given below:-
         using System.Data.OleDb;
  • For Sql we use following Namespace which are given below:-
           using System.Data.SqlClient;
We can connect any database through oleDb using c# in Ado.Net.I have implement both concepts on same table (students) in master database of sql server.
There are some steps to implement this concept on windowsFormsApplication(use website also) which are given below:-
3

How to create Constraints in ADO.NET Application

By // No comments:
In this tutorial ,I am going to explain "How to use constraints in Ado.Net application ".This is very important concept on the basis of security.All constraints,which are used in .NET applications,are used for some specific purpose.All the constraints basically provide some restriction for end users.If any user want to access or modify the information, then he can't access or modify all information because developer already putted some restriction for accessing the information on your application .
I have already explained all constraints in Sql Server tutorials as
Please Read above links so that you can easily implement each constraints in below application.There are some steps to implement this concept in ado.net application which are given below:-
3

How to use different connection strings in asp.net application

By // No comments:
There are some connection strings in asp.net for database connectivity.There are mainly two architecture are used in ADO.NET for database connectivity in asp.net application.
  1. Connected architecture
  2. Disconnected architecture
If we add .mdf file(database) in asp.net application(website) or create table in sql server database then we can use different connection strings for database connectivity.I have seen many students face problem in database connectivity in asp.net application. that's why i am going to explain database connectivity in asp.net application.In this tutorial i am going to insert some values in table with help of different-different connection strings.You can use any of one connection strings to perform the insertion,deletion and updation operations in database.It is very easy concept.If you understand this whole concept which i have explained below then you never face any type of connectivity problem in database in future.  
  In below application i have performed only insertion operation with the help of different connection strings.In this application i have used six different connection strings(only four main strings) which are given below.
3

How to search related data from database in asp.net like Google

By // 4 comments:
Hi friends you will have to seen there are lots of records in database at this time.In this tutorial i will explain how to make search to user friendly in asp.net application.you can easily search related data from the database.In this application you can search lots of data by entering the single character in search box. Google also search lots of records from the database or cache memory like this application but it use very complex algorithm.This concept is also known as Dictionary search algorithm.But we can not compare with Google search engine. To provide relevant search to your user you can use this concepts on your asp.net application.
There are some steps to implement this concept on your asp.net application which are given below:-
Step 1:- First open your visual studio-->File--> New -->website-->select ASP.NET Empty website--> Add-->open Solution Explorer-->Add a New web form --> drag and drop label ,Text Box, SqlDataSource and Gridview control from toolbox as shown below:-
3

Ado.Net Application

By // 2 comments:
Hi Friends ! Today i am going to make a ado.net Application in .NET.In this application if you select one value from comboBox then  all values related to that id will display on the textBox  Fields.This is very useful concept for you ,if  you want to make any Application in  .NET.If you understand this concept then you will relate any problem with this concept when you are making any .NET Application.You can solve big problem very easily.Because all big problem are collection of  some small problems.
If you will follow these steps which is given below then you will become good application Developer in.NET  after few month.You can download whole application from bottom.
Step 1  First open Your MSSql Server->create a student table which has three Fields and insert some values which is given below in image:-
3

DataSet and DataAdapter in C#

By // No comments:
Hi Friends! here i am going to show you "how can Make the Dataset and Data-Adapter using coding" in disconnected architecture. There are some steps please follow one by one which are given below.
Step1:-  First open your visual studio-> File-> New project -> select windows form application->click OK.-> Drag and Drop Data grid-view control  and one Button control from the Toolbox.
3

How can Create Dataset and Sql Data-Adapter using through Menu in Disconnected Architecture

By // 1 comment:
Dataset:-  Dataset is a cache memory where data resides. To represent this cache memory we have Dataset class which resides within System.Data Namespace.One Dataset can contain more than one tables.In windows application Sql Data-adapter and Dataset can be created either through menu or by writing the code.Here we are discussing how to create Sql data-adapter and Dataset using through Menu.

3

Using Connected Architecture Display the Table 's Column Data in Combobox

By // No comments:
There are two type of architecture in Ado.Net. which is given below:-
  1. Connected architecture
  2. Disconnected architecture
Now here i am going to discuss about connected architecture:-In connected architecture application directly connected to the database.
3

Ado and Ado.Net In .NET

By // 2 comments:
It is data model which is used by .net application for doing data manipulation with database.Ado means Active Data Object.Before the Ado.Net there was 'Ado' used for connectivity and data manipulation with database.But There are some difference b/w Ado and Ado.Net:-


3
Powered by Blogger.