In Visual Basic .NET or Visual C# programming, when would you use Structured Query Language (SQL)? How are they executed?

In Visual Basic .NET or Visual C# programming, when would you use Structured Query Language (SQL)? How are they executed? 
by

1 Answer

Answer :

ADO.NET handles most of the database communication for you behind-thescenes. You would only use SQL statements when generating ad-hoc queries for the database. You execute SQL statements by using a DataCommand object. Statements the return records, such as SELECT statements, are executed using the ExecuteQuery method. You can also return a single value with a SELECT statement by using the ExecuteScalar method. To execute non-value returning statements, such as DELETE, INSERT INTO, or UPDATE statements, use the ExecuteNonQuery method.
by

Related questions

But won't most .NET developers eventually choose C# over Visual Basic.NET?

Description : But won't most .NET developers eventually choose C# over Visual Basic.NET? 

Last Answer : No. Because the power of the two languages is so similar, the primary factor for developers migrating to the .NET world will probably be the syntax they prefer. Since many more developers ... the dominant language for building Windows applications five years from now will still be Visual Basic. 

SQL stands for  Structured Query Language  Statistical Query Language  Superior Questions Lot  Superior Questions Lo

Description : SQL stands for   Structured Query Language   Statistical Query Language   Superior Questions Lot   Superior Questions Lo

Last Answer :  Structured Query Language

………………… is a full form of SQL. A) Standard query language B) Sequential query language C) Structured query language D) Server side query language

Description : ………………… is a full form of SQL. A) Standard query language B) Sequential query language C) Structured query language D) Server side query language

Last Answer : A) Standard query language

Isn't C# the native language of .NET?

Description : Isn't C# the native language of .NET?

Last Answer : Every language built on the .NET Framework must use the CLR. The CLR defines core language semantics, and so all of the languages built on it tend to have a great deal in common. The biggest choice a . ... just a little bit more-and so neither is the "native" .NET language. There is no such thing.

Will we eventually see a .NET Framework-based version of Java as a competitor to C#?

Description : Will we eventually see a .NET Framework-based version of Java as a competitor to C#?

Last Answer : Apparently not. Microsoft will never offer a complete Java environment because Sun has essentially required that Java licensees implement all of Java-something Microsoft will never do. (Why should it? Does ... she's working in a true Java environment because the familiar libraries won't be there. 

Define what is a basic difference between the while loop and do-while loop in C#?

Description : Define what is a basic difference between the while loop and do-while loop in C#?

Last Answer : The while loop tests its condition at the beginning, which means that the enclosed set of statements run for zero or more number of times if the condition evaluates to true. The do while loop iterates a set of statements at least once and then checks the condition at the end.

Programming With Visual Basic.NET?

Description : Programming With Visual Basic.NET?

Last Answer : Visual Basic .NET is the latest incarnation of Visual Basic. Itis sometimes known as VB7, a misnomer on account of itsincompatibility with VB6: new features and syntax within VB7 meanthat a re-write, ... a good formdesigner.3. Start up a Visual Basic .NET IDE and make a Windowsapplication.4. D

Assume a systems development project effort calculation determines that the system will require 240 function points. If the developers choose to implement this system in the C programming language, approximately 31,200 lines of code will have to be written. If the developers choose Visual Basic to implement the system, the number of lines of code will be _____. a. about the same b. can't tell without more information c. exactly the same d. much greater e. much less

Description : Assume a systems development project effort calculation determines that the system  will require 240 function points. If the developers choose to implement this system in the  C programming language, approximately ... without more information  c. exactly the same  d. much greater  e. much less

Last Answer : e. much less

What second programming language did Google add for App Engine development? A. C++ B. Flash C. JavaD. Visual Basic

Description : What second programming language did Google add for App Engine development? A. C++ B. Flash C. JavaD. Visual Basic

Last Answer : Java

What second programming language did Google add for App Engine development? A. C++ B. Flash C. Java D. Visual Basic

Description : What second programming language did Google add for App Engine development? A. C++ B. Flash C. Java D. Visual Basic

Last Answer : Java

Define what is the main use of delegates in C#?

Description : Define what is the main use of delegates in C#?

Last Answer : Delegates are mainly used to define call back methods.

Can we use “this” inside a static method in C#?

Description : Can we use “this” inside a static method in C#?

Last Answer : No. We can’t use “this” in a static method.

Why use “finally” block in C#?

Description : Why use “finally” block in C#?

Last Answer : Finally block will be executed irrespective of exception. So while executing the code in try block when an exception occurs, control is returned to catch block and at last finally block will be ... the closing connection to database / releasing the file handlers can be kept in finally block.

Why use the keyword “const” in C#? Give an example.

Description : Why use the keyword “const” in C#? Give an example.

Last Answer : “Const” keyword is used for making an entity constant. We can’t reassign the value to constant. Eg: const string _name = “Test”;

Why use “using” in C#?

Description : Why use “using” in C#?

Last Answer : “Using” statement calls – “dispose of” method internally, whenever any exception occurred in any method call and in “Using” statement objects are read-only and cannot be reassignable or modifiable.

Can you change the value of a variable while debugging a C# application?

Description : Can you change the value of a variable while debugging a C# application? 

Last Answer : Yes. If you are debugging via Visual Studio.NET, just go to Immediate window. 

How do you generate documentation from the C# file commented properly with a command-line compiler?

Description : How do you generate documentation from the C# file commented properly with a command-line compiler? 

Last Answer : Compile it with the /doc switch. 

What is the syntax to inherit from a class in C#?

Description : What is the syntax to inherit from a class in C#? 

Last Answer : Place a colon and then the name of the base class. Example: class MyNewClass : MyBaseClass

What’s the C# syntax to catch any possible exception?

Description : What’s the C# syntax to catch any possible exception?

Last Answer : A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.

Does C# support multiple-inheritance?

Description : Does C# support multiple-inheritance?

Last Answer : No. 

List the differences in C# 2.0.

Description : List the differences in C# 2.0. 

Last Answer : • Generics • Iterators • Partial class definitions • Nullable Types • Anonymous methods • :: operator • Static classes static class members • Extern keyword • Accessor accessibility • Covariance and Contravariance • Fixed size buffers • Fixed assemblies • #pragma warning

What mechanisms does C# have for the readers, writers problem?

Description : What mechanisms does C# have for the readers, writers problem?

Last Answer : System.Threading.ReaderWriterLock which has methods AcquireReaderLock, ReleaseReaderLock, AcquireWriterLock, and ReleaseWriterLock 

Does C#Does C# have “friendship”? have “friendship”? Does C# have “friendship”?

Description : Does C# have “friendship”? 

Last Answer : Not before C# 2.0 

Does C# supports multiple inheritance?

Description : Does C# supports multiple inheritance? 

Last Answer : No

Can C# have multiple catch blocks?

Description : Can C# have multiple catch blocks?

Last Answer : Yes

Can C# have global overflow checking?

Description : Can C# have global overflow checking? 

Last Answer : Yes

Name 10 C# keywords.

Description : Name 10 C# keywords. 

Last Answer : abstract, event, new, struct, explicit, null, base, extern, object, this 

Can you change the value of a variable while debugging a C# application?

Description : Can you change the value of a variable while debugging a C# application? 

Last Answer : Yes. If you are debugging via Visual Studio.NET, just go to Immediate window. 

How do you generate documentation from the C# file commented properly with a command-line compiler?

Description : How do you generate documentation from the C# file commented properly with a command-line compiler?

Last Answer : Compile it with the /doc switch.

What is the syntax to inherit from a class in C#?

Description : What is the syntax to inherit from a class in C#? 

Last Answer : Place a colon and then the name of the base class. Example: class MyNewClass : MyBaseClass

What’s the C# syntax to catch any possible exception?

Description : What’s the C# syntax to catch any possible exception?

Last Answer : A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.

Does C# support multiple-inheritance?

Description : Does C# support multiple-inheritance?

Last Answer : No.

Isn't C# just a copy of Java?

Description : Isn't C# just a copy of Java? 

Last Answer : In some ways, yes. The semantics of the CLR are quite Java-esque, and so any CLR-based language will have a good deal in common with Java. Creating a language that expresses those semantics in a syntax ... had been free to make some changes to Java, my guess is that C# wouldn't exist today. 

Which is better: C# or Java?

Description : Which is better: C# or Java?

Last Answer : The two languages have an awful lot in common, and so in some ways it's natural to try to choose a winner. The fact that each language is often viewed as the flagship of its camp-C# in Microsoft's . ... like the radio. You can do it, but you'll be happier if you choose based on the whole package.

C# provides a default constructor for me. I write a constructor that takes a string as a parameter, but want to keep the no parameter one. How many constructors should I write?

Description : C# provides a default constructor for me. I write a constructor that takes a string as a parameter, but want to keep the no parameter one. How many constructors should I write? 

Last Answer : Two. Once you write at least one constructor, C# cancels the freebie constructor, and now you have to write one yourself, even if there’s no implementation in it.

Does C# support multiple inheritance?

Description : Does C# support multiple inheritance? 

Last Answer : No, use interfaces instead.

How do you inherit from a class in C#?

Description : How do you inherit from a class in C#?

Last Answer : Place a colon and then the name of the base class. 

Define what are the advantages of getting and set properties in C#?

Description : Define what are the advantages of getting and set properties in C#?

Last Answer : 1. The get property accessor is used to return the property value. 2. The set property accessor is used to assign a new value.

Define what are sealed classes in c#?

Description : Define what are sealed classes in c#?

Last Answer : The sealed modifier is used to prevent derivation from a class. A compile-time error occurs if a sealed class is specified as the base class of another class.

Define what is the syntax to inherit from a class in C#?

Description : Define what is the syntax to inherit from a class in C#?

Last Answer : When a class is derived from another class, then the members of the base class become the members of the derived class. The access modifier used while accessing members of the base class specifies ... syntax to inherit a class from another class In C# is as follows: class MyNewClass : MyBaseClass

Define what Command is used to implement properties in C#?

Description : Define what Command is used to implement properties in C#?

Last Answer : get & set access modifiers are used to implement properties in c#.

Can we declare a block as static in c#?

Description : Can we declare a block as static in c#?

Last Answer : No, because c# does not support static block, but it supports static method.

Does C# support a variable number of arguments?

Description : Does C# support a variable number of arguments?

Last Answer : Yes, using the params keyword. The arguments are specified as a list of arguments of a specific type, e.g., int. For ultimate flexibility, the type can object. The standard example of a method which uses this approach is System.console.writeLine().

Does C# provide copy constructor?

Description : Does C# provide copy constructor?

Last Answer : No, C# does not provide copy constructor.

Is String is Value Type or Reference Type in C#?

Description : Is String is Value Type or Reference Type in C#?

Last Answer : A string is an object(Reference Type).

How does C# differ from C++?

Description : How does C# differ from C++?

Last Answer : C# does not support the #include statement. It uses only using statement. In C#, the class definition does not use a semicolon at the end. C# does not support multiple code inheritance. Casting in ... used on string values. Command line parameters array behave differently in C# as compared to C++.

Define what are the different types of literals in C#?

Description : Define what are the different types of literals in C#?

Last Answer : Boolean literals: True and False are literals of the Boolean type that map to the true and false state, respectively. Integer literals: Used to write values of types Int, uint, long, and ulong. Real ... by a double-quote character, such as © hello . The Null literal: Represents the null-type.

Does C# have a throws clause?

Description : Does C# have a throws clause?

Last Answer : No, unlike Java, C# does not require (or even allow) the developer to specify the exceptions that a method can throw.

Is C# object-oriented?

Description : Is C# object-oriented?

Last Answer : Yes, C# is an OO language in the tradition of Java and C++.

Is using of exceptions in C# recommended?

Description : Is using of exceptions in C# recommended?

Last Answer : Yes, exceptions are the recommended error handling mechanism in .NET Framework.