- .Net Errors (3)
- .Net Question (10)
- 3 – Tier Architecture (2)
- AJAX (2)
- ASP.Net (60)
- ASP.Net – SQL Server (7)
- ASP.Net Controls (16)
- ASP.Net Example (102)
- ASP.Net Objects (4)
- Blog (1)
- Blogger (1)
- C Program (82)
- FileUpload (2)
- JQuery (7)
- PHP (1)
- PROJECT (10)
- SQL (21)
- SQL Function (8)
- SQL-SERVER (24)
- Validation Control (7)
- Web Server (3)
- Windows Application (8)
Category Archives: ASP.Net – SQL Server
How to use LINQ in ASP.NET Web Application with C#. Connectivity between ASP.Net and SQL - Server using LINQ.
Databse Connection in Windows Application with ms sql server. DataBase Connectivity between Windows Application and mssql server using SQLConnection and DataAdapter in ASP.Net.
DataBase Connection in Windows Application with ms sql server using TableAdapter and StoredProcedure through Wizard in ASP.Net. Insert Data to ms sqlserver in Windows Application.
How to make connection between ASP.Net and SQL-Server using SQLCommand, SQLDataAdapter and SQLStoredProcedure in C#.
ASP.Net -SQL Server Connectivity using SqlDataAdpater method. connection between asp.net and sql server management studio 2008.
Database Connectivity between ASP.Net and SQL-Server
There are many method to make connection between ASP.Net and SQL-Server.
1. Connection using TableAdapter and StoredProcedure thought Wizards.
2. Connection using SQLCommand and SQLDataAdapter using StoredProcedure .
3. Connection using SQLDataAdapter and SQLConnection writing query in webpage.
STEP 1 – Open the SQL-Server and Create New Database for connectivity.
Now Create New Table “UserMst” in Database Example.
STEP 2 – Create Stored Procedure for Select Data.
Fiil up the Record in Created Table named UserMst
- There are many method for connecting ASP.Net Application to SQL-Server.
- We are discussing basic three method below for connection.Method IStep 1 - Import Namespace
Step 2 – Delcare SqlConnection
(Make Connection between Asp.Net Application to Sql Server)string strconn = “Data Source=COMPUTERNAME\\SQLEXPRESS;Initial Catalog=’DataBaseName’;Integrated Security=True”;
SqlConnection SqlConn = new SqlConnection(strconn);
Step 3 – Declare SqlDataAdapter
(SqlDataAdapter is a Bridge between DataBase and DataSet/DataTable)SqlDataAdapter SqlAdapter = new SqlDataAdapter(“select * from Table”, SqlConn);
Step 4 – Declare DataSet/DataTable and fill the data from DataAdapterDataTable DT = new DataTable();SqlAapter.Fill(DT);