CODE Reminder

Convert Visual Basic code to C#

2010-04-28T12:56:00.000+05:00

http://www.developerfusion.com/tools/convert/vb-to-csharp/

Computer Science

2010-04-24T10:19:00.006+05:00

Advice for Computer Science College Students

by Joel Spolsky

http://www.joelonsoftware.com/articles/CollegeAdvice.html

SQL Select Top N within Group By?

2010-03-19T12:40:00.002+04:00


SELECT  ID, groupName, hitValue, 

Rank()  OVER (PARTITION BY groupName ORDER BY hitValueDESC) AS Rank

FROM    myHits

How SQL Server 2005 stores nvarchar(n)?

2009-11-12T08:47:00.001+04:00

If we take nvarchar(3000) for a column, server does not allocate 3000 character at the initial.
It means if we write 200 characters into that column it will allocate 200 only not 3000.

Windows run line commands?

2009-11-12T08:44:00.002+04:00

logoff - logoff
mstsc - remote desktop connection
inetmgr - IIS service
regedit - registry editing tool

How to disable drildown at Crystal Reports?

2009-11-12T08:43:00.003+04:00

If we make the EnableDrillDown property false, crystal report will not go into the detail of sub reports.

How to write into a .doc (Word) file in c#?

2009-09-07T16:04:00.002+05:00

private void MakeDoc(object fileMain, string number)
{
Microsoft.Office.Interop.Word.ApplicationClass WordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

object nullobj = System.Reflection.Missing.Value;

WordApp.Visible = false;

Microsoft.Office.Interop.Word.Document doc = WordApp.Documents.Open(
ref fileMain, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj, ref nullobj);

doc.Activate();

FindAndReplace(WordApp, "", number);

object fileOutput = Directory.GetCurrentDirectory() + @"\K.doc";
doc.SaveAs(ref fileOutput, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj, ref nullobj);

doc.Close(ref nullobj, ref nullobj, ref nullobj);
WordApp.Quit(ref nullobj, ref nullobj, ref nullobj);

Functions.OpenFile(fileOutput.ToString());
}

private void FindAndReplace(Microsoft.Office.Interop.Word.Application WordApp, object findText, object replaceWithText)
{
object matchCase = true;
object matchWholeWord = true;
object matchWildCards = false;
object matchSoundsLike = false;
object nMatchAllWordForms = false;
object forward = true;
object format = false;
object matchKashida = false;
object matchDiacritics = false;
object matchAlefHamza = false;
object matchControl = false;
object read_only = false;
object visible = true;
object replace = 2;
object wrap = 1;

WordApp.Selection.Find.Execute(ref findText,
ref matchCase, ref matchWholeWord, ref matchWildCards,
ref matchSoundsLike, ref nMatchAllWordForms, ref forward,
ref wrap, ref format, ref replaceWithText, ref replace,
ref matchKashida, ref matchDiacritics, ref matchAlefHamza,
ref matchControl);
}

How to change mouse curser?

2009-09-05T10:39:00.000+05:00

this.Cursor = Cursors.WaitCursor;

....

this.Cursor = Cursors.Default;

C# double count of digits after point?

2009-09-02T10:37:00.001+05:00

Convert.ToSingle(myValue).ToString("N2");

How to copy a folder to new location in c# recursively?

2009-09-02T08:11:00.004+05:00

public void CopyFolder(string sourceFolder, string destFolder)
{
if (!Directory.Exists(destFolder))
Directory.CreateDirectory(destFolder);

string[] files = Directory.GetFiles(sourceFolder);
string[] folders = Directory.GetDirectories(sourceFolder);

foreach (string file in files)
{
string name = Path.GetFileName(file);
string dest = Path.Combine(destFolder, name);
File.Copy(file, dest);
}

foreach (string folder in folders)
{
string name = Path.GetFileName(folder);
string dest = Path.Combine(destFolder, name);
CopyFolder(folder, dest);
}
}

How to learn Windows XP .NET framework version?

2009-08-18T18:43:00.000+05:00

Look at registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP

Use ENTER key instead TAB key?

2009-08-17T18:19:00.001+05:00

protected override bool ProcessDialogKey(Keys keyData)
{
if (keyData == Keys.Enter)
{
Control c = this.GetNextControl(ActiveControl, true);
if (c != null)
{
c.Focus();
}
}
return base.ProcessDialogKey(keyData);
}

How to measure program performance in c#?

2009-08-13T09:37:00.000+05:00

DateTime start = DateTime.Now;

Code.....

TimeSpan end = DateTime.Now.Subtract(start);
MessageBox.Show(end.TotalMilliseconds.ToString());

C# DateTime Formats

2009-08-12T18:06:00.000+05:00

DateTime.Now.ToString("dd.MM.yyyy HH:mm");

What are Microsoft Office Tools Scanning commands?

2009-08-12T14:08:00.003+05:00

Run line command:

Viewer: MSPVIEW
Scanner: C:\Program Files\Common Files\Microsoft Shared\MODI\11.0\MSPSCAN.EXE

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.

2009-04-22T09:12:00.001+05:00

http://blog.crowe.co.nz/archive/2006/03/02/589.aspx

How to measure performance of Queries?

2009-04-08T11:48:00.002+05:00

1 SET LANGUAGE ENGLISH
2 SET STATISTICS TIME ON
3 SET STATISTICS IO ON
4 
5 
6 PRINT 'Result of first Query'
7 Your first Query
8 PRINT 'Result of second Query'
9 Your second Query

Reference

How to reset auto increment value of a table in Ms SQL?

2009-04-07T10:30:00.001+05:00

DBCC CHECKIDENT (tablename, RESEED, 0)

How to handle ASP.NET textbox client side events?

2009-04-06T15:57:00.001+05:00

function(s, e)
{

alert(s.GetValue());

anotherTextBoxClientİnstanceName.SetValue('asdsd');

}

What is JSP (Java Server Pages)?

2009-03-29T17:28:00.002+05:00

JSP - Java server pages.

JSP is programming language(environment) to develop dynamic web pages.

Developed by Sun Microsystems
Works on both IIS (Internet Information System) and Apache (Commonly Tomcat used)
.jsp files are compiled into Java Servlets by a JSP compiler on JSP Servlet engine.
.jsp files are parsed once and used forever.
<%! ... %> is used for variable and method declarations.
scriptlet: <% ... %> tags, any valid Java code is called scriptlet.
<% -- my comment -- %> or <% /* my Comment */%>
<%= expression ... %> - we do not use (;) at this
<%@ directives ... %> : directives give special information about the page to the JSP engine.
JSTL - JSP Standard tag library

Advantages:

Multiplatform
Component reuse by using Javabeans + EJB
advantages of Java

Execution steps of .jsp files

send .jsp file to JSP Servlet engine
parse .jsp file
generate servlet source code
compile servlet source code into class
instantiate servlate
send HTML (servlet output) to client

reference

How to manage PHPbb forum databse tables?

2009-03-17T11:04:00.004+04:00

How to clean bots from PHPbb forum?

Statistics shown in frontpage such as

Username of last user, total number of users, topics and posts are stored in

phpbb_config

Last post author name wrote on a forum is stored in

phpbb_forums

How to change date format at SQL Server?

2009-02-20T14:13:00.002+04:00

How to change date format at MS SQL Server?

SET DATEFORMAT DMY


Note: DMY means Day-Month-Year, so you can use MDY or YDM, etc...

SQL Server stored procedure parameters decrease performance

2009-02-17T16:15:00.004+04:00

When we use parametrs directly in query's WHERE parts,
performance of query decrease dramatically.

So we can use local values to copy these parametrs.

1 ALTER PROCEDURE [dbo].[CalculateSomething]
2     @myID INT
3 AS
4 BEGIN
5 DECLARE @myIDLocal INT
6 
7 SET @myIDLocal = @myID -- If you this performance of query
8                        -- will inctrease!
9 SELECT * FROM myTable WHERE ID = @myIDLocal

How to use Crystal reports?

2009-02-10T09:38:00.003+04:00

How to connect to Crystal report?
How to use stored procedures at Crystal reports?
How to pass parameter to Crystal report?

 1 
 2 ReportDocument reportDocument = new ReportDocument();
 3 ParameterField paramField = new ParameterField();
 4 ParameterFields paramFields = new ParameterFields();
 5 ParameterDiscreteValue paramDiscreteValue = 
                          new ParameterDiscreteValue();
 6 
 7 /***********************************/
 8 
 9 paramField.Name = "@ID";
10 paramDiscreteValue.Value = textBox.Text;
11 paramField.CurrentValues.Add(paramDiscreteValue);
12 paramFields.Add(paramField);
13 CrystalReportViewer.ParameterFieldInfo = paramFields;
14 
15 reportDocument.Load(Server.MapPath("Report.rpt"));
16 CrystalReportViewer1.ReportSource = reportDocument;
17 reportDocument.SetDatabaseLogon("myUsername", "myPassword",
18                    "192.187.1.1", "myDatabase");

Reference

How to get set session variables in ASP?

2009-02-06T15:27:00.005+04:00

How to get set session variables in ASP.NET?
How to get set session variables in ASP (c#)?
How to get set session variables at ASP?

1 //Get session value:
2 
3 int sessionValue = ((int)Context.Session.Contents["myValue"]);
4 
5 
6 //Set session value:
7 
8 Context.Session.Add("mySessionValue", 1001);