MSDotNetBuddy

Public Class Form1
Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "

Public Sub New()
MyBase.New()

'This call is required by the Windows Form Designer.
InitializeComponent()

'Add any initialization after the InitializeComponent() call

End Sub

'Form overrides dispose to clean up the component list.
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub

'Required by the Windows Form Designer
Private components As System.ComponentModel.IContainer

'NOTE: The following procedure is required by the Windows Form Designer
'It can be modified using the Windows Form Designer.
'Do not modify it using the code editor.
Friend WithEvents TextBox1 As System.Windows.Forms.TextBox
Friend WithEvents TextBox2 As System.Windows.Forms.TextBox
Friend WithEvents TextBox3 As System.Windows.Forms.TextBox
Private Sub InitializeComponent()
Me.TextBox1 = New System.Windows.Forms.TextBox()
Me.TextBox2 = New System.Windows.Forms.TextBox()
Me.TextBox3 = New System.Windows.Forms.TextBox()
Me.SuspendLayout()
'
'TextBox1
'
Me.TextBox1.Location = New System.Drawing.Point(64, 32)
Me.TextBox1.Name = "TextBox1"
Me.TextBox1.TabIndex = 0
Me.TextBox1.Text = ""
'
'TextBox2
'
Me.TextBox2.Location = New System.Drawing.Point(64, 64)
Me.TextBox2.Name = "TextBox2"
Me.TextBox2.TabIndex = 1
Me.TextBox2.Text = ""
'
'TextBox3
'
Me.TextBox3.Location = New System.Drawing.Point(64, 96)
Me.TextBox3.Name = "TextBox3"
Me.TextBox3.TabIndex = 2
Me.TextBox3.Text = ""
'
'Form1
'
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
Me.ClientSize = New System.Drawing.Size(292, 266)
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.TextBox3, Me.TextBox2, Me.TextBox1})
Me.Name = "Form1"
Me.Text = "Form1"
Me.ResumeLayout(False)

End Sub

#End Region



Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
If Asc(e.KeyChar) = 13 Then
SendKeys.Send("{TAB}")
End If
End Sub

Private Sub TextBox2_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox2.TextChanged
End Sub

Private Sub TextBox2_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox2.KeyPress
If Asc(e.KeyChar) = 13 Then
SendKeys.Send("{TAB}")
End If

End Sub
End Class

Public Class Form1
Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "

Public Sub New()
MyBase.New()

'This call is required by the Windows Form Designer.
InitializeComponent()

'Add any initialization after the InitializeComponent() call

End Sub

'Form overrides dispose to clean up the component list.
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub

'Required by the Windows Form Designer
Private components As System.ComponentModel.IContainer

'NOTE: The following procedure is required by the Windows Form Designer
'It can be modified using the Windows Form Designer.
'Do not modify it using the code editor.
Friend WithEvents TextBox1 As System.Windows.Forms.TextBox
Friend WithEvents Label1 As System.Windows.Forms.Label
Private Sub InitializeComponent()
Me.TextBox1 = New System.Windows.Forms.TextBox()
Me.Label1 = New System.Windows.Forms.Label()
Me.SuspendLayout()
'
'TextBox1
'
Me.TextBox1.Location = New System.Drawing.Point(80, 72)
Me.TextBox1.Name = "TextBox1"
Me.TextBox1.TabIndex = 0
Me.TextBox1.Text = ""
'
'Label1
'
Me.Label1.AutoSize = True
Me.Label1.Font = New System.Drawing.Font("Microsoft Sans Serif", 9.75!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
Me.Label1.Location = New System.Drawing.Point(48, 40)
Me.Label1.Name = "Label1"
Me.Label1.Size = New System.Drawing.Size(164, 15)
Me.Label1.TabIndex = 1
Me.Label1.Text = "8 digited numeric Textbox"
'
'Form1
'
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
Me.ClientSize = New System.Drawing.Size(292, 266)
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.Label1, Me.TextBox1})
Me.Name = "Form1"
Me.Text = "Form1"
Me.ResumeLayout(False)

End Sub

#End Region

Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
Dim str As String = TextBox1.Text

If e.KeyChar.IsLetter(e.KeyChar) Then
e.Handled = True
End If

If e.KeyChar.IsPunctuation(e.KeyChar) Then
e.Handled = True
End If
If e.KeyChar.IsSymbol(e.KeyChar) Then
e.Handled = True
End If

If Asc(e.KeyChar) >= 48 And Asc(e.KeyChar) <= 57 Then
If str.Length = 8 Then
e.Handled = True
MessageBox.Show("Atmost 8 Digited Number are allowed")
End If
End If

End Sub
End Class

using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;

namespace OOPLib
{
class Library
{

}

class Person
{
public string PersonName;
public string PersonAddress;
public string PersonEmailAddress;
public Boolean PersonIsMale;
public DateTime PersonBirthDate;

//contructor of person class
public Person(string Name, string Adr, string Email, Boolean IsMale, DateTime BirthDate)
{
this.PersonName = Name;
this.PersonAddress = Adr;
this.PersonBirthDate = BirthDate;
this.PersonEmailAddress = Email;
this.PersonIsMale = IsMale;
}
public Person()
{
}
}//

//Author Class is derived from Person
class Author:Person
{
Weblinks AuthorWebs;

//constructor for author class
Author(Person p,Weblinks links)
{
this.PersonEmailAddress = p.PersonEmailAddress;
this.AuthorWebs = links;

this.PersonName = p.PersonName;
this.PersonAddress = p.PersonAddress;
this.PersonBirthDate = p.PersonBirthDate;
this.PersonIsMale = p.PersonIsMale;
}
}//

//List based collection of author objects
class Authors : CollectionBase
{
public void Add(Author newAuthor)
{
List.Add(newAuthor);
}
public void Remove(Author newAuthor)
{
List.Remove(newAuthor);
}
public Author this[int AuthorIndex]
{
get
{
return (Author)List[AuthorIndex];
}
set
{
List[AuthorIndex] = value;
}
}
}//

public class PrintedMedia
{
public string Id;
public string Name;
public long Price;
public string Publisher;

//constructor of PrintMedia Class
public PrintedMedia (string id,string name,long price ,string publisher)
{
this.Id = id;
this.Name = name;
this.Price = price;
this.Publisher = publisher;
}
//Default constructor
public PrintedMedia()
{
}
}//

//Book Class derived from PrintedMedia
class Book:PrintedMedia
{
string BookISBN;
Authors BookAuthors;
int BookCopies;
string BookEdition;
string BookCatagory;
Weblinks BookWebRef;

//constructor of book class
public Book(string ISBN, Authors newAuthors, int Copies, string Edition, string Catagory,Weblinks webref)
{
this.BookAuthors = newAuthors;
this.BookCatagory = Catagory;
this.BookCopies = Copies;
this.BookEdition = Edition;
this.BookISBN = ISBN;
this.BookWebRef = webref;
}
public Book()
{
}
}//

public enum PeriodicalTypes
{
Weekly,BiWeekly,Monthly,BiMonthly,SixMonthly,Yearly
}

//Periodical class inherit from PrintedMedia Class
class Periodical : PrintedMedia
{
PeriodicalTypes PeriodicalType;
DateTime PeriodicalIssueDate;


Periodical(PrintedMedia p,PeriodicalTypes q,DateTime IssueDate)
{
this.Id = p.Id;
this.Name = p.Name;
this.Price = p.Price;
this.Publisher = p.Publisher;
this.PeriodicalType = q;
this.PeriodicalIssueDate = IssueDate;
}
}//


//List Based Collection class for Periodicals
class Periodicals : CollectionBase
{
public void Add(Periodical newPeriodical)
{
List.Add(newPeriodical);
}
public void Remove(Periodical newPeriodical)
{
List.Remove(newPeriodical);
}
public Periodical this[int PeriodicalIndex]
{
get
{
return (Periodical)List[PeriodicalIndex];
}
set
{
List[PeriodicalIndex] = value;
}
}
}
//List Based Collection Class for Book's Web References
class Weblinks:CollectionBase
{
public void Add(string newUrl)
{
List.Add(newUrl);
}

public void Remove(string newUrl)
{
List.Remove(newUrl);
}
public string this[int WebIndex]
{
get
{
return (string)List[WebIndex];
}
set
{
List[WebIndex]=value;
}
}
}//


//List Based Book object collection
class Books : CollectionBase
{
public void Add(Book newBook)
{
List.Add(newBook);
}

public void Remove(Book newBook)
{
List.Remove(newBook);
}

public Book this[int BookIndex]
{
get
{
return (Book)List[BookIndex];
}
set
{
List[BookIndex] = value;
}
}
}//

//Member class derived from person class
class Member : Person
{
string MemberID;
long MemberDeposite;
Books BorrowedBooks;
Periodicals BorrowedPeriodicals;

Member(string ID, long Deposite, Person p,Books Borrowed,Periodicals Periodicals)
{
this.MemberID = ID;
this.MemberDeposite = Deposite;

this.PersonName = p.PersonName;
this.PersonAddress = p.PersonAddress;
this.PersonBirthDate = p.PersonBirthDate;
this.PersonEmailAddress = p.PersonEmailAddress;
this.PersonIsMale = p.PersonIsMale;
this.BorrowedBooks = Borrowed;
this.BorrowedPeriodicals = Periodicals;
}

}//

//List Based Collection of Member Objects

class Members : CollectionBase
{
public void Add(Member newMember)
{
List.Add(newMember);
}
public void Remove(Member newMember)
{
List.Remove(newMember);
}
public Member this[int MemberIndex]
{
get
{
return (Member)List[MemberIndex];
}
set
{
List[MemberIndex] = value;
}
}
public enum StaffPositions
{
Librarian, DeputyLibrarian, Clerk, Peon
}

public class StaffMember : Person
{
StaffPositions staffType;

StaffMember(Person p, StaffPositions q)
{
this.PersonAddress = p.PersonAddress;
this.PersonBirthDate = p.PersonBirthDate;
this.PersonEmailAddress = p.PersonEmailAddress;
this.PersonIsMale = p.PersonIsMale;
this.PersonName = p.PersonName;
staffType = q;
}

}//


//List Based collection of StaffMember objects
class StaffMembers : CollectionBase
{
public void Add(StaffMember newMember)
{
List.Add(newMember);
}
public void Remove(StaffMember newMember)
{
List.Remove(newMember);
}
public StaffMember this[int MemberIndex]
{
get
{
return (StaffMember)List[MemberIndex];
}
set
{
List[MemberIndex] = value;
}
}

}
}
}

Class having two contructor in C#:

using System;
using System.Collections.Generic;
using System.Text;

namespace ClassWithConstructor
{
class Program
{
static void Main(string[] args)
{
DrinkBottle db = new DrinkBottle("Pepsi", 250,"Caffetino");
db.openBottle();
Console.ReadKey();
}
}

public class DrinkBottle
{
string Brand;
int Size;
string Flavour;
string MonthOfManiFacture;

public DrinkBottle(string brand, int size, string flavour)
{
Brand=brand;
Size=size;
Flavour = flavour;
MonthOfManiFacture = DateTime.Today.ToString() ;
}
public DrinkBottle(string brand, int size, string flavour,string MFM)
{
Brand = brand;
Size = size;
Flavour = flavour;
MonthOfManiFacture = MFM;
}
public void openBottle()
{
Console.WriteLine("Specification of Bottle Opened");
Console.WriteLine("Brand:"+Brand );
Console.WriteLine("Size"+Size);
Console.WriteLine("Flavour"+Flavour);
Console.WriteLine("Manifacturing Date"+MonthOfManiFacture); }
}
}

1)Create a vb 6.0 standard exe project add a textbox,a lavel ,add,calculate,reset
command button
2)copy assembly of NewMegacalc2 and NewMeanCalculator in current directory
3) copy type libraries for both of these.

Dim mobjCalc As NewMeanCalculator.MeanCalc
Dim mobjmega As NewMegaCalc2.IMegaCalc

Private Sub CmdAdd_Click()
mobjmega.Addinput (Text1.Text)
End Sub

Private Sub CmdCalculate_Click()
mobjmega.doCalculation
Text1.Text = mobjmega.GetOutput()
End Sub

Private Sub CmdReset_Click()
mobjmega.Reset
End Sub

Private Sub Form_Load()
mobjCalc = New NewMeanCalculator.MeanCalc
mobjmega = mobjCalc
End Sub

********************
Importing Vb.net assembly in vb 6.0:
Pre-requisite:

1)Create Class Library in VB.net add reference to NewMegaCalc2 a .Net Assembly
2)Add Following code

Public Class MeanCalc
Implements NewMegaCalc2.IMegaCalc

Dim mintValue As Integer
Dim mdblValues() As Double
Dim mdblMean As Double

Public Sub AddInput(ByVal InputValue As Double) Implements NewMegaCalc2.IMegaCalc.Addinput
mintValue = mintValue + 1
ReDim Preserve mdblValues(mintValue)
mdblValues(mintValue - 1) = InputValue
End Sub
Public Sub DoCalculation() Implements NewMegaCalc2.IMegaCalc.doCalculation
Dim IValue As Integer
mdblMean = 0
If (mintValue = 0) Then Exit Sub
For IValue = 0 To mintValue - 1 Step 1
mdblMean = mdblMean + mdblValues(IValue)

Next
mdblMean = mdblMean / IValue

End Sub

Public Function GetOutput() As Double Implements NewMegaCalc2.IMegaCalc.GetOutput
GetOutput = mdblMean
End Function

Public Sub Reset() Implements NewMegaCalc2.IMegaCalc.Reset
mintValue = 0
End Sub

Public Sub New()
Reset()
End Sub
End Class

******************************
PreRequesite:
1)create a vb.net class library called NewMeanCalc2 add following code to it
2)build project

Public Class Class1


End Class
Public Interface IMegaCalc
Sub Addinput(ByVal InputValue As Double)
Sub doCalculation()
Function GetOutput() As Double
Sub Reset()
End Interface

HTML:

%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>ImageMap server Control</title>
</head>

<body>
<form id="form1" runat="server">
<div>

<asp:ImageMap ID="ImageMap1" runat="server" ImageUrl="~/Images/daisy.jpg"
HotSpotMode="PostBack" Width="200" onclick="ImageMap1_Click" Height="200">

<asp:RectangleHotSpot Top="0" Bottom="100" Right="100" Left="0" AlternateText="Purnima" PostBackValue="purnima"/>
<asp:RectangleHotSpot Top="0" Bottom="100" Right="200" Left="100" AlternateText="Pratiksha" PostBackValue="pratiksha"/>
<asp:RectangleHotSpot Top="100" Bottom="200" Right="100" Left="0" AlternateText="Suverna" PostBackValue="suverna"/>
<asp:RectangleHotSpot Top="100" Bottom="200" Left="100" Right="200" AlternateText="Sajida" PostBackValue="sajida"/>
</asp:ImageMap>

</div>
</form>
</body>
</html>

C# Code:

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void ImageMap1_Click(object sender, ImageMapEventArgs e)
{
Response.Write(e.PostBackValue.ToString());
}
}

C# Implementation of Writing Data to XML Format using Dataset’s :WriteXml method:

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Xml ;
namespace Writing_To_XML
{
class Program
{
static void Main(string[] args)
{
SqlConnection con = new SqlConnection("Integrated Security=SSPI;Initial Catalog=sangram;Data Source=(Local)");
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from course", con);
SqlCommandBuilder sbuilder = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "course");
da = new SqlDataAdapter("select * from student", con);
da.Fill(ds,"student");

//setting relation between cno field common to both

DataRelation dataRel=ds.Relations.Add("RelName",ds.Tables[0].Columns["cno"],ds.Tables[1].Columns["cno"]);
dataRel.Nested=true ;
ds.WriteXml(@"I:\Trial\CourseStud.xml");
Console.WriteLine("Program Execution Finished:");
con.Close();
Console.ReadKey();
}
}

}

C# code:

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page
{
static DataSet ds;
static SqlDataAdapter da;
static SqlCommandBuilder cmdBuilder;
static string currentCno;

protected void Page_Load(object sender, EventArgs e)
{
if (! Page.IsPostBack)
{
Bind();
}

}
public void Bind()
{
SqlConnection con = new SqlConnection("Initial Catalog=sangram;Integrated Security=SSPI;Data Source=(local);");
con.Open();
da = new SqlDataAdapter("select * from courses", con);
cmdBuilder = new SqlCommandBuilder(da);
ds = new DataSet();
da.Fill(ds, "courses");
DataList1.DataSource = ds.Tables[0];
DataList1.DataBind();
}

protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{


if (e.CommandName == "Select")
{
DataList1.SelectedIndex = e.Item.ItemIndex;
currentCno = ((Label)e.Item.FindControl("LblCourseId")).Text;
Bind();
}
if (e.CommandName == "Insert")
{
string cno = ((TextBox)e.Item.FindControl("TxtCourseId")).Text;
string cname = ((TextBox)e.Item.FindControl("TxtCourseName")).Text;
string duration = ((TextBox)e.Item.FindControl("TxtCourseDuration")).Text;
string fees = ((TextBox)e.Item.FindControl("TxtCourseFees")).Text;

DataColumn[] Dcol = new DataColumn[1];
Dcol[0] = ds.Tables[0].Columns[0];
ds.Tables[0].PrimaryKey = Dcol;

DataRow drow;
drow = ds.Tables[0].NewRow();

drow[0] = cno;
drow[1] = cname;
drow[2] = duration;
drow[3] = fees;

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

da.Update(ds, "Courses");

Bind();

}


}
protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
{
DataList1.EditItemIndex = -1;
DataList1.SelectedIndex = -1;
Bind();
}
protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
{
// Retrieve the updated values from the selected item.
string cno =((TextBox) e.Item.FindControl("TxtCourseId")).Text;
string cname =((TextBox) e.Item.FindControl("TxtCourseName")).Text;
string duration =((TextBox) e.Item.FindControl("TxtCourseDuration")).Text;
string fees =((TextBox) e.Item.FindControl("TxtCourseFees")).Text;


//Adding Temp prim key
DataColumn[] Dcol=new DataColumn[1];
Dcol[0]=ds.Tables[0].Columns[0];
ds.Tables[0].PrimaryKey = Dcol;

DataRow drow ;
if (ds.Tables[0].Rows.Find(cno)!= null)
{
//modifing exiting row without changing cno
drow = ds.Tables[0].Rows.Find(cno);

drow[0] =cno;
drow[1] = cname;
drow[2] = duration;
drow[3] = fees;

}
else
{
//deleting old row
ds.Tables[0].Rows.Find(currentCno).Delete();
//adding new row
drow = ds.Tables[0].NewRow();
drow[0] =cno;
drow[1] = cname;
drow[2] = duration;
drow[3] = fees;

ds.Tables[0].Rows.Add(drow);
}

//updating deleted row and newly added row simultenously
da.Update(ds, "Courses");


DataList1.EditItemIndex = -1;
DataList1.SelectedIndex = -1;

Bind();

}
protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
{

}
protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
{
DataList1.EditItemIndex = e.Item.ItemIndex;
Bind();
}
protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
{
//Adding Temp prim key
DataColumn[] Dcol = new DataColumn[1];
Dcol[0] = ds.Tables[0].Columns[0];
ds.Tables[0].PrimaryKey = Dcol;

string cno = ((TextBox)e.Item.FindControl("TxtCourseId")).Text;

ds.Tables[0].Rows.Find(cno).Delete();
da.Update(ds, "Courses");
Bind();
}
public int GetMaxCno()
{

DataRow[] drow= ds.Tables[0].Select("cno=max(cno)");
string maxRow = drow[0][0].ToString();
return Convert.ToInt16( maxRow);
}

}

HTML:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DataList ID="DataList1" runat="server" OnItemCommand="DataList1_ItemCommand" OnCancelCommand="DataList1_CancelCommand" OnUpdateCommand="DataList1_UpdateCommand" OnEditCommand="DataList1_EditCommand" OnSelectedIndexChanged="DataList1_SelectedIndexChanged" OnDeleteCommand="DataList1_DeleteCommand" >
<HeaderTemplate>
<table style="border-style:solid;">
<tr>
<td >Course Id</td>
<td>Course Name</td>
<td>Course Duration</td>
<td>Course Fees</td>
<td>Command</td>
</tr>

</HeaderTemplate>
<FooterTemplate>
<tr>
<td><asp:TextBox ID="TxtCourseId" Enabled="false" Text='<%#GetMaxCno()+1%>' runat="server"></asp:TextBox></td>
<td><asp:TextBox ID="TxtCourseName" Text="CourseName" runat="server"></asp:TextBox></td>
<td><asp:TextBox ID="TxtCourseDuration" Text="CourseDuration" runat="server"></asp:TextBox></td>
<td><asp:TextBox ID="TxtCourseFees" Text="CourseFees" runat="server"></asp:TextBox></td>
<td><asp:Button ID="Btn3" Text="Insert" CommandName="Insert" runat="server" /></td>
</tr>
</table>
</FooterTemplate>

<ItemTemplate>
<tr>
<td>
<asp:Label ID="LblCourseId" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cno")%> ></asp:Label>
</td>
<td>
<asp:Label ID="LblCourseName" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cname")%> ></asp:Label>
</td>
<td>
<asp:Label ID="LblCourseDuration" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"duration")%> ></asp:Label>
</td>
<td>
<asp:Label ID="LblCourseFees" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"fees")%> ></asp:Label>
</td>
<td>
<asp:Button ID="Button1" runat="server" CommandName="Select" Text="Select"></asp:Button >
</td>
</tr>

</ItemTemplate>
<AlternatingItemTemplate>
<tr style="background-color:Burlywood;">
<td>
<asp:Label ID="LblCourseId" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cno")%> ></asp:Label>
</td>
<td>
<asp:Label ID="LblCourseName" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cname")%> ></asp:Label>
</td>
<td>
<asp:Label ID="LblCourseDuration" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"duration")%> ></asp:Label>
</td>
<td>
<asp:Label ID="LblCourseFees" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"fees")%> ></asp:Label>
</td>
<td>
<asp:Button ID="Btn1" runat="server" CommandName="Select" Text="Select"></asp:Button>
</td>
</tr>
</AlternatingItemTemplate>
<SelectedItemTemplate>
<tr>
<td>
<asp:TextBox ID="TxtCourseId" Enabled="false" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cno")%>/>
</td>
<td>
<asp:TextBox ID="TxtCourseName" Enabled="false" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cname")%>/>
</td>
<td>
<asp:TextBox ID="TxtCourseDuration" Enabled="false" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"duration")%> />
</td>
<td>
<asp:TextBox ID="TxtCourseFees" runat="server" Enabled="false" Text=<%#DataBinder.Eval(Container.DataItem,"fees")%> />
</td>
<td>
<asp:Button ID="Btn1" runat="server" CommandName="Edit" Text="Edit"></asp:Button >
</td>
<td>
<asp:Button ID="Btn2" runat="server" CommandName="Delete" Text="Delete"></asp:Button >
</td>
</tr>
</SelectedItemTemplate>
<EditItemTemplate>
<tr>
<td>
<asp:TextBox ID="TxtCourseId" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cno")%>/>
</td>
<td>
<asp:TextBox ID="TxtCourseName" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cname")%>/>
</td>
<td>
<asp:TextBox ID="TxtCourseDuration" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"duration")%> />
</td>
<td>
<asp:TextBox ID="TxtCourseFees" runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"fees")%> />
</td>
<td>
<asp:Button ID="Btn1" runat="server" CommandName="Update" Text="Update"></asp:Button >
</td>
<td>
<asp:Button ID="Btn2" runat="server" CommandName="Cancel" Text="Cancel"></asp:Button >
</td>
</tr>
</EditItemTemplate>

</asp:DataList></div>
</form>
</body>
</html>

ASP.NET 2.0

Create a new webApplication .Add Following Code to it


Partial Class _Default
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim UserName As String
UserName = Request.QueryString("Name")
Response.Write("Hello" + " " + UserName + " Have a nice day!")
End Sub
End Class

Now to test it:
Open Internet Explorer in Address Bar write address of our aspx page
followed by ? Name=Sangram.
Add Press Go.

You will see on web form “Hello Sangram have a nice day!”.

C#:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Default2 : System.Web.UI.Page
{
static DataSet ds;
static SqlDataAdapter da;
static SqlCommandBuilder cmdBuilder;
static string currentCno;

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Bind();
}
}
public void Bind()
{
SqlConnection con = new SqlConnection("Initial Catalog=sangram;Integrated Security=SSPI;Data Source=(local);");
con.Open();
da = new SqlDataAdapter("select * from courses", con);
cmdBuilder = new SqlCommandBuilder(da);
ds = new DataSet();
da.Fill(ds, "courses");
Repeater1.DataSource = ds.Tables[0];
Repeater1.DataBind();
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Select")
{

MessageLabel.Text ="You Have Selected Course In: " + ds.Tables[0].Rows[e.Item.ItemIndex][1].ToString() ;

}
}
protected void Repeater1_ItemCreated(object sender, RepeaterItemEventArgs e)
{
MessageLabel.Text = "All Items Have Been Created";
}
}

HTML :
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand" OnItemCreated="Repeater1_ItemCreated">
<HeaderTemplate>
<table>
<tr>
<td><strong>Id</strong></td>
<td><strong>Course Name</strong></td>
<td><strong>Course Duration</strong></td>
<td><strong>Fees</strong></td>
<td><strong>Command</strong></td>
</tr>
</HeaderTemplate>

<FooterTemplate>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>
</FooterTemplate>

<ItemTemplate>
<tr>
<td><asp:Label runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cno")%> ID="LblCourseId"></asp:Label></td>
<td><asp:Label runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cname")%> ID="LblCourseName"></asp:Label></td>
<td><asp:Label runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"duration")%> ID="LblCourseDuration"></asp:Label></td>
<td><asp:Label runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"fees")%> ID="LblCourseFees"></asp:Label></td>
<td><asp:Button ID="Btn1" Text="Select" CommandName="Select" runat="server" /> </td>
</tr>
</ItemTemplate>

<AlternatingItemTemplate>
<tr style="background-color:Burlywood;">
<td><asp:Label runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cno")%> ID="LblCourseId"></asp:Label></td>
<td><asp:Label runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"cname")%> ID="LblCourseName"></asp:Label></td>
<td><asp:Label runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"duration")%> ID="LblCourseDuration"></asp:Label></td>
<td><asp:Label runat="server" Text=<%#DataBinder.Eval(Container.DataItem,"fees")%> ID="LblCourseFees"></asp:Label></td>
<td><asp:Button ID="Btn1" Text="Select" CommandName="Select" runat="server" /> </td>
</tr>
</AlternatingItemTemplate>
</asp:Repeater>
<br />
<asp:Label ID="MessageLabel" runat="server"></asp:Label></div>
</form>
</body>
</html>

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;


namespace Updating_Dataset
{
class Program
{
static void Main(string[] args)
{
SqlConnection con = new SqlConnection("Integrated Security=SSPI;Initial Catalog=sangram;Data Source=(local)");
SqlDataAdapter da = new SqlDataAdapter("select * from course", con);
SqlCommandBuilder sbuilder = new SqlCommandBuilder(da);
DataSet ds = new DataSet();

da.Fill(ds, "course");
Console.WriteLine("Old Row:");
Console.Write(ds.Tables["course"].Rows[0][0].ToString());
Console.Write(" "+ ds.Tables["course"].Rows[0][1].ToString());
Console.Write(" " + ds.Tables["course"].Rows[0][2].ToString());
Console.Write(" "+ds.Tables["course"].Rows[0][3].ToString());

ds.Tables[0].Rows[0][1] = "GW BASIC";
da.Update(ds, "course");

Console.WriteLine("Edited Row:");
Console.Write(ds.Tables["course"].Rows[0][0].ToString());
Console.Write(" " + ds.Tables["course"].Rows[0][1].ToString());
Console.Write(" " + ds.Tables["course"].Rows[0][2].ToString());
Console.Write(" " + ds.Tables["course"].Rows[0][3].ToString());

Console.ReadKey();
con.Close();
}
}
}

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;

namespace MSACCESS
{
class Program
{
static void Main(string[] args)
{
string strDestPath = "I:\\Trial\\school.mdb";
SqlConnection sqlcon=new SqlConnection("Data Source=(Local);Integrated Security=SSPI;Initial Catalog=sangram") ;
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand("select * from course", sqlcon);
SqlDataReader sqldr = sqlcmd.ExecuteReader();
LoadFromSql(sqldr,strDestPath,"course");
Console.ReadKey();
}

private static void LoadFromSql(SqlDataReader dr1, string Path,string table)
{
OleDbConnection olecon = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source = " + Path );
olecon.Open();

OleDbCommand olecmd = new OleDbCommand();
olecmd.Connection = olecon;

string strCno,strCname,strDuration,strFees;

while (dr1.Read())
{
string strCmd;

strCno=dr1[0].ToString();
strCname = dr1[1].ToString();
strDuration = dr1[2].ToString();
strFees = dr1[3].ToString();

strCmd = "Insert into course values(" + strCno + ",'" + strCname+ "'," + strDuration+ "," + strFees + ")";
olecmd.CommandText = strCmd;

try
{
olecmd.ExecuteNonQuery();
}
catch( OleDbException oleEx)
{
Console.WriteLine(oleEx.Message);
}

}


}
}
}

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace DATASET_Handling
{
class Program
{
static void Main(string[] args)
{
SqlConnection sqlcon = new SqlConnection("Integrated Security= SSPI;Initial Catalog=sangram;Data Source=(Local) ");
sqlcon.Open();

SqlDataAdapter sqlda = new SqlDataAdapter("select * from course", sqlcon);
DataSet ds = new DataSet();

sqlda.Fill(ds, "course");

foreach (DataRow drow in ds.Tables["course"].Rows )
{
Console.Write("Cno:"+ drow["cno"].ToString());
Console.Write(" Cname:"+ drow["cname"]);
Console.Write(" Duration:" + drow["duration"].ToString());
Console.Write(" Fees:"+ drow["fees"].ToString());
Console.WriteLine();
}
sqlcon.Close();
Console.WriteLine("Program Finished");
Console.ReadKey();

}
}
}

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data.SqlClient;


namespace writing_data_to_text_file_in_csharp
{
class Program
{

static void Main(string[] args)
{
SqlConnection con = new SqlConnection("Data Source=(Local);Initial Catalog = Sangram;Integrated Security=SSPI");
con.Open();

SqlCommand cmd = new SqlCommand("select * from course", con);
SqlDataReader dr = cmd.ExecuteReader();

string strPath ="I:\\trial\\Course.txt";
//writing data to text file
writeToFile(dr,strPath);

//releases datareader object
dr.Close();
dr.Dispose();

//releases connection object
con.Close();
con.Dispose();

//releases command object
cmd.Dispose();

}

private static void writeToFile(SqlDataReader dr1,string Path)
{

FileStream fstream= new FileStream(Path , FileMode.OpenOrCreate, FileAccess.ReadWrite);
StreamWriter swriter= new StreamWriter(fstream);

while(dr1.Read())
{
string textrow;
textrow = dr1["cno"].ToString();
textrow = textrow+ " " + dr1["cname"];
textrow = textrow + " " + dr1["duration"].ToString();
textrow = textrow + " " + dr1["fees"].ToString();
swriter.WriteLine(textrow);
}
swriter.Close();
swriter.Dispose();

fstream.Close();
fstream.Dispose();

dr1.Close();
dr1.Dispose();
}
}

}

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace Mysql2
{
class Program
{
static void Main(string[] args)
{
MySqlConnection con = new MySqlConnection("datasource=localhost;username=root;password=indusstar;database=mysql");
con.Open();

MySqlDataAdapter da = new MySqlDataAdapter("select * from courses", con);
//need table with primary key
MySqlCommandBuilder cmdBuilder = new MySqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "courses");

DataRow drow = ds.Tables[0].Rows[3];

//updating

drow[0] = 4;
drow[1] = "Gambas.Net";
drow[2] = 5;
drow[3] = 8000;

da.Update(ds, "courses");

con.Close();

}
}
}

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace Mysql2
{
class Program
{
static void Main(string[] args)
{
MySqlConnection con = new MySqlConnection("datasource=localhost;username=root;password=indusstar;database=mysql");
con.Open();

MySqlDataAdapter da = new MySqlDataAdapter("select * from courses", con);
//need table with rimary key
MySqlCommandBuilder cmdBuilder = new MySqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "courses");

DataRow drow = ds.Tables[0].NewRow();
drow[0] = 4;
drow[1] = "Gambas";
drow[2] = 3;
drow[3] = 5000;

ds.Tables[0].Rows.Add(drow);
da.Update(ds, "courses");

con.Close();

}
}
}

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace Adapter_Dataset
{
class Program
{
static void Main(string[] args)
{
SqlConnection con = new SqlConnection("Integrated security=SSPI;Initial Catalog=sangram;Data source=(local)");
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from course", con);
DataSet ds = new DataSet();
da.Fill(ds,"course");
da = new SqlDataAdapter("select * from student", con);
da.Fill(ds, "student");

Console.WriteLine("Course Table");
foreach (DataRow drow in ds.Tables["course"].Rows)
{
Console.Write("Cno:"+ drow[0].ToString());
Console.Write(" Cname:"+ drow[1]);
Console.Write(" Duration:"+ drow[2].ToString());
Console.Write(" Fees:"+drow[3].ToString());
Console.WriteLine();
}

Console.WriteLine("Student Table");
foreach (DataRow drow in ds.Tables["student"].Rows)
{
Console.Write("Sno:"+drow[0].ToString());
Console.Write(" Sname:"+ drow[1]);
Console.Write(" Cno:"+ drow[2].ToString());
Console.WriteLine();
}
Console.ReadKey();

}
}
}

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace Adding_Rows_to_table
{
class Program
{
static void Main(string[] args)
{
SqlConnection con = new SqlConnection("Integrated Security=SSPI;Initial Catalog=sangram;Data Source=(local)");
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from course", con);
SqlCommandBuilder sbuilder = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "course");
Console.WriteLine("Number of Rows Before Adding New Record :" + ds.Tables[0].Rows.Count.ToString());

DataRow drow = ds.Tables[0].NewRow();

drow["cno"] = 27;
drow["cname"] = "CORE JAVA";
drow["duration"] = 2;
drow["fees"] = 4000 ;

ds.Tables[0].Rows.Add(drow);
da.Update(ds, "course");

Console.WriteLine(ds.Tables[0].Rows.Count.ToString());

con.Close();
Console.ReadKey();

}
}
}