C# - Gridview Update Changing Update Parameter?
Oct 20, 2010
I have a Gridview where I can modify the Time portion of a DateTime field. The update method is working well, except for one thing:The field should only allow the time portion, e.g 08:23:09 but on the Database it saves it as a full DateTime, e.g 10/18/2010 08:23:09 AM. The problem is that upon editing, instead of adding the existing Date portion, it adds the current Date portion. So if I am editing the item from the last example into 08:25:09 instead of adding it as 10/18/2010 08:25:09 AM it adds it as 10/20/2010 08:25:09 AM which is obviously undesired behavior.Here's how I am doing the update:
protected void grvOutHour_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridView grvOutHour = (GridView)this.grvReport.Rows[grvReport.EditIndex].FindControl("grvOutHour");
TextBox txtBox = (TextBox) grvOutHour.Rows[e.RowIndex].FindControl("txtEditOutHour");
[code]...
View 1 Replies
Similar Messages:
Sep 27, 2010
I have a vb.net page that has an optional parameter. If a user enters data for that field, and clicks save, it saves fine via the stored procedure. HOWEVER, if the user changes their mind, and wants to erase the data they entered, they go to the text field, and delete the characters, and click save, but no matter what, the stored procedure will not save the fact that they erased the data (it won't set it back to NULL). If the user enters a space, the stored procedure will save the space, and if they enter different data, it will save the other data. I can't figure out how to get it back to letting them set it to Null? I think this is because it's an optional parameter, and the stored proc is used by several forms (Some of those forms do not include this parameter), but this form utilizes that optional paramater.
Here's my stored procedure...
[Code]....
[Code]....
View 2 Replies
Jul 25, 2010
I have GridView1 and SqlDataSource1. I use EnableEditing to GridView1. This is Code of GridView
<
asp:GridView
ID="GridView1"
Width="100%"
runat="server"
AutoGenerateColumns="False"
BackColor="White"
BorderColor="#3366CC"
BorderStyle="None"
BorderWidth="1px"
CellPadding="4"
DataKeyNames="DoctorID"
DataSourceID="SqlDataSource1">
<RowStyle
BackColor="White"
ForeColor="#003399"
/>
<Columns>
<asp:BoundField
DataField="DoctorID"
HeaderText="DoctorID"
InsertVisible="False"
ReadOnly="True"
SortExpression="DoctorID"
/>
<asp:BoundField
DataField="DoctorName"
HeaderText="DoctorName"
SortExpression="DoctorName"
/>
<asp:BoundField
DataField="City"
HeaderText="City"
SortExpression="City"
/>
<asp:BoundField
DataField="Str"
HeaderText="Str"
SortExpression="Str"
/>
<asp:BoundField
DataField="StrRegion"
HeaderText="StrRegion"
SortExpression="StrRegion"
/>
<asp:BoundField
DataField="StringLevels"
HeaderText="StringLevels"
SortExpression="StringLevels"
/>
<asp:BoundField
DataField="Streat"
HeaderText="Streat"
SortExpression="Streat"
/>
<asp:BoundField
DataField="Email"
HeaderText="Email"
SortExpression="Email"
/>
<asp:BoundField
DataField="Mobile"
HeaderText="Mobile"
SortExpression="Mobile"
/>
<asp:BoundField
DataField="HomePhone"
HeaderText="HomePhone"
SortExpression="HomePhone"
/>
<asp:BoundField
DataField="ClinicPhone"
HeaderText="ClinicPhone"
SortExpression="ClinicPhone"
/>
<asp:BoundField
DataField="Fax"
HeaderText="Fax"
SortExpression="Fax"
/>
<asp:BoundField
DataField="address_details"
HeaderText="address_details"
SortExpression="address_details"
/>
<asp:BoundField
DataField="Expr1"
HeaderText="Expr1"
SortExpression="Expr1"
/>
<asp:BoundField
DataField="VisitPlaceStr"
HeaderText="VisitPlaceStr"
SortExpression="VisitPlaceStr"
/>
<asp:CommandField
ShowEditButton="True"
/>
</Columns>
<FooterStyle
BackColor="#99CCCC"
ForeColor="#003399"
/>............
View 1 Replies
Aug 27, 2010
I have a gridview with a date field. I don't want the user to be able to type in their own date and mess up the format so I made the property readonly. That date is then set by a point and click interface. This is all working fine but when the user clicks update this field doesn't update because it's readonly. If i turn readonly off it works so is there a way to turn off the readonly property right before submit?
View 7 Replies
Feb 4, 2010
I have two image buttons in a gridview, one to approve the opening of the record and one to approve the closing of the record. I have added a CommandName to each button (OpenApproved and CloseApproved) and in the grids rowcommand I would like to update the database with the Username of the person clicking the button, Username goes into either the OpenLeadApprover or CloseLeadApprover field depending on which button is pressed. The grid has a sqldatasource with an Update stored procedure which has three parameters, @WorkOrderIDWhat I have tried to do in the RoeCommand event is declare a variable for the sqldatasource and add the parameter value to it, then run the update command. Here is the code:
[Code]....
View 4 Replies
Nov 5, 2010
during edit mode i populate the drop down in question with data based on a value selected in another drop down also in the gridview, all works find, but the paramater is not being updated with the selected value, i think this is because i do not call any Bind in the aspx side.
<asp:TemplateField HeaderText="Build Types">
<ItemTemplate>
<asp:Label ID="lblBuildTypes runat="server" Text='<%# Bind("BuildType") %>'></asp:Label>
</ItemTemplate>
[Code]....
View 2 Replies
Nov 4, 2010
I have a SQL table containing a timestamp column. This table is displayed in ASP using GridView control. The timestamp column is indicated in the DataKeyNames property of the GridView. I'm using TemplateFields for all columns and a ItemTemplate HiddenField control connected to the timestamp column using Eval.
<asp:TemplateField
ItemStyle-Wrap="false"
Visible="false"
HeaderText="timestamp"
SortExpression="timestamp">
<ItemTemplate>
<asp:HiddenField
ID="gv_hid_timestamp"
runat="server"
Value='<%#
Eval("timestamp") %>'
></asp:HiddenField>
</ItemTemplate>
</asp:TemplateField>
The data is displayed properly. I'm trying implement the optimistic concurrency in C# using the value of above mentioned timestamp and a stored procedure. The SQL stored procedure expects the @timestamp as varbinary(8). I'm not sure how to pass the value of gv_hid_timestamp back to the stored procedure. I'm using the following:
command.Parameters.Add("@timestamp", SqlDbType.Binary).Value = Byte.Parse(((HiddenField)gv.Rows[row].FindControl("gv_hid_timestamp")).Value);
resulting in the following error: "Input string was not in correct format." (I also tried different data types but with similar result). I want to be able to pass this parameter programmatically from C# and not have to specify it on the UpdateParameters list.
View 2 Replies
Apr 19, 2010
i want to update the data of a database through a gridview update button
how can i attach a dataconvertion like this
[Code]....
View 1 Replies
Jul 10, 2010
I want to update multiple rows of gridview (only price field. for that i have added textbox) on click of update button which is outside of gridview.I have done following way
<asp:LinkButton ID="lnkUpdate" CssClass="BlueButton" runat="server" OnClick="lnkUpdate_Click">Update</asp:LinkButton>
[Code]....
Up to this its working fine but when no textbox updated then no need to go in for loop so i am looking for confiramtion before updating rows please help me how to do that becausei am less aware with javascript. another problem is textbox value disappear when page index changed how i can retain that values.
View 2 Replies
Mar 23, 2011
[Code]....
View 8 Replies
Jun 28, 2010
When i try to update a row using the update functionality of Gridview it updates all the rows rather then updating that specific row which is in edit mode.
[Code]....
View 1 Replies
Jul 31, 2012
I have a query . I want to edit the grid view columns in which user click the edit button he will edit the column in the grid and after that i want to add update button so that when he clicks on updates button after editing the row. The row will be updated and the grid will show you the new update row.
Here is my following piece of code.
<asp:GridView ID="noticeDetails" runat="server" BorderWidth="1px" AutoGenerateColumns="false" PageSize="10" Width="100%" CellPadding="10"
AutoGenerateEditButton="true" onrowediting="noticeDetails_RowEditing" >
<Columns> <asp:TemplateField HeaderText="CampaignIDRange">
<ItemTemplate> <%# Eval("CampaignIDRange")%>
[Code] ....
Basically grid is about that when user enter values intothe grid, the values will show in to the grid upon click button.I added edit button it works fine but it will incomplete without update button method ...
View 1 Replies
Nov 19, 2010
I have an update that changes user profile informationI have pulled the membership email in and can view the email in my table but it will not update the email when I change it.When I debug this code it seems to work fine and I beleive it was working before but suddenly stopped.I should add that I have created my own profile table and have had no problems updating all other information.Even adding the ability to update the membership password.here is my code for the update of the email:
[Code]....
Has anyone had a similar problem?I am not sure why it is not working
View 1 Replies
Aug 26, 2010
i have a list box, a command button and a grid
when i click a particular record / or multiple records on the list box and then cclick the command button the records r transferred 2 the grid
i also have custom paging, the paging shld ocur as many times i clcik the command button
i have used updatepanel with the command button in it so that partial postback ocurs or there is no page flicker , but when i use update panel i get teh records in the grid but custom page is not working . it has no affect even if the records are added
if i remove update panel the paging works properly how do i manage it with update panel
View 2 Replies
May 26, 2010
I am using an update panel in my ASP.NET code. My problem is very simple and straight forward.
There is button which send some group SMSs to different users.
I used update panel to show UpdateProgress on my page.
On click of the button I wish to hide the button and some other labels on the page.
The problem is that after clicking the button everything else works find but these control's state does not change.
Funny thing is when i click the button, it does some checks and update a label text with error resultant values, if error is there. It works fine.
But after removing the error, I click the button once again to do the processing. Then everything on code works fine, but the label which was showing doesnot hide.
Code is as follows:
ASP.NET page code:
[Code]....
Server side code:
[Code]....
View 15 Replies
Apr 26, 2010
how would i do my Gridview delete command like a update command?
im using a datasource... and my delete command is like my update command... so i can change the status into "INACTIVE"...
DeleteCommand="UPDATE ACCOUNT_MAINTENANCE SET am_status = 'INACTIVE' WHERE (accmain_no = @accmain_no)"
UpdateCommand="UPDATE [ACCOUNT_MAINTENANCE] SET [account_type] = UPPER(@account_type), [min_deposit] = @min_deposit, [min_capital] = @min_capital WHERE [accmain_no] = @accmain_no"
when i press my delete command at gridview... the status changed into "INACTIVE" but when i refresh or press f5... it automatically update the status into "INACTIVE" also...
View 3 Replies
Sep 3, 2010
It's possible change the DefaultValue of Parameter with javascript?
View 6 Replies
May 29, 2010
I am facing a critical condition wherein I have a web page and a User control within it.I need to set the value of two labels in the user control using values collected on the server side.However whatever I do on the server side or client side I do see on the webpage although I can see in the code that it is being set.So Now I am just sending the value from the server side and setting it on the client side.I am sending from server side using,
if(rowcnt > 0 && rowcnt1 > 0 && (selectedh != string.Empty))
ScriptManager.RegisterClientScriptBlock(this.updMainTable, typeof(string), "test1", "showRehabMain('"+val+"')", true);
[code]...
View 2 Replies
Feb 22, 2010
I need to render a chart control inside UpdatePanel, I have done this part.
The difficult part is that now I need to pass parameter/parameters to server side and grab it in code-behind
so that I can use this information to render the chart.
The parameter/parameters can only be grab in client side by javascript since it is jQuery.data().
I am trying to work around this by saving it to a hidden field, that is not neat though.
View 4 Replies
Apr 28, 2010
I would like to execute a stored proc that simply updates a record. At this point I would like to keep it parameter less. But in future, I will be adding parameters to the stored proc. Can I simply do it via SQLDataSource? It will save me writing few lines of code to execute stored proc in a traditional ado.net.
View 1 Replies
Sep 5, 2010
We have two update panels on our webpage. Now first update panel is having button cancel. While second update panel is having a file upload control.
Now if the user uploads a file that is going to upload in about 2 mins, and in between, say after 30 seconds the user clicks the cancel button, the upload taking place in update panel 2 should stop.
How do we achieve this ?
View 2 Replies
Jan 9, 2010
I have a details view that is bound to a sqldatasource. The datasource has some extra parameters besides the updated data on the screen, they are;
[Code]....
I am want to take the old values of the details view from the detailsview1_itemupdating event and add them as a parameter to my sqldatasource.
[Code]....
So how can I then add this as a parameter to my sqldatasource?
View 2 Replies
Jan 22, 2010
i'm beginning with a little question. So i have this scenario
[Code]....
So i have a Linq object named TCategory. When the user wants to edit this object he will have 2 fields id and categoryName and when he press update the UpdateCategory function will receive an already made object of TCategory type storing the data user has typed. The problem is that i also want to let the client to change the id of the object so i need to pass to the function the actual Id and the TCategory object. How can i do this?
[Code]....
View 1 Replies
Oct 13, 2010
I'm trying to figure out if it's possible to use an ObjectDataSource Update method with a table-valued parameter. Here's my ODS:
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
DataObjectTypeName="TestProject.MyTestDataTable"
SelectMethod="GetTestData" TypeName="TestProject.BLL.TestBLL"
OldValuesParameterFormatString="original_{0}"
UpdateMethod="UpdateTestData">
<SelectParameters>
<asp:Parameter DefaultValue="65" Name="testId" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>
I bind this to a GridView but I'm not looking to edit row by row. Instead my GridView has a bunch of TemplateFields with textboxes. I also have a Button that when pressed, invokes the Update method of the ODS. So then the "UpdateTestData" function in my TestBLL is called. This looks like this:
public void UpdateTestData(MyTestDataTable dt)
{
QueriesTableAdapter qta = new QueriesTableAdapter();
qta.UpdateTestData(dt);
}
At run-time in debug, it seems like the object for the signature above is not populated with the data from my GridView.
View 1 Replies
Jul 4, 2010
in a grid view i have a checkbox column ,which is making checked based on the char value from the SQL DB.
In SQL DB field type is char(1).
My requirement is , need to pass "Y" if checkbox is true ,and "N" if checkbox is false.How to pass that parameter in an update statement.
How it is possible?I used the parameter like as follows.But it is giving me an error when i click update.Groupid parameter is working perfect.The error is coming from the "HPermission" parameter.
<asp:BoundField DataField="GroupID" HeaderText="GroupID" InsertVisible="False" ReadOnly="True" SortExpression="GroupID" />
<asp:TemplateField HeaderText="Hud" >
<ItemTemplate>
<asp:CheckBox ID="chkStatus1" runat="server" AutoPostBack=false
Checked='<%# Convert.ToBoolean(Eval("HPermission").ToString().Equals("Y")) %>'
/>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
UpdateCommand="exec [dbo].[GridUpdDel] @GroupID,@HPermission,'UPDATEPERMISIION',0,'',''" >
<UpdateParameters>
<asp:Parameter Name="GroupID" />
<asp:Parameter Name="HPermission" />
</UpdateParameters>
View 3 Replies