There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
VB.NET/C# equivalent for SQL T-SQL syntax
Given the following SQLcommend Text as sample:
"select * from customers where cust_id like '%" + textbox1.text.tostring.tri
What's the VB.NET/C# equivalent for it as below:
Dim CustID As String
if CustID ??? textbox1.text.tostring.tri
??? is the code you fill in for the T-SQL "like".
Thanks.
"select * from customers where cust_id like '%" + textbox1.text.tostring.tri
What's the VB.NET/C# equivalent for it as below:
Dim CustID As String
if CustID ??? textbox1.text.tostring.tri
??? is the code you fill in for the T-SQL "like".
Thanks.
Who is Participating?
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.Tri
cmd.CommandType = CommandType.Text
' Other code to use it goes here.
Fernando
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.Tri
cmd.CommandType = CommandType.Text
' Other code to use it goes here.
Fernando
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()))
It depends on what version of the .Net Framework you are using.
Dim foo As Boolean
foo = textToSearch.Contains(find
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(find
...
Dim foo As Boolean
foo = textToSearch.Contains(find
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(find
...
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month5 days, left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
textbox1.Text.IndexOf(Cust
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.