Happy Codings - Programming Code Examples

Asp.Net Programming

Asp.Net > Code Snippets Code Examples

Executing Transact-SQL SELECT statement using SQLCommand



Executing Transact-SQL SELECT statement using SQLCommand

<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>

<script language="VB" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)

Dim objConn As New SQLConnection("server=LOCALHOST;User id=SA;password=;database=Northwind")
Dim objCommand As New SqlCommand("Select categoryName from Categories", objConn)
objCommand.Connection.Open()

Dim objReader As SqlDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection)
While objReader.Read()
response.Write(objReader.GetString(1) & "<br/>")
End While
objReader.Close()
objConn.Close()
end sub
</script>

C Language Implement Specify Command
Put on the motor. Address of digital control port. Check whether FDC is ready. Beginning of command phase. Input the command parameters. Enter command parameters...

Program to find largest array element in C
Finding largest value in an Array is a classic C array program. Code gives you an insight of iteration, array & conditional operators. We iteratively check each element of an array if

C Program Compare two Text or Data files
Firstly Declare two file pointers for two files. Open 2 files in read mode. Now Inside while loop read both files character by character. Check both characters whether they're equal

Find the Number of Permutations of given
Prints a total number of permutation possible for a given string. The time complexity of this algorithm is "O(n)". Algorithm takes the input of the string. Then it checks for the repetition

Using Insertion Sort Technique in The C++
To sort an array using insertion sort, enter the array size and then array elements in random order. Start Sorting the Elements of the array in Ascending Order using insertion sort as like

Remove All Occurrences of Character from
Program to remove all occurrences of a given character from the string using Loop. Enter a character to Remove from string. Function to "Remove all occurrences" of a character from

Calculate Addition or Subtraction & Trace
Calculate the addition or subtraction & trace of 2 matrices. Here trace of the matrix is the sum of the elements on the main diagonal i.e the diagonal from the upper left to the lower

C Program to Display Factors of a Number
This C Program takes a Positive Integer from the user & displays all the positive factors of that number. The for loop is iterated until j<= Number is False. In each iteration, number is