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].....
I 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 am using VS 2010, SQL 2008 express and doing windows applicaion programming in vb.net.I want to write a select query(or Stored Procedure) such that the conditions mentioned under WHERE clause can be variable .like :Select * from TABLE where F1 = var1 and F2 = var2 and F3 = var3.Now on the basis of some conditons the equations in where clause should beused.Say condition is variable value >6.Now in this case ,if
var1 =7 var2 =3 var3 = 8 then the query shud behave like
:
select * from TABLE where F1 = var1 and F3 = var3
[code].....
im trying to write a query using multi 'where' conditions however am having so difficulty making it suitable for vb, sql = "SELECT * FROM Room WHERE [Room Size]= '" & Noofppl.Text & "'" AND [Number of PC's] = '" & noofpcs.Text&"'"
View 7 RepliesHow to find the best way to develop a way to send a meeting request with a .Net application. I'm beginning in .Net development. The thing I'd like : the user has a form where that he can fullfill with the info about the meeting. Then, the server creates a .ics file with those information. I'd like next to suggest the user to send this meeting request. So, is it possible to create a mailto with an attachement that's located on my server? Is it the best way to handle this problem? Ain't there any other possibility to interact between an app and Outlook? I'm developping in VB.Net for a web application using the framework ASP.NET MVC 3.
View 5 RepliesI'm trying to build a inter-group meeting schedule, which could be described as a distributed sequence with recurrence relationships (restrictions).
View 2 Replies[code].....
View 1 RepliesCode Coring Experience Live Meeting the Visual Studio Team Visual C# and Visual Basic languages continue to evolve towards feature parity, strive to simplify programming and deployment with the Microsoft Office APIs, and allow easy interop to dynamic languages. In the tools space, Visual Studio 2010 offers greater support for Test-Driven Development, where tests are written before product code as an iterative approach to software design. In this interactive session you will get a chance to connect with the two Program Managers DJ Park and Dustin Campbell as they walk through the feature areas they feel will have the greatest impact to you and your development teams.
[Code]...
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?
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 RepliesI 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].....
Here is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
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 RepliesHow 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] .....
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?
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?
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].....................
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 Repliesclient2 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 Repliesi 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].....
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.
how can we add images in treeview using vb.net. Different images in different conditions .
View 1 RepliesI am using VS2008 and VB.NET. Can someone provide or point me to info on how to add a Terms and Conditions form to an installation? The user would have to accept in order for the installation to continue or else cancel installation.
View 2 RepliesI am developing a website on writing reports ...users can comment on a report (huh!! as if a new thingy ;))..back to question..what am doing is showing the comments using a listview.
Question: i want that when someone comments on his own post the row should be of different color, so that its clearly visible that the post owner has commented...I have seen this in Scott Guthrie's blog.
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]....
Using the Application Framework in a WinForms Project, I need to check conditions to determine whether the application should run at all and if it shouldn't run then I need to kill it before it even shows the main form. My conditional checking is occurring at the MyApplication.Startup event handler, so all I need is the method that shuts down or kills the current application.
I'm pretty sure this question's been asked a thousand times, a few of those even by me, but I can never remember the right language to get any useful info out of a Google or MSDN Search string.
It never hurts to try. In a worst case scenario, you'll learn from it.
I've recently started running into DotNET difficulties with newer HP and Dell systems that are pushing x64 processors and operating systems onto a totally unaware end-user market, so suddenly a lot of work I've done in VB.NET is going to ____ in a handcart; specifically all the work I've done with 3rd Party tools that are only available in x86 or x64 builds and not DotNET Native builds for any CPU. The biggest problem is that all the DLL File Names, in-code Namespaces, Classes, and Methods are totally identical - just one version is compiled for 32 bit and one for 64. What I need to do to fix this is provide some #If compile conditions that alter the paths of existing references based on the Build Configuration, so that when I'm compiling for the x86 platform it references C:DBAPISQLitex86System.Data.SQLite.DLL but when compiling for x64 it references C:DBAPISQLitex64System.Data.SQLite.DLL.
I don't have a problem writing compile conditions, but can't figure out how to alter the reference paths before the compile begins, short of manually removing one reference and adding the other every single time I need to do a dual-platform compile.
I'm working on a piece of code at the moment that allows the user to enter values into fields. Once the user clicks on the 'save' button I am checking those fields against certain conditions (essentially calling a bunch of stored procedures to assess the values). If any of these 'rules' are met, I need to generate a popup that informs the user that certain values need to be fixed before they can continue for some of the conditions, and for others just to inform them of what conditions may need their attention. how do I generate a popup box in my codebehind if the conditions are met?
View 1 RepliesI have been programming an activation type of security protection for my software but i ran into problems when i try to generate an alphanumeric key with conditions. i cant seem to be able to make the keys to be valid with the condition.Basically i can get the 25 keys but all of them seem to be returning 1(ones) instead of 0(zero which what i want. below is my sample code may be someone can tell me what i am doing wrong, by the way i did google, woogle,bing, bang, yahoo, yadoo etc but no go.
generate the keys
Public Function GenerateCode() As Object
Dim IntRnd As Object
Dim IntStep As Object[code]....
the damn thing keeps returning 1 instead of 0. I do know i can simply change to 1 and be off the issue. but if is that easy to generate 1 the isnt easy just to break it. oh yeah the whole thing hangs when i generate the code? if i loop it, its able to get a 0 but i cant take the key thats in the loop?
I have been programming an activation type of security protection for my software but I ran into problems when I try to generate an alphanumeric key with conditions. I cant seem to be able to make the keys to be valid with the condition. Basically I can get the 25 keys but all of them seem to be returning 1 (ones) instead of 0(zero which what i want.
Code:
generate the keys
Public Function GenerateCode() As Object
Dim IntRnd As Object
Dim IntStep As Object
Dim StrName As Object
[Code] .....
The damn thing keeps returning 1 instead of 0. I do know I can simply change to 1 and be off the issue. but if is that easy to generate 1 then isn't it easy just to break it. The whole thing hangs when I generate the code? If I loop it, its able to get a 0 but I cant take the key that's in the loop??
