C# ASP.NET Sql Command Select Statement Source Code Example


Premium (Not Free) Video Tutorials

Free Video Tutorials & Free Tools

C# ASP.NET Sql Command Select Statement Source Code Example

Purpose: – Illustrates using in C-Sharp ASP.NET.

Prerequistes:

  1. Install C# (Express or Standard Edition)
  2. Install SQL Server Express
  3. Download Northwind and Pubs Database
  4. Attach Northwind Database to Databases in Sql Express
  5. Attach pubs Database to Databases in Sql Express

Notes:

  • You can build your own library of syntax examples by using same web site over and over and just add new web forms to it.

Instructions:

  1. Use Visual Web Developer 2008
  2. Create new web site;
    • Click File/New Web Site
    • Select ASP.NET Website Template
    • Select C-Sharp for Language
    • name of Web Site could be CSharp_ASPNET_Syntax.
  3. Add New folder named "Database_ADONET"
    • Right-click project name in solution explorer;
    • add new folder;
    • name of folder could be: Database_ADONET
  4. Add Web Form Named SqlCommandSelect to Database_ADONET folder
    • Right-click Database_ADONET folder;
    • add new item;
    • Select Web Form
    • Check place code behind in separate file
    • Web Form name could be SqlCommandSelect
  5. Click on copy code in code below to copy code into web form SqlCommandSelect.aspx
  6. Click on copy code in second set of code below to copy code into code-behind SqlCommandSelect.aspx.cs
  7. Right-click on SqlCommandSelect.aspx in solution explorer and select view in browser

Step 1: Click on Copy Code to Cut-n-paste code into SqlCommandSelect.aspx

 XML |  copy code |? 
< %@ Page Language="C#" AutoEventWireup="true" CodeFile="SqlCommandSelect.aspx.cs" Inherits="Database_ADONET_SqlCommandSelect" %>
 
< !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html>
<head>
<title>Sql Command Select C-Sharp ASP.NET</title>
</head>
<body>
    <form id="Form1" runat="server">
        <p>
            Find: 
            <asp :TextBox id="TextBox1" runat="server" Text="*"></asp>
             <asp :Button id="Button1" onclick="Button1_Click" runat="server" Text="Go"></asp>
        </p>
        <p>
            <asp :DataGrid id="DataGrid1" runat="server" BorderWidth="5px" BorderColor="Black" CellPadding="5">
                <headerstyle font-size="X-Small" font-names="Arial Narrow" font-bold="True" forecolor="White" backcolor="Black"></headerstyle>
                <alternatingitemstyle backcolor="Silver"></alternatingitemstyle>
                <itemstyle font-size="X-Small" font-names="Arial Narrow"></itemstyle>
            </asp>
        </p>
    </form>
</body>
</html>
 


Step 2: Click on Copy Code to Cut-n-paste code into SqlCommandSelect.aspx.cs
 C# |  copy code |? 
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
 
partial class Database_ADONET_SqlCommandSelect : System.Web.UI.Page
{
 
    System.Data.DataSet FindByTitle(string search)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Pubs_ConnectionString"].ConnectionString);
        string queryString = "";
 
        if (search == "*")
        {
            queryString = "SELECT [titles].[title], [titles].[price], [titles].[notes], [titles].[pubdate] FROM [titles]";
        }
        else
        {
            queryString = "SELECT [titles].[title], [titles].[price], [titles].[notes], [titles].[pubdate] FROM [titles] WHERE ([titles].[title] like @search + '%')";
        }
 
 
 
        System.Data.SqlClient.SqlCommand sqlCmd = new System.Data.SqlClient.SqlCommand(queryString, con);
        if (search != "*")
        {
            sqlCmd.Parameters.Add("@search", System.Data.SqlDbType.NVarChar).Value = search;
        }
 
 
        System.Data.SqlClient.SqlDataAdapter dataAdapter = new System.Data.SqlClient.SqlDataAdapter(sqlCmd);
        System.Data.DataSet dataSet = new System.Data.DataSet();
        dataAdapter.Fill(dataSet);
 
        return dataSet;
    }
 
    public void Button1_Click(object sender, EventArgs e)
    {
        string sTitle = TextBox1.Text;
        DataGrid1.DataSource = FindByTitle(sTitle);
        DataGrid1.DataBind();
    }
 
}
 


Step 3: Click on Copy Code to Cut-n-paste code into web.config right after the appSettings section
 XML |  copy code |? 
<connectionstrings>
    <add name="Nortwind_ConnectionString"
      connectionString="Server=(local)\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI" />
    <add name="Pubs_ConnectionString"
      connectionString="Server=(local)\SQLEXPRESS;Initial Catalog=pubs;Integrated Security=SSPI" />
  </connectionstrings>
 

Related posts:

  1. VB.NET ASP.NET Sql Command Select Statement Source Code Example VB.NET ASP.NET Sql Command Select Statement Source Code Example that...
  2. C# Select Statement Source Code Example Source Code example shows how to use Sql Select in...
  3. C# Sql Command Delete Statement Source Code Example C# Source Code Example that illustrates using Sql Command Delete...
  4. VB.NET Sql Command Delete Statement Source Code Example Example illustrates using VB.NET Sql Command Delete Statement and checking...
  5. VB.NET Sql Command Update Statement Source Code Example VB.NET Source Code Example shows how to use Sql Command...

Related posts brought to you by Yet Another Related Posts Plugin.

Comments

5 Responses to “C# ASP.NET Sql Command Select Statement Source Code Example”
  1. Sheen says:

    Hi,

    I have read and applied your search snippet, this works fine however I have a select option on my Gridview control. I need to also select the record from the search word. Unfortunately my program could not select the searched record.

    I will be glad to send you my complete snippet through your email. Could you please help me on this.

    Thanks.

  2. maha says:

    Ok , i now working with linking between c#.net and Google map , i want to make alst if places when i click on it ( name of a place)( this click ill take me to place in the Google map

  3. sony says:

    hi, i want to know how to select data from particular row from the datalist, and how to insert data in the treeview and how to select and click particular item from the treeview. please reply fast..

  4. Thanks for sharing this information. I also recommend the use of LINQ-to-SQL it is a little easier and safer than using SQL.

  5. We had not been conscious of several the information which you talked about and so i would like to simply offer you thanks

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

Powered by WP Hashcash

This blog uses the cross-linker plugin developed by Web-Developers.Net