C#

mjawadkhatri wrote:

OdbcConnection conn = new OdbcConnection("Driver={SQL Server};Server=test;UID=sa;PWD=java;");

<br />
OdbcConnection conn = new OdbcConnection("DSN=test;UID=sa;PWD=java;");<br />

OdbcConnection cn= new OdbcConnection("Driver={SQL Server};Server=mySQLServer;UID=sa;
                               PWD=myPassword;Database=Northwind;");

        While reader.Read(){<br />
            intCounter++;<br />
            if (intCounter % 2 == 0){<br />
                 Console.WriteLine(reader(0).ToString())<br />
            }<br />
}<br />
        End While

static void Main(string[] args)
        {
            MyFunc();
            Console.ReadKey(false);
        }

        public static void MyFunc()
        {
            Console.WriteLine("Begin"); // Simple Amend to prevent compiler optimization
            Console.WriteLine(Program.GetCallStack());
            Console.WriteLine("End"); // Simple Amend to prevent compiler optimization
        }

        public static string GetCallStack()
        {
            System.Diagnostics.StackTrace callStack = new
            System.Diagnostics.StackTrace();
            string s = "";
            int index = 0;
            while (true)
            {
                System.Diagnostics.StackFrame frame =
                callStack.GetFrame(index);
                if (frame == null) break;
                System.Reflection.MethodBase method = frame.GetMethod();

                if (index == 0) s = " --" + s;
                s = method.DeclaringType.Name + "." + method.Name + "()" + Environment.NewLine + s;
                index++;
            }
            return (s);
        }

Pete O'Hanlon wrote:

The important thing to rememember is that it's a tool available to you, and you should ignore it if it doesn't fit the problem.