Search This Blog

.NET GENES

Posts

Showing posts with the label T-SQL

Show all

Donate

No results found

Donate

Powered by Blogger

.NET GENES: Greg Esguerra is a .NET Applications Developer and IT Instructor from Cebu City, Philippines with experience working on projects related to web, desktop, database and business intelligence using Microsoft Technology Stack.

Visit profile

Donate

FAVORITES

GitHub Repository
LinkedIn Profile
InfoVerze
Personal Blog

PAGES

About Me
Disclaimer
Contact Us

LABELS

.NET 57
.NET 82
.NET Core13
.NET Framework1
.NET MAUI1
.NET Source Code Analysis1
AccessDatabaseEngine2
Acer1
Acer Aspire 71
Acer Aspire V5-431P/471P1

Active Directory1
ADO.NET9
Adobe Illustrator 20211
Adobe Photoshop 20211
Ajax23
Ajax Control Toolkit11
AngularJS6
AnimationExtender1
ASP Classic2
ASP.NET12
ASP.NET Core1
ASP.NET Core MVC 3.13
ASP.NET Core MVC 5.06
ASP.NET Core MVC2
ASP.NET Membership5
ASP.NET MVC112
ASP.NET MVC Image3
ASP.NET Server Validation Control1
ASP.NET Web API1
ASP.NET Web Forms83
Asynchronous Programming1
AuthorizeAttribute2
AutoComplete2
AutocompleteExtender2
Automapper1
Axios HTTP Client1
BinaryFormatter2
BindingList1
BindingNavigator1
BindingSource3
Blazor1
BlockUI1
Blog Customization3
Bootstrap17
Bootstrap 43
Bootstrap DatePicker2
Bootstrap Modal3
Bootstrap Table17
Bootstrap Table Wenzhixin24
Bootstrap Typeahead.js1
Bootstrap-Table-Export.js2
C#231
Castle Windsor3
Chart.js1
ClosedXML1
Code First1
COM Interop2
Config Files1
Configuration3
CookieContainer2
Create React App1
Crystal Reports3
CSS9
Custom Controls16
Dapper ORM7
Data Annotations6
DataGridView15
DataGridViewComboBoxColumn2
DataTable12
DateDiff1
DateTime1
DateTimePicker1
DAX8
DAX Studio1
Dead Pixel Checker1
Delegates1
Dictionary4
DinkToPDF1
Docker3
DynamicPopulateExtender1
Entity Framework34
Entity Framework Core5
Excel8
Font Awesome 51
FormView3
FTP2
GeckoFX5
Generic Constraints1
Generics3
Git3
Github8
Google Chrome1
Google Photos API3
GridView28
GUID2
GZip1
Hashtable1
Hierarchy Slicer2
HTML2
HTML 55
HTML Agility Pack2
Html Helpers9
HTMLEditorExtender1
HttpHandler1
HttpPostedFileBase1
IEnumerable<T>1
IEqualityComparer<T>1
IIS1
Internet Explorer5
iTextSharp1
JavaScript45
JavaScript Prototype1
JavaScriptSerializer2
jqGrid2
jQuery50
jQuery Promise1
jQuery UI7
jQuery UI Dialog2
jQuery Unobtrusive Validation1
jQuery Validation1
jqueryUI DatePicker2
jsfiddle.net1
JSON8
Json.NET1
JsonSerializer2
jsTree.js5
Knockout3
LG Monitor2
LG OnScreen Control1
LINQ32
Linux1
List<T>6
MahApps.Metro.IconPacks1
Microsoft Office1
Microsoft Teams1
Microsoft.mshtml1
Microsoft.VisualBasic1
Microsoft.VisualBasic.PowerPacks1
Moment.js3
MongoDB3
Moq Framework1
Mozilla Firefox2
MS Access1
MS Outlook2
MVCContribGrid2
MVVM13
MySQL23
NameValueCollection2
NBuilder1
Newtonsoft.Json3
Node.js2
Notepad++1
Notepad++ Plugin1
NotepadPlusPlusPluginPack.Net1
NPM1
NuGet Package2
NumericUpDownExtender1
Observable Collection5
OleDB2
On Premises Data Gateway2
OpenWebKitSharp3
OpenXML2
Oracle4
OS20
PagedList Pager2
PdfSharpCore2
PopupControlExtender1
Power BI16
Power BI Desktop8
Power BI Service2
Predicate2
Process.Start1
Productivity Power Tools1
Quasar Framework3
Queue1
React.js1
Regular Expression18
Remote Validation2
Repeater Control1
RepoDB ORM4
REST3
RichTextBox1
Samsung Galaxy Note 10 Lite2
Script Template1
Sharkoon SKILLER Gaming Chair1
Shell Command1
Sitecore1
SixLabors ImageSharp2
SmtpClient1
Spring.NET1
SQL Developer1
SQL Parameter1
Sql Server64
SQL Server Compact 4.01
SqlBulkCopy2
SQLDataReader1
SSH.NET1
StringBuilder1
Structures1
T-SQL35
Tailwind CSS 3.02
TDD1
Test Driven Development1
Threading2
TimeSpan2
TP-Link TL-WA855RE Extender1
TreeView1
Typeahead.js1
TypeScript2
Unit Of Work2
Unity Container3
Utility Software2
Validation2
VB.NET52
VBA1
VBForums1
VBScript1
Visual Studio34
Visual Studio 20171
VIsual Studio 20198
Visual Studio 20225
Visual Studio Code3
VS Code2
vue-chartjs1
Vue.js4
Vue.js 33
WCF1
WebBrowser13
WebClient6
WebGrid2
WebRequest11
Webservice6
WebView22
Windows 104
Windows 113
Windows API2
Windows Domain1
Windows Forms43
Windows Server1
Windows Snap Layout1
WPF59
WPF ConverterParameter1
WPF DataGrid29
WPF Resource Dictionary3
WPF UserControl1
WPF Value Converter6
Xamarin5
Xamarin Forms5
XAML13
XDocument2
XML20
XmlSerialzer2
XPath3
XPathDocument1

Show more Show less

FOLLOWERS

Add Checkbox In WPF Datagrid DatagridTemplateColumnHeader (For Checkall)

- September 23, 2012

Hello, Here's how to add checkbox in WPF Datagrid DatagridTemplateColumn to simulate checkall. I have included the TSQL script, XAML and C# codes. Perform these steps below 1. Create an MSSQL database with the following Product Table schema below: Table: Products Fields: - ProductID (int, autoincrement) - ProductName (varchar) - UnitPrice (decimal) - QuantityPerUnit (varchar) - Discontinue (bit) SQL Script: USE [Your_Database_Name] GO /****** Object: Table [dbo].[Products] Script Date: 05/27/2013 14:07:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Products]( [ProductID] [int] NOT NULL , [ProductName] [varchar](50) NULL , [UnitPrice] [decimal](18, 2) NULL , [QuantityPerUnit] [varchar](50) NULL , [Discontinue] [bit] NULL , CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED ( [productID] ASC ) WITH

WPF CRUD Application Using DataGrid, MVVM Pattern, Entity Framework, And C#.NET

- February 04, 2021

Good day to all! Here's an example of a WPF CRUD (Create,Update and Delete) project using the DataGrid control, ADO.NET Entity Framework 6.x, C#.NET and Model–View–Viewmodel(MVVM) architectural pattern. This post was based from this tutorial WPF CRUD With DataGrid, Entity Framework And C#.NET except that we are now using the MVVM framework. The steps below are pretty straightforward and easy to follow. I. Project Setup 1. Add a table called Students in you database. The complete script is found in this post WPF CRUD With DataGrid, Entity Framework And C#.NET 2. Create a WPF Project and add four folders called DataAccess, Model, View and ViewModel. 3. Your project structure may look similar with the screenshot provided below. II. Coding The Model and Repository Class 1. Inside the Model folder, add an ADO.NET Entity Data Model that connects to the Students table in your database. On my part, I named it StudentModel . 2. For the connectionstring name in App.config file, I

Change BIOS Boot Options For Acer Aspire V5-431P/471P

- September 18, 2013

Hello and Good afternoon! Here's a useful Acer Aspire V5-431P/471P Tip that is to Change BIOS Boot Options for Acer Aspire V5-431P/471P (I Series) 1. Restart/Shutdown the Laptop 2. Tap F2 key on startup 3. When BIOS interface appears, go to Boot Menu 4. Change Boot Mode to Legacy BIOS. 5. Restart Again the laptop and perform step 2. 6. Set the Boot Priority of Devices using F5/F6.

Add Placeholder (Watermark) To Html.TextBoxFor() Helper In ASP.NET MVC 4

- March 12, 2014

After working with simple form html elements, I decided to give it a try applying the placeholder jquery framework to ASP.NET MVC4 application. The steps are similar in this post: Placeholder attribute in HTML5 form Elements except that the target controls are HTML Helpers. Basically, TextBoxFor() helper when rendered to the browser is an input text element. So, let's give it a spin. On your _Layout.cshtml, reference the jquery and placeholder scripts. <script type= "text/javascript" src= "~/Scripts/jquery-1.7.1.min.js" ></script> <script type= "text/javascript" src= "~/Scripts/placeholders.jquery.min.js" ></script> and in your MVC Form, apply it to TextBoxFor() as shown below: @model TextBoxFor.Models.Movie @{ ViewBag.Title = "CreateMovie"; } <h2>Create</h2> @using (Html.BeginForm()) { @Html.ValidationSummary(true) <fieldset> <legend>Movi

How To Insert Or Add Emojis In Microsoft Teams Status Message

- July 09, 2021

Good day Gents! I was trying to update my Microsoft Teams status and was wondering if I can add or insert emoji. For editing or adding new teams status, only text fields are available and there's no emoji icon similar to writing a teams message. After googling for a few minutes, I found this link Emoji's in status which is a feature request in Microsoft Teams User's Voice Forum. So far this upgrade request only has thirty votes which is relatively small and may be considered a low priority for the product team to implement. Given the limitations at hand, I tried several approach including copying an emoji in a chat message which didn't work and later found a solution using Microsoft Outlook 365. First is to create a new email message in Microsoft Outlook and press (Window Key + .). The emoji dropdown control will appear. Next is to select the emoji that you wanted to add to Teams. Copy the emoji from the newly created email message template and paste that to Micr

Contact Form

Name

Email *

Message *