wordpress plugins yoast seo activities
SQL Constraints
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 […]
How to install and configure XAMPP and WP
Advance SQL queries
C# search in Data Table
I want to discuss about c# search in Data Table Search DataTable by Column Name: Example:
|
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:
|
1 2 3 4 5 6 |
DataTable dTable ; DataView dv = dTable .DefaultView; dv.RowFilter = "parentcode=" + code + ""; dv.Sort = "code desc"; |
Then copy dataview to datatable:
|
1 |
dTable = dv.ToTable(); |
Another way, […]
Sql DateTime
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 […]
SQL Basic Query
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.
|
1 2 |
SELECT year FROM surveys; |
We have capitalized the words SELECT and FROM because they are […]
Introduction to ASP.NET Core
ASP.NET Core is a cross-platform, high-performance, open-source framework for building modern, cloud-based, Internet-connected applications.
WordPress Yoast SEO
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. […]
