CFF Coding Source - Bootstrap Tags Input (C# and SQL Server Database)

HTML

JavaScript

var citynames = new Bloodhound({
    datumTokenizer: Bloodhound.tokenizers.obj.whitespace('name'),
    queryTokenizer: Bloodhound.tokenizers.whitespace,
    prefetch: {
        url: 'Tags.ashx',
        filter: function (list) {
            return $.map(list, function (cityname) {
                return { name: cityname };
            });
        }
    }
});
citynames.initialize();
/**
 * Typeahead
 */
var elt = $('.example_typeahead > > input');
elt.tagsinput({
    typeaheadjs: {
        name: 'citynames',
        displayKey: 'name',
        valueKey: 'name',
        source: citynames.ttAdapter()
    }
});
// HACK: overrule hardcoded display inline-block of typeahead.js
$(".twitter-typeahead").css('display', 'inline');

SQL

-- Create a new database called [Virtual-Class-01] in SQL Server.
-- Right-click and choose [New Query]
-- Copy and paste the code below and hit [Execute]

USE [Virtual-Class-01]
GO
/****** Object:  Table [dbo].[Tags]    Script Date: 8/15/2022 7:46:55 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tags](
    [TagID] [int] IDENTITY(1,1) NOT NULL,
    [TagName] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Tags] PRIMARY KEY CLUSTERED 
(
    [TagID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Tags] ON 
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (1, N'Dallas')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (2, N'Charlotte')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (3, N'Raleigh')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (4, N'Houston')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (5, N'Washington')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (6, N'New York')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (7, N'Los Angeles')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (8, N'Sydney')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (9, N'Melbourne')
GO
SET IDENTITY_INSERT [dbo].[Tags] OFF
GO

ASP.NET

<?xml version="1.0"?>
<configuration>
  <connectionStrings configSource="database.config" />
  <system.web>
    <compilation debug="true" strict="false" explicit="true" targetFramework="4.7.2" />
    <httpRuntime targetFramework="4.7.2" requestValidationMode="2.0" />
  </system.web>
</configuration>

<?xml version="1.0"?>
<connectionStrings>
  <add name ="Virtual-Learning" connectionString="Data Source=sqlcorecs-01\sql2019;Database=Virtual-Class-01;User ID=testuser;Password=testuser;MultipleActiveResultSets=True"/>
</connectionStrings>

using System.Data;
using System.Configuration;
using System.Data.SqlClient;

protected void Page_Load(object sender, EventArgs e)
    {
        string LessonConString = ConfigurationManager.ConnectionStrings["Virtual-Learning"].ConnectionString;
        using (SqlConnection LessonCon = new SqlConnection(LessonConString))
        {
            using (SqlCommand cmd = new SqlCommand("select TagID, TagName from Tags", LessonCon))
            {
                LessonCon.Open();
                SqlDataReader rsTag = cmd.ExecuteReader();
                Context.Response.Write("<ol>");
                if (rsTag.Read()) { 
                while (rsTag.Read())
                {
                    String strTag = (string)rsTag["TagName"];
                Context.Response.Write("<li>" + strTag + "</li>");
                }
                }
                Context.Response.Write("</ol>");
                LessonCon.Close();
            }
        }
    }

using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections.Generic;

public void ProcessRequest(HttpContext context)
    {
        //List<string> names = new List<string>();
        List<string> names = new List<string>();
        string LessonConString = ConfigurationManager.ConnectionStrings["Virtual-Learning"].ConnectionString;
        using (SqlConnection LessonCon = new SqlConnection(LessonConString))
        {
            using (SqlCommand cmd = new SqlCommand("select TagID, TagName from Tags", LessonCon))
            {
                LessonCon.Open();
                SqlDataReader sdr = cmd.ExecuteReader();
                while (sdr.Read())
                {
                    names.Add(sdr["TagName"].ToString());
                }
                LessonCon.Close();
            }
        }
        context.Response.ContentType = "text/plain";
        context.Response.Write(string.Format("[\"{0}\"]", string.Join("\",\"", names)));    
    }

Preview

About Company

Top Viewed Articles