Why Software Is Eating The World

A good article to share.

Crystal Report in Visual Studio 2010

Crystal Report is a easy tool for us to design and generate report from data source. But unfortunately, Visual Studio 2010 didn't included it, you need to download from SAP as add-on application. Plus, if you using Visual Studio Express 2010 you may not to using features like editing .rpt file, export as pdf file format, etc. Express version only install runtime which enable you to view crystal report. Another weakness of Crystal Report in Visual Studio 2010 is when you put your crystal report to server, your server need to install runtime in order to view crystal report. It's quite inconvenience for those company which sell their product to client because need to include runtime msi which occupied up to 70MB. For your more information, please take a look here. Thanks~ =)

Generate JSON from MySQL using C#

I would like to share this article because I try to search some related posts or articles and found out it was rare when compare with other topics. Hence, I do it by myself and hope you can get what you want from here.

Before start write your coding, please make sure you add reference Newtonsoft.Json. If you haven't get it, please download from here.

Define your mySQL connection first and write your query.

1. MySqlConnection conn = new MySqlConnection(
2. "server=localhost;" +
3. "uid=xx;" +
4. "pwd=xx;" +
5. "database=xx;");
6. MySqlCommand comm = new MySqlCommand();
8. conn.Open();
9. comm = conn.CreateCommand();
10. comm.CommandText = "SELECT name FROM student";
11. MySqlDataReader reader = comm.ExecuteReader();
12. List<Student> eList = new List<Student>();

Don't forget to build constructor to get and set.

1. public class Student
2. {
3. public string Name;
4. }

Read database data line by line.

1. while (reader.HasRows)
2. {
3. if (reader.Read())
4. {
5. Student e = new Student();
6. e.Name = Convert.ToString(reader["Name"]);
7. eList.Add(e);
8. }
9. else
10. {
11. break;
12. }
13. }

Convert to JSON format.

1. System.Web.Script.Serialization.JavaScriptSerializer oSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();
2. string ans = oSerializer.Serialize(eList);
3. string script = "{\"Employee\": " + ans + "}";
4. ClientScriptManager cs = Page.ClientScript;
5. cs.RegisterStartupScript(Page.GetType(), "JSON", script, true);
6. Response.ContentType = "application/json";
7. Response.Write(script);

Check your aspx file in browser.

Sharing is caring. =)

Titanium Developer SDK loading Issue

Well, I'm new in Titanium Developer, hence a lot of things still in confuse condition. One of the problem I faced when I start develop my iPhone Application through Titanium Developer was when I run my Test & Package, my SDK appear loading... which mean it doesn't detect any path of my latest SDK version(I using old version Titanium while my Xcode and SDK version are latest one). When you go through Library/Application Support/mobilesdk/osx/ and inside osx folder only contains oldest version such as 1.2.x or 1.4.x folder. So what you need to do is update your version. Click here to download the latest Titanium SDK version. Extract the zip file and move it inside osx folder. Also, you need to recreate your project to make sure your Titanium SDK version is latest version. Check back your Test & Package, loading problem is no longer there.

Sharing is caring~ =)

Page Without Cache in C#

This question have been trouble me for whole day, just because i put my coding in wrong page. So, please make sure your page which don't want store any cache have following coding.

protected void DisableBufferingOnPage()

{

Response.Buffer = true;

Response.ExpiresAbsolute = DateTime.Now.AddDays(-1d);

// set expiry date in the past

Response.Expires = -1500;

Response.CacheControl = "no-cache";

Response.Cache.SetNoStore();

Response.AppendHeader("Pragma", "no-cache");

Response.AppendHeader("Cache-Control", "no-cache");

Response.CacheControl = "no-cache";

Response.Expires = -1;

Response.ExpiresAbsolute = new DateTime(1900, 1, 1);

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.Cache.SetExpires(DateTime.Now);

Response.Cache.SetAllowResponseInBrowserHistory(false);

}

Please call this function at Page_Load. Also, if you record your session when log in please make sure it is clear and abandon when log out.

Session.Clear();

Session.Abandon();

So, when you log out even you click back button also cannot go previous page unless you log in.

Sharing is caring~ Cheers~ =)

Ctrl + Alt + Copy or Paste

When you copy the part of article from wikipedia or some information website which contain HTML links, this HTML link will remain its blue color and underline once you paste this article on your Microsoft Word or PowerPoint.

Here are the way to solve it.

Using Ctrl + Alt + C when you copy and paste it with Ctrl + Alt + V~

Here are the result:

P/S: This copy and paste only affect those html link only. The number such likes [1] will remain its position so you have to delete it by yourself.

Have fun and enjoy it. =)

IE 8 Multi-login

Do you know that Internet Explorer 8 (IE 8) can multi login?

What's multi login means?

It's means that you have more than one account of same website.

For an instance, Facebook only can accept about 5000 friends.

So if you have more than that, you need have to open a new account.

But to develop two accounts in one time, for sure you need to login and logout many time unless you open two browsers in one time.

That's the way you can develop it in one time which using IE 8 provides multi login.

It's not a plugin which you need to download it. It is default feature of your IE 8.

Here is the way~~

For Google Chrome and Mozilla Firefox user, you can search extension chrome or plugin Firefox to have similar feature with this.

Have fun and enjoy it. =)