Difference between break and continue in c#break : key word used when we want to terminate code execution or terminate execution of loop let see below example and understand. for (int k = 0; k < 10; k++) { if (k == 5) { ...
Query to Alter,Add,modify,delete columns in table - sql server
Introduction:
how to write SQL Query to add new column to existing table in sql server and query to delete column from table in sql and query to modify column in existing table.
Query to add new column to table
If we want to add new column to existing table that syntax will be like this
ALTER TABLE Table_Name ADD COLUMN_NAME DATATYPE
Ex:
ALTER TABLE emp_table ADD Manager_Name...
This article
demonstrates some commonly asked SQL queries in a .NET/SQL job interview.
Let’s create Employee
table and insert data as shown below
to perform basic sql query operation.
CREATE TABLE #Employee
(
EmpID INT Identity,
Empname Varchar(100),
EmpSal Decimal (10,2),
DEPARTMENT varchar(100),
JOINING_DATE varchar(100)
)
INSERT INTO #Employee VALUES ('Krishna',50000,'System...
Here I will explain
how to merge cells in asp.net grid view Footer as per requirement.
write code like as
shown below in your aspx page
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>merger Footer
programmatically as per requirement</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
OnRowDataBound="GridView1_RowDataBound" ShowFooter="true" BackColor="#339966" >
<Columns>
<asp:TemplateField HeaderText="Employee
...
Subscribe to:
Posts (Atom)