Validation Control (One Numeric,alphapet,special char)

^.*(?=.{8,})(?=.*\d)(?=.*[a-zA-Z])(?=.*[!@#$%^&*()_+-=]).*$

File Upload Validator

<>
< Text="Upload File" />>
<><>
< id="RegularExpressionValidator1" runat="server"
ErrorMessage="Only mp3, m3u or mpeg files are allowed!"
ValidationExpression="^(([a-zA-Z]:)(\\{2}\w+)\$?)(\\(\w[\w].*))
+(.mp3.MP3.mpeg.MPEG.m3u.M3U)$"
ControlToValidate="FileUpload1">><>
< id="RequiredFieldValidator1" runat="server"
ErrorMessage="This is a required field!"
ControlToValidate="FileUpload1">><>

To Close Window

To Close Window
function CloseWindow()
{
bName = navigator.appName; //1
bVer = parseInt(navigator.appVersion); //2
if (typeof document.body.style.maxHeight != "undefined")
{
window.open('','_self');
window.close();
}
else
{
win = top;
win.opener = top;
win.close ();}
}

Page.RegisterStartupScript

uncomment it

//Page.RegisterStartupScript("myscritp", "
");

// Page.RegisterStartupScript("scritp", "
");

Sql Quries

ROW_NUMBER()
Select ROW_NUMBER()OVER( order by loginDate desc) As SrNo, UserLoginName, Firstname, Lastname, Email,Regdate, dbo.fnYesNo(isActive)UserActive, dbo.fnyesno(isDelete) UserDeleted,Count(isActive) as NoofLogins, Min(loginDate) FirstLoginTime, Max(loginDate)LastLoginTime from View_userLogging where customerId=1 group by UserLoginName, Firstname, Lastname, email, Regdate, isActive,CustomerID, isDelete,loginDate
Function Creation
CREATE FUNCTION [dbo].[fnAccessType] (@PassChar varchar(1))
RETURNS VARCHAR(30) as
BEGIN
Declare @Result varchar(30)
set @Result= Case @PassChar
When '0' then 'Public'
When '1' then 'Private'
When '2' then 'Protected'
End
RETURN (@Result)
END
Function Creation
Alter FUNCTION GetUserName (@UserLoginName varchar(100))
RETURNS VARCHAR(300) asBEGIN
Declare @Result varchar(300)
set @Result=(select FirstName +' '+ LastName+ ' ('+ UserLoginName+')' from UserLogin where UserLoginName=@UserLoginName)
RETURN (@Result)
End

Creating Function

ALTER FUNCTION [dbo].[fnUsage] (@UsgSec int)

RETURNS VARCHAR(10)

as

BEGIN
Declare @Result varchar(10),@min decimal,@mins int,@hrs int,@tmp varchar(10)
If (IsNumeric(@UsgSec)=1) Begin set @min=floor(@UsgSec/60)
If (@min>0 )

begin

set @hrs=@UsgSec/3600

set @mins=@min - floor(@min/60)*60
set @tmp=CAST(@hrs AS varchar(10)) + ':' +right(100+CAST(@mins as varchar(10)),2)
end

else

begin

set @tmp='0:00' end
set @Result = @tmp + ':' + right( 100+ Cast(convert(int,(@UsgSec % 60))as varchar (10)),2) EndElse Begin set @Result='0:00:00'

End
RETURN (@Result)
END

Database connection

Method1
{
cn.Open();
string ster="select *from Employee";
cmd.CommandText=Str;
cmd.Connection=cn;
dr=cmd.ExecuteReader()
if(!dr.Read())
{
string TempVar=(string) dr.GetValule(0);
drpEmployee.Items.Add(TempVar);
}
}
Method2
To fill DataGrid
{
cn.Open();
ds.Clear(0
string str="select *from Employee";
cmd.CommandTex=str;
cmd.Connection=cn;
da.SelectCommand=cmd;
da.Fill(ds,"Test");
gridEmployee.DataSource=ds;
gridEmployee.DataMember="Test";
gridEmployee.DataBind();
}
Method3
using System.Data.SqlClient;
Using System.Configuration;

Public Sql Connection cn=new SqlConnection(ConfigurationSetting.AppSettings.Get("ConnectionString")
public SqlCommand cmd=new SqlCommand();
public SqlDataAdaptor da=new SqlDataAdaptor();
Button Click
{
cn.Open();
cmd=new SqlCommand("School_Add",cn);
cmd.CommandType=CommandType.StoredProcedure;
SqlParameter parStudentName=new SqlParameter("@StudentName",SqlDbType.Varchar,50);
parStudentName.Value=this.txtStudentName.Text;
cmd.Parameters.Add(parStudentName);
"
"
cmd.ExecuteNonQuery();

}

Link Button in GridView

Button Click
{
GridViewRow row=(GridViewRow)((LinkButton)Sender).NamingContainer;
string ComplaintId=GridView1.DataKeys[row.RowIndex].Value.ToString();
string str=GridView1.Rows[row.RowIndex].Cells[3].Text.ToString();
}