[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

VB.NET/C# equivalent for SQL T-SQL syntax

Posted on 2008-06-24
7
Medium Priority
?
475 Views
Last Modified: 2008-06-26
Given the following SQLcommend Text as sample:
"select * from customers where cust_id like '%" + textbox1.text.tostring.trim +"&'"
What's the VB.NET/C# equivalent for it as below:
Dim CustID As String
if CustID ??? textbox1.text.tostring.trim
??? is the code you fill in for the T-SQL "like".
Thanks.
 




0
Comment
Question by:ksfok
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 4

Expert Comment

by:LiorRon
ID: 21857556
What is it you are trying to accomplish ?
0
 

Author Comment

by:ksfok
ID: 21857577
Look for a string that contains a particular string.
0
 
LVL 64

Assisted Solution

by:Fernando Soto
Fernando Soto earned 200 total points
ID: 21857685
Hi ksfok;

Try it like this:

' Modify the connection string to meet your needs
Dim cnn As New SqlConnection("Data Source=(local);Initial Catalog=YourDB;Integrated Security=SSPI")
Dim cmd As SqlCommand = cnn.CreateCommand()
cmd.CommandText = "SELECT * FROM customers WHERE cust_id like '%" & Textbox1.Text.ToString.Trim & "'"
cmd.CommandType = CommandType.Text
' Other code to use it goes here.

Fernando
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 8

Accepted Solution

by:
Chumad earned 800 total points
ID: 21858190
Use IndexOf method of the string...

textbox1.Text.IndexOf(CustID)

IndexOf looks for a string and returns the position of the string. In your case, if it returns 0 or higher, that means the string had a match in it.

There are other methods as well that might be handy... such as SubString, Replace, etc.
0
 
LVL 2

Assisted Solution

by:larker1
larker1 earned 1000 total points
ID: 21858293

C# code:
int foo = 0;
string textToSearch = this.textBox1.Text;
string findThis = this.textBox2.Text.Trim();
foo = textToSearch.IndexOf(findThis);
MessageBox.Show(string.Format("Position: {0}",foo.ToString()));
 
VB Code:
Dim foo As Int32
Dim textToSearch = Me.textBox1.Text.Trim()
Dim findThis = Me.textBox2.Text.Trim()
foo = textToSearch.IndexOf(findThis)
MessageBox.Show(String.Format("Position: {0}", foo.ToString()))

Open in new window

0
 

Author Comment

by:ksfok
ID: 21867725
What about:

textToSearch.contains(findThis)

?
0
 
LVL 2

Assisted Solution

by:larker1
larker1 earned 1000 total points
ID: 21868055
It depends on what version of the .Net Framework you are using.

Dim foo As Boolean
foo = textToSearch.Contains(findThis);

This is not available in .Net 1.1 framework but it is available I think starting with 2.0, and definately 3.5
If you're using .Net 1.1, you'll have to stick with the

if (textToSearch.IndexOf(findThis) > -1)  then
...
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
This article introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question