- .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)
Monthly Archives: October 2012
How to add manually columns to Gridview in ASP.Net. Add columns in gridview control in asp.net c#.
Maintain scroll position after Post back is fired in ASP.Net C#. Maintain scroll position means After post back event fired the page position same as before.
Difference between .ToString() and Convert.Tostring() in .NET
Send email in ASP.Net
Send E-mail in ASP.Net 2.0 is easy task…
First Add Namespace System.Net.Mail to send email.
Send email using C#
<%@ Import Namespace=”System.Net.Mail” %>
protected void Page_Load(object sender, EventArgs e)
//create the email message
MailMessage email = new MailMessage();
//set the from addresses
email.From = new MailAddress(“firstname.lastname@example.org”);
//set the to Address
//set the email subject and body , message
email.Subject = “Subject of Email – MeeraAcademyl”;
email.Body = “This is the Body of Email / Message of Email.”;
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
How to Create Stored Procedure in SQL-Server?
Stored Procedure is write SQL Query in Specific format in SQL Server and call them from your application, instead of writing queries inside your program code.
Stored Procedures are precompiled Transact-SQL statements which is stored in a SQL Server database.
Stored procedure is a simple SQL Statement, which is precompiled.
STEP 1 – Open the SQL Server management studi0
STEP 2 – Create a New Database
STEP 3 – Expand the DataBase name, Select the Programmability folder —> Stored Procedure.
Here, we will learn how to create XML using Query:
Here SQL statement “FOR XML RAW” creates one XML node for every corresponding row in database and columns will be created as attributes of that XML node. Results:
XML RAW (
SQL ELEMENTS create Elements instead of Attributes in xml
XML RAW (