The Microsoft CRM – Client Relationship Management package from Microsoft Business Solutions was initially designed to be customizable with Microsoft Visual Studio.Net and one of its programming languages: C # .Net or VB.Net. You can use ADO.Net, Web Service, Transact SQL scripts and stored procedures, implement SQL Server tools like Linked Server on all ODBC / OLEDB compliant databases including ORACLE, Sybase, Ingress, DB2, Unidata, Pervasive SQL, Ctree and even Lotus Notes / Domino.
In this short article we would like to give you the clue on programming third-party SQL database integration.
First, use Microsoft CRM SDK to start communication with Microsoft CRM, we have it in C #:
String[] arr1 = coll.AllKeys;
int loop1, loop2;
for (loop1 = 0; loop1 0?1:arr1.Length); loop1++)
{
String[] arr2 = coll.GetValues(arr1[loop1]);
for (loop2 = 0; loop2
Then you use ADO.Net for calling stored procedure with parameters to do the integration job:
try
{
string SQLStatement="ICS_UpdateAccountPrivate '"+
strAccountId +"' , '" + this.TextBoxWorkPerformed.Text +
"' , "+doubleEncode(System.Double.Parse(this.TextBoxAnnualRevenue.Text))+" , "+
intEncode(System.Int32.Parse(this.TextBoxNumberOfEmployees.Text.Replace(",","")))+" , "+
doubleEncode(System.Double.Parse(this.TextBoxAverageGrowthRate.Text))+" , "+
"'"+this.DropDownListOwnership.SelectedItem.Text +"' , "+
intEncode(System.Int32.Parse(this.RadioButtonList.SelectedItem.Value))+" , "+
intEncode(System.Int32.Parse(this.TextBoxCredit.Text.Replace(",","")))+" , '"+
this.TextBoxComments.Text+"'";
System.Data.SqlClient.SqlConnection tmpConnection =
new System.Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings["ConnectionStringICS"]
);