Tuesday, December 20, 2011

IComparer


class MessageCompare : IComparer<Messages>
{
    public int Compare(Messages x, Messages y)
    {
        if (y.Date.CompareTo(x.Date) != 0)
        {
            return y.Date.CompareTo(x.Date);
        }
        else
        {
            return 0;
        }

    }
}

Friday, December 9, 2011

Google Maps API V3 for ASP.NET


Introduction

Google Maps provides a flexible way to integrate maps to provide directions, location information, and any other kind of stuff provided by the Google Maps API in your web application. Although there are some articles in CP explaining about maps, in my article I am going to provide information about the latest Google Maps API V3 version. In this article, we will see some of the common techniques that are used with Google Maps. In order to work with the code sample explained below, you need to have some basic knowledge about JavaScript and C#.

Sunday, November 27, 2011

Master Pages and Themes

Introduction:
Master Pages in Asp.net allows you to control the layout, design and common controls of all the pages in the website/web application. With a single master page you can define the look and feel of your application which includes multiple content place holders. Along with Master Pages you can work with themes to provide the user with great User Interface. In this article we see an overview of how to
  1. Create a Master page with single and multiple content place holders,
  2. Add Content Pages,
  3. Nested Master Pages.
  4. Programming the Master Page,
  5. Creating themes for the application and
  6. Finally we will see how we can work with multiple themes.

Web.Config File - Asp.Net

Introduction

The time you start developing your web application until you finish the application, you will more often use the Web.config file not only for securing your application but also for wide range of other purposes which it is intended for. Asp.Net Web.config file provide you a flexible way to handle all you’re requirements at the application level. Despite of simplicity provided by the .Net Framework to work with web.config working with configuration files would definitely be a task until you understand it clearly. This could be one of the main reasons, that I have started writing this article.
This article would be a quick reference for the professional developers and for those who just started programming in .net, this article would help them to understand the Asp.Net configuration in an efficient way.The Readers may skip reading section "Authentication,Authorization, Membership Provider, Role Provider and Profile Provider Settings", as most of them are familiar with those particular settings.

Wednesday, November 9, 2011

Asp.Net Profile Provider

Introduction

In the Article "Asp.Net MemberShip and Role Provider.", We have seen how to conigure and use the in built Sql Server MemberShip Provider. In this continuation article, we will see the usage of SqlProfileProvider. In any application if you want to store the user information other than the Registration details like their address,user's interest, themes etc., you can use the SqlProfileProvider.

Implementing the SqlProfileProvider:

The Profile provider can be configured to the application by using the following settings in the web.config file.

Asp.Net Membership and Role Provider

Introduction

Asp.Net 2.0 provides built in controls to manage Membership in Web Applications. All these controls use Asp.Net providers that are loaded via web.config file. Membership provider and Role provider allows a complete system to maintain users information, authenticate and authorize the users. This article demonstrates how to use and configure the default Member ship and Role provider.

JavaScript for Asp.Net Developers

Introduction

JavaScript along with Asp.net helps u to build web applications which are robust and effective. In this article the most commonly used tasks which can be achieved in Asp.net by using JavaScript are discussed. The article describes the following content. JavaScript to perform validations, JavaScript client side API for Asp.net Server Controls, Call a JavaScript from code behind and Vice-Versa, Grid View alert for deleting, Pass the C# variables to JavaScript array, Pop-up in Grid View.

JavaScript Create User Wizard for Asp.Net

Introduction

Asp.net provides built in create user wizard for membership which can be customized automatically depending on the user requirements. But in some cases if you want your own custom create user wizard and then this articles explains you the way to achieve your requirement. The Designed control provides you the flexible way to implement the membership wizard for the user.

Background

Sunday, September 25, 2011

Welcome to My Blog

Welcome.
Welcome To Technowallet. This blog is a beginners guide to develop web applications using .Net Technologies.
All the articles helps u to quickly learn the related technologies. 

Thursday, September 15, 2011

GridView

GridView:
Displays the values of a data source in a table where each column represents a field and each row represents a record. The GridView control allows you to select, sort, and edit these items.
Working with GridView DataSource controls to display data:
GridView can be bind with any one of the following DataSource controls:
SqlDataSource
LinqDataSource
ObjectDataSource
XmlDataSource.
Without need to write any line of code directly one can directly bind the DataSource Controls to display the data in GridView. In the below examples we will work with SqlDataSource and ObjectDataSource controls.
1.       SqlDataSource:
2.      ObjectDataSource:
In general the ObjectDataSource control is used to bind the data from the business logic class. So, first we will take a look at how to create a class that can bind data to GridView.
Creating your Movie class:
Follow the steps to create the Movie Class:
1. Open visual studio, create a new Empty Web Site and save it in u r local directory with some name.
.
2.      Go to solution explorer add a new master page and then add a new content page.

Monday, September 12, 2011

Sql Command

Sql Command:

Sql Command is a connected class of Ado.Net Object model. Sql Command Class is used to perform various database operations over a given connection object (Sql server Database). Sql Command Class is used to perform both synchronous and asynchronous operations. The available methods and properties of Command Object allow you to execute a Sql query or stored procedure.

Saturday, September 10, 2011

Stored Procedure

Stored Procedure:

Stored Procedures are precompiled Sql server objects which store the Sql queries and executes whenever the stored procedure is called. In this tutorial we will see how to work with stored procedure. The following things are discussed in this article.
  1. Create and Execute Stored Procedure.
  2. Stored Procedure with parameter.
  3. Stored Procedure with output parameter.
  4. Return a value from stored procedure.
  5. Call a Stored Procedure from another Stored Procedure

Friday, September 9, 2011

Sql Data Reader

Sql Data Reader:

Data Reader object allows you to perform forward only read only operations over the database. Data Reader is another connected class of Ado.net and is one of the two available data storages objects of Ado.net object model.

Saturday, August 6, 2011

sql Dat Adapter


  1. Sql data Adapter:

Insert/update/Delete Records:

1.      Establish the connection to the sql server by using sql connection class.
        SqlConnection cnn = new SqlConnection("Data Source = .\\SQLEXPRESS; Initial Catalog = master;Integrated Security= true");

2.      Open the connection
3.      Execute the sql query to insert/update/delete the record(s) by using sql data adapter.
            SqlDataAdapter da = new SqlDataAdapter(new SqlCommand("Insert into student values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "')",cnn));
4.      Use one of the following combinations of properties and methods as per the requirements.
·        InsertCommand.ExecuteNonQuery();
·        UpdateCommand.ExecuteNonQuery();
·        DeleteCommand.ExecuteNonQuery();
·        SelectCommand.ExecuteNonQuery();

da.InsertCommand.ExecuteNonQuery();
            cnn.Close();

Alternately u can use SelectCommand.ExecuteNonQuery(); to perform insert/delete/update operations as shown below.
cnn.Open();
            SqlDataAdapter da = new SqlDataAdapter("Insert into student values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "'",cnn);
            da.SelectCommand.ExecuteNonQuery();
            cnn.Close();

5.      Finally close the connection.

Binding Source

Binding Source:

Retrieving Information from database by using Binding Source:
  1. Establish the connection to the sql server by using sql connection class.
  2. SqlConnection cnn = new SqlConnection("Data Source = abc;
    Initial Catalog = master;Integrated Security= true");
  3. Execute the sql query to retrieve information by using sql data adapter.
  4. SqlDataAdapter da = new SqlDataAdapter("select * from student", cnn);
  5. Fill the values in Data Set by using the sql data adapter.
  6. da.Fill(ds, "student");
  7. Bind the dataset as data source to the binding source.
  8. bs.DataSource = ds.Tables["student"];
  9. Bind the values to the controls.
  10. textBox1.DataBindings.Add("Text", bs, "studnetid");
  11. Repeat the syntax for all the controls. Use the binding source methods to navigate between the values.
  12. bs.MoveFirst();bs.MovePrevious();bs.MoveNext();bs.MoveLast();

Friday, June 17, 2011

Ado.net

ADO.NET is a set of classes that expose data access services to the .NET programmer. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational, XML, and application data. ADO.NET supports a variety of development needs, including the creation of front-end database clients and middle-tier business objects used by applications, tools, languages, or Internet browsers.
Ado.net Object Model:
Working with database in dot net now has become easier with Ado.net Object Model. Ado.net has wide range of classes which can be used flexibly to perform database operations. Before going to start working with ado.net we’ll understand the architecture of Ado.net. The Ado.net Architecture is basically classified into two classes:
1. The Connected Classes and
2. The Disconnected Classes