ADO.NET :: Attempting To Create A Data Driven Website?
Dec 26, 2010
First, I am new to VWD 2010 and attempting to create a data driven website.
I am attempting to return a value from an sql server stored procedure and store that value in a variable. I have searched here and online and tried to follow the examples that I found. However, I have not been successful in making it work.
Here is my stored procedure:
[Code]....
Here is my VB code behind where I am attempting to get the return value:
[Code]....
I know that I have a good connection because I am using the same connection string from my WebConfig file and it is working in other instances.
Below is the error message that is being displayed.
'The formal parameter "@monRegAmt" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output."
View 11 Replies
Similar Messages:
Feb 23, 2011
I am looking for an open source Thermometer that i can connect to a JSON or XML datasource and display this on my website.
The site is an asp.net site so javascript controls are not a problem. My Googling didn't reveal very much at all.
View 1 Replies
Nov 22, 2010
I'm used to developing private applications for very small amount of concurrent users (usually no more than 10) on very good servers, so I have never been pressed about stress testing my applications. That being said, this is something I want to have a better grasp on my applications.
FYI, all of my websites are based on ASP.NET 3.5 (WebForms), NHibernate (specially interested in testing it with numerous concurrent sessions) as the ORM of choice and require Active Directory authentication.
View 2 Replies
Feb 24, 2010
How to Access 2007 data driven website SELECT Article, ArticleContent, Category
View 3 Replies
Mar 26, 2010
I have a website using .Net framework 2 on a dedicated server who's display periodically corrupts - typically after heavy traffic numbers to the server. I can correct the problem simply by uploading a batch of user-controls to the server, or recycling the memory pool.
Has anyone else seen this type of effect before, where the display of data-driven elements of a website corrupt?
Corrupt image first.
View 5 Replies
Dec 1, 2010
I am in the process of putting a new site together which will make use of AJAX to pull through page content should the user have javascript enabled.
So, I am in the situation whereby every Action Method requires a check to see if the request was through AJAX or not, which is straightforward. If the request was through AJAX then I can return a partialview, if not then a full view can be returned.
With this pattern though, I'll need to create a View and a PartialView for every page on the site. The only real difference between them is going to the inclusion of the masterpage.
Am I missing a trick here is is this doubling up of views the only way to go?
I had a page that could get accessed through /site/test. Somewhere in my JS I would add a hash to the url like so #/site/test. JS would then watch for any hash changes and load the partial views as needed. If JS was not available though, an entire view would need to be returned.
So for each page I would need the view, which would then include a call to RenderPartial which would load up the partial view which would actually contain the page content. So, for every page there are two files. It just seems there should be a cleaner way of doing this.
View 1 Replies
Mar 3, 2011
On my local machine I have created a database driven website. All is working well on my local machine.
Now I want to upload it to my Arvixe Hosting. How do I do that from Visual Studio 2010 Keeping in mind I have a Database too ?
Do I need to manually create a Database on the Server ? Do I then create all the tables Manually ? Do I then populate the tables manually ? Or is it a 1 button click ?
View 10 Replies
Aug 29, 2010
To learn ASP.NET MVC, I am thinking of creating a community forum like SO where people can rate posts, users etc. and the user can thereby gain points. I just can't figure out if the points should be added to the user profile whenever an action is done (post rated up/down, user created new post etc.) or if it should be calculated from the different activities the user has done.
I have a few pro's and con's for both ways of doing it:
[code]....
View 3 Replies
Dec 25, 2010
I create a database driven menu, in specific condition i want to open link in new tab... i use following code but not working....
Menu1.Target = "_blank"; (target is not working in menu control)Any other solution for this....
View 3 Replies
Mar 28, 2011
I have been asked to take over and modify an existing dynamic web site made with vb and asp 3.5 on a shared hosting enviroment. The original programmer left and I have no access to the original documentation of the site, if any. Nevertheless, I have complete access to the web server and database server.
How can I import the existing wen site into Visual Studio and recreate the development enviroment.
I'm new to asp.net, but U have prior experience with VB and asp web development.
View 3 Replies
Dec 14, 2010
I am attempting to bind data from a dropdown list that was populated from another datasourceID. I've bolded what I believe is relevant to this issue in the code below. But basicly its binding the proper county on the pull down menu but when I hit form submit it dosnt postback that info instead its null.
[code]....
View 14 Replies
Mar 16, 2010
I am attempting to add a drop down menu to a gridview once the user slects the "Edit" button for the gridview. I want the value, before the edit button is selected, to be the value in one table and once the "Edit" button is selected I want to show values from another table in a drop down menu so the user only has specific values to edit the selected row with.
2 tables:
table 1) tbl_FormalizeRawData - List of columns from a table inside a database
table 2) tbl_StandardColumns - list of standard column names for system tables.
I want the user to be able to specify which raw non standard columns corospond to the standardized system table columns.
example:
RawClientTable.MiscColumn1 = SystemTable.Member_First_Name
RawClientTable.MiscColumn2 = SystemTable.Member_Last_Name
my code for the gridview is as follows. I am looking to see what else I need to do in order to allow the gridview to be edited on the final column by a dropdown menu populated by a seperate table but display the item in the main table with all the non standard column names:
[Code]....
a boot in the rright direction. I attempted to go through the "Walkthrough: Displaying a Drop-Down List While Editing in the GridView Web Server Control" at the website[URL] as it was geared toward a drop down menu added to a gridview both using the same table.
View 1 Replies
Nov 25, 2010
Sample web application code where content(like forms) is generated based on user role like admin,priority1 user,priority2 user.
View 1 Replies
May 24, 2010
So, after all and after all these projects that have been done. What is the best way and I should consider as standard in the furute to start any further ASP.NET Projects that are database driven.
I have done many using
1. Store procedures and classes
2. One class to handle all the add,delete,update ...etc functions
3. ADO.NET
4. Using sql statements directly on the code (I know not recommended, it was my first project) :))
..and so on
What method you recommend in the future that will save me code and errors and optimize my application speed as well.
View 2 Replies
Mar 25, 2010
I have a page with 6 large GridViews on it, and I'd like to add tooltips to the headers on each of the GridViews. Now I know how to add the tooltips, I'm planning to simply use a variation of the code at the bottom, but I'm wondering the best way to go about loading the data for the tooltips.
What I have is a table with descriptions of each of the columns, and I want to use those descriptions as the tooltips, but I need to do it in as light an implementation as possible, so hopefully I'm not going to the database too much, certianly I don't want to have to make a trip to the database for each cell, I'd like to load all of the data only once for each page load.
[Code]....
View 11 Replies
Feb 2, 2010
Im trying to incorporate the ajax controll toolkit slider control within an ascx control so that i can then use that within a repeater on an aspx page. Basically i want to have a number of slider controls rendered to a page with default values based on data from a database. i need to put the slider within a data bound repeater as i wont know until runtime how many sliders i will need (maybe there is a better way?). does anyone know of ay examples of how to do this?
The user will then need to be able to move the slider to the value they are after and on the mouse up event ie when they release the slder I will want to be able to update my database with the value they set it to. This bit i think i am ok with but i cant seem to work out how to build a page where by i can render lots of slider controls wth default valuesset from a database.
View 1 Replies
Jan 17, 2010
I didn't really know where and how to put this so here we go:
I'm trying to design a map with co-ordinates that's driven from data in a database. I want it to look something like this:
Also, the selected X/Y co-ordinate must be centered for the user to see. How could I produce something like this?
View 5 Replies
Jul 28, 2010
the best practice for a designing a simple CRUD application with some screens updating various tables (like admin pages to maintain static data for an application). the simplest way would be to drag a data grid/gridview, bind it to a dataset and use a data adapter for CRUD operations. but if this application needs to be scalable, lets say to add any extra UI/business logic in future, then is there any design pattern that can with this? should I be using an object data source control and bind it to business objects instead? or are there any better ways of doing it? should I build a complete layered application or will that be overengineering for this requirement?
View 3 Replies
Jul 2, 2010
I have a data driven site that displays a lot of information, particularly images, using listviews contained within UpdatePanels, since this data can change with each post back you often see 'submit query' before the Item image appears. So, is there a way of making the page display only after it has finished loading data? The delay as the page loads is only brief but looks quite ugly when 'Submit query' appears all over the site.
View 2 Replies
Aug 12, 2010
Did anybody do Database Driven - Horizontal and Vertical Nav without using XML?is it possible to bind menu control with query or view and pass query string to find particular horizontal nav and vertical nav?Please post working solution, i was trying for days to find a working solution. All the samples i tried is not working or it is too complex.i love to write and manage simple code.
View 1 Replies
Dec 9, 2010
I'm currently creating a web application.
I had Administrator, Teachers, Students roles.
I wanting to create a function where Administrator able to change username of the users that login to my web application or delete that user.
The users are created from asp.net web site administrator tools (security tab)..
View 4 Replies
Jan 20, 2011
I have a asp.net website in the IIS which is available on internet as www.xyz.com now I have been asked to prepare another website which will be accessed via www.xyz.com/abc.
For this, do I need to create a virtual directory under the website folder XYZ in IIS? or is there any other way to achieve this.
View 2 Replies
Jan 12, 2011
want to develop a comment box and chat for my new project.
would love to use some jquery ajax where-ever possble.
want to store commentbox data nto database and retrieve to display them.
no idea about chat whether it should be file or database.
View 3 Replies
Jan 21, 2010
I am creating a web site through command line. I am able to create a web site with single host address. But i want multiple host address for a website. this is the command I am using iisweb /create D:Test Test.com /d [URL]
View 6 Replies
Dec 13, 2010
I'm pretty new in the world of ASP.Net, but not on developing in general. I created a webservice which read data from a SQl-database. This works fine. Now I want to create a customer website which uses the webservice to read those data. I need to do this periodically, say every 10 seconds.
The profiler on the database and debugging the website tells me that the values are read good, even is they are changed in de database. But, I need to display those values on a label, but this won't work, only with a meta-refresh every 10 seconds.Is there a way to use a timer and refreshes labels ?
View 4 Replies
