Home » 2011 » March » 30

Archive for March 30, 2011

Microsoft SQL Express Version

March 30, 2011 - Posted in Applications, MS SQL - Permalink

To check MSSQL Version and service pack, create new query, pass below parameters and run the query. select serverproperty(‘ProductVersion’) Version, serverproperty(‘Edition’) Edition, serverproperty(‘ProductLevel’) ProductLevel, serverproperty(‘ComputerNamePhysicalNetBIOS’) PhysicalNetBIOS, serverproperty(‘ResourceVersion’) ResourceVersion

Simple record query inside gridview

March 30, 2011 - Posted in Access, Applications, ASP.NET - Permalink

Here is simple record query inside the datagrid. I was looking for this solution which does not require code behind. Access DB structure Detail.aspx page code: <form id=“form1” runat=“server”> <div> <asp:GridView ID=”GridView1″ runat=”server” AutoGenerateColumns=”False” DataKeyNames=”ID” DataSourceID=”DetailView” GridLines=”None”> <Columns> <asp:TemplateField> <ItemTemplate> <table width=”660px” border=”0″ cellpadding=”0″ cellspacing=”0″> <tr> <td colspan=”4″> <a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p1″><img src=”images/<%# Container.DataItem(“Pic1″)%>” width=”75px” height=”54px” border=”0″/></a>&nbsp; […]