ASP.NET

Re: on an aspx formInput=file html control

20-Apr-07 1:17

ok if you click the browse button only you can do is can select the File after selecting the file Add one button "Upload" in this button click event write the code
// iterate through the posted files if you have many html file controls
for (int i = 0; i < Request.Files.Count; i++)
{

HttpPostedFile objFile = Request.Files[i];

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

aransiola20-Apr-07 7:59

aransiola

20-Apr-07 7:59

I want the Browse button(on clicking it) and dispalying the filenamein the input box to display the graphicimage
on my image control

t.aransiola

reading mutiple files from disk

marky77719-Apr-07 22:09

marky777

19-Apr-07 22:09

Hi all.

I need help. I want to read mutiple html files from a folder (help needed here) and convert them to .txt files and manipulate them (no help needed).

I want to know how to do this. I know i have to loop through the folder and load each file independantly,process it, and move onto the next file.

If anyone can help, please reply...

Thanks
Marquin Smile | :)

Re: reading mutiple files from disk

Sandeep Akhare20-Apr-07 0:12

Re: reading mutiple files from disk

20-Apr-07 0:12

You can do that
Use System.IO namespace and Play with Directory and File classes

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

marky77720-Apr-07 1:10

marky777

20-Apr-07 1:10

Thanks. I have figured it out. Cool | :cool:

problem with javascript calendar date format.

MissionSuccess19-Apr-07 21:45

MissionSuccess

19-Apr-07 21:45

Respected Gurus

I m having a javascript calendar,which gives me the date in dd/MM/yyyy format.
My machines regional setting is also in dd/MM/yyyy format.

but when i m trying to save it in the database,it gives me the error "Invalid date time."

although when i set my calendar to return dates in MM/dd/yyyy format,it runs smoothly.But my users want it in dd/MM/yyyy format.

my code is

strIssueDate = Trim(txtIssueDate.Value)
If strIssueDate <> "" Then
dtIssuedate = DateTime.Parse(strIssueDate, System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat).ToShortDateString
End If

after this line i face the error.

Plz,suggest me some permanent solution.....

Re: problem with javascript calendar date format.

varshavmane20-Apr-07 0:24

varshavmane

20-Apr-07 0:24

Hi,

Same problem even I was facing. U just need to change the date format the way user wants to see it and let the date in db be in the format MM/dd/yyyy.

All the Best...

ASP Search Check Spelling

Socheat.Net19-Apr-07 21:28

Socheat.Net

19-Apr-07 21:28

I have problem, how can i use asp to check spelling with you component "Word Automation" becuase the server not installed, please help me
Thanks

................

Using Windows Media Encoder from ASP.NET

Piyush2219-Apr-07 20:38

Piyush22

19-Apr-07 20:38

Hi Gurus,
I was to stream clients Audio and Video to live audience from mywebsite.
I wanted to give users facility to get online and start streaming live from their
Webcam and mic. And the first thing that came to my mind to deploy this
was Windows Media Server and Windows Media Encoder.
I started developing the application and as long I was working
on my developer machine it was all fine but now as i started testing on my server
I am in a total mess.
My WMEncoder is installed on the server and the problem is
when I try to hit the streaming page from my client it enumerates
the devices on the server and not on my client machine.
So whatever the stream is generated is genrated from the webcam on
server and not my webcam
And if no webcam is connected to server the encoder simply fails, hanging the
server Sad Frown | :(

I am compeletly stuck in this and can't find any solution so far.
Any pointer or help would be really great

Thanking You all in advance

pIrus
Dreams in our eyes, We are aiming high
Sky is not the limit, When we spread wings and fly

Marketraise.com

Converting excell file into html file

Lijo Rajan19-Apr-07 20:14

19-Apr-07 20:14

HI All

I need to convert my excell file into html file through asp.net and c# code.Can anyone help me on this or can u provide the code for this.Thanks in advance.

Sandeep Akhare20-Apr-07 1:03

20-Apr-07 1:03

Do you want to open Excel file in IE ?
What is the meaning of converting Excel to html

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Lijo Rajan20-Apr-07 1:11

20-Apr-07 1:11

Mr Sandeep Thank you very much for your respone to my query.
Yes i want to open my excel file which i uploaded in html format in IE.For example in gmail we have the option to view the file which we uploaded as html.Like that i have to view the excel file in html format.Plse help me.

Sandeep Akhare20-Apr-07 1:42

20-Apr-07 1:42

Put the all Excel files in one folder in your application
Add one link on your page like

<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/Images/02639_SandeepSureshAkhare_BFSI_Self Appraisal.xls" Target=_self>HyperLink</asp:HyperLink></td>

and open it i think this one of the simplest way to open any file
The other is COM object which makes your application bulky

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Lijo Rajan20-Apr-07 1:54

20-Apr-07 1:54

Thank you verymuch Mr Sandeep for your answer.I need to open my excel file as html document.Not as excel file.If i use the methode which u told, it will be opened as excel file right? I request u to help me to view my excel file as html file.Suppose the name of the file i uploaded is book1.xls.I need to save this in the folder in the name of book.html instead of book1.xls.Then i can use the methode which u told.So i can give the url of hyperlink is book1.html so that it will be opened as html document.I request you to Plse help me or give me the code for this.

Arun.Immanuel20-Apr-07 2:39

20-Apr-07 2:39

Please Import Microsoft Excel from the COM Tab of the Add Reference Page.

See if this code helps U.
Try to understand this and write Ur code accordingly.

Create a table in the webpage.
Add the rows and its contents dynamically by iterating through the corresponding object.

Excel.Workbook objWorkBook = ExcelObj.Workbooks.Open("d:\\one.xls", 0, true, 5,
"", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true);

Excel.Sheets sheets = objWorkBook.Worksheets;

Excel.Worksheet objworksheet = (Excel.Worksheet)sheets.get_Item(1);

Excel.Range objRange = objworksheet.get_Range("A" + i, "J" + i);
System.Array objvalues = (System.Array)objRange.Cells.Value;
string[] strArray = ConvertToStringArray(objvalues);

//Code to add data to the existing cells

Lijo Rajan20-Apr-07 3:04

20-Apr-07 3:04

Mr Arun I am extremily sorry to tell u that this code didnt help me.Now i have the code to convert excell file into html file as follows

using Excel = Microsoft.Office.Interop.Excel;

Microsoft.Office.Interop.Excel.Application excel = null;
Microsoft.Office.Interop.Excel.Workbook xls = null;
excel = new Microsoft.Office.Interop.Excel.Application();
object missing = Type.Missing;
object trueObject = true;
excel.Visible = false;
excel.DisplayAlerts = false;

xls = excel.Workbooks.Open(strFilePath, missing, trueObject, missing,

missing, missing, missing, missing, missing, missing, missing, missing,

missing, missing, missing);

object format = Microsoft.Office.Interop.Excel.XlFileFormat.xlHtml;

IEnumerator wsEnumerator =
excel.ActiveWorkbook.Worksheets.GetEnumerator();
int i = 1;
while (wsEnumerator.MoveNext())
{
Microsoft.Office.Interop.Excel.Worksheet wsCurrent = Convert.ToString(Microsoft.Office.Interop.Excel.Worksheet.ReferenceEquals);
String outputFile = strFilePath + "." + i.ToString() + ".html";
wsCurrent.SaveAs(outputFile, format, missing, missing, missing,
missing, missing, missing, missing, missing);

}
excel.Quit();

I have added the microsoft excel library through add reference. but it is showing error as follows

The type or namespace name 'IEnumerator' could not be found (are you missing a using directive or an assembly reference?)

so how can i rectify this problem?Which name space i have to include to getrid from this error.Plse help me?

Arun.Immanuel21-Apr-07 22:57

21-Apr-07 22:57

Please try to include this line and let me know if it works.

using System.Collections;

Regards,
Arun Kumar.A

Arun.Immanuel21-Apr-07 23:15

21-Apr-07 23:15

Yes,
the code U have supplied works fine.

I have made some slight changes and finally
I have converted xl to html.

Regards,
Arun Kumar.A

Lijo Rajan23-Apr-07 1:08

23-Apr-07 1:08

Thank You Verymuch Mr Arun.If u dont mind could u plse give me the code which u have changed?I mean The code i have given in which u have modified.
And plse mention the changes which u have done.

Arun.Immanuel23-Apr-07 1:39

23-Apr-07 1:39

Hi,

Here is the entire code:

using System;
using System.Collections ;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Office;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

Excel.Application excel = null; //In my system i am unable to refer the class Excel.Application like what U have.

Excel.Workbook xls = null;
excel = new Excel.Application();
object missing = Type.Missing;
object trueObject = true;
excel.Visible = false;
excel.DisplayAlerts = false;

xls = excel.Workbooks.Open("E:\\aOfficial\\MyFiles\\Output1.xls", missing, missing, missing,

missing,missing,missing,missing,missing,missing, missing,missing,

missing,missing,missing);

object format = Excel.XlFileFormat.xlHtml;

IEnumerator wsEnumerator=excel.ActiveWorkbook.Worksheets.GetEnumerator();
int i = 1;

while (wsEnumerator.MoveNext ())
{

Excel.Worksheet wsCurrent = (Excel.Worksheet )wsEnumerator.Current;//This is the only change
String outputFile = "d:\\a" + "." + i.ToString() + ".html";
wsCurrent.SaveAs(outputFile, format, missing, missing, missing,
missing, missing, missing, missing, missing);

}
excel.Quit ();

}
}

Regards,
Arun Kumar.A

Lijo Rajan23-Apr-07 4:08