Excel Problum - ASP.NET Discussion Boards

Mircea Grelus15-Jul-06 13:06

15-Jul-06 13:06

I think you need to be more specific as to what are you trying to accomplish. Your basicaly saying and asking the same thing.

adamoz wrote:
when i use tag, it changes as in html code page

adamoz wrote:
but i want that the tag i'd written, change as
in html code page

regards,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.

displaying html file on webpage

pawanmishraji15-Jul-06 2:01

pawanmishraji

15-Jul-06 2:01

Dear friends

i have a html file on my system's c drive, i want to display it on web page below a button control. when i click this this button, this file should be displayed.

Pawan Mishra
MCA, MCP.NET, MCAD.NET

Re: displaying html file on webpage

enjoycrack15-Jul-06 20:02

enjoycrack

15-Jul-06 20:02

Hi there,

Just simply reading the file's content by using System.IO namespace....show it on webpage then...

<< >>

Re: displaying html file on webpage

RichardGrimmer17-Jul-06 2:57

RichardGrimmer

17-Jul-06 2:57

Or put it in an IFrame....a little simpler

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

Allow Service to interact with Desktop

Kapil Thakur15-Jul-06 1:45

Kapil Thakur

15-Jul-06 1:45

in a windows services, if we are calling an exe file and we want the UI of the exe to show on desktop. then Under LogOn tab (in services in administrative tools), we check "Allow Service to interact with Desktop" checkbox.

i want to know is there any way that we achieve this through coding.
i mean, can we make that windows service already configured to "Allow Service to interact with Desktop" checkbox checked through coding.

thanks

Re: Allow Service to interact with Desktop

led mike15-Jul-06 16:55

led mike

15-Jul-06 16:55

I think those are registry settings. you might find that Microsoft has hidden such information in the DOCUMENTATION and what does this have to do with ASP.NET?

"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum

led mike

Re: Allow Service to interact with Desktop

stan_p21-Dec-10 0:56

stan_p

21-Dec-10 0:56

Here is how to do it in C#:
http://it.expertmonster.com/question/Allow-service-to-interact-with-desktop-112.html

Excel Problum

kirthikirthi14-Jul-06 23:30

kirthikirthi

14-Jul-06 23:30

Hi all
I am trying to save data in Excel
I have 2 arrays in 1st array fields 2nd array data is there
Iam using this code

MYCODE
--------

Dim i As Integer
Dim strLine As String, filePath, fileName, fileExcel, link
Dim objFileStream As FileStream
Dim objStreamWriter As StreamWriter
Dim nRandom As Random = New Random(DateTime.Now.Millisecond)
Dim fs As Object, myFile As Object
fileExcel = "Results.xls"
If Not Directory.Exists(("c:\WeatherWizard")) Then
Directory.CreateDirectory(("c:\WeatherWizard"))
End If
filePath = ("c:\WeatherWizard")
fileName = filePath & "\" & fileExcel
objFileStream = New FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Write)
objStreamWriter = New StreamWriter(objFileStream)
----------------ARRAY 1
Dim str1 As New ArrayList
str1 = (Session("str"))
For i = 0 To str1.Count - 1
strLine = strLine & str1(i).ToString & Chr(9)
Next
objStreamWriter.WriteLine(strLine)
strLine = ""
-----------------ARRAY 2
Dim j
Dim ia33 As New ArrayList
ia33 = (Session("ia11"))

For j = 0 To ia33.Count - 1
strLine = strLine & ia33(j) & Chr(9)
Next

objStreamWriter.WriteLine(strLine)
strLine = ""

objStreamWriter.Close()
objFileStream.Close()
---------------------------------------------------------
But its is not saving properly Plz can any one help Me

OR CAN U GIVE ME AN IDEA TO SAVE ARRAY's DATA IN EXCEL SHEET

THX

asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf

Re: Excel Problum

Mircea Grelus15-Jul-06 0:16

Mircea Grelus

15-Jul-06 0:16

You have to automate Excel in order to save data properly in excel documents. You have to add a reference to MS Excel Library object. This article[^] will lead you on the right way.

regards,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.

how can i delete from multiple table on a single button click

Amit Agarrwal14-Jul-06 23:22

Amit Agarrwal

14-Jul-06 23:22

how can i delete from multiple table on a single button click
thanx

Re: how can i delete from multiple table on a single button click

Reza Raad15-Jul-06 0:20

Reza Raad

15-Jul-06 0:20

you can delete as many as you want with multiple delete command,
describe your problem more...

Re: how can i delete from multiple table on a single button click

Amit Agarrwal15-Jul-06 0:27

Amit Agarrwal

15-Jul-06 0:27

i hav no common field in the tables so i cann't use join.

on a button click i want to delete records from multiple table.

i'm writing individual query in different strings.

i'm confusing in commandobject and nonexecutequery ().

how would i use them for multiple queries.

thanx

Re: how can i delete from multiple table on a single button click

Reza Raad15-Jul-06 1:30

Reza Raad

15-Jul-06 1:30

there is two way for delete for you:
first way is that you use indivisual queries on command as you used
second way is merging queries as below:
delete * from table1;
delete * from table2;
...

put (;) semicolon between queries.

First time site upload

Maurader14-Jul-06 22:55

Maurader

14-Jul-06 22:55

Hi all,
I am fairly new to ASP.NET and have been trying to upload a site to a 1&1 server, however when viewed on the net I am just seeing the source rather then the page. Any ideas?

Regards,
P.Cairns

Re: First time site upload

Saifi Hasan15-Jul-06 21:29

Saifi Hasan

15-Jul-06 21:29

The Framework may not be there on server, this is why .ASPX files dint get parse & execute . make sure Framework is there and IIS and farmwork is registred.

Nobody is perfect i'm Nobody

Re: First time site upload

Maurader15-Jul-06 23:19

Maurader

15-Jul-06 23:19

Thanks, thats what I have heard from other sources as well. It seems my package did not support the .NET framework, which I have now upgraded. There is a 24hr wait prior to the upgrade so I'll try again then. Thanks.

Regards,
Oz

EditItemTemplate in vb.net 1.1

amaneet14-Jul-06 22:10

amaneet

14-Jul-06 22:10

Sir,
I am returning a table in the td tag of ot table(which is placed in the edititemtemplate of datagrid).Now the problem in it is returning a table but not the structure of the table and returnibg the text and the text value is System.Web.UI.HtmlControls.HtmlTable.But i want the complete structure of the table in that row of the datagrid.Is it possible?
-----------------------------------------------------------------
I am using the following code.
-----------------------------------------------------------------

 public function FindAttribute (byval str as string) as System.Web.UI.HtmlControls.HtmlTable <br />
<br />
        Dim t As New System.Web.UI.HtmlControls.HtmlTable<br />
        t.Width = "100%"<br />
        t.ID = "dynamic"<br />
        Dim drow As System.Web.UI.HtmlControls.HtmlTableRow<br />
         Dim dcell(1) As System.Web.UI.HtmlControls.HtmlTableCell<br />
        Connect()<br />
        Dim recordscount As Integer<br />
        cmd = New OleDbCommand("select count(*) from Depositdetail where depositId=" & str, con)<br />
        dr = cmd.ExecuteReader<br />
        If (dr.Read) Then<br />
            recordscount = dr.Item(0)<br />
        End If<br />
        dr.Close()<br />
<br />
<br />
        cmd = New OleDbCommand("select * from Depositdetail where depositId=" & str, con)<br />
        dr = cmd.ExecuteReader<br />
        While (dr.Read)<br />
                        drow = New System.Web.UI.HtmlControls.HtmlTableRow<br />
                        dcell(0) = New System.Web.UI.HtmlControls.HtmlTableCell<br />
            dcell(0).Width = "30%"<br />
                        dcell(1) = New System.Web.UI.HtmlControls.HtmlTableCell<br />
            dcell(1).Width = "70%"<br />
            dcell(0).InnerText = dr.Item(0)<br />
            dcell(1).InnerText = dr.Item(1)<br />
            drow.Cells.Add(dcell(0))<br />
            drow.Cells.Add(dcell(1))<br />
            t.Rows.Add(drow)<br />
        End While<br />
        FindAttribute = t

Re: EditItemTemplate in vb.net 1.1

RSArockiam15-Jul-06 20:43

RSArockiam

15-Jul-06 20:43

How did you call this code from where (codebehind/html)?
Please specify that part.
If you are using code behind, then you should add this htmltable into controls collection.
If you are accessing this code from html side, this will not work. You have to do some extra ....

So please specify the full code (where you access this function?).

Regards
R.Arockiapathinathan

How can I declarate class in JSctrpt

alexan0814-Jul-06 20:56

alexan08

14-Jul-06 20:56

How can I declarate class in JSctrpt

Re: How can I declarate class in JSctrpt

led mike15-Jul-06 16:57

led mike

15-Jul-06 16:57

you mean using ASP.NET?

"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum

led mike

Re: How can I declarate class in JSctrpt

enjoycrack15-Jul-06 20:08

enjoycrack

15-Jul-06 20:08

Do you mean JScript? If so, look at JScript

<< >>

Re: How can I declarate class in JSctrpt

RichardGrimmer23-Jul-06 8:48

RichardGrimmer

23-Jul-06 8:48

<br />
function myClassName<br />
{<br />
  var m_firstVar;<br />
  var m_secondVar=new String();<br />
<br />
  this.method1 = method1;<br />
  this.method2 = method2;<br />
<br />
  myClassName = new function<br />
    {<br />
      //constructor code<br />
    }<br />
}<br />
<br />
function method1() {} <br />
<br />
<div class="ForumSig">"Now I guess I'll sit back and watch people misinterpret what I just said......" <br />
Christian Graus At The Soapbox<br />
</div>

Make text of HTML Button Bold

varun_khanna1714-Jul-06 20:42

varun_khanna17

14-Jul-06 20:42

I have Html button and i want to make text of button bold.
CAn anybody help in it?

Re: Make text of HTML Button Bold

Amit Agarrwal14-Jul-06 21:46

Amit Agarrwal

14-Jul-06 21:46

hi Every HTML Button has a property called Style in that u can set the text property Bold.

Hope this will work for u.

Re: Make text of HTML Button Bold

Mircea Grelus15-Jul-06 0:53

Mircea Grelus

15-Jul-06 0:53

Just add style="font-weight:bold" in the HTML source of the button (<input id="Button1" type="button" value="button" style="font-weight:bold" />)

regards,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.