Im trying to make it so that the user can pick what column to see and what now to see. How would I make it so when the user right clicks anywere thats on the column name show a contexmenustrip?
View 3 RepliesI use split button with ContextMenuStrip and i need to fill ContextMenuStrip with data in database like item name
View 2 RepliesHow can i insert a multi-column combobox into a contextmenustrip?
View 2 RepliesIt's possible to select random a column in SQL 2005 using SqlConnection? And this column to send "UserID" e " ChName" for Label1.Text and Label2.Text?
example: after choosing random the column, send "UserID" and "ChName" to Label1.Text and Label2.Text.
Unable to select multiple column in datatable
Code:
Dim Activitydtb As DataTable = DirectCast(ViewState("TalentcharacterActivty"), DataTable)
grdviewactivity.DataSource = Activitydtb.Select("SELECT
[Code].....
I'm writing a help application for the Customer support team at my company to help agents ask better questions when customers report problems. In it, I've got a SQL database that contains all the products, topics, and questions. The layout is similar to the following:
Products Table:
Product_ID Product Name:
Topics Table:
Topic_ID Product_ID Topic
[code]....
I don't know if I'm making myself clear, but I basically need to do the equivalent to the following SQL statement: "SELECT PRODUCT_ID FROM Products WHERE PRODUCT_Name = LstProducts.SelectedValue"
I am going to make a invoices then.. they are going to have a id it is not going to be identity, it is not my idea, this is the idea's my professor's. then he want it so..he didn't want i change id to int, he want it was varchar..but now i have seen this is as identity.. id =1, next id=2, next=id=3.. but it doesn't mind he told me in the future it is going to be so..
abc000002
abc000003
abc000004
[code]....
then for that he doesn't want i change it to int how can i get the last? i want it one plus next i want it was
abc000010
how can i do it? i am working on visual basic and visual studio 2008i can use a loop-for, or a query for solve it?
Im trying to restore my program from the system tray using a Contextmenustrip. Ive googled it but can seem to find anything.
View 7 RepliesI have 9 small PictureBoxes that all have the same ContextMenuStrips. I need to be able to change the Backcolor property of the PictureBoxes via a ColorDialog. How would I determine which PictureBox has been selected so I can apply the correct PictureBox with the chosen color?
View 3 Repliesim trying to work with adding controls in runtime. Anyways ive added a ContextMenuStrip control in runtime and added a item called "Display". The ContextMenuStrip is also added to textbox's that are also added in runtime and when i right click a textbox i see the "Display" but i want it to do "msgbox(textbox.text)" when i click "Display".
[Code]...
I'm using VB.NET 2008. I have a form with about 10 or so labels on it, and that could increase the more I develop my assignment. I would like to give each of these labels a context menu, which says "Whats this?" and provide a message box to the user with the appropriate help text. Now what I've done so far is created a contextmenustrip on my forum, and linked all the labels to that single contextmenustrip. I have also added a menu item to that strip called WhatsThisToolStrip MenuItem, but I am at a loss, on where to go next, and find out on what label the contextmenu was activated on?
So for example if a user right clicks the lblStatus label and selects "Whats this?" item a different message box will appear than if the user right clicked the lblSid label.
how do I add items to a select column? Say I have ColumnA and ColumnB, how do I add items to ColumnA then add items to ColumnB? I have:
lvlist.Columns.Add("Cars", 150, HorizontalAlignment.Left)
lvlist.Items.Add("Car1")
lvlist.Items.Add("Car2")
lvlist.Items.Add("Car3")
[code]....
I has a datagridview and now I would like to determine that whether column1 in row 1 is selected by the user.What should I write to do so?
Private Sub DataGridView1_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick
[Code].....
How to get all data in a selected row in datagridview ?
View 1 Repliesi have more than 10 table but same column names i need to collect datas from these table for example i need to select name column from 10 tables how to do this
View 8 RepliesI need to Quarry from Data Table Like
select Name, Address from myDataTable where name = 'x'
and
select distinct(name) from myDataTable
I have a Xtragrid where when I double click the row I need to be able to pass the value of one of the columns to a stored procedure. There's got to be an easy way to do this but I haven't been able to find it.
View 9 RepliesI want to select a datagridview row according to its column value (i.e. user id) when I click on that row (with sql command).
I had following coding:
If chkboxMvOut.Checked Then
Dim oledbCMD As OleDbCommand = New OleDbCommand
oledbCMD = New OleDbCommand("UPDATE qmaint.ots_output set Timeend = '" & CStr(time2) & "' + Remark='" & txtRemark2.Text & "' + Cstate = 'Move Out' where user_ID ='" & lngUserid & "'", myConn)
oledbCMD.ExecuteScalar()
End If
Dim MyQuery = From c In xdoc.Descendants() _
Where c.Attribute(OriginY) IsNot Nothing _
Order By Val(c.Attribute(OriginY).Value), Val(c.Attribute(OriginX).Value) _
Select c.Attribute(UniStr)
Right above you can see my First! linq attempt! And here comes my first question.
How can i select more than one column in a linq query in vb.net?
For example... Select c.Attribute(UniStr) AND c.Attribute(OriginY)
The data type for my DATE column in SQL is smalldatetime. I want to perform a query which selects records based on the the selected date of a calendar object.
A user clicks on the date and the date is stored in ddlfilter2 DDLfilter2.Items.Add(CalendarMain.SelectedDate)
mystring = "SELECT * FROM view_main where date" & "='" & DDLFilter2.Text & "'"
produces this "select * from view_main where date='24/03/2009'
I then get an error saying "The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value."
In the SQL database the data is displayed as "24/03/2009 00:00:00" is this why the query is failing?
I have a query that executes fine in TOAD, but when bringing back the results with either an ADO.Net DataReader or DataAdapter/DataSet, it's not recognizing a column in the select statement. See the query below... the column in question has its data coming from a dynamic table or sub-select or whatever you call it. I don't see why this is a problem in .Net:
Dim sql As String = String.Format("select bu.row_id, bu.name, selectedOrgs.bu_id as selectedOrg " _
& " FROM SIEBEL.s_prod_int_bu pb " _
[Code].....
How do i use Datatable.select method to select only those rows where a specific column value is blank?
View 16 RepliesI was wondering how i could pass the following SLQ function to my datatable:
Select sum(Quantity) from Purchases where transaction_mode=1
I'm just a frustrated noob trying to get past my first DB Program. My goal is to get relational data from different tables all ordered by a certain field..Ive noticed early on that i cannot select a column when its name has a space.[code]Now the statement i want to use is sql = "SELECT [PT.Chart Number],[PT.Last Name],[CA.Case Number] FROM Table1 AS PT INNER JOIN Table2 AS CA ON PT.Chart Number = CA.Chart Number ORDER BY PT.Chart Number"..When i Debug i get the same type of error ("... Can't find column name PT.Chart... ")I'm new to sql so i dont know if my syntax is off.
View 4 Repliesi am using the grid from dev express.. in vb.net 2005..when i choose a row to edit, in that row, when i select a particular column , then cursor show focus in that particular column , instead it is focused in the first column in that select row.
View 1 RepliesUnable to select multiple column in datatable [code]....
View 3 RepliesI have a column in DB called price with Decimal as its datatype. when I use:dim r as objectAccessConnection.Open()cmd = AccessConnection.CreateCommand()r = cmd.CommandText = "SELECT AVG (Price) FROM Sale;"I receive an error "Decimal byte array constructor requries an array of length four containing valid decimal bytes."It works fine with other datatype such as Integer and Double. What is my problem?
View 1 RepliesI'm writing an app for someone where I am pulling in work orders table information. The information includes: worknum, fname, lname, customername, description, etc. I do not plan to update the data in this table, only to read from it.I'd like to display a combo box for the work order numbers. The user would start typing the information for the work order in and it would autocomplete based on what's in the list. As work orders are displayed in the combo box, I want to update the data in text boxes representing the various fields.
I'm thinking rather than query the database several times, it would be a good idea to create a DataSet with information for the work orders table within the last x months then query the data from that dataset. I know there is a DataSet.Select method, but it looks like it returns the entire row. Is it possible to retrieve just a column of distinct values? For example, I'd like to do a select statement similar to this:
SELECT worknum FROM {WorkOrderDataSet} WHERE date >'{today-x}
The first part in curly brackets is meant to represent the work order dataset I create when first importing the data from Access. The second part in curly brackets will be replaced with variable data to represent a date to reference. I also don't think I'll need distinct because the workorder is unique (edit: is a primary key)Is it possible to retrieve just a column of distinct values from a DataSet with multiple columns? How do I do this?
I use this connection:
Dim connetionString As String
Dim cnn As SqlConnection
connetionString = "Data Source='" & txtHost.Text & "';Initial Catalog='" & txtDatabase.Text & "';User ID='" & txtUser.Text & "';Password='" & txtSenha.Text & "'"
cnn = New SqlConnection(connetionString)
cnn.Open()
cnn.Close()
How I read to SQL using "SELECT * FROM table ORDER BY rand()", select a random column and send the value "User" and "Password" of this column to Label1 and Label2.
I have the properties. I have the format property set to TIME. The text box on the form now shows the time. But when you click on the pull down, you get the date picker.
View 2 Replies