Please find the my below code default.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%--
<----------default.cs-------------------->
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Web.Services;
using System.Configuration;
using System.Data.SqlClient;
using System.Web.Script.Services;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
public class Name
{
public String FromDate { get; set; }
public String ToDate { get; set; }
}
[WebMethod]
[ScriptMethod]
public static List GetCustomers(Name user)
{
string constr = ConfigurationManager.ConnectionStrings["LMS"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("select Emp_Nm from dbo.Emp_Master"))
{
List customers = new List();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@fromdate", user.FromDate);
cmd.Parameters.AddWithValue("@todate", user.ToDate);
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
customers.Add(new ListItem
{//Value = sdr["CustomerId"].ToString(),
Text = sdr["Emp_Nm"].ToString()
});
}
}
con.Close();
return customers;
}
}
}
}
Imran BagawanPosted May 14, 2016, 1:30 AM
Purba AnggaraPosted May 12, 2016, 1:40 AM
Purba AnggaraPosted May 12, 2016, 1:38 AM
Imran BagawanPosted May 12, 2016, 1:33 AM
Purba AnggaraPosted May 12, 2016, 1:22 AM
format Date Visit https://msdn.microsoft.com/en-us/library/8kb3ddd4%28v=vs.110%29.aspx