Forms Data Controls :: How To Change Insert To Edit If UserId Exist In Table
Feb 6, 2011
It sounds pretty simple, but I can't find a way to make it work. I have a FormView with a InsertTemplate where it inserts the current logged in user's UserId and content from a HTMLeditor, and a EditTemplate where it retreives the current logged in UserId and shows content from database in the HTMLeditor.
How can I get it to show EditTemplate if the userId exist in the table, and InsertTemplate if the UserId does not exist in the table?
I'm using an edittemplate to handle both editing and inserting for a Formview. In Insert mode, the Identity parameter is not needed (and cannot be used in the parameter list). In Edit mode, I need the bound value to know which record to update. So, what I tried to do is set the Text property in the OnDataBinding method.
[Code]....
The result is that the field is bound for Insert anyway, shows up as a parameter, and my insert statement fails (since this extra field messes up the field order of the parameters). Plus, it is always null in Insert mode by definition.
Is the OnDataBinding method too late to clear the property? If so, where can I do this, since PageLoad is too early (the template has not loaded yet and I cannot Findcontrol the field. Or is there a better way to handle all this?
I'm creating a web project for one of my uni modules using Visual studio 2010. I'm using asp.net membership and have all of my sql-server tables set up correctly (I'm pretty sure).
I have a form that I have created myself that inserts into the database using sqlDataSource.insert(). I had some problems initially with not being able to insert any data into the table at all, but I have cleared that up.
My problem now is that I need to insert the currently logged in user's userID into one of the columns of the table. But every time I hit the submit button, I am told I cannot insert null values in the userID column.
I can retrieve the userID using this snippet:
[Code]....
This is the code behind for the page:
[Code]....
As you can see it is a bit of a mess, I've been frantically trying different variations, as I need to catch up a little with other uni modules.
Here is my SQLDataSource from the .aspx page, The controlparameters work fine for the other data I am inserting. maybe the <asp:parameter name="userID" /> is wrong?
[Code]....
I'm relatively new to vb, and I come from a html & css background.
I recently read Scott Mitchell's article series "Examining ASP.NET's Membership, Roles, and Profile". In Part 6 [URL] It says "to store additional, user-specific fields...If you are using the SqlMembershipProvider, this would mean creating an additional database table that had as a primary key the UserId value from the aspnet_Users table and columns for each of the additional user properties."
I created a table named Thread to store some specific users information and comments they make. I set the ThreadId as the primary key and the UserId as the foreign key to the UserId in aspnet_Users table. But when I run the application and use a user's account to submit a comment, there is an error in my Comments.aspx.vb page "Cannot insert the value NULL into column 'UserId', table 'ASPNETDB.dbo.Thread'; column does not allow nulls. INSERT fails.The statement has been terminated."
How can I make the logged-on user's UserId inserted into the Thread table when storing the user's other data information?
I have a page where I have a tab container and four tabs. the problem is on the first tab "manage quote request" I have a Gridview with the quote request general informatin listed and have a template field created with a link button to databind to the formview quote details. the porblem comes in when after I click on the select linkbutton. the Formview loads right. Then Whe I try to click on the edit linkbuttin in the form view I have to click it twice to change the mode to edit.
I have a standard gridview and detailsview. My detailsview has some fields which are templates, with dropdownlists. The user selects a record in the gridview, then can go down to the detailsview, select Edit, and change some values (using dropdownlists).I am getting the error, "DDL has a selectedvalue which is invalid because it does not exist...." when I click Edit in the detailsview.
I know the problem has something to do with the dropdownlists not being instantiated or bound until I enter Edit mode. Is that right? In what event should I databind my dropdownlists? I've tried several things but could not get it to work. Do I have to loop through all the rows of my details view looking for the dropdownlists, or can I access them directly from some event?
I have a GridView on a page for maintainance of the database (mdf). Under this GridView1 I have a FormView1 where I use the ItemInsertTemplate to Insert new rows in my database (which shows the data in GridView1). The first textbox (BIDTextBox) i have on this template, contains text which identify a person. I would like to have a routine which checks if the same value that is entered in the BIDTextBox allready exists in the database. This routine should be fired upon leaving the control BIDTextBox.
I have tried with some stored procedure in my database, but that dosn't seem to do the trick. The most logical to me seems to do a loop thru my table "Ansatte" in my database using sql, selecting any occurence from the field "BID" in my table "Ansatte" that is simillar to the text entered in the BIDTextBox.
im using gridview to read data from datasuorce(my access) and im editing data using 'enable editing' from smart tag(in design window .aspx), now i want to change the edit text: edit(i hav named it as edit) to 'view' for one particular user whose name:'sunil'?
this is my table(in my access layer and calling this data through datasource of gridview):
I have a confusing question, I have a user table and it stores all the usual data for a user that you would expect but im trying to figure out how a user could add another user?
Sounds strange but each user in the User table has his own UI which is UserID how could I add another table where UserID can have a relationship with another UserID?
i.e how would I right the syntax for the above question if I wanted to display all the UserIDs friends on a page. How would I add a friend.
CDC or Change data capture is a new feature in SQL Server 2008, which is an ability to record changes to table data into another table without writing triggers or some other mechanism, Change data capture records the changes like insert, update, and delete to a table in SQL server.I have sql 2005 and I have created triggers and tables CDC to capture the data. everything functions good and the data is being updated in the _CDC tables. all i need to do now is to generate the updated data as a report (excel/html)- what should I do ......?i need to show only the updated columns when user selects the date periods ( Range between dates ) and the person name - i need to display any updated info about that person during that period. So this updated columns about this person should be displayed in excel formatted column wise.
I am working on a web app for an online photo album. It is the last project in Scott Mitchell's book: "ASP.Net 2.0 in 24 hours".
I am creating a page where users can enter new photo images. The functionality for uploading an image will come later. I am working on just inserting a new row into the Pictures table with an optional category, a required title and a required description.
I am getting an error when I try to insert a new row.
Here is a screenshot of the page with a shot of the dropdown list.
The Categories are user-specific. I am getting the correct values retrieved.
[URL]
There are two pretty simple database tables involved here.
NOTE: The CategoryID and PIctureID are both autoincrement integer columns.
[URL]
The page uses a DetailsView that uses a SqlDataSource that uses the Pictures table. (The DetailsView's Default Mode property is set to "Insert". The "Enable Inserting" checkbox is also checked.)
The dropdown list uses a dropdown control that uses a SqlDataSource that uses the Categories table.
When the "Insert" button is clicked the CategoryID value associated with selected (Category) Name on the dropdown list will be used along with the Title and Description values to insert a row in to the Pictures table. (If no Category value is selected, then a null value will be used for the CategoryID. This is OK because the CategoryID column in the Pictures table allows nulls.)
My problem is that I am getting this error:
Cannot insert explicit value for identity column in table 'Pictures' when IDENTITY_INSERT is set to OFF.
(FYI: I have the full version of both Visual Studio and SQL Server.)
I would like to change the layout of the edit and insert templates to show multiple columns (instead of the default 1), and make the required fields show in the first column. Please point me in the direction I need to go.
I have a ListView Which displays Customer, product, price, Quantity and comments from database.The User can either edit it or Insert new items. In Edit Item template and Insert item template, i need to add a image button next to the textbox, which when clicked, will display a pop up window with list of customers or products.I have been doing it with the normal aspx page with textboxes. I use click handler to pop up the windows.i'm not able to do with listview Please help to give a solution to it.How else can i add an image icon and click it and get the values back to the textboxes?i will post what i'm doing without listview first and then the part of the relavant code of Listview.
I got a problem about finding controls in Edit/Insert Itemtemplate inside a DetailsView.Here is the code.I put a Label (id= "Label6") to test whether the findcontrol method works or not. Unfortunately, I almost tried every means but still coudn't find it.
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've got a DatalList control on a page that I intend on using for Editing Items. I've added a button control into the Item Template with CommandName="Edit", and when click the button on the item, the page Posts Back and continues to display the ItemTemplate for that item.
How can I change the "Edit" button to an imagebutton without need to disable the autogeneratecolumn?I don't want to do that in the code..just using the autogenerate....
I am trying to handle the detailsview programmatically but I don't know what I am doing wrong. My details view control isn't going into edit mode. My code for my gridview's select button properly loads the data into the detailsview but once the detailsview renders clicking on "Edit" doesn't switch the detailsview contol into edit mode.
This code draws the information from my database and loads the information into the dataview:
[Code]....
This code is in my dvTeamDetails_ItemCommand sub and the beep works:
Lets say that i want to make a ADMIN page for articles.
1) I show all my articles on lines 2) Each article has an EDIT BUTTON and INSERT NEW button 3) When I click on the EDIT BUTTON, it opens a CUSTOM page where i can Edit my article. 4) When i click on the INSERT NEW BUTTON it opens the same CUSTOM page where i can Insert my article.
I was trying to do it with Gridview and Formsview.
I am using a formview on main web page and the Item template displays my data correctly but I get and error when I try and link to the edit or insert templates.This happens on our remote tesing server only.On my local machine running the page on the local server in VS 2010 everything works fine.But then doesn't it always work on your local machine.I might also mention that I am compiling for asp.net 4.0. Here is the stack trace :
System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'MYCORPABIGWEB01$'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()