This is default featured post 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

Wednesday, November 25, 2015

Gareeb Jaan Ke Humko Na

Gareeb Jaan Ke Humko Na Tum Mita Dena, Tumhin Ne Dard Diya
Tumhin Ne Dard Diya, Tumhin Dawa Dena
Gareeb Jaan Ke...

Lagi Hai Chot Kaleje Pe Umr Bhar Ke Liye (2)
Tadap Rahe Hain Mohabbat Mein Ek Nazar Ke Liye, Nazar Mila Ke
Nazar Mila Ke Mohabbat Se Muskuraa Dena
Tumhin Ne Dard Diya, Tumhin Dawa Dena
Gareeb Jaan Ke...


Jahan Mein Aur Hamaara Kahan Thikaana Hai (2)
Tumhaare Dar Se Kahan Uth Ke Humko Jaana Hai, Jo Ho Sake Toh
Jo Ho Sake Toh Muqadaar Mera Jaga Dena
Tumhin Ne Dard Diya, Tumhin Dawa Dena
Gareeb Jaan Ke...

Mila Qaraar Na Dil Ko Kisi Bahaane Se
Tumhaari Aas Lagaayein Hain Ek Zamaane Se, Kabhi Toh Apni
Kabhi Toh Apni Mohabbat Ka Aasra Dena
Tumhin Ne Dard Diya, Tumhin Dawa Dena
Gareeb Jaan Ke...

Geeta Dutt: Nazar Tumhaari Mere Dil Ki Baat Kehti Hai (2)
Tumhaari Yaad Toh Din Raat Saath Rehti Hai, Tumhaari Yaad Ko
Tumhaari Yaad Ko Mushkil Hai Ab Bhula Dena
Tumhin Ne Dard Diya, Tumhin Dawa Dena
Tumhi Ne Dard Diya...

Mohd.Rafi: Milega Kya Jo Yeh Duniya Humein Sataayegi (2)
Tumhaare Bin Toh Humein Maut Bhi Na Aayegi, Kisi Ke Pyaar Ko
Kisi Ke Pyaar Ko Aasaan Nahin Mita Dena
Tumhin Ne Dard Diya, Tumhin Dawa Dena
Gareeb Jaan Ke!

Tuesday, November 17, 2015

jQuery UI AutoComplete TextBox with asp.net webforms



Method 1 (using Handlers)


Connection String
<connectionStrings>
      <addname="constr"connectionString="Data Source = .\SQLExpress;       
       Initial Catalog = Northwind; Integrated Security = true"/>
</connectionStrings>

  
AutoComplete Handler
<%@ WebHandler Language="C#" Class="Search_CS" %>
using System;
using System.Web;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;
public class Search_CS : IHttpHandler {
   
    public void ProcessRequest (HttpContext context) {
        string prefixText = context.Request.QueryString["q"];
        using (SqlConnection conn = new SqlConnection())
        {
            conn.ConnectionString = ConfigurationManager
                    .ConnectionStrings["constr"].ConnectionString;
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandText = "select ContactName from Customers where " +
                "ContactName like @SearchText + '%'";
                cmd.Parameters.AddWithValue("@SearchText", prefixText);
                cmd.Connection = conn;
                StringBuilder sb = new StringBuilder();
                conn.Open();
                using (SqlDataReader sdr = cmd.ExecuteReader())
                {
                    while (sdr.Read())
                    {
                        sb.Append(sdr["ContactName"])
                            .Append(Environment.NewLine);
                    }
                }
                conn.Close();
                context.Response.Write(sb.ToString());
            }
        }
    }
    public bool IsReusable {
        get {
            return false;
        }
    }
}

Client Side Implementation
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
<link href="css/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
<script src="scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script src="scripts/jquery.autocomplete.js" type="text/javascript"></script>
<script type="text/javascript">
    $(document).ready(function() {
        $("#<%=txtSearch.ClientID%>").autocomplete('Search_CS.ashx');
    });      
</script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="txtSearch" runat="server"></asp:TextBox>
    </div>
    </form>
</body>
</html>

Javascript
<script type="text/javascript">
    $(document).ready(function() {
        $("#<TextBoxControlId>").autocomplete('<Url of handler>');
    });      
</script>
Example AJAX Autocomplete Extender using jQuery in ASP.Net



Method 2 (using web Methods)


Aspx page
protected void Page_Load(object sender, EventArgs e)
{

}

[WebMethod]
public static List<string> GetAutoCompleteData(string username)
{
List<string> result = new List<string>();
using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"))
{
using (SqlCommand cmd = new SqlCommand("select DISTINCT UserName from UserInformation where UserName LIKE '%'+@SearchText+'%'", con))
{
con.Open();
cmd.Parameters.AddWithValue("@SearchText", username);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
result.Add(dr["UserName"].ToString());
}
return result;
}
}
}


Javascript in Head section of the page 
 
$(".autosuggest").autocomplete({
source: function(request, response) {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Default.aspx/GetAutoCompleteData",
data: "{'username':'" + document.getElementById('txtSearch').value + "'}",
dataType: "json",
success: function(data) {
response(data.d);
},
error: function(result) {
alert("Error");
}
});
}
});


Tuesday, November 3, 2015

Earn





Start earning money in less than 10 minutes!


Maximize your revenue with PopCash! You can start earning money in less then 10 minutes. All you need is an account in our system and your domains approved. Once you have done those things you can place the Javascript code (generated by our system) in your website body. This is all! Now all your visitors will view a pop-under from PopCash. Our pop-under is showed once in a 24 hour timeframe, so your visitors will not be disturbed by repeated popunders!

Key Advantages


  • Almost all websites are accepted.
  • We pay for all visitors (worldwide traffic).
  • Clean ads. We test the campaigns landing pages multiple times every day.
  • Withdrawals are processed daily (on weekdays).
  • Minimum withdrawal amount is only $10.
  • Very quick domain approval.
  • Hourly updated detailed statistics of your revenues.
  • Intuitive and very easy to use administration interface.
  • Online support through many instant messengers and through email.
  • Many targeting & optimizing possibilities and various traffic sources.
  • Payments through PayPal, Paxum or Payza.

Are you ready to start? You can register here!

Monday, November 2, 2015

You Give Love A Bad Name



Shot through the heart
And you're to blame
Darling, you give love a bad name...

An angel's smile is what you sell
You promise me heaven, then put me through hell
Chains of love got a hold on me
When passion's a prison, you can't break free

Oh, oh, you're a loaded gun (yeah)
Oh, oh, there's nowhere to run
No one can save me
The damage is done

[Chorus:]
Shot through the heart
And you're to blame
You give love a bad name (bad name)
I play my part
And you play your game
You give love a bad name (bad name)
You give love a bad name
You give love a bad name

Paint your smile on your lips
Blood red nails on your fingertips
A school boy's dream, you act so shy
Your very first kiss was your first kiss goodbye

Oh, oh, you're a loaded gun
Oh, oh, there's nowhere to run
No one can save me
The damage is done

[Chorus:]
Shot through the heart
And you're to blame
You give love a bad name (bad name)
I play my part
And you play your game
You give love a bad name (bad name)
You give love... ah!

Oh!

[Chorus:]
Shot through the heart
And you're to blame
You give love a bad name
I play my part
And you play your game
You give love a bad name (bad name)

Shot through the heart
And you're to blame
You give love a bad name (bad name)
I play my part
And you play your game
You give love a bad name (bad name)
(Whoa) You give love
(Whoa) You give love (bad name)
(Whoa) You give love
(Whoa) You give love (bad name)
(Whoa) You give love
(Whoa) You give love (bad name)
(Whoa) You give love
(Whoa) You give love (bad name)

Friday, October 31, 2014

Dynamic DataTable

                     DataSet ds = new DataSet();
            DataTable dtEmp = new DataTable();
            DataTable dtDept = new DataTable();

            DataColumn deptPK = new DataColumn { ColumnName = "DepartmentID", DataType = typeof(Int32), AutoIncrement = true };
            dtDept.Columns.Add(deptPK);
            dtDept.Columns.Add(new DataColumn { ColumnName = "DeptName", DataType = typeof(string) });
            dtDept.PrimaryKey = new DataColumn[] { deptPK };
            ds.Tables.Add(dtDept);

            DataColumn empPK = new DataColumn { ColumnName = "EmpID", DataType = typeof(Int32), AutoIncrement = true };
            DataColumn colName = new DataColumn { ColumnName = "Name", DataType = typeof(string), AutoIncrement = true };
            dtEmp.Columns.Add(empPK);
            dtEmp.Columns.Add(colName);
            dtEmp.Columns.Add(new DataColumn { ColumnName = "City", DataType = typeof(string), AutoIncrement = true });
            dtEmp.Columns.Add(new DataColumn { ColumnName = "Salary", DataType = typeof(double), AutoIncrement = true });
            dtEmp.Columns.Add(new DataColumn { ColumnName = "DOJ", DataType = typeof(DateTime), AutoIncrement = true });
            dtEmp.Columns.Add(new DataColumn { ColumnName = "DepartmentID", DataType = typeof(Int32), AutoIncrement = true });
            //Constraints
            dtEmp.PrimaryKey = new DataColumn[] { empPK };
            UniqueConstraint unq = new UniqueConstraint(new DataColumn[] { colName });
            dtEmp.Constraints.Add(unq);
            ds.Tables.Add(dtEmp);


            ForeignKeyConstraint fk = new ForeignKeyConstraint("ForeignKey", dtDept.Columns["DepartmentID"], dtEmp.Columns["DepartmentID"]);
            dtEmp.Constraints.Add(fk);