Hi Everybody!

If you've been interest in learning new technologies, the Microsoft has made available a serie of training kits who you can download and then learn ones.

For me, the Microsoft training kits has been useful and interesting where I can learn a new technology without spending money!

So, you can download the training kits on the list below:

• Visual studio 2010 and .NET Framework 4;
• Visual Studio LightSwitch;
• Silverlight 4.0;
• SQL Server 2008 R2;
• Windows Phone 7;
• Windows Azure Platform;
• PHP on Windows and SQL Server;
• Identity Developer;
• Office 2010 Developer;
• Office 365 Developer;
• Sharepoint 2010 Developer;
• SharePoint and Silverlight;
• SharePoint 2010 and Windows Phone;
• BizTalk Server 2010 Developer;
• Windows Server AppFabric;
• Web Camps;
• Dynamics CRM 2011 Developer;

See you next post! 

Hi Everybody,

In this post, I'm going to try to explain about connection pooling. This subject is very important to know because our systems might loose performance if the developer doesn't know how to apply it. Well, let's go the to post! 

Where is connection pooling ?

When you try to connect in any database some steps you must follow. First, you need a network where data from database can arrive at the system.  Further, you need to have credentials to access the database too, after this, you need to close the connection.

You might think this process may not have problems and not cost the application a lot. In some cases, you are right, however you need to analyze your application, such as: quantity of datas that are transported, number of visitors/users in your application.

The connection pooling tries to improve/maximize the access to the data, allowing an application to keep ownership of a database connection. In other words, it is a cache of database connections kept in which these ones can be reused when the new requests to the database are demanded.

It maintains a group of connection from database. Then, when an application tries to connect a database it is verified if there is a free connection from the pool. Case there is one, the application used it. Otherwise, it is created a new connection the application.

In ADO.NET, you can use it too. It is enabled by default. However you can disable one setting it in the connection string. See the sample this in the SQL Server connection string:

Data Source=Server;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;Pooling=False;

Additional, you can set the Min and Max Pool Size connection allowed in the pool.  The default values are 100 and 0.

Let's see a sample setting the Max pool size - 150 and Min Pool Size - 10 in the SQL Server connection:

Data Source=Server;Initial Catalog=myDataBase;User ID=user;Password=test;Max Pool Size=150;Min Pool Size=10;Pooling=True;

There is another important property that can be set in the connection string. It is Connection Timeout in which when the connection is required it is created a time compared with the current time.  Case the connection isn't closed it is destroyed when the time connection exceeds the value specified by the Connection Timeout.  Per default, this property is set 15 seconds. See sample below of SQL Server connection with the Connection Timeout with value 20 seconds:

Data Source=Server;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;Pooling=False;Connection Timeout=20;

If you need to know about connection string  of other database, you can read last post here.

I hope you liked this post and be useful for you! 

Hi Everybody!

I'd like to share you about a great web site about the connection strings. This site is fantastic where its focus is in connection string for MANY data bases.

Click here to access the web site!

I hope this post be useful for you!

See you next post!

Hi Everybody!

I'm going to explain in this post about ScrumMaster roles. This role in the scrum is very important, the scrum is facilitated by him/her. See below the mainly roles, skills, problems and others...

Roles:

• Accountables for removing impediments to the capacity of the team to deliver the sprint goal;
• Protects the team;
• Keeps team focused on the tasks at hand;
• He/She is "project manager" or "leader";
• Guarantees that the process is understood and followed;
• Helps the development team improve its productivity and creativity the team;
• Helps the customer meet his/her objectives and drive the functionality developed by team (maximize ROI);
• Improves working environment;
• Improves the team collaboration;
• Follows the progress status and estimates are up-to-date;
• 
  

Skills:

• Influences without authority;
• Shows responsibility without power;

Hi Everybody!

Recently, I have a problem with hosting asp.net 4.0 on II6. I have already installed the .NET Framework 4.0 in the server and configured all, but when I tested the web site it wasn't working.

So, A friend passed me a web site (blog) that explains how to solve this problem!  Case you have the same problem, please, access this web site!!

Good Luck!

Hi Everybody! 

I'm going to explain about how to built-in charting control with datetime scale. 

So, there is a chart control that you can use in the windows forms and asp.net project. Before using, you can download this control in this web site for the version .NET 3.5 and it is free! 

After installed, you create a windows form project in visual studio. Then, you can see in the toolbox within the "DATA" tab the chart control where we can see the picture below. 

Put this control on your form, you will see the control with the chart.

For this sample, let's go to see some properties, classes and methods you can use on your chart.

Title: Title of chart. you can define more than one title. See the code below:

chartControl.Titles.Add("Sells per month");

Series: You can define many series you want in your chart. One is chart where it can be having type of "Line, Point, Pie" and others. See the code to create two series below:

chartControl.Series.Add(new Series("Sales projection"));
chartControl.Series.Add(new Series("Sales consolidated"));

ChartType: this property you define the chart type: Line, Point, Pie, Funnel... This property is related with your serie.  See the code:

chartControl.Series[0].ChartType = SeriesChartType.Line;
chartControl.Series[1].ChartType = SeriesChartType.Line;

Serie's Color: For each serie you can configure a color. See the code:

chartControl.Series[0].Color = System.Drawing.Color.Blue;
chartControl.Series[1].Color = System.Drawing.Color.Red;

Serie's Border Width: You can set a serie's border width case you think necessary to show better. Look at the code:

chartControl.Series[0].BorderWidth = 3;
chartControl.Series[1].BorderWidth = 3;

ChartAreas: You can instance the chartArea object that you can configure many properties the chart: BackColor, BorderColor, CursorX, CursorY, AxisX, AxisY and much more things.

Let's set some properties that ChartArea class:

AxisX.Title:

var chartArea = new ChartArea();
chartArea.AxisX.Title = "Days";

AxisY.Title:

chartArea.AxisY.Title = "Sells";

Adding the chartArea object in chartArea:

crtSells.ChartAreas.Add(chartArea);

Binding: the Serie's binding received a collection where sets the point (coordinate). For this, you define the DataBind and after setting the valueType (X or Y axis). See the sample below:

chartControl.Series[0].Points.DataBind(GetSerieProjectionData().DefaultView, "xValuesDate", "yValues", null);
charControl.Series[0].XValueType = ChartValueType.DateTime;

chartControl.Series[1].Points.DataBind(GetSerieConsolidatedData().DefaultView, "xValuesDate", "yValues", null);
chartControl.Series[1].XValueType = ChartValueType.DateTime;

The DataBind parameters are: 

• GetSerieProjectionData().DefaultView: collection with data;
• xValuesData: a string type having the name of the collection's X-axis;
• yValues: a string type being the name of the collection's Y-axis;
• null: a string value for others fields.

In XValueType, you can set the value type in the X-axis or you can set the value type also in the Y-axis

(YValueType).

If you have interest in learning more, you can download the simple sample () about this post, further, I recommend that you download the windows forms and asp.net samples which provide more than 200 samples. Also, there is a documentation the chart control, see here now.

Graph.rar (56.54 kb)