I have a form that shows simple table and let the user select a row. when user select a row the record shows in a formview below the gridview. After I update the formview changes take place in database but shows in gridview ONLY the next time I load the page.
[Code]....
I want delete, edit, select items is in grid view i have to do in c# code it will reflect to database also
View 3 RepliesI have a parent gridview5 with child gridview 6, today i deployed it to our dev server and on that server we have alot more records, so for the nested gridviews i need to enable paging on the parent gridview5. Doing so works fine, until i make a selection within the child gridview6, once any selection is made, and i try to page the page throws an error, i have the following bound to the parent gridview5.
[Code]....
[Code]....
I have Edit / Delete / Select buttons enabled on my gridview.. Originally i had added the code to change the BackColor when you made a selection.
But now as the edit and delete functions are being completed.. i need to enable that coloring regardless which linkbutton you select.. As long as something on that row is selected, then i need to change it.
I have this within my SelectedIndexChanged event
[Code]....
I am using a from view for data entry. I need to verify that a check box is true or false after editing a record.
I have been accessing label text using the following|
CType(FormView1.FindControl("RespDeptLabel"), Label).Text
How can I access the state of a checkbox in the form view to determine if it is true or false
I have a Gridview with a parameterized SQLdatasource. I want the Gridview to be filter when the a selection is made from the dropdown list Here is what I have. I am missing something.
<asp:SqlDataSource ID="SqlDSAlbums" runat="server"
ConnectionString="<%$ ConnectionStrings:Default %>"
SelectCommand="SELECT Album.Album, genre.Genre, Band.Band, Album.year, Album.AlbumUID FROM Album INNER JOIN Band ON Album.BandUID = Band.BandUID LEFT OUTER JOIN genre ON Album.GenreUID = genre.GenreUID WHERE (genre.Genre = @Genre) OR (genre.Genre <
'ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ') ORDER BY genre.Genre, Band.Band"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>">
<SelectParameters>
<asp:ControlParameter ControlID="ddlGenre" Name="Genre"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDSGenre" runat="server"
ConnectionString="<%$ ConnectionStrings:Default %>"
SelectCommand="SELECT Genre, GenreUID FROM genre Order by Genre"></asp:SqlDataSource>
Select a Genre
<asp:DropDownList ID="ddlGenre" runat="server" DataSourceID="SqlDSGenre"
DataTextField="Genre" DataValueField="Genre" AppendDataBoundItems="True"
AutoPostBack="True">
</asp:DropDownList>
<asp:GridView ID="gvAlbum" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDSAlbums">
<Columns>
<asp:BoundField DataField="Album" HeaderText="Album" SortExpression="Album" />
<asp:BoundField DataField="Genre" HeaderText="Genre" SortExpression="Genre" />
<asp:BoundField DataField="Band" HeaderText="Band" SortExpression="Band" />
<asp:BoundField DataField="year" HeaderText="Year"
SortExpression="year" />
<asp:TemplateField HeaderText="Comments">
<ItemTemplate>
<asp:HyperLink ID="hlToComments" HeaderText="Comments" runat="server" NavigateUrl='<%# String.Format("ViewComments.aspx?AlbumUID={0}", Eval("AlbumUID")) %>' Text="Click Here" />
</ItemTemplate>
</asp:TemplateField>
Query 1 - Grid View: - I have an excel sheet which I import into gridview at runtime. For excel sheet import, I have a fileupload dialog box and an asp.net button control which when clicked imports the sheet contents into a gridview. The problem is I have my fileupload box and button control in a page called Default.aspx and I need the gridview get displayed maximized in a new page called Default2.aspx.
Also, I need to specify the row number of the field titles from the excel sheet dynamically at runtime so that the gridview appends any new field/column from that row on. The excel sheets I use contain complex formatting. Is there anyway to display the excelsheet contents as they have been defined and formatted?
Query 2 - Sessions: - I add nodes to my treeview dynamically at runtime. Since HTTP is a stateless protocol, the changes which I do remain only for that session. How do I append the changes I do to the treeview simultaneously in the code?
- I have appended 2 extra columns into the excel sheet generated gridview which take input through dropdownlistbox control at runtime. How do I update and retain those changes in the gridview?
I am using a grid form to diplay data... the insert form is completely a separate form. In the insert form a text box called "FormPercentageTextBox" is getting a calculated result using javavascript based on some field ( field1,field2) values (val1, val2).
the problem i have is: when i edit the form and i want to update any value..i want the new calculation result showing on the edited "FormPercentageTextBox" field. I need to have this calculation reflected/
im having difficulty with a project I'm working on. The project has many data tables however it's three that im concerned with. The tables are applicants, position applied for and positions. In one part of the project I have created a formview which inserts users to our applicants table. This is working fine however now I want the option within the formview for users to be able to select from a checkbox list the positions that they are applying for. I want to pull data from the positions table and the current formview and insert that information to the position applied for table. The primary key for "Applicants" is CSVC, PK for "Positions" Table is PositionID, Key for "Position applied for" is CSVC and PositionID.
View 5 Repliesi have create a simple form using form view...
in my form i have use DropDownList..(Id = DropDownList1)
when am trying use that dropdownlist in my cs page i can't get id..
I have a form view with a couple of text boxes on them. I want to make the text values available elsewhere on the form I have been trying
Are they any special Insert Paramters I shoud/need to use on a formView. I currently have the below datasource but when submitted it only inserts <NULLS> intot he required table.
[Code]....
The fields that aren't being inserted are already pre-populated via the following used FormViews:
[Code]....
The following works fine and is how I expect:
[Code]....
[Code]....
I want to add a formview on the page using C# code.
View 1 RepliesI am trying to use this query in a form view "Select * from actions where emp_id = " & session("emp_id") for the select command. This is the format I am used to in classic asp. How can I acheive the same results in asp.net.
View 2 Repliesi have a problem with forms authentication. i have a website and want to restrict access to an especific folder. i want the access to this folder be made via the login form this is what i have in the web.config
<authentication mode="Forms">
<forms name="Compra" loginUrl="wfLogin.aspx" path="/" protection="All" timeout="30" />
</authentication>
<authorization>
<allow users="*"/>
</authorization>
Then this to restrict folder
<location path="Admin">
<system.web>
<authorization>
<deny users="*"/>
</authorization>
</system.web>
</location>
the problem is that when the user login with valid information the website return to the login form.
I am using a "Detail View" to edit the data in my "Customer" table. The fields are "CompanyName", "ContactPerson", "StreetAddress", and "City". If I type data into the first field ("CompanyName") and then press the "tab" key, control moves to the second field "ContactPerson". However, if I type data into the first field ("CompanyName") and then press the "Enter" key, instead of control moving to the second field ("ContactPerson") the program closes the form.
Is there someway that I can control the action of the "Enter" key so that this will not happen?
Also, is there any way that I can have control move from the first field ("CompanyName") to a field other than the seconc field ("ContactPerson") if the content of the "CompanyName" field contains the value "Internal"?
I have a database with a 1 to many relationship in SQL Server 2008. I have created a formview in VS2008 to insert records into the child table. However I can't set the foreign key to automatically insert this value. If I manually type in a value the insert works but I need it to pick up the fk ID automatically from the master table. How can I do this?
The master table: tblTopic has ID int auto increment primary key and the child table has ID int auto increment primary key and TopicID int allow duplicates no nulls, foreign key. I have set updates to cascade in the relationship.
My insert statement is INSERT INTO tblTopic (TopicID, Comment, SubmittedBy) VALUES (@TopicID, @Comment,@SubmittedBy). The TopicID keeps throwing the error, this is the foreign key.
This is the first time I have tried to do this, so apologies if it's really obvious but I'm on a bit of learning curve.
I have a formview that runs of an SQLDS, very simple stuff. Inside that form i have various fields, one of them is a credit field, one of them is a debit field. Now i have put a radio button list with two radio buttons (credit and debit). What i want to do is when the "credit" radio button is enabled i want the "credit" text box to be enabled and visa versa.
I know how to reference an object inside a formview, but i am confused, do i reference the radio button list and then the list items inside it or?
Once again something for a new bee... I have 3 questions -
1. I wanted to add a drop down list instead of a text box to my grid control (which should come up on clicking editing)
2. Similar control for form view
3. On click "select" in a grid view, I want to open a new web page which will show a form view attached with the same "select" index.
I need to do a custom update for a form view (I think/know), as some of the parameters that are required for updating values should not be updated by the users, such as userid of the person performing the action which is passed back to the database for auditing purposes.
Additionally, there are some fields, such as LastUpdatedBy, LastUpdatedDate that need to be seen, but not edited. The stored procedure on the backend takes care of this, and these are not parameters for the Update method. The FormView by default is trying to pass all these values back to the database.
Lasty, the select query of the object datasource is a stored procedure that performs several joins based on PF/FK relationships to bring back more meaningful information than just a FK, so some columns are just the joined value, and can not be updated directly. Again, formview is trying to pass these parameters
So given that, I have defined the following even handler for a simple form view:
(not sure if this is the way to proceed given the above, but...)
protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
ProjectDetailsDataSource.UpdateParameters.Clear();
ProjectDetailsDataSource.UpdateParameters.Add("projectID", ((Guid)e.Keys["ProjectID"]).ToString());
ProjectDetailsDataSource.UpdateParameters.Add("projectName", (string)e.NewValues["ProjectName"]);
ProjectDetailsDataSource.UpdateParameters.Add("description", (string)e.NewValues["Description"]);
ProjectDetailsDataSource.UpdateParameters.Add("projectTypeID", "1");
ProjectDetailsDataSource.UpdateParameters.Add("statusID", "1");
ProjectDetailsDataSource.UpdateParameters.Add("productID", null);
ProjectDetailsDataSource.UpdateParameters.Add("isComplete", ((bool)e.NewValues["IsComplete"]).ToString());
ProjectDetailsDataSource.UpdateParameters.Add("isActive", ((bool)e.NewValues["IsActive"]).ToString());
ProjectDetailsDataSource.UpdateParameters.Add("userid", Membership.GetUser().ProviderUserKey.ToString());
ProjectDetailsDataSource.Update();
FormView1.ChangeMode(FormViewMode.ReadOnly);
e.Cancel = true;
}
My questions are as follows:
1) Is this the right approach?
2) Is so, when I cancel the edit (because I did the update myself), and change mode, the FormView returns to read only mode as inteneded (good so far). However, when I hit F5 (refresh), the ItemUpdating method is called again, and updates the database.
how to call AJax rating control in Form view ?
I have 1 rating control in fromview in code behid page i wan to call Ajax rating contrl in formview for determine event and property .
I am new to working with the Form View control so I am not quite sure how to do this.
I want my users to be able to enter search criteria into text boxes at the bottom of my FV just beneath a table and then click a button to initiate a DB search and rebind of the form.
Where do I create/ access the button's event handler to make this happen ?
I would like to have buttons in the Item template and possibly the edit template sections of the FV.
So I have created my buttons and now I want to access their button click events.
Here is my meager start this is located in the Formview databound event:
[Code]....
I have two gridviews, say 'A' and 'B'...I want to add all the rows of 'A' to 'B' while avoiding the duplicates....For eg:
View 10 Replieshow can i show only the last INSERTED data entry made in SQLSERVER? And show that entry in a gridview but not all of the entries at once only the last one made.
View 1 Replies