I have a select box call 'ToLB' which takes in value items from another select box. I need to extract those selected values from 'ToLB' and print it on a label, this is how I do it but apparently it's not working as in no error message but nothing was printed to the label.[code]
View 1 RepliesIT STILL GIVES A MSGBOX IF I SELECT THE CHECKBOX BOX OR NOT ....My code below will redirect to Google in both conditions: If the user selects the checkbox, then it will redirect to www.google.com, but if a user forgets to check the checkbox then it shows the msg box with an ok button. When I click on ok it should redirect to www.google.com
I want When a user forgets to check any of the checkboxes to show a msgbox with an ok button and stay on the same page. Otherwise if user selects any of the checkboxes then redirect to google
[code]...
I have two drop down. SelCurrentManuf and selCurrentModel. I want the option in selCurrentModel to change depending on the option selected in selCurrentManuf. How do i do it?
<asp:DropDownList runat="server" ID="selCurrentManuf"></asp:DropDownList>
<asp:DropDownList runat="server" ID="selCurrentModel"></asp:DropDownList>
This is how i am currently populating selCurrentModel
Public Sub PopulateCurrentModel()
Dim mySelectQuery As String = "SELECT * FROM Model where ManufID = "+ selCurrentManuf.Text+";"
Dim myConnection As New MySqlConnection(Session("localConn"))
[Code]...
but it only populates the first selected manuf, and doesnt change after
Private Sub selCurrentManuf_SelectedIndexChanged(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles selCurrentManuf.SelectedIndexChanged
PopulateCurrentModel()
End Sub
i am generating another popup window (Lookup.aspx including a DataGrid). From that datagrid i can fill the textbox in File.aspx using javascript.It works in InternetExplorer7 & InternetExplorer8 .But in Morzilla the popup & datagrid is appearing,but i can't select from datagrid .In same manner a calendar image onclick="displaycalendar(... );" i can select datetime to a textbox,it works in IE6 and IE7 but doent works in IE8 Morzilla.
View 1 RepliesI have aspx gridview with checkbox on evryrow, what is required is whenever we check any of the rows, a query should be launched to change the specific agent -each row consist of agentID, Pass, Status- to Paid Status. using javascriptWhat I need to know is how to loop to get the Checked row and get the ID of the row checked so that I can get THe ID of the Agent in thos row so that I can update its status.using javascriptI found something similar on stackflow:t GridView selected row DataKey in JavascriptBut it is not my case, what is needed is at the check of a checkbox a javascript function should launch through which I could update the selected row in grid view after having the index of this row and this all to avoid refreshing the page.
View 2 RepliesI have a gridview displaying all employees. Upon selecting an employee, I'd like to open a new page or window that would display all of the information for that employee with the option to edit/delete/update. Once this transaction is complete, return to previous page with gridview of all employees. ((language I'm usings is VB))
[code]...
I have 3 checkboxes and 1 textbox i use only these controls mentioned above ..I want ---- when i check checkbox1 and checkbox2 then it will display in textbox1 as 1,2 as it is as the same ascending order not 1,2, or 2,1,I use this type of coding in asp.net (VB) , i wanna use this coding for 45 checkboxes........
View 1 RepliesI am using asp.net.I have taken one Hidden value and assigning value to that hidden variable in Java-script.
aspx: <input type="hidden" runat="server" id="hdnProductionIds" value="0" name="hdnProductionIds" />
JS:document.getElementById("ctl00_ContentPlaceHolder1_hdnProductionIds").value = "123";
I want to use that hidden value in server side coding(vb.net). But while do-post back, hidden variable value becomes Zero (default value)
[code]
Public Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand
If e.CommandName = "Select" Then
[Code].....
I want to select top 4 values in sql table using vb.net.. how do i select it?
View 10 RepliesNew to using SQL and I am having trouble accomplishing something that I figured would be simple.I am trying to create and INSERT that will insert the MAX() value from the first column in one table to the first column in another table while the rest of the columns will be filled with parameters.
I have tried switching my code around to see if I just had the syntax wrong but I've had no luck and I'm not even sure what I'm trying to do is possible (at least in a single INSERT).Here is what I have at the moment:
INSERT INTO [Table2] VALUES(SELECT(Number FROM [Table1] WHERE Max(Number)), @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10)
I'm using some HTML with vb.NET and would like to know if it's possible to pass data back and forth. I need the value of an option in a drop down box passed down:
[Code]...
I 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 RepliesWe have a listbox in our MVC View and the user has the ability to highlight multiple values. I'd like to be able to save those selected values(if possible?) as a comma delimited cell value in our '08 SQL Database.
The image below shows what I am attempting to explain. Note the selection in the LISTBOX
This is where we save the passed in values from the Positionnumber DDL (Listbox w/ mulitple highlights).
> <HttpPost()>
> Function Edit(wsmonitor As WSMonitor, ByVal vbpositionnumberDDL As Integer, ByVal PassedCounty As Integer, ByVal
> MonitorTypeDDL As String) As ActionResult
[Code]....
I am creating a page in which I need to show a drop down List. From this drop down List a user can select multiple values. I know I could use a check box list like:
<asp:CheckBoxList ID="CheckBoxList1" runat="server" style="margin-right: 158px">
<asp:ListItem>Value 1</asp:ListItem>
<asp:ListItem>Value 2</asp:ListItem>
[code]....
but if there are more than 50 or so values then that will consume a lot of space on the page and will look odd. So kindly tell me how can I select multiple values from drop down list or if there any alternatives so that I can select multiple values and show many records on a minimum space but not a grid?
I am entering a value in textbox and click the find button. In the button click i've written the following code, but it does not yield any result.
dbprovider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbsource = "Data Source = D:sprrg.mdb"
con.ConnectionString = dbprovider & dbsource
[Code]....
Here is my select stament to store values when username and password and check boxes are check
com =
New OleDbCommand("INSERT
INTO Users (UserName,Password,IsAdmin,Read,Write,Change,REMOVE,User_st) VALUES ('" & txtusername.Text &
"','" & txtpassword.Text &
"'," &
CInt(chkIsadmin.Checked) &
[Code]...
My problem is this wehen i add new record to my db it saves values like this the value of read column is as follows read = 1 when check box is checked and read = 0 when check box is checked but i want to save true or false instead 1 and 0 how to achieve this using vb.net and my db is Oracle.
Is there a way to do a select statement with conditional values?
For example: select * from table where column1 = (ifequals(column1, Active, Y, N))
I'm pretty new in Linq and the first problem I've is to select the Distinct values from a ObservableCollection( Of T)
I've tried with[code]...
I want to check the current time with the half an hour time slots (total of 48 starts from 00:00,00:30,01:00,....23:30). Is it possible using select case statement.
I am storing the current time in an object.
Dim datime As DateTime = DateTime.Now.ToString("t")
now i need to do conditional check on this variable. under whichever the time slot the variable belongs, i need to write a value under corresponding timeslot.
How do I cycle through a ComboBox Values list so I can check each value and select one of them efficiently?
Examples in C# or VB.Net welcome.
I have a little challenge. I have a report that I declared a parameter called Department that has default values like this: [Code] The problem is that when I test this (with CR10 or on web), and I select multiple values, the thing does not show the values for the multiple values. It only works when I select a single department. What should I do?
View 2 RepliesI am using VB.net 2003 application program. I am trying to do a select statement whereby I'm searching between 2 datetime values that are being stored as datetime. records are stored inside Access. For example, I am searching between 2 datetime:
StartTime = 2/23/2009 9:00:00 AM
EndTime = 2/23/2009 11:30:00 AM
So I need to find all the records in between 9:00 AM and 11:30 AM on 2/23/2009.
strSQL = "select OrderID from Orders Where OrderDate >= ('" & StartTime & "') AND OrderDate <= ('" & EndTime & "') "
but i got the error showing below:
An unhandled exception of type 'System.Data.OleDb.OleDBException' occurred in system.data.dll
strSQL = "select OrderID from Orders Where OrderDate >= DATEVALUE('" & StartTime & "') AND OrderDate <= DATEVALUE('" & EndTime & "') "
But when I use DATEVALUE, it takes the date from the string and set time as midnight (00:00:00). So it returns no records between 9:00 AM and 11:30 AM on 2/23/2009, but I can see there are records. [Code]
strSQL = "select OrderID from Orders Where OrderDate >= TimeValue('" & StartTime & "') AND OrderDate <= TimeValue('" & EndTime & "') "
And when I use TimeValue, it returns the time from the string and set date as jan 1st. so it returns no records between 9:00 AM and 11:30 AM on 2/23/2009, but I can see there are records. [Code]
but none of the codes above is returning records between 9:00 AM and 11:30 AM on 2/23/2009, but I can see there are records. i searched and found all those examples. but that didn't work. Is there anyway i can search between 2 datetime values. i need to find all the records that lies between that time period (for example: between 9:00 AM and 11:30 AM on 2/23/2009).
In vb.net I would like to set all numericUpDown (NUD) controls to select their value when they receive focus, like a text box does. Do I need to write a GotFocus handler for each NUD? I know I can use widthBox.Select(0, widthBox.ToString().Length) to do the selection I just need to be able to apply this to all NUD GotFocus events.
View 2 RepliesIs it possible to select distinct values from a DataTable?
View 5 RepliesI was able to do this via a SELECT CASE statement, however I'm always trying to improve my code writing and was wondering if there was a better approach. Here's the scenario:Each document has x custom fields on it.There's y number of documentsHowever there's only 21 distinct custom fields, but they can obviously have n different combinations of them depending on the form.So here's what I did, I created an object called CustomFields like so:
Private Class CustomFields
Public agentaddress As String
Public agentattorney As String
[code].....
I am trying to get values from a select multiple box like this but the breakpoint at 'For Each Item in box' is nothing, what am I doing wrong?
[Code]...
I have a listbox which is populated from a sql table. I need to select unique month values from the dates in this listbox.
Dates are, for example:
21/09/2010
22/09/2010
21/07/2010
09/06/2010
I need to extract september, june and july only from the above, sort them and display them in a another listbox.
lambda - vb.net lamba expression to select all values between lower and upper values plus the next lower and upper value. I need some help with a lamda expression to get a subset of range of values. I have a lower and upper value, and getting everything between them seems easy enough, but I also need the next lower and higher value to be included. I can do each of these separately, but would like to do it in one shot if possible.
The range I need the subset from has 150 values. A small example would look like:
{8.206,8.206,8.201,8.196,8.193,8.192,8.189,8.174,8.171,8.171,8.166,8.163,8.157,8.154,8.153,8.14,8.131}
My lower value is: 8.16
My upper value is: 8.17
I need to get back: {8.171,8.171,8.166,8.163,8.157}
I as part of the support VB code for a larger ASP project, I need to read back the existing data from an Access database, to see if user has changed a value.
I'm reading the existing data back into a DataView using the following function:
Public Shared Function GetPolicyStatus(ByVal intPolicyID As Integer) As DataView
Dim strConString As String
Dim conMyData As OleDbConnection
[Code]....