Ive created a sql database using visual studio 2010.I need to use a radio button on my form, which when checked, updates a table for the record it is currently on with the integer 1.This is as far as I have got:
Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
RadioButton1.CheckedChanged
If RadioButton1.Checked = True Then
End If
End Sub
i am developing a simple vb.net application. i have three forms in my app. the first form has 2 radio buttons from which i need to select one. based on the selection made in my next form a combobox ll be populated.so far so good.there is a back button on my 2nd form which when clicked redirects me to the first form. here when i select the next radio button the combo box in the next form does not populate accordingly. it still holds the old values. \[code]
View 4 RepliesI have one radio button and one listbox .i want code for display listbox depends on the radio button check true and false.
View 3 RepliesMy current code only selects a single item from a specific field. How do I make it populate the listbox with ALL the items in a field?
Try
conn.ConnectionString = "server=; username=; password= database="
conn.Open()
Dim sqlAdapter As New MySqlDataAdapter
[code]....
example:
check in/check out using radio button..
database will store the time when the person check in..and same thing goes for check out..
i have a form in vb.net and it has two groups of radio buttons and once a selection is made i need to update it and save it into the database(ms access). i am failing to get the information to save into the access database but instead i am getting an error on the command execute query. here is my code:
[code]
strSQL = "INSERT INTO development VALUES (" & Label2.Text & "','" & Label3.Text & "','" & Label4.Text & "','" & Label5.Text & "','" & Label6.Text & "','" & Label20.Text & "','" & Label21.Text & "','" & RadioButton5.Text & "','" & RadioButton6.Text & "'," & devstaffid.Text & ",'" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox5.Text & "','" & dateindev.Text & ")"
[code]....
i have problem that i know once someone answers, i will kick myself, but here goes. i need to move the text next to the radio button to the left of the radio button, that part is easy just make sure the the "right to left" is maked yes, got it. but, the problem is i am making a seating chart and the seats are labeled 10-a, 10-b etc.... when the right to left is set to yes my text reverses and becomes a-10 and i can't seem to figure out what is set in the properties the is causing the alpha to be placed before the numeric.
View 2 Repliesi have 31 PAIRS of radio buttons Yes or No in a web form which will insert the value of radion buttons or text of radio buttons in a single table of 31 columns in SQL server. I grouped each pair of radio button (Y and N). How can I retrieve the selected radio button value of the group and insert it into MS sql server database table using one insert command in VB.Net?
View 2 RepliesThe problem I have is that many times, the dataset that this control is bound to is empty. Therefore, the user continuously gets an error saying that one or more fields is missing. When I debug the code, I can see the code in the class loop through all of the radio button controls on the form. Since none of them match the field from the database, the code throws the error. I assume the code expects a match.
Should I modify the class to handle the case when there is a DBNull value? If so, what would be the best method? Or should I approach this situation in a completely different manner?
Public Class myGroupBox
Inherits GroupBox
Private _myTag As String
[Code]....
trying to write a simple form for calculating professor's salaries depending on their degree and position.my problem is that the when i select a check box, the value is not being updated until i select a different radio button. it probably doesn't make much sense here,
Public Class frmMain
Private Sub optLecturer_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles optLecturer.CheckedChanged[code]....
the values being assigned to my salary label are correct, but are not being updated until i select a new radio button. im not entirely sure how to get around this so that the value is updated as soon as i select the check box.here's when the program looks like:
I have two buttons on a form , clock in and clock out, and i have two fields in an access database, fldCheckIn and fldCheckOut, when i click the check in button i want it to get the current time and set it to the field in the database
View 13 RepliesI have a radio button control on a web form. The members of my ListItem collection are
assigned the following.
Text No
Value 0
Text Yes
Value 1
So what I need to do, is to readd a varchar value from my database and if the column value returned equals 'Yes' then I need to select the radio button that has the assigned value of 1. Otherwise if the value read from the database is 'No', then I need to select the radio button assigned a value of 0
So how can I set the value for my radio button? I experimented and could not figure it out. The 'Yes' or 'No' value is stored in my database in the field ds.Tables("employee").Rows(0).Item("answer")
So I tried something like this which is not correct:
RadioButtonList1.Items.FindByValue(ds.Tables("employee").Rows(0).Item("answer") = "Yes").Equals(True)
In my project I would like to call an exe so that exe pop up will come with a Login Screen with 2 buttons Login and Cancel.In those 2 buttons, login button is focussed default. Now my application should invoke the Login button automatically. Means there won't be Pressing ENTER KEY or Mouse Button Etc. Just after the Login Screen, there is a 2nd Screen that has 5 different Radio buttons, the 1st Radio button is always the default. So I also want to click this radio button automatically without using the keyboard or the mouse. y intention is that, the application should do that automatically.
I have tried with getting the handle of the focused Button by GetFocus method and tried to send that handle to the application by SendMessage and PostMessage. But it's not working.So can any body give some suggestion regarding this?
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 am currently writing a program that needs the use of a database. At the moment I am trying to get a simple combobox working.The problem I am having is that I have never done any work with databases and VB08.I am using an access database that has the fields SMTP, Port, SSL
I want to populate a combo box with the field SMTP and from there I want 2 other labels to be filled in with the port and ssl details I was wondering a) How do I set the connection up with Visual Basic (within the database I am using MySQL to get the information) b) How do I go about populating the combo box?
User will use a button1.click to open a filedialog to locate the file they needed. after which, the name of the file will appear on a textbox. Button2 is an OK button to write the filename into a txt file. Button2.click will work with the 3 radio buttons - meaning when Radio Button 1 is true and Button2.click is clicked, the filename will be saved asFile1.txt.if Radio Button 2 is true and Button2.click is clicked, the filename will be saved as File2.txt. Likewise to Radio Button 3
View 1 RepliesI am using WPF in VB. My window contains radio buttons and combo boxes. I am wondering how can I save those in textfiles?
View 2 RepliesI have a column in a table that contains a message and I want this message to be displayed in a label. Here is my code which currently doesn't populate the label.
Protected conString As String = ConfigurationManager.AppSettings("sqldirectory")
Dim cnn As New SqlConnection(conString)
Dim cmd As New SqlCommand("select message from [database].[dbo].[table]")
[Code]....
how i can implement below requirement using asp.net and vb.net.I have three fields in a form which are filled by users. Based on these three values, i need to auto-populate the 4th field.I have planned to implement this in the following way.Write a separate class file with a function to calculate the possible values for the 4th fields based on 1st 3 inputs. This function can return some where between 1-10 values. So I've decided to use drop-down for 4th field, and allow users to select the appropriate value.Call the above function in onchange function of 3rd field and take and use the return values to populate the 4th field. I'm planning to get the return values in array field.(Does this need a post back?)
View 3 RepliesHow to take a value from a combo box and have it update a field in sql table?
View 1 RepliesThere 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 created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?
Table: Filmes ... Field: NomeTextBox
Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox
I'm trying to populate a date from a bound text field in a DetailsView. I keep getting a error when a DBNull is in the column. How do I avoid the DBNull when populating the text field.
My code is as follows:
<asp:TemplateField HeaderText="CBYD Clear Date">
<EditItemTemplate>
<asp:TextBox ID="CBYDExpDate" runat="server" ReadOnly="true" Text='<%# IIf(Eval("CBYDDate") is DBNull.Value,"", String.Format("{0:MM/dd/yyyy}", Eval("CBYDDate").AddDays(30)))%>' />
</EditItemTemplate> </asp:TemplateField>
I developed a VB form which has a bunch of text fields. I've an external excel spreadsheet. I want a particular cell from the excel file like "A5" & the value to be auto populated in the text field of the VB form. Is this feasible?
View 2 Replies[code]......
View 7 RepliesDim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 RepliesI have an editable ComboBox with a validation on the Text property to make sure manually entered info is valid.EDIT: All I want to do is populate the .Text property with the ValueMember of a selection rather than the DisplayMember I also have the .Items populated with valid entries having the DisplayMember and ValueMember set.My DisplayMember is a caption along with the data, and the ValueMember is the data itself.So Items might be:
(DisplayMember, ValueMember)
"Foo - 1ab2" , "1ab2"
"Bar - 3cd4" , "3cd4"
I had a validation on the text which can also validate manual user input like "5ef6" The problem I'm having is that if the user selects an item from the combobox it populates the text field with the DisplayMember property (ex: "Foo - 1ab2") which will fail validation.I have tried to manually set the .Text property with the SelectedValue or the SelectedItem.Value on each of the three relevant combobox events to no avail.I would like that the .Text of the ComboBox get populated with the .ValueMember of the item when selected rather than the .DisplayMember
EDIT: I cannot validate by trying to extrapolate the value from the caption. I send the Text off to a service to be validated.
void FillMyCombo
{
KeyValuePair<string, string> listValue1 = new KeyValuePair<string, string>("Foo - 1ab2" , "1ab2")
KeyValuePair<string, string> listValue2 = new KeyValuePair<string, string>("Bar - 3cd4" , "3cd4")
[code].....
The user can manually enter something like "5ef6" which will pass validation.But when they select an item from the list, rather than manually entering it, the .Text property gets filled with the caption and not the value ... so it will contain "Foo - 1ab2" and that will fail validation. I cannot change the validation method to "infer" the value from the caption. I have no control over that service. All I'm after is the displayed value EDIT: Say a user selects "Foo - 1ab2" from the dropdown list, I want the text in the box to say "1ab2" EDIT: I have also tried to set the .Text property in code but I can't seem to make it work in any of the ComboBox events. how to programmaticly set the .Text property (and make it commit!) on a selection event they will also answer this question.
Background: I have a webForm app that registers a user in the database based on the information provided with a web service, auto-generates a random password and username, and e-mails the user a link to take an application based on the marketing company selected.
Question: How do I populate the MarketerName_TextBox field with the currently logged in users name (Is it User.Identity.Name and do I add that line on aspx.vb end or the aspx end?)
[Code]...
I have the following in vb.net
<asp:RadioButtonList ID="rbEdit5" runat="server" RepeatDirection="horizontal" >
<asp:ListItem Value="1" >Yes</asp:ListItem>
<asp:ListItem Value="0" >No</asp:ListItem>
</asp:RadioButtonList>
I need to programatically select one of the 2 listitems.How do I programatically select say 'Yes' above in vb.net?
I've come across this page, and I'm trying to click the radio button of the webbrowser. Here's the HTML source:
<div align="left" style="padding:2px;">
<input type="radio" name="choicepick" value="ABA">A
</div>
<div align="left" style="padding:2px;">
<input type="radio" name="choicepick" value="ABB">B
</div>
I've tried: Webbrowser1.document.getelementbyID("choicepick").setattribute("value","ABA")to click the 'A' radio button but it's not working.