SQL Query

Select * from student where studid not in (select studid from studentdetails union select -1 as studid)

File Filter

//openFileDialog1.Filter = "Media files (*.wmv)|*.wmv|All Files (*.*)|*.*";
// openFileDialog1.Filter = "Media files (*.wmv)|*.wmv";

my mail check link

general mphasis url

https://my.mphasis.com/default.aspx



LAAS

https://hrapps.corp.mphasis.com/Authentication/Login.aspx?APPTOKEN=f52dab7a-5a23-45ae-985b-a298ec385f1f&URL=https://hrapps.corp.mphasis.com/LAAS/Admin%20Pages/Default.aspx


MARS


https://marshr.corp.mphasis.com/psp/HRPROD/?cmd=login&languageCd=ENG&

EDS mail box url


https://uspl.webmail.eds.com/exchange/



MPHASIS MAIL BOX


https://mail.mphasis.com/exchange/


oracle link

http://mars.corp.mphasis.com/OA_HTML/AppsLocalLogin.jsp?langCode=US&username=NZ3HHC

Pay Roll Link

http://employeepay.mphasis.com:8080/mphasis/home.do

Flash Screen in Windows Application

Add windows form.

add two timer control in that form

set form background as white

do the complition with help of following code



using System;
using System.Drawing;
using System.Windows.Forms;
using System.Drawing.Drawing2D;
using System.Drawing.Text;

namespace gridcomputing
{
public partial class frmSplashScreen : Form
{
#region "VARIABLES"

protected int intCurrentGradientShift = 10;
protected int intGradiantStep = 5;
#endregion

#region "CONSTRUCTOR"
public frmSplashScreen()
{
InitializeComponent();
}
#endregion

#region "FORM LOAD"
private void frmSplashScreen_Load(object sender, EventArgs e)
{

}
#endregion

#region "TIMER TICK"
private void tmrAnimation_Tick(object sender, EventArgs e)
{
// Obtain the Graphics object exposed by the Form.
Graphics grfx = CreateGraphics();
// Set the font type, text, and determine its size.

Font font = new Font("TIMES NEW ROMAN", 40,
FontStyle.Regular , GraphicsUnit.Point);

string strText = " Quality of Service \n" +
" in \n" +
" Grid Computing \n";

SizeF sizfText = new SizeF(grfx.MeasureString(strText, font));

// Set the point at which the text will be drawn: centered
// in the client area.

PointF ptfTextStart = new PointF(Convert.ToSingle(ClientSize.Width - sizfText.Width) / 2,
Convert.ToSingle(ClientSize.Height - sizfText.Height) / 2);

// Set the gradient start and end point, the latter being adjusted
// by a changing value to give the animation affect.
PointF ptfGradientStart = new PointF(0, 0);
PointF ptfGradientEnd = new PointF(intCurrentGradientShift, 200);
// Instantiate the brush used for drawing the text.
LinearGradientBrush grBrush = new LinearGradientBrush(ptfGradientStart,
ptfGradientEnd, Color.Maroon, BackColor);
// Draw the text centered on the client area.
grfx.DrawString(strText, font, grBrush, ptfTextStart);
grfx.Dispose();
// Shift the gradient, reversing it when it gets to a certain value.
intCurrentGradientShift += intGradiantStep;

if (intCurrentGradientShift == 500)
{
intGradiantStep = -5;
}
else if (intCurrentGradientShift == -50)
{
intGradiantStep = 5;
}
}

private void timer1_Tick(object sender, EventArgs e)
{
this.Close();
}
#endregion

}
}

Personal Usefull link

PAN CARD TRACK LINK

http://www.utitsl.co.in/utitsl/site/pantracker.jsp

Global Assembly Cache

Global Assembly Cache
To create a small Class Library project by using Visual Studio .NET or Visual Studio 2005, to generate a strong name, and to install the project's .dll file in the Global Assembly Cache, follow these steps:

1. Open Visual Studio .NET or Visual Studio 2005.
2. Create a new Class Library project named GAC in Visual Basic .NET or in Visual Basic 2005.
3. A strong name is needed. To generate this cryptographic key pair, use the SN Tool, which is located in the \bin subdirectory, where the .NET Framework Solution Developer Kit (SDK) is installed. The SN Tool is very easy to use. The command-line statement takes the following form:
sn -k "C:\[DirectoryToPlaceKey]\[KeyName].snk"
4. For convenience, create a directory named GACDemo in C:\ so that you can easily locate the key and access the key from the command prompt.

NOTE: For most users, the .NET tools are located in C:\Program Files\Microsoft.NET\FrameworkSDK\Bin. Before you type the following SN command, you may want to copy this similar path on your computer to the .NET bin directory, type cd from the command prompt, right-click to paste the path, and then press ENTER to quickly change the directory where the SN Tool is located.

Type the following:
sn -k "C:\GACDemo\GACkey.snk"
Note In the .NET Framework 2.0, the .NET tools are located in the C:\Program Files\Microsoft.NET\SDK\v2.0\Bin folder.
5. A key is generated, but it is not yet associated with the project's assembly. To create this association, double-click the AssemblyInfo.vb file in the Visual Studio .NET or Visual Studio 2005 Solution Explorer. Add the following to the list of assembly attributes that are included in this file by default when a project is created in Visual Studio .NET or in Visual Studio 2005:

Compile the project by clicking CTRL+SHIFT+B. No further code is necessary at this point in order to install a .dll file in the GAC.
6. You can install the .dll file by using the Gacutil Tool or by dragging the .dll file into the appropriate directory. If you use the Gacutil Tool, you can use the following command:
gacutil -I "C:\[PathToBinDirectoryInVSProject]\gac.dll"
If you want to drag the file, use Microsoft Windows Explorer. Open two instances of Windows Explorer. In one, navigate to the location of the .dll file output for your console project. In the other, navigate to c:\[SystemRoot]\Assembly.

Drag your .dll file into the folder.

Crystal Report in Windows Application

1. Add Crystal Report to Application give oledb(ado) connection
2. Select Corresponding Table and column


CrystalReport1 objRpt = new CrystalReport1();
objRpt.SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();