About Me

My photo
Kottarakara, Kollam, Kerala, India
Though currently in Thiruvananthapuram, my residence is at Kollam district in Kerala which is almost 75 kms away from the office

I Me Myself !

Hi all, as a ASP.NET professional i would like to use this as a technological and informative site. Maybe, this contains my personal portfolio, funny matters, videos, photos too. Still i mainly intend to use this for official purpose.

Currently specialising in Microsoft's Dynamic CRM 4.0, am engaged in an assignment to successfully develop and deploy a CRM product as per the custom business logic. I am employed in a microsoft partnered switzerland based firm, know more...

The technologies/languages/packages i am confident in are:


  1. ASP.NET (vb/C#)

  2. C#.net

  3. vb.net

  4. sql server

  5. Adobe photoshop

  6. Macromedia Flash

  7. MS Dynamics CRM 4.0

My achievements includes:
1) Cisco Certified Network Associate (CCNA).
2) Active member of ASP.NET forum.
3) Active member of CRM Dynamics Community.

My professional career:


  • Web Designer at AUFIDUS INDESIGNS, Ernakulam, Kerala

  • Computer Lecturer at SRV Govt Higher Secondary School, Ernakulam, Kerala

  • Software Instructor at IGNOU, Ernakulam, Kerala

  • Lower Divison Clerk (LDC) at Melattur Grama Panchayat, Malappuram, Kerala

  • Software Trainer in .NET at Sun Infosys, Kottayam, Kerala

  • Software Trainer in .NET at NIIT, Adoor, Kerala

  • Computer Lecturer at UIT, Adoor, Kerala

  • Senior Systems Executive at PIT Solutions, Technopark, Thiruvananthapuram, Kerala

Accessing CRM database via Javascript in CRM 4.0

To access the CRM database from JavaScript, use the following as a template:

var connection = new ActiveXObject("ADODB.Connection");
var connectionString = "Provider=SQLOLEDB;Server=STUNNWARECRM;Database=stunnware_mscrm;Integrated Security=sspi";

connection.Open(connectionString);

var query = "SELECT name FROM FilteredAccount";
var rs = new ActiveXObject("ADODB.Recordset");

rs.Open(query, connection, /*adOpenKeyset*/1, /*adLockPessimistic*/2);
rs.moveFirst();

var values = "";

while (!rs.eof) {
values += rs.Fields(0).Value.toString() + " ";
rs.moveNext();
}

connection.Close();

alert(values);

Cheers
Binukumar S

reference: http://www.stunnware.com/crm2/topic.aspx?id=JS7