|
I would like to find alternatives for updating a database every time the user clicks a 'next' or 'submit' button on a C# 2010 web form application
Right now I have added two new web pages to an existing C# 2010 web form application. Currently when the user enters information on the first page and hits the next button, the 'main' table and the 'sub' tables have rows inserted into the database. When the user is on the second web page, they can update additional information on the 'main' table only.
Also on the second web page the user can click a 'previous' button and return to the first page. The user can correct fields that were incorrect on the first page. They hit the submit button and those columns are updated on the main table and the user is directed to the second web page. When the user hits the 'submit' button on the second page the database is updated again.
Thus I would like to find a way to pass information between the first web page and second web page and not update the database. I only want to update the database when the user clicks the 'submit' button on the second page.
Can you tell me and/or point me to a reference on how to accomplish this task?
|
|
|
|
|
One way would be to add the form values to the session so it is available on both pages and only update the database when the user presses a save button. You could also, for instance, create a class to hold all of the form values as properties and add the class to the session rather than a bunch of individual form values.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Thanks for your answer so far! I have the addtitional question to ask:
I will need to pass information that would update two different tables. One table contains about 50 columns that would update one row in the table called 'main'. The second table called 'sub' only has 4 columns in each row. However the second table is joined to the fist table and can have from 1 to 400 rows that ties to the 'main' table.
Could I pass the information between the passes using a dataset that contains two data tables? The form values you suggested to does not suggest this as an option. Is that a possibility?
Thus I am wondering what option would be the best for my situation?
|
|
|
|
|
Maybe you could implement a staging table where you would write entries as the user navigates between the pages and only when the proper "submit" button is clicked would you process those records from staging to production.
just a thought.
|
|
|
|
|
What do you mean by a staging table? Would this be a real table that I write write directly on the sql server database? I mean it would be a table that I create while the application is running and delete the table when the application is finish running? The table would be on sql server and not in a data table?
|
|
|
|
|
Yes, this would be a real, server-side table (maybe more than one).
My idea is that when the user goes into "edit" mode, you would:
1) Generate a transaction ID which would be valid for the lifetime of the edit session
2) copy the necessary data from your primary tables to this staging area along with the Transaction ID for each record.
3) As the user navigates between the pages all edits are saved to this staging area
4) when the final "save" button is clicked all of the staging data associated with the Transaction ID would be applied to the primary tables and the staging data is deleted.
You will have to deal with abandoned transactions when the user just closes his browser and that staging data is neither applied or deleted. If your applicaiton has a logout page, then you could delete all staging data when the user logs out.
just a thought.
Vote if you find this helpful.
|
|
|
|
|
Hello all
I wish your opinion about the above differences in performance between VB.net application that uses the web services through Web Reference and made a web application in ASP, Javascript or PHP.
I am developing an application using just the web services via webservice. I have an IIS server with a database that my application connects to. I'm following this path since I'm a pretty old designer. I have much more familiar with procedures and forms rather than HTML, Javascript and other gadgets and the spare time between work and family that I would remain for the study of such environments and possible coding is very little beyond the fact that progress would be much slower.
That said, a desktop application like this, what limitations should be meeting?
The big advantage is that I write in one language, I do not have to worry about HTML, CSS and similar mischief, but what do I'm going to lose?
My biggest fear is to be penalized in terms of performance, perhaps with restrictions on access to the db, because basically this is the only service that my server provides, but much more I'm worrying to realize after much time and work that I had gotten into a blind alley
Thanks a lot for your kind replies
|
|
|
|
|
ilgrongo wrote: VB.net application that uses the web services through Web Reference and made a web application in ASP, Javascript or PHP.
IN theory, it would run faster, because it's not running in a browser. Doesn't matter if its vb or c-sharp, in terms of speed or functionality, its all the same. It produces the same result in the same amount of time. A web service is a web service, regardless of it being php, asp or asp.net. It's suppose to be homo-genius, and transparent regardless of who made the request.
ilgrongo wrote: desktop application like this,
Are your talking about a windows program written in vb?, that talks to a web server running asp.net?
ilgrongo wrote: I do not have to worry about HTML, CSS and similar mischief,
If it's a windows program, then none of that applies anyways.
I'm confused here, I think you have 1 way to do it in mind, and your trying to solidify your decision, in which I don't see an alternative. If you have to get data from a remote server, then you either tunnel to the server using ssl, or make a request to a web service.
|
|
|
|
|
Thanks for your kind reply.
You hit the point...
I'm writing vb.net application acting as a web client. It's a fasted choise for me at this stage. In that way, using a single language I'm handling almost everything. I'm also reusing many classes I made in previous projects. The asp programming on server side is mininum. The server part actually consists in some asmx files deploying several classes and methods which take care of db queries and some . Also in the future I don't think that server part will implements much more functionalities. Check on data validity is performed on client side.
Maybe it's true that my preferred choise would be VB.NET application but I'm not excluding any other road. I'm looking for some good reasons that drive me to consider something different and invest my time elsewhere. That's the spirit of my post. Listen voices with much more experience than my, it could help me to think in different way, because now I'm worried about speed only, maybe I'd be worried about something else that I'm ignoring.
Hope to be clear,please tolerate my English
Thanks
modified 14-Jun-12 9:10am.
|
|
|
|
|
I have nothing spiritual to offer at this moment in time.
I've been writing in vb since 1995, when my friend at microsoft gave me a retail copy from their campus store.
In hind site, there was a time were I said I should write in c-sharp, and never got around to it. But the joke is that I write Javascript, ActionScript 3, Jquery, PHP, and took up c++, and I still write in vb, because I can spit it out so fast.
I only have 1 program in vb, that I just rewrote in c++ win32. The learning curve was very difficult, but after 6 months, I got pretty good at it. I'll never write another windows program in vb again.
[edit]
Life is short, take the least path of least resistance, and enjoy your free time.
|
|
|
|
|
Hi,
I'm on a project which is near completion. I have this page, a student page that shows daily attendance reports and allows the student to search based on some criteria. When the search button (The LinkButton) is clicked it redirects to the default page instead. This is not acceptable. I'm sure of my code and I know nothing is wrong with it. But for some reason the event is not firing and it redirects me to the default page instead. I've also tried to debug the code by doing a step through. Unfortunately that one did not work either. That was where I knew that the code for the linkbutton is not being fired. Please does anybody have a clue as to what the problem might be because, it's actually driving me nuts. Many thanks in advance.
|
|
|
|
|
kaycey90 wrote: I'm sure of my code and I know nothing is wrong with it.
Are you really really sure about that?
kaycey90 wrote: When the search button (The LinkButton) is clicked it redirects to the default page instead.
Well something fired, and called an event handler, or else it would of stayed on the same page.
Maybe you should put a
response.write("<span style=:color:black;">I fired</span>")
in the event function to see if it fired.
After that, hard code your response.redirect link, to see if the page changes
response.redirect("~/somepage.aspx")
It's always the code
|
|
|
|
|
how can set master page form and content page contain place holder in asp.net bez i execute my web application in IE but size set are different from i set size
|
|
|
|
|
|
dipen mistry wrote: in IE
You have to set the width in css style width: 100%. If you use a asp object like panel and set the width property to 100%, it will pick up as 100px.
Other than that, I have no clue why it's not the size you expect.
|
|
|
|
|
i try for create web setup(open-file-new-project-other project type-setup and deployment and select web setup project ) but i select project output from right click web application folder and select project output but not get any information in combo box of project so, plz guide me for create web setup in vs2008 step by step and indicate my problem
|
|
|
|
|
|
Hi all!
I am developing a web-based application mainly using the .NET stack, (ASP.net with C# in the code-behind, the AJAX toolkit...). What I need now is to provide some basic image edition functionalities. These are, to allow for basic zone definition directly over the image, and secondly to provide basic drag-and-drop (allowing to drag a previously defined item to a specific defined section on the image) capability.
¿Is there any valid solution based on the .Net/AJAX stack? ¿Any Javascript-based solution? ¿Must I use some RIA solution as Silverlight or Flash? ¿Must I explore HTML5 for a solution?
Thanks for your time.
|
|
|
|
|
I think html 5 supports drag and drop, and browsers that support html 5.
We were going to use uploadify with drag and drop, and found that only the html 5 version supported it.
You should do some research and double check your requirements
|
|
|
|
|
|
Thanks for your help to both!
|
|
|
|
|
i have published a website in VS 2010 and added it in ISS 5.1 using virtual directory now when i try to run it i get an error saying...
Failed to access IIS metabase
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.
i tried changing the permissions but still get the same error
can someone pls help me out on this...
|
|
|
|
|
Please do not repost what is essentially the same query. If you have additional information then edit the original question and add it there.
|
|
|
|
|
In 5.1, the metabase stores the website parameters.
So you ran the setup you made, and the setup did not complete all the parameters, leaving you with a broken website.
So go back to the website installer you made and fix the code. And test it running in debug, or at least look at 5.1 IIS management, to see what your missing. Write down what your missing on a piece of paper, and make the adjustments to your installation program.
Use the process of elimination, until you narrow it down, and it works.
|
|
|
|
|
this question has been asked so many time and i have gone through almost all of those answers, but i still get the page not found error when i try to browse my published website...
this is what i have done
i have created a new website in VS 2010 then published and using ISS 5.1 i have created a virtual Directory for it, even after all this my pages have not been able to work...
am i missing something basic here, pls help me out...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
