Error For Processing Model

In the previous thread I said when I want to create a model and structure, in process time one error appeared that I said.
Now I think this error is because of my structure now I€˜ve one request i send my project and please see that and say what is this error?
Thanks a lot.
For creating mining structure and mining model I use the code of chapter14 file that one person had put for me

Please run this project and then say whay when I process my model ,the process do incorrectly.
in this code button 1 is for showing the anme of data bsase and table and column of that in currenyt server and then with button 2 i want ot creat model and struture and data source data source view
now please run this code and then say whay i have error for process model .
please run and answer me
thanks a lot


string last;

int ts;

string[] items;

string ky;

string t;

string dbnam;

string tblnam;

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True");

con.Open();

SqlCommand cmd1 = new SqlCommand(" EXEC sp_databases;", con);

DataSet ds = new DataSet();

SqlDataAdapter da1 = new SqlDataAdapter();

da1.SelectCommand = cmd1;

da1.Fill(ds, "1");

this.comboBox1.DisplayMember = "database_name";

this.comboBox1.ValueMember = "database_name";

this.comboBox1.DataSource = ds.Tables["1"];

SqlCommand cmd2 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_tables @table_owner ='dbo';", con);

SqlDataAdapter da2 = new SqlDataAdapter();

da2.SelectCommand = cmd2;

da2.Fill(ds, "2");

this.comboBox2.DisplayMember = "table_name";

this.comboBox2.ValueMember = "table_name";

this.comboBox2.DataSource = ds.Tables["2"];

SqlCommand cmd3 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_columns @table_name = N'" + comboBox2.Text.ToString() + "', @table_owner = N'DBO';", con);

SqlDataAdapter da3 = new SqlDataAdapter();

da3.SelectCommand = cmd3;

da3.Fill(ds, "3");

DataTable dt = new DataTable();

dt.Columns.Add("column_name");

dt.Columns.Add("data_type");

for (int i = 0; i < ds.Tables["3"].Rows.Count; i++)

{

DataRow dr = ds.Tables["3"].Rows;

dt.Rows.Add(dr[3], dr[5]);



}

con.Close();

dataGridView1.Columns.Clear();

dataGridView1.DataSource = dt;

DataGridViewCheckBoxColumn DVCC = new DataGridViewCheckBoxColumn();

DVCC.Name = "key";

dataGridView1.Columns.Add(DVCC);

DataGridViewCheckBoxColumn DVCC2 = new DataGridViewCheckBoxColumn();

DVCC2.Name = "input";

dataGridView1.Columns.Add(DVCC2);

DataGridViewCheckBoxColumn DVCC3 = new DataGridViewCheckBoxColumn();

DVCC3.Name = "predict";

dataGridView1.Columns.Add(DVCC3);



}

private void Form1_Load(object sender, EventArgs e)

{

}

private void button2_Click(object sender, EventArgs e)

{

dbnam = comboBox1.Text;

tblnam = comboBox2.Text;

Microsoft.AnalysisServices.Server srv = new Server();

srv.Connect("data source=localhost");

string dbname;

dbname = comboBox1.Text;



Database dbNew = new Database(dbname,

Utils.GetSyntacticallyValidID(dbname, typeof(Database)));

srv.Databases.Add(dbNew);

dbNew.Update();

//***************************//

string DataSourcename;

DataSourcename = comboBox1.Text;

RelationalDataSource dsNew = new RelationalDataSource(

DataSourcename,

Utils.GetSyntacticallyValidID(

DataSourcename,

typeof(RelationalDataSource)));

dsNew.ConnectionString = "Provider=SQLNCLI;Data Source=localhost;" +

"Initial Catalog="+comboBox1.Text+";Integrated Security=SSPI"; ;

dbNew.DataSources.Add(dsNew);

dsNew.Update();

//**************************//





DataSet dset = new DataSet();

SqlConnection cn = new SqlConnection("Data Source=localhost;" +

"Initial Catalog="+comboBox1.Text+";Integrated Security=true");

SqlDataAdapter da = new SqlDataAdapter("select * from "+comboBox2.Text,cn);



da.FillSchema(dset, SchemaType.Mapped, comboBox2.Text);

DataSourceView dsv = new DataSourceView(comboBox1.Text, comboBox1.Text);

dsv.DataSourceID = comboBox1.Text ;

dsv.Schema = dset.Clone();

dbNew.DataSourceViews.Add(dsv);

dbNew.Update(UpdateOptions.ExpandFull);







MiningStructure ms = dbNew.MiningStructures.Add(comboBox2.Text, Utils.GetSyntacticallyValidID(comboBox2.Text,

typeof(MiningStructure)));

ms.Source = new DataSourceViewBinding(comboBox1.Text);

ms.CaseTableName = comboBox2.Text;



int count = dataGridView1.Rows.Count;

for (int i = 0; i < count - 1; i++)

{







if (Convert.ToBoolean(dataGridView1.Rows.Cells["key"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["input"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["predict"].Value))

{

string X;





X = Convert.ToString(dataGridView1[0, i].Value);

ScalarMiningStructureColumn I;

I = new ScalarMiningStructureColumn(X,

Utils.GetSyntacticallyValidID(X, typeof(ScalarMiningStructureColumn)));

if (!Convert.ToBoolean(dataGridView1[2, i].Value))

{



I.IsKey = false;

I.Type = conv(Convert.ToString(dataGridView1[1, i].Value));

I.Content = "Continuous";



}

else

{

ky = X;

I.IsKey = true;

I.Content = "Key";

I.KeyColumns.Add(comboBox2.Text, X, OleDbType.Integer);

}

ms.Columns.Add(I);



}

// //****************************************************************************************************************************************//

}

ms.Update();

MiningModel mm = ms.MiningModels.Add(comboBox2.Text,

Utils.GetSyntacticallyValidID(comboBox2.Text, typeof(MiningModel)));

mm.Algorithm = "Microsoft_Time_Series";

for (int i = 0; i < count - 1; i++)

{

if (Convert.ToBoolean(dataGridView1.Rows.Cells["key"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["input"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["predict"].Value))

{

string X;

X = Convert.ToString(dataGridView1[0, i].Value);

MiningModelColumn mc = new MiningModelColumn(X,

Utils.GetSyntacticallyValidID(X, typeof(MiningModelColumn)));

mc.SourceColumnID = ms.Columns[X].ID;

if (Convert.ToBoolean(dataGridView1[2, i].Value))

mc.Usage = "Key";

else

if ((Convert.ToBoolean(dataGridView1[3, i].Value)) && (Convert.ToBoolean(dataGridView1[4, i].Value)))

mc.Usage = "Predict";

else

mc.Usage = "PredictOnly";

mm.Columns.Add(mc);

}

}

mm.Update();

ms.Process(ProcessType.ProcessStructure);

mm.Process(ProcessType.ProcessDefault);



srv.Disconnect();

SqlDataAdapter da2 = new SqlDataAdapter("select " + ky + " from " + comboBox2.Text, cn);

DataTable dt=new DataTable();

da2.Fill(dt);

ts = dt.Rows.Count;

items = new string[ts+10];

for (int i = 0; i < ts; i++)

{DataRow dr = dt.Rows;

items=dr[0].ToString();



}

last = items[ts-1];



}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

{



SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True");

SqlCommand cmd2 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_tables @table_owner ='dbo';", con);

con.Open();

SqlDataAdapter da2 = new SqlDataAdapter();

da2.SelectCommand = cmd2;

DataSet ds = new DataSet();

da2.Fill(ds, "2");

con.Close();

this.comboBox2.DisplayMember = "table_name";

this.comboBox2.ValueMember = "table_name";

this.comboBox2.DataSource = ds.Tables["2"];



if (comboBox2.Items.Count > 0)

{

comboBox2.SelectedIndex = 0;

}





}

private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True");

SqlCommand cmd3 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_columns @table_name = N'" + comboBox2.Text.ToString() + "', @table_owner = N'DBO';", con);

con.Open();

SqlDataAdapter da3 = new SqlDataAdapter();

da3.SelectCommand = cmd3;

DataSet ds = new DataSet();

da3.Fill(ds,"3");

con.Close();

dataGridView1.DataSource = "empty";



con.Close();

DataTable dt = new DataTable();

dt.Columns.Add("column_name");

dt.Columns.Add("data_type");



for (int i = 0; i < ds.Tables["3"].Rows.Count; i++)

{

DataRow dr = ds.Tables["3"].Rows;



dt.Rows.Add(dr[3], dr[5]);

}

dataGridView1.Columns.Clear();

dataGridView1.DataSource = dt;

DataGridViewCheckBoxColumn DVCC = new DataGridViewCheckBoxColumn();

DVCC.Name = "key";

dataGridView1.Columns.Add(DVCC);

DataGridViewCheckBoxColumn DVCC2 = new DataGridViewCheckBoxColumn();

DVCC2.Name = "input";

dataGridView1.Columns.Add(DVCC2);

DataGridViewCheckBoxColumn DVCC3 = new DataGridViewCheckBoxColumn();

DVCC3.Name = "predict";

dataGridView1.Columns.Add(DVCC3);



}

public string conv(string data_type)

{



if (data_type == "int" | data_type == "tinyint" | data_type == "smallint" | data_type == "bigint")

t = "Long";

else

if (data_type == "char" | data_type == "nchar" | data_type == "varchar" | data_type == "nvarchar" | data_type == "binary" | data_type == "varbinary" | data_type == "image" | data_type == "text" | data_type == "ntext" | data_type == "timestamp" | data_type == "uniqueidentifier")

t = "text";

else

if (data_type == "decimal" | data_type == "float" | data_type == "money" | data_type == "smallmoney" | data_type == "numeric" | data_type == "real")

t = "Double";

else

if (data_type == "datetime" | data_type == "smalldatetime")

t = "Date";

else

if(data_type=="bit")

t="Boolean";

return t;

}



}

}