Talk in computer language.

Watermark Textbox ASP.NET AJAX Extension

This program is for Watermark text field. Copy below code into an AJAX enable website.

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

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

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

<title>Untitled Page</title>

</head>

<body>

<div>

Enter name:-<asp:TextBox ID="TextBox1" runat="server" BackColor="#C0C0FF"></asp:TextBox>

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<cc1:textboxwatermarkextender id="TextBoxWatermarkExtender1" runat="server"

TargetControlID="TextBox1"

WatermarkText="Write first and last name"

WatermarkCssClass="watermarked"

</cc1:textboxwatermarkextender>

</div>

</form>

</body>

</html>

ASP.Net AJAX calendar Extension

This example is for AJAX calendar Extender. You can make a stylish calendar simply by editing the CSS style. Open a ASP.Net AJAX enable page in your visual studio and paste the below code to make stylish calendar

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

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<title>Untitled Page</title>

/*Calendar Control CSS*/

.cal_Theme1 .ajax__calendar_container {

background-color: #DEF1F4;

border:solid 1px #77D5F7;

}

.cal_Theme1 .ajax__calendar_header {

background-color: #ffffff;

margin-bottom: 4px;

}

.cal_Theme1 .ajax__calendar_title,

.cal_Theme1 .ajax__calendar_next,

.cal_Theme1 .ajax__calendar_prev {

color: #004080;

padding-top: 3px;

}

.cal_Theme1 .ajax__calendar_body {

background-color: #ffffff;

border: solid 1px #77D5F7;

}

.cal_Theme1 .ajax__calendar_dayname {

text-align:center;

font-weight:bold;

margin-bottom: 4px;

margin-top: 2px;

color: #004080;

}

.cal_Theme1 .ajax__calendar_day {

color: #004080;

text-align:center;

}

.cal_Theme1 .ajax__calendar_hover .ajax__calendar_day,

.cal_Theme1 .ajax__calendar_hover .ajax__calendar_month,

.cal_Theme1 .ajax__calendar_hover .ajax__calendar_year,

.cal_Theme1 .ajax__calendar_active {

color: #004080;

font-weight: bold;

background-color: #DEF1F4;

}

.cal_Theme1 .ajax__calendar_today {

font-weight:bold;

}

.cal_Theme1 .ajax__calendar_other,

.cal_Theme1 .ajax__calendar_hover .ajax__calendar_today,

.cal_Theme1 .ajax__calendar_hover .ajax__calendar_title {

color: #bbbbbb;

}

</style>

</head>

<body>

<asp:ScriptManager ID="ScriptManager1" runat="server" />

<asp:TextBox SkinID="txtboxCustomizedMSkin" ID="tbEndDate" runat="server" CausesValidation="true" ReadOnly="true" />

<cc1:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="tbEndDate" CssClass= " cal_Theme1" />

</form>

</body>

</html>

Search data from DataTable using LINQ ASP.Net

Here I have shown how LINQ can use to find data from DataTable. Here i have used SQLServer 2005 database for database operation. Using sql query I am fetching data from database and after that the data is store into a data table. And at last I have used LINQ query to fetch my desire data from DataTable.

Step 1) Copy and paste below code and don't forget to change database connection code according to your system setting.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

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

{

SqlConnection con = new SqlConnection();

SqlCommand cmd = new SqlCommand();

SqlDataReader rd;

public string query;

protected void connection()

{

con.ConnectionString = "server=.\\SQLEXPRESS; integrated security=SSPI; initial catalog=sourav;";

con.Open();

cmd.Connection = con;

}

protected void Page_Load(object sender, EventArgs e)

{

connection();

SqlDataAdapter ad = new SqlDataAdapter("select * from loginfo",con);

DataTable dt = new DataTable("dt");

ad.Fill(dt);

int namec =(from c in dt.AsEnumerable()

where c.Field<string>("username") == "sourav"

select c).Count();

this.Label1.Text="Number of this name:- "+ namec.ToString() ;

}

Talk in computer language.

Saturday, March 10, 2012

Watermark Textbox ASP.NET AJAX Extension

ASP.Net AJAX calendar Extension

Search data from DataTable using LINQ ASP.Net

About Me