I am a total newbie here. I have generated a web page using Visual Studio 2008. It connects to a database and lets me insert records. On the bottom of the form it automatically pus a link for "Insert" or "Cancel". I need them to be buttons. Is this possible? I don't even know where to begin.
View 4 RepliesA TemplateField of a DetailsView can be assigned a value easily at any of many event handlers such as Load, PreRender, etc. when the page is loaded. However, after Insert or Cancel is clicked, all the fields are cleared. I cannot figure out how to assign a value to the field again in code-behind.
View 4 RepliesI have a detailsview which has a button for insert and edit depending on mode plus a cancel button. What I am looking to do, is to use the cancel button to stop any insert or update to the database if clicked.
View 2 RepliesI am using a LINQ to SQL data source for a ListView and perform a validation check in the Listview ItemUpdating event:
[Code]....
This works great and keeps the user from updating the record with invalid data.However, when I hit cancel after this operation, it saves the text in the box rather than cancelling the operation. Here's my code for the update button:
[Code]....
Update Function:
[Code]....
I do not handle the cancel button event, as the cancel operation has worked fine... unless someone enters incorrect information and e.Cancel is set to true.What am I doing wrong? Is it the mixture of using the LINQ Datasource and doing my own updating?
I have a text box that I am reading mulitple employee names into. If the user enters a name that does not belong to an employee I want to cancel the item_updating function. Here is my code:
Dim RECIPIENTS() As String
RECIPIENTS = RLIST.Split(";")
Dim NAME As String
[code]...
We moved to a new SQL server and I started getting an error on one of my sps only when I ran it from a website. If I manually ran the sp it worked fine. The error I got was this System.Data.SqlClient.SqlException: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode. I can tell you that this sp does some things, then calls another sp which writes some sql to open an excel file and insert the data. Here is the pseudo
SET @sql = 'INSERT INTO dbo.TempParts (partKey, partKeyNumeric, partKeyAlpha, PartNumber, [Description], Comment, notAvailable ,BatchID)
've made a quiz/score system where a user will go through categories (page by page using querystring) and after submitting his/her score i redirect them to the next page where i show them their score and i also want to show "out of x number of questions".
I've made a query in my dataset:
[Code]....
I get an error about "Cannot implicitly convert type "void" to "object". This is the first time i am trying to use the SQL COUNT so i am almost certain it has something with the way i write it in my BLL, but i cannot figure out why or how to write it as it should. Hopefully you can direct me in the right path?
I want to know how to Edit and Update data from gridview. I have a gridview that generate data from a sqlcommand.Then I want to update the data directly from the gridview, I added the manually the Edit,Update,Cancel manually from the Command Field.How to Edit and Update the data directly from the selected row in the Gridview?
View 2 RepliesIs it possible to bind data to specfic columns in Gridview?
I mean, if I send a query to my database and it returns 1 column, then bind that column to the first column in the gridview, then send another query and bind the resulting column from that query to the second column without erasing the data of the first column etc etc.
I'm still building). After loggin in, users are presented with 3 radio buttons (they work), and 3 cascading drop downs (they work). Below that is an AJAX Accordion with 5 panes, each pane has a tabpanel with 4 tabs, 2 of the tabs have gridviews that change based on who is logged in and the radio buttons and dropdowns above
View 1 RepliesI'm using a datapager control on my listview to perform paging in it.When paging through the table, I need to perform some validations. When these validations are not successfull, the paging should be cancelledI currently perform the validation in the PagePropertiesChanging event of the ListView, however, the arguments do not provide a Cancel property.
[Code]...
It has to do with the RowCommand 'Cancel'. When clicking on my Edit button for a row, the GridView puts the row into edit mode without a problem (I have no code for the Edit command, I let the control do everything).
Once in Edit mode, if I click the Cancel button (again, I have no code handline this RowCommand, I let the control handle it (like i do with many other GridViews)) I get the following exception:
"System.InvalidOperationException: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."
I am having a strange problem. I put on a Gridview on my aspx page. I also data bound it to a table from my SQL server.
Other than that I wanted to put in the Edit, Update and Cancel functionality so I also put in this from the Gridview Smart Tag.
Following is the gridview aspx code can anyone tell me what I am missing here?
[Code]....
Im going to attempt to explain this as short as possible.I have a student registration page.There are two ways you can add a new student:1)'Add New Student' button in the emptydata template field of a detailsview )When the detailsview is actually populated just click the 'insert' linkProblem is I need two cancels buttons that do different things depending on which scenario above is enacted. I tried to state: When "Add New Button" is clicked show one cancel button and not show the other.I have both cancel buttons showing as of now, and they are both setup to do the different things that I want them to do just cant get them to be visible or not visible depending on which button is clicked.
View 2 RepliesI have a GridView. I allow editing using:
[Code]....
As I allow editing of row, so I have GridView:RowUpdating(). In it, I check if the entered value is valid. If not, I have e.Cancel = true.
[Code]....
After I see the message box comes up, the textbox still stays the same. I expect the textbox will disappear just as if I have pressed the Cancel button. (By the way, the ClientUtil is a class someone has written for me.)
How do I make the e.Cancel = true works as if I press the Cancel button.
i want to display results from multiple queries in a repeater... is it possible? for example, a user searches for a keyword "test" i search 4 different databases for it, and display results from all 4 in one repeater.
View 2 Repliesin VB, exactly how would you show only 1 gridview for this type of page example, where a user can fill in multiple options for searching:
Enter first and last name
_______firstname
_______lastname
[code]...
I have a Datalist with 6 elements inside (Labels and Hyperlink)This is in the "results.aspx" page. The process in started by the query stings being sent to the this page:...results.aspx?q=(ItemNameSeached)&cid=(City ID number)I have this bound to an SQL Data Source. My problem is that the ITEM_NAME, ITEM_ID (for the More... link), and the ITEM_BUILDING_ID are in one table in my database; The BUILDING_NAME and BUILDING_ADDRESS are in another table.I have an sql query string working to get the information in the items table but I don't know how to get the Building Information which is on another table. I know the sql query to get the building information (SELECT building_Name, building_address FROM buildings WHERE building_id = @ITEM_BUILDING_ID). My problem is that you can't bound two sql data sources and in the buildings query how do I get the value of the ITEM_BUILDING_ID label into the query.
View 4 Repliesi m using Details View i need to perform sly functiona;ity like in Grid (edit,updating,canceling)but i couldn't found the events in Details View which are present in Gridview(rowdeleting,rowcanceling edit,row updating)here is my source
[Code]....
My Source
[Code]....
Details View Event
[Code]....
I have several places where I have a gridview and dataview set, and when I hit an edit button on the gridview it opens up the dataview. When I hit a cancel button fom the dataview I have this code that returns mew to the gridview:
dvwUser.ChangeMode(DetailsViewMode.Insert);
I have created a Formview1 which have 3 columns Name, Status and Description. I just wanted to update display the Status and Description but not the Name. Can anyone give me any guidelines how I can do this.
I have use the following code on my asp.net page
[Code]....
how to perform Edit/Update & cancel in the grid view .. already the data is there in the gridview
[code]....
i want to update the values of the rows on my gridview. there are no errors or warnings about the code, but when i debugged the project i saw that the textboxes i want to change do not change. so there can not be update process.
[Code]....
I have a gridview in which i am retrieving data from database. There are 4 column fields :- EmpId , Name , Project Description and an image. With an image click 2 options should come Edit and Delete. I am done with delete but i m facing problems with Edit (I have already done it with AutoGenerateEditbutton="True" but I want to customize it) .
View 6 Repliesi have simple gridview
[Code]....
here i need to put this template field insted of command fields
<asp:TemplateField HeaderStyle-Width="0px">