Hi ,
$(document).ready(function () {
$("#btnShowData").click(function () {
var param = { str: $('#txtCity').val() };
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Default3.aspx/BindEmployees",
data: JSON.stringify(param),
//data: "{}",
dataType: "json",
success: function (result) {
for (var i = 0; i < result.d.length; i++) {
$("#gvData").append("" + result.d[i].ID + " " + result.d[i].ReportName + " " + result.d[i].ReportDescription + " " + result.d[i].Status + "
}
},
error: function (result) {
alert("Error");
}
});
});
});
// $(document).ready(function () {
// $("#btnShowData").click(function ()
// {
// $.ajax({
// type: "POST",
// contentType: "application/json; charset=utf-8",
// url: "Default3.aspx/BindEmployees",
// data: "{}",
// dataType: "json",
// success: function (result) {
// for (var i = 0; i < result.d.length; i++) {
// $("#gvData").append("
// }
// },
// error: function (result) {
// alert("Error");
// }
// });
// });
// });
script>
<script type="text/javascript">
$(function () {
$("#txtCity").autocomplete({
source: function (request, response) {
var param = { cityName: $('#txtCity').val() };
$.ajax({
url: "Default3.aspx/GetCities",
data: JSON.stringify(param),
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
dataFilter: function (data) { return data; },
success: function (data) {
response($.map(data.d, function (item) {
return {
value: item
}
}))
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
alert(textStatus);
}
});
},
minLength: 2//minLength as 2, it means when ever user enter 2 character in TextBox the AutoComplete method will fire and get its source data.
});
});
script>
head>
<body>
<button id="btnShowData" runat="server">Show Databutton>
<form id="form1" runat="server">
City:
<asp:TextBox ID="txtCity" runat="server">asp:TextBox>
<br />
<div>
<asp:GridView ID="gvData" runat="server" CellPadding="4" ShowHeaderWhenEmpty="true" ForeColor="#333333">
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:TemplateField>
<AlternatingItemTemplate>
<asp:CheckBox ID="chkStatus" runat="server" />
AlternatingItemTemplate>
asp:TemplateField>
Columns>
asp:GridView>
div>
form>
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.BindGrid();
}
}
public void BindGrid()
{
DataTable dt = new DataTable();
dt.Columns.Add(" ID ");
dt.Columns.Add("ReportName");
dt.Columns.Add("ReportDescription");
dt.Columns.Add("Status");
gvData.DataSource = dt;
gvData.DataBind();
}
[WebMethod]
public static Employee[] BindEmployees(string str)
{
//DataTable dt = new DataTable();
List < Employee> employeeList = new List<Employee>();
using (SqlConnection con = new SqlConnection(@"Data Source = .; initial Catalog = master; Integrated Security = true"))
{
string Query = "SELECT * FROM Report WHERE ReportName= '" + str.ToString() + "'";
using (SqlCommand command = new SqlCommand(Query))
{
command.Connection = con;
con.Open();
SqlDataAdapter da = new SqlDataAdapter(command);
using (DataTable dt = new DataTable())
{
da.Fill(dt);
foreach (DataRow dtrow in dt.Rows)
{
Employee employee = new Employee();
employee.ID = dtrow["ID"].ToString();
employee.ReportName = dtrow["ReportName"].ToString();
employee.ReportDescription = dtrow["ReportDescription"].ToString();
employee.Status = dtrow["Status"].ToString();
employeeList.Add(employee);
}
}
}
}
return employeeList.ToArray();
}
public class Employee
{
public string ID { get; set; }
public string ReportName { get; set; }
public string ReportDescription { get; set; }
public string Status { get; set; }
}
[WebMethod]
public static List<string> GetCities(string cityName)
{
List<string> City = new List<string>();
string query = string.Format("SELECT ReportName FROM Report WHERE ReportName LIKE '%{0}%'", cityName);
//Note: you can configure Connection string in web.config also.
using (SqlConnection con = new SqlConnection(@"Data Source = .; initial Catalog = master; Integrated Security = true"))
{
using (SqlCommand cmd = new SqlCommand(query, con))
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
City.Add(reader.GetString(0));
}
}
}
return City;
}
public void chkStatus_OnCheckedChanged(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source = .; initial Catalog = master; Integrated Security = true");
con.Open();
CheckBox chkStatus = (CheckBox)sender;
Int64 nID = Convert.ToInt64(gvData.DataKeys[((GridViewRow)chkStatus.NamingContainer).RowIndex].Value);
string sQuery = "UPDATE Report SET Status = @Status WHERE ID = @ID";
SqlCommand com = new SqlCommand(sQuery, con);
com.Parameters.Add("@Status", SqlDbType.Bit).Value = chkStatus.Checked;
com.Parameters.Add("@ID", SqlDbType.BigInt).Value = nID;
com.ExecuteNonQuery();
BindGrid();
}
}
Bharath PeggemPosted Oct 16, 2015, 7:22 AM
Bharath PeggemPosted Oct 15, 2015, 7:26 AM
$('input[type=checkbox]').click(function () {
if ($(this).is(':checked')) {
var checkid = $('input[type=checkbox]').val();
$.ajax({
url: "Default3.aspx/UpdateCustomer?Id=' + checkid + '&status=' + 1",
data: JSON.stringify(checkid),
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
success: function (data) {
//write msg updated
alert("Record successfully updated!!!");
//location.reload();
}
});
}
return false;
});
});
Davin MartynPosted Oct 15, 2015, 4:26 AM
Davin MartynPosted Oct 14, 2015, 9:37 AM
Please check my code :
<script language="javascript" type="text/javascript">
$(document).ready(function () {
$('input[type=checkbox]').click(function () {
if ($(this).is(':checked')) {
var checkid = $('input[type=checkbox]').val();
$.ajax({
url: "Default3.aspx/UpdateCustomer?Id=' + checkid + '&status=' + 1",
data: JSON.stringify(checkid),
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
success: function (data) {
//write msg updated
alert("Record successfully updated!!!");
//location.reload();
}
});
}
return false;
});
});
script>
AND CS :[WebMethod]
public static void UpdateCustomer(int checkid, int status)
{
using (SqlConnection con = new SqlConnection(@"Data Source = .; initial Catalog = master; Integrated Security = true"))
{
using (SqlCommand cmd = new SqlCommand("UPDATE record SET status = @status WHERE Id = @checkid"))
{
cmd.Parameters.AddWithValue("@Id", checkid);
cmd.Parameters.AddWithValue("@status", status);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
I an unable to update after check on checkbox please check what is the problem in my web method or script?Davin MartynPosted Oct 14, 2015, 9:37 AM
Please check my code :
<script language="javascript" type="text/javascript">
$(document).ready(function () {
$('input[type=checkbox]').click(function () {
if ($(this).is(':checked')) {
var checkid = $('input[type=checkbox]').val();
$.ajax({
url: "Default3.aspx/UpdateCustomer?Id=' + checkid + '&status=' + 1",
data: JSON.stringify(checkid),
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
success: function (data) {
//write msg updated
alert("Record successfully updated!!!");
//location.reload();
}
});
}
return false;
});
});
script>
AND CS :[WebMethod]
public static void UpdateCustomer(int checkid, int status)
{
using (SqlConnection con = new SqlConnection(@"Data Source = .; initial Catalog = master; Integrated Security = true"))
{
using (SqlCommand cmd = new SqlCommand("UPDATE record SET status = @status WHERE Id = @checkid"))
{
cmd.Parameters.AddWithValue("@Id", checkid);
cmd.Parameters.AddWithValue("@status", status);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
I an unable to update after check on checkbox please check what is the problem in my web method or script?Bharath PeggemPosted Oct 14, 2015, 5:10 AM
Davin MartynPosted Oct 14, 2015, 3:51 AM
Hello Sir....
Any update ?
Davin MartynPosted Oct 14, 2015, 1:03 AM
Bharath PeggemPosted Oct 13, 2015, 10:36 AM
Davin MartynPosted Oct 13, 2015, 10:16 AM
Please check I unable to update record
[WebMethod]
public static void UpdateCustomer(int Id, int status)
{
using (SqlConnection con = new SqlConnection(@"Data Source = .; initial Catalog = master; Integrated Security = true"))
{
using (SqlCommand cmd = new SqlCommand("UPDATE record SET status = @status WHERE Id = @Id"))
{
cmd.Parameters.AddWithValue("@Id", Id);
cmd.Parameters.AddWithValue("@status", status);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
}
<script type="text/javascript">
$('input[type=checkbox]').click(function() {
if($(this).is(':checked')) {
var checkid = $('input[type=checkbox]').val();
$.ajax({
url: "Default3.aspx/UpdateCustomer",
data: JSON.stringify(checkid),
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
success: function (data) {
//write msg updated
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
alert(textStatus);
}
});
}
else
{
alert(textStatus);
}
});
script>
Bharath PeggemPosted Oct 13, 2015, 9:34 AM
$.ajax({
url: "yoururlpath",
data: JSON.stringify(checkid),
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
success: function (data) {
//write msg updated
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
// write msg not Updated
}
});
},
Davin MartynPosted Oct 13, 2015, 8:55 AM
Hi
Davin MartynPosted Oct 13, 2015, 4:47 AM
Bharath PeggemPosted Oct 13, 2015, 3:28 AM