SQL Select In Multiple Text Box?
Apr 30, 2009I want to make SQL query based on the values in the controls.
View 7 Replies
ADVERTISEMENT
Possible To Select And Highlight Multiple Portions Of Text Within A Textbox?
Apr 28, 2009Is it possible to select and highlight multiple portions of text within a textbox?
View 6 RepliesUnable To Select Multiple Column In Datatable (dtable.select())
Aug 2, 2011Unable to select multiple column in datatable
Code:
Dim Activitydtb As DataTable = DirectCast(ViewState("TalentcharacterActivty"), DataTable)
grdviewactivity.DataSource = Activitydtb.Select("SELECT
[Code].....
.net - One Dataset With Multiple Results Sets (multiple Select Statements) SQL Reporting Service?
Oct 15, 2011I 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 RepliesMultiple Select Of HTML Select Element?
Mar 22, 2011I 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..
Select To Multiple Sql Tables Using Select Query?
Jul 23, 2011I 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].....
Select Multiple Objects Like Checking Multiple Checkboxes?
Nov 24, 2010Is 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 RepliesCan't Select Multiple Records In SQL With ASP.net?
Nov 18, 2011I 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 Table
Jun 18, 2012how to select from multiple tables. so far this is my code how do i Dim dr As OleDbDataReader
[Code]...
How To SELECT To Multiple Table
Jun 18, 2012what 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 RepliesSelect Multiple Columindexes In Dgv?
Mar 14, 2010what 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]...
VS 2008 Return Multiple Table Rows To Multiple Text Boxes
Feb 27, 2011visual basic 2008 express
access 2007 db
I am attempting to fill a form with multiple rows from an access table based off of a parameterized query. My query works fine but I don't want to return one row at a time, I want to return all rows that match my query in multiple text boxes. I know that I can use a datagrid view to accomplish this, but I would prefer the look of a textboxes on a form. I have read through many books and searched the internet forums but think I may just not know what to search for as nothing has worked yet. Can anyone point me in the right direction. So far I have tried setting the text box value to the row().item(), creating a different dataset for each row, and even setting variables for the results of the query to then be passed to the text boxes. Since none of this work, I don't really have any starting code to post. If I could just get a starting point I could work from there, so don't feel the need to code anything for me, just set me in the right direction.
How Can Select Multiple Items In ListView
Oct 6, 2011I 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 Query Multiple Table
Mar 14, 2012how 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 RepliesMultiple Conditions With A SELECT From Where Query?
Mar 30, 2010I 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]....
Multiple Select With Duplicate Names
Mar 7, 2010I'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 RepliesRetain Values In Select Multiple Box?
Oct 28, 2011I 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 RepliesSelect Case With Multiple Variables?
Jun 25, 2011Is 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
Select Multiple Contols At Runtime?
Oct 6, 2010I 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 RepliesSelect Multiple Rows In Datagridview?
Jan 8, 2009I'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 RepliesSelect Multiple Values In DropdownList In Asp.net With VB?
Jan 20, 2012I 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?
How To Select Multiple Values Based On Parameters
Aug 11, 2011I 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 RepliesIDE :: Unable To Select Multiple Column In Datatable
Aug 2, 2011Unable to select multiple column in datatable [code]....
View 3 RepliesLINQ To SQL Select Distinct From Multiple Colums?
Apr 2, 2010I'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?
Multiple ListBox - User Cannot Select Same Items
Jun 9, 2010I 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.
Radiobutton To Select Multiple Choices From Listbox?
Jan 25, 2011Can'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....
Select Multiple Items In A Listview Programatically In WPF?
Jun 11, 2009Is there any way I can select multiple items in a listview programatically in WPF?
View 1 RepliesSelect Multiple Items In A Listview Programmatically In WPF?
Jun 11, 2009Is there any way I can select multiple items in a listview programmatically in WPF?
View 2 RepliesSelect Multiple Options And Unchecked It In Menustrip?
Sep 15, 2009Im 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].....
Select Multiple Pictureboxes For Drag'n'Drop?
Nov 23, 2010Is 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].....