Rajesh Kamalakshan: July 2010

Tuesday, July 13, 2010

How to know the number of rows in all the tables in a SQL server 2005 database?

The blow query will show the number of rows in all the tables in a SQL server 2005 database

select distinct sysobjects.name,sysindexes.rows from sysobjects
inner join sysindexes on sysindexes.id=sysobjects.id
where sysobjects.xtype='u'
order by sysindexes.rows desc

or you can use the below querry to the same details

SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count

FROM sys.dm_db_partition_stats st
WHERE index_id < 2
ORDER BY st.row_count DESC

Saturday, July 10, 2010

How to clear the text values of an Ajax ComboBox control?

Today I had Googled a lot to find a solution for clearing the text box values of an Ajax ComboBox, but unfortunately I could find any accurate solution. Then I finally decided to make some changes to the code which is published in my blog (http://rajeshkamalakshan.blogspot.com/2010/05/how-to-get-selected-text-of-microsoft.html) to achieve the above result.

For all you please find the code to clear the text box values of an Ajax ComboBox

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>

<%@ Register assembly="System.Web.Ajax" namespace="System.Web.UI" tagprefix="asp" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>Untitled Page</title>
    <script runat="server">
    protected void Page_Load(object sender, EventArgs e)
    {
       
        TextBox textBox = ComboBox1.FindControl("TextBox") as TextBox;
        if (textBox != null)
        {
            textBox.Attributes.Add("onBlur", "cmb_OnBlur(this);");
        }
        Button1.Attributes.Add("OnClick", "return ClearComboText(" + textBox.UniqueID  + ")");
    }
    </script>
    <script language="javascript" type="text/javascript">
    function ClearComboText(comboTextBox)
    {
    comboTextBox.value ="";
    return false;
    }
    function cmb_OnBlur(Text)
    {
         alert(Text.value  )
    }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:AjaxScriptManager ID="AjaxScriptManager1" runat="server">
        
        </asp:AjaxScriptManager>
    </div>
<asp:ComboBox ID="ComboBox1" runat="server">
    <asp:ListItem Value="R">Rajesh</asp:ListItem>
        <asp:ListItem Value="V">Vrinda</asp:ListItem>

</asp:ComboBox>
    <asp:Button ID="Button1" runat="server" Text="Button" />
    </form>
</body>
</html>