ASP.NET

soneliso19-Jul-07 21:42

soneliso

19-Jul-07 21:42

Sorry for that i'm using VB

here is my code

Dim ExcelObj As Excel.Application
Dim workbook As Excel.Workbook

ExcelObj = New Excel.Application
workbook = ExcelObj.Workbooks.Open(strFullFileName, 0, True, 5, "", "", True, Excel.XlPlatform.xlWindows, ",", False, False, 0, True)

'workbook = ExcelObj.Workbooks.Open(strFullFileName)
workbook.Application.Visible = True
workbook.Close()
workbook = Nothing

ExcelObj.Quit()
ExcelObj = Nothing

Sathesh Sakthivel19-Jul-07 22:15

Sathesh Sakthivel

19-Jul-07 22:15

Try with the Code as Sandeep Said.

SSK.

Sandeep Kumar19-Jul-07 21:47

Sandeep Kumar

19-Jul-07 21:47

Hi,

First add reference of Excel and try to open the document.

Example:

<code>Excel.ApplicationClass _appClass = new ApplicationClass();
Excel.Workbook _workbook = null;
Excel.Worksheet _worksheet = null;

try
{
_workbook = _appClass.Workbooks.Open(
excelSheetNamePath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);

_worksheet = (Excel.Worksheet)_workbook.Worksheets[1];</code>

Regards,
Sandeep Kumar.V

need pair of values to hold in a dropdownlist

soneliso20-Jul-07 0:28

soneliso

20-Jul-07 0:28

I have tried that but it didn't work. I have tried a different way...
I pass a variable to HTML Hidden tag
FileName.Value = "C:\MyExcel.csv"

Then here is A tag
GetFile

This work like fine, but it display the excel file on a html page.

Here is what i'm doing.

I have an aspx page with a button and ExportToExcel icon. When clicking on the button is should create a table using a DataTable which is returned from Database Class and create and save a csv file to C:\. On click on Export to Excel icon, it should open the saved file.

Is there an easier way to do this.

choorakkuttyil19-Jul-07 21:14

choorakkuttyil

19-Jul-07 21:14

hello,
i am struggling to hold a pair of values in a dropdownlist
i.e CountryID and CountryName i want to take CountryID when selectedIndexChanged Event raises...
I had done the same thing in desktop app. by overriding .Value() and .ToString Method..

I dont want to write Multiple queries at every time because it is an overhead in web apps.

anyone who can help me out please.....
i am expecting advice, code snippet or files...so that i can go ahead...
Confused | :confused:

nobz

Re: need pair of values to hold in a dropdownlist

Sathesh Sakthivel19-Jul-07 21:40

Sathesh Sakthivel

19-Jul-07 21:40

Pls be clear in your question.

SSK.

Re: need pair of values to hold in a dropdownlist

choorakkuttyil19-Jul-07 22:02

choorakkuttyil

19-Jul-07 22:02

let me explain...........

public object Value;
public object Value1;
public string Description;
public ValueDescriptionPair(object NewValue, string NewDescription)
{
Value = NewValue;
Description = NewDescription;
}
public ValueDescriptionPair(object NewValue, object newvalue1, string NewDescription)
{
Value = NewValue;
Value1 = newvalue1;
Description = NewDescription;
}
public override string ToString()
{
return Description;
}
----------------------------------------------------------------------
i created one value pair like this......
for that i will get a set of values which overides .Value method
----------------------------------------------------------------------
ddlCountryService.Items.Add(Convert.ToString(new NRIValueDescriptionPair.ValueDescriptionPair(dtr[0],dtr["fld_CountryId"], Convert.ToString(dtr["fld_CountryName"]))));
-----------------------------------------------------------------------
Here i could able to set the values also......
-----------------------------------------------------------------------
obj.CountryId= Convert.ToString(ddlCountryService.SelectedItem.Value);
--------------------------------------------------------------------------
but....
i couldnt able to get the value by .Value method...
it is not overriding... i did this nicely in windows apps.....dont know y its not happenning in web apps
----------------------------------------------------------------------------

hope it will be clear for you now.....
help me.... Sniff | :^)

Javascript function in a web usercontrol

anujose19-Jul-07 20:54

anujose

19-Jul-07 20:54

i am creating a usercontrol that contains 2 textboxes and a button.textboxes are web controls .i want to check when i click in button whether textboxes contains value or not? is it possible to write a javascript function inside a usercontrol?
i tried
if(document.getElementById('Name').value=="")
{
alert("Name can't be empty");
}
but it's not working?
with regards,
Anu

Re: Javascript function in a web usercontrol

N a v a n e e t h19-Jul-07 21:01

N a v a n e e t h

19-Jul-07 21:01

anujose wrote:
if(document.getElementById('Name').value=="")

You will get error on this line, if control Name is a server control. This happens because ASP.NET appends user control name with the server side controls to make control id unique. So you need to view source of the page and find out how your control is rendered. Usually it will be like usercontrolname_controlname. Find this name and use that in javascript.

My Website | Ask smart questions

Re: Javascript function in a web usercontrol

Vasudevan Deepak Kumar19-Jul-07 21:10

Vasudevan Deepak Kumar

19-Jul-07 21:10

anujose wrote:
'Name'

'<%=Name.ClientID%>'

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: Javascript function in a web usercontrol

anujose19-Jul-07 21:32

anujose

19-Jul-07 21:32

can you just explain?

string.replace

Sebastian T Xavier19-Jul-07 20:33

19-Jul-07 20:33

Hi all,
I need your help in replace function.........
Please look the code below.....

<br />
string File;<br />
File = "C:\\Documents and Settings\\sxavier\\Desktop\\prasobh.doc";<br />
string strFileName = File;<br />

I would like to replace \\ with \... I have tried the line below , but will not work....
strFileName = strFileName.Replace("\\", "\");

Please guide me ....

Thanks in advance

Sebastian

N a v a n e e t h19-Jul-07 20:39

N a v a n e e t h

19-Jul-07 20:39

Sebastian T Xavier wrote:
strFileName = strFileName.Replace("\\", "\");

strFileName = strFileName.Replace("\\", @"\");

My Website | Ask smart questions

Sebastian T Xavier19-Jul-07 22:38

19-Jul-07 22:38

Thank you Navneet,it worked

sebastian

Vasudevan Deepak Kumar19-Jul-07 20:43

Vasudevan Deepak Kumar

19-Jul-07 20:43

Sebastian T Xavier wrote:
strFileName = strFileName.Replace("\\", "\");

It breaks "Build" with the error "Newline in constant".

Sebastian T Xavier wrote:
strFileName = strFileName.Replace("\\", "\");

~~strFileName = strFileName.Replace("\\", "\");~~
strFileName = strFileName.Replace(@"\\", @"\");

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Sebastian T Xavier19-Jul-07 22:39

19-Jul-07 22:39

Thank you...........

sebastian

sathesh pandian19-Jul-07 20:45

sathesh pandian

19-Jul-07 20:45

hi,

try to use / instead of \ otherwise use @"\".

\ is a new line character in C# and your code will work only in vb.net.

So it is better to avoid it.

All The Best

Sathesh Pandian

Sebastian T Xavier19-Jul-07 22:40

19-Jul-07 22:40

Thank you.............

sebastian

Imran Khan Pathan19-Jul-07 20:49

Imran Khan Pathan

19-Jul-07 20:49

try with this

Replace("\\", @"\");

Best Regard

Pathan

GOD HELP THOSE WHO HELP THEMSELVES

Sebastian T Xavier19-Jul-07 22:41