Learn & Enjoy With DOTNET

The Blog is Moved to TechTasks.net

2010-11-25T22:26:00.000-08:00

Chating , Sockets Programming in Dotnet

2009-05-01T09:36:00.000-07:00

I found some great tutorial for
Sockets Programming
Serial Communications
Incorporating Fingerprint Recognition
into Your .NET Application
Infrared Programming .
Fun with RFID
Interfacing with External Devices

Down lode Link

http://rs217.rapidshare.com/files/73353974/Practical_.NET_2.0_Networking_Projects_Jan_2007.rar

Privacy Policy

2009-04-06T11:30:00.000-07:00

* Google, as a third party vendor, uses cookies to serve ads on your site.
* Google's use of the DART cookie enables it to serve ads to your users based on their visit to your sites and other sites on the Internet.
* Users may opt out of the use of the DART cookie by visiting the Google ad and content network privacy policy.

DataBase(1)

2009-01-26T21:16:00.000-08:00

Connecting MySql With Asp.net Using ODBC Drivers

Connecting MySql With C# ASP.NET

Dotnet InterView Questions

2009-01-05T03:34:00.001-08:00

Go Through the following links

Dot Net - C#.Net(FAQ'S)

Dot Net - Asp.Net - Basic I(FAQ'S)

Dot Net - Asp.Net - Basic II(FAQ'S)

www.Dotnetquestion.info

CoolInterview.com

prepareforjob.com

GeekInterview.com

interviews.dotnetthread.com

TechPreparation.com

www.allinterview.com

Dotnetfaqs.blogspot.com

www.infosrama.com

placementhelper.blogspot.com

dotnethell.blogspot.com

dotnetinterviews.blogspot.com

List Of Forums

2009-01-05T02:28:00.000-08:00

If You have question,Post your question in the following forums you get no of answers from experts

http://forums.asp.net/

http://www.dotnetjunkies.com/forums/

http://www.c-sharpcorner.com/Forums/

http://forums.aspfree.com/

http://forums.msdn.microsoft.com/

http://www.dotnetspider.com/forum/

USEFUL LINKS AND BOOKS

2009-01-05T02:08:00.000-08:00

The Following Links Provides Good Collection sites free Books

Useful Sites For DotNet

Free Books For .NET

List Of Forums

Dotnet InterView Questions

Useful Sites For DotNet

2009-01-05T01:46:00.000-08:00

MSDN Home Page

Home The Official Microsoft ASP.NET 2.0 Site

The www.asp.net site is a portal site for the ASP.NET development community. From here you can download ASP.NET, download Visual Web Developer - a free web development tool, and ask questions on the forums."

Windowsclient.net

The Official MicroSoft WPF and windows forum Site

The Code Project

Your place for Visual Studio and .NET articles, code snippets, discussions, news and the best bunch of developers on the net.

www.codeguru.com

CodeGuru is about code. CodeGuru is about Gurus. CodeGuru is about so much more!

www.gridviewguy.com

By seeing the you misunderstands But the site is for complete Asp.net

4GuysFromRolla.com

4Guys is an online resource site for ASP and ASP.NET information!

www.dotnetspider.com

This site is for dot-net interview questions,jobs,tutorials,articles and it has the demo projects.This is very useful for the freshers to read the articles and tutorials and to see the demo projects

DotNetJunkies.com

This is a community Web site for developers using the Microsoft .NET Framework. DotNetJunkies.com has been online since July 2000.

www.c-sharpcorner.com

C# Corner is one of the leading community site where developers can share their source code, articles, tutorials, and discussions. Site has thousands of free source code samples, articles, tutorials, links, discussions

ASPalliance.com

ASPAlliance served as a shared hosting site for distinguished ASP and ASP.NET professionals to publish content on their own mini-sites, kind of an early form of blogging. Much of this can still be viewed at

www.w3schools.com

This site is famous for the web-technologies.This is useful for the Freshers.This site consists of HTML,XML,ASP,ASP.NET,SQL,JAVA SCRIPT.

www.code-magazine.com

Component Developer Magazine (CoDe) is on an aggressive growth path to become the number one Microsoft technology information resource, as reflected in our slogan, "Microsoft Technologies In-Depth for IT Managers and Developers."

Quickstarts.asp.net

The QuickStart Tutorials are the fastest way to understand what the .NET Framework technology offers leading-edge developers. Inside you'll find information about the most compelling features of the .NET Framework technology, including how to put them immediately to work for you or your company.

CoderSource.net

If you have really come to our site all the way through the web space, we can understand your desperation towards finding the code that you needed. If we have served your needs, we are the happiest because there is somebody who would like to use what we did. Our work and search doesn't go waste. The feeling is great.

Beansoftware.com

BeanSoftware Posts Articles on ASP.NET Tutorials,ASP.NET FAQ, .NET Windows Forms,General .NET Framework

123aspx.com

The largest Directory of ASP.NET Resources. Featuring extensive links to ASP.NET Tutorials, Tutorials, Examples, Code, Hosting, programming, basics, script, and more.

ASPWire

Active Server Pages: ASPWire - ASP News & Information Source

Devx.com

Devx is the leading provider of technical information and services that enable corporate application development teams to efficiently conquer development challenges and keep projects moving. We are committed to leading the market by offering customers timely, vital resources and superior services designed to enhance their efforts of applying new technologies and techniques

DotNetSlackers.com

Welcome to DotNetSlackers, providing you with the latest .NET news and articles, free blogs to express yourself about .NET and active forums to ask for or give help.

Code101

Code101 provides material on Microsoft .NET technology.

ASPFREE.com

ASP Help, ASP Tutorials, ASP Programming, ASP Code

www.xmlforasp.net

The XML for ASP.NET Developers Website now offers online video tutorials that help you learn ASP.NET, AJAX, XML and Web Service concepts visually.

Programmersheaven.com

This site is dedicated to programmers all over the world. Our main goal is to provide a complete starting point for programming related web surfing, file downloading and interaction.

CshapHelp.com

C# Help: Articles, Forum, Source Code

DotNet Gallery

The Site is an online interactive .Net learning guide which makes smart interaction with the people to give best idea of their own through discussion and forum. It also helps the beginners and make them to learn .Net easily by using sample projects, coding standards, and coding snippets provided in this site. It provides idea for smart programming through best coding standards.

ConnectionStrings.com

All connection strings accessible at one location. Find the syntax for your database connection and learn more accurate ways of connecting."

www.wilsondotnet.com

This site is my .NET v2.0 online home, where I try to create simple but helpful tools and share what I've learned in articles, forums, code, demos, and more. I try to focus on simplicity, best practices, architecture, and other advanced concepts, so you won't find yet another example of how to use a grid. I try to share some things freely with the community, including the WilsonWebPortal if you just want to use it as is and/or create your own modules

www.devsource.com

Developer Resource, Microsoft Programming, Visual Basic VB and .Net Development

Odetocode.com

.Net related Articles, Code and Resources

Beyond Web Logs

Discuss technology, web development, networks and more ...

Dotnetcurry.com

Come to where the .net flavour is....

DOTNETfunda.com

The Fundamentals of .NET

Developerfusion.com

developerFusion aims to bring together developers all over the globe, whilst delivering top-notch technical know-how.

We more happy with your Comment

Non Editable Rows in GridView

2008-12-29T01:53:00.000-08:00

In This example A GridView containes non editable rows,

Here We use “Bit” DataType for Editable colume in sql server

When we use “Bit” Datatype the gridview binds the colume with Check boxes automatically

Productid (int)	Productname (Varchar)	price (int)	editable (bit)
1	keyboard	500	True
2	Monitor	5000	False
3	mouse	400	False
4	HDD	3000	True

 <asp:GridView ID="GridView1" runat="server" AutoGenerateEditButton="True" DataKeyNames="productid,editable"
            OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowEditing="GridView1_RowEditing"
            OnRowUpdating="GridView1_RowUpdating" Style="z-index: 100; left: 222px; position: absolute;
            top: 75px">
        asp:GridView>
        <asp:Label ID="Label1" runat="server" Font-Size="Large" ForeColor="Red" Style="z-index: 102;
            left: 311px; position: absolute; top: 51px">asp:Label>

In .cs File

public partial class _Default : System.Web.UI.Page  
{
    SqlConnection con; SqlDataAdapter da; SqlCommand cmd; DataSet ds;
    protected void Page_Load(object sender, EventArgs e)
    {
        con = new SqlConnection("server=FOCALPOI-392A7D\\SQLEXPRESS;user id=raji;password=chekuri;database=raji");
        if (IsPostBack == false)
        {
            getdata();
        }
         
    }
    public void getdata()
    {
        da = new SqlDataAdapter("select * from product", con);
        ds = new DataSet();
        da.Fill(ds, "product");
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        Label1.Text = "";
        GridViewRow r = GridView1.Rows[e.NewEditIndex];
        CheckBox cb = (CheckBox)r.Cells[4].Controls[0];
 
//if the Check box in editable colume  is checked then the colume is allow to edit

//if not then it is non Editable colume
        if (cb.Checked)
        {
            GridView1.EditIndex = e.NewEditIndex;
            getdata();
        }
        else
        {
            Label1.Text = "This Is Non Editable Item";
        }
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        getdata();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        GridView1.EditIndex = -1;
        getdata();
    }
}

Validate DropDownList inside GRIDVIEW

2008-12-29T01:21:00.000-08:00

In Coding Page

<asp:GridView  ID="GridView1"  runat="server"  AutoGenerateColumns="False"  OnRowCancelingEdit="GridView1_RowCancelingEdit"  OnRowEditing="GridView1_RowEditing"  OnRowUpdating="GridView1_RowUpdating"  OnRowDataBound="GridView1_RowDataBound"  Font-Names="Verdana"  Font-Size="Small" style="z-index: 100; left: 41px; position: absolute; top: 66px" DataKeyNames="productid">

<Columns>

<asp:BoundField DataField="productid" HeaderText="ProductID" />

<asp:BoundField DataField="productname" HeaderText="ProductName" />

<asp:BoundField DataField="price" HeaderText="Price" />

<asp:TemplateField HeaderText="Choose">

<ItemTemplate>
<asp:DropDownList ID="DropDownList1"   runat="server" Width="100px">asp:DropDownList><br />
ItemTemplate>
<EditItemTemplate>

<asp:DropDownList ID="DropDownList1"   runat="server" Width="100px">asp:DropDownList><br />

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="DropDownList1" Display="dynamic"
ErrorMessage="Please Select the Rating" InitialValue="Select Rating">asp:RequiredFieldValidator>

EditItemTemplate>
asp:TemplateField>

<asp:CommandField ShowEditButton="True" />

Columns>

asp:GridView>

In .CS File

using System.Data.SqlClient;


public partial class _Default : System.Web.UI.Page  
{
    SqlConnection con; SqlDataAdapter da; SqlCommand cmd; DataSet ds;
    protected void Page_Load(object sender, EventArgs e)
    {
        con = new SqlConnection("server=FOCALPOI-392A7D\\SQLEXPRESS;user id=raji;password=chekuri;database=raji");
        if (IsPostBack == false)
        {
            getdata();
        }
    }


    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {


        if (e.Row.RowType == DataControlRowType.DataRow)
        {


            DropDownList ddList = (DropDownList)e.Row.FindControl("DropDownList1");
            //DropDown List First item is same as InitialValue propertie  
            ddList.Items.Add("Select Rating");
            ddList.Items.Add("1");
            ddList.Items.Add("2");
            ddList.Items.Add("3");
            ddList.Items.Add("4");
            ddList.Items.Add("5");




        }


    }


    public void getdata()
    {
        da = new SqlDataAdapter("select * from product", con);
        ds = new DataSet();
        da.Fill(ds, "product");
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }




    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        getdata();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        getdata();
    }


//we are not  doing any updation  
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        GridView1.EditIndex = -1;
        getdata();
    }
}

.Net Keyboard Shortcuts

2008-12-26T04:51:00.000-08:00

Key board shortcut keys always help to increase your speed. So i am giving below some of the Keyboard Shortcuts which will be very useful.

Ctrl + N :- Opens the New Project Dialogue Box
Ctrl + Shift + O :- Opens the Open File Dialog Box
Ctrl + Shift + A :- Opens Add New Item window
Ctrl + D :- Opens Add Existing Item window
Ctrl + F :- Opens Find window
Ctrl + H :- Opens Find and Replace window
Ctrl + Shift + H :- Opens Replace in Files window
Ctrl + Alt + Shift + F12 :- Opens Find Symbol window
F7 :- Opens Code Designer window
Shift + F7 :- Gets you back to Design View
Ctrl + R :- Opens the Solution Explorer window
Ctrl + Alt + S :- Opens the Server Explorer window
Ctrl + Shift + C :- Opens the Class View window
F4 :- Opens the Properties window
Ctrl + Shift + E :- Opens the Resource view window
Ctrl + Alt + X :- Opens the Toolbar window
Shift + Alt + Enter :- Takes you to Full Screen View
Alt+F8 :- Opens Macro Explorer window
F2 :- Opens Object Browser window
Ctrl + Alt + T :- Opens Document Outline window
Ctrl + Alt + K :- Opens Task List window
Ctrl + Alt + A :- Opens Command window
Ctrl + Alt + O :- Opens Output window
Ctrl + Alt + Y :- Opens Find Symbol Results window
Ctrl + Alt + F :- Lists Items under the Favorites Menu in your
Ctrl + Shift + B :- Builds your project
Ctrl + Shift + F9 :- Clears All Breakpoints
Ctrl + Alt + P :- Opens the Processes Dialog box
Ctrl + T :- Opens Customize Toolbox window
Ctrl + Shift + P :- Runs Temporary Macro
Ctrl + Shift + R :- Records Temporary Macro
Alt + F11 :- Opens Macros IDE
F5 :- Runs your Application
Ctrl + F5 :- Runs your Application without Debugging
Ctrl + Alt + E :- Opens the Exceptions Dialog Box
F8 :- Used while Debugging Applications
Shift + F8 :- Used While Debugging Applications
Ctrl + B :- Inserts a New Breakpoint
F10:-Line By Line execution
Ctrl+Tab:-To Shift B/W .net Editor Pages

Grid View Operataions

2008-12-25T23:34:00.000-08:00

GridView Update,Delete,Adding (Insert) Record...

Select All And Delete Using CheckBox In GridView

GridView Paging & Sorting

GridView DeleteAll,SelectAll,ClearAll(Server Side)

Change GridView Row Color When MouseOver

Alphabetical Paging in Gridview

Highlight GridView rows when condition is true

Non Editable Rows in GridView

Validate DropDownList inside GRIDVIEW

FAQ'S & INTERVIEW TIPS

2008-12-25T23:21:00.000-08:00

Dot Net - C#.Net(FAQ'S)

Dot Net - Asp.Net - Basic I(FAQ'S)

Dot Net - Asp.Net - Basic II(FAQ'S)

C#.NET

2008-12-25T23:20:00.001-08:00

Simple Calculator In Windows Application Using C#

ASP.NET

2008-12-25T23:07:00.000-08:00

Introduction ASP.NET

JavaScript Validatoin For Basic Controles in ASP.NET

ASP.NET Validator Controls

Connecting MySql With Asp.net Using ODBC Drivers

Mail Sending Using Net.Mail

Connecting MySql With C# ASP.NET

Store and Retrive Images From DataBase

Saving Uploaded file into Disk and displaying the content into TextBox

Writing Connection string in web.config file

Working With Command Builder in ASP.NET

DOTNET FRAMEWORK

2008-12-25T23:00:00.000-08:00

Introduction to Microsoft .NET

Projects With Source Code

2008-12-25T22:42:00.000-08:00

Hi Here we Are Providing Links To Get Projects with Source Code

www.1000projects.com

It is a good website for getting all example projects where you can get better knowledge about doing better projects on .net

More than 1000 projects with source code....

nopCommerce(shopping cart)

nopCommerce is a fully customizable shopping cart. It's stable and highly usable. nopCommerce is a open source e-commerce solution that is ASP.NET 3.5 based with a MS SQL 2005 (or higher) backend database. Our easy-to-use shopping cart solution is uniquely suited for merchants that have outgrown existing systems, and may be hosted with your current web host or our hosting partners. It has everything you need to get started in selling physical and digital goods over the internet.

Download sample Projects from Microsoft official Site CodePlex

CodePlex is Microsoft's open source project hosting web site. You can use CodePlex to create new projects to share with the world, join others who have already started their own projects, or use the applications on this site and provide feedback.

Library Management System

A simple library management system that provides following facilities login, register, add category, add / remove book, search / issue book, return book. Language used is C# and db is SQL server 2000 and SQL Client has been used in code.

Some sample Projects are provides by dotnetspider.com

BlogEngine.NET Web Site

BlogEngine.NET is a full-featured blogging platform that is a breeze to set up, customize, and use. BlogEngine.NET works with your choice of data source; you may use SQL Server, or you may take the plug’n’play approach using XML files.

Jobs Site Starter Kit

Jobs Site Starter Kit (JSSK) is an ASP.NET starter kit demonstrating many new features of ASP.NET 2.0 including themes, master pages, new data controls, membership, roles and profiles. JSSK is a web application that provides a platform for candidates seeking job and the employers to share their needs.

Starter Kits and asp.net Community ProjectsThe ASP.NET 2.0 Starter Kits for Visual Web Developer are fully functional sample applications to help you learn ASP.NET 2.0 and accomplish common Web development scenarios. Each sample is complete and well-documented so that you can use the code to kick start your Web projects today! These kits, once downloaded are integrated directly into the Visual Web Developer 2005 Express Edition or Visual Studio 2005 experience.

Attendance Analysis System:

“Attendance Analysis System” is developed, keeping in mind the requirements about day-to-day handling of attendance of the students by the faculties in the engineering colleges. By using Attendance analysis system, a lecturer can keep track of attendance of every student, analyze it and finally build a Microsoft Word based report.

ASP.Net - Shopping Cart

This is a fictitious Web Based E-Commerce Site developed for users who visit a typical shopping site for online buying . Apart from normal features of a sales site ,some value added features such as accessing Web Services, Credit Card validation, Emailing ,Report Generation using inbuilt crystal reports for managerial access have been added. I have also made a provision for adding new products,categories ,sub categories…….image uploading etc for the manager of the company.

eBilling and Invoice System

eBilling and Invoice System is a live project written in Visual Basic 6 programming language. It is a working solution. I give you complete project listing with all project file, source code, database, crystal reports. You can use this project as you want. You can free download all the project documentation, project source code, project executable files, database downlodefrom link. Code are well commented for your reference, however if you want any clarification you can contact me for further explanation.

IMPRO (Industrial Manpower Resource Organizer)

IMPRO is a live project written in VB.NET and SQL Server. It is a working solution. I give you complete project listing with all project file, source code, database. You can use this project as you want. I am not claim any copyright for this project. You can free download all the project documentation, project source code, project executable files, database from downlode link. Code are well commented for your reference, however if you want any clarification you can contact me for further explanation.

Sales Invoice System

This is a database project .which I made for my six month training.
It is very user friendly Once user has entered the information about the product ,there prices and supplier of the product all these fields will be automatically filled up in the invoice and purchase order form.

The following sites gives Hundreds of Examples With Source Code

SourceForge.net

SourceForge.net is the world's largest open source software development web site. We provide free services that help people build cool stuff and share it with a global audience.

planet-source-code.com

See all Visual Basic Categories of Code

The Below Example is One Of Those

Using TreeView, DataGridView, and WebBrowser to view and display records in an Access DB

The purpose of this sample application is to demonstrate the utilization of various controls in VB.NET that will allow you to access, view and display records in an MS Access database. I have tried to demonstrate, through usage of various procedures, functions and events how to: (1) Initializing a new Connection to an Access Database using the OpenFileDialog to search for the particular database, (2) Display records in a TreeView Control, (3) By selecting and expanding any one of the TreeView Nodes, you will be able to view selected items in a recordset in a DataGridView Control utilizing a DataTable as the DataSource, (4) Create, and populate selected items in an HTML report, (5) Display the HTML report(s) in a WebBrowser Control, (6) Display the HTML reports in your default browser. References: Add a reference to Microsoft ActiveX Data Objects 2.8 Library in order to access the MS Access Database. NOTE: If you using a version of VB.NET older than VB2008, you must first create a new project and than import all the files in this sample project before running it.

Sourcecodesworld.com

At Source Codes World.com, you can find thousands of categorised source codes and projects submitted by members for the growth of Feel free to use these source codes, but leave the credit to the author intact.

See all ASP Home

Sourcecodeonlinee.com

Source code online.com is provides free source code and scripts Downloads

Browse all ASP.NET Projests

Enter Text In Into Two TextBoxes At the Same Time

2008-12-06T00:26:00.000-08:00

In Coding Page

function makeSame()
{
document.getElementById('T2').value= document.getElementById('T1').value;
}

Here makesame() function is called with TextBox1 onkeyup event

<br />        <asp:textbox id="T1" runat="server" style="z-index: 100; left: 210px; position: absolute;             top: 130px" onkeyup="makeSame();"></asp:TextBox><br />        <asp:textbox id="T2" runat="server" style="z-index: 101; left: 209px; position: absolute;             top: 183px"></asp:TextBox><br />

Saving Uploaded file into Disk and displaying the content into TextBox

2008-12-05T23:58:00.000-08:00

Design

//in upload button click event write the bel0w code

protected void btnuplode_Click(object sender, EventArgs e)

{

fuplode.SaveAs(@"D:\\Raji\\ASP\\uplodefile\\uploadefiles\\" + fuplode.FileName);

StreamReader sr=new StreamReader ("D:\\Raji\\ASP\\uplodefile\\uploadefiles\\" + fuplode.FileName);

string content=sr.ReadToEnd();

TextBox1.Text = content;

sr.Close();

}

Writing Connection string in web.config file

2008-12-05T23:23:00.000-08:00

In Web.config file

In .CS file

string str = ConfigurationManager.ConnectionStrings["sqlconstr"].ToString();

string str1 = ConfigurationManager.AppSettings[0].ToString();

string str1 = ConfigurationManager.AppSettings["sqlconstrusingappset"].ToString();

//connection string using ConnectionString

con = new SqlConnection(str);

//connection string using AppSettings

con = new SqlConnection(str1);

con.Open();

Change GridView Row Color When MouseOver

2008-12-05T22:57:00.000-08:00

In .CS file

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

SqlConnection con; SqlDataAdapter da; SqlCommand cmd; DataSet ds;

protected void Page_Load(object sender, EventArgs e)

{

con = new SqlConnection("server=FOCALPOI-392A7D\\SQLEXPRESS;user id=raji;password=chekuri;database=raji");

con.Open();

da = new SqlDataAdapter("select * from product", con);

ds = new DataSet();

da.Fill(ds, "product");

GridView1.DataSource = ds;

GridView1.DataBind();

}

protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)

{

string onmouseoverstyle = "this.style.backgroundColor='red'";

string onmouseoutstyle="this.style.backgroundColor = 'white'";

string onmouseclickstyle = "this.style.backgroundColor = 'lightgreen'";

if (e.Row.RowType == DataControlRowType.DataRow)

{

//adds events to GridView row

e.Row.Attributes.Add("onmouseover", onmouseoverstyle);

e.Row.Attributes.Add("onmouseout", onmouseoutstyle);

e.Row.Attributes.Add("onclick", onmouseclickstyle );

}

DESIGN

Working With Command Builder in ASP.NET

2008-12-05T21:25:00.000-08:00

The CommandBuilder class is a part of the .NET Framework. Its purpose is to automatically build SQL INSERT, UPDATE, and DELETE statements for a DataTable based on a SQL SELECT statement.

When creating a CommandBuilder a DataAdapter is passed as a parameter to the constructor. This links the CommandBuilder to a DataAdapter allowing it to read the SELECT command that has been associated with the DataAdapter. It will use the SELECT command to extract the schema information from the Table in the Database. Using this schema information it can automatically build INSERT, UPDATE and DELETE Command objects and the required SQL statements.

The CommandBuilder is useful when the immediate updation are not required in DB, because CommandBuilder is Disconnected Object

When we use UPDATE Method of corresponding DataAdapter then only updation are reflected in DB

In .CS FILE

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

SqlConnection con; static SqlDataAdapter da; SqlCommandBuilder cb;

static DataSet ds; DataRow rec;

protected void Page_Load(object sender, EventArgs e)

{

if (IsPostBack ==false)

{

con = new SqlConnection("server=FOCALPOI-392A7D\\SQLEXPRESS;user id=raji;password=chekuri;database=raji");

da = new SqlDataAdapter("select * from Emp", con);

ds = new DataSet();

da.Fill(ds, "emp");

cb = new SqlCommandBuilder(da);

GridView1.DataSource = ds;

GridView1.DataBind();

}

//In ADD button Click method we add a record to DataSet(ds) Table

protected void btnadd_Click(object sender, EventArgs e)

{

rec = ds.Tables[0].NewRow();

//create a new record with stucture of the DataSet Table

rec[0] = Convert.ToInt32( TextBox1.Text);

rec[1] = (TextBox2.Text);

rec[2] = Convert.ToInt32(TextBox3.Text);

rec[3] = (TextBox4.Text);

ds.Tables[0].Rows.Add(rec);

//Add a new record to DataSet(ds) Table,At this time record is added in DataSet Only Couldt not replect in DB

GridView1.DataSource = ds;

GridView1.DataBind();

}

//In Get button Click method we retrive corresponding of given empno from DataSet(ds) Table

protected void btnget_Click(object sender, EventArgs e)

{

rec = ds.Tables[0].Select("EmpNo=" + int.Parse(TextBox1.Text))[0];

TextBox2.Text = rec[1].ToString();

TextBox3.Text = rec[2].ToString();

TextBox4.Text = rec[3].ToString();

}

//Delete a record from DataSet(ds) Table by using select command

protected void btndelete_Click(object sender, EventArgs e)

{

rec = ds.Tables[0].Select("EmpNo=" + int.Parse(TextBox1.Text))[0];

// rec Stores the delete record

rec.Delete();

// delete's the record from DataSet Table

GridView1.DataSource = ds;

GridView1.DataBind();

}

//Update a record from DataSet(ds) Table by using select command

protected void btnupdate_Click(object sender, EventArgs e)

{

rec = ds.Tables[0].Select("EmpNo=" + int.Parse(TextBox1.Text))[0];

rec[1] = (TextBox2.Text);

rec[2] = Convert.ToInt32(TextBox3.Text);

rec[3] = (TextBox4.Text);

GridView1.DataSource = ds;

GridView1.DataBind();

}

protected void btnclear_Click(object sender, EventArgs e)

{

TextBox1.Text = "";

TextBox2.Text = "";

TextBox3.Text = "";

TextBox4.Text = "";

}

//Update in DB

protected void btnupdatedb_Click(object sender, EventArgs e)

{

da.Update(ds,"emp");

}

DESIGN

JavaScript Validatoin For Basic Controles in ASP.NET

2008-11-20T22:20:00.000-08:00

Thanks for Visiting www.funnydotnet.co.cc

Design

In Coding Page Add Following code in Head Tag

function Validation()

{

//name

document.getElementById ('txtname');

if(name.value=='')

{

alert("Name Can't Blank");

getElementById ('txtname').focus();

return false;

}

//checking for only alphabets and name should be more than 4 char

var reforname=/^[A-Za-z]{4,50}$/;

var phone=document.getElementById('txtname').value;

if(phone.search(reforname))

//if(isNaN(phone))

{

alert("Enter Correct name");

document.getElementById ('txtname').focus();

return false;

}

//accepts only 10 digits

var reforphone=/^\d{10}$/;

var phone=document.getElementById('txtphone').value;

if(phone.search(reforphone))

{

alert("Enter Correct Phone No");

document.getElementById('txtphone').focus();

return false;

}

//Email Validation

var reforemail=/\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*/;

var phone=document.getElementById('txtemail').value;

if(phone.search(reforemail))

{

alert("Enter Correct email");

document.getElementById('txtemail').focus;

return false;

}

//Dropdown list Validation

var dob=document.getElementById('ddldob');

if(dob.value=="select")

{

alert("select DOB");

return false;

}

//Radio Button Validation Here 'gender' is Group Name Of Radio Button

//if(document.getElementById('rb1').checked==false && document.getElementById ('rb2').checked==false)

if(document.form1.gender[0].checked==false && document.form1.gender[1].checked==false)

{

alert("select Gender");

return false;

}

//checkbox validation

if(document.getElementById('cb1').checked==false&& document.getElementById ('cb2').checked==false)

{

alert("select Alert Modes");

return false;

}

return true;

}

Add the Following Code In Page Load

//When Validation Function return True Then OnClick() is Fired (internally calls javaScript Function)

submit.Attributes.Add("OnClick","return Validation()");

Dot Net - C#.Net(FAQ'S)

2008-11-20T00:26:00.000-08:00

1 . Does C# support multiple-inheritance?

No.

2 . Who is a protected class-level variable available to?

It is available to any sub-class (a class inheriting this class).

3 . Are private class-level variables inherited?

Yes, but they are not accessible. Although they are not visible or accessible via the class interface, they are inherited.

4 . Describe the accessibility modifier “protected internal”.

It is available to classes that are within the same assembly and derived from the specified base class.

5 . What’s the top .NET class that everything is derived from?

System.Object.

6 . What does the term immutable mean?

The data value may not be changed. Note: The variable value may be changed, but the original immutable data value was discarded and a new data value was created in memory.

7 . What’s the difference between System.String and System.Text.StringBuilder classes?

System.String is immutable. System.StringBuilder was designed with the purpose of having a mutable string where a variety of operations can be performed.

8 . What’s the advantage of using System.Text.StringBuilder over System.String?

StringBuilder is more efficient in cases where there is a large amount of string manipulation. Strings are immutable, so each time a string is changed, a new instance in memory is created.

9 . Can you store multiple data types in System.Array?

No.

10 . What’s the difference between the System.Array.CopyTo() and System.Array.Clone()?

The Clone() method returns a new array (a shallow copy) object containing all the elements in the original array. The CopyTo() method copies the elements into another existing array. Both perform a shallow copy. A shallow copy means the contents (each array element) contains references to the same object as the elements in the original array. A deep copy (which neither of these methods performs) would create a new instance of each element's object, resulting in a different, yet identacle object.

11 . How can you sort the elements of the array in descending order?

By calling Sort() and then Reverse() methods.

12 . What’s the .NET collection class that allows an element to be accessed using a unique key?

HashTable.

13 . Will the finally block get executed if an exception has not occurred?

Yes.

14 . What’s the C# syntax to catch any possible exception?

A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.

15 . Can multiple catch blocks be executed for a single try statement?

No. Once the proper catch block processed, control is transferred to the finally block (if there are any).

16 . Explain the three services model commonly know as a three-tier application.

Presentation (UI), Business (logic and underlying code) and Data (from storage or other sources).

Class Questions
17 . What is the syntax to inherit from a class in C#?

Place a colon and then the name of the base class.
Example: class MyNewClass : MyBaseClass

18 . Can you prevent your class from being inherited by another class?

Yes. The keyword “sealed” will prevent the class from being inherited.

19 . Can you allow a class to be inherited, but prevent the method from being over-ridden?

Yes. Just leave the class public and make the method sealed.

20 . What’s an abstract class?

A class that cannot be instantiated. An abstract class is a class that must be inherited and have the methods overridden. An abstract class is essentially a blueprint for a class without any implementation.

21 . When do you absolutely have to declare a class as abstract?

1. When the class itself is inherited from an abstract class, but not all base abstract methods have been overridden.
2.When at least one of the methods in the class is abstract.

22 . What is an interface class?

Interfaces, like classes, define a set of properties, methods, and events. But unlike classes, interfaces do not provide implementation. They are implemented by classes, and defined as separate entities from classes.

23 . Why can’t you specify the accessibility modifier for methods inside the interface?

They all must be public, and are therefore public by default.

24 . Can you inherit multiple interfaces?

Yes. .NET does support multiple interfaces.

25 . What happens if you inherit multiple interfaces and they have conflicting method names?

It’s up to you to implement the method inside your own class, so implementation is left entirely up to you. This might cause a problem on a higher-level scale if similarly named methods from different interfaces expect different data, but as far as compiler cares you’re okay.
To Do: Investigate

26 . What’s the difference between an interface and abstract class?

In an interface class, all methods are abstract - there is no implementation. In an abstract class some methods can be concrete. In an interface class, no accessibility modifiers are allowed. An abstract class may have accessibility modifiers.

27 . What is the difference between a Struct and a Class?

Structs are value-type variables and are thus saved on the stack, additional overhead but faster retrieval. Another difference is that structs cannot inherit.

Method and Property Questions

28 . What’s the implicit name of the parameter that gets passed into the set method/property of a class?

Value. The data type of the value parameter is defined by whatever data type the property is declared as.

29 . What does the keyword “virtual” declare for a method or property?

The method or property can be overridden.

30 . How is method overriding different from method overloading?

When overriding a method, you change the behavior of the method for the derived class. Overloading a method simply involves having another method with the same name within the class.

31 . Can you declare an override method to be static if the original method is not static?

No. The signature of the virtual method must remain the same. (Note: Only the keyword virtual is changed to keyword override)

32 . What are the different ways a method can be overloaded?

Different parameter data types, different number of parameters, different order of parameters.

33 . If a base class has a number of overloaded constructors, and an inheriting class has a number of overloaded constructors; can you enforce a call from an inherited constructor to a specific base constructor?

Yes, just place a colon, and then keyword base (parameter list to invoke the appropriate constructor) in the overloaded constructor definition inside the inherited class.

Events and Delegates

34 . What’s a delegate?

A delegate object encapsulates a reference to a method.

35 . What’s a multicast delegate?

A delegate that has multiple handlers assigned to it. Each assigned handler (method) is called.

36 . Is XML case-sensitive?

Yes.

37 . What’s the difference between // comments, /* */ comments and /// comments?

Single-line comments, multi-line comments, and XML documentation comments.

38 . How do you generate documentation from the C# file commented properly with a command-line compiler?

Compile it with the /doc switch.

Debugging and Testing Questions

39 . What debugging tools come with the .NET SDK?

1. CorDBG – command-line debugger. To use CorDbg, you must compile the original C# file using the /debug switch.
2.DbgCLR – graphic debugger. Visual Studio .NET uses the DbgCLR.
3.
40 . What does assert() method do?

In debug compilation, assert takes in a Boolean condition as a parameter, and shows the error dialog if the condition is false. The program proceeds without any interruption if the condition is true.

41 . What’s the difference between the Debug class and Trace class?

Documentation looks the same. Use Debug class for debug builds, use Trace class for both debug and release builds.

42 . Why are there five tracing levels in System.Diagnostics.TraceSwitcher?

The tracing dumps can be quite verbose. For applications that are constantly running you run the risk of overloading the machine and the hard drive. Five levels range from None to Verbose, allowing you to fine-tune the tracing activities.

43 . Where is the output of TextWriterTraceListener redirected?

To the Console or a text file depending on the parameter passed to the constructor.

44 . How do you debug an ASP.NET Web application?

Attach the aspnet_wp.exe process to the DbgClr debugger.

45 . What are three test cases you should go through in unit testing?
1. Positive test cases (correct data, correct output).
2. Negative test cases (broken or missing data, proper handling).
3.Exception test cases (exceptions are thrown and caught properly).

46 . Can you change the value of a variable while debugging a C# application?

Yes. If you are debugging via Visual Studio.NET, just go to Immediate window.

ADO.NET and Database Questions

47 . What is the role of the DataReader class in ADO.NET connections?

It returns a read-only, forward-only rowset from the data source. A DataReader provides fast access when a forward-only sequential read is needed.

48 . What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix. OLE-DB.NET is a .NET layer on top of the OLE layer, so it’s not as fastest and efficient as SqlServer.NET.

49 . What is the wildcard character in SQL?

Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would involve ‘La%’.

50 . Explain ACID rule of thumb for transactions.

A transaction must be:
1. Atomic - it is one unit of work and does not dependent on previous and following transactions.
2. Consistent - data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t.
3. Isolated - no transaction sees the intermediate results of the current transaction).
4. Durable - the values persist if the data had been committed even if the system crashes right after.

51 . What connections does Microsoft SQL Server support?

Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password).

52 . Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.

53 . What does the Initial Catalog parameter define in the connection string?

The database name to connect to.

54 . What is a pre-requisite for connection pooling?

Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings. The connection string must be identical.

Assembly Questions

55 . How is the DLL Hell problem solved in .NET?

Assembly versioning allows the application to specify not only the library it needs to run (which was available under Win32), but also the version of the assembly.

56 . What are the ways to deploy an assembly?

An MSI installer, a CAB archive, and XCOPY command.

57 . What is a satellite assembly?

When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core application are called satellite assemblies.

58 . What namespaces are necessary to create a localized application?

System.Globalization and System.Resources.

59 . What is the smallest unit of execution in .NET?

An Assembly.

60 . When should you call the garbage collector in .NET?

As a good rule, you should not call the garbage collector. However, you could call the garbage collector when you are done using a large object (or set of objects) to force the garbage collector to dispose of those very large objects from memory. However, this is usually not a good practice.

61 . What happens in memory when you Box and Unbox a value-type?

Boxing converts a value-type to a reference-type, thus storing the object on the heap. Unboxing converts a reference-type to a value-type, thus storing the value on the stack.

Dot Net - Asp.Net - Basic II(FAQ'S)

2008-11-19T22:45:00.000-08:00

1 . What is the difference between URL and URI?

A URL is the address of some resource on the Web, which means that normally you type the address into a browser and you get something back. There are other type of resources than Web pages, but that's the easiest conceptually. The browser goes out somewhere on the Internet and accesses something.

A URI is just a unique string that uniquely identifies something, commonly a namespace. Sometimes they look like a URL that you could type into the address bar of your Web browser, but it doesn't have to point to any physical resource on the Web. It is just a unique set of characters, that, in fact, don't even have to be unique.

URI is the more generic term, and a URL is a particular type of URI in that a URL has to uniquely identify some resource on the Web.

2 . How to convert milliseconds into time?

TimeSpan ts = TimeSpan.FromMilliseconds(10000);
Response.Write (ts.ToString () );
3 . How to include multiple vb/cs files in the source?

You can do this using assembly directives.

or

However, note that each source file will be compiled individually into its own assembly, so they cannot have dependencies on each other.

4 . How to convert a string to Proper Case?

Use the namespace System.Globalization

string myString = "syncFusion deVeloPer sUppOrt";
// Creates a TextInfo based on the "en-US" culture.
TextInfo TI = new CultureInfo("en-US",false).TextInfo;
Response.Write (TI.ToTitleCase( myString ));

For more details refer TextInfo.ToTitleCase()

5 . How can I ensure that application-level variables are not updated by more than one user simultaneously?

Use the HttpApplicationState's Lock and UnLock methods.

For more details refer : MSDN: Application State

7 . How to validate that a string is a valid date?

bool blnValid=false;
try
{
DateTime.Parse(MyString);
blnValid=true;
}
catch
{
blnValid=false;
}

8 . Are namespaces and Class names Case Sensitive?

Namespaces and Class names are case Sensitive. Namespaces imported using the @ Import Directive will cause an error if the correct case is not used.

9 . How to convert string to a DateTime and compare it with another DateTime?
bool blntimeIsOk = (DateTime.Parse("15:00") <>

10 . How to get the url of page dynamically?

Use Request.Url property

11 . How to convert user input in dMy format to Mdy?

DateTime dt = DateTime.ParseExact("0299", new string[] {"My","M/y"}, null,System.Globalization.DateTimeStyles.None); For more details refer DateTime.ParseExact

12 . When the User is prompted a File Download dialogbox, if the user selects "Save" then the "Save as" dialog box is displayed. Is there any way for me to retrieve the filename and directory path specified by the user on the File Download dialog box?

Clients do not report information back about where the user selects to save the content, so there isn't an easy way to do this. Instead, you would need to ask the user before using the content-disposition for a file path, and then you could specify the filename parameter for the content-disposition header. Still, the user is free to change that path when actually downloading.

13 . How to hide or show Controls in server side code?

In any appropriate event write VB.NET TextBox1.Visible =not TextBox1.Visible C# TextBox1.Visible =!TextBox1.Visible ;

14 . How to check if the user is using a secure or non secure connection? The Request Object defines a Property called IsSecureConnection, that will indicate whether http:// or https:// has been used. 15 . Is it possible to write code in many languages in one ASP.NET project? You cannot write the code-behind files in different languages in the same project, but you can write the aspx pages and ascx controls in different languages.

16 . What is the difference between Response.Redirect() and Server.Transfer().

Response.Redirect

* Tranfers the page control to the other page, in other words it sends the request to the other page.

* Causes the client to navigate to the page you are redirecting to. In http terms it sends a 302 response to the client, and the client goes where it's told. Server.Transfer

* Only transfers the execution to another page and during this you will see the URL of the old page since only execution is transfered to new page and not control.

* Occurs entirely on the server, no action is needed by the client Sometimes for performance reasons, the server method is more desirable

17 . How to get the hostname or IP address of the server?

You can use either of these:

* HttpContext.Current.Server.MachineName

* HttpContext.Current.Request.ServerVariables["LOCAL_ADDR"] The first one should return the name of the machine, the second returns the local ip address. Note that name of the machine could be different than host, since your site could be using host headers

18 . What is the meaning of validateRequest=true in .net framework1.1?

The value of validateRequest is set to 'true' by default, which means that the framework will automatically deny submission of the '<' and '>' characters.

19 . What is the different between and ?

The is used for databinding where as is used to output the result of an expression. The expression inside will be executed only when you call the page's or control's DataBind method. The expression inside will be executed and displayed as and when it appears in the page.

20 . What permissions do ASP.NET applications posses by default?

By default ASP.NET Web applications run as ASP.NET user. This user has limited permissions equivalent to the User Group.

21 . How can I specify the relative path for a file?

Suppose you have following file hierarchy:

default.aspx
Admin/login.aspx
Misc/testpage.aspx

And you are on the login.aspx and want your user to navigate to the default.aspx (or testpage.aspx) file. Then you can use

* Response.Redirect ("../default.aspx")
* Response.Redirect ("../Misc/testpage.aspx")

22 . How can I specify the "upload a file" input textbox in a form to be read only so that the user can click on the browse button and pick a file but they cannot type anything into the textbox next to the browse button.

23 . How to change the Page Title dynamically?

//Declare
protected System.Web.UI.HtmlControls.HtmlGenericControl Title1 ;

//In Page_Load
Title1.InnerText ="Page 1" ;

24 . Why do I get the error message "Object must implement IConvertible". How can I resolve it?

The common cause for this error is specifying a control as a SqlParameter's Value instead of the control's text value.
For example, if you write code as below you'll get the above error:

SqlParameter nameParameter = command.Parameters.Add("@name", SqlDbType.NVarChar, 50);
nameParameter.Value = txtName ;

To resolve it, specify the control's Text property instead of the control itself.

nameParameter.Value =txtName.Text;

25 . Why is default.aspx page not opened if i specify http://localhost. I am able to view this page if i hardcode it as http://localhost/default.aspx?

If some other default page comes higher in the list, adjust the default.aspx to be the number one entry inside the IIS configuration. If you have multiple websites inside IIS, make sure the configuration is applied on the right website (or on all websites by applying the configuration on the server-level using the properties dialog, configure WWW service).

26 . Can ASP.NET work on an NT server?

No. For more details refer ASP 1.1 version

27 . Is it possible to migrate Visual InterDev Design-Time Controls to ASP.NET?

Refer INFO: Migrating Visual InterDev Design-Time Controls to ASP.NET

28 . How to automatically get the latest version of all the asp.net solution items from Source Safe when opening the solution?

In VS.NET you can go to Tools > Options > Source Control > General and check the checkbox for Get everything when a solution opens.
This retrieves the latest version of all solution items when you open the solution.

29 . How to make VS.Net use FlowLayout as the default layout rather than the GridLayout?

For C#, go to path C:\Program Files\Microsoft Visual Studio .NET 2003\VC#\VC#Wizards\CSharpWebAppWiz\Templates\1033
Change the following line in the existing WebForm1.aspx

to

Note:Before changing any templates it's a good idea to make backup copies of them
Or rather than above approach you can change the behavior for new files on a per project basis in Visual Studio by:

1. Right clicking on the project name (Ex: "WebApplication1)" in Solution Explorer, and select "Properties".
2. From project properties window, under Common Properties>Designer Defaults>Page Layout change "Grid" to "Flow".

30 . Can I use a DataReader to update/insert/delete a record?

No. DataReader provides a means of reading a forward-only stream of rows from a database.

31 . How to format a Telphone number in the xxx-xxx-xxxx format?

double Telno= double.Parse(ds.Tables[0].Rows[0]["TelNo"].ToString());
Response.Write(Telno.ToString("###-###-####"));
32 . Can two different programming languages be mixed in a single ASPX file?

No. ASP.NET uses parsers to strip the code from ASPX files and copy it to temporary files containing derived Page classes, and a given parser understands only one language

33 . Can I use custom .NET data types in a Web form?

Yes. Place the DLL containing the type in the application root's bin directory and ASP.NET will automatically load the DLL when the type is referenced. This is also what happens when you add a custom control from the toolbox to your web form.