Blog | Programming71.com

SDLC (Software Development Life Cycle)

May 30, 2020May 30, 2020 Debbrath 2 Comments Software

The Software Development Lifecycle (SDLC) is a systematic process for building software that ensures the quality and correctness of the software built. SDLC process aims to produce high-quality software which meets customer expectations. The system development should be complete in the pre-defined time frame and cost. SDLC stages cover the complete life cycle of a […]

SQL Constraints

May 30, 2020October 18, 2021 Debbrath 2 Comments SQL

I want to discuss about SQL Constraints. Column level constraints : limits only column data Table level constraints : limits whole table data Common types of constraints include the following: NOT NULL Constraint: Ensures that a column cannot have NULL value. DEFAULT Constraint: Provides a default value for a column when none is specified. UNIQUE […]

Introduction to ASP.NET Core

May 30, 2020October 17, 2021 Debbrath Leave a comment ASP.NET

ASP.NET Core is a cross-platform, high-performance, open-source framework for building modern, cloud-based, Internet-connected applications.

Sql DateTime

May 30, 2020October 16, 2021 Debbrath 3 Comments SQL

In this article we discus about SQL DateTime Format. SQL Server provides a number of options you can use to SQL DateTime Format. One of the first considerations is the actual date/time needed. The most common is the current date/time using getdate(). This provides the current date and time according to the server providing the […]

C# search in Data Table

May 30, 2020October 15, 2021 Debbrath Leave a comment C#

I want to discuss about c# search in Data Table Search DataTable by Column Name: Example:

string _sqlWhere; _sqlWhere = "PROD_NAME like '" + strProductName + "%' and BOM_CATEGORY_ID in (" + strBomCategory + ")"; 
DataTable _newDataTable = dt.Select(_sqlWhere).CopyToDataTable();

1 2	string _sqlWhere; _sqlWhere = "PROD_NAME like '" + strProductName + "%' and BOM_CATEGORY_ID in (" + strBomCategory + ")"; DataTable _newDataTable = dt.Select(_sqlWhere).CopyToDataTable();

You can search group of value from datatable using DataView . First create dataview from datatable. And then Filter in dataview by column name and order by. Example:

DataTable dTable ;

DataView dv = dTable .DefaultView;

dv.RowFilter = "parentcode=" + code + "";
dv.Sort = "code desc";

DataTable dTable ;

DataView dv = dTable .DefaultView;

dv.RowFilter = "parentcode=" + code + "";

dv.Sort = "code desc";

Then copy dataview to datatable:

dTable = dv.ToTable();

1	dTable = dv.ToTable();

Another way, […]

WordPress Yoast SEO

May 30, 2020October 14, 2021 Debbrath Leave a comment WordPress

WordPress Yoast SEO improve your site’s SEO on all needed aspects. Technical optimization for your site. Automatically optimizing and inserting the meta tags and link elements that Google and other search engines like. With the Yoast SEO plugin you can control which pages Google shows in its search results and which pages it doesn’t show. […]

SQL Basic Query

May 30, 2020October 13, 2021 Debbrath 1 Comment SQL

I want to discuss about SQL Basic Query. Microsoft SQL and Oracle PLSQL is import for DB sql query. SQL queries can be written in the box located under the “Execute SQL” tab. Click ‘Run SQL’ to execute the query in the box.

SELECT year
FROM surveys;

1 2	SELECT year FROM surveys;

We have capitalized the words SELECT and FROM because they are […]

Advance SQL queries

May 30, 2020October 12, 2021 Debbrath Leave a comment SQL

DELETE a FROM Table1 AS a INNER JOIN Table2 AS b ON a.id = b.id

Sql Syntax

May 30, 2020October 11, 2021 Debbrath 1 Comment SQL

SQL is followed by a unique set of rules and guidelines called Sql Syntax. All the SQL statements start with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW and all the statements end with a semicolon (;). Various Syntax in SQL: SQL SELECT Statement SELECT column1, column2….columnN FROM table_name; […]

ETL (Extract, Transform, and Load) Process

May 30, 2020October 10, 2021 Debbrath 3 Comments SQL

I want to introduce about Microsoft Excel and SQL server integration (ETL process). First of all Open Excel and then go to Data menu. Now select Get Data and From other sources. Select From Microsoft Query. As per below: Then connect to Database. Click Cancel. And Yes. And Close. Now go to File menu and […]