Using An SQL Like Statement In Code
Mar 10, 2009
I have 3 tables: Users, Plan, Organization [code]What i want is when a user logs in, and opens frm.Plans to only allow that user to view Plans for his/her company. This is the sql statement i have currently:"Select Plan.*, Organization.*, [Users].* from Plan left outer join Organization ON Plan.Plan_Name = Organization.Company_Name inner join [Users] on [Users].Company_id = Organization.Company_id where [Users].UserID = current_user and Plan.Plan_Name like '%'+@Organization.Company_Name+'%'"My login code is also posted in this forum with the title "Login Permission".
View 14 Replies
ADVERTISEMENT
Apr 22, 2011
I'm writing something that will examine a function and rewrite that function in another language so basically if inside my function F1, i have this line of code var x=a.b(1) how do i break up the function body into symbols or "tokens"?I've searched around and thought that stuff in System.Reflection.MethodInfo.GetMethodBody would do the trick however that class doesn't seem to be able to have the capabilities to do what i want..dit 2:basically what I'm trying to do is to write a program in c#/vb and when i hit F5 a serializer function will (use reflection and) take the entire program (all the classes in that program) and serialize it into a single javascript file. of course javascript doesn't have the .net library so basically the C#/VB program will limit its use of classes to the .js library (which is a library written in c#/vb emulating the framework of javascript objects)
View 4 Replies
Aug 3, 2009
It looks like this: Itis stripping out HTML characters.
Imports System.Text.RegularExpressions
Function GetTextFromHtml(ByVal htmlText As String) As String
[code].....
View 1 Replies
Oct 8, 2009
I only want to return a certain number of rows into the DataTable via LINQ's Take or use it on the Rows property, but I am not sure how or where to do it: Here is the current code:
Dim dt As DataTable = GetDataTable("sp", params)
For Each dr As DataRow In dt.Rows
Dim o As New OR()
[code].....
View 1 Replies
May 27, 2011
How would you go about reducing the code for this but still allowing it to work the way it is now
Dim updatelesson As String = cmbChange.SelectedIndex
Dim chosenlesson As String = cmbSession.SelectedIndex
Dim changed As String = lstNames.SelectedItem
[CODE]....
View 3 Replies
Jan 29, 2010
Write the pseudo-code for an If..Then statement that determines the apropriate tax rate for a given annual income level using the guide below:
Under $20,000 = 2% income tax
$20,000 - $50,000 = 5%
$50,001 - $75,000 = 10%
This is what i wrote:
If Annual Income is < $20,000 Then
income tax = 2%
If Annual Income is $20,000<= $50,000 Then
[code]....
View 2 Replies
Dec 22, 2009
It's just before while I found that expression (see my signature) is possible, so this request is not about what 'I am missing', but what I can think of. It would be nice to have named sections of code in visualbasic, which would replaced almost everything you can miss about GoTo. Imagine this:
Section Compression
For Each item ...
If Not item IsV...
[code]....
View 4 Replies
Aug 26, 2010
How do I write the equivalent c# code below in vb.net? This 'About' form is launched by a ToolItemMenu. It is just informational and contains only an OK button
//Form contains company logo, copyright info and OK button.
public About formAbout;
using (formAbout = new About())
[code].....
View 1 Replies
May 2, 2011
The code is as follows
dim st as string
st="select * from employees where empName='" & textName.Text &"'"
' The empName is Dani'e
'So the single quote with in the name Dani'e makes the vb.net code to halt.
View 3 Replies
May 17, 2012
As you can see from the code below there is a lot of repeated code. I want to move that code outside the if statement as it's performed for each if, but the Dim employees variable I'm declaring is causing my issues. I don't know how to declare the variable outside the if statement as it's a linq-to-sql query, so I can later define it within the if statement. I can't access employees outside the if statement, so I can't just put the repeating code outside the if statement.
Private Sub btnFindEmployee_Click(sender As System.Object, e As System.EventArgs) Handles btnFindEmployee.Click
If chkSrcEmpID.Checked = True Then
[CODE]...
View 1 Replies
Jun 3, 2009
I have an application that contains both test code and production code. The test code points to the test files on the local machine while production is located on the server. I comment out the production code when testing. To save some time I figured I would create a Global Variable integer called pTest and encase the test and production code in a Case statement so that if I set pTest=1 then the test code will run and if pTest=0 then production code will run.
[code]...
View 6 Replies
Sep 26, 2009
Dim i As Integer
If Label1.Text = "" Then
i = BPORes_csvDataGridView.CurrentRow.Index
Label1.Text = BPORes_csvDataGridView.Item(0, i).Value
[CODE]...
I have this code in the click event for a button I want to be able to select a row in my datagridview then Hit the ok button and have it populate to text box1 if textbox1 is already filled then i want to go to textbox2 and so on, (total of 6) So far if extbox1 is empty "" and i click ok button it populates, when i click ok button again to textbox2 does not populate.
View 8 Replies
May 8, 2012
I have an SQL statement which i need to code in vb:
CODE:
Notice the fields prodno1 and prodno2 in the table structure.. this is part of a number of sql statements i need to run and put inside a loop. my problem is i want to automatically use this same code such that on the next loop, this sql statement is going to be:
CODE:
Note that in this "2nd loop"
- the table name is now r3 from r2 in the first SQL statement
- there are now prodno1, prodno2 and prodno3 instead of just prodno1 and prodno2
- in the WHERE clause, the p.prodNo becomes p.prodNo2
And so on and so forth.. so for the 3rd loop
- there's going to be r4
- there's going to be prodno4
- in the WHERE clause i will use p.prodNo3
View 3 Replies
Jan 20, 2012
I have a class with a static list of keys, and I have a static method called Remove() that removes a key from that list.Now what I understand from the contracts post conditions is that as the programmer of the class, I guarantee that the current public method does something specific, in this case : removing the element of the list.
Here's what I've written:
private static List<Keys> m_usedKeys; // private list of keys
public static void Remove(Keys _key)
{
[code]....
What I'm trying to "Ensure" here, is that the Remove() method removes the key for real from the list (Yes this might be a trivial example, but I get the error there.)when I write the Contract.Ensures() line, VS2010 gives me the following error :
Error 3 Detected expression statement evaluated for potential side-effect in contracts of method 'LibJungleTimer.KeyBind.Remove(System.Windows.Forms.Keys)'. (Did you mean to put the expression into a Requires, Ensures, or Invariant call?) C:UsersJoelDocumentsProgrammationJTJungleTimerLibJungleTimerKeyBind.cs 51
I think this error says that the expression m_usedKeys.remove(_key); has a potential side-effect. In fact, it has a side-effect, it removes a key from the list!If I try to write something like this instead :
Contract.Assert(!m_usedKeys.Any(x => x == _key));
well it compiles fine.
View 1 Replies
Jul 8, 2011
I cannot seem to figure out why VB keep throwing me this exception but here is the code
[Code]...
View 3 Replies
Jun 4, 2009
I would like to get some input as to how I would create the same code without a dreaded "goTo" statement. This is something i've wanted to get an answer to for a while and just thought about it again.
[Code]...
View 6 Replies
Jan 13, 2011
I am used to C like languages such as C#. I added a list box with a list of names. In the code behind I added the below code. When I run the code I am getting the MessageBox but it will state "UserName favorite color is " but does not show the color. I thought it might be misspelled or non-matching names but this is not the issue due to the names being correct.
Public Class Form1
Private Sub lstData_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstData.SelectedIndexChanged
'Declare Variables
[CODE]...
View 4 Replies
Oct 14, 2009
See
Public Class Form1
Dim sql As String
Dim conn As New OleDb.OleDbConnection
Dim da As New OleDb.OleDbDataAdapter
[CODE]...
The problem, The INSERT statement works fine in the form load but not in the button click event?
View 29 Replies
Jan 1, 2010
I was convinced that If <expression> Then <statement [:statement]> Else [statements] in concrete form of If a = b Then SayHello() Else SayBye() End has sense. I read article on msdn on If-then-else, but I forgot why I was reading, so I concluded, that snippet above means this
If a = b Then HelloIsSaid : IsNotEnded Else ByeIsSaid : IsEnded But I have tested it now, and I see, that Else without statement is nothing more than decoration. It would be pretty good if it had function I described. Do you think its good request? Or do you know any circumstance where this Else has some function?
View 13 Replies
Jun 8, 2009
y friend and I are re-learning Visual Basic, and we are stumped on this bit of code.
For intAsterisks As Integer = 0 To intLine - 1
lblAsterisks.Text = lblAsterisks.Text + "*"
Next
View 6 Replies
Jun 24, 2011
I have the following SQL:
[Code]...
I want to put it (the select count statement) in this LINQ statement so I can get the sales count in my linq statement: Dim TheLeads = (From L In DB.Leads Where L.IsDeleted = False Select L).ToList() Is this possible to do in LINQ?
View 1 Replies
Feb 23, 2009
add an if statement and an exit statement to my do loop that exits when my future value (FV) is greater than 1000, then to change the exit statement to a continue statement so my loop will continue even though my fv is greater then 1000, point is to get this to run even though my if statement doesnt do anything. problem something wrong in my code and an exception error (xception of type 'System.OverflowException' occurred in mscorlib.dll)
so can someone show me where or why I have an error is, what am I overthinking now! I could use a hint, OMG i could use a tutor for that matter
[Code]...
View 3 Replies
Jun 23, 2010
A co-worker wants to convert the following IfThenElseIf statement into a Select Case statement.
Explain why this is not possible.
If temperature = 100 Then
X = 0
ElseIf population > 1000 Then
X = 1
ElseIf rate < .1 Then
X = -1
End If
View 7 Replies
Aug 4, 2010
I cant get this SQL statement to insert any of the values in the form to add to the database
sql
sql = "INSERT INTO prevresults (ExamDate, ExamTime, CorrectAnswers, PassPercentage) VALUES (date.now, time.now, rightanswers, percentage.text)"
[code]....
View 4 Replies
May 24, 2012
Return statement which is true in an if statement
View 3 Replies
Oct 5, 2009
how to use them then before, but am still a little confused with a few aspects. Here goes:
1.) Lets say you have a method that checks for a certain condition(s) and if it fails Throws an exception. Does it have to be in a try/catch block? Meaning can the "Throw" statement exist in a block with no try/catch statement?
2.) Now lets say we have a method that has a try catch block and in it there is a throw statement. When the throw statement is executed does it first try to find an appropriate catch block in the same method or does it immediately go back to the calling method without looking at the catch statements in the current method where the exception was thrown?
3.) I created a custom exception class that inherits from ApplicationException. Next I created a method which has a catch block that catches this type of exception and does some action. Is the System(i.e CLR) smart enough to throw an exception of this type, or does it only throw exceptions from SystemException?
4.) I know that some people are more liberal in their use of exceptions and others use it more sparingly when truly strange stuff happen like the DB going down. I am writing code where I am getting some info back from the database, converting it and then storing it. Sometimes there might be data that comes back from the database and other times the field is empty and the Null value comes back. Therefore in the instances where Null comes back from the database I should not convert the value to anything, since I will get an error. What should I do in this situation? Should I let the CLR throw the exception when it goes to convert the Null value or should I check for the Null value and if it exists not convert?
5.) In general when I throw exceptions, is it sensible to only throw exceptions of the type Application Exception or are there instances where the programmer throws exceptions of the type SystemException?
View 2 Replies
Jul 11, 2010
I'm building a listview search feature in my app. (See the code below). It works really well, except if you search "T" then the code removes all items, if you search "t" then it removes every item except for those starting with "t". Is there any way to make a 'like' statement, or use some kind of wildcard to make the statement not case sensitive?
For Each itm As ListViewItem In ListView2.Items
If itm.Text Like TextBox1.Text & "*" Or itm.SubItems.Item(1).Text Like TextBox1.Text & "*" Then
Else
[code].....
View 2 Replies
May 2, 2012
I have a line of code that is working in one statement but not the second statement. I'm not sure what I'm doing wrong, I am learning slowly but surely, and it is by no small margin because of the ave found here =) The error is occuring in the intResult = intSelection x intCount line of the SECOND Do While Loop.
The blue squiggle line is under "intCount" just FYI
Dim intSelection As Integer
Dim intCount As Integer = 0
[code]....
View 1 Replies
Jan 29, 2009
I have the following vb code which works as expected when it's in a code-behind page. I tried to move it to a shared or component page since I will need to use it in multiple pages:
Imports Microsoft.VisualBasic
Public
Class DetTime
'Determine eastern time
[CODE]...
However the "if" statement shows an error " statement cannot appear outside of a method body" and the Microsoft solution is to "move statement into a procedure or subroutine"
View 1 Replies
Dec 8, 2011
I have some code to execute code at runtime...
Here is the main
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
If TextBox1.Text.Trim <> "" Then
If TextBox2.Text.Trim <> "" Then
[code]....
When the button is pressed, it all works and the following files are created: yahoo.dll and yahoo.pdb My question is this: What is the code to load the already compiled yahoo files to execute the code again, without having to recompile the code?
View 1 Replies
