connection here and declaration of variable
Dim i As Integer
Dim chk As CheckBoxList
chk = CType(Me.FindControl("chkBx1"), CheckBoxList)
For i = 0 To chk.Items.Count - 1
[Code]...
I have 3 tables:
CustomerType
CusID
EventType
EventTypeID
[code]....
Then I want it to automatically insert data into CustomerEventType table based on the last EvenTypeID data that's just inserted and the checks of the CusID that is using CheckBoxList1 bounded from CustomerType (Suppose there are 2 IDs. )After I Click on Insert button the data in EventType table and CustomerEventType table should be:
EventType
EventTypeID
1
CustomerEventType
[code]....
The only question that I have is, what should be the code behind the insert button using VB.NET LINQ-to-SQL to get this result?
If I a many-to-many relationship between Users and Roles and I have an instance of a User entity and several Role Ids can I insert a relationship between the two types of entities without having any other Role data and without doing a select on the Roles first? Update:
I might not have been clear enough. I don't have an instance of a Role, only the role id. Is it possible to create the relationship between User and Role without filling a Role object from the database first?
I have a function that looks like this[code]...
I want to make the entire string (title + "/" + cost + "/" + asin) a hyperlink to another page called SearchDisplay.aspx.
Basically, I am trying to write a LINQ to Objects statement where the relationship is a grandparent, parent, child relationship. (You could also call it a Master Detail relationship.)
Dim coverages As New List(Of Coverage)
Dim coverage As Coverage
For Each rl In oClaimsPolicy.RiskLocations
[code].....
Im trying to use a CheckboxList Control to Store Yes and No and i noted there its a property on the control
"Selection Mode" One/MultiSelect/MultiSelect Extended
i set One expecting it to allow only one item being select at the same time but it doesnt work as expected, my question is there its another property to achieve this without having to code the event?.
i could do it by coding the event but, im tired of coding stuff that really isnt needed, since there are routines for that on VB.NET.
I am learning asp.net and needed to have a CheckBoxList which items will be initially selected if the are in a CSV string from a database.I have got it working although I just wondered if I have gone about it the best way as it seemed a little long winded?[code]
View 1 RepliesUsing a checkboxlist not a simple checkbox I need to select 1 checkbox otherwise display a error message in an label once I submit the form. My checkboxlist does generate correctly now I just need to validate it
'check checkboxlist
For Each ckbox In checkBoxCropsFertilzed.Items
If ckbox.Selected > 1 Then
lblErrorMessage.Text = "too many selected"
End If
Next
I use Visual Basic 2008 Database is Mysql Three tables:
[Code]...
I remember we were taught BASIC (Beginner's All Purpose Symbolic Instruction Code) language in school, when we were in 5th grade. It was purely in DOS-Mode and we basically used it for drawing. Then I learnt Visual Basic 6.0 quite a few years basic. I neve found a similarity between them
View 11 RepliesI have two tables which need to be connected using a one-to-one relationship. In SQL Server 2005, how would I add this relationship to the database diagram, do I just leave the relationship blank? Is there any pre requisite queries I have to add? How do I connect these tables in VB? .. the same way I would connect a one-to-many?I need the Student table to be linked to the Class Table where One student can be in only 1 class.
View 10 RepliesIf I have a List(Of Guid) can I map those Guid's with a single Linq expression to a CheckboxList of values?
View 1 RepliesPretty basic question, I have a checkboxlist inside of a wizard control. I need to collect the value of all items that are checked, as well as whatever value is inside of a textbox if "other" is checked, to insert into my database during the Wizard.FinishButtonClick event. How do I do this?
View 1 RepliesSo, I'm running VB.net 3.5. I have a dynamic list of server names, and I want to put them in a CheckBoxList. The list is populated and, using that same list, I make a graph of the performance for each server listed. I want to be able to check and uncheck the checkboxes representing servers and, when I lick an update button, it'll create a new graph and graph only the servers that are still checked. I noticed that the page still loads before the button click is handled, so the CheckBoxList will repopulate itself before being able to read the current CheckBoxList. This is my load. And I populate my checkboxlist inside ShowView()
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
[Code]....
And I wanna try to preserve the checkboxlist values when I do an event handler for an update button.
Private Sub btnUpdateGraph_Click(sender As Object, e As System.EventArgs) Handles btnUpdateGraph.Click
'insert code
End Sub
How do I specify that I want two columns on a checkboxlist?Below is my code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
Dim di As New IO.DirectoryInfo("\bk00app0001Images")
Dim imageArray As IO.FileInfo() = di.GetFiles()
[code]....
how can i connect a checkboxlist with a database?
View 5 RepliesI have a list of options on my site that a user can select. What I want to do is provide functionality to limit the amount of content the user gets based on his selection in a CheckBoxList. Once he's selected what he wants, he'll click Save and his selection will be written to the database. The CheckBoxList is initially populated from the Modules table. This provides a list of modules that the user can select. When he clicks Save, the code needs to loop through this CheckBoxList and "pick out" the values for the CheckBoxes that were checked, disregarding the ones that weren't. The problem is that whether a CheckBox is checked or not, the debugger returns a False value for the CheckBoxList.Items(i).Selected property.
Here's my code:
Private Sub AddUpdateOrg(ByVal OrganizationName As String,
ByVal Action As String, Optional
ByVal Target As Integer = Nothing)
[Code] .....
Its possible that this behavior is the result of a postback from the save button. Upon further examination of the code, I've reconsidered the possibility that this issue is caused by a postback as the CheckBoxList is not bound on page load.
My below code pulls in 100 items into the checkboxlist all into one column. How can I modify the code so it will appear as two columns?
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
Dim di As New IO.DirectoryInfo(ImagePath)
Dim imageArray As IO.FileInfo() = di.GetFiles()
Dim image As IO.FileInfo
'list the names of all images in the specified directory
For Each image In imageArray.OrderBy(Function(i) i.Name)
CheckBoxList1.Items.Add(image.Name)
Next
End If
End Sub
I have some checkboxlist like this:
<asp:CheckBoxList ID="G1" runat="server">
<asp:ListItem Value="Comunicações Unificadas" Text="Comunicações Unificadas - UCoIP"></asp:ListItem>
[code].....
I am attempting to set a range of checkmarks in a checkboxlist using vb.net code behind. I want the user to select a beginning value and an ending value and I want to fill in the range between them as having all been checked. Assuming the user checks the 10th and 15th checkboxlist items, I thought the following would display checkmarks for items 10 - 15[code]...
View 6 RepliesHere I have a code with a CheckedListBox and I want to display multiple information, name, country etc.. My code just displays its name. How to display more information, retrieved from a file. txt, in CheckedListBox ? I do not know what part of the code displays
Here is the function that returns data Public Overrides Function ToString() As String
Return _Name
Return _Old
Return _Country
End Function
My issue involves relationships and cascaded effects between properties, and I'm wondering what best practices are on this.I have a class that contains a list of varying length of numbers. When editing the list, sometimes the user prefer to set a TargetSum, so that the program enforces the list will always add to this sum. I am accomplishing this by programmatically setting the final element in the list such that list sum = TargetSum. For example, if the user chooses to UseTargetSum, then sets TargetSum = 10, then creates a list of length 4, and enters 1, 4, 2 for the first 3 elements, then the final element is programmatically fixed to 3. The user cannot change the final element themselves.
I do this behind the scenes by handling all necessary events, such as a list element value change, list length change, and the UseTargetSum option change. For each event trigger, it recalculates the last element's value.It works but then there was a bug when loading saved data. If a list is loaded by sequentially adding the elements, the handlers modify each entry. Regarding the example, when the first value of 1 is entered, the handlers say "a value was just added, the sum should be 10, there is currently only one element, so it needs to be 10". So the first element gets changed to 10 behind the scenes. When the second element is next added, the handlers say "a value of 4 was just added, but the first element is already 10, so it should be zero." At the end of the load, the final list reads 10,0,0,0 instead of 1,4,2,3.
I know it is possible to rearrange the load procedure such that I get the correct list. For instance, I could avoid enabling the TargetSum event handlers until after all the data is loaded. The list would first be created as 1,4,2,3 and then the handlers would change nothing.
But this experience makes me wonder if I am opening the door for other sneaky side effects. It seems you should be able to load data without worrying too much about an implicit ordering. It also seems unusual to have "cascading" effects between class properties. Is there a more accepted approach?
The other alternative I'm considering is to only enforce TargetSum only inside UI forms. Ie, when you know it's a user making the change, then enforce the TargetSum, but otherwise leave the core class logic alone.That way database loads, etc, are left unaffected. But I guess the downside of not having ubiquitous enforcement is that opens the door of incorrect sums via some unforeseen complication.
I have made a small "front-end" application for an Access databasefile.
I set up 3 tables with relations in Access, and added the database as a datasource in my project. I have done no database programming, and the app has worked nicely for about 2 years. It's a simple master-detail form with 2 datagridviews dragged from the datasource window.
Yesterday I opened the project to add a new form. The form is just a "setttings form" with no database activities.
When I press F5 - the main form do not start, and I get the error message "DataMember property '{0}' cannot be found on the DataSource." - where the property name is the name of one of the 2 relationships in the datasource.
Im would like to create relationships between my tables from different database. im using VB 2008 and SQL 2008 as my database. Is the relationships should be made on my database itself or tru coding in my VB? If either which how can i do that.
View 2 RepliesHow do we create relation ships between tables using a sql query?im using MS Access and VB.net.
View 2 RepliesI cannot figureout to which class ItemStatus should link to!please refer to my blog in the following link to detail description of the issue
View 2 RepliesI'm using a dataset class written by others who have defined the foreign key relationships between tables using the tools in the schema diagram. I'm binding the dataclass to a windows form. I'm running into an issue where I have an existing header record and I'm trying to insert data into a child table via a grid programmatically. The child table contains all keys for data. As the grid is bound to a binding source, I'm simply adding rows directly to the grid programmatically.
When I attempt to save the data, I get the error ForeignKeyConstraint FX_Activity_UserRoleActivity Requires Child Key Values (4) to exist in the parent table. The value (4) is one of the foreign key values and it does exist in the parent table. The error occurs when I tell the bindingsource associated to the child table on the form to EndEdit. Looking at the XSD file for the dataset, both foreign keys are set up for 'Both Foreign and Key Constraint' with Cascade set for both update rule and delete rule. Accept/Reject rule is set to none.
Running a SQL trace, I confirmed that SQL Server is not generating the error, so it is occurring on the client application somewhere. First what does the error actually mean? Second, does the configuration of the foreign key relationship in the dataset's XSD file have anything to do with it? If so how should the foreign keys be set up between the tables? If it isn't how would you go about troubleshooting this issue as stepping through the code ends with the .EndEdit call to the binding source.
StudentId is a foreign key in StudentSubject,What I want know is how do I illustrate the relationship between the two tables is many to one
StudentSubject
StudentID Subject
148 Art
148 History Of Art
145 English
145 Poetry
128 Chemistry
128 Physics
128 Biology
123 Math
StudentLocation
Student RoomNumber
123 1a
145 3b
148 4c
128 2a
I am trying to input value to AppSchedNumber into my AppInfo table which is the primary key of my AppExamSchedule (auto inrement). The problem is I can't insert on my AppInfo because my AppSchedNumber on my AppExamSchedule should be the same.
View 1 RepliesI am using VS2008 Standard, Access 2007 and VB.net. I have an Access db with a Membership table, a DuesPayment table and a table linking the two together.
[code]....
1) In VS I have a single form (frmMembership). I used the Data Sources window to create a single datasource containing the tables tblMembers, tblDuesPayment and lktblMemToPay. from the 'Data Sources' window I drug tblMembers, as text boxes, to the form. I drug tblDuesPayment to the form as a DataGridView.
I right-clicked 'dsMembership...Edit in Dataset Designer' and checked that the relations between the three tables was as shown above. I left all other settings as they were created by VS.When I execute the app I get the member information as expected and can use the TblMembersBindingNavigator to step through the members. The DataGridView, instead of showing dues payment information for the member showing on the form, shows ALL of the dues information for ALL members does not exhibit any relationship between tblMembers and tblDuesPayment.
2)I also tried creating a dataset for tblMembers only. Then I used 'dsMembership.Edit in DatasetDesigner' window to create a TableAdapter for tblDuesPayment and lktblMemToPay. I got the same results.
3) I tried various other combinations, like creating TableAdaptors for tblMembers and a TableAdaptor for a combination of lktblMemToPay & tblDuesPayment.