MS Techno Blogging

CruiseControl.NET Server Configuration (ccnet.config)

2011-11-25T14:47:00.001-08:00

To configure the CruiseConrol.NET Server, the configuration file (ccnet.config) has to be configured and placed in the "server" folder which will be used by Cruise Control .NET for continuous integration. This sample file contains the settings for one of the test application created in Visual Studio. I have tried to configure all the possible settings which are used in practical situations.

This example uses Visual Source Safe (VSS) as the source control application which check for any modifications in VSS (IfModificationExists) every 60 seconds.If any check-in happen in VSS, CruiseControl will pick get the latest files and prepare a auto build.

ccnet.config file

<cruisecontrol>
<project name="CCTestApp" webURL="http://localhost/ccnet/server/local/project/CCTestApp/ViewProjectReport.aspx">
    <workingDirectory>C:\CruiseControlTest\BuildServer\CCTestApp</workingDirectory>
   <artifactDirectory>C:\CruiseControlTest\BuildServer\CCTestApp\Artifacts</artifactDirectory>
    <labeller type="defaultlabeller">
        <prefix>lblCCTestApp_build_</prefix>
        <incrementOnFailure>true</incrementOnFailure>
    </labeller>
    <sourcecontrol type="vss" autoGetSource="true">
        <project>$/CCTestApp</project>
        <username>t799153</username>
        <password></password>
        <ssdir>C:\Chandreshwar\PROJ\DOTNET\VSS_DB\</ssdir>
       <workingDirectory>C:\CruiseControlTest\BuildServer\CCTestApp\Source</workingDirectory>
        <cleanCopy>true</cleanCopy>
        <applyLabel>false</applyLabel>
    </sourcecontrol>
    <triggers>
        <intervalTrigger seconds="60" buildCondition="IfModificationExists"/>
    </triggers>
    <tasks>
        <devenv solutionfile="C:\CruiseControlTest\CCTest\CCTest.sln" configuration="release" executable="C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE\devenv.exe"/>
        <modificationWriter>
             <filename>modifications.xml</filename>
             <path>C:\CruiseControlTest\BuildServer\CCTestApp</path>
        </modificationWriter>
    </tasks>
    <publishers>
      <xmllogger logDir="C:\CruiseControlTest\BuildServer\CCTestApp\BuildLogs" />
    </publishers>
</project>
</cruisecontrol>

You can find the complete reference of all the configuration settings in CruiseControl.NET here.

Quick Introduction to Scrum - An Agile Methodology

2010-05-27T02:53:00.000-07:00

Its time for me to share the Agile approach of software development which we have applied to our projects since more than 6 months. Its the way I can remember what I worked on to be referenced in future instead of looking for material in my laptop or web community.

We have been using Scrum approach for software development and I really found very impressive with the shippable product at the end of each sprints. Believe me this approach really works which I was not able to assimilate before we planned to implement the process.

To answer what is Scrum, its an Agile approach to software development where project progresses in series of Iterations called Sprints. Each Sprint is usually 2-4 weeks with typically 5-9 members with following roles:

ScrumMaster - can be thought as a coach to help team to use Scrum and keep team members from any distractions.
Product Owner - representing stake holders.
Team - self-organized cross-functional team consisting of Programmers, Testers, Designers, Analysts.

Activities of Scrum:
Following are the main activities that are spanned throughout the iteration.

Sprint Planning Meeting -
This is the first activity for the iteration. Attendees for this meetings are product owner, scrum master, the team, business analysts, architects, database designers, etc.

First task in the planning meeting is to identify the resource availability during the period of sprint (e.g. of 10 days (2 weeks) of development/testing activity how many days each resource is available). Assuming all working at 50% productivity (distraction, un-predictable task), we arrive at total story point for the sprint (e.g. 6 resource available all 10 day comes to 60. Working at 50% productivity come to 30 story points). Story point can be thought as number of days and each story is estimated by story points rather than hours.

The product owner usually identifies the user stories before the start of planning meeting to reduce the time of discussion. Story can be thought as a brief feature description of work to be performed (e.g. multi funding enablement for reports) from the product backlog that need to be considered for the current iteration. Product owner along with Business Analysts explains all the stories well in detail to the team in order for them to estimate the tasks. Its not required that team members should come prepared for the meeting. They can ask all required questions till every one is very clear to estimate the tasks.

Estimation is done using "poker game" (cards with 1, 3, 5, 8, 13, 20, 40 points) where team, product owner, scrum master individually raises card to show how many point they feel for the story. Advantage of this is that all the members in the team estimate (cross team estimation) the stories which helps reveal any unknowns and assumptions. Estimate not only contains development tasks, but also involves designing, testing, deployment etc..

Upon completion of Planning Meeting, scrum master sticks the stories on the story board. Story board is any white board where is divided into 3 columns viz. Planned, Started and Done. From the image below, you can see that the each story is further broken down into tasks and put on post-its.

Daily Scrum Meeting -
Updating soon....

Sprint Review (Demo) -
Updating soon....

Sprint Retrospective -
Updating soon....

Customize your Blogger blog with a novel look and feel

2010-03-28T01:55:00.000-07:00

By this time you might have noticed the new layout of my blog with very unusual template as compared to out-of-the-box templates provided by Blogger.

You can now customize your Blogger Blog with new "Blogger in Draft". With new Template Designer introduced, you can customize look and layout of your blog to look dissimilar.

Go to http://draft.blogger.com/ and log-in using your Blogger account to use new templates as they are only available from here. Navigate to "Layout" and to the right, you will find "Template Designer" link to customize. (You wont find the "Template Designer" from www.blogger.com as this hasn't released yet)

Try now before they are released to all...

Official "Blogger in Draft": http://bloggerindraft.blogspot.com

Search Text in all SQL Server Objects

2009-10-09T05:49:00.000-07:00

Many time you come through a situation where you want to Search a text in SQL Objects such as table, stored procedure, views, triggers, etc.., but we don't get when required.

Below SQL Script will search any text assigned to @Search variable in all Tables, Users, Views, Functions, Stored Procedures, Primary Key, Foreign Key etc..

Script to search text in all SQL Server objects:

DECLARE @Search varchar(255)
SET @Search='xsp_get' -- GIVE YOUR SEARCH TEXT
SELECT DISTINCT
LEFT(so.name, 100) AS Object_Name,
LEFT(
CASE so.type
WHEN 'U' THEN 'Table - User'
WHEN 'S' THEN 'Table - System'
WHEN 'P' THEN 'Stored Procedure'
WHEN 'V' THEN 'Table - View'
WHEN 'TR' THEN 'Trigger'
WHEN 'C' THEN 'Constraint - Check'
WHEN 'D' THEN 'Default'
WHEN 'K' THEN 'Key - Primary'
WHEN 'F' THEN 'Key - Foreign'
WHEN 'L' THEN 'Log'
WHEN 'R' THEN 'Rule'
WHEN 'RF' THEN 'Replication Filter stp'
ELSE '<<UNKNOWN ' + so.type + '>>'
END
,25) AS Object_Type
FROM syscomments sc
INNER JOIN sysobjects so ON so.id = sc.id
WHERE text Like '%'+@Search+'%'
ORDER BY 2,1

Facade Pattern with C#

2009-09-13T12:26:00.000-07:00

Facade Pattern classified into Structural Pattern is unified interface that represents entire by hiding the complexities.

It provides the higher level interface which makes subsystem easier to use. It provides client with a single entry point which eliminates knowing the complexity of many subsystems beneath it.

In this pattern, facade object is aware of the responsibility owned by subsystem classes. It essentially delegates the client request to subsystem classes; whereas sub-system classes perform operation as assigned by facade object and doesn’t holds any reference to it.

Below is the sample class diagram demonstrates Facade pattern where client makes a call to Facade class and the subsystem operations are managed by facade thereby eliminating the client to directly deal with subsystems.

Code for Facade Class:

namespace MyProject.FacadePattern
{
public class Facade
{
private IValidateUser _validateuser;
private IAddUser _adduser;
private INotifyService _notifyservice;

public Facade()
{
_validateuser = new ValidateUser();
_adduser = new AddUser();
_notifyservice = new NotifyService();
}

public bool AddUser(User user)
{
if (!_validateuser.ValidateUser(user))
return false;

_adduser.AddUser(user);
_notifyservice.SendEmail(user);
}
}
}

< Back to Design Patterns

Decorator Pattern with C#

2009-09-10T20:47:00.000-07:00

Decorator Pattern classified into Structural Pattern which add responsibilities to objects dynamically.

A client application often needs to augment the services provided by methods of some class, by inserting some pre and post-processing tasks before and after the method calls. If distinct pre and post-processing tasks were to be carried out for different clients, the application logic would become complex by conditional statements, leading to a maintenance nightmare.

Consider a class where clients can invoke method to transfer files to and from some remote server. In addition to being able to upload and download files, the client application would also like to log all file transfer requests and perform access checks for each invocation.

An implementation based on the Decorator pattern would derive a class from FileTransfer and override the virtual methods, inserting the additional operations before and after calling the base methods. Client still continue to call the same method; however additional responsibility is added to the class without affecting other clients using the same functionality. Thus, Decorator Pattern allows dynamic and transparent addition and removal of responsibilities without affecting client code.

FileTransfer Class (used by multiple clients):
namespace MyProject.DecoratorPattern
{
public class FileTransfer
{
public virtual bool UploadFile(string url)
{
bool result;
// File Upload Logic
Console.WriteLine("File Uploaded to url :" + url);
result = true;
return result;
}

public virtual bool DownloadFile(string url, string localpath)
{
bool result;
// File Download Logic
Console.WriteLine("File downloaded to '{0}' from url '{1}'", url, localpath);
result = true;
return result;
}
}
}

Derive from FileTransfer Class:
namespace MyProject.DecoratorPattern
{
class Decorator : FileTransfer
{
//Additional Responsibility added without affecting client code, demonstrate Decorator Pattern.
public override bool UploadFile(string url)
{
bool result = false;
if (!AccessAllowed(url)) return result;
result = base.UploadFile(url);
LogActivity(url);
return result;
}
//Additional Responsibility added without affecting client code, demonstrate Decorator Pattern.
public override bool DownloadFile(string url, string localpath)
{
bool result = false;
if (!AccessAllowed(url)) return result;
result = base.DownloadFile(url, localpath);
LogActivity(url);
return result;
}
private bool AccessAllowed(string url)
{
bool result;
// URL access Logic
Console.WriteLine("Access Allowed to url :" + url);
result = true;
return result;
}
private void LogActivity(string url)
{
// Logic to Log Upload/Download Activity
Console.WriteLine("Activity logged for url: " + url);
}
}
}

< Back to Design Patterns

Strategy Pattern with C#

2009-09-09T17:44:00.000-07:00

Strategy Pattern classified under Behavioural Pattern encapsulates an algorithm inside a class.

Strategy Pattern is a class that has to perform strategically depending on user input, platform information and so on.. Depending on user input, a different algorithm will be used; however, the end result is the same.

To explain this through example, I have used three diferrent search algorighm, each with its own performance and accuracy trade-off. One of them is very computation-intensive, but does a more thorough job, while another is faster but generates results that may be inaccurate for very data. My application will ask the user for the desired performance and then invoke the appropriate algorithm. To this end, I will encapsulate my algorithms in classes that demonstrate Strategy Pattern.

iSearch.cs
This interface will be implemented by various classes with different search algorithm

namespace MyProject.StrategyPattern.Search
{
public interface iSearch
{
string Search(string keyword);
}
}

Search.cs
Having implemented all three algorithms in this manner mentioned below, I can now design the client that decouples it from the implementation details of any specific algorithm. The client holds a reference to the interface, and does not need to know anything about the concrete implementation of the interface.

namespace MyProject.StrategyPattern.Search
{

public class ListSearch : iSearch
{
#region iSearch Members

public string Search(string keyword)
{
return "Searched " + keyword + "with List Search Algorithm";
}

#endregion
}

public class TreeSearch : iSearch
{
#region iSearch Members

public string Search(string keyword)
{
return "Searched " + keyword + " with Tree Search Algorithm";
}

#endregion
}

public class BinarySearch : iSearch
{
#region iSearch Members

public string Search(string keyword)
{
return "Searched " + keyword + " Binary Search Algorithm";
}

#endregion
}

}

SearchKeyword.cs
Finally, I create an instance of the SearchKeyword class and, depending on user input, initialize it with the appropriate algorithm. The Test method of the SearchKeyword class invokes the Search method of the iSearch interface that every algorithm implements

namespace MyProject.StrategyPattern
{
public class SearchKeyword
{
private iSearch _search;

public SearchKeyword(iSearch Search)
{
_search = Search;
}

public string SearchString(string Keyword)
{
return _search.Search(Keyword);
}

}
}

< Back to Design Patterns

Singleton Pattern with C#

2009-09-08T22:12:00.000-07:00

Singleton Pattern which is classified under Creational Pattern which focuses on having only one instance of object at any given time.

To give an example, windows directory service which has multiple entries but you can only have single instance of it through out the network.

A singleton is the sole instance of some class.
It is most often the case that the singleton should also be globally accessible, and this is achieved by making the creation method/property public.
Note that in the code below, the class constructor is private to avoind creating instance of class.

Creating Class which will return only one instance:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MyProject.SingletonSample.Evaluation;

namespace MyProject.SingletonSample
{
public class Singleton
{
// Private Constructor to not allow to creating instance
private Singleton() { }

private static iEvaluation instance;

// Creates and maintains single instance of Evaluation Class
public static iEvaluation Instance
{
get
{
if (instance == null)
{
instance = new Evaluation.Evaluation();
}
return instance;
}
}

}
}

Creating Instance of Singleton class:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MyProject.SingletonSample.Evaluation;

namespace MyProject.SingletonSample
{
class Program
{
static void Main(string[] args)
{
EvalData ed1=new EvalData();
ed1.Name = "Aaaa";
ed1.Comment = "Added with ED1";
ed1.DateSubmitted = DateTime.Now;

EvalData ed2 = new EvalData();
ed2.Name = "Bbbb";
ed2.Comment = "Added with ED2";
ed2.DateSubmitted = DateTime.Now;

Singleton.Instance.AddEval(ed1);
Singleton.Instance.AddEval(ed2);

Console.ReadKey();
}
}
}
< Back to Design Patterns

Design Patterns

2009-09-08T20:21:00.000-07:00

Design Patterns are recurring solution to recurring problems in software architecture. A design pattern can solve many problems by providing a framework for building an application.

Design patterns which make the design process cleaner and more efficient, are especially well-suited for object-oriented languages such as C#. Existing design patterns make good templates for the objects, allowing you to build software faster, re-use the code, and a pattern which is acceptable organisation wide.

Design patterns can improve the extensibility of your applications and the reuse of your objects. Software design and architecture without a rudimentary understanding of design patterns is unthinkable. Most software applications and systems incorporate one or more design patterns which we all might have come across, but don't know them as patterns.

A design pattern is a description of a set of interacting classes that provide a framework for a solution to a generalized problem in a specific context or environment. In other words, a pattern suggests a solution to a particular problem or issue in object-oriented software development

There are three basic classification of patters:

~ Creational

Singleton Pattern

~ Structural, and

~ Behavioural pattern

Strategy Pattern

Simple Way To Output XML to Browser

2009-07-02T07:32:00.000-07:00

I have seen many Blogs and Posts where people do lot of hard work just to display the XML onto the web page. Well its very easy but people dont know which TAG do this

When you paste the XML on a .htm file, browser renders the XML Attributes as HTML attributes and displays the output. It wont display the way you see in a notepad file or in Visual Studio.

Some time during XML programming (I mean reading/writing/parsing/traversing), we get an error saying some issue with XML, but we can't see the extire XML because browser renders like a html file.

Without wasting more time, in order to print or show the XML content on browser, put the entire XML content in <XMP></XMP> tag and see the magic.

Below is the XML which I had put in a web page with and following 2 images shows the difference.

Output without <XMP></XMP> Tag:

Output with <XMP></XMP> Tag:

Similar Tags:
Display XML to Browser,
Print XML to Browser,
Output XML to Browser,
Viewing XML file in Browser.

Free Open source Encryption Software- TrueCrypt

2009-03-21T15:33:00.000-07:00

This is an amazing open source on-the-fly disk encryption software for Windows, Mac and Linux. You can encrypt entire disk (internal/external/USBs) as well as encrypt any files/folders into encrypted file which can be mounted later.

TrueCrypt has an fantastic feature of two levels of encryption which helps to protect the volume in case if you have to reveal the password. In this case he creates a Hidden Volume which will never be known to others and opened with another password. It uses Encryption Algorithm such as AES-256, Serpent, Twofish and mode of operation is XTS

Advantage is you don't need to decrypt every files/folders to view it. You just have to mount with correct password and it operates as normal volume.

Only disadvantage is that IF YOU FORGET THE PASSWORD, YOU WILL LOOSE ALL DATA.

READ THE DOCUMENTATION AND TUTORIAL BEFORE INSTALLING...

URL to site: http://www.truecrypt.org/
Download: http://www.truecrypt.org/downloads
Docs: http://www.truecrypt.org/docs/

Deleting Services Forcefully from Services MMC

2009-02-12T13:57:00.000-08:00

Few days back I modified my Windows Service .NET Application and compiled to MSI to be re-installed. Somehow during un-install process, service was not removed from Services Microsoft Management Console (MMC) and it came to my notice during re-installation of MSI.

As there is no Delete option available in Services MMC, it was becoming a nightmare to re-install it. Some how I found SC.EXE which is a command line program to communicate with Service Control Manager and Services.

There are many available options but what interested me is you can Create, Start, Stop, Delete a service with a Command Line.

Creating a Service:

sc.exe create PayCalcService binPath= "C:\Program Files\PaymentCalculation\paycalc.exe" DisplayName= "PaymentCalculationService"

Starting a Service:
sc.exe start PaymentCalculationService

Stopping a Service:
sc.exe stop PaymentCalculationService

Deleting a Service:
sc.exe delete PaymentCalculationService

Hope this helps for similar problems...

Shortcut to create Property out of Field - C#

2008-02-18T09:49:00.000-08:00

To create Property out of Field, you need to declare a field as private and create Property for the field. But now you can create Property out of Field with combination of three keys. Yeah..., its Ctrl+R+E.

Declare the field as private and press "Ctrl+R+E" on the field name. It will popup a dialog where you can set the name of property (its almost what you want). Click OK to create Property in your C# code.

Property gets created automatically on click of OK

Shortcut to implement methods and properties of Interface in inheriting class - C#

2008-02-17T11:22:00.000-08:00

Whenever you create an Interface and implement in a class, you need to remember and override all methods or need to verify whether all methods/properties are impmenented. Using shortcut below you can implement all methods and properties of an Interface in inheriting class with click to three keys... i.e. "Alt+Shift+F10".

In the example below, I have created Interface with two methods and one property. While inheriting this interface in a class named "Test", you need to press "Alt+Shift+F10" on interface to implement all the methods and properties.

Press "Alt+Shift+F10" and press enter to implement all methods and properties.

Shortcut to add Namespace automatically while coding in class file - C#

2008-02-17T10:51:00.000-08:00

While coding a class file, you might encounter situations where you come to know that namespace is missing and you need move to top of file and add a namespace by "using" keyword.

e.g. you are writing a DAL (Data Access Layer) and have to create a variable of "SqlDataReader". Suddenly you recognize that "System.Data.SqlClient" is missing (its a pain sometimes..). In this case you need to move top and type there.

Below is the shortcut for this problem. Taking above example, type SqlDataReader and press "Alt+Shift+F10" and press enter to create a namespace automatically.

Press "Alt+Shift+F10" to show Smart Tag and press enter to select first option.

You see, "System.Data.Sqlclient" got added without going and typing it...

Let me know your comments..

Shortcut to load MS Visual Studio faster

2008-02-17T10:38:00.000-08:00

There is a way to load MS Visual Studio 2005 or 2008 IDE faster than ever to save your time. There is always some time involved in loading IDE but using the command below you can load IDE faster.

Type the command in your Run dialog:
devenv /nosplash

Happy Coding!!!

HEROES happen {here} registration open for Bangalore, Mumbai and Delhi

2008-02-17T10:13:00.000-08:00

Registration for "HEROES happen {here}" event is open for Bangalore, Mumbai and New Delhi. Microsoft is celebrating the launch of Windows Server 2008, Visual Studio 2008 and SQL Server 2008. The event will bring together IT Pro's and Developers in your city to get an in-depth, up-close look at the new products and will give attendees an opportunity to meet with Microsoft employees and Partners who have been working on these new products.

Hurry and resigter yourself from link below:
http://heroeshappenhere.co.in/Register.aspx

OR

Bangalore - 4-March-2008
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032366983&Culture=en-IN

Mumbai - 5-March-2008
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032366992&Culture=en-IN

Delhi - 6-March-2008
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032366996&Culture=en-IN

Hurry and reserve fast, as there are limited seats and get your FREE GIFT!!

Dot Net Videos

2008-01-22T08:07:00.000-08:00

Wanna learn Dot Net from scratch to intermediate level... Reading from books would take too much of time and there are many vidoe sites I have seen on net including microsoft (http://asp.net/learn), but this one I have found a bit useful and sharing the link below:

http://www.dotnetvideos.net

Videos range from creating DAL layers, business logic layer, reporting, paging and sorting, acessing database to working with binary files, caching, working with batch data...

In order to view the videos, you need to register yourself and for timebeing its free, so go ahead and register yourself and start dot net...

Happy learning and let me know your comments....

Read Excel with C# ADO.NET

2007-04-16T10:01:00.000-07:00

Today I got a customer requirement where they had requirement to display data from Excel to their Web Site. I had done this with other earlier versions (ASP, VB), but never tried with .NET.

I thought this to be very difficult and might took enough time to fetch and display the data on site. This can be done easily through ADO.NET in very simpler way by manipulating the ConnectionString.

Below is the code snippet:

Thanks...

Read XML in Dataset with C#

2007-04-08T10:49:00.000-07:00

Instead of using looong approach to open, read and parse XML, I prefer reading XML with Dataset and process as required. Reading through Dataset will load all data into DataTable and DataRow and can be parsed as reqd.

Using the standard way to read XML (see other articles in blog for reading XML with recommended method) might be good, but remembering long and many lines of code to read and parse is again tedious.

Below is the code snippet:

Thanks...

Create Typed Dataset using C#

2007-01-08T22:09:00.000-08:00

In this article, i will provide complete overview of Dataset, difference between "Typed Dataset" and "Untyped Dataset", advantages/disadvantages of both and one example to how to create Typed Dataset with Visual Studio 2005 with literally no code to write...

Introduction:
Dataset is one of the new technology in ASP.NET and it maps the entire database in iteself which means it can have all the Tables, Columns, Relationship, Constraints etc. Having all these in Dataset, it makes itself a disconnected database in which you can make changes and later you can update against actual database. In other words we can say that Dataset is a mirror copy tables and being disconnected in nature it makes insert/update/delete operations much faster.
I assume you are aware of other ADO.NET components such as Connection, Command, DataAdapter etc..

Differences:

Typed Datasets are Tightly coupled datased which provides Type-Safe operation where fields of tables are mapped as property.
Uptyped dataset are one which we create programatically and its loosely coupled.
Typed: TypedDataSet.Categories.Name = "Beverages"
Untyped: UntypedDataSet.Tables("Categories").Row(0).Item(1)="Beverages"
Typed dataset reduces overhead and increases performance as they already have table schema with them.
Any type mismatch can be captured at compile time instead of run-time.
One disadvantage with Typed Dataset is if your table schema changes, you need to everytime change the Dataset's XSD file (which i will discuss later).

Creating Typed Dataset with Visual Studio 2005

To start creating Typed Dataset demo, I will be using Northwind Database. If you dont have this DB, you can download from MS Site. This will help us to be on same page and later you can try with your own database.

Finally we come here:

1. Start Visual Studio 2005 and create "New Project" and select "Web Application" and name the project as "TypedDatasetDemo". Reason for Web App is because you can see the code generated by visual studio. Same steps are applicable for WebSite too.

2. In "Solution Explorer", right click and select "Add New Item". Select Dataset from Dialog and name as "DSCategory.xsd".

3. Right click Dataset Designer and click Add->Table Adapter... to start with Wizard. You need to create new connection string if you dont have by clicking "New Connection" button. Click Next...

4. Give the name for connection string to be saved so it can be used next time. Click Next...

5. Leave with default selection of "Use SQL Statement" and click Next.

6. Paste the query in SQL Statement text area. "SELECT CategoryID, CategoryName, Description FROM Categories". You can even use "Query Builder..." button to create query by wizard.

7. In next screen, you need to mention the method name to "Fill a DataTable" and "Return a Data Table". This method will be used to fill DataTable and will be bound to control e.g. Grid View. Change the method name to "FillCategory" and "GetCategory".

8. Click "Finish" to complete the wizard.

Thats it... Typed dataset is created which can be used by web pages.

To complete this demo, we will create WebPage and load data into Grid View.

Open Web Page and drop "Grid View" and name as "gvCategory"
Switch to "Code View" of page and copy the code as mentioned below.

namespace TypedDatasetDemo
{
public partial class _Default : System.Web.UI.Page
{
DSCategoryTableAdapters.CategoriesTableAdapter cAdapter = new TypedDatasetDemo.DSCategoryTableAdapters.CategoriesTableAdapter();
DSCategory.CategoriesDataTable cDataTable;
protected void Page_Load(object sender, EventArgs e)
{
BindData();
}
private void BindData()
{
cDataTable = cAdapter.GetCategory();
gvCategory.DataSource = cDataTable;
gvCategory.DataBind();
}
}
}

My First Blog

2007-01-08T21:29:00.000-08:00

Hi... this is my first blog on this site... I created this blog a/c today and thought to start blogging on technical stuff on .NET 2.0, 3.0 and 3.5.

I will be posting articles from basic to advanced level and any solution to any critical issues.

Hope you find this site interactive and helpful :)

You can also let me know if you would like me to discuss on some topics.

Happy coding.....