<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function () { $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "Bind/BindDatatable",---->check here plz data: "{}", dataType: "json", success: function (data) { for (var i = 0; i < data.d.length; i++) { $("#gvDetails").append("<tr><td>" + data.d[i].UserId + "</td><td>" + data.d[i].UserName + "</td><td>" + data.d[i].Location + "</td></tr>"); } }, error: function (result) { alert("Error"); } }); }); </script> <asp:GridView ID="gvDetails" runat="server"> <HeaderStyle BackColor="#DC5807" Font-Bold="true" ForeColor="White" />
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindColumnToGridview(); } } private void BindColumnToGridview() { DataTable dt = new DataTable(); dt.Columns.Add("UserId"); dt.Columns.Add("UserName"); dt.Columns.Add("Location"); dt.Rows.Add(); gvDetails.DataSource = dt; gvDetails.DataBind(); gvDetails.Rows[0].Visible = false; } [WebMethod] public static UserDetails[] BindDatatable() { DataTable dt = new DataTable(); List<UserDetails> details = new List<UserDetails>(); using (SqlConnection con = new SqlConnection("Data Source=184.168.47.17;Initial Catalog=Question_Papers;User ID=Shravan;Password=Shravan@34; Trusted_Connection=False")) { using (SqlCommand cmd = new SqlCommand("select TOP 10 UserId,UserName,Location from Test_1", con)) { con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); foreach (DataRow dtrow in dt.Rows) { UserDetails user = new UserDetails(); user.UserId = dtrow["UserId"].ToString(); user.UserName = dtrow["UserName"].ToString(); user.Location = dtrow["Location"].ToString(); details.Add(user); } } } return details.ToArray(); } public class UserDetails { public string UserId { get; set; } public string UserName { get; set; } public string Location { get; set; } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)