Get Table structure from XML in SQL Server

Get Table structure from XML in SQL Server.

Here is the script to get the table view from XML Document using OPENXML.

declare @doc varchar(1000)
declare @docHandle int
set @doc = '<Employee-Details>
     <Employee>
        <Firstname>Hariharasudhan</Firstname>
        <Lastname>Chandiramurthy</Lastname>
        <DOB>11-July-1982</DOB>
     </Employee>
     <Employee>
        <Firstname>Suguna</Firstname>
        <Lastname>Ramamurthy</Lastname>
        <DOB>02-September-1979</DOB>
     </Employee>
     <Employee>
        <Firstname>Pasupathy</Firstname>
        <Lastname>Thandavan</Lastname>
        <DOB>01-August-1982</DOB>
     </Employee>
   </Employee-Details>'
exec sp_xml_preparedocument @docHandle output, @doc
select * from openxml (@docHandle, '/Employee-Details/Employee', 1)
     with (FirstName varchar(100) './Firstname/text()'
        , LastName varchar(100) './Lastname/text()'
        , Date_Of_Birth varchar(100) './DOB/text()')

Check the given Url is Valid

Check the given Url is Valid

In some situation we want to check the particular url (eg:google.com) is valid or not through programatically.

Here is the code for checking the url.
urlcheck.aspx

<div>
<asp:TextBox ID = "txtUrl" runat = "server" Text = "http:\\">
</asp:TextBox>
<asp:Button ID = "btnCheck" runat = "server" OnClick = "ButtonClick" Text = "Check" />
<asp:Label ID = "lblMsg" runat = "server"></asp:Label>
</div>

urlcheck.aspx.cs

protected void ButtonClick(object sender, EventArgs e)
{
try
{
System.Net.HttpWebRequest objReq = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(txtUrl.Text);
System.Net.HttpWebResponse objRes = (System.Net.HttpWebResponse)objReq.GetResponse();
if (objRes.StatusCode == System.Net.HttpStatusCode.OK)
{
lblMsg.Text = "Url is Valid";
lblMsg.ForeColor = System.Drawing.Color.SeaGreen;
}
else
{
lblMsg.Text = "Url is not Valid";
lblMsg.ForeColor = System.Drawing.Color.Red;
}
objRes.Close();
}
catch (Exception ex)
{
lblMsg.Text = ex.Message.ToString();
lblMsg.ForeColor = System.Drawing.Color.Red;
}
}

Check All Option in TreeView control

Javascript : Check All Option in TreeView control
ASP.Net 2.0 Provides Tree view control with more features. It gives an option to select items through checkboxes. But there is no option for select all in a single click.

We can do that using Javascript. Here the stuff....

<script language = "javascript" type = "text/javascript">
function treeViewClick()
{
var checkStatus = false;
var obj = event.srcElement;
if(obj.tagName == 'INPUT' && obj.type == 'checkbox')
{
checkStatus = obj.checked;
while(obj.tagName != 'TABLE')
{
obj = obj.parentElement;
}
if(isParent(obj)) /// Parent Node ---- Needs to set the parent status (Checked or Unchecked) to its child.
{
obj = obj.nextSibling;
var tables = obj.getElementsByTagName('TABLE');
for(tblcnt = 0; tblcnt < tables.length; tblcnt++)
{
checkAllDependents(tables[tblcnt], checkStatus);
}
}
else /// Child Node --- Needs to set the parent of this child as unchecked...
{
var parent = obj.parentElement.previousSibling;
var parentchkboxes = parent.getElementsByTagName('INPUT');
if(parentchkboxes.length > 0 && checkStatus == false)
parentchkboxes[0].checked = false;
}
}
}

function checkAllDependents(element, isChecked)
{
var ctrls = element.getElementsByTagName('INPUT');
for(cnt = 0; cnt < ctrls.length; cnt++)
{
if(ctrls[cnt].type == 'checkbox')
{
ctrls[cnt].checked = isChecked;
}
}
}

function isParent(element)
{
var anchors = element.getElementsByTagName('A');
//if(anchors.length > 1) // the Treeview Node option of SelectAction is other than "none"
if(anchors.length > 0) // the Treeview Node option of SelectAction is "none"
return true;
else
return false;
}
</script>

Here is the controls scripts.

<div>
<asp:XmlDataSource ID = "dsXML" runat = "server">
<Data>
<Products>
<Type Name = "Microsoft">
<Product ID = "1" Name = "DOTNET" />
<Product ID = "2" Name = "SQLServer" />
<Product ID = "3" Name = "Office" />
</Type>
<Type Name = "Oracle">
<Product ID = "1" Name = "Oracle11g" />
<Product ID = "2" Name = "Oracle10g" />
<Product ID = "3" Name = "Oracle9i" />
</Type>
<Type Name = "Sun">
<Product ID = "1" Name = "J2EE" />
<Product ID = "2" Name = "J2ME" />
<Product ID = "3" Name = "JSP" />
</Type>
</Products>
</Data>
</asp:XmlDataSource>

<asp:TreeView ID = "tvProducts" runat = "server"
DataSourceID = "dsXML" onclick = "treeViewClick();"
ShowCheckBoxes = "Leaf" BackColor = "seagreen" ForeColor = "white">
<DataBindings>
<asp:TreeNodeBinding DataMember = "Products" Text = "Products" SelectAction ="none" />
<asp:TreeNodeBinding DataMember = "Type" TextField = "NAME" ShowCheckBox = "true" SelectAction="none" />
<asp:TreeNodeBinding DataMember = "Product" ValueField = "ID" TextField = "NAME" SelectAction="none" />
</DataBindings>
</asp:TreeView>
</div>

Awesome Features of VS.NET 2008

Awesome Features of VS.NET 2008
VS.NET 2008 (Framework 3.5) released with wonderful features.
Look on this
VS.NET 2008 Features