Changing SQL Queries Based On Various Conditions?
Apr 16, 2012
deal with ever changing SQL queries based on various conditions? i am using Cmd.BindByName = True so it doesn't need to be in an ordered way when adding parameters. Just that this is the hectic way of doing the update SQL ..or even worse insert SQL/I favor doing parameters instead of using stored procedure bcoz i find it faster by using parameters .
SQLStr.Append("Update Table set col1 = :time ")
Cmd.Parameters.Add("time" , OracleDbType.Varchar2)
Cmd.Parameters("time").value = "xxx"
[code]....
View 3 Replies
ADVERTISEMENT
Nov 29, 2010
Let's say I have items in my WinForms application which have an expiration date. I have more different conditions than this one but let's do it simple. I'd like to trigger an event when an item comes to expiration. What is the ideal way to do so? Checking every X minutes?
View 3 Replies
Oct 12, 2009
I have a ListView that I populate with running processes and would like to highlight specific rows based on the amount of memory consumption. After I add the processes to the list and and call the WorkingSet64 property of the process, I tried this:
vb.net For Each lvi In ListViewProcess.Items If proc.WorkingSet64 >= 2000 Then lvi.BackColor = Color.Yellow End If Next
Processes is the variable I used to grab the collection of processes. proc is defined as a variable and then used to loop through the processes.
lvi is of course the ListViewItems in the ListView.So, by the code I have above, I loop through the ListViewItems, and if any of the processes are above or equal to 2000, then I set the background color to Yellow.
However, it sets every line to yellow, and I can't seem to figure out to set only those processes that have a WorkingSet64 above 2000.
Would I need to loop through the processes and then set the background color of the ListViewItem based on that? That kind of makes sense to me, but if I do that, I'm not sure how to set it just for those processes. Maybe by setting a separate variable?
View 6 Replies
Feb 15, 2012
I have a problem with sorting this thing. I want to sort a column without changing the data in the other column. i have an attached document. A picture of my query and database..
View 3 Replies
Jun 3, 2009
Have a table called AProjects in a SQL Server Express 2008 Database. This table has a date field (Data Type date) called Due. Trying to extract a dataset based on the following code / query in the Form Load sub in VB 2008 Express: All variables have been declared
conn.ConnectionString = "Data Source=LaptopSQLEXPRESS;AttachDbFilename='C:Program FilesMicrosoft SQL ServerMSSQL10.SQLEXPRESSMSSQLDATABTISbe.mdf';Integrated Security=True;Connect Timeout=30;"
conn.Open()
sqlProjects = "SELECT AProjects.ProjID, AProjects.RefNo, Clients.Client, " & _
"Status.Status, AProjects.Due " & _
[Code]...
View 6 Replies
Apr 30, 2009
I am a new to programming, trying to learn vb.net, so I apologize if my questions are very elementary or my terminology is incorrect. I am trying to format a query to an Oracle table based on user-selected radio buttons on a Windows form (i.e. the query will return different elements from the table based on the radio buttons selected). The query results will be placed in a listbox on the form. My thought was to make a Property containing my query like so:
[Code]...
and then I have a sub that feeds this SQL property (containing the query) into an OracleConnection.My problem is that I don't know how to customize that query depending on what radio buttons are selected by the user. Is a Property the best way to go about this, or is there some other way that may be better?
View 1 Replies
Jan 6, 2010
I am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
View 1 Replies
Sep 21, 2011
I have a project in VB.NET 2010 (compiling to x86, .NET 2.0 runtime) that I want to compile into two separate EXEs - a "lite" version and a "full" version. Unfortunately I cannot make two separate projects as it uses the Adobe Reader COM control - and sharing a form using that control between two projects seems to confuse the IDE (something to do with COM Interop, I assume - if someone knows how to share a form hosting the adobe reader control, that would solve my problem too).
I have found this thread: C#: VS.NET: Change name of exe depending on conditional compilation symbol however I don't have any MSBuild experience so I need more explicit instructions. On the "My Project>Compile" tab there is a "Build Events..." button. I was wondering if anyone knows how to set a conditional compilation constant and use that to determine the EXE name (or change it after build). If all else fails I can rename the EXE manually I suppose, but I'd prefer it to be automated.
View 1 Replies
Dec 11, 2009
Just wondering if someone can at least point out where I'm going wrong here. I've already got the code to populate the listbox by a button click from the user and am just trying to figure out how exactly to alter the text of a label based on what the user selects in the listbox. From what I have the Label will display the case else selection but nothing else despite my best efforts to get it to change. Here is what I've tried. I realize it is very trivial, but I am only a beginner to programming.
[Code]...
View 3 Replies
Aug 29, 2011
Attempting to set a color on a data row in my DGV if the value is True. As of now it changes all rows.
[Code]...
View 2 Replies
Feb 24, 2009
I have this VB.Net 1.1 project that I have to make some changes to. There is a flag in the App.config file. If it is false, the page just loads a splash screen and runs the program normally. If it is true it first opens a login window. VB.Net is not something I've ever worked with before. I can't for the life of me figure out where the logic for the picking the startup object is. In the property pages, Main.vb is always set as the startup object, but that's not even the window that loads up when the flag is false, it always comes after the splash screen.
View 2 Replies
Oct 12, 2011
When a SelectedIndex in a ListBox is changed I would like a textbox below the listbox that gives a description to be populated with the value from a description field in SQL.I have the following code so far, but I get an error that says "Must declare the scalar variable "@ReportName"
[code]...
View 1 Replies
Jan 1, 2012
I have done this in Php with a function before. I just don't know how to do it in VB.I have a character sheet creator for a game I am making. What I am wanting to do is write a single function, where in you click on a button and it will pass the text box name (so that it knows which text box to edit), as well as the value inside of the text box (to make sure that the new character stat ceiling is taken into account).
Private Sub Button_Click
AddtoValue(Textbox1,stats)
End Sub[code].....
Essentially, I need to know what to put for noidea, and noidea2, like, byval or byref or what?
View 3 Replies
Nov 8, 2011
What I've done so fa
Private Sub LogInToolStripMenuItem_Click(sender As System.Object, e As System.EventArgs) Handles LogInToolStripMenuItem.Click
Try
[code].....
View 1 Replies
Oct 18, 2011
Basically I want to move my mouse to the coords that is received based on the location of a certain coloured pixel. I can get the coords of the pixel but when using them on mouse position, the mouse position is based on the entire screen rather than the form. How could I change the position coords based on the form rather than the entire screen. E.G. If a certain coloured pixel is 2,2 in a form and I put that as the mouse position, it would go outside the form but I dont want that. I want it to hover of the pixel coords
This is my
Dim bmp As Bitmap = DirectCast(PictureBox1.Image, Bitmap)
For x As Integer = 0 To bmp.Width - 1
For y As Integer = 0 To bmp.Height - 1
If bmp.GetPixel(x, y) = (Color.FromArgb(108, 90, 60)) Then
Windows.Forms.Cursor.Position =
End If
Next
Next
View 2 Replies
Mar 10, 2010
Is there anyway to take a static stream reader, and switch it to another text file based on the user changing the file?
View 1 Replies
May 10, 2009
Public Class Inventory_Edit
Private Sub Inventory_Edit_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CategoryDataSet.Category' table. You can move, or remove it, as needed.
Me.CategoryTableAdapter.Fill(Me.CategoryDataSet.Category)
[URL]
I added an "edit" icon on my bindingNavigator. When users click on it, a new form will come out and pull out all the data records from the datagridview. Now the strange thing is that when I wanted to edit the data records, when I left the product name blank, I would get an error message saying "Product cannot be blank" - please see above code. But when I left the "Cost Price" blank(same applies to "Sell Price" and "Quantity"), the error message box wouldn't come out, instead, it did not allow me to move on to another textbox, close the form etc until I filled out that textbox with INTEGER. May I know why the error mesagebox would not come out when I entered the wrong datatype?
View 12 Replies
Oct 11, 2011
the testBoolean is set to the value True, but for some reason when debugging, it step through both conditions, so in the end the button1.visble becomes False, but I want it to be set to True.[code]....
View 14 Replies
Feb 1, 2011
I am very new to vb, I know there is an error somewhere, I had an assignment which stated that if a number was < 101 or > 500 and the answer is correct the output should be, for example-123, if the answer was wrong then the message output should be wrong number <101>500. Everytime I type in a number(no matter what the number) and click on my check button I get the output message. If at all possible, can you please assist. My professor gave the following example, but I am still not getting it:
Dim strInteger As String = "52.801"
Dim dblNumber As Double
dblNumber = CDbl(strInteger)
[code].....
View 4 Replies
Sep 21, 2010
I'm searching for a way to change the font size of selected text in a RichTextBox (rtf) having different font families (e.g. Arial and MS SansSerif) and font styles (underline, bold...) using the FontDialog, but without changing the families and styles. The following code resets all the font attributes, which is not what I want:
[Code]...
View 5 Replies
Jun 20, 2012
I want to use a value that is pulled from the SQL within the if statement. Ideally i want to do the equivalent of <% If DataBinder.Eval(Container, "DataItem.BookID") == 1 Then%> Is there a way to do this with the correct syntax?
View 2 Replies
Jun 21, 2010
How to combine these two conditions in one section
Private Sub DataGridView1_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles DataGridView1.CellValidating
'condition 1
' check given value is numeric or charactr type
If e.ColumnIndex = 3 Then
If Not IsNumeric(e.FormattedValue) Then
DataGridView1.Rows(e.RowIndex).ErrorText = " must be a numeric value"
[Code] .....
'condition 2
' check given value is greater than 0 or not
If e.ColumnIndex = 3 Then
If (e.FormattedValue.ToString = "0") Then
[Code] .....
View 2 Replies
Jun 6, 2011
I have and existing .rdlc file where I display the grades of each students as well as the general average. I get general average like
=FormatNumber(Switch(Fields!YearLevel.Value="LC7" or
Fields!YearLevel.Value="LC8",(IIF(Fields!SectionName.Value<>"1st Sec A" and
Fields!SectionName.Value<>"2nd Sec A",
[code]....
I want to display:
"1st Honor" if gen. ave is >=90 but all the subject grades must be >=90 also
"2nd Honor" if gen. ave is >=88 but all the subject grades must be >=88 also
"Third Honor" if gen. ave is >=85 but all the subject grades must be >=85 also
How do I do it?
View 6 Replies
Dec 9, 2011
So I am trying to evaluate 3 conditions in an if statement. Its not working how I would assume it should. I basically want to do this:
vb.net
If PGN = &HEF007E And PGNData(0) = &H58 And (PGNData(1) And &H40) = &H40 Then IgnOn = True Else IgnOn = False
If I write it in that manner it gives inconsistent results. If I workaround by writing it this way it works perfectly:
vb.net
If PGN = &HEF007E And PGNData(0) = &H58 Then
If (PGNData(1) And &H40) = &H40 Then IgnOn = True Else IgnOn = False
Endif
What is the proper way to do this with only one if statement?
View 7 Replies
Jun 8, 2011
Having problem make last if an statement work in the code. the variables in the if statment are doubles but the ide keep telling i need a proceeding if statement. but is already there it is in the last if statement of the code
Public Class Form1
Dim Totals As New List(Of Double)
Private Sub btnclear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE].....................
View 4 Replies
Feb 15, 2012
I'm doing a stock Control System as a school Project using An Access 2007 DB and Visual Studio 2010. I'm trying to do an update Query based on two variables entered into comboboxes, I cannot get the VB to accept the conditions for this, Can anyone Help me?[code]I Cannot get the Code to recognise the Last "'", is there a way to do this?
View 7 Replies
Jul 28, 2011
The following code is looking for the phone number of contacts in a database when the column "hoohoo" = 15. However it doesnt keep to this condition, but displays all of the numbers. Am i missing a line that tells it to keep to the condition???
Dim SQL As String = "SELECT *, Phone FROM TblContacts WHERE Hoodoo=15"
Dim myOleDbCommand As New OleDb.OleDbCommand(SQL, con)
con.Open()
[Code].....
View 2 Replies
Feb 18, 2008
client2 so like this my treeview has be displayed.i can able to display the value in my treeview.my requirement is i need to keep image for the treeview nodes. for example Group1 - sample1.gif server1 -sample2.gif client1 -sample3.gif so i need to keep images to this nodes at run time and i need to chage the image depeds on my need. for example in some situation i will keep sample2
View 3 Replies
May 7, 2010
i want to set 2 conditions for a for loop as i want to loop through the same line of code at the same time . here it is as i have it now
it does not work how i want it to as i want both loops to run simuntaneously instead it runs the first loops continuously before the second and way around this?
For Me.i = 0 To maxrows - 1
For Me.h = 1 To maxrows
Me.Controls.Item("TextBox" & Me.h).Text =
[Code].....
View 1 Replies
Apr 10, 2012
I am trying to combine 2 regular expressions into 1 with the OR operator: |
I have one that checks for match of a letter followed by 8 digits:
Regex.IsMatch(s, "^[A-Z]d{8}$")
I have another that checks for simply 9 digits:
Regex.IsMatch(s, "^d{9}$")
[Code]...
Apparently I am not combining the two correctly and apparently I am horrible at regular expressions.And for those wondering, I did take a glance at How to combine 2 conditions and more in regex and I am still scratching my head.
View 5 Replies
