Unveiling Tomorrow's Tech Today, Where Innovation Meets Insight
Add Datagridview1, Textbox control and two radio buttons on form, radio button name rd1, rd2. // Form Mudule using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; …
Search as you type using c# Read MoreHow to find a special character in a string Query – I This query finds all special character in a string. remove special character in a string in SQL SERVER …
How to find Special character in a string using SQL LIKE operator Read MoreUpdate Command with Case Statement or Expression Update Data from one table to another table using Oracle How to use Subquery in Where Clause How to delete duplicate record in …
Advance SQL Update command Read MoreFirst need to add the reference “Microsoft.Office.Interop.Excel”. You can add it from .Net components. Add an open Dialog box control, Datagridview1, Textbox control and two Command buttons on form using …
Import Data from Excel to DataGridView in C# Read MoreThis query returns “High” and “Low” based on their salary compared to the average salary of all employees. SELECT employee_id, first_name, CASE WHEN Salary>=(SELECT Avg(Salary) From Employees) THEN ‘High’ ELSE ‘Low’ …
How to Use Sub Query in Case Expression Read MoreThis query I used aggregate functions with sub-queries SELECT (SELECT MAX(salary) FROM employees) AS Highest, (SELECT MIN(salary) FROM employees) AS Lowest, (SELECT COUNT(*) FROM employees) AS Employees, (SELECT SUM(salary) FROM …
Subquery as column in Oracle SELECT Statements Read MoreEXTRACT function extracts and returns the year, month, day, hour, minute, second, or time zone from Z, Z may be a timestamp or a DATE. The Syntax of the EXTRACT …
EXTRACT Function in SQL Read MoreSQL Insert IntoCommand How to Copying a Table Definition Use the CREATE TABLE command with a subquery that returns no rows: Query: Create Table E_Detail as Select * from Employees …
SQL Insert Into Command Read MoreUpdate data in one table with data from another table How to update multiple columns in a table with values from columns in another table. Oracle Table Structures and values: Create …
Update data in one table with data from another table Read MorePass Parameter to SQL Stored procedure from VB Create Stored Procedure in SQL Server Create Proc [dbo].[PassP] @Id smallint as Select * from dbo.Customers where Id=@Id Visual Basic Dim sqlcnn …
Passing Parameters Read More