C# ASP.NET Sql Command Select Statement Source Code Example
Get 5 Hours of FREE PREMIUM Videos:
LearnVisualStudio.NET Free Preview
“ I am a lifetime member of LearnVisualStudio.net and a Premium Plus member of dotNetVideos.net.
LearnVisualStudio.net is awesome because it grows in value each year as more videos are added.
dotNetVideos.net is also great because it focuses a lot on MS Certifications and practical interview questions.
”
- Wade Harvey (IdealProgrammer.com)
LearnVisualStudio Premium Videos
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  |  |
 |
dotNetVideos Premium Video Catalog
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  | |
Premium (Not Free) Video Tutorials
Free Video Tutorials & Free Tools
C# ASP.NET Sql Command Select Statement Source Code Example
Purpose: – Illustrates using Sql Command Select Statement in C-Sharp ASP.NET.
Prerequistes:
- Install C# (Express or Standard Edition)
- Install SQL Server Express
- Download Northwind and Pubs Database
- Attach Northwind Database to Databases in Sql Express
- 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:
- Use Visual Web Developer 2008
- 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.
- Add New folder named "Database_ADONET"
- Right-click project name in solution explorer;
- add new folder;
- name of folder could be: Database_ADONET
- 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
- Click on copy code in code below to copy code into web form SqlCommandSelect.aspx
- Click on copy code in second set of code below to copy code into code-behind SqlCommandSelect.aspx.cs
- 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:
- VB.NET ASP.NET Sql Command Select Statement Source Code Example VB.NET ASP.NET Sql Command Select Statement Source Code Example that...
- C# Select Statement Source Code Example Source Code example shows how to use Sql Select in...
- C# Sql Command Delete Statement Source Code Example C# Source Code Example that illustrates using Sql Command Delete...
- VB.NET Sql Command Delete Statement Source Code Example Example illustrates using VB.NET Sql Command Delete Statement and checking...
- 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.
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.
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