Alter Query

To add a column in a table, use Alter Query the following syntax:

ALTER TABLE table_name
ADD column_name datatype.

To delete a column in a table, use the following syntax (notice that some database systems don't allow deleting a column)

ALTER TABLE table_name
DROP COLUMN column_name.

To change the data type of a column in a table, use the following syntax:
ALTER TABLE table_name

MODIFY COLUMN column_name datatype.
(InMySql)

Read More

CHECK WHETHER DUPLICATE EATERY

IF((SELECT COUNT(*) FROM TableName WHERE ColumnName=@ColumnName AND ColumnName1=@ColumnName1) > 0)
BEGIN   
 SELECT '! Exit'
 return
 END
 ELSE
 SELECT '! Not Exit'  

Write this code then we can't face duplicate entry

Read More

The INSERT INTO statement is used to insert new records in a table.
Syntax:-
  INSERT INTO table_name (column1,column2,column3,...)
  VALUES (value1,value2,value3,...);

 The DELETE statement is used to DELETE  records in a table.
Syntax:-
  DELETE FROM table_name
  WHERE some_column=some_value; 

The UPDATE  statement is used to UPDATE  records in a table.
Syntax:-
  UPDATE table_name
  SET column1=value1,column2=value2,...
  WHERE some_column=some_value;

Read More

SQL SELECT Query
The SELECT statement is used to select data from a database.
Query
SELECT * FROM TABLE NAME.
Use this query we get All data of Table. And we Want to particular data then use Select Column Name
Example.

SELECT column_name,column_name
FROM table_name;
 

Read More

How To Timer Work in Asp.net

Using a Timer Control Inside an UpdatePanel Control

When the Timer control is included inside an UpdatePanel control, the Timer control automatically works as a trigger for the UpdatePanel control. You can override this behavior by setting the ChildrenAsTriggers property of the UpdatePanel control to false.
For Timer controls inside an UpdatePanel control, the JavaScript timing component is re-created only when each postback finishes. Therefore, the timed interval does not start until the page returns from the postback. For instance, if the Interval property is set to 60,000 milliseconds (60 seconds) but the postback takes 3 seconds to complete, the next postback will occur 63 seconds after the previous postback.
The following example shows how to include a Timer control inside an UpdatePanel control.

<asp:ScriptManager runat="server" id="ScriptManager1" />
<asp:UpdatePanel runat="server" id="UpdatePanel1" 
    UpdateMode="Conditional">
  <contenttemplate>
    <asp:Timer id="Timer1" runat="server"
      Interval="120000" 
      OnTick="Timer1_Tick">
    </asp:Timer>
  </contenttemplate>
</asp:UpdatePanel>

Using a Timer Control Outside an UpdatePanel Control

When the Timer control is outside an UpdatePanel control, you must explicitly define the Timer control as a trigger for the UpdatePanel control to be updated.
If the Timer controls is outside an UpdatePanel control, the JavaScript timing component continues to run as the postback is being processed. For example, if the Interval property is set to 60,000 milliseconds (60 seconds) and the postback takes 3 seconds to complete, the next postback will occur 60 seconds after the previous postback. The user will see the refreshed content in the UpdatePanel control for only 57 seconds.
You must set the Interval property to a value that enables one asynchronous postback to complete before the next postback is initiated. If a new postback is initiated while an earlier postback is being processed, the first postback is canceled.
The following example shows how to use the Timer control outside an UpdatePanel control.

<asp:ScriptManager runat="server" id="ScriptManager1" />
<asp:Timer ID="Timer1" runat="server" Interval="120000" 
  OnTick="Timer1_Tick">
</asp:Timer>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
  <Triggers>
    <asp:AsyncPostBackTrigger ControlID="Timer1" 
        EventName="Tick" />
    </Triggers>
    <ContentTemplate>
      <asp:Label ID="Label1" runat="server" ></asp:Label>
  </ContentTemplate>
</asp:UpdatePanel>

Read More