i have this page called rateuser.aspx. User A logs in and can go to this page to rate&feedback any user. This is my code.
Protected Sub submit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles submit.Click
Dim connectionString As String = ConfigurationManager.ConnectionStrings("feedbackratingConnectionString").ConnectionString
Dim connection As SqlConnection = New SqlConnection(connectionString)
connection.Open()
Dim sql As String = "INSERT INTO feedbackuser(feedbacktitle,feedback,date) VALUES(@feedbacktitle,@feedback,@date);"
Dim command As SqlCommand = New SqlCommand(sql, connection)......
the first insert is to insert the feedback data into the feedback table. the 2nd insert is to insert rating data into the rating table. the 3rd insert is to take the feedbackuserID and the ratinguserID and insert it to the feedbackratinguser table (the "toMemberID" is taken from a dropdownlist and the "fromMemberID" is when i session the logged in user.) the "toMemberID" is controlled by dropdownlist where the value is in MemberID but data displayed is username. I am unable to insert the 3rd insert. The error line was "Dim reader3 As SqlDataReader = command.ExecuteReader()" and the error is "ExecuteReader requires an open and available Connection. The connection's current state is closed." how do i solve this error? the executereader is in a open connection already.
i am having serious trouble doing this rateuser.aspx. in this page, the logged in user(user A) can give a feedback to any user (user B). Similarly, another user (user C) can give a feedback to user B. when user A goes to user B's page, he should be able to see all feedback that was given to user B. i am having problem in doing the retrieving as i get duplicate data. To my knowledge, one user can receive many feedback.. and one user can give many feedback. my friend said it could because my "toMemberID" has the same ID (user B), thus it duplicated.
i had created a aspx page..Feedback and i had created the captcha coding... both i created in different folder...i wanna link the Feedback form with the captcha... -wen i want send the feedback, i have to write the captcha...after tat only can send.. how to link the form n captcha??
I'll be starting a complete re-write of a system in the coming weeks. I'll be using ASP.NET MVC 2.I'm still trying to determine what I should be using as far as TDD, mocking, and IOC is concerned. I was thinking:
VSTEST for writing my TDD tests (or possibly nUnit) Moq as my mocking framework (for creating doubles and fakes) Moq for IOC development Not sure exactly what the ideal setup should be and I'm continuing to research what's available. I'd like some feedback from the community on the most optimal toolsets for TDD, mocking, and IOC.
i want to implement a sort of feedback form/survey form in asp.net which is linked to a database. i want to create a asp.net application which will take questions from a database then display them on the form. once the user has finished the survey the results will be stored into the database.
I'm using a GridView control, using the Northwind database as a sandbox.
I have allowed editing of rows using AutoGenerateEditButton="true" and that all works fine. The book I'm using for reference the following code behind for error handling (C#):
[code]...
However, this seems to have no effect upon my label text, leading me to believe that the exception handling snippet won't work either.
I want to develope an Teacher's Rating/ Feedback/ Assesment (by students) application in .NET.There will be 20 different points on which a student will rate his/her teachesr as poor, fair, good, Very Good and Excellent.
I want a gridview for feedbcak process by students about their teachers. I need to render teachers image in header row (that,s also dynamically based on previously selected teachers), and dynamically selected questions for feedback in the header column. In the remaining cells I need star rating control to rate the teachers on respective question.
I also wanted the functionality so that teachers images i.e. header row remain in it's position while scrolling but I got the same from your previous post.I also want some hints on how to store the rated values in database.
I use GridView & FormView to update a record. but when I click the "save" button, throw an except : FormView must be in the insert mode to insert a record. The record has been updated success, and I didn't change the mode of the FormView, how this error comes?
In my detailsview, I have an emptydatatemplate set up to allow users to enter new records. The code works. However, once the record is inserted, the detailsview defaults to a standard insert screen. I know this will cause confusion for the users. I would prefer the detailsview to either show in edit mode or a read-only mode. I have used detailsview.changemode and detailsview.currentmode in the custom sub created for the add new button of the emptydatatemplate- neither of which do what I was hoping. It would be even better if when there was no data, it defaulted to the insert screen (which seems like that should be an easy, no-brainer way for .net to function) but it doesn't. Or, I don't know how to accomplish it.
I don't want to force the user to click cancel after inserting an item through the emptydatatemplate just to be able to use the detailsview for other records.
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
I am using Visual studio 2010 express and I have a details view databinded to an sql database table. When I use the Insert option on the view it causes an error due to it trying to insert a null into the primary key field. If the Insert function does not create a new primary key entry how is it created?
I have a GridView (BulkEditGridView), that has 10 rows from the datasource. I Add a TemplateField "Insert Row" button to insert 1 blank row at selected row using Rows.AddAt.First time i press "Insert Row", it works as expected, the row inserted at selected row. now i press another "Insert Row", the row is inserted, however the row (in first time inserted) now move to the last row. and so on.
I have a problem with DetailsView linked with Database, DetailsView is Insert/Edit enabled, and adding/ediditng data works, however........ when I add a new record (DetailsView in Insert mode) and press INSET instead going to record I have just created in Read-Only Mode it shows me blank form, it looks that the "linking" field is null.
I am trying to pass in as an insert parameter for SQLds2 the scope_identity of the insert of SQLds1.
Exception Details: System.InvalidOperationException: Error executing 'InsertCommand' in SqlDataSource 'SqlDataSource1'. Ensure the command accepts the following parameters: @Name1, @NewId
Getting the message that ObjectDataSource ... count not find a non-generic method ... that has parameters ... The parameter list is fine until I get to the very end and it list the two data fields that are in my DetailsView. Using the ASP Tutorial #17 (Examining the Events Associated with Inserting, Updating, and Deleting) and the Exploring the Data Modification - specifically the one showing the INSERT of the Product Name and UnitPrice. ASPX page is pretty simple and attempting something similar, two fields to insert a new record - update the other fields later.
Full Error Message follows along with ASPX and the AsignaturasBLL.cs. Interesting thing is that when I swap the two fields in the DetailView, then the last two fields in the error message are swapped. In the error message I bolded these two fields.
i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
I do have a details view, which insert data to a database table using SQL Datasource. Now i need the data to be inserted in to 2 tables instead of one.
I have a Winform that has fields need to be filled by a user. All the fields doesn't belong to one table, the data will go to Customer table and CustomerPhone table, so i decided to do multiple inserts. I will insert appropriate data to CustomerPhone first then Insert the rest data to Customer table.
I am using 1 textbox with a Ajax Calendar extender to allow my user's to select a date graphically (exp: 12/15/2009). I have another textbox for the hour and minutes in military time(exp: 15:30). I think i have the code to grab the data from the 2 textbox's and combine them to be inserted into the field (exp: 12/15/2009 15:30). Here is my insert code for the Field:
[Code]....
However unless I make all the fields Nullable the insert fails, on top of that none of the other field that I have selected on the Detailsview Insert or Edit are inserted into there fields. Half of my fields have to be non-null values. So how do I fix this?
I can supply additional vb code and the aspx code if needed.
This is the error I'm getting: Cannot insert the value NULL into column 'Operation_type', table '/GAOSDB.MDF.dbo.BC_Perf_Log'; column does not allow nulls. INSERT fails. The statement has been terminated.'
This is the first non-null column.
I need to get this figured out because I have 30 other web pages that will be utilizing the same approach.
