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:
Here is my VB code behind where I am attempting to get the return value:
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."
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.
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?
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.
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:
i want to know how to connect asp.net with access 2007. i need to add, update and delete data in a data grid. can you please help me out? im new and i need full instructions to do it. its really urgent
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.
I have a web page with links to various files including an Access 2003 .mdb and an Access 2007 .accdb. Both are about 1 mb in size. Both are in the same directory. The hyperlink for both is coded the same except for the database name. Users are instructed to right click on the links and choose "Save Target As..." to download the application to their computer. Currently, users and myself can download the .mdb trouble free. The .accdb will not. The error message states that the site cannot be found or is unavailable. This happens with any .accdb I put in the directory.
1) I have an ASP.NET website which is the main entry point in the application.This website uses Forms authentication, which validates credentials (username/password) against a database. 2) Once logged on the website, the user is displayed a page containing several links which point to a Sharepoint 2007 application, where authentication is managed by an Active Directory. 3) Every user in the Active Directory is duplicated in the database managing the ASP.NET website authentication.
I am using the below code to Export DataTable to Word,Excel,CSV format & it's working fine. But problem is that this code export to MS Word 2003,Excel 2003 & CSV version. I need to Export my DataTable to MS Word 2007,Excel 2007 & CSV because I am supposed to handle more than 100,000 records at a time and as we know Excel 2003 supports for only 65,000 records.
how to export DataTable or DataSet to MS Word 2007,Excel 2007 & CSV.
I am using the below code to Export DataTable to MS Word,Excel,CSV format & it's working fine. But problem is that this code export to MS Word 2003,Excel 2003 version. I need to Export my DataTable to Word 2007,Excel 2007,CSV because I am supposed to handle more than 100,000 records at a time and as we know Excel 2003 supports for only 65,000 records.
how to export DataTable or DataSet to MS Word 2007,Excel 2007.
I have a issue where I am trying to pull some records from an Access 2007 DB that has linked tables from a SQL 2005 Server. When I go to do this the browser IE8 just sits there and does nothing. THe little progress bar at the bottom moves about half way then that is it. It will sit there and show no errors or do anything. I have experience with connecting and manipulating Access and SQL server DB's but not through Access with linked tables from SQL Server. Here is test code below:
This does not produce an error or anything. The browser just sits there and sits there. Is there something I am missing?
Is there any way i connnect a Access 2007 database from SQL Server stored procedure using oledb connection so that i can copy some records from that database?I am asked to achieve this through stored procedure only without using DTS or SSIS.
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.
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.