Render Codein aspx page using XML and XSL

Once you have created your template (Xml,Xslt) then you have to render on the page for render the code in your page you have to create one of the place holder in your page and place form load code in you load section.

You must need to modify your xml,xsl file name.



protected void Page_Load(object sender, EventArgs e)
{
XslCompiledTransform proc = new XslCompiledTransform();
proc.Load(Server.MapPath("XSLTFile.xsl"));
StringWriter writer = new StringWriter();
proc.Transform(XmlReader.Create(Server.MapPath("form.xml")), null, writer);
P1.Controls.Add(Page.ParseControl(writer.ToString()));
}

Some time Asp.net controls doesn't placed in the pages using xslt so you have to apply the above format or lines or code other wise you can directly render the code using this control

Column level query

Check the column is already exist or not, on alter the table, During the add a new column.


if Not exists (select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='tblMurli'
and COLUMN_NAME='My_NewColumn' )
Alter table tblMurli Add My_NewColumn numeric(18, 0)

List Generic Controls

public class Product
{
public Product()
{
//
// TODO: Add constructor logic here
//
}
private int number;
public int Number
{
get { return number; }
}

private string name;
public string Name
{
get { return name; }
}

public Product(int number, string name)
{
this.name = name;
this.number = number;
}
}

===============================================
// List
List list = new List();
list.Add(new Product(1,"Murli"));
list.Add(new Product(2,"Sanjay"));
list.Add(new Product(3,"Mahesh"));
list.Add(new Product(4,"Tom"));


List intlist = new List();
intlist.Add(1);
intlist.Add(2);
intlist.Add(5);
intlist.Add(7);

for (int i = 0; i < intlist.Count; i++)
{
lblMessage.Text += "
No " + i + " :" + intlist[i];
}

foreach (int layland in intlist)
{
lblMessage.Text += layland;
}


GridView1.DataSource = intlist;
GridView1.DataBind();

Write Xml File Via Sql

Comment everything from the aspx page and write below code in the code behind files

1.==================================
string Con = "Data Source="46\\SQLEXPRESS2008;User id=sa;password=murli;Initial Catalog=Murli";
XmlDocument xDoc = new XmlDocument();
XPathNavigator xPath = xDoc.CreateNavigator();
using (SqlConnection Conn = new SqlConnection(Con))
{
Conn.Open();
SqlCommand Cmd = new SqlCommand("Select * from Product As Products For Xml Auto,Elements", Conn);
using (XmlWriter xW = xPath.PrependChild())
{
xW.WriteStartElement("Products");
using (XmlReader xR = Cmd.ExecuteXmlReader())
{
xW.WriteNode(xR, true);
}
xW.WriteEndElement();
}
}
Response.ContentType = "text/xml";
xDoc.Save(Response.Output);

2.=================================
using System.IO;
using System.Text;
using System.Data.SqlClient;


protected void Button1_Click(object sender, EventArgs e)
{
string str = "";
SqlConnection con = new SqlConnection("Data Source=MyDataSource\\SQLEXPRESS2008;Initial Catalog=Murli;User ID=sa;Password=murli");
con.Open();
string s = "select * from tblAnswer";
SqlCommand cmd = new SqlCommand(s, con);
SqlDataReader dr = cmd.ExecuteReader();
StringBuilder sb = new StringBuilder();
sb.Append("");
sb.Append("");
while (dr.Read())
{
sb.Append("");
sb.Append("" + dr[0].ToString() + "");
sb.Append("" + dr[1].ToString() + "");
sb.Append("");
}
sb.Append("");

StreamWriter stw = File.CreateText("D://mutest1.xml");
stw.WriteLine(sb.ToString());
stw.Close();
}

Read XML File from Javascript

For reading xml data using javascript we need to go to the following steps.
1. First create xml file File name called book.xml or anything else.
2. on the another file write the below code
============================book.xml=============================================
<?xml version="1.0" encoding="utf-8" ?>
<bookstore>
<book category="cooking">
<title lang="en">Everyday Italian</title>
<author>Giada De Laurentiis</author>
<year>2005</year>
<price>30.00</price>
</book>
<book category="children">
<title lang="en">Harry Potter</title>
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>
<book category="web">
<title lang="en">XQuery Kick Start</title>
<author>James McGovern</author>
<author>Per Bothner</author>
<author>Kurt Cagle</author>
<author>James Linn</author>
<author>Vaidyanathan Nagarajan</author>
<year>2003</year>
<price>49.99</price>
</book>
<book category="web" cover="paperback">
<title lang="en">Learning XML</title>
<author>Erik T. Ray</author>
<year>2003</year>
<price>39.95</price>
</book>
</bookstore>
==================================================
================Page where want to display the xml data =============================
<head>
<script type="text/javascript">
function loadXmlData(FName)
{
try{ // Internet Explorer
xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
}
catch(e){
try{ // Mozila,Safari,Opera,etc
xmlDoc = document.implementation.createDocument("","",null);
}
catch(e){alert(e.message);}
}

try{
xmlDoc.async = false;
xmlDoc.load(FName);
return xmlDoc;
}
catch(e){alert(e.message);}
}

function get_firstChild(n)
{
y=n.firstChild;
while (y.nodeType!=1)
{
y=y.nextSibling;
}
return y;
}
</script>
</head>

<body>
<script type="text/javascript">
xmlDoc=loadXmlData("books.xml");
var Count = xmlDoc.getElementsByTagName("title");
//alert(Count.length);
for(var z=0;z<Count.length-1;z++)
{
document.write(z+1+" "+Count[z].childNodes[0].nodeValue +"<br/>");
}


document.write("<hr/>");
document.write(xmlDoc.getElementsByTagName("title")[0].childNodes[0].nodeValue);
document.write("<br />");
document.write(xmlDoc.getElementsByTagName("author")[0].childNodes[0].nodeValue);
document.write("<br />");
document.write(xmlDoc.getElementsByTagName("year")[0].childNodes[0].nodeValue);

x=get_firstChild(xmlDoc.getElementsByTagName("book")[3]);
document.write(x.nodeName);
</script>
</body>

==================Output=====================
1 Everyday Italian
2 Harry Potter
3 XQuery Kick Start
<hr/>
Everyday Italian
Giada De Laurentiis
2005title

Execute Sql stmt using procedure

EXEC sp_executesql N'SELECT * FROM tblFirst'

Count number of active user in asp.net

global.asax
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
Application["OnlineUsers"] = 0;
}

void Session_Start(object sender, EventArgs e)
{
// Code that runs when a new session is started
Application.Lock();
Application["OnlineUsers"] = (int)Application["OnlineUsers"] + 1;
Application.UnLock();
}

void Session_End(object sender, EventArgs e)
{
// Code that runs when a session ends.
// Note: The Session_End event is raised only when the sessionstate mode
// is set to InProc in the Web.config file. If session mode is set to StateServer
// or SQLServer, the event is not raised.
Application.Lock();
Application["OnlineUsers"] = (int)Application["OnlineUsers"] - 1;
Application.UnLock();
}

=============================================
Get data in page
lblMessage.Text = DateTime.Now.ToShortDateString();
lblMessage.Text += " " + Application["OnlineUsers"].ToString();

Encript Decript String In Asp.Net

public string Encrypt(string text) // public static string Encrypt(string text)
{
try
{
text = text.Trim();
byte[] encData_byte = new byte[text.Length];
encData_byte = System.Text.Encoding.UTF8.GetBytes(text);
string encodedData = Convert.ToBase64String(encData_byte);
return encodedData;
}
catch
{
throw;
}
// return string.Empty;
}
public string Decrypt(string text) // public static string Decrypt(string text)
{
try
{
text = text.Trim();
System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();
System.Text.Decoder utf8Decode = encoder.GetDecoder();
byte[] todecode_byte = Convert.FromBase64String(text);
int charCount = utf8Decode.GetCharCount(todecode_byte, 0, todecode_byte.Length);
char[] decoded_char = new char[charCount];
utf8Decode.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0);
string result = new String(decoded_char);
return result.Replace("\\","").Replace("\"","");
}
catch
{
throw;
// Handle Exception Here
}
// return string.Empty;
}

Call Encript Decript Finction In Code Behind file:-
string Id = Decrypt(Request["Id"]);
string Id = Encrypt("\"" + Ds.Tables[0].Rows[i]["MaterialID"].ToString() + "\"");

To script All the Stored Procedures in the Database :

SELECT O.Name as ProcName
,M.Definition as CreateScript
,O.Create_Date
,O.Modify_Date
FROM sys.sql_modules as M INNER JOIN sys.objects as O
ON M.object_id = O.object_id
WHERE O.type = 'P'

If the Stored Procedure is created with ENCRYPTION option then you will get the NULL in the definition column.

Similarly,

To script All the Views in the Database :

SELECT O.Name as ProcName
,M.Definition as CreateScript
,O.Create_Date
,O.Modify_Date
FROM sys.sql_modules as M INNER JOIN sys.objects as O
ON M.object_id = O.object_id
WHERE O.type = 'V'

To script All the Functions in the Database :

SELECT O.Name as ProcName
,M.Definition as CreateScript
,O.Create_Date
,O.Modify_Date
FROM sys.sql_modules as M INNER JOIN sys.objects as O
ON M.object_id = O.object_id
WHERE O.type = 'FN'

For scripting all Triggers small modification is required, instead of sys.objects I joined the sys.triggers with sys.sql_modules.

To script All the Triggers in the Database :

SELECT O.Name as ProcName
,M.Definition as CreateScript
,O.Create_Date
,O.Modify_Date
FROM sys.sql_modules as M INNER JOIN sys.triggers as O
ON M.object_id = O.object_id

Dynamic create table using code behind

Table table = new Table();

for (int j = 1; j < 4; j++)
{
TableRow row = new TableRow();
TableCell cell = new TableCell();
// Add the control to the TableCell
string Temp = j==1 ? str1 : j==2 ? str2 : j==3 ? str3 : "";
cell.Text = Temp;
row.Controls.Add(cell);
table.Rows.Add(row);
}
this.Page.Controls.Add(table);

Encript And Decript String

Encrypting Connection String Code

private string EncryptConnectionString(string connectionString)
{
Byte[] b = System.Text.ASCIIEncoding.ASCII.GetBytes(connectionString);
string encryptedConnectionString = Convert.ToBase64String(b);
return encryptedConnectionString;
}

Once you got the encrypted connection string you can copy and paste it in the web.config file
<appSettings>
<add key="ConnectionString" value="ZGF0YSBzb3VyY2U9Llx2c2RvdG5ldDtpbml0aWFsIA0KICAgY2F"/>


Decrypting Connection String
private string DecryptConnectionString()
{
Byte[] b = Convert.FromBase64String(ConfigurationSettings.AppSettings["ConnectionString"]);
string decryptedConnectionString = System.Text.ASCIIEncoding.ASCII.GetString(b);
return decryptedConnectionString;
}

Gird view Find result

When you are using paging then you use lines of code for finding the rowindex id

GridViewRow gvr = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
int RowIndex = gvr.RowIndex;


When you are doesn't use paging then you ues below code to find the row index record

int index = Convert.ToInt32(e.CommandArgument);

// Retrieve the row that contains the button clicked
// by the user from the Rows collection. Use the
// CommandSource property to access the GridView control.
GridView customersGridView = (GridView)e.CommandSource;
GridViewRow row = customersGridView.Rows[index];

// Create a new ListItem object for the customer in the row.
Response.Write(Server.HtmlDecode(row.Cells[1].Text));

Data Bind

Binding database record in the your strcture.

<%#DataBinder.Eval(Container.DataItem,"FirstName")%>
<%#Eval("id") %>
<%#Bind("id") %>

Java Script Cookies

function Declaration of Read Cookies :--
function ReadCookie(cookieName) {
var theCookie=""+document.cookie;
var ind=theCookie.indexOf(cookieName);
if (ind==-1 cookieName=="") return "";
var ind1=theCookie.indexOf(';',ind);
if (ind1==-1) ind1=theCookie.length;
return unescape(theCookie.substring(ind+cookieName.length+1,ind1));
}
function calling of Read cookies :-
ReadCookie('MycookieName');