I have more than 100 controls (labels, textboxes, menu, Gridviews etc).I want onclick a button to turn all these controls to visible = true Now I need to code them one by one. Is there a code (in VB if possible) to make it applies to all in the control ?
View 2 RepliesIs there a command to select all controls ?
View 3 RepliesI have a Gridview that I want to filter. My gridview is in an update panel and my filter button is not. On button click i have the following
protected void bttnfilter_Click(object sender, ImageClickEventArgs e)
{
if (TextBox1.Text != "")
{
[Code].....
So i add to the select command but I'm getting an error. How should I go about this? I don't want to use dynamic sql.
I have a select statement, the code i have selects the item numbers from table(OrderItems) that is filtered with a combo box.[code]...
View 2 RepliesOn button Click I want to Set the Select command of a Gridview. I do this and then databind the grid but it doesn't work. What am i doing wrong? [code]
View 2 Repliesi have use this code to search the records of my datagridview and put it on my datetimepicker, there's no error occuring but it's not working either?
Public Sub SelectRecordM()
Try
Dim dbConn As OleDbConnection
Dim dbSelect As New OleDbCommand()
[code]....
I need to filter a measurements table that consists of 63 measurement objects that may or may not be tested more then once. The entries are put in a Batch table on a SQL server in the following fashion:
ID: | Serie | Test object | Min Amps | Max Amps | OK?
DateTime| String | Integer | Double | Double | Boolean
So there may be multiple entries in my database with the same series and testobject number but with (slightly) different results.
Currently I just select: SELECT * FROM Measurements WHERE Serie = 'XXXX' and use a datareader object to fill a datatable and then I let loose a routine on it that will either: Get the last result that produced a good measurement, so OK = 1 and max ID. Or the last result that produced a bad measurement if there are no good ones. I then end up with a list of 63 either good or bad measurement objects with the last good result, and if there isn't one then the last bad result.
Now I know that SQL is quite powerfull and I suppose that it must be possible to directly query for these results without a programatical routine re-filtering the results. I suppose it's like Selecting within a select statement..
I'm trying to create this select command against Access Database----Keeps giving me error saying operator is missing I just can't seem to figure it out
da2.SelectCommand.CommandText = "SELECT RecordList.RecSchNo, RecordList.RecTitle, RecordList.RecReasonCode" & "FROM DispReasons INNER JOIN RecordList ON DispReasons.ReasonID = RecordList.RecReasonCode" & _
"WHERE DispReasons.ReasonID =?;"
SchultzMan
I use a Datagridview control, in which I need to display info and after that to export it to an excel document(but the export to excel part it's not important right now). I need to display in the Datagridview 2 fields:name and item, from a table(here 's where I thought I should use select) and also the value field which has to be calculated using a certain formula...
Let's say value= a+b
My SelectCommand.CommandText is:
dtaadpPoints.SelectCommand.CommandText = "SELECT TOP 1 * FROM PointsTrans WHERE UserID=" & UserID & " ORDER BY PointNo DESC"
This should select the top row from the table PointsTrans where the UserId is what has been declared earlier when sorted in descending order.
But when I stopped the code to see what was happening there dtaadpPoints.SelectCommand.CommandText containe
I'm new to vb but acquainted with programming in java, C, and other languages. I'm developing an application and I'm having difficulties at commanding controls from different forms. It's like this: Form1 has some buttons and charts, and in Form2 it's a "Settings" form to select the category and series for the charts. When i close the Form2 I need to activate some controls like buttons in Form1 and the problem is that at run-time I can call functions like this one:
In Form1:
Public Sub EnableButton()
button1.Enabled = True
End Sub
In Form2:
Public Sub BeforeClosing()
Form1.EnableButton()
Me.close()
End Sub
Using breaks I can see that they execute and the properties of the button change but after the close event of Form2, the properties of the button1 control become unchanged. At the global variables I have:
Dim newChart As System.Windows.Forms.DataVisualization.Charting.Chart
At ButtonX_Click i create a new chart and define some properties and in the end i activate the Form2
Private Sub ButtonSettings_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonSettings.Click
[Code] .....
So the sequence is:
Form1 Execute: Button_Settings_Click -> initialize chart and Form2.Show()
Happens: Chart Initialized and properties are changed Form2
Execute: Button_OK_Click -> Form1.Button_ShowChart.PerformClick() and Me.Close()
Happens: Sub .PerformClick() executes but values are not changed Form1
Execute: Button_ShowChart_Click -> Add data to Chart
Happens: Chart is found as NULL and properties are lost
Why does the controls properties are lost if they are executed???
Sqlserver Table1 has following data
CODE:
I want to get following result
CODE:
That is grouping on date.
What command should I write to get above result
I posted a while ago about having issues with a database, and selecting a value from the database. I was told that there were things missing from my code, and I've not gone back and added the things I was advised to. Now, my code seems to be working more, but outputting the wrong value.
[Code]...
For example I have 2 things in the listbox:Install Registry keyDelete filesIf I choose "Install Registry Key" then the button should install the registry key when clickedIf I choose "delete Files" then the button should delete files when clicked
View 2 RepliesWhen I click the "Edit" button, and it switches to the EditItemTemplate view on the right, I want to prefill the Textbox and select the corresponding option in the DropDownList. [code]...
View 2 RepliesI'm getting ok connection to the database... but it's always telling me that I don't have permission to use the SELECT command with some table called 'proc'.
View 1 RepliesSo based on what is selected in a radiobuttonlist i want the select command to change for my datasource. The problem I'm facing is that if i set the default selected radio button the query will work for that
my radiobuttonlist , user (dropdownlist are all located in an update panel that is not updated after the button is clicked
this my button code
If user.Text = "ALL" Then
SqlDataSource22.SelectCommand = "SELECT * FROM [dashboardtasks] WHERE [completed] = 'NO'"
[Code].....
I see the examples where I can export a table into an Excel Worksheet by using
SELECT * INTO [Excel 8.0;Database=C:Book1.xls].[Sheet1] FROM [MyTable]
But I can only use [MyTable] if it is a binding source correct? What i would like to do is something like:
[Code]...
I am working on a Windows forms project that connects to a Microsoft Access database, reads the the file, does some math and then provides some basic statistics back.I am teaching myself VB and I know the code below could be more efficient.However, right now I am just trying to make it functional.The program filters the data it needs via sql, and there are several sql statements.I separated the code for each of the sql statements and into a subroutine so that I could call each one when the form loads and also when the user clicks a button to update.The program works fine on the form load, however, when you click the update button you get the following error on the 'odaCalls.Fill' in subroutine Count(): "The select command property has not been initialized before calling 'Fill'.[code]
View 1 RepliesI have a Web Browser in my vb form which has some url....what I need to do from the webpage is "Right Click -> Select All -> Copy-> Paste "-> in a textbox . How can I do it ?
View 4 Repliesi try to select controls using LINQ but it show error
here is the code:
Dim testcontrol As VariantType
testcontrol = From cControl As Control In Me.Controls.OfType(PictureBox) Select cControl Order By Name Ascending
[Code].....
I am using select command for one of my button
Dim edit1 As OleDbCommand = New OleDbCommand("select * from [exporter] where exp_id='" & t1.Text & "'", con1)
now:-
t1 is a textbox
and in my table exp_id is "Number" now when i run this i get an error at the time executing reader (Data type mismatch in criteria expression.) but when i change exp_id properties to "Text" it run's properly
Is there a shortcut like CTRL + A which can select all controls in a container instead of all the controls in the form?
View 3 RepliesIn 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 RepliesI want to be able to select any control on the vb form at runtime. These controls will be added to theform on a click of a button. So essentially I want to dynamically be able to add and then select these controls at runtime. I would also like to make these controls dragable on the form.
View 1 RepliesFirst let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
If i click "chose items" to select some controls to new tab in toolbox, VS 2008 SP1 closed automaticaly. what might be the problem?
View 2 RepliesI am currently using psexec.exe from PsTools to send a command to a remote system to fire a command through a command prompt however I am finding that the shell I am doing does not seem to like the spaces in the path.
[Code]...
Any ideas on how I handle the following error thrown in the SqlDataAdapter.Fill as a result of the BeginTrans in the callee?
System.InvalidOperationException = {"ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction.The Transaction property of the command has not been initialized."}
[code].....
Public Sub ExecuteTransaction(ByVal connectionString As String) Using connection As New OleDbConnection(connectionString)
Dim command
As New OleDbCommand()
Dim transaction
As OleDbTransaction
[Code]...