Create, show and save XML Sitemap Dynamically - .Net Core

Feb 24, 2019 BY xtreme

WHAT IS XML SITEMAPAn XML (EXTENSIBLE MARKUP LANGUAGE) SITEMAP Is a Text File USED TO DETAIL ALL URLS ON A WEBSITE. IT CAN INCLUDE EXTRA INFORMATION (METADATA) ON EACH URL, WITH DETAILS OF WHEN THEY WERE LAST UPDATED, HOW IMPORTANT THEY ARE AND WHETHER THERE ARE ANY OTHER VERSIONS OF THE URL CREATED...

Group of Radio Buttons - Asp.Net MVC

Feb 21, 2019 BY xtreme

introductionHtmlHelper class includes two extension methods to generate Radio element in a razor view: RadioButton() and RadioButtonFor()RADIOBUTTONThe Html.RadioButton() method creates a radio button element with a specified name, isChecked boolean ...

Find All Columns of All Tables For a Keyword - Sql Server

Feb 20, 2019 BY xtreme

a custom functiondeclare @StringToSearch nvarchar(100) set @StringToSearch='Establishment'CREATE TABLE #Results (_ColumnName nvarchar(370), ColumnValue nvarchar(3630)) DECLARE @TableName nvarchar(256), @_ColumnName nvarchar(128), @SearchStr nvarchar(110) SET @TableName = '' SET @SearchStr = QUOT...

Find All Tables and Views Having Column with Specified Name - Sql Server

Feb 20, 2019 BY xtreme

Search Column Name in Tables n ViewsSELECT COLUMN_NAME AS 'ColumnName',TABLE_NAME AS 'TableName' FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%MyName%' ORDER BY TableName ,ColumnName; Search in Tables onlySELECT c.name AS 'ColumnName' ,t.name AS 'TableName' FROM sys.columns c JOIN ...

Parameterized Queries - Asp.Net

Feb 20, 2019 BY xtreme

A parameterized query includes placeholders for the actual data to be passed inUsing Sql Commandstring strQuery = "select Id,Name from Table where Name = @name"; SqlCommand cmd = new SqlCommand(strQuery, con); cmd.Parameters.AddWithValue("@name", txt.Text.Trim()); DataTable dt = GetData(cmd); ...

Local Method Calls inside a Linq query - C#

Feb 20, 2019 BY xtreme

LINQLanguage INtegrated Queries are SQL-like C# queries that can be used to manipulate collections of objects. You can call user-defined functions inline. functions that are included in a query whose execution is deferred are not executed until the query is executed.public async Task&...

List All Tables, Views - Sql Server

Feb 20, 2019 BY xtreme

list all tables All Tables In Sql 2000SELECT NAME FROM sysobjects WHERE xtype='U' All Tables In Sql 2005 and above SELECT TABLE_NAME FROM .INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'list all viewsAll Views In Sql 2000 SELECT NAME FROM sysobjects WHERE xtype='V' All Views I...