DOTNET: 2012

Friday, September 14, 2012

Working with Custom Date Format using Jquery ( *****)

Custom Date Format using J Query

File->New->Website

First download the following JQuery files

http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js

http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js

https://www.coderesort.com/p/epicode/browser/Geta.Tags/Geta/Tags/Resources/jquery-ui-1.8.16.custom.css?rev=2107

http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css

DataBase Design

Create a Class

Class1.cs
Add the namespace

using System.Web;
using System.Globalization;

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Globalization;

/// <summary>
/// Summary description for Class1
/// </summary>
public class Class1
{
// to Convert Custom dateformat to system dateformat we are using this DateFormat
public static string DateFormat
{
get
{
DateFormatCo obj = new DateFormatCo();
string date = string.Empty;
if (obj .dateformat!= null)
{
date = obj.dateformat;
}
else
{
date = "yyyy-MM-dd";
}
return date;
}
}

// convert custom dateformat to system dateformat
public static DateTime CultureDate(string val)
{
CultureInfo culture = CultureInfo.CurrentCulture;
DateTime cultureDate = DateTime.ParseExact(val, DateFormat, culture);
return cultureDate;
}
}

DateFormatCo.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
/// Summary description for DateFormatCo
/// </summary>
public class DateFormatCo
{
public string dateformat { get; set; }

public string userid { get; set; }
}

Add a New Page with Name as RegistrationDetails.aspx

<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="FIRST NAME"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label2" runat="server" Text="LAST NAME"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label3" runat="server" Text="ADDRESS"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
</td>
</tr>

<tr>
<td>
<asp:Label ID="Label5" runat="server" Text="User Defined Format"></asp:Label>
</td>
<td>
<asp:DropDownList ID="dateFormat" runat="server" CssClass="Dropdown" Width="150%">
<asp:ListItem value="MM-dd-yyyy" Text="MM-DD-YYYY"></asp:ListItem>
<asp:ListItem value="MM-yyyy-dd" Text="MM-YYYY-DD"></asp:ListItem>
<asp:ListItem value="yyyy-MM-dd" Text="YYYY-MM-DD"></asp:ListItem>
<asp:ListItem value="yyyy-dd-MM" Text="YYYY-DD-MM"></asp:ListItem>
<asp:ListItem value="dd-MM-yyyy" Text="DD-MM-YYYY"></asp:ListItem>
<asp:ListItem value="dd.yyyy.MM" Text="DD.YYYY.MM"></asp:ListItem>
<asp:ListItem value="MM.dd.yyyy" Text="MM.DD.YYYY"></asp:ListItem>
<asp:ListItem value="MM.yyyy.dd" Text="MM.YYYY.DD"></asp:ListItem>
<asp:ListItem value="yyyy.MM.dd" Text="YYYY.MM.DD"></asp:ListItem>
<asp:ListItem value="yyyy.dd.MM" Text="YYYY.DD.MM"></asp:ListItem>
<asp:ListItem value="dd/MM/yyyy" Text="DD/MM/YYYY"></asp:ListItem>
<asp:ListItem value="dd/yyyy/MM" Text="DD/YYYY/MM"></asp:ListItem>
<asp:ListItem value="MM/dd/yyyy" Text="MM/DD/YYYY" Selected="True"></asp:ListItem>
<asp:ListItem value="MM/yyyy/dd" Text="MM/YYYY/DD"></asp:ListItem>
<asp:ListItem value="yyyy/MM/dd" Text="YYYY/MM/DD"></asp:ListItem>
<asp:ListItem value="yyyy/dd/MM" Text="YYYY/DD/MM"></asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label8" runat="server" Text="InputDateFormat"></asp:Label>
</td>
<td>
<select id="format">
<option value="mm/dd/yy">Default - mm/dd/yy</option>
<option value="yy-mm-dd">ISO 8601 - yy-mm-dd</option>

</select>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label4" runat="server" Text="Input DOB"></asp:Label>
</td>
<td>
<asp:TextBox ID="datepicker" runat="server" ></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label6" runat="server" Text="User Id"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label7" runat="server" Text="PassWord"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
</td>
</tr>
</table>
</div>
</form>
</body>

RegistrationDetails.aspx.cs

using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class afterlogindatedisplay : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("user id=sa;password=uday; database=uday;data source=localhost");
con.Open();
string datetime = Convert.ToString(Class1.CultureDate(Context.Request["datepicker"]).ToShortDateString());
SqlCommand cmd = new SqlCommand("insert into regsiterationdetails(fname,lname,address,dateformat,dob) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + dateFormat.Text + "','" + datepicker.Text + "')",con);
SqlCommand cmd1 = new SqlCommand("insert into logindetails(userid,password) values('" + TextBox5.Text + "','" + TextBox6.Text + "')", con);
int i = cmd.ExecuteNonQuery();
int i1 = cmd1.ExecuteNonQuery();
if ((i > 0)&&(i1>0))
{
Response.Redirect("login.aspx");
}
con.Close();
}
}

The details are registered successfully.

login.aspx

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="UserName"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label2" runat="server" Text="PassWord"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox2" runat="server" TextMode="Password"></asp:TextBox>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Button ID="Button1" runat="server" Text="Login" onclick="Button1_Click" />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>

login.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("user id=sa;password=uday; database=uday;data source=localhost");
con.Open();
SqlCommand cmd = new SqlCommand("select loginid from logindetails where userid='"+TextBox1.Text +"'and password='"+TextBox2.Text+"'", con);
SqlDataReader dr;
int no;
dr = cmd.ExecuteReader();
while (dr.Read())
{
no = Convert.ToInt32(dr[0]);
Context.Session["no"]=no;
}
con.Close();
int regno = Convert.ToInt16(Context.Session["no"]);
SqlDataAdapter da1 = new SqlDataAdapter("select * from regsiterationdetails where regid=" + regno, con);
DataSet ds = new DataSet();
da1.Fill(ds);
Context.Session["DefaultFormats"] = ds;
Response.Redirect("dateformatpage.aspx");

}
}

dateformatpage.aspx

Add the following jquery files which u have download
Create a new folder with name JQuery.
and paste those files in JQuery folder of ur website.
Copy any Calender.gif image file from google and paste in JQuery folder

and now go to datepicker.js
and change the following buttonImage property.

buttonImage: path of the image

<link rel="Stylesheet" href="JQuery/jquery-ui-1.8.16.custom.css" type="text/css"/>
<script type="text/javascript" src="JQuery/jquery.ui.datepicker.js"></script>
<script type="text/javascript" src="JQuery/jquery.ui.core.js"></script>

dateformat.aspx

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript" src="JQuery/jquery-1.6.2.js">
</script>

<link rel="Stylesheet" href="JQuery/jquery-ui-1.8.16.custom.css" type="text/css"/>

<script type="text/javascript" src="JQuery/jquery.ui.datepicker.js"></script>
<script type="text/javascript" src="JQuery/jquery.ui.core.js"></script>
<script type="text/javascript" language="javascript">
$(function () {
var dates = $("#dob").datepicker({
dateFormat: '<%= Context.Session["DatePickerFormat"] %>',
minDate: -0

});
});

</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td>
<asp:Label ID="ename" runat="server" Text="fname"></asp:Label>
</td>
<td>
<asp:TextBox ID="fname" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label2" runat="server" Text="lname"></asp:Label>
</td>
<td>
<asp:TextBox ID="lname" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label3" runat="server" Text="address"></asp:Label>
</td>
<td>
<asp:TextBox ID="address" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="dob"></asp:Label>
</td>
<td>
<input type="text" id="dob" name="dateFormat2" runat="Server" class="TextBox" style="Width:100px" />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>

dateformat.aspx.cs

using System.Web.UI;
using System.Data;
using System.Web.UI.WebControls;

public partial class dateformatpage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Context.Session["DefaultFormats"] != null)
{
DataSet ds = (DataSet)Context.Session["DefaultFormats"];
DataTable dt = new DataTable();
dt = ds.Tables[0];
string dob = string.Empty;
string dateformat = string.Empty;
string firstname=string.Empty;
string lastname=string.Empty;
string address=string.Empty;
foreach (DataRow dr in dt.Rows)
{
dateformat = dr[3].ToString();
dob = dr[4].ToString();
firstname=dr[0].ToString();
lastname=dr[1].ToString();
address=dr[2].ToString();
Context.Session["DatePickerFormat"] = dob;
}
string selectformat= Convert.ToString(Context.Session["DatePickerFormat"]);
this.dob.Value = Convert.ToDateTime(selectformat).ToString(dateformat);
this.fname.Text = Convert.ToString(firstname);
this.lname.Text = Convert.ToString(lastname);
this.address.Text = Convert.ToString(address);
}
}
}

output

Note :Please Select Input Date Format as   ISO 8601 - yy-mm-dd bec the above code has been written based on that format.

LoginPage

DateFormat Page

Sunday, September 9, 2012

Working with Array List PART 3

File->New->Project-Console Application

Output

Saturday, September 8, 2012

Working with Array List PART 2

using System.Collections;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
ArrayList arr = new ArrayList();
arr.Add("Uday");
arr.Add("Vijay");
Console.WriteLine("The count in the arraylist is " + arr.Count);
arr.Add("Shiva");
arr.Add("Raju");
// Whenever we add Five Element the Capacity will be double, the default capacity of
//ArrayList is 4
Console.WriteLine("the capacity in the arraylist is " + arr.Capacity);
arr.Add("Srikanth");
Console.WriteLine("the capacity in th arraylist is " + arr.Capacity);
arr.Add("Srinu");
arr.Add("Trisha");
arr.Add("Illeana");
arr.Add("Samantha");
Console.WriteLine("the capacity in th arraylist is " + arr.Capacity);
arr.Add("Chiranjeevi");
arr.Add("Prasad");
arr.Add("Venkatesh");
arr.Add("Murthy");
arr.Add("Charan");
arr.Add("Mahesh");
arr.Add("Pawan");
Console.WriteLine("The capacity in th arraylist is " + arr.Capacity);
arr.Add("AlluArjun");
Console.WriteLine("the capacity in th arraylist is " + arr.Capacity);
Console.ReadKey();
}
}
}

Output

Count:

It is used to count the total no of elements which are been inserted.

Output:

Count: It is used to Count the Total no of elements which are inserted.

Contains: It is used to check wheather the element exists in the ArrayList or Not.

Output:

Insert Method;

It will insert the element in the specified location of the index in the ArrayList.

AddRange

It will add the collections of elements in the object as individual objects in the Array List

Output:

RemoveAt

It will remove the object as specified in the argument.

Output

Working with ArrayList PART 1

ArrayList

File->New-> Project-Console Application

using System.Collections;

It is the namespace which is used.

Output

Add Method
It will add the element as object in the Array List. These Objects are stored in heap.

Saturday, September 1, 2012

GridView with DataSet ,DataTable, DataReader

DataBase Design

Default.aspx

Default.aspx.cs

protected void Button1_Click(object sender, EventArgs e)
{
/* dataset */
con = new SqlConnection("user id=sa;password=uday;database=uday;data source=localhost");
cmd=new SqlCommand("select *from customers", con);
con.Open();
da=new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds,"customers");
GridView1.DataMember = "customers";
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}

protected void Button3_Click(object sender, EventArgs e)
{
/* DataTable */
con = new SqlConnection("user id=sa;password=uday;database=uday;data source=localhost");
cmd = new SqlCommand("select *from customers", con);
con.Open();
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
con.Close();
}

protected void Button2_Click1(object sender, EventArgs e)
{
/* datareader */
con = new SqlConnection("user id=sa;password=uday;database=uday;data source=localhost");
cmd = new SqlCommand("select *from customers", con);
con.Open();
SqlDataReader dr;
dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
con.Close();
}

Output:

Friday, August 31, 2012

Access Specifiers in C#.

They are used to define scope of the Class or its Members i,e who can access it and who cannot Access it.

Here we will discuss about each access specifier with an example.

.Net Supports five Access Specifiers.

1 Public.
2 Private.
3 Protected.
4 Internal.
5 Protected Internal.

public:

So any member declared as public can be accessed from the outside the class.

We can access from other class using object reference.

Example

File-New- Project- Console Application.

In the above example we have created a object in Derived Class , since the variable is public it can be accessed from outside the class.

output

private

Members declared as private are not Accessible outside the class.

A class under Namespace cannot be declared as private.

Example

Output:

Example for Public and Private Access Specifier.

output

2 Example

output

Protected

If the members are declared as protected , then they can be accessed only From the child class., it is same as private.

Note: A class under Namespace cannot be declared as private.
This access specifier is used when we need to use Inheritance in the program.

output

Another Example of working with Protected Access Specifier.

Internal

Members are declared as internal under a class than they r accessible only with in the Project either from the Child Class or a Non Child Class. These are accessible only within the Assembly.

internal is the default Access Specifier for the Class.

output

Protected Internal

Members declared as ProtectedInternal under a Class enjoys Dual Scope. i,e with the project they behave as internal members and provide access to all the classes, outside the project they change to Protected and still provide access to there child classes.

Output:

Add a new project under the solution of type Console Application, name it as ConsoleApplication2 & rename the default file Program.cs as Four.cs so that class name also changes as Four, now write the following code in it by adding the reference of ConsoleApplication1 assembly from its physical location.

DOTNET

Friday, September 14, 2012

Working with Custom Date Format using Jquery ( *****)

Sunday, September 9, 2012

Working with Array List PART 3

Saturday, September 8, 2012

Working with Array List PART 2

Working with ArrayList PART 1

Saturday, September 1, 2012

GridView with DataSet ,DataTable, DataReader

Friday, August 31, 2012

Access Specifiers in C#.

Kubernetes

Report Abuse