-- JQuery GridView One CheckBox Selected Check

   if ($('#<%=GridView1.ClientID%> input:checkbox:checked').length > 0) {
      alert('selected');
    }
   else {
       alert('Not Selected');
    }

-- Asp.net Embedded InLine Code Binding --

Page Directive
<%@ Page Language="C#" %>
Rendering Code
<% Response.Write("Hello World!"); %>
<%= SayHello("Ahmed") %>
<%: DateTime.Now.ToString() %>
Expression Syntax
<%$ ConnectionStrings:ConnStrFromWebConfig %>
<%$ AppSettings:ValueFromWebConfig %>
<%$ Resources:Resource, Arabic %>
<%$ RouteValue:year %>
<%$ YourExpressionPrefix : Any %>
Data Binding Syntax
<%# Eval("Name") %>
<%# Bind("Name") %>
<%# XPath ("Name") %>
Comment Server
<%-- -- %>

Reseed/Reset Table Identity Value

DBCC CHEKIDENT Used To Reset Your Table Value
For Example

    If  We Want Next Record To Have Identity As 135 We Need To Run Sql Query To :

DBCC CHECKIDENT (yourTABLEname, reseed, 134)

                                                             For More Details Visit Microsoft Tech Lab

WebService Url

http://www.mikesdotnetting.com/Article/104/Many-ways-to-communicate-with-your-database-using-jQuery-AJAX-and-ASP.NET

WebService , Ajax

  <script type="text/javascript">
    $(document).ready(function(){
    $("#Customers").change(function(){
    //Using Load Method
       $("#CustomerDetails").load("FetchCustomer.aspx?CustomerID=" + $('#Customers').val());
     });

    //Using getMethod
    $.get("FetchCustomer.aspx",
       { CustomerID: "" + $('#Customers').val() + "" },
       function(data){
                $('#CustomerDetails').html(data);
                });
 
     //Using Ajax Method
      $.ajax({
               contentType : "text/html;charset=utf-8",
               data:"CustomerID="+$('#Customers').val(),
               url:"FetchCustomer.aspx",
               dataType:"html",
               success:function(data){
                $('#CustomerDetails').html(data);
                }
             });
          });
     });
    </script>

Drop All Procedures

DECLARE @name VARCHAR(128)

DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])

WHILE @name is not null

BEGIN

    SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'

    EXEC (@SQL)

    PRINT 'Dropped Procedure: ' + @name

    SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 AND [name] > @name ORDER BY [name])

END

GO

C# Sql Connection String

connetionString="Data Source=ServerName;
  Initial Catalog=DatabaseName;User ID=UserName;Password=Password"

  cnn = new SqlConnection(connetionString);

Example

string connetionString = null;

            SqlConnection cnn ;

   connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password" 

            cnn = new SqlConnection(connetionString);

            try

            {

                cnn.Open();

                MessageBox.Show ("Connection Open ! ");

                cnn.Close();

            }

            catch (Exception ex)

            {

                MessageBox.Show("Can not open connection ! ");

            }