Hello all i am getting following error on click of my button
please check code and let me know,
i have already spent lot of time solving this.
Purpose of this code is to get list of country's based on pincode
my dropdown is coming correct
but after that when i click on button to get my dropdownvalue in c#
it throws this error.
Object reference not set to an instance of an object.
I am getting this error on click of my button.
aspx code
<%@ Page Language="C#" AutoEventWireup="false" CodeFile="Default.aspx.cs" Inherits="_Default" EnableEventValidation="true"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Bind Dropdownlist with JQuery in asp.net</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<script type="text/javascript">
$(function () {
$('[id$=txtPin]').change(function () {
var v = $('[id$=txtPin]').val();
$.ajax({
type: "POST",
contentType: "application/json;charset=utf-8",
url: "Default.aspx/BindDatatoDropdown",
data: JSON.stringify({ id: '1', pinCode: v }),
dataType: "json",
success: function (data) {
$.each(data.d, function (key, value) {
$("#ddlCountry").append($("<option></option>").val(value.ID).html(value.Description));
});
},
error: function (result) {
alert("error");
}
});
});
$('[id$=ddlCountry]').change(function () {
alert("Handler for .change() called.");
});
});
$(document).ready(function () {
});
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:TextBox ID="txtPin" runat="server"></asp:TextBox>
<br />
<br />
<asp:DropDownList ID="ddlCountry" runat="server" />
<%----%>
<p>
<%----%>
</p>
<asp:Button ID="btnGetData" runat="server" OnClick="btnGetData_Click" Text="Get Data" />
</form>
</body>
</html>
C# Code
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Services;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
public class PODetails
{
public string ID { get; set; }
public string Description { get; set; }
}
[WebMethod]
public static PODetails[] BindDatatoDropdown(string id, string pinCode)
{
DataTable dt = new DataTable();
List<podetails> details = new List<podetails>();
using (SqlConnection con = new SqlConnection("Data Source=SAM-PC;Initial Catalog=BPOPortalProd;Persist Security Info=True;User ID=sa;Password=sudesi123"))
{
SqlCommand cmd = new SqlCommand("GetAddressDetails",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.VarChar, 100)).Value = id;
cmd.Parameters.Add(new SqlParameter("@pincode", SqlDbType.VarChar, 100)).Value = pinCode;
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dtrow in dt.Rows)
{
PODetails country = new PODetails();
country.ID = dtrow["ID"].ToString();
country.Description = dtrow["Description"].ToString();
details.Add(country);
}
}
return details.ToArray();
}
protected void btnGetData_Click(object sender, EventArgs e)
{
string str = ddlCountry.SelectedItem.Text;
}
}
Thanks in Advance
Submit an article or tip