Re: OWC11 Not coming For webpage....

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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[i][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" <mak@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:24616086-5A2A-4916-B3CF-912A91534441@xxxxxxxxxxxxxxxx
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 [MVP]" wrote:

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" <mak@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D53741D2-1A73-4F68-911D-00418391F45F@xxxxxxxxxxxxxxxx
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





.

Relevant Pages

  • Re: Idea: Multitasking graphical OS for the GS
    ... My thinking over the years has been to start with the toolbox. ... an event loop like so: ... tell the operating system when each function in your ... when the routine finishes. ...
    (comp.sys.apple2)
  • Re: ComboBox and UserForm_Initialize
    ... I used the View>Toolbars>Control Toolbox. ... After adding the ComboBox I right ... UserForm_Initialize routine but it seems not to execute. ...
    (microsoft.public.word.docmanagement)
  • Re: Cycles per Tool function?
    ... was their ever any documentation on how many cycles ... >intensive certain toolbox functions are. ... and time how long it takes to run the routine. ...
    (comp.sys.apple2.programmer)
  • delta time = time stop - time start
    ... I'm using Python to parse a bunch of s/w test files and make csv files for later report generation by MS ACCESS....(my boss ... Each session in the log has an ASCII start and stop time, ... I have the basic parse part done for parameters, errors, etc., but noticed my routine for determining how long each ... and is a string with leading zeros where appropiate. ...
    (comp.lang.python)
  • Re: Cycles per Tool function?
    ... If the routine is too fast for the timer resolution, you could always run the toolbox routine 100 or 1000 times and then divide the total time by the number of calls you made. ... I would just suggest that you should also run the timing loop 1000 times with a null toolbox call, so you can subtract the overhead of the measurement code from the result before dividing by X. ... t1 = clock; ...
    (comp.sys.apple2.programmer)