Do drag and drop controls create DataSets

When I drag a GridView from the toolbox onto a Webform, and then configure its DataSource is a true DataSet created that I can access in the code behind? When my results return I want to be able to access individual rows and cells, taking their values, assiging them to variables and then using the newly equated variable to perform calculations.

Thank you,

Your GridView is bound to dataset It is simple to access values in dataset: your_DataTable.Rows[rowindex][colunmindex]

Or use GridView1.Rows[rowid].Cells[cellindex] to access the control (or findControl(id) if there are many).

DM Windows Forms Controls in November Feature Pack for SS2005

Hello,

There is a download in the Feature Pack For Microsoft SQL Server 2005 - November 2005 for the Microsoft SQL Server 2005 Datamining Viewer Controls. Unfortunately I cannot find a shred of documentation for said controls. It would be nice to know what their names are, where they are installed, how you add them to your toolbox. Sample apps would be of great benefit as well (but I don't want to ask for too much).

Here is the description for the controls which I find somewhat confusing. Are they Web Controls or Windows Forms Controls?

The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2005 Analysis Services in their client-side applications.

Wendell G.

I agree that documentation would be useful. In the meantime, this sample that demonstrates how to embed the viewer controls (which *are* Winform controls and not web controls, as the description mistakenly indicates) might help:

http://www.sqlserverdatamining.com/DMCommunity/Downloads/Links_LinkRedirector.aspx?id=1362

|||

Wow Raman, this is incredible! Thank you so much.

It appears these controls are the controls that the Business Intelligence Developer's Studio is built with. Does anyone know if these controls are redistributable? I am especially interested in the Microsoft.AnalysisServices.Controls, Microsoft.AnalysisServices.Graphing, and Microsoft.AnalysisServices.Viewers.

Do the controls require Analysis Services to be installed on the deployed workstation?

If Microsoft does not have these documented, is anyone writing a developer's book that explains how to use them?

Thanks again!

Wendell G

|||

Yup, these are the viewer controls hosted in BI Dev Studio and SQL Mgmt Studio and they *are* redistributable. The controls don't require an AS install on the workstation - they only require a subset of client components (just the AS 9.0 OLE DB driver, I believe - the install should pop up the appropriate prerequisites if they are missing).

We are hoping to provide documentation in a web refresh but I don't have a timeframe yet.