Archive
Archive for January, 2010
JQuery to Check User Name Availability from Database
January 26, 2010
4 comments
Hi
try this example to use JQuery to Check User Name Availability from Database using the following steps :
1) Open MS SQL Server and create new database with contains table with the following schema
CREATE TABLE [dbo].[UserTable]( [UserName] [varchar](30) NOT NULL, [FirstName] [varchar](50) NOT NULL, [LastName] [varchar](50) NOT NULL, [Email] [varchar](70) NOT NULL, CONSTRAINT [PK_UserTable] PRIMARY KEY CLUSTERED ( [UserName] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]
2) Create Stored Procedure which will check if user exist or not in table
CREATE PROCEDURE CheckUserName( @UserName VARCHAR(50) ) AS BEGIN IF EXISTS (SELECT * FROM UserTable WHERE [UserName] = @UserName ) SELECT '1'; --user name already exist in database ELSE SELECT '0'; --user name does not exist in database END
3) Open VS2005 and create a new web site and add new web form
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Register.aspx.cs" Inherits="_Default" %>
<head id="Head1" runat="server">
<title></title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.0/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$("#<%=txtUserName.UniqueID%>").change(function() {
var uname = $("#<%=txtUserName.UniqueID%>");
var msgbox = $("#status");
if (uname.val().length > 5) {
$.ajax({
type: "POST",
url: "Register.aspx/CheckUserName",
data: "{'args': '" + uname.val() + "'}",
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function(msg) {
if (msg.d == 'Available') {
uname.removeClass("notavailablecss");
uname.addClass("availablecss");
msgbox.html('<img src="Images/yes.png"> <font color="Green"> Available </font>');
}
else {
uname.removeClass("availablecss");
uname.addClass("notavailablecss");
msgbox.html(msg.d);
}
}
});
}
else {
uname.addClass("notavailablecss");
msgbox.html('<font color="#cc0000">User Name must be more than 5 characters</font>');
}
});
});
</script>
<style type="text/css">
body
{
font-family:Arial, Helvetica, sans-serif
}
#status
{
font-size:11px;
margin:10px;
}
.availablecss
{
background-color:#CEFFCE;
border:1px solid green;
}
.notavailablecss
{
background-color:#FFD9D9;
border:1px solid red;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<br />
User Name :
<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox>
<span id="status"></span> </form>
</body>
</html>
4) In code behind add the following code
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[System.Web.Services.WebMethod]
public static string CheckUserName(string args)
{
string returnValue = string.Empty;
string conString = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(conString);
try
{
SqlCommand sqlCmd = new SqlCommand("CheckUserName", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@UserName", args.Trim());
sqlConn.Open();
int success = int.Parse((sqlCmd.ExecuteScalar().ToString()));
if (success == 1) // User Name Not Available
{
returnValue = "<img src='Images/no.png'> <font color='#cc0000'><b>'" + args + "'</b> is already in use.</font></img>";
}
else if (success == 0)//User_Name is available
{
returnValue = "Available";
}
}
catch
{
//Handle Error
}
finally
{
sqlConn.Close();
}
return returnValue;
}
}
5) In web.config file add the connection string
<connectionStrings> <add name="MyConnection" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True" /> </connectionStrings>
after that run your application
Hope this helps
Good Luck.
Categories: ASP.Net, Javascript, Jquery
Gridview Row Tooltip
January 15, 2010
3 comments
Hi
try this example to Show Tooltip with Gridview Row
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "<a href="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd</a>">
<html xmlns="<a href="http://www.w3.org/1999/xhtml">http://www.w3.org/1999/xhtml</a>" >
<head runat="server">
<title>Untitled Page</title>
<script language="javascript" type="text/javascript">
function ShowTooltip(name,address,city,state,phone1,fax)
{
// var Popup = document.getElementById("Popup");
document.getElementById("td0").innerText=name;
document.getElementById("td1").innerText=address;
document.getElementById("td2").innerText=city;
document.getElementById("td3").innerText=state;
document.getElementById("td4").innerText=phone1;
document.getElementById("td5").innerText=fax;
x = event.clientX + document.body.scrollLeft;
y = event.clientY + document.body.scrollTop + 10;
Popup.style.display="block";
Popup.style.left = x;
Popup.style.top = y;
}
function HideTooltip()
{
Popup.style.display="none";
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="CustomerID" DataSourceID="SqlDataSource1" OnRowDataBound="GridView1_RowDataBound">
<Columns>
<asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" />
<asp:BoundField DataField="CompanyName" HeaderText="CompanyName" SortExpression="CompanyName" />
<asp:BoundField DataField="ContactName" HeaderText="ContactName" SortExpression="ContactName" />
<asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
<asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [CustomerID], [CompanyName], [ContactName], [Address], [City], [Phone] FROM [Customers]">
</asp:SqlDataSource>
</div>
<div id="Popup">
<div style="BACKGROUND-COLOR: #003366"><b><center>Address</center></b></div>
<div>
<table width="100%" border=0 cellpadding=0 cellspacing=0>
<tr>
<td id=td0 align=left></td>
</tr>
<tr>
<td id=td1 align=left></td>
</tr>
<tr>
<td id=td2 align=left></td>
</tr>
<tr>
<td id=td3 align=left></td>
</tr>
<tr>
<td id=td4 align=left></td>
</tr>
<tr>
<td id=td5 align=left></td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
and in code behind :-
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "ShowTooltip('" +
DataBinder.Eval(e.Row.DataItem, "CompanyName").ToString() + "','" +
DataBinder.Eval(e.Row.DataItem, "CustomerID").ToString() + "','" +
DataBinder.Eval(e.Row.DataItem, "ContactName").ToString() + "','" +
DataBinder.Eval(e.Row.DataItem, "Address").ToString() + "', '" +
DataBinder.Eval(e.Row.DataItem, "City").ToString() + "','" +
DataBinder.Eval(e.Row.DataItem, "Phone").ToString() +
"');");
e.Row.Attributes.Add("onmouseout", "HideTooltip();");
}
}
Hope this helps
Good Luck
Categories: ASP.Net
Bind RadioButtonList with Image from Database
January 14, 2010
Leave a comment
Hi
try this example to Bind RadioButtonList with Image from Database
Step1 :- Open MS SQL Server 2005 and create Database which contains Table called “Photo” whith the following fields
- Id –> (int) Primary key
- Title –> nvarchar(50)
- Pic –> nvarchar(20)
Step2 :- Open MS VS2005 and craete new website and add new folder called “images” which will contain all image that i will save it’s name with it’s Extension in my table
Step3 :- add new web page and add RadioButtonList control
Step4 :- in code behind of web page add the following code
public DataSet GetPhoto()
{
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = "select * from Photo";
comm.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter(comm);
adapter.Fill(ds);
return ds;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet photoDS = GetPhoto();
if (photoDS.Tables.Count > 0)
{
DataTable dt = photoDS.Tables[0];
foreach (DataRow row in dt.Rows)
{
ListItem item = new ListItem();
item.Text = "<img Width=\"100\" Height=\"100\" runat=\"Server\" src=\"images/" + row["Pic"].ToString() + "\" alt="+row["Title"].ToString()+" />";
item.Value = row["Id"].ToString();
RadioButtonList1.Items.Add(item);
}
//-- To Select First item in RadioButtonList
RadioButtonList1.Items[0].Selected = true;
RadioButtonList1.DataBind();
}
}
}
Step5:- in web.config add the connectionstring
<connectionStrings> <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings>
after that run the website
Hope this helps
Good Luck.
Categories: ASP.Net
Validate Dropdownlist using Javascript
January 11, 2010
Leave a comment
Hi
try this example to Validate Dropdownlist using Javascript
you can also check these posts to Validate DropdownList using Validator Controls
Validate DropdownList using Compare Validator
Validate DropdownList using Custom Validator
Validate DropdwonList with RequiredField Validator
<head>
<script type ="text/javascript">
function CountryCheck()
{
var ddlCountry = document.getElementById ("<%=ddlCountry.ClientID%>");
var ddlCity = document.getElementById ("<%=ddlCity.ClientID%>");
var country = ddlCountry.options[ddlCountry.selectedIndex].value;
var city = ddlCity.options[ddlCity.selectedIndex].value;
if (country == "0")
{
alert("Please Select Country");
return false;
}
else
{
if (city == "0")
{
alert("Please Select City");
return false;
}
}
return true;
}
</script>
</head
<asp:DropDownList ID="ddlCountry" runat="server">
<asp:ListItem Text ="----Select Country----" Value ="0"></asp:ListItem>
<asp:ListItem Text ="US" Value ="1"></asp:ListItem>
<asp:ListItem Text ="UK" Value ="2"></asp:ListItem>
<asp:ListItem Text ="IN" Value ="3"></asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="ddlCity" runat="server">
<asp:ListItem Text ="----Select City----" Value ="0"></asp:ListItem>
<asp:ListItem Text ="Mumbai" Value ="1"></asp:ListItem>
<asp:ListItem Text ="Delhi" Value ="2"></asp:ListItem>
<asp:ListItem Text ="Chennai" Value ="3"></asp:ListItem>
</asp:DropDownList><asp:Button ID="Button3" runat="server" Text="Button" OnClientClick = "return CountryCheck();" />
</body>
Hope this helps
Good Luck
Categories: ASP.Net, Javascript
Validate FCKEditor Control
January 5, 2010
Leave a comment
Hi
try this example to Validate FCKEditor Control using CustomValidator control
Your HTML Markup for FCKEditor:
<FCKeditorV2:FCKeditor ID="HTMLFCKeditor" runat="server" Height="400px" Width="100%"> </FCKeditorV2:FCKeditor> <asp:CustomValidator ID="CustomValidator2" runat="server" ValidationGroup="Invitation" ErrorMessage="Enter Message !" Display="Dynamic" ClientValidationFunction="ValidateFCKEditor"></asp:CustomValidator>
CustomValidator Javascript Function:
function ValidateFCKEditor(source, args)
{
var fckEditorClientID = document.getElementById('<%=HTMLFCKeditor.ClientID%>');
args.IsValid = FCKeditorAPI.GetInstance(fckEditorClientID.id).GetXHTML(true) != "";
}
Hope this helps
Good Luck.
Categories: ASP.Net, Javascript
Error: The task with the name Data Flow Task and the creation name “DTS.Pipeline.1” is not registered for use on this computer
January 1, 2010
2 comments
I also ever experienced this problem. This problem occured probably, you use username and password to log on to your computer, so sql server need to verify the user who authorized to use the sql server service.. But sometimes sql server cannot redirect to the account, so we need to configure the user.
Here’s the step :
1. open sql server configuration mangager
2. choose sql server 2005 services
3. right click sql server integration services, choose properties
4. choose log on tab, select this account, enter your username and password which is used to log on your computer.
5. reopen the business intelligence studio. There you are, the data flow task component can work properly again.
finally, i found out how to solve this problem…
thanks to sulton..
Categories: SQL Server
Yasser Zaid's Weblog 
Recent Comments