I was able to get the code below to give me the value I want from my SQL table however it has to display it in a gridview so I assume that something in the code acutally makes the result a data source rather than a string value.
[Code]....
I was wondering if when you add the update link for gridview records, is there a way to only allow the user to update just one field in the record?
View 1 Replies I have a gridview where I am using the update. I have converted the label into a templatefield and added a dropdownlist which is getting polulated in the Rowdatabound event. When I test the update i get an error
Cannot insert the value NULL into column 'StartTime', table 'HTC.dbo.EventDates'; column does not allow nulls. UPDATE fails.The statement has been terminated. so I am ussuming its still trying to update from the label rather than using the dropdownlist. here is my code:
[Code]....
I have a Modified Date and Modified By column in my gridview and I want them to be updated with the current date and current user any time a user updates the row.
I converted my columns to template fields and the textboxes in the edititemtemplate are bound to my sql data columns "ModifiedDate" and "ModifiedBy"
Then I added the attached code in my RowUpdating event.
When I test the code and click the Update link on my gridview I don't get an error but the values don't update either. I put a breakpoint on the code and when I hover over "ModifiedDateLabel.Text" I see the old value of the field so I know I'm accessing the control correctly.
So I am uding a GridView bound to a SQL data source.
I have a template feild bound to a SQL BIT
<EditItemTemplate <asp:CheckBox ID="chkSelected" runat="server" Checked='<%# Bind("Selected") %>
The original Item Template was Enabled ="false" I changed this so that you did not have to set the row to a state of edit in order to just select a row. I enabled it so that you could "select" any row with out putting it in a state of edit. the only value changing is if its selected or not. What i am trying to do is use the Data Source Update method to update the bit in the database based on the check box. Currently Update() returns 0. I believe this is because the row/feild is not marked as changed so the Data Source does not see it as something that needs to be updated.
What I am hoping for out of this is post is a way that the rows whom check value has changed to be marked as changed/edited so that the data source will update the database with the values of the check boxes. If all rows are updated this is acceptable as well. I know this is a super simple solution but i have been out of the .NET for a little bit.
I have a gridview and sqldatasource in a form. My sqldatasource has select,delete and update command. The delete command is working but the update doest not work when I click the update command field.
Here is my code [Code]....
I created a gridview that is bound with an SQL datasource - I added a gridview button column. I need to update/insert 'Y' on a specific cell in the row when I press the button
This is my gridview code
[code]....
The button column I have says delete on it but it shouldn't really delete it - Once I press the button it puts a 'Y' on a column that is filtered out by my sql statement in the sql datasource
i have a DropDownlist in my GridView that is bind to another DataSource than the GridView.
For the display it is working well but when I want to update datas I m stuck. Something is wrong and I don't know why.
[Code]....
I am stocking in the Database the value of the dsDroit but when I want to update the field I just know how to get the text not the value.
I am trying to set up a GridViewUpdate, I need to find the Parameter and I am having trouble figuring it out.
How would I go about obtaining the value for "@ID" parameter in order for the user to update the required "TAUpdateDate" field?
[Code]....
I have a gridview, and I was trying to use SQLAdapter for the first time. I have it set up but I want the user to enter a Date in the last field of the Gridview and be able to update it. I was looking up examples, and I cannot get it to properly update. The field I want to be able to update is the "TADateUpdate" I have gotten it to show the texbox fields to edit, but I can't figure out a method to update properly.
[Code]....
I have a gridview based on a sqldatasource that has some colums from which two colums showing the data of two fields: field1 and field2. field1 is an ID which should not be updated and therefore it is readonly=true. The sql-query from the sqldatasource is:
SelectCommand="SELECT field1, field2 from anyView"
What I want is, that when a row is updated, then the value from field1 should be copied to field2 The update-query is:
UpdateCommand="UPDATE myTable SET field2=@field2 WHERE field1=@field1"
My idea was, that the @field2 paramter gets the value from the query string out of field1:
<UpdateParameters>
<asp:QueryStringParameter Name="field2" QueryStringField="field1" Type="Int32" />
</UpdateParameters>
But this does not work. Is there an easy way to copy the data from field1 to field2 when updating the row? In addition, is this possible, even if field2 ist not shown in the gridview (i.e. field2 is selected in the query but is not a field in the gridview but should be updated with value of field1).
I've run into this before, but I was using a formsview and just changed the field to hidden. I am trying to get the value of a cell out of a gridview to a variable and here is the code:
[Code]....
This works perfectly if column 6 is visible, but because it's an id number (which is not the primary key) I do not want it visible, but changing it to visible="false" causes this code to return null. Changing it back to visible and it works.
I'm not sure why the visiblity of a control changes the functionality of it.
I know how to catch a key pressed, but I don't know how to do that in a gridview to get the the row index and the value of the field. Explanation in the code below (it is going to be more clear I guess) :
[Code]....
In the txtPosition TextBox the user is entering a number and press the Enter key which launch the "HandleAttribute" event as if the client had click on the "imgbtnUp" ImageButton.
how can i align text in gridview template feild.already test ItemStyle-HorizontalAlign="Right"
but not working..
I have created a question form which has a text box where a user can type their question. During testing, I can add text to the box and use the Sql Insert command to add a record in my sql database table.I need to have the text box list a series of question to which the user provides the answer. So in the onLoad event of the page I have specified me.txtQuestion = "the contents to be displayed by default as questions". This works fine, when I open the question page, the question text box has the correct pre-defined content.My issue now is that when I change the content of that text box, weather it be adding or deleting text and I save the record, it is always the default text that is saved. It's like I need to do a refresh of the text box prior to saving...Does anyone have some ideas as to how I would accomplish this?
View 3 RepliesI have seen several Web Sites that use GridViews that have lookup fields with different Value and Text Fields (as in drop down lists) but I can't seem to figure it out how to display the Text Field in the Item Template when the Text Field is not in the datasource. .
Here's what I have. I have a Gridview whose datasource is a Linq to SQL Invoice table, e.g.
InvoiceID
CustomerID
InvoiceNumber
THe Customer table is related to the Invoice Table thru the CustomerID. The relationship is defined in SQL Server and is displayed in the DBML.
I have created a template field for the CustomerID field in the Gridview. I would like to display the CustomerName when the Item Template is displayed and a DropDownList in the Edit Template. The DropDownList works great, but I cannot seem to figure out how to display the CustomerName in then Item Template.
I seem to remember seeing in some video that you can simply drag the CustomerName into the CustomerID Item Template Field. But I can't seem to find the customerName field. The DataSource includes the Customer Table because of the relationship, but no fields are displayed.
I suspect this is real simple, but I cannot seem to find an article or video that explains how to do this.
I'm using a formatting expression with a template field. When the details view goes into edit mode the formatting is applied. It looks great because it applies the currency formatting. It shows up as "$60,000.00" instead of "60,000.0000". But then when I do the update it gets rejected because of the $. Is there a way to keep the formatting for the user to see in edit mode but remove the $ when doing the update so I don't get the error?
The error: Exception Details: System.FormatException: Input string was not in a correct format.
template field:
[Code]....
I want to hyperlink from a field in one gridview to a field in another gridview based on id. I've tried many ways but haven't seen success.
View 20 RepliesI am currently working with a large query of client name, and instead of using a dropdownlist, I have done the follow:
I setup a Textbox for the user to enter some text, and then click the search button. Using a modalpopupextender (AJAX), and panel appears showing a listbox displaying clients that are like the text entered. The user then picks one, hits ok, and the value is returned to the text box.
Currently, the listbox is not displaying anything. Here is what I have:
[Code]....
I changed a text field to a template field assigning the selected text and the selected value is being assigned to another currency field also templated. I get aa error
[FormatException: Input string was not in a correct format.]
The updating of the ASP Button and the Input Button works fine, but I can't get the regular HTML Button to work.
I used an alert to verify that the event was getting triggered, but it is not updating the button.
[Code]....
I have a question regarding to the text in the html code. I would like to know if there is a way to change the content text in the html with text that has been written in textbox. For example i have following text in html, so how can I replace this text by using a text box in the server side.
View 2 RepliesI had a load event in my form where I assign a text box todays date as the text.I have created a button clic event that writes to a database the value which can be updated a required.
The problem i am having is that even if I change the value of the text box it sill seems to remeber the value it was given when the page as loaded.
how do I update a field from code like inserting a date. i have something like below. i want to insert the date when the record is updated or edited, but it does not work what is the correct way to do this in mvc
[HttpPost]
I inherited some JavaScript that I was told to integrate into our ASP.NET site. I thought this would be straightforward but it's turning out to be a bit of a challenge.
The code looks something like this:
<SELECT id="Question1" name="Question" onchange="updateQuestion();">
<OPTION value="notChosen">--Please Select One--</OPTION>
<OPTION value="in">India</OPTION>
<OPTION value="de">Germany</OPTION>
<OPTION value="fr">France</OPTION>
<OPTION value="us">United States</OPTION>
<OPTION value="ch">Switzerland</OPTION>
</SELECT>
The goal is to get the value from this HTML control into ASP.NET, however this control itself is being dynamically generated by another chunk of javascript, so I can't just change this to an asp.net control. My solution was to add the onchange="updateQuestion();" method, this JS will take these SELECT tags and place the values into an ASP.NET control:
function updateSecQ() {
var sQuestion = document.getElementById('<%=sQuestion.ClientID%>');
sQuestion.Value = "";
var questions = document.getElementsByName('Question');
for (question in questions) {
if (questions[question].value != null)
sQuestion.Value += questions[question].value + ",";
}
alert(sQuestion.Value);
}
As you can see, that's looking to update an ASP.NET control:
<asp:HiddenField ID="sQuestion" runat="server" value="" />
This appears to all work, however when I goto the server side on the form submit I see that sQuestion.Value is still = "".