Web Forms :: Insert A Feedback To A Particular User?
Feb 1, 2011
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 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 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 have written a SP which maintains users log in and log out history,it works fine when any user logs in or clicks on log out, problem is that as per need its not to allowed to keep the screen idle for 1 minute or more then in the log out column Null value is passed.
SP
Create proc usp_trackuserlogindetails @username varchar(50) = null, @command int = 0 as BEGIN if(@command = 0) begin insert into userlog (USERNAME,LOGIN,LOGOUT) values (@username,Getdate(),Null)
[Code] ....
Here when user manually clicks the log out button then 1(table above) is the output.
When user leaves the screen idle then after 1 minute the page goes to the Login.aspx page if the user tries to do something on the current page,here 2(table above) is the output can i store some hard core value instead of Null like Session expire or the exact session expires time.
This is placed in the sqldatasource selecting sub. It works well and loads up data from the database based on the @UserId parameter.
I load up the detailsview and it only loads up data from the DB based on the currently logged in user, however i want them to be able to insert some data too.
Anyone know how i can achieve this when they select insert? For starters i having endless parameter problems but i am sure i can sort that out. what i really need is someone to tell me how i can pass the UserId into the USERID text when the details view mode changes to "insert"
I know there is a "mode changed" event, should i be using that?
I have a pre-existing app that allows me to display detailed record results from a database,and I've made a custom mod to it to limit the type of results(i.e. show me just THESE three tables instead of all tables associated with a record).I would like to make a hyperlink from the abridged version of the record to the full version of the record,but I can't for the life of me figure out how to do this!I know that the code in the .aspx file should look something akin to:
I need to be able to insert a record ID in order to get the end-user to the appropriate results page,so I need to find a way to insert a field Record_ID at the end of that keyword string call (d=).
Any ideas of what I'm doing wrong and/or what I need to do to the code behind file? I'm sure that this is one of those "can be done in 5 minutes" types of things once I know what I'm doing.
I am selecting the date field in the 'dd-mm-yyyy' format by using SQL Codes(103,105...).While inserting I want the userto insert the date in same format(dd-mm-yyyy) but it will not happening as in SQL Server we need to insert the date in'mm-dd-yyyy' format.Pls send me insertion query in sql to achieve this.Pls respond me ASAP.
I have a control that I want to be able to mark areas as editable. When a user enters a username and password, they can then edit these editable areas.One of the area to edit is the main content of the page. Since I want them to be able to edit this on every page, I have put the editable control into the master page, wrapped around the ContentPlaceHolder of the master page.I found out how to allow the parser to allow <prefix:tag></prefix:tag> rather than just ending it with />, but I can't figure out how to get the text within the tags to be accessible through something like a Text property. A prime example of this behavior is the Label control, where you can put <asp:Label>Hello!</asp:Label> and access Hello! through the .Text property in the code.
I am using the createuserwizard to create a new user, however, I am also adding data to a custom sql table during the create user process. Everything works great. The new user is created in the aspnet_tables and the extra data is added to my custom table. The issue I am having is adding the current logged in user's ID to the custom table so I know who added the new user. I am able to capture the newly added user's ID and insert it into the custom table to create the link between the aspnet_tables and my custom table, however, the insert places the new user's id into my IDModifiedUser field instead of the currently logged in user.
would like to know how to feed data for columns like Logged-in user id , Updated date, created date etc... I have these audit columns on each and every table. User id: Logged in user idCreated date or modified date: current system date time. and don'nt want to show these columns on the UI as well.
I'm using a listview control to do a survey stuff. Everything is working perfect to present the data questions, to be answered text with the different type of controls radiobuttonlists, checkboxlists, dropdownlists, etc. The admin can modify, create, change questions, answers, etc. on the survey.When it's select, edit, or insert it's easy to find the control inside a listview.However, I'm wondering how to post user's answers back to DB. How to find controls inside the listview to grab the entered data/responses from there using let's say the submit button that is outside of the listview.I believe there should be a way to do it as otherwise why we put radiobuttonlist on a listview that somebody could click it and then we should be able to get that entries. Or I'm too optimistic on this control?
I have a detailsview in insert mode. I want to prompt the user to enter data in all fields, if left empty. Could someone please find a few minutes to show me how to do it?
From my ASP.NET application I am calling an INSERT stored procedure, there is a default value for one of the columns in the table that the INSERT procedure places the data into. How do I specify that I want the default value to be used instead? (Or do I have to specify the actual default value in my parameters)
i m working on mvc 3.0 application and using bulting feature of membership for creating account and i have using ASPNET_REGSQL.EXE command than i have migrated table in our database but when i create any user in membership mvc user account but in database, records are not inserted of user ...
I have three column comes from database table(Table1) and one column is for entering data for the user let us consider it look like this
ItemNo ItemName Qty uservalue
001 A 50 20 002 A 20 5 003 B 50 004 C 60 10 005 D 40 006 E 90 15
........
If its 300 row from database to gridview it will show 50 record with page navigation..What i need is i need to insert data in to database table which gridview row has user value..The output of the another table(Table2) will look like this after insert
