How to Use Replace Query in SQL

UPDATE emp_details set lastname=replace(lastname, 'Kumar', 'Sharma') where serial_num=100

How to use While loop in Sql Query Analyser

declare @i as int
set @i=1
BEGIN
while @i < 10

UPDATE employee_details set lastname='Kumar' where serial_num=@i
set @i=@i+1

END;

Convert unicode in hex

 string str = "युवराज फिर बने भारत की जीत के नायक"; //unicode text

        string data= string.Empty;  //for high performance
        foreach (char ch in str)
        {
            int temp= ch;
            data+= String.Format("{0:x4}", (uint)System.Convert.ToUInt32(temp.ToString()));
        }
        data= data.ToUpper();

How to use ajax animation extender

<style type="text/css">.flyOutDiv{display: none; position: absolute; width: 400px; z-index: 3; opacity: 0; filter: (progid: DXImageTransform.Microsoft.Alpha(opacity=0)); font-size: 18px; border: solid 1px #FFFFFF; background-color: #FFFFFF; padding
} : 5px;.flyOutDivCloseX{background-color: #666666; color: #FFFFFF; text-align: center; font-weight: bold; text-decoration: none; border: outset thin #FFFFFF; padding
}
: 5px; </style>

How to do paging in Datalist Control in asp.net

In Design page add two link button and a data list control i.e ".aspx" page


<asp:LinkButton ID="lnkPrevious" CssClass="footertxt" runat="server" onclick="lnkPrevious_Click">Previous</asp:LinkButton>&nbsp;
<asp:LinkButton ID="lnkNext" runat="server" CssClass="footertxt" onclick="lnkNext_Click">Next</asp:LinkButton>
<asp:DataList ID="DataList1" runat="server" RepeatColumns="3"
<ItemTemplate>
"In this section add your design "
</ItemTemplate>
</asp:DataList>
 Now in .cs file write code given as :
public partial class test: System.Web.UI.Page
{
SqlDataAdapter da;
DataSet ds;
string conn;
static DataTable dt;
PagedDataSource pds;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
BindGrid();
}
public void BindGrid()
{
string conn = ConfigurationManager.ConnectionStrings["yourconnectioname"].ConnectionString;
string sql="Select * from Tbl_FreeRegister" ;
da = new SqlDataAdapter(sql, conn);
dt = new DataTable();
da.Fill(dt);
pds = new PagedDataSource();
pds.DataSource = dt.DefaultView;
pds.AllowPaging = true;
pds.PageSize = 9;
pds.CurrentPageIndex = CurrentPage;
lnkbtnPrevious.Enabled = !pds.IsFirstPage;
lnkbtnNext.Enabled = !pds.IsLastPage;
DataList1.DataSource = pds;
DataList1.DataBind();
}
//Define Property
public int CurrentPage
{
get
{
if (this.ViewState["CurrentPage"] == null)
return 0;
else
return Convert.ToInt16(this.ViewState["CurrentPage"].ToString());
}
set
{
this.ViewState["CurrentPage"] = value;
}
}
//linkbutton click event
protected void lnkPrevious_Click(object sender, EventArgs e)
{
CurrentPage -=1;
BindGrid();
}
protected void lnkNext_Click(object sender, EventArgs e)
{
CurrentPage += 1;
BindGrid();
}
}

Select MAX no from particular column in SQL Server or MAX fuction

If we have a table design like as :

Alter table command

alter table table_name alter column membership_no int

select MAX(membership_no) as Membership from table_name

ShutDown System By programming in asp.net

1. using System.Management;   
2.   
3. public static void ShutDownComputer()   
4. {   
5.         ManagementBaseObject outParam = null;   
6.         ManagementClass sysOS = new ManagementClass("Win32_OperatingSystem");   
7.         sysOS.Get();   
8.          
9.         sysOS.Scope.Options.EnablePrivileges = true;    
10.       
11.         ManagementBaseObject inParam = sysOS.GetMethodParameters("Win32Shutdown");   
12.        
13.         inParam["Flags"] = "1";    
14.         inParam["Reserved"] = "0";   
15.         foreach (ManagementObject manObj in sysOS.GetInstances())   
16.         {   
17.             outParam = manObj.InvokeMethod("Win32Shutdown", inParam, null);   
18.         }   
19. }