OWC11 Not coming For webpage....

M

mak

Hello!
I am working with asp.net 2005 and i want to do a web page. So i need a
chart from microsoft office xp web components. Here is what i do:
1. I add a reference from menu bar website>add reference and i add microsoft
office web components 11
2. in toolbox i do right click and i choose "choose items" from com
components i check the microsoft office chart 11.0
but it does't insert into the toolbox, when i do it for a window application
it works but for the web application it does't work. Doew anyone know what
happen and how can i show the chart into my toolbox?

Thanks in advance,

Regards,
kam
 
M

mak

hey alvin,

i tried to display the spreadsheet like the following way

1. by referring your blog i copied the Object tag into my ASP.NET 2.0 web
page.
2. The formula and data i entered in separate excel file, saved it as
webpage,
then by right clicking that i copied the XML content.
3. In my asp.net 2.0 web page i copied the xml content as Param tag.

now i cud see the same functionality which i saw in excel application, using
Spreadsheet in webpage.

Upto this fine, but my issue is

1. the formula i have to bind from sql server 2005 table. (.i.e,., at runtime)
2. i have to load the data at runtime from sql server 2005
3. the user will do changes, that i have to update again in sequl2005.

i mean i need the functionality which is similiart to other controls like
"textbox". to access the properties.
Is it possible to get that same, If my expectation is wrong plz apologize.

looking for ur reply.



Alvin Bruney said:
Strictly speaking, it should work for neither. See my blog for an
explanation of why

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


mak said:
Hello!
I am working with asp.net 2005 and i want to do a web page. So i need a
chart from microsoft office xp web components. Here is what i do:
1. I add a reference from menu bar website>add reference and i add
microsoft
office web components 11
2. in toolbox i do right click and i choose "choose items" from com
components i check the microsoft office chart 11.0
but it does't insert into the toolbox, when i do it for a window
application
it works but for the web application it does't work. Doew anyone know what
happen and how can i show the chart into my toolbox?

Thanks in advance,

Regards,
kam
 
A

Alvin Bruney [MVP]

One of the easiets (read painfree) ways to do this is to simply fire the
query and write a little routine to parse the dataset into a comma delimited
string. Then you load that string into a server-side text box with viewstate
set to true. Modify your client-side OWC code to load data from the textbox
using CSVDATA. That will work.

Your parse routine should be something like this
using System.Text;
StringBuilder sb = new StringBuilder(1024);
for(int i = 0; i < mySQLDATASET.Tables[0].Rows.Count; i++)
{
for(int j = 0; j < mySQLDATASET.Tables [0].Columns.Count; j++)
{
sb.Append(mySQLDATASET.Tables[0].Rows[j].ToString());
}
//row delimiter
sb.Append(System.Environtment.Newline);
}
TextBox1.text = sb.ToString();

air code.
--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


mak said:
hey alvin,

i tried to display the spreadsheet like the following way

1. by referring your blog i copied the Object tag into my ASP.NET 2.0 web
page.
2. The formula and data i entered in separate excel file, saved it as
webpage,
then by right clicking that i copied the XML content.
3. In my asp.net 2.0 web page i copied the xml content as Param tag.

now i cud see the same functionality which i saw in excel application,
using
Spreadsheet in webpage.

Upto this fine, but my issue is

1. the formula i have to bind from sql server 2005 table. (.i.e,., at
runtime)
2. i have to load the data at runtime from sql server 2005
3. the user will do changes, that i have to update again in sequl2005.

i mean i need the functionality which is similiart to other controls like
"textbox". to access the properties.
Is it possible to get that same, If my expectation is wrong plz apologize.

looking for ur reply.



Alvin Bruney said:
Strictly speaking, it should work for neither. See my blog for an
explanation of why

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


mak said:
Hello!
I am working with asp.net 2005 and i want to do a web page. So i need a
chart from microsoft office xp web components. Here is what i do:
1. I add a reference from menu bar website>add reference and i add
microsoft
office web components 11
2. in toolbox i do right click and i choose "choose items" from com
components i check the microsoft office chart 11.0
but it does't insert into the toolbox, when i do it for a window
application
it works but for the web application it does't work. Doew anyone know
what
happen and how can i show the chart into my toolbox?

Thanks in advance,

Regards,
kam
 
M

mak

Alvin,

I am lucky, to get the plenty of code from your side, thanks for that.
Is it possible to access the properties of the Spreadsheet Object Tag in
Code behind file.

As of now i hvnt written any code to access the properties, since it is not
coming.
for ex.
If i add textbox in my webpage, i can access the properties in Code behind
Is the same way can i do with Spreadsheet control.

Regards,
mak

Alvin Bruney said:
One of the easiets (read painfree) ways to do this is to simply fire the
query and write a little routine to parse the dataset into a comma delimited
string. Then you load that string into a server-side text box with viewstate
set to true. Modify your client-side OWC code to load data from the textbox
using CSVDATA. That will work.

Your parse routine should be something like this
using System.Text;
StringBuilder sb = new StringBuilder(1024);
for(int i = 0; i < mySQLDATASET.Tables[0].Rows.Count; i++)
{
for(int j = 0; j < mySQLDATASET.Tables [0].Columns.Count; j++)
{
sb.Append(mySQLDATASET.Tables[0].Rows[j].ToString());
}
//row delimiter
sb.Append(System.Environtment.Newline);
}
TextBox1.text = sb.ToString();

air code.
--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


mak said:
hey alvin,

i tried to display the spreadsheet like the following way

1. by referring your blog i copied the Object tag into my ASP.NET 2.0 web
page.
2. The formula and data i entered in separate excel file, saved it as
webpage,
then by right clicking that i copied the XML content.
3. In my asp.net 2.0 web page i copied the xml content as Param tag.

now i cud see the same functionality which i saw in excel application,
using
Spreadsheet in webpage.

Upto this fine, but my issue is

1. the formula i have to bind from sql server 2005 table. (.i.e,., at
runtime)
2. i have to load the data at runtime from sql server 2005
3. the user will do changes, that i have to update again in sequl2005.

i mean i need the functionality which is similiart to other controls like
"textbox". to access the properties.
Is it possible to get that same, If my expectation is wrong plz apologize.

looking for ur reply.



Alvin Bruney said:
Strictly speaking, it should work for neither. See my blog for an
explanation of why

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


Hello!
I am working with asp.net 2005 and i want to do a web page. So i need a
chart from microsoft office xp web components. Here is what i do:
1. I add a reference from menu bar website>add reference and i add
microsoft
office web components 11
2. in toolbox i do right click and i choose "choose items" from com
components i check the microsoft office chart 11.0
but it does't insert into the toolbox, when i do it for a window
application
it works but for the web application it does't work. Doew anyone know
what
happen and how can i show the chart into my toolbox?

Thanks in advance,

Regards,
kam
 
A

Alvin Bruney [MVP]

You can't access the object tag, you can access the object thru it's id by
streaming out script from the server. Roughly:
Response.Write("<script>document.all.spreadsheet_id.CSVDATA='1,2,3,4,5'</script>");

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


mak said:
Alvin,

I am lucky, to get the plenty of code from your side, thanks for that.
Is it possible to access the properties of the Spreadsheet Object Tag in
Code behind file.

As of now i hvnt written any code to access the properties, since it is
not
coming.
for ex.
If i add textbox in my webpage, i can access the properties in Code behind
Is the same way can i do with Spreadsheet control.

Regards,
mak

Alvin Bruney said:
One of the easiets (read painfree) ways to do this is to simply fire the
query and write a little routine to parse the dataset into a comma
delimited
string. Then you load that string into a server-side text box with
viewstate
set to true. Modify your client-side OWC code to load data from the
textbox
using CSVDATA. That will work.

Your parse routine should be something like this
using System.Text;
StringBuilder sb = new StringBuilder(1024);
for(int i = 0; i < mySQLDATASET.Tables[0].Rows.Count; i++)
{
for(int j = 0; j < mySQLDATASET.Tables [0].Columns.Count; j++)
{
sb.Append(mySQLDATASET.Tables[0].Rows[j].ToString());
}
//row delimiter
sb.Append(System.Environtment.Newline);
}
TextBox1.text = sb.ToString();

air code.
--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


mak said:
hey alvin,

i tried to display the spreadsheet like the following way

1. by referring your blog i copied the Object tag into my ASP.NET 2.0
web
page.
2. The formula and data i entered in separate excel file, saved it as
webpage,
then by right clicking that i copied the XML content.
3. In my asp.net 2.0 web page i copied the xml content as Param tag.

now i cud see the same functionality which i saw in excel application,
using
Spreadsheet in webpage.

Upto this fine, but my issue is

1. the formula i have to bind from sql server 2005 table. (.i.e,., at
runtime)
2. i have to load the data at runtime from sql server 2005
3. the user will do changes, that i have to update again in sequl2005.

i mean i need the functionality which is similiart to other controls
like
"textbox". to access the properties.
Is it possible to get that same, If my expectation is wrong plz
apologize.

looking for ur reply.



:

Strictly speaking, it should work for neither. See my blog for an
explanation of why

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


Hello!
I am working with asp.net 2005 and i want to do a web page. So i
need a
chart from microsoft office xp web components. Here is what i do:
1. I add a reference from menu bar website>add reference and i add
microsoft
office web components 11
2. in toolbox i do right click and i choose "choose items" from com
components i check the microsoft office chart 11.0
but it does't insert into the toolbox, when i do it for a window
application
it works but for the web application it does't work. Doew anyone
know
what
happen and how can i show the chart into my toolbox?

Thanks in advance,

Regards,
kam
 
M

mak

Alvin,

i will gohead with that, thanks alot.
do u cover any of these issue which i asked you in your BLACK BOOK.
Is that Book is available in India?

Alvin Bruney said:
You can't access the object tag, you can access the object thru it's id by
streaming out script from the server. Roughly:
Response.Write("<script>document.all.spreadsheet_id.CSVDATA='1,2,3,4,5'</script>");

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


mak said:
Alvin,

I am lucky, to get the plenty of code from your side, thanks for that.
Is it possible to access the properties of the Spreadsheet Object Tag in
Code behind file.

As of now i hvnt written any code to access the properties, since it is
not
coming.
for ex.
If i add textbox in my webpage, i can access the properties in Code behind
Is the same way can i do with Spreadsheet control.

Regards,
mak

Alvin Bruney said:
One of the easiets (read painfree) ways to do this is to simply fire the
query and write a little routine to parse the dataset into a comma
delimited
string. Then you load that string into a server-side text box with
viewstate
set to true. Modify your client-side OWC code to load data from the
textbox
using CSVDATA. That will work.

Your parse routine should be something like this
using System.Text;
StringBuilder sb = new StringBuilder(1024);
for(int i = 0; i < mySQLDATASET.Tables[0].Rows.Count; i++)
{
for(int j = 0; j < mySQLDATASET.Tables [0].Columns.Count; j++)
{
sb.Append(mySQLDATASET.Tables[0].Rows[j].ToString());
}
//row delimiter
sb.Append(System.Environtment.Newline);
}
TextBox1.text = sb.ToString();

air code.
--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


hey alvin,

i tried to display the spreadsheet like the following way

1. by referring your blog i copied the Object tag into my ASP.NET 2.0
web
page.
2. The formula and data i entered in separate excel file, saved it as
webpage,
then by right clicking that i copied the XML content.
3. In my asp.net 2.0 web page i copied the xml content as Param tag.

now i cud see the same functionality which i saw in excel application,
using
Spreadsheet in webpage.

Upto this fine, but my issue is

1. the formula i have to bind from sql server 2005 table. (.i.e,., at
runtime)
2. i have to load the data at runtime from sql server 2005
3. the user will do changes, that i have to update again in sequl2005.

i mean i need the functionality which is similiart to other controls
like
"textbox". to access the properties.
Is it possible to get that same, If my expectation is wrong plz
apologize.

looking for ur reply.



:

Strictly speaking, it should work for neither. See my blog for an
explanation of why

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


Hello!
I am working with asp.net 2005 and i want to do a web page. So i
need a
chart from microsoft office xp web components. Here is what i do:
1. I add a reference from menu bar website>add reference and i add
microsoft
office web components 11
2. in toolbox i do right click and i choose "choose items" from com
components i check the microsoft office chart 11.0
but it does't insert into the toolbox, when i do it for a window
application
it works but for the web application it does't work. Doew anyone
know
what
happen and how can i show the chart into my toolbox?

Thanks in advance,

Regards,
kam

 
A

Alvin Bruney [MVP]

Yup, these topics are covered. Amazon ships everywhere.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


mak said:
Alvin,

i will gohead with that, thanks alot.
do u cover any of these issue which i asked you in your BLACK BOOK.
Is that Book is available in India?

Alvin Bruney said:
You can't access the object tag, you can access the object thru it's id
by
streaming out script from the server. Roughly:
Response.Write("<script>document.all.spreadsheet_id.CSVDATA='1,2,3,4,5'</script>");

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


mak said:
Alvin,

I am lucky, to get the plenty of code from your side, thanks for that.
Is it possible to access the properties of the Spreadsheet Object Tag
in
Code behind file.

As of now i hvnt written any code to access the properties, since it is
not
coming.
for ex.
If i add textbox in my webpage, i can access the properties in Code
behind
Is the same way can i do with Spreadsheet control.

Regards,
mak

:

One of the easiets (read painfree) ways to do this is to simply fire
the
query and write a little routine to parse the dataset into a comma
delimited
string. Then you load that string into a server-side text box with
viewstate
set to true. Modify your client-side OWC code to load data from the
textbox
using CSVDATA. That will work.

Your parse routine should be something like this
using System.Text;
StringBuilder sb = new StringBuilder(1024);
for(int i = 0; i < mySQLDATASET.Tables[0].Rows.Count; i++)
{
for(int j = 0; j < mySQLDATASET.Tables [0].Columns.Count; j++)
{
sb.Append(mySQLDATASET.Tables[0].Rows[j].ToString());
}
//row delimiter
sb.Append(System.Environtment.Newline);
}
TextBox1.text = sb.ToString();

air code.
--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


hey alvin,

i tried to display the spreadsheet like the following way

1. by referring your blog i copied the Object tag into my ASP.NET
2.0
web
page.
2. The formula and data i entered in separate excel file, saved it
as
webpage,
then by right clicking that i copied the XML content.
3. In my asp.net 2.0 web page i copied the xml content as Param tag.

now i cud see the same functionality which i saw in excel
application,
using
Spreadsheet in webpage.

Upto this fine, but my issue is

1. the formula i have to bind from sql server 2005 table. (.i.e,.,
at
runtime)
2. i have to load the data at runtime from sql server 2005
3. the user will do changes, that i have to update again in
sequl2005.

i mean i need the functionality which is similiart to other controls
like
"textbox". to access the properties.
Is it possible to get that same, If my expectation is wrong plz
apologize.

looking for ur reply.



:

Strictly speaking, it should work for neither. See my blog for an
explanation of why

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


Hello!
I am working with asp.net 2005 and i want to do a web page. So i
need a
chart from microsoft office xp web components. Here is what i do:
1. I add a reference from menu bar website>add reference and i
add
microsoft
office web components 11
2. in toolbox i do right click and i choose "choose items" from
com
components i check the microsoft office chart 11.0
but it does't insert into the toolbox, when i do it for a window
application
it works but for the web application it does't work. Doew anyone
know
what
happen and how can i show the chart into my toolbox?

Thanks in advance,

Regards,
kam

 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top