JavaScript[Inside .cshtml]:
<select class="ddlist" onchange="Change()" style="width:150px;margin-left:10px">
<option value="DB 1">DB 1</option>
<option value="DB 2">DB 2</option>
</select>
………………………………………..
function Change() {
clientTarget = $("#OlapClient1").data("ejOlapClient");
var oclientWaitingPopup = $("#" + clientTarget._id).data("ejWaitingPopup");
oclientWaitingPopup.show();
var DB = $(".ddlist").val();
var serializedCustomObject = JSON.stringify(DB);
oclientProxy.doAjaxPost("POST", oclientProxy.model.url + "/" + oclientProxy.model.serviceMethodSettings.initialize, JSON.stringify({
"action": "initializeClient", "customObject": serializedCustomObject, "clientParams": oclientProxy.model.enableMeasureGroups + "-" + oclientProxy.model.chartType
}), oclientProxy._renderControlSuccess);
}
C#[Inside WCF Service]:
string DB = "DB 1";
public Dictionary<string, object> InitializeClient(string action, object customObject, string clientParams)
{
////
dynamic customData = serializer.Deserialize<dynamic>(customObject.ToString());
if (customData as string != null)
DB = customData;
// You can choose your database by giving appropriate connection string.
if (DB.Equals("DB 1"))
connectionString = "Your Connection String1 here”;
else
connectionString = "Your Connection String2 here”;
////
return olapClientHelper.GetJsonData(action, DataManager, clientParams);
}
|