|
|
David,
What I want is the code to retrieve that specific table in either excel format or in txt format on to my local computer. Can you assist with that code please??????
|
|
|
|
|
At this time, I have no time to work on such a project. I'm busy at work and home. I find this project interesting, so I may work on it for my own knowledge, but I can't guarantee any timeframe for completion.
|
|
|
|
|
Thanks you...
i will eagerly wait for your post....
|
|
|
|
|
Hi All,
I am having one ASP.NET application in which I m trying to write multiple files in folder (C:\Inetpub\wwwroot\Test\MyData\reports). I am failed to write files in folder if I omit the write permission to Everyone.
I do not want to give Everyone permission due to security reasons. I am using windows XP and IIS 5.1 but my client can use different os such as Windows 2000, 20003 etc and different IIS 5.x or 6.0. So I need a solution which will work on all the platforms.
I tried to find out the correct way for achieving this but found no correct solution. Tried following things:
1. I have given Full permission to 'reports' folder for ASPNET account using security tab, but it didnt work.Same thing I tried with IIS_WPG but it is also not working.
2. I have read about impersonation but I think it is not suitable for my requirement as I do not want to give permission for a specific user and also I can not instruct the client to change user name and password in web.config.
3. One thing which worked in my case is when I given write permission to 'Users(<machinename>\Users)' group using security tab. I dont know how it worked or is it the correct solution and if yes, then will it wiork for different OS and IIS.
Thanks in advance for any help.
Regards,
NN
|
|
|
|
|
|
I would guess that you're getting newlines in your text, but you need to replace them with break tags if you want to render the text onto your page.
.Replace(Environment.NewLine, "<br/>"); on the string before you render it. Or before you store it.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
HI Christian Graus
Thanks for reply
|
|
|
|
|
i hav a dropdown which is binded to a table
here
i will select the text from dropdown and press a button
to save details in db
here while saving or inserting a record
i am not getting any values in dropdown which i hav selected
pls reply
tanx
|
|
|
|
|
you have to insure the drop down property AutoPost back is true
|
|
|
|
|
Rubbish. If he's got a button set to do the postback, that will work just fine, and if he has a problem, AutoPostback won't fix it.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
well changing the selected item in the dropdownlist and causing a postback on that event might be the solution i guess
|
|
|
|
|
Not a chance in hell. If it gets lost, it will still get lost on an autopostback
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
Odds are good that you're binding to your data source every time. This will clear the selection. So, bind your drop down to your data source in an if (!IsPostback) block.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
anbusenthil wrote: here while saving or inserting a record
i am not getting any values in dropdown which i hav selected
I Guess, this is due to postback while storing and loading data from database. Unless you post the relevant code its difficult to say.
|
|
|
|
|
Hai Friends
I have declared a variable outside all the function in an aspx.cs page, like
public partial class StaticVar : System.Web.UI.Page
{
static int a;
protected void Page_Load(object sender, EventArgs e)
{
Response.Write(a.ToString());
}
protected void Button1_Click(object sender, EventArgs e)
{
a = 50;
Response.Write("set 50, a= " + a.ToString());
}
protected void Button2_Click(object sender, EventArgs e)
{
a = 60;
Response.Write("set 60, a= " + a.ToString());
}
protected void Button3_Click(object sender, EventArgs e)
{
Response.Write("a= " + a.ToString());
}
}
The problem is that when more than one user access this page and modifies the variable a, all the users gets the new value for a,
i.e., they loose the value what they had set for a. They get the value that is been set by the last user.
If I remove 'Static' from its declaration, then its value is not available to other functions.
How to solve this problem.
Please help me.
Shivanandan C V
|
|
|
|
|
Buy a basic book on ASP.NET and read it. Actually, I suspect your issue is that you don't understand ASP.NET. Static works just as you are seeing, and non static only exists for the lifecycle of one page. Therefore, you need to store values in something persistent, such as the session, or if it's all in one page, viewstate.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
There is no need to declare it static if you are declaring it as class level variable. As a class level variable, it's value should be accessible in all methods inside that class.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
But not between postbacks.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
If I don't declare it as Static, then its value is retained only in the function in which it is assigned. In other function its value becomes 0. Please check my code without Static identifier.
Shivanandan C V
|
|
|
|
|
Shivan Nandan wrote: If I don't declare it as Static, then its value is retained only in the function in which it is assigned. In other function its value becomes 0. Please check my code without Static identifier.
The issue is that without the static the variable is only available for that one instance of the page. Every time you visit the page you get a new instance of the page so the variable is set back to what it started as.
Your mental model is that when a user gets a page they retain that page object for the duration of their session. They don't. That would place an huge strain on the server to maintain all that for all users.
A page will be destroyed soon after it is rendered - along with all variables on it.
Man who stand on hill with mouth open wait long time for roast duck to drop in
|
|
|
|
|
Use Session variable.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
Shivan Nandan wrote: The problem is that when more than one user access this page and modifies the variable a, all the users gets the new value for a,
i.e., they loose the value what they had set for a. They get the value that is been set by the last user.
That is the correct functionality. ASP.NET applications are multi-user applications. static variables are global for the entire application. If you set it to some value then all users will see that value.
Shivan Nandan wrote: If I remove 'Static' from its declaration, then its value is not available to other functions.
Incorrect. Its value is available to the methods in the class. This time however, the value only lasts as long as the object it is in lasts (in this case the object is the one representing your page).
Shivan Nandan wrote: How to solve this problem.
Looking at your sample code, you expect the value to hang around for postbacks. That isn't going to happen. The page object (along with your variable) will exist for as long as it takes to process and render the page. The page object is them discarded (along with your variable).
So, basically, you need some mechanism to store the value between postbacks. You can store the value in the page itself (a hidden field, or add it to the viewstate). You could store it in the session. You could create your own mechanism. It is up to you.
Ultimately, you need ot read a book on how ASP.NET works, and especially how the page lifecycle works as this leaky abstraction trips up many people. In other words HTTP is stateless, but ASP.NET tries to provide a stateful framework, and sometimes it just doesn't work they way you'd expect. So you have to go and read some stuff about the page lifecycle to understand what is going on.
Man who stand on hill with mouth open wait long time for roast duck to drop in
|
|
|
|
|
Thank you very much for helping me...
Shivanandan C V
modified on Wednesday, June 10, 2009 4:17 AM
|
|
|
|
|
I am handling one project in asp.net.Now I want to update my sql database when anyone leave the domain. So I need to call a stored Procedure when user leave page. And I can do it very easily if user click on logout button. But the problem arises when anyone just close the browser (by clicking cross button) or when he navigate away to another page (typing another address in address bar). Some ppl said that this can be done with Ajax script. Anyone please provide some coding for this?
Regards,
Shimona
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
