XploreDotNet

Forgot SQL Server Admin Password

noreply@blogger.com (windows_mss) — Sat, 14 May 2011 05:55:00 +0000

exec sp_password @new='NewPassword', @loginame='sa'
go
alter login sa enable
go

Bend Replacement for Traditional notepad ?

noreply@blogger.com (windows_mss) — Sat, 07 Aug 2010 17:53:00 +0000

Notepad is the light-weight text editor for Windows OS for a long time with simple UI and limited functionalities. I had a chance to try bend for few minutes and I am convinced with its functionalities.

Bend have all the functionalities available in the notepad, and also having tab interface, better find and replace, Zoom Ctrl + Mouse Wheel, Syntax highlighting etc.

Its Prerequisites,

Note :Apparently Bend works on Vista and XP SP3 as well. As long as .net 4.0 works

Courtesy:Codeplex

How To Zip The Folder using VB script

noreply@blogger.com (windows_mss) — Mon, 01 Feb 2010 16:09:00 +0000

Option Explicit

Const FOF_SIMPLEPROGRESS = 256
Dim MySource, MyTarget, MyHex, MyBinary, i
Dim oShell, oCTF
Dim oFileSys
dim winShell
Const cstrApp = "Zip It"
MySource = InputBox("Enter path to folder to zip (Ex:D:\xyzfolder)", cstrApp ) 'Example :"D:\test\"
MyTarget = InputBox("Enter path and name of Zip file (Ex:D:\xyz.zip)", cstrApp)'"D:\smp.zip"

MyHex = Array(80, 75, 5, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,0, 0)

For i = 0 To UBound(MyHex)
MyBinary = MyBinary & Chr(MyHex(i))
Next

Set oShell = CreateObject("WScript.Shell")
Set oFileSys = CreateObject("Scripting.FileSystemObject")

'Create the basis of a zip file.
Set oCTF = oFileSys.CreateTextFile(MyTarget, True)
oCTF.Write MyBinary
oCTF.Close
Set oCTF = Nothing

'Add File to zip
set winShell = createObject("shell.application")
winShell.namespace(MyTarget).CopyHere MySource

wScript.Sleep(5000)

'Follow these steps only if you're receiving the 800A01AD error for Wscript.Shell component. For any other ActiveX object, the following steps does not apply:
'Click Start, Run and type:
' * regsvr32 wshom.ocx
' * regsvr32 scrrun.dll

Wishing you all a very joyful, peaceful and happy New Year.

noreply@blogger.com (windows_mss) — Fri, 01 Jan 2010 05:15:00 +0000

Wishing you all a very joyful, peaceful and happy New Year.

How To Add Border To Image Within DataGrid Column in Silverlight

noreply@blogger.com (windows_mss) — Thu, 31 Dec 2009 05:11:00 +0000

<data:DataGridTemplateColumn Header="Image">
                        <data:DataGridTemplateColumn.CellTemplate>
                            <DataTemplate>
                                <Border BorderBrush="Black" Width="101" BorderThickness="1,1,1,1" Height="13" >
                                    <Image Width="25" Height="11" Source="http://localhost/SLR/images/pers_org.png" Stretch="UniformToFill" HorizontalAlignment="Left" Canvas.Top="0" Canvas.Left="0" >
                                    </Image>
                                </Border>
                            </DataTemplate>
                        </data:DataGridTemplateColumn.CellTemplate>
                    </data:DataGridTemplateColumn>

//Bind the Following code within datagrid LoadingRow Event

Border border = (Border)dgName.Columns[4].GetCellContent(e.Row);// value 4 is the Possible of the Cell in the datagrid
Image image = (Image)border.Child;
//RelMang tmpRm = (RelMang)e.Row.DataContext;
//image.Width = Convert.ToDouble(tmpRm.mx_Rel_Prcntg.ToString());
image.Width = Convert.ToDouble(20); // Dynamically Setting Width of the Image Which in Datagrid Cell

Silverlight How To Pass Values Between Pages or Forms

noreply@blogger.com (windows_mss) — Thu, 24 Dec 2009 10:35:00 +0000

In App.xaml.cs have declared some application level variables as follows,

private string valueToPass

public string valTo
{
   get
   {
       return valueToPass;
   }

   set
   {
       valueToPass = value;
   }
}

page1.xaml.cs

App ap = (App)Application.Current;
ap.valueToPass = "YourValue";

page2.xaml.cs

App ap = (App)Application.Current;
messageBox.show(ap.valueToPass);

How To wrap Text In silverlight DataGrid Column

noreply@blogger.com (windows_mss) — Thu, 24 Dec 2009 04:41:00 +0000

Make your datagrid AutoGenerateColumns="False" , then do the following changes to wrap text in the datagrid coloumn

<data:DataGridTemplateColumn Header="Your Header" Width="150">
         <data:DataGridTemplateColumn.CellTemplate>
                 <DataTemplate>
                        <TextBlock TextWrapping="Wrap" Text="{Binding Your_Data_Display}" />
                 </DataTemplate>
        </data:DataGridTemplateColumn.CellTemplate>
</data:DataGridTemplateColumn>

Silverlight The type or namespace name 'IValueConverter' could no

noreply@blogger.com (windows_mss) — Wed, 23 Dec 2009 05:52:00 +0000

While Using Silverlight if you are getting the following Error "The type or namespace name 'IValueConverter' could not be found (are you missing a using directive or an assembly reference?)" Just Include namespace System.Windows.Data; in your code behind.

Silverlight The type or namespace name 'BitmapImage' could not be

noreply@blogger.com (windows_mss) — Wed, 23 Dec 2009 05:49:00 +0000

While Using Silverlight if you are getting the following Error "The type or namespace name 'BitmapImage' could not be found (are you missing a using directive or an assembly

reference?)" Just Include namespace System.Windows.Media.Imaging; in your application

How To Pass values from iframe to Controls In parent Document

noreply@blogger.com (windows_mss) — Mon, 07 Dec 2009 09:37:00 +0000

if(parent.document.Yourformname.YOurfieldname != null){

parent.document.Yourformname.YourfieldId.value = SetYourValue;
}

For Div Content

if(parent.document.all["DIVName"] != null){

parent.document.all["YourDIVName"].innerHTML = SetYourValue;
}

How to call the function with parameter in iframe

noreply@blogger.com (windows_mss) — Mon, 07 Dec 2009 09:24:00 +0000

var objIFrame = document.frames["ifrmId"];
    if ((objIFrame ) && (objIFrame .fnNameInIframe)) {
        objIFrame .fnNameInIframe(Param1);
    }

Whats The Difference Between Manifest and Metadata

noreply@blogger.com (windows_mss) — Thu, 03 Dec 2009 08:46:00 +0000

Metadata describes contents in an assembly, classes, interfaces, enums, structs, etc.

Manifest describes an assembly itself, Assembly name version number, culture, strong name, etc.

How To Find The Number Of Live Connection In Database

noreply@blogger.com (windows_mss) — Fri, 20 Nov 2009 04:12:00 +0000

SELECT DB_NAME(dbid) AS db, COUNT(dbid) AS connection FROM SYS.SYSPROCESSES WHERE dbid > 0
GROUP BY dbid

How To Duplicate Tab Or Clone Tab In Firefox

noreply@blogger.com (windows_mss) — Mon, 16 Nov 2009 10:05:00 +0000

Just press the Ctrl key And drag The corresponding tab which is to Clone or duplicate

Supported By Firefox 3.x

Regular Expression To Check Input With no space using JavaScript

noreply@blogger.com (windows_mss) — Thu, 12 Nov 2009 10:28:00 +0000

<html>
   <head>
       <script>
           function validateContent(evt)
           {
           var pattern =    /^\w[a-zA-Z@#0-9.]*$/;
               if(evt.value.search(pattern) == -1)
               {
                   alert('Space not Allowed');
                   return false;
               }
           }
       </script>
   </head>
   <body>
       <input type='text' onkeyup='return validateContent(this);' />
   </body>
</html>

How To Search Text In Script In Database In Procedure

noreply@blogger.com (windows_mss) — Fri, 16 Oct 2009 03:51:00 +0000

    DECLARE @srchString VARCHAR(1000)
   SET @srchString='Procedure_Name'
   SET @srchString = '%' + @srchString + '%'
   SELECT O.NAME FROM syscomments C
   JOIN sysobjects O ON O.id = C.id
   WHERE O.xtype = 'P' AND C.TEXT LIKE @srchString

How To Set Background Image For Canvas

noreply@blogger.com (windows_mss) — Wed, 16 Sep 2009 05:18:00 +0000

<Canvas.Background>
<ImageBrush ImageSource="images/dashboard.jpg" Stretch="Fill" />
</Canvas.Background>

See Also...
ImageBrush
Strech Property

How To Send Mail With Attachment In Asp.Net

noreply@blogger.com (windows_mss) — Sun, 13 Sep 2009 11:23:00 +0000

have to Include The following Namespace,

using System.Net;
using System.Net.Mail; // For Mailing Purpose
using System.IO; // To Check File existence in Server
using System.Text; // For Encoding.UTF8

   try
        {
            MailMessage objMailMsg = new MailMessage(txtFrom.Text.Trim(), txtTo.Text.Trim());
            Attachment MailAttachment;

            objMailMsg.BodyEncoding = Encoding.UTF8;
            if (txtCc.Text.Trim().Length > 0)
            {
                objMailMsg.CC.Add(txtCc.Text.Trim());
            }
            if (txtBcc.Text.Trim().Length > 0)
            {
                objMailMsg.Bcc.Add(txtBcc.Text.Trim());
            }
            objMailMsg.Subject = "Testing Mail";
            objMailMsg.Body = txtMessage.Text.Trim();
            if (fuMailAtt.HasFile)
            {
                if (!File.Exists(Server.MapPath(@"Attach\" + fuMailAtt.FileName)))
                {
                    fuMailAtt.SaveAs(Server.MapPath(@"Attach\" + fuMailAtt.FileName));
                    MailAttachment = new Attachment(Server.MapPath(@"Attach\" + fuMailAtt.FileName));
                    objMailMsg.Attachments.Add(MailAttachment);
                }
                else
                {
                    MailAttachment = new Attachment(Server.MapPath(@"Attach\" + fuMailAtt.FileName));
                    objMailMsg.Attachments.Add(MailAttachment);
                }
            }
            objMailMsg.Priority = MailPriority.High;
            objMailMsg.IsBodyHtml = true;

            SmtpClient objSMTPClient = new SmtpClient("smtp.mail.yahoo.com", 587);
            objSMTPClient.Credentials = new NetworkCredential("YourYahooId", "Your Yahoo Password");
            objSMTPClient.Send(objMailMsg);
            Response.Write("Mail Send");
        }
        catch (Exception ex)
        {
            Response.Write("Mail Not Send " + ex.Message);
        }

Controls Name

From Address        txtFrom
To Address            txtTo
Cc Address            txtCc
Bcc Address          txtBcc
FileUpload             fuMailAtt
Message                txtMessage
Send Button           btnSend

Download SourceCode

How To Remove Border In Silverlight HyperlinkButton

noreply@blogger.com (windows_mss) — Thu, 10 Sep 2009 09:09:00 +0000

IsTabStop="False"

How To Get Time Part From datetime Sql Server

noreply@blogger.com (windows_mss) — Thu, 03 Sep 2009 06:19:00 +0000

select convert(varchar,getdate(),8) AS Time

The type or namespace name 'AspNetCompatibilityRequirements' coul

noreply@blogger.com (windows_mss) — Tue, 01 Sep 2009 04:55:00 +0000

If Getting The type or namespace name 'AspNetCompatibilityRequirements' could not be found, then have to include the following namespace in class,

Using System.ServiceModel.Activation // C#
Imports System.ServiceModel.Activation // VB

javascript get table row count

noreply@blogger.com (windows_mss) — Wed, 26 Aug 2009 05:11:00 +0000

document.getElementById('tablename').rows.length

Whats the Difference between Cluster and Non-cluster index ?

noreply@blogger.com (windows_mss) — Fri, 21 Aug 2009 17:21:00 +0000

Clustered Index

* There can be only one Clustered index for a table
* Usually made on the primary key
* The logical order of the index matches the physical stored order of the rows on disk

Non-Clustered Index

* There can be only 249 Clustered index for a table
* Usually made on the any key
* The logical order of the index does not match the physical stored order of the rows on disk

Silverlight : How To Bring Control To Front

noreply@blogger.com (windows_mss) — Fri, 21 Aug 2009 11:01:00 +0000

Canvas.SetZIndex(Your_Element_Name,Value_To_Bring_It_To_Front);

How To Create Dynamic TextBox With Event Handler

noreply@blogger.com (windows_mss) — Thu, 13 Aug 2009 04:11:00 +0000

    protected void Page_Load(object sender, EventArgs e)
    {
        createTxt();
    }

    private void createTxt()
    {

        TextBox txt = new TextBox();
        txt.ID = "txt1";
        txt.AutoPostBack = true;
        txt.TextChanged += new EventHandler(txt_TextChanged);
        form1.Controls.Add(txt);
    }

    void txt_TextChanged(object sender, EventArgs e)
    {
        TextBox txtBx = (TextBox)sender;
        Page.Title = txtBx.Text;
    }