I have a page which has a GridView on it, which is populated from a database. Some of the columns in the GridView have text boxes, as well as Checkboxes.When the user saves the page, the page may error if they have not entered their data correctly. At this point, I need to re-display what they have entered already so they can simply make the correction instead of having to change everything from scratch again.
View 1 RepliesI have a javascript function below to move from select multiple box A which is populated from database to another multiple select box B, in the event of a postback my values in B which are moved over from A got lost. Initially I thought because I included a "runat="server"" tag for server side actions but apparently it's not the case. I read about Form.Request but ain't have a clue how to go about it. I just need to retain those values in multiple select box B.[code]...
View 1 RepliesWhat i am trying to achieve is that if listbox2 contains checkedlistbox1 items then checkedlistbox1 should retain checked state even after the from is closed and re-opened again.
Since i am saving the checkedlistbox1 values into a Table - is it possible to bind those to retain the checked state even after the from is closed and re-opened again - or it can be done comparing the values from both listboxes [code]...
There are lots of questions about this but I've not been able to solve my problem using the answers to any of them (after many, many attempts..)
I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page.
I want to change the DoNotMail boolean value represented by a Gridview checkbox and automatically update in the database if the checkbox is checked from 0 (False, Will Mail) to 1 (True, Won't Mail) here is the code I used. [code]...
is it possible to do a two way sync on the entire gridview when the user hits a button so you don't have to do an update every time a row is changed? because the user might check the box and then check another box then uncheck a box and it would be a lot of updates...
i have created a dynamic tabpage and a dynamic tablelayoutpanel inside it then added dynamic textboxes and labels inside the tablelayoutpanel...the thing is , i am having a problem on how to access the value of those textboxes and labels and add them as new columns in the new table(tagpage) in mysql database, i can already create the table in the database but i cant add the new columns in it. heres the code for accessing the values of the labels and textboxes
error: NullReferenceException was unhandled....Object variable or With block variable not set.
sql = "alter table " & tbl_selected(counter) & " add " & frmMain.Controls("TLP_" & SecArrList_sp(counter2)).controls.item(SecArrList_sp(counter2) & "label" & counter).Text & " varchar(100) NULL;"
I would like to add controls like textBox in GridView from code on the fly.
In my project i have one Grid in that i can't decide how many rows and columns are there. so that i just give it DataSource. This working fine. [code]...
I have a dynamically-created GridView which to which I'm attaching a handler using the AddHandler command. The problem is that when I try to refer to sender.rows within that function, it won't do anything because it says that sender.rows.count = 0. I've done enough dynamic form creation that I'm pretty sure that I'm creating the controls, binding them, and adding the handler at the proper points during the page init/load load_complete. Also, I have nearly the exact same code-behind on another form that is not dynamic, and it is able to access the values in the rows.
Considering that the RowCommand event is firing, it's clear that I'm clicking on a row. For some reason it's just not in scope for the handler event. Background: What I really want to do is access the values that are databound to the row. I'm creating a SQLCommand and binding that to the dynamic grid, and I would prefer to talk to the grid's datasource, but that doesn't seem to be possible. Perhaps I'm missing something, but for now it seems that reading the values from the GridView (which I hate doing) is the only thing that works.
[Code]...
I have a windows form with a gridview bound to a lisbox. I need to know how to get the field in the gridview with prices to show a total in a textbox, also on the form.
View 3 RepliesI have a variable defined as follows:Dim iRows As List(Of String())I've also been converting that to a list of lists just to make it easier to work with.Dim iRows As List(Of IList(Of String))I would like to bind that list to a GridView using the contents of the nested array/list to dynamically define the columns. I don't know ahead of time how many columns there will be, but I do know that they are all the same throughout the list.
View 2 RepliesI have been trying to modify the data going into a column by adding spacing to the start of the column before the Row ID, using the level to multiply the amount of spaces.Ie. ID is SVG00098 and is a Level 3 Asset, so it requires 6 spaces before the ID.
View 8 RepliesI'm creating a dynamic gridview in vb.net using a connected sql database. Everything works fine except 1 thing: when i click the update command, the event just won't fire no matter what I do. the gridview goes into edit mode and the cancel button works fine. This has cost me over 2 days of googling but none of the solutions work. I used breakpoints to check if the code was executed, but it wasn't. If anybody has any experience in this:I believe the problem lies in the addhandler but it doesn't give any errors.I forgot to mention that the sql command was a test and sets the data in that field to 15, now it's 10, it works when i use a normal button or a static gridview.
Public Class WebForm1
Inherits System.Web.UI.Page
Dim rowscount As Integer = 2
[code]....
I am trying to bind a SQL XML field to my gridview. [code]...
View 2 RepliesI have a gridview with a template field and inside the template field is a checkbox field.My question is how do I capture the event when a checkbox is ticked and how do I reference that row which has been ticked?
View 1 RepliesI have a DevExpress GridView whose cells are painted with a random color based on some condition. Now each color has a meaning and I want to show it as a legend. Number of colors used for each condition may vary.How can I do this. I'm using DevExpress 2009 Vol2, and .Net framework - 2.0 and WinForms?
View 1 RepliesI have a web page with 5 checkboxes and 2 textboxes per checkbox. When the user checks one or more checkboxes the corresponding textboxes become enalbed for UI. I need to insure that the input for the textboxes is an integer-that I will do with a validators. There is a gridView on the same page. When the user checks one or more checkboxes the 2 columns of the gridView rows become active for input through enabled textboxes.
There are 4 columns in the grid. The minimum number of rows enabled are 2 and the maximum are 26. The UI for the grid's textbox input is numbers. Those numbers have to be equal to or less than the total. How do I validate UI of numbers(integers) into the grid's dynamically generated textboxes and then add the total and compare it to the alloted total? I prefer to do this with the code behind - using VB.NET - rather than with ASP.NET or absolutely not javascript.
In the RowDataBound event of an ASP.NET Gridview I am trying to read the value of a Label in a Template Field. I would prefer to capture this value in the RowUpdating Event, but for some reason I seem to recall that it is not possible. Here is the ASP...
<asp:TemplateField HeaderText="Translation" ItemStyle-Width="250" >
<ItemTemplate>
<asp:Label ID="Label11" runat="server" Text='<%# Bind("lang_String") %>' Width="250px"></asp:Label>
</ItemTemplate>
Here is the VB.net code that I am trying to figure out....
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
If (e.Row.RowState And DataControlRowState.Edit) > 0 Then
[code]....
I have some of these events in my gridview custom coded. But the real issue here is that I store a previous record, that is, the record that was being changed, or the old.value and I store it in another column. So when the user enters say "< newValue >" without the quotes, the aspx validator rejects the input as dangerous.
I can disable the validation, and html encode the value as it gets written to the db, but when I display the value back in the gridview in the "Previous Value" column it appears like this...< Neutral > semi-colons missing because this site decodes.How I can encode and decode inline in ASPX?How can I encode this template field that is getting entered into a gridview?
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("lang_String") %>'></asp:TextBox>
</EditItemTemplate>
allow certain html characters to be entered into this field only without turning off validation for the entire site.I do need this to apply to the entire column.
I want to populate a checkbox field in a gridview.
I am using the Checked='<%# Convert.ToBoolean(Eval("Inactive")) %>' statement but the issue that I am facing is that in the database some records contain NULL for Inactive. If it encounters a 0 or 1 value it works fine but if NULL it throws an exception.
Kindly guide me how to populate the checkbox so that it should be unchecked even if the field is null.
I have a gridview that displays a calculated field, based on a db source field it populates with.
can i sort by it? i can't seem to figure out how to do it?
example:
my templatefield looks like this:
<asp:TemplateField HeaderText="Category" SortExpression="category" >
<ItemTemplate>
<asp:Label runat="server" Text='<%# BuildCategory(DataBinder.Eval(Container, "DataItem.category")) %>'
ID="lblPrice"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
where category is party of the datasource, but what gets displayed is a calculated value - which is different from the category.what can i put in the "SOrtExpression" to make it sort by the new value - taht gets displayed?
I needed to create an Access table programmatically an was able to by using Martin Xie's post but how can I set the Field1 - Field Property Index to Yes (No Duplicates)?
[code]...
I re-wrote this to make it more readable. If you want to skip right to the chase, look at the ALL CAPS comments in the code blocks. All necessary code has been included for debugging. I've searched multiple forums (including ASP.NET), and the MSDN library and cannot fix this >.<
[Code]....
GridView SORTING of DYNAMIC Columns and Data Source Scope
View 2 RepliesI have limited knowledge on VB coding. I am now creating a system which allow customer to select exhibition event and booth number they want and next reserved which day they want to rent.By default, in GridView control can add checkbox Field but it only generate 1 checkbox for 1 row of data.
As state in the title, I have no idea how to generate the checkboxes for every field in database call D1,D2,D3,D4,D5,D6 and D7, each carry value 0 by default.Now I want every single field have a checkbox to allow customer select which day they want to reserve and retrieve their checked value to stole into corresponding D1-D7 field, checked value will update value 0 to 1.Next, how should I coding to store the checked value into database? in default.aspx or default.aspx.vb? generate checkbox instead of using gridview?What I want
My coding:
<%@ Page Language="VB" MasterPageFile="~/MasterPageMember.master" AutoEventWireup="false" CodeFile="member_view_event_list.aspx.vb" Inherits="member_view_event_list" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">[code].....
I have a value in one of my gridview column which will determine if the entire row's value should be in red color. I did the below but somehow every single row is red colored.
Protected Sub uigvList_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles uigvList.RowCreated
If e.Row.RowType = DataControlRowType.DataRow Then
[Code]....
i need to create a pop up window whn the user clicks the button link of the gridview
the gridview is a project details table and the button field should giv the abstract of each project.
on clicking the abstract of a particular project,that abstract should be displayed as a pop up.
is it possible to do it thru de popup control exteder of the ajax contrl toolkit?
I have to disable all the controls on my gridview for business purposes.[code]...
View 2 RepliesI need to create a page that will display gridview based on user wants (programmatic ally).Basically I have a list of columns then the user will choose for the list. I need also to have sorting function
View 2 RepliesI'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page:
<asp:SqlDataSource ID="msgUnread" runat="server"
ConnectionString="<%$ ConnectionStrings:edinsec %>"
[code]....
As you can see I was playing with WithEvents but that didn't seem to help. In the above code all I was trying to get was some kind of reaction to the clicking of a checkbox - but nothing happens (no errors, either).
I have users check off lab facilities in a UI. I want to use linq to fetch corresponding records for all of the labs that they have checked off. Basically,
Dim myRecs = (From l As EpiData In myDataContext.EPIDatas Where l.facility= _
one of the checked labs
So basically, I need to write a linq query where the "strings" to match are determined at runtime. Is there any way to do this easily? I know that there is a library out there called dynamic LINQ, but (1) it's in C# and I'm writing in VB (2) I'm really just looking for a single, simple solution for this single case.
I started editing an existing code (basicaly to learn vb) without any real previou experience. Well let's get to the point; I have a form that gathers data from db ordering by user ID (on click count). I have one DataGridView with a list of user, some have data in db, some have not. I came so far that if I CLICK on a user that have data, all data is dissplayed in 6 dinamyc textboxes. If user has no data inly first (emty) row with 6 dinamyc textboxes is created.
Then I have a button that simultaneously adds a row of dinamyc textboxes bellow and multiplyies textbox04 (name is clickcount & 4) and textbox05 and displays the result in textbox06. I want to add a messagebox that shows if textbox04 & 05 are empty and in that case exits sub. Of course if they are not empty, their sum should be multiplyed in textbox06 (on 2 decimal places exact) Here is my code so far:
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Reset warnings
[Code].....