NinethSense

Just came back from the exam center. Let me announce that I am a Microsoft Certified Technology Specialist in Microsoft SQL Server now!

The Microsoft Certified Technology Specialist (MCTS) certifications provide the foundation for Microsoft Certification. These certifications are designed to validate your skills on the features and functionality of key technologies. You can show your depth of knowledge in one specific technology, earn multiple MCTS certifications to show breadth across different products, or build on the MCTS to earn a Microsoft Certified IT Professional (MCITP) credential.

Also, added ADO.NET also in my brainbench certifications list.

PRINCE = PRojects IN Controlled Environments which is a methodology of Project Management. It covers the management, control and organisation of a project. "PRINCE2" refers to the second major version of this method and is a registered trademark of the Office of Government Commerce (OGC), an independent office of HM Treasury of the United Kingdom.

More details here: http://en.wikipedia.org/wiki/PRINCE2

PRINCE2 is a process-driven project management method which contrasts with reactive/adaptive methods such as Scrum. PRINCE2 2009 defines 40 separate activities and organizes these below processes:

1. Starting up a project
2. Initiating a project
3. Directing a project
4. Controlling a stage
5. Managing stage boundaries
6. Closing a project

Check this link also: http://www.prince-officialsite.com/

URL: http://www.microsoft.com/downloads/details.aspx?FamilyID=752CB725-969B-4732-A383-ED5740F02E93&displaylang=en

The Visual Studio 2010 and .NET Framework 4 Training Kit includes presentations, hands-on labs, and demos. This content is designed to help you learn how to utilize the Visual Studio 2010 features and a variety of framework technologies including:

• C# 4.0
• Visual Basic 10
• F#
• Parallel Extensions
• Windows Communication Foundation
• Windows Workflow
• Windows Presentation Foundation
• ASP.NET 4
• Windows 7
• Entity Framework
• ADO.NET Data Services
• Managed Extensibility Framework
• Visual Studio Team System

I know this is an old theme but I had to write a sample app for demonstration in a tech forum. So reproducing here also.

Importantly, the DataTable/DataSet must be serializable.

ASMX Code:

    public class Service1 : System.Web.Services.WebService
    {
 
        [WebMethod]
        public DataTable HelloWorldDataSet()
        {
            DataTable dt = new DataTable("MyDataTable");
            dt.Columns.Add("column1",typeof(System.String));
            dt.Columns.Add("column2", typeof(System.String));
 
            DataRow dr = dt.NewRow();
            dr["column1"] = "blah1";
            dr["column2"] = "blee1";
            dt.Rows.Add(dr);
 
            dr = dt.NewRow();
            dr["column1"] = "blah2";
            dr["column2"] = "blee2";
            dt.Rows.Add(dr);
 
            return dt;
        }
    }

        private void button1_Click(object sender, EventArgs e)
        {
            helloservice.Service1 service = new WindowsFormsApplication1.helloservice.Service1();
            DataTable dt = service.HelloWorldDataSet();
        }

C# Code:

Please check this hobby application and let me know if you want me to continue with this app. If I have positive feedbacks, I may go with CodePlex.

I did this sample with Visual C# 2008 Express and tested with MySQL 5.1

Download URL: http://kidoos.net/media/p/607.aspx