what you can see in the code is when i select a name of a column in cbo1(combobox1.text) and also the value of a RB1(radiobutton1.text) .the cells of the selected column returns the value of RB1 so thats OK
but when i select a different name (column) in cbo1 the value of the first column doesn't stay and i want that unchanged
[Code]...
Unable to select multiple column in datatable
Code:
Dim Activitydtb As DataTable = DirectCast(ViewState("TalentcharacterActivty"), DataTable)
grdviewactivity.DataSource = Activitydtb.Select("SELECT
[Code].....
I have a question regarding the dataset usage in Reporting Services. I have a stored procedure which returns multiple select statements (result tables), and I created a Dataset in Reporting Services 2005 with this stored procedure. The problem is that I can not reference the second or third result table, and I can only use the first select statement fields. Is this the limitation on Reporting Services Dataset or is there a way to use multiple table results in one dataset?
View 1 RepliesI have a webbrowser control in VB 2010 Windows Form project that loads a webpage. This webpage contains select tags with a few options. I can select one option using:
Dim
cboTemp1 As
mshtml.HTMLSelectElement
[Code]....
But I need to be able to select more than one option (e.g. 1 and 6) in the select tag/element. Is that possible, the Select element has the multiple select option enabled..
I want to select to multiple sql tables using select query in vb.net..I have 2columns in sql table..I have tried this query.. But i'm getting error.
TextBox11.Text = Val(27)
cmd = New SqlCommand("SELECT outside,power FROM vijay21 INNER JOIN vijay22 ON vijay21.outside=vijay22.outside WHERE outside BETWEEN " & Val(TextBox11.Text) & " AND " &
[code].....
Is there a tool in the toolbox that i can use that replaces checkboxes. i have limited amount of space and checkboxes just keep taking up room. I need the user to select multiple objects like checking multiple checkboxes.
View 5 RepliesI have problem and I've been looking for a week now on how to solve it. Yesterday I thought I solved but apparently I didn't when I tried the query with new data added in my database.Here's my query
Public Function getTicketsByBeginstation(ByVal station As String) As Array
Dim r As Array
r = (From u In treinDataContext.Tickets Where u.ritId =[code].....
The problem I have is: when I have a station selected there are more than 1 trajecten (connections in English) but I had to use the .first else Visual Studio would give the error "the '=' operator is not defined for 'integers' and 'system.linq. IQueryable(of integer)".
So I give the name of a station -> I have to select all trajectens with the given station as beginstation -> I have to select all ritten which have the given trajecten -> I have to select all tickets which have the given ritten So: I have to show all tickets for a certain station.
how to select from multiple tables. so far this is my code how do i Dim dr As OleDbDataReader
[Code]...
what sql command i must use. this is my current command but it give me an error saying "The specified filed 'ClientNo' could refer to more than one table listed in the FROM clause of your sql statemate." [code]
View 3 RepliesI want to make SQL query based on the values in the controls.
View 7 RepliesI have a ListView box on my project, which is filled with another function.I need it so that when you press Button1, messageboxes pop up with all of the selected items in it.
So basically, I select multiple items in my ListView, press Button1, and the MsgBox appears showing me what I've selected.[code...]
how to select multiple table in vb2010? i trying to create a login so i need to retrieve the data in 3 different tables in one database i have a code but not work.[code]
View 2 RepliesI am trying to link to a Access database at runtime using a SELECT FROM WHERE query, which I can do but.......
with the WHERE part I want to select several conditions, 4 actually and it is not working, what am I doing wrong?
Here is my code,
Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=V:GYMDBFLineProdSanderProduction.mdb")
[Code]....
I'm trying to grab some data from my SQL database as below;[code]The problem is when I read the data I get an error 'Name'.[code]How would I read this data as above considering I can't use name twice?
View 4 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 RepliesIs there any way to use a Select statement to Test multiple variables?
ie:
Dim x as integer = 1
Dim x as integer = 2
Dim z as integer = 3
Select Case x, y, z
I am writing an app that puts multiple controls on a form at run time and then I edit the controls in a property grid. All that is working fine. I'd like to 'mark' the contol when it is 'selected just like visual studio does with the dotted border (or soemthing similar, I don't care that it is just like vs). I'm already using MouseDown event to grab the control and send it to the PropertyGrid, but I have now wired it up to take multiple controls and need to 'identify' them on the screen.
View 1 RepliesI'm using DGV to display data. I also have a DFVCheckboxColumn. If user checks a checkbox column the data from that row is transfered to database. i'm able to select multiple columns with pressing the CTRL key.But i wanna select multiple rows without pressing CTRL key. Can someone give me samplecode or guide me in this
View 1 RepliesI 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 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 RepliesUnable to select multiple column in datatable [code]....
View 3 RepliesI'm using LINQ to SQL to select some columns from one table. I want to get rid of the duplicate result also.
Dim customer = (From cus In db.Customers Select cus.CustomerId, cus.CustomerName).Distinct
Result:
1 David
2 James
1 David
3 Smith
2 James
5 Joe
Wanted result:
1 David
2 James
3 Smith
5 Joe
Can anyone show me how to get the wanted result?
I currently have two list boxes that have the exact same items in each. I don't want the user to be able to select the same item from both list boxes.
My code:
listbox1.Items.Add("SSS")
listbox1.Items.Add("AAA")
listbox2.Items.Add("SSS")
listbox2.Items.Add("AAA")
I'd like the user to not be able to select AAA & AAA from different list boxes, just SSS & AAA. I have way more items just thought I'd shorten it.
Can't seem to find code for radiobutton to hilight multiple choices from listbox, e.g.
If radiobutton1.clicked = true then
listbox1.selecteditems = "apple" "cherry" "pear
if radiobutton2.clicked = true
listbox1selecteditems = "apple" "cherry" etc....
Is there any way I can select multiple items in a listview programatically in WPF?
View 1 RepliesIs there any way I can select multiple items in a listview programmatically in WPF?
View 2 RepliesIm creating a menustrip which can choose to draw the shape you want, and the colour you want to fill in the shape.For the colour part, I manage to choose multiple colour options. Example : If i checked red and blue colour, the shape of the colour would be purple. But when I want to uncheck the red color or blue color, it does not work.
Public Class Form2
Private Sub ExitToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ExitToolStripMenuItem.Click
Me.Close()
End Sub
[code].....
Is it possible to modify this section of code to select multiple instances of pictureboxes, so that I can drag them all together. At the moment I have to do one at a time, and when there's more than half a dozen, its a bit tedious. I've added the Control key to distinguish it from single drag'n'Drop, but.
'using Left mousebutton and Control to multi drag & drop
e.Button = MouseButtons.Left And My.Computer.Keyboard.CtrlKeyDown Then
newPictureBox = DirectCast(sender, PictureBox)
[code].....
I'm programming a utility for a game, and at the moment I am adding chat commands for it. They use the Select Case type, but I want to be able to use multiple conditions for 1 case.
Current
Case "/lame"
If sParameter = "announce" Then
AnnounceMsg("^1No Laming
^7Laming consists of
^5* ^7Attacking someone with
^5- ^7Weapon Down
^5- ^7Chatbubble Up")
[Code] .....
I get an error:
Conversion from string "/lame" to type 'Long' is not valid.
I built a form that has 3 Listview objects. Each Listview contains items, the user is to select an item from a Listview and click a button that moves the item "up" or "down" to an adjacent Listview.I am having a difficult time "knowing" which Listview item has been selected. The problem arises once a user has clicked items from different Listviews. Even though, visually, only one item is selected in one Listview, the program still detects a selection from other Listviews.
View 1 Replies