Sql concatenate select query statement

The following example concatenates non character, non binary expressions by using “CAST”. EmpData having following data : Id   Name    DateTime                                          Address 2    Madhu    2011-02-02 00:00:00.000    Pune select ‘ this is my ‘ + name +’–‘ + CAST( Id as nvarchar) from EmpData output will be – this is my Madhu–2 Using “CONVERT” – select ‘… Read More Sql concatenate select query statement

popup grid with PopupControlExtender ajax control

//markup main.aspx page put gridview inside update panel for not post back <div> <asp:ScriptManager ID=”ScriptManager1″ runat=”server”> </asp:ScriptManager> <asp:UpdatePanel ID=”UpdatePanel1″ runat=”server”> <ContentTemplate> <asp:GridView ID=”GridView1″ runat=”server” AutoGenerateColumns=”False” BorderColor=”#336699″ BorderStyle=”Solid” BorderWidth=”1px” CellPadding=”3″ Font-Names=”Verdana” Font-Size=”10pt” onrowcreated=”GridView1_RowCreated”> <Columns> <asp:BoundField DataField=”Id” HeaderText=”ID” /> <asp:BoundField DataField=”Title” HeaderText=”Title” /> <asp:TemplateField ItemStyle-Width=”40″ ItemStyle-HorizontalAlign=”Right”> <ItemTemplate> <asp:Image ID=”Image1″ runat=”server” ImageUrl=”~/magnify.gif” /> <asp:PopupControlExtender ID=”PopupControlExtender1″ runat=”server” PopupControlID=”Panel1″ TargetControlID=”Image1″… Read More popup grid with PopupControlExtender ajax control

javascript for goUrl

function goURL(index) { var URL = new Array() URL[‘index’] = “index.htm” URL[‘contact_us’] = “contact_us.htm” URL[‘privacy’] = “privacy.htm” URL[‘sitemap’] = “sitemap/sitemap.htm” location.href = URL[index] } <div id=”footerhome”> <li><a href=”javascript:goURL(‘index’)”>Home</a></li> <li></li><li><a href=”javascript:goURL(‘contact_us’)”>Contact Us</a>&nbsp;</li> </div>

Update panel / Modal popup Demo

login update panel <script type=”text/javascript”> function pageLoad() { try { $find(“mdlSignInPopup”).add_shown(onModalPopupShown); } catch (err) { } try { $find(“mdlNewUserPopup”).add_shown(onModalPopupShown); } catch (err) { } } function onModalPopupShown() { try { $get(“<%=txtUsername.ClientID%>”).focus(); } catch (err) { } try { $get(“<%=txtFirstName.ClientID%>”).focus(); } catch (err) { } } </script> <asp:UpdatePanel ID=”UpdatePanel1″ runat=”server”> <ContentTemplate> <div id=”divSignIn”> <div style=”margin-left: 15px;margin-right:… Read More Update panel / Modal popup Demo