I have a form that has a detailsview. In that detailview I have and edit button that is visible only when a condition is met. I made the edit command field a template to achive this. My Question is can I have multiple conditions that make the edit button visible. Attached is my current linkbutton with the current variable.
[Code]....
I am using access database with asp.net C# page.
I have multiple amounts that I need to display and edit. I am trying to understand the best way to do this..
In MSAccess:
Should I define them as currency or number?
ASP.net
if I use formatting for the field as {0:C}, it works fine in View mode. However, i am unable to update the field in Edit mode for an amount with decimal places. In Edit mode, I can only enter whole numbers(ex: I can enter 123, but not 1.23).
If I set the ApplyFormattingInEditMode=True, I am unable to save data entered in any format($123.23, 123, 123.23, all of them cause the error).
The error I am getting is "Input string is not in a correct format".
I have a problem that is driving me insane. I have a simple detailsview that operates as you would expect a detailsview to do - the only difference being that in the updated event I send an email to various people to advise of detail changes (I have conditional testing to do this).
The problem is that if the user goes crazy with left clicking the update button, email recipients can receive multiple duplicate emails.
I have looked all over the net and seen many varied solutions for this problem - mainly using javascript - but none of them seem to be able to block multiple clicks without disabling or hiding the update button - which obviously causes issues with client side validation in the event that information is missing or incorrect.
I have a vb.net page that has a editable detailsview. When a user wants to erase the data for a field, they highlight the data, and delete/backspace over it, and click update. However, the original data is still saved. If they are replacing the current data with new data, that works fine and updates/saves correctly. This problem only happens when the current data needs to be removed.
View 6 RepliesI'm thinking of using a modal pop up control that would have a details view in it. I currently have a details view that uses CSS Friendly control adapters with the CssSelectorClass attribute. Can I use the CSS friendly CssSelectorClass property with a details view in the modal pop up and style it as I'm currently doing with my Details View?
View 1 RepliesI have on a page a gridview that can be filtered with one text box. I set up the gridview to show select and wanted to then connect a details view so that when you selected a row the entire details would show up. When I run it I get this error. Data keys must be specified on GridView 'GridView1' before the selected data keys can be retrieved. Use the DataKeyNames property to specify data keys.
<%@ Page language="C#" masterpagefile="MainContent.master" title="Electrical Storage" EnableEventValidation="false" %>
<asp:Content id="Content1" runat="server" contentplaceholderid="Content">
<div id="Rightside">
<h2>Search Electrical Storage
</h2>
<li><a href="EStorageResultsAll.aspx">View All Files</a></li>
<li>Specify Projects to View</li>
<br />
<br />
<form>
Search: <asp:TextBox id="Search" runat="server"></asp:TextBox>
(% is wildcard)<br /><br />
<asp:Button runat="server" Text="Search" id="Button1"
PostBackUrl="electrical_storage.aspx" Height="26px" BackColor="#000066" ForeColor="White" Width="129px"></asp:Button>
<br />
<hr />
<asp:GridView id="GridView1" runat="server" AutoGenerateColumns="False" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" DataSourceID="AccessDataSource1" ForeColor="Black" Width="820px" AllowSorting="True">
<RowStyle BackColor="White" />
<Columns>
<asp:commandfield ShowSelectButton="True">
</asp:commandfield>
<asp:boundfield DataField="CoID" HeaderText="Co ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Add Info" SortExpression="FileAddInfo" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location" Visible="False">
</asp:boundfield>
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000066" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT [CoID], [ProjClass], [Project], [FileName], [FileAddInfo], [FileNumber], [BoxNumber], [Location] FROM [FilesWithLocation]
WHERE (([CoID] LIKE '%' + ? + '%') OR ([ProjClass] LIKE '%' + ? + '%') OR ([Project] LIKE '%' + ? + '%')OR ([FileName] LIKE '%' + ? + '%')OR ([FileAddInfo] LIKE '%' + ? + '%')OR ([BoxNumber] LIKE '%' + ? + '%'))">
<SelectParameters>
<asp:controlparameter ControlID="Search" Name="CoID" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="ProjClass" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="Project" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileName" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileAddInfo" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileNumber" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="BoxNumber" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource id="AccessDataSource2" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT * FROM [FilesWithLocation] WHERE ([SearchString] = ?)">
<SelectParameters>
<asp:controlparameter ControlID="GridView1" Name="SearchString" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:DetailsView id="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="AccessDataSource2" Height="50px" Width="442px">
<Fields>
<asp:boundfield DataField="CoID" HeaderText="Company ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Additional Info" SortExpression="FileAddInfo">
</asp:boundfield>
<asp:boundfield DataField="PeriodBegin" DataFormatString="{0:d}" HeaderText="Period Begin" SortExpression="PeriodBegin">
</asp:boundfield>
<asp:boundfield DataField="PeriodEnd" DataFormatString="{0:d}" HeaderText="Period End" SortExpression="PeriodEnd">
</asp:boundfield>
<asp:boundfield DataField="FileType" HeaderText="File Type" SortExpression="FileType">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber">
</asp:boundfield>
<asp:boundfield DataField="SearchString" HeaderText="Search String" ReadOnly="True" SortExpression="SearchString">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location">
</asp:boundfield>
</Fields>
</asp:DetailsView>
</form>
</div>
</asp:Content>
<asp:Content id="Content2" runat="server" contentplaceholderid="head">
<style type="text/css">
table {
width: 820px;
}
.gridview {
width: 820px;
position: fixed;
}
</style>
</asp:Content>
I have a details view that appears when record is selected in a GridView. Can this details view be opened in it's own modal window that would allow me to use the full event model?
View 3 RepliesI have some problems trying to query my database. The problem is that I'm not sure how to multiple join tables in my database.
tables to make it easier:
[code]....
What I'm supposed to do is to find all the teachers (predavac) who were teachers on the specific activity (aktivnost) and who had specific attendee (polaznik). The problem is I'm not sure how to do multiple joins on this one.
i create view in sql server and execute a select query using AND operator on it using vb.net and bind data with gridview...but i am not getting result in grid
View 3 RepliesI have a gridview which display when person start n stop the project if same person do muliple projects it save n retrives eaisly i want to do that when i press select in gridview it give me the all about the person means if ali is working on 2 projects so it give me details like ali firsrt project is this time n date this , second project is this how can i do this ?
View 1 RepliesI am trying to edit and update a selected users details, following the tutorial [URL]
I get the following errors in the Error List in VS 2010:
Error 6 'Comment' is not a member of 'System.Security.Principal.IPrincipal'. C:projectsFPOS_v2FamilyAdminedit_user.aspx.vb 21 9 C:projectsFPOS_v2
Error 5 'Email' is not a member of 'System.Security.Principal.IPrincipal'. C:projectsFPOS_v2FamilyAdminedit_user.aspx.vb 20 9 C:projectsFPOS_v2
Error 2 'FamilyAdmin_edit_user.Private Sub DeleteUser(sender As Object, e As System.EventArgs)' is not accessible in this context because it is 'Private'. C:projectsFPOS_v2FamilyAdminedit_user.aspx 140
Error 1 'FamilyAdmin_edit_user.Private Sub UnlockUser(sender As Object, e As System.EventArgs)' is not accessible in this context because it is 'Private'. C:projectsFPOS_v2FamilyAdminedit_user.aspx 138
Error 7 'IsApproved' is not a member of 'System.Security.Principal.IPrincipal'. C:projectsFPOS_v2FamilyAdminedit_user.aspx.vb 22 9 C:projectsFPOS_v2
Error 8 'UnlockUser' is not a member of 'System.Security.Principal.IPrincipal'. C:projectsFPOS_v2FamilyAdminedit_user.aspx.vb 88 9 C:projectsFPOS_v2
Error 4 Property 'User' is 'ReadOnly'. C:projectsFPOS_v2FamilyAdminedit_user.aspx.vb 11 9 C:projectsFPOS_v2
The code for the edit_user.aspx is:
[Code]....
The code for the edit_user.aspx.vb is which is where I am getting the error:
[Code]....
The problem is with the User. But I don't know how to sort this as im new to all this.
I'm trying to get a record to show up in a details view as part of a Master Details. I was able to get this to work by setting the visibility to true for the Details View in the Page Load event. I now want the details view to show up when the Select button is clicked in the GridView's template field using the onClick event for the button. I don't seem to be assigning the correct properties to get this to work though. what property I should use with this? I know I have to get it from the GridView and assign it to the details but haven't gotten it to work. this is the GridView:
[Code]....
Is it possible to have multiple conditions in an SQL select command. I have an SQL Table with the follwing filds.
Image1
Image1Approved
Image2
Image2Approved
Etc
Image1 is a varchar(50) and stroes the picture name. Image1Approved is a tinyint (0 = Pending, 1 = Declined & 2 = Approved) I am using the following to query the SQL database.
SelectCommand="SELECT Image1, Image1Approved, Image2, Image2Approved, Image3, Image3Approved FROM UserProfiles WHERE (UserId = @UserId)"
The part that I am stuck on is only returning the images that have there associated approved condition set. I know how to do this with a seperate select command for each image but can this be done for all image files in one statement.
my grid view is connecting to the db. but now i cant do eding when i click on it it just dont do the new values. here is my code:
[Code]....
I have a field in a details view shown below
<asp:BoundField DataField="DTMON_F" HeaderText="Monday Hours From: " InsertVisible="False"
ReadOnly="True" SortExpression="HOURS" Visible="false" />
<asp:TemplateField HeaderText="Monday Hours From: " SortExpression="HOURS">
<EditItemTemplate>
<uc1:TimePicker ID="tpMondayHours" runat="server"/>
</EditItemTemplate>
<InsertItemTemplate>
<%-- <uc1:TimePicker runat="server" ID="tpMondayHours" />--%>
<asp:TextBox ID="txtMondayHours" runat="server" Text='<%# Bind("DTMON_F") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblMondayHours" runat="server" Text='<%# Bind("DTMON_F") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
Before "DTMON_F" is binded to the view I want to cut the string that is returned...Where and how might I do this?
i have a DatagridView which contains 5 columns. The Fifth Column can contain a number or a NULL value .
I need to edit the DataGrid it in such a way that the fifth column is hidden everytime.
And on a specific condition that if fifth column is not null , then display the value which is present in fifth column ,in a small subscript below the the corresponding element in first column .
i have a gridview inside an edittemplate formview control in a master/detail scenario
so in the formview i have some comboboxs/datepicker/..etc corresponding to the master table
and a gridview corresponding to the detail table
in this gridview i enabled multi editing of rows like in this article[URL]
the problem is that even i change the values on the gridview , if i click the update button of the formview the "details table" changes isn't submited to the database
My grid view had tomany item in my website,it showing Horizontal scrool bar how to avoid this scrool bar or how to split Grid view after clicking the row editing templete.
View 2 RepliesIn my gridview i click the select button next to a row of data and it pops up a detailsview of that selected row. Also i created button in the details view that closes it. And below is the source code inside the detailsview for how i did that and also the code behind. Since i created it this way where i set the detailsview1.visible = false, when it closes it doesn't pop back up when i click the select button again, and that's exactly what i want it to do is pop up when i click the select button on the gridview.
<asp:TemplateField HeaderText="QuickDetails" HeaderStyle-ForeColor="White" ItemStyle-HorizontalAlign="Right" HeaderStyle-BackColor="#5D7B9D">
<ItemTemplate>
<asp:Button ID="btnClose" runat="server" Text="X" OnClick="CloseDetailsView" />
</ItemTemplate>
</asp:TemplateField>
Protected Sub CloseDetailsView(ByVal sender As Object, ByVal e As EventArgs)
DetailsView1.Visible = False
End Sub
I have a detailsview which has two ajax toolkit text editors and can take several seconds to load. I would like to display a spinner graphic while the detailsview is loading as it can also reload if the values of a dropdownlist inside the detailsview are changed. I had it working using an update panel and updatePanelAnimation but the problem is that the form has a file upload and it won't post the image from inside an update panel. I have the spinner inside a div element and I've been trying Page.Init, Page.LoadComplete and the like to try to display the spinner while the page is loading and hide it when the page has loaded. Can I somehow hook these up to the detailsview to display a spinner while it's loading?I'm also having a similar problem with a page of FileUploads. I would like to display a loading graphic while files are uploading but it's using FTP to upload the files and I can't find any way to do this.
View 1 RepliesI have a details view that's part of a master/details scenario. When a record is selected it shows the details view. The Pay Status field is a label at this point, when the details view is in read only mode. But then when the edit button is clicked the Pay Status is a DDL that has it's items list populated declaratively.
I want the DDL to default to the text value of the label. This will be hourly or salary. This way if the user doesn't change it's value it will push the correct value to the db.
I tried something with the PreRender event but couldn't get it to work out. Below is what i have so far I wasn't sure how to assign the text property of the label or bind to the label to get the value and set that for the DataTextField.
[Code]....
[Code]....
I have on one page a grid view that has a a delete bit and create new form, these both work. when the user clicks the edit button/link the id for that field is thrown in the url to a new page with a details view on with its default mode to "Edit". I have a stored procedure to update the SQL dB which works when run in SQL. however when the values are chaged in the details view, I click the update button and it says that it has succesfully updated and throws no errors... It has not?
I think the problem is getting the new values out of the details view. which i have been doing like this...
TextBox _AddressContactName = (TextBox)DetailsView1.FindControl("AddressContactName");
string s_AddressContactName = _AddressContactName.Text;
This gives me what the value that it was before editing and the same as in the dB, this is why i'm getting a successful bool value for the stored procedure. My question is this... how do i get the values after its been changed in the details view?
I have 2 DetailsView controls- dvPerson, dvVehicle - that are bound to datasets at RUN TIME. When a person is selected in dvPerson, dvVehicle should filter to show vehicle info only for that person.
View 7 RepliesCan I customize details view to look differently. If so how?
View 3 Replies I have written in the old ASP for year and just started two weeks ago with .net, It has taken some adjustments. I am learning using Web Dev Express. Anyway, Here is my question.
I am learning by creating a simple progam to track boxes associated with cases(litigation) IE Smith v Smith case has files in 3 boxes.
two tables
[code]....