Monthly Archives: October 2012

ADD Select button in Gridview control in ASP.Net

ADD Select button in Gridview control in ASP.Net C#. get selected value from gridview control using autogenerate select button in asp.net c#.

How to add manually columns to Gridview in ASP.Net

How to add manually columns to Gridview in ASP.Net. Add columns in gridview control in asp.net c#.

Bind Gridview in ASP.Net C#

Bind Gridview in ASP.Net C#. fetch data from sql server and bind to gridview control in asp.net c#.

Maintain scroll position after Postback is fired 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

Difference between .ToString() and Convert.Tostring() in .NET

Value Types and Reference Types in .Net

Value Types and Reference Types in .Net, difference between value type and reference type in asp.net.

What is Boxing and Unboxing in C#

What is Boxing and Unboxing in C#, conversion from value type to reference type and convert reference type to value type process known as boxing and unboxing.

Send E-mail in ASP.Net C# and VB.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(“meeraacademy@hotmail.com”);

//set the to Address
email.To.Add(“meeraacademy@hotmail.com”);

//set the email subject and body , message
email.Subject = “Subject of Email – MeeraAcademyl”;
email.Body = “This is the Body of Email / Message of Email.”;

read more

Databse Connection between ASP.Net and SQL-Server using Wizard

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

read more

How to Create Stored Procedure in SQL-Server?

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.

read more

Create XML using SQL Query in SQL Server 2008

Here, we will learn how to create XML using Query:

SELECTTOP1000 [Code]
      ,[Name]
      ,[Price]
  FROM[Temp].[dbo].[Product]
  FORXML RAW ('Product'),
  ROOT ('Products');
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:
<Products>
<ProductCode="1"Name="Computer"Price="100.0000"/>
<ProductCode="2"Name="Mobile"Price="250.0000"/>
</Products>
SQL ELEMENTS create Elements instead of Attributes in xml
SELECTTOP1000 [Code]
      ,[Name]
      ,[Price]
  FROM[Temp].[dbo].[Product]
  FORXML RAW ('Product'),
ROOT ('Products'),
ELEMENTS;

read more

Create Simple Chat Application in ASP.Net with C#

How to Create Simple Chat Application in ASP.Net with C#, online chat application in asp.net. Implement chat application in my asp.net website with C#.