Re: First time site upload - ASP.NET Discussion Boards

kirthikirthi14-Jul-06 23:30

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.

Problem in edititemtemplate in vb.net1.1 [modified]

amaneet14-Jul-06 19:42

amaneet

14-Jul-06 19:42

>Hi Friends.

I am putting datalist in the edititemtemplate of the datagrid.After then some part of the datalist code (placed in the edititemtemplate of the datagrid)is not executing.I am placing the datalist in the edititemtemplate of datagrid.

-----------------------------------------------------------
I am using the following code.
-------------------------------------------------------------

<asp:DataGrid id="dg1" runat="server" Width="392px" Height="144px"
AutoGenerateColumns="False"
AllowPaging="True" PageSize="5">
--------------------------------------------------
<Columns>
<asp:TemplateColumn>
<HeaderTemplate>
<TABLE width="100%">
<TR>
<TD width="70%">Deposit Types
</TD>
<TD align="center" width="15%">Edit
</TD>
<TD align="center" width="15%">Delete
</TD>
</TR>
</TABLE>
</HeaderTemplate>
------------------------------------------------------------

<ItemTemplate>
<TABLE width="100%">
<TR>
<TD><%#Container.DataItem(1).ToString()%></TD>
<TD align="center" width="15%">
<asp:ImageButton id="edit" ImageUrl="images/edititem.gif" CommandName="edit" Runat="server"></asp:ImageButton></TD>
<TD align="center" width="15%">
<asp:ImageButton id="Imagebutton1" ImageUrl="images/cross.gif" CommandName="delete" Runat="server"> </TR>
</TABLE>
</ItemTemplate>

-----------------------------------------------------------------------
<EditItemTemplate>
<TABLE id="edititem" width="100%">
<TR>
<TD width="100%">
<asp:DataList id="dl1" Runat="server">
<ItemTemplate>
<table width="100%">
<tr>
<td width="30%">
<%#FindAttribute(Container.DataItem(0).ToString())%>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList></TD>
</TR>
</TABLE>
</EditItemTemplate>
</asp:TemplateColumn>
</Columns>
<pagerStyle Mode="NumericPages"></PagerStyle>
</asp:DataGrid>
Please help.

-- modified at 1:42 Saturday 15th July, 2006

general

dansoft14-Jul-06 19:21

dansoft

14-Jul-06 19:21

I am developing a billing system. I'm having tables including packages and invoices. The packages are created for each invoices.

How can i renew the packages? For example one package is monthly plan and the second one is yearly plan. How can i renew the monthly plan package and generate an invoice for that package. This must also helps to track the invoice & package details.

I'm very much confused please help me!

Re: general

Colin Angus Mackay15-Jul-06 13:28

Colin Angus Mackay

15-Jul-06 13:28

One would assume that there would be some business rules governing this. For exampe, for a yearly plan you may do a search at the start of each month to see whose plan is expiring in the next month and generate invoices. However, what ever the rule is, it is up to the business rather than you. You need to ask what the rules are for governing renewals in your business.

Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

How to bind data in datagrid

ypsyong14-Jul-06 18:28

ypsyong

14-Jul-06 18:28

Good day to all. Smile | :)

I got a problem to bind a data into datagrid in asp.net.
My problem is, i got several way to key in the data to search the relevant data to be bind in the datagrid.

Such as i got 3 textbox provide for the user to key in the input data, and how do i need to use this different data to filter out the most accurate data to be bind in the datagrid.

Can anyone give me a solution to solve this problem. If got sample code would be more better.

Thanks and have a nice day. Big Grin | :-D