Jump to content
xisto Community
Sign in to follow this  
Followers 0
dhanesh1405241511

Gridview Doesnt Update After Deleting A Value

By dhanesh1405241511, in Programming

Recommended Posts

dhanesh1405241511    0

dhanesh1405241511
Posted

I have a gridview i managed to update using the edit option in the smartmenu. The problem comes when i delete a value or make a value read only.

Say i have a table Employee with the following columns : EmpID, Emp Name, Password, Emp Type.

Now when i remove the value EmpID, the gridview does not update. it just reloads when i hit update but no changes are made.

On the other hand say i make Emp Type as Read only, when i update .. the gridview updates, but the value of Emp Type updates as blank. While editing other values, the value of Emp Type that i made readonly shows correctly. But after i hit update and the values get sent to the DB in access, the field Emp Type updates as blank.

Is there any solution to this ? This is my code for the Employee update page:

<%@ Page Language="VB" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.OleDb" %><script language="VB" runat="server">	Protected Sub btlogout_Click(ByVal sender As Object, ByVal e As System.EventArgs)		FormsAuthentication.SignOut()		Response.Redirect("Default.aspx")	End Sub</script><html xmlns="http://forums.xisto.com/no_longer_exists/; ><head runat="server">	<title>Origin TimeSheet :: Edit Details</title>	<link rel=stylesheet type="text/css" href="styles.css"></head><body bottommargin="0" leftmargin="0" marginheight="0" marginwidth="0" rightmargin="0" topmargin="0" bgcolor="#EAEAEA">	<form id="form1" runat="server">	<center><table border="0" style="border: 2px solid #565656; border-top: 0px" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" height="100%" width="777">	<tr>		<td><!-- logo image --><img src="images/logo.jpg" border="0" width="232" height="106" alt=""><!-- end logo image --><img src="images/header.jpg" border="0" width="279" height="106" alt=""><img src="images/header1.jpg" border="0" width="267" height="106" alt=""></td>	</tr>	<tr>		<td background="images/menu_back.gif" style="height: 42px">			<table border="0" width="100%" cellpadding="0" cellspacing="0">				   <tr><!-- menu starts here -->					   <td width="16%" align="center"><a href="user_welcome.aspx" class="menu">Home</a></td>					   <td><img src="images/menu_d.gif" border="0" width="2" height="29" alt=""></td>					   <td width="16%" align="center"><a href="user_addtime.aspx" class="menu">Add TimeSheet </a></td>					<td><img src="images/menu_d.gif" border="0" width="2" height="29" alt=""></td>					   <td width="16%" align="center"><a href="user_edittime.aspx" class="menu">Edit TimeSheet </a></td>					<td><img src="images/menu_d.gif" border="0" width="2" height="29" alt=""></td>					   <td width="16%" align="center"><a href="" class="menu"><span style="color: greenyellow">Edit Details </span></a></td>					<td><img src="images/menu_d.gif" border="0" width="2" height="29" alt=""></td>					   <td width="16%" align="center"></td>					<td></td>					<td width="16%" align="center"></td>					<td style="padding-right: 80px"></td>				   <!-- menu ends here -->				</tr>			   </table>                          			                       			                       			                       			                       			                       			                       			                       			                      			                  			<asp:Button ID="Button1" runat="server" Font-Bold="True" ForeColor="Red" OnClick="btlogout_Click"				Text="Logout" /></td>	</tr>	<tr>		<td height="100%" valign="top" style="text-align: center">			<br />			<span style="font-size: 14pt">				<br />				<span style="font-size: 16pt; color: tomato; font-family: Trebuchet MS"><strong>Edit					your Details<br />				</strong></span> <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False"					DataKeyNames="UserID" DataSourceID="AccessDataSource1" Height="50px" Width="125px">					<Fields>						<asp:BoundField DataField="Type" HeaderText="Type" HtmlEncode="False" ReadOnly="True"							SortExpression="Type" />						<asp:BoundField DataField="UserID" HeaderText="UserID" ReadOnly="True" SortExpression="UserID" />						<asp:BoundField DataField="UserName" HeaderText="UserName" SortExpression="UserName" />						<asp:BoundField DataField="Password" HeaderText="Password" SortExpression="Password" />						<asp:BoundField DataField="RealName" HeaderText="RealName" SortExpression="RealName" />						<asp:CommandField ShowEditButton="True" />					</Fields>				</asp:DetailsView>				<asp:AccessDataSource ID="AccessDataSource1" runat="server" ConflictDetection="CompareAllValues"					DataFile="~/App_Data/origin_timesheet.mdb" DeleteCommand="DELETE FROM [Employee] WHERE [UserID] = ? AND [UserName] = ? AND [Password] = ? AND [RealName] = ? AND [Type] = ?"					InsertCommand="INSERT INTO [Employee] ([UserID], [UserName], [Password], [RealName], [Type]) VALUES (?, ?, ?, ?, ?)"					OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Employee] WHERE ([UserName] = ?)"					UpdateCommand="UPDATE [Employee] SET [UserName] = ?, [Password] = ?, [RealName] = ?, [Type] = ? WHERE [UserID] = ? AND [UserName] = ? AND [Password] = ? AND [RealName] = ? AND [Type] = ?">					<DeleteParameters>						<asp:Parameter Name="original_UserID" Type="Int32" />						<asp:Parameter Name="original_UserName" Type="String" />						<asp:Parameter Name="original_Password" Type="String" />						<asp:Parameter Name="original_RealName" Type="String" />						<asp:Parameter Name="original_Type" Type="String" />					</DeleteParameters>					<UpdateParameters>						<asp:Parameter Name="UserName" Type="String" />						<asp:Parameter Name="Password" Type="String" />						<asp:Parameter Name="RealName" Type="String" />						<asp:Parameter Name="Type" Type="String" />						<asp:Parameter Name="original_UserID" Type="Int32" />						<asp:Parameter Name="original_UserName" Type="String" />						<asp:Parameter Name="original_Password" Type="String" />						<asp:Parameter Name="original_RealName" Type="String" />						<asp:Parameter Name="original_Type" Type="String" />					</UpdateParameters>					<SelectParameters>						<asp:SessionParameter Name="UserName" SessionField="S2" Type="String" />					</SelectParameters>					<InsertParameters>						<asp:Parameter Name="UserID" Type="Int32" />						<asp:Parameter Name="UserName" Type="String" />						<asp:Parameter Name="Password" Type="String" />						<asp:Parameter Name="RealName" Type="String" />						<asp:Parameter Name="Type" Type="String" />					</InsertParameters>				</asp:AccessDataSource>				</span></td>	</tr>	<tr>		<td background="images/footer.gif" height="38">			<table border="0" width="100%" cellpadding="0" cellspacing="0">				   <tr>					   <td width="50%" style="padding: 5px; color: #ffffff">All Rights Reserved 2007 :: Origin</td>					   <td width="50%" style="padding: 5px" align="right">				   </tr>			 </table>   		</td>	</tr>	</table></center>	<div>		<a href="user_welcome.aspx">Home</a><br />		<a href="user_addtime.aspx">Add</a><br />		<a href="user_edittime.aspx">Edit Time</a><br />		<a href="user_myedit.aspx">Edit Deatils</a></div>		<br />		<br />		<asp:Button ID="btlogout" runat="server" OnClick="btlogout_Click" Text="Logout" />			</form></body></html>

Really Really need help in this guys,
Thanks and regards in advance.
Dhanesh.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0
Go To Topic Listing
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

  I accept