Re: 1gb upload .mdb file - ASP.NET Discussion Boards

Getting a Sub node value with the help of another Sub node value in XML

chand1010-Aug-07 1:40

10-Aug-07 1:40

Hi
I am looking for a Condition clause in XML like "WHERE" in SQL.

If the XML file is like.....

<Details>
<Person>
<ID>100</ID>
<Name>Mr.X</Name>
</Person>
<Person>
<ID>101</ID>
<Name>Mr.Y</Name>
</Person>
.....
.....
</Root>

If I want the Name of a person with ID = 100

Fisrt of all how to Search for that ID in XML file, after that how can I get the Name for that ID.

I have not failed. I've just found 10,000 ways that won't work. -Thomas A. Edison

Thank u
Chandu

Re: Getting a Sub node value with the help of another Sub node value in XML

Vasudevan Deepak Kumar10-Aug-07 4:09

Vasudevan Deepak Kumar

10-Aug-07 4:09

Once you load this XML into a dataset, DataTable Select should help you out. Even a DataView RowFilter can be used right?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

how can i shift my data from HTML table to EXCEL using ASP

koolprasad200310-Aug-07 1:19

koolprasad2003

10-Aug-07 1:19

helllo frnd,

how can i shft my HTML table cotent to EXCEL with header and all

please help...

thankx in advance

regards,
koolprasad2003

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Re: how can i shift my data from HTML table to EXCEL using ASP

andyharman10-Aug-07 5:44

andyharman

10-Aug-07 5:44

The easiest way is to run the following code before outputing your current HTML:

<%
Call Response.Clear()
Session("REPORTCOUNT") = CLng(Session("REPORTCOUNT")) + 1
Call Response.AddHeader("Content-Disposition", _
      "attachment; filename=Report_" & Session("REPORTCOUNT") & ".xls")
Response.ContentType = "application/vnd.ms-excel"
%>

This basically tells your browser that it is opening an MS-Excel spreadsheet. MS-Excel is able to the HTML in spreadsheet format. You can even use simple CSS and the HTML table attributes (e.g. "bgcolor") to make things reeeeally pretty.

I use the REPORTCOUNT session variable to allow me to allocate unique filenames because Excel doesn't like having two spreadsheets open with the same name. The only niggle is that when you choose "File->Save As" from Excel menu, it initially assumes that you want to save an HTML-formatted file.

Other methods are to use ASP to write out in the XML Excel format introduced by Office 2003, or to use ADO to write to an Excel spreadsheet connection - then download the resulting file.

Regards
Andy

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".

upload .mdb file

rajmani10-Aug-07 1:18

rajmani

10-Aug-07 1:18

Hi all

How upload msaccess(.mdb) file using Asp.net.

It is possible,

thanks

Re: 1gb upload .mdb file

rajmani10-Aug-07 1:26

rajmani

10-Aug-07 1:26

How upload 1gb file upload using asp.net client side

thanks

Re: 1gb upload .mdb file

Kschuler10-Aug-07 3:35

Kschuler

10-Aug-07 3:35

If you want to upload files that are going to be of a rather large size, you will have to make a change to your web config file. You will need to specify a maxRequestLength equal to the largest size file you plan to allow. The default is 4096 which is 4 MB.

http://msdn2.microsoft.com/en-gb/library/e1f13641.aspx[^]

Good Luck.

Re: 1gb upload .mdb file

Kelly Herald11-Aug-07 6:20

Kelly Herald

11-Aug-07 6:20

The problem with using the basic file upload control is that the server side will need to allocate memory equal to the size of the file getting uploaded. Where I work we used to use the basic file upload control and whenever someone would upload a 600MB file IIS for ALL people would stop responding and the server showed the worker process using 600+ MB of memory.

For that size of file I highly recommend using the free NeatUpload[^] component. Not only will it give you a progress bar it also won't consume much memory because it takes chunks postback stream and saves it to a temp file and responds with a progress message. Also, during the upload the client can cancel the upload. I have successfully uploaded 1.7+ GB without any problems and the server memory usage went up by about 10MB which is very acceptable.

Kelly Herald
Software Developer

Re: upload .mdb file

N a v a n e e t h10-Aug-07 1:30

N a v a n e e t h

10-Aug-07 1:30

rajmani wrote:
How upload msaccess(.mdb) file using Asp.net.

Use FileUpload control. File type doesn't matter

My Website | Ask smart questions

Re: upload .mdb file

Vasudevan Deepak Kumar10-Aug-07 4:11

Vasudevan Deepak Kumar

10-Aug-07 4:11

The user has some added query info here:

http://www.codeproject.com/script/comments/forums.asp?msg=2176950&forumid=12076#xx2176950xx[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

On Enter move on next TextBox..?

fmlove10-Aug-07 1:05

fmlove

10-Aug-07 1:05

Hi!

i want..... when i enter on a textbox cursor move to next field

Re: On Enter move on next TextBox..?

koolprasad200310-Aug-07 1:23

koolprasad2003

10-Aug-07 1:23

hello frnd,

it can be achived by the Javascript/VbScript just use the "onKeyDown" event and check that

if event.keyCode = 13
{
document.getElementById("txtSecond").focus();
}

regards,
koolprasad2003 Smile | :)

If the message is useful for U then please Rate This message...

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Re: On Enter move on next TextBox..?

fmlove10-Aug-07 2:16

fmlove

10-Aug-07 2:16

Thanks for help

dear but can you tell me how can i get the next textbox name...

Re: On Enter move on next TextBox..?

Michael Sync10-Aug-07 6:50

Michael Sync

10-Aug-07 6:50

fmlove wrote:
dear but can you tell me how can i get the next textbox name..

You have your page or project with you. isn't it? Smile | :)

So, go and take a look... and decide which textbox you want the cursor to move when you press the "Enter" key.

OR Do you wanna detect automatically to the next control after current one?? It's hard to say since it is based on the design.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

Move on nextText Box ..?

fmlove10-Aug-07 0:39

fmlove

10-Aug-07 0:39

HI!

i have two Text Box (TextBox1,TextBox2) and the maxlength for TextBox1 is 3 and for TextBox2 is 7. now i want when maxlength of TextBox1 is end then cursor automatically move on next TextBox2....Please help....

Re: Move on nextText Box ..?

N a v a n e e t h10-Aug-07 1:17

N a v a n e e t h

10-Aug-07 1:17

Write a javascript function and call it in OnKeyDown event of the textbox. Inside this function check the length of the text, if it is your desired length change focus to next textbox.

My Website | Ask smart questions

treeview

Nidhiii10-Aug-07 0:35

Nidhiii

10-Aug-07 0:35

im giving treeview node colour using this code (shown below)
treenode.Text =
"<font color = #066C57 >" Addition "</font>";

bt at that time its tooltip is showing
"<font color = #066C57 >" Addition "</font>";
when im giving treenode.tooltip="something" it is nt working
pls give me a solution

Re: treeview

S A R I T H10-Aug-07 0:37

S A R I T H

10-Aug-07 0:37

first u rebuild ur solution
after reuild it comes same then try this
write de code in source(html)

<Nodes>

<asp:TreeNode Text="Table of Contents"
ToolTip="Table of Contents Description">
</node>

Sarith...

Re: treeview

koolprasad200310-Aug-07 1:26

koolprasad2003

10-Aug-07 1:26

Nidhiii wrote:
treenode.Text =
"" Addition "";

to give the color to treeview node use the style property of HTML view don't use the code behind

regards,
koolprasad2003 Smile | :)

If the message is useful for U then please Rate This message...

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Access to the path #### is denied

Sebastian T Xavier10-Aug-07 0:15

Sebastian T Xavier

10-Aug-07 0:15

Hi,

When i try to attach and send a file , i got the error..
The report of BOM can't be send as an email due to error:-Access to the path
'c:\inetpub\wwwroot\xxx\PDF\admin\Report.pdf' is denied

.Please tell me how to solve this.........

With thanks

Sebastian

Re: Access to the path #### is denied

Blue_Boy10-Aug-07 0:50

Blue_Boy

10-Aug-07 0:50

right click on folder wwwwroot and uncheck Read only checkbox

I Love SQL

Re: Access to the path #### is denied

Sebastian T Xavier10-Aug-07 1:20

Sebastian T Xavier

10-Aug-07 1:20

HI,
Thanks for your reply. but still it shows the same error. now in another section , inside a javascript function..

thanks once again

sebastian

Re: Access to the path #### is denied

Blue_Boy10-Aug-07 2:21

Blue_Boy

10-Aug-07 2:21

check javascript code which you used, or post here javascript code maybe we can find solution

I Love SQL

Re: Access to the path #### is denied

R. Giskard Reventlov10-Aug-07 3:10

R. Giskard Reventlov

10-Aug-07 3:10

First thing is to check if you have set up permissioning correctly on the folder. In other words, your process has no rights to the folder in which the pdf is stored. Right click on the folder and select "Security". You need to select and grant permissions to your applications user.

home
tastier than delicious

textbox problem

Kissy1610-Aug-07 0:10

Kissy16

10-Aug-07 0:10

Hai to all,
1)Is it possible to assign a property like ,the textbox should accept either blank or telephone number like 011-342344 .
2)i know with regular expression validator or required field validator,we can give ..it shd not take blank or wrong format.
but how to do as i wrote in the first point.plz anybody can give me an idea.which property of textbox shd i need to set???if not possible wat shd i do???
thanks in advance

kissy

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