.NET, C#, MDM and everything else

RadBinaryImage MapPageRoute not working

2011-04-12T09:46:00.001-05:00

Under ASP.NET 4.0, when using System.Web.Routing (URL Routing) with telerik controls I received broken images.

void RegisterRoutes(System.Web.Routing.RouteCollection routes)

{

//make sure this is first

routes.Add(new System.Web.Routing.Route("{resource}.axd/{*pathInfo}", new System.Web.Routing.StopRoutingHandler()));

//...other routes here

}

found the answer here:

http://www.telerik.com/community/forums/aspnet-ajax/ajax/system-web-routing-and-asp-net-ajax-client-side-framework-failed-to-load.aspx

Deploying ASP.NET 4 Web Forms Application Using Routing on IIS 6

2011-04-12T09:28:00.000-05:00

In IIS 6, opened the properties dialog of the virtual directory, went to the "Directory" tab, click the "Configuration" button, and added a Wildcard application map to the aspnet_isapi.dll (c:\windows\microsoft.net\framework\v4.0.30319\aspnet_isapi.dll) and unchecked the "Verify that file exists" checkbox. This made it work.

Found the answer here: http://stackoverflow.com/questions/2953713/deploying-asp-net-4-web-forms-application-using-routing-on-iis-6

SQL Server Reporting Services

2009-12-03T14:57:00.002-06:00

I had a chart that needed to show negative values. I changed the Y-axis Scale minimum to 'auto' and it worked.

Yeah, well....

2009-03-31T15:25:00.002-05:00

Activate Reporting Services 2000 on Windows 2000

2009-03-04T13:57:00.006-06:00

I installed SQL Server Reporting Services on Windows 2000. At the end it said I had to manually activate Reporting Services.

This is what I did:

C:\WINNT\Microsoft.NET\Framework\v1.1.4322>aspnet_regiis.exe –i

Then this….

C:\WINNT\Microsoft.NET\Framework\v1.1.4322>rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"

------------

If you had to restore a database that crashed, you'll need to restore the RSReportServer.config and then do a -r like this:

C:\WINNT\Microsoft.NET\Framework\v1.1.4322>rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -r

Found the answer here:
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=92&threadid=27885&enterthread=y

C# find last months date range

2008-11-13T14:49:00.002-06:00

DateTime firstDay = new DateTime(DateTime.Now.AddMonths(-1).Year, DateTime.Now.AddMonths(-1).Month, 1);

int DaysinMonth = DateTime.DaysInMonth(DateTime.Now.AddMonths(-1).Year, DateTime.Now.AddMonths(-1).Month);

DateTime lastDay = firstDay.AddMonths(1).AddTicks(-1);

used code found here:
http://anuraj.wordpress.com/2007/12/03/last-day-and-first-day-of-the-month-using-c/

Why I'm Unimpressed With Rawness Of Skillz

2008-08-08T14:04:00.000-05:00

Why I'm Unimpressed With Rawness Of Skillz

SSRS 2005 Report prints blank pages - landscape mode

2008-06-10T09:41:00.000-05:00

Re: SSRS 2005 Report prints blank pages - MSDN Forums: "SSRS 2005 Report prints blank pages"

Body + Right marigin + Left margin should be less than page width
Body + Top margin + Bottom margin should be less than page height

If you have header and footer take them also into account
If you have any text box ,please check it is width and also matrix data regions.

c# read Excel 2007 .xlsx files

2008-04-24T12:03:00.002-05:00

In order to read .xlsx files you need the drivers: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=7554f536-8c28-4598-9b72-ef94e038c891

If you don't, you may get the error: "Could not find installable ISAM."

dir = new DirectoryInfo(System.Environment.CurrentDirectory);
xlsFiles = dir.GetFiles("*.xls", SearchOption.AllDirectories);

//loop thru all the text files
foreach (FileInfo xlsFile in xlsFiles)
{
DataSet dataSet1 = new DataSet();
OleDbConnection connection = new System.Data.OleDb.OleDbConnection();
OleDbDataAdapter dataAdapter1;

if (System.IO.Path.GetExtension(xlsFile.Name) == ".xlsx")
{

connection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + xlsFile.FullName + ";Extended Properties='Excel 12.0;'";
}
else
{
connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + xlsFile.FullName + ";Extended Properties='Excel 8.0;'";
}

dataAdapter1 = new OleDbDataAdapter("select * from [Sheet1$]", connection);

dataAdapter1.Fill(dataSet1);
DataTable dt = dataSet1.Tables[0];

}

Putting ASP.NET Dynamic Data into Context

2008-04-11T13:54:00.000-05:00

Scott Hanselman's Computer Zen - Putting ASP.NET Dynamic Data into Context

Jeremy Schneider's Blog: Hide form tag, but leave content

2008-03-07T08:22:00.000-06:00

Jeremy Schneider's Blog: Hide form tag, but leave content: "The problem is that a common practice in ASP.NET is to have a tag 'high up' in the HTML, usually in the Master page. HTML doesn't allow overlapping tags, so my PayPal button won't work. Since the higher level is in the Master page, it makes removing it pretty messy. As far as I know, there's no built-in 'hide this tag"

100+ Resources for Web Developers | BlogWell

2008-03-05T08:09:00.000-06:00

100+ Resources for Web Developers BlogWell

ProperCase function in SSRS ( SQL Server Reporting Services)

2008-03-04T11:19:00.000-06:00

=StrConv(Fields!Name.Value, vbProperCase)

found the answer here:

Any ProperCase function in SSRS report - TechNet Forums: "Any ProperCase function in SSRS report"

Connect: Microsoft SharedView Beta

2008-02-18T09:30:00.000-06:00

Connect: Microsoft SharedView Beta

SQL Server 2008, welcome to 10 years ago.

2007-12-04T14:36:00.000-06:00

SQL Server 2008 will have IntelliSense « Fun with .NET and SQL Server

SQL Server 2005 Reporting Services ReportViewer Control and IE7 « Arcane Code

2007-11-30T11:06:00.000-06:00

3 tips to showing reports on a web form:

SQL Server 2005 Reporting Services ReportViewer Control and IE7 « Arcane Code

Microsoft Report Viewer 2008

2007-11-28T09:28:00.000-06:00

If you want to use the Report Viewer that comes with VS 2008 you need this version 9 ReportViewer.exe installed on the server.

Note: you need to install .NET 3.5 first.

Download details: Microsoft Report Viewer Redistributable 2008

Visual Studio 2008

2007-11-26T15:53:00.001-06:00

Installed Visual Studio 2008. 3.3GB download for the Pro version. Why so big? got me.
Overall, very impressed. The ListView control looks nice. "A repeater on speed."

IE7

2007-11-12T15:59:00.000-06:00

Why can't IE7 remember what tab I was looking at last when I remove a tab!?! Firefox can!

Comcast Violates Net Neutrality. File Your Own FCC Complaint!

2007-11-05T08:15:00.001-06:00

Yes, this is a blatant solicitation get people to sign this complaint, but Comcast deserves it and Net Neutraility is being violated! ....Today, Free Press filed a legal complaint demanding that the FCC take action to protect the free flow of information on the Internet. By joining our complaint, you can help stop Comcast and other gatekeepers.

read more | digg story

Deploying Reports and ReportViewer Controls

2007-11-02T10:55:00.000-05:00

If you get this error:
"Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.0.0,"

You need to run this file on the server:
The ReportViewer control redistributable is a self-extracting file named ReportViewer.exe that includes an .msi and other files. You can find ReportViewer.exe at the following location: C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\ReportViewer\ReportViewer.exe.

Found the solution here:
Deploying Reports and ReportViewer Controls

SQL Server Reporting Services number of rows per page

2007-11-02T10:01:00.000-05:00

Set a number of rows per page with the grouping trick:

Go to Table Properties - GroupsAdd a Row Group with the following function: =Ceiling(RowNumber(Nothing)/30)Make sure "page break at end" is checkedNow you have a set number of rows and with that a set vertical size(assuming text does not wrap).Make the control a little wider then needed and you should not have scrollbars (most of the time).

Found the code here:
SQL Server reportingsvcs ReportViewer control always shows scrollbars

SQL Server Reporting Services RunningValue in a chart - scope issues

2007-11-01T16:13:00.000-05:00

Using SQL 2005 and Visual Studio 2005 I wanted to show a cummulative series in a chart, plotted as a line. I had to add a "fake" series grouping in order to get it to work.

Found the solution here:

sqlserver reportingsvcs RunningValue in a chart - scope issues

ASP.NET Resources - Proliferation of Unhelpful Visuals

2007-10-16T15:32:00.000-05:00

ASP.NET Resources - Proliferation of Unhelpful Visuals

Utilities.NET 1.0 released - James Newton-King

2007-10-03T11:56:00.000-05:00

Utilities.NET 1.0 released - James Newton-King

DateTime Parse and CultureInfo problem.

2007-10-02T11:30:00.000-05:00

Show US formatted dates in a different culture:

string dt = "1/31/2004";
CultureInfo nfo = new CultureInfo("en-US");
DateTime date = DateTime.Parse(dt, nfo);

CultureInfo nfo2 = new CultureInfo("en-GB");
Console.WriteLine(date.ToString(nfo2));

Found the code here.

24/7

2007-09-25T12:02:00.000-05:00

Do advertisers really need to say "and you can shop online 24/7". It's 2007, I think everyone is well aware that websites are available ALL THE TIME.

GridView: Creating groups and summaries with 2 lines of code

2007-09-18T16:11:00.000-05:00

I haven't tried this out yet but it looks nice. Makes grouping rows easy.

GridView: Creating groups and summaries with 2 lines of code

Comcast must die.

2007-09-11T15:23:00.001-05:00

Yet another story on how Comcast screwed one of their customers. They're Craptastic!

read more | digg story

System.Net.WebClient

2007-09-10T15:12:00.000-05:00

I needed a way to grab some content from a remote site. The following code worked the best. You may not need to specify a proxy as I have.

System.Net.WebClient wc = new System.Net.WebClient();

string proxyURL = ConfigurationManager.AppSettings["ProxyURL"];

string proxyCredUserName = ConfigurationManager.AppSettings["ProxyUserName"];

string proxyCredPassword = ConfigurationManager.AppSettings["ProxyPassword"];

System.Net.WebProxy proxy = new System.Net.WebProxy(proxyURL);

System.Net.NetworkCredential cred = new System.Net.NetworkCredential(proxyCredUserName, proxyCredPassword, domain);

proxy.UseDefaultCredentials = true;

proxy.Credentials = cred;

wc.Proxy = proxy;

chartImage = wc.DownloadData(chartImageURL);

Microsoft SQL Reporting Services and Visual Studio 2005

2007-08-27T14:23:00.000-05:00

If you want to be able to create Report Projects for SQL Reporting Services with Visual Studio 2005 you have to install SQL 2005, I did the Standard install, and make sure you select the "Business Intelligence" items. Wait forever.......and when the install is finally done you will get a option for "Report Server Project" when you select "New Project" in Visual Studio 2005.

Seamless inline text editing with ASP.NET AJAX | Encosia

2007-08-23T12:41:00.000-05:00

I've seen this done Google calendar and think it's a nice way to have the same page used as display and edit. The author of this blog does an awesome job of explaining each step.

Seamless inline text editing with ASP.NET AJAX Encosia

SAP MDM COM API SP5

2007-08-21T15:15:00.000-05:00

I've noticed that the console now seems to show ALL com api connections in the Logins section. Apparently MDM COM API creates a connection for the application and another for the trace. I'm not sure if this is true but I've never saw it before moving to SP5.

SQL Reporting Services

2007-08-16T15:35:00.000-05:00

I had a report that looked great in the browser but showed this error when exported to Excel:
"Subreports within table/matrix cells are ignored."

It's a limitation with the software. I removed the table and put my Fields and sub reports in a List control. I set the datasource and grouping properties for the List control and everything works fine now.

No More Hard Drive! 100 Free Software Apps to Go Online-Only

2007-08-10T16:23:00.000-05:00

No More Hard Drive! 100 Free Software Apps to Go Online-Only

SAP MDM COM API Get Attribute By Category ID

2007-08-09T15:17:00.000-05:00

public static DataTable GetByCategoryID(int attributeID, int categoryID, XCATCOMLib.Catalog catalog)
{
// There are 3 types of attributes:
// Feature - text values;
// Characteristic - numeric values;
// Coupled - coupled numeric values.

DataRow row = null;
DataTable dt = new DataTable();
dt.Columns.Add("AttributeID");
dt.Columns.Add("AttributeValue");
dt.Columns.Add("AttributeCoupleValue");
dt.Columns.Add("AttributeDisplayValue");
dt.Columns.Add("AttributeRating");
dt.Columns.Add("ShowAllFlag");
dt.Columns.Add("AttributePriority");
dt.Columns.Add("AttributeUnitID");
dt.Columns.Add("AttributeCoupleUnitID");

XCATCOMLib.Attribute prodAttribute = catalog.GetAttribute(CATEGORY_TABLE, attributeID);
XCATCOMLib.Search search = new XCATCOMLib.SearchClass();
XCATCOMLib.TaxonomyLookupParameter param = search.Parameters.NewTaxonomyLookupParameter(PRODUCT_TABLE, CATEGORY_FIELD);
param.NodeID = categoryID;

XCATCOMLib.FreeFormTableParameter tableParam = search.Parameters.NewFreeFormParameter(PRODUCT_TABLE);
XCATCOMLib.FeatureParameter featureParam = null;

int attribType = prodAttribute.Type;
string attribDefinition = prodAttribute.Definition;
byte attribPriority = prodAttribute.Priority;

if (attribType == 0) //xcFeatureValueType
{
XCATCOMLib.FeatureValues fvs = catalog.GetLimitedFeatureValues(search, CATEGORY_TABLE, attributeID);
foreach (FeatureValue fv in fvs)
{
row = dt.NewRow();
row["AttributeValue"] = fv.ID;
row["AttributeID"] = attributeID;
row["AttributeDisplayValue"] = fv.Value;
row["AttributeRating"] = 0;
row["ShowAllFlag"] = false;
row["AttributePriority"] = attribPriority;
row["AttributeUnitID"] = "";
row["AttributeCoupleUnitID"] = "";
dt.Rows.Add(row);
}
}
else if ((attribType & 0xFF) > 0) //xcCharacteristicValueType
{
string attribName = Helper.FormatAttributeName(prodAttribute.Name);
string attribAlias = prodAttribute.Alias;

int[] gRatingArray = new int[5];
gRatingArray[0] = 8;//"xcNominalRating";
gRatingArray[1] = 1;//"xcMinimumRating";
gRatingArray[2] = 2;//"xcMaximumRating";
gRatingArray[3] = 16;//"xcAverageRating";
gRatingArray[4] = 4;//"xcTypicalRating";

int attribTypeInt = prodAttribute.Type;
for (int k = 0; k < gRatingArray.Length; k++)
{
int rating = gRatingArray[k];

if ((attribTypeInt & rating) == rating)
{
XCATCOMLib.CharacteristicValues cvs = catalog.GetLimitedCharacteristicValues(search, CATEGORY_TABLE, attributeID, (RatingEnum)rating);

foreach (CharacteristicValue cv in cvs)
{
row = dt.NewRow();
row["AttributeID"] = attributeID;
row["AttributeDisplayValue"] = cv.GetString(prodAttribute.DimensionID, prodAttribute.DecimalPlaces, prodAttribute.AllowFractions, cv.UnitID);;
row["AttributeValue"] = cv.Value;
row["AttributeCoupleValue"] = "";
row["AttributeRating"] = rating;
row["ShowAllFlag"] = false;
row["AttributePriority"] = attribPriority;
row["AttributeUnitID"] = cv.UnitID;
row["AttributeCoupleUnitID"] = "";
dt.Rows.Add(row);
}
}
}
}
else if (attribType == 0x8000) //xcCoupledValueType
{
XCATCOMLib.CoupledValues cpvs = catalog.GetLimitedCoupledValues(search, CATEGORY_TABLE, attributeID);
foreach (CoupledValue cpv in cpvs)
{
string primary;
string coupled;
primary = cpv.Primary.GetString(prodAttribute.DimensionID, prodAttribute.DecimalPlaces, prodAttribute.AllowFractions, cpv.Primary.UnitID);
coupled = cpv.Coupled.GetString(prodAttribute.CoupledDimensionID, prodAttribute.CoupledDecimalPlaces, prodAttribute.CoupledAllowFractions, cpv.Coupled.UnitID);

row = dt.NewRow();
row["AttributeDisplayValue"] = primary + " " + prodAttribute.CoupledDelimiter + " " + coupled;;
row["AttributeValue"] = cpv.Primary.Value;
row["AttributeCoupleValue"] = cpv.Coupled.Value;
row["AttributeID"] = attributeID;
row["AttributeRating"] = 0;
row["ShowAllFlag"] = false;
row["AttributePriority"] = attribPriority;
row["AttributeUnitID"] = cpv.Primary.UnitID;
row["AttributeCoupleUnitID"] = cpv.Coupled.UnitID;
dt.Rows.Add(row);
}
}

return dt;
}

SAP MDM COM API SP5

2007-08-09T15:14:00.000-05:00

MDM SP5 seems to be faster overall. A new field has been added in the console called "Code". This is really nice because now you can access fields using this Code name instead of the display Name.

There were a lot of places in where I had to change .Name to .Code, but after that the upgrade went smoothly.

Scrollovers - A New Way of Linking

2007-08-03T12:08:00.000-05:00

I like the idea. Too many on a page might be overkill though.

Scrollovers - A New Way of Linking

2010, a "Windows 7" software subscription odyssey

2007-07-24T11:45:00.001-05:00

Microsoft has again confirmed that the "big release" approach to software development is alive and well at Microsoft. Ballmer said as much earlier this year in advance of the retail Vista launch, but the company is reiterating the point now as it ramps up preparation for the next version of Windows and a renewed push for software subscriptions.

read more | digg story

Send Web User Control as Email

2007-07-19T09:34:00.000-05:00

I often have to setup an application to auto-send emails. I use a user control as the body of the email to save time formatting the HTML.

private string getSupervisorEmailContent()

    string content;

    // create and populate an instance of a ContentControl user control

    EmailSupervisor cc = (EmailSupervisor)this.LoadControl("EmailSupervisor.ascx");

    cc.EmployeeName = this.lblEmployeeName.Text;

    cc.SystemLink = "http://" + HttpContext.Current.Request.Url.Host + "/TechLadder";

    // render the output of the user control to a string, for use by the email message body

    System.Text.StringBuilder sb = new System.Text.StringBuilder();

    System.IO.StringWriter sw = new System.IO.StringWriter(sb);

    System.Web.UI.HtmlTextWriter htmltw = new System.Web.UI.HtmlTextWriter(sw);

    cc.RenderControl(htmltw);

    content = sb.ToString();

    return content;

private void SendSupervisorEmail(string email)

try

        MailAddress from = new MailAddress("no-reply@andrew.com");

        MailAddress to = new MailAddress(email);

        MailMessage Message = new MailMessage(from, to);

        Message.IsBodyHtml = true;

        Message.Subject = "System Engineering Technical Ladder";

        string superMsg = getSupervisorEmailContent();

        Message.Body = superMsg;

        SmtpClient client = new SmtpClient(ConfigurationManager.AppSettings["Andrew:MailServer"]);

        client.Send(Message);

    catch (Exception ex)

        throw ex;

SAP MDM COM API

2007-07-17T11:34:00.001-05:00

For more than a year I’ve been using the SAP MDM (Master Data Management) COM API with .NET 1.1. Getting started was frustrating. There isn’t a lot of code samples out there.
Here is a simple function to get the product record by product ID.

public static XCATCOMLib.ResultSet GetResultSet(int productID, XCATCOMLib.Catalog catalog)
{
XCATCOMLib.Search search = new XCATCOMLib.SearchClass();
XCATCOMLib.ResultSetDefinition productsRsDef = null;

// get references to tables
XCATCOMLib.Tables tables = catalog.Tables;
XCATCOMLib.Table prodTable = tables.Item(PRODUCT_TABLE);

// products
productsRsDef = new XCATCOMLib.ResultSetDefinitionClass();
productsRsDef.Table = prodTable.Name;

//get the column names of the product table
for (int j = 0; j < prodTable.Fields.Count; j++)
{
productsRsDef.Fields.Add(prodTable.Fields.Item(j));
}

XCATCOMLib.TableParameter lp = search.Parameters.NewTableParameter(PRODUCT_TABLE);
lp.RecordIDs.Add(productID);

ResultSet rs = catalog.GetResultSet(search, productsRsDef, prodTable.Fields.Item(0).Name, true, 0);

return rs;
}

Retrieve Microsoft Exchange FreeBusy data

2007-07-17T11:33:00.001-05:00

I wanted to show an exchange users calendar for the current day. There is a command you can use with Microsoft Outlook web access. At first I thought I could just call this command, parse the XML and display a table from 8am to 5pm showing out of office, in a meeting, etc..
What I didn’t realize is that you will always get back null unless you run the command on the exchange server. Microsft actually explains that you should use the command to make a web service.

You can also use CDOEX, (Collaboration Data Objects for Exchange), to retrieve the data. Again, this must be run on the exchange server. You’d have to find the cdoex.dll and regsvr32 it locally to add it to Visual Studio. You can find the dll on the exchange server or search the web. That code looks like this:

string freebusy = “EMPTY”;
int Interval = 30;
DateTime dtStartDate = DateTime.Parse(“2/8/2007 1:00:00 AM”);
DateTime dtEndDate = DateTime.Parse(“2/8/2007 11:00:00 PM”);

CDO.Addressee iAddr = new CDO.Addressee();
ActiveDs.ADSystemInfo Info = new ActiveDs.ADSystemInfo();

iAddr.EmailAddress = “example@example.com”;
if (!(iAddr.CheckName(“LDAP://” + Info.DomainDNSName, “”, “”)))
throw new System.Exception(“Error occured!”);

freebusy = iAddr.GetFreeBusy(dtStartDate, dtEndDate, 30, “”, “”, “”, “”);

Change Gridview row color

2007-07-17T11:32:00.001-05:00

One way to change the entire row color of a GridView is to do it during RowDataBound(). If a flag returns true from the database I wanted to make that entire row red. Here is how I did that:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView test = (System.Data.DataRowView)e.Row.DataItem;
bool actionPlanExists = SqlConvert.ToBoolean(test.Row[“ActionPlanExists”]);
if (actionPlanExists == true)
{
e.Row.BackColor = System.Drawing.Color.Red;
e.Row.ForeColor = System.Drawing.Color.White;
}
}
}

.NET Localization

2007-07-17T11:31:00.000-05:00

Here is code to offer a dropdownlist so visitors can change the language.

– Language –
English
中文版本 - Chinese
Ceština - Czech
Francois - French
Deutsch - German
Italiono - Italian
Español - Spanish
Português - Portuguese

protected void ddlLanguage_SelectedIndexChanged(object sender, EventArgs e)
{
//store the selected language in a cookie
}
protected override void InitializeCulture()
{
string lang = string.Empty;
HttpCookie cookie = System.Web.HttpContext.Current.Request.Cookies[“MyAPP”];

if (cookie != null)
{
try
{
lang = cookie[“Language”];
}
catch
{ }
}

if ((lang != null) && (lang != string.Empty))
{
String selectedLanguage = lang;

if ((selectedLanguage != null) && (selectedLanguage != “”))
{
UICulture = selectedLanguage;
Culture = selectedLanguage;

Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(selectedLanguage);
Thread.CurrentThread.CurrentUICulture = new CultureInfo(selectedLanguage);
}
base.InitializeCulture();
}
}

MDM Get Attributes

2007-07-17T11:29:00.000-05:00

I needed a way to get all the attributes for a repository in MDM. I did that with the MDM COM API like this:

this.catalog = Helper.GetCatalog();

DataTable dt = new DataTable();
dt.Columns.Add(”Name”);
dt.Columns.Add(”ID”);
XCATCOMLib.Attributes allAttributes = new XCATCOMLib.AttributesClass();
allAttributes = catalog.GetAttributes(CATEGORY_TABLE, 0, false);

foreach(XCATCOMLib.Attribute attrib in allAttributes)
{

DataRow row = dt.NewRow();
row[”Name”] = attrib.Name;
row[”ID”] = attrib.ID;
dt.Rows.Add(row);

}

this.dgAttributes.DataSource = dt;

this.dgAttributes.DataBind();

MDM Multiple Languages

2007-07-17T11:28:00.000-05:00

MDM has great support for multiple languages. You can login to their GUI client (Data Manager) with your desired language. I found out that when you use the MDM COM API with multiple languages to get images you have to use their enumerations.

You can’t pass in “Original”, you must pass in XCATCOMLib.ImageVariantTypeEnum.xcOriginalType
I also had to get the “Images” tableID. Otherwise the Secondary languages will not retrieve an image.

Here’s a function to get an image:

public static string GetImage(XCATCOMLib.Fields objFields, XCATCOMLib.Catalog catalog, ImageVariantTypeEnum variantType)
{
string imgURL;
System.Object[] imgID = (System.Object[])objFields.Item(”Images”).Value;
int imagesTable = objFields.Item(”Images”).LookupTableID;
int webimgID = int.Parse(imgID.GetValue(0).ToString());

CachedImageInfo imgInfo = catalog.GetCachedImageInfo(imagesTable, webimgID, variantType);
string imageCached = imgInfo.CachedPath.Replace(”\\”,”/”);
imgURL = ConfigurationSettings.AppSettings[”ImagesCacheFolder”] + “/” + imageCached;

return imgURL;
}