I want to change this code to jquery if thisIsPostBack thisPopulatebooks private void Populatebooks username thisPageUserIdentityName string userId Session34UserId34ToString string getADPOST 34GetNewRESULT34 using SqlConnection con new SqlConnectionconstring conOpen using SqlCommand cmd new SqlCommandgetADPOST con

Hi micahI have created sample code which fullfill your requirementSo please refer the below codeHTMLltform id34form134 runat34server34gtlttable border34034 cellpadding34034 cellspacing34034gt lttrgt lttdgt Name lttdgt lttdgt ltaspTextBox ID34txtName34 runat34server34 gt lttdgt lttrgt lttrgt lttdgt Country lttdgt lttdgt ltaspTextBox ID34txtcountry34 runat34server34 gt lttdgt lttrgt lttrgt lttdgt ltaspButton ID34btnSubmit34 Text34Submit34 runat34server34 gt lttdgt lttrgtlttablegtltbr gtltdivgt ltaspDataList ID34dlGetresult34 runat34server34 RepeatColumns34334 RepeatDirection34Horizontal34gt ltItemTemplat

Refresh DataList after adding new record on Button click using jQuery Ajax in ASP.Net

micah

SOLVED CLOSED ACTIVE ANSWERED
User: micah
Posted: on Jul 27, 2017 12:19 AM
Forum: Data Controls
Answer: 1
Views: 7233

I want to change this code to jquery

if (!this.IsPostBack)
        {

            this.Populatebooks();
        }
    }

    private void Populatebooks()
    {

        username = this.Page.User.Identity.Name;
        //string userId = Session["UserId"].ToString();

        string getADPOST = "GetNewRESULT";
        using (SqlConnection con = new SqlConnection(constring))
        {
            con.Open();
            using (SqlCommand cmd = new SqlCommand(getADPOST, con))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                {
                    cmd.Parameters.AddWithValue("@UserName", Session["userName"]);
                    cmd.Parameters.AddWithValue("@FriendUserName", Fusername);
                    DataTable dt = new DataTable();
                    SqlDataAdapter sda = new SqlDataAdapter(cmd);
                    sda.Fill(dt);
                    Getresult.DataSource = dt;
                    Getresult.DataBind();
                }
            }

        }
    }

    protected void People(object sender, EventArgs e)
    {

        DataListItem item = (sender as LinkButton).NamingContainer as DataListItem;

        string usernameFlw = ((item.FindControl("lblusename") as Label).Text);


        using (SqlConnection con = new SqlConnection(constring))
        {
            if ((item.FindControl("btnRecom") as LinkButton).Text.ToUpper() == "ADD")


                using (SqlCommand cmd = new SqlCommand("INSERT INTO FStatus values(@UserName,@FriendUserName,@UserStatus,@Count)", con))
                {
                    //  cmd.Parameters.AddWithValue("@UserId", Session["UserId"]);
                    //  cmd.Parameters.AddWithValue("@BookId", bookId);
                    cmd.Parameters.AddWithValue("@UserName", Session["userName"]);
                    cmd.Parameters.AddWithValue("@FriendUserName", usernameFlw);
                    cmd.Parameters.AddWithValue("@UserStatus", "TRUE");
                    cmd.Parameters.AddWithValue("@Count", 1);
                    // cmd.Parameters.AddWithValue("@Status", status);
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                }


            else
            {
                using (SqlCommand cmd = new SqlCommand("DELETE FROM FStatus WHERE FriendUserName=@FriendUserName", con))
                {
                    cmd.Parameters.AddWithValue("@FriendUserName", usernameFlw);
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                }

            }

            this.Populatebooks();
        }
    }
    protected void Getresult_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            //  string bookid = (e.Item.FindControl("lblId") as Label).Text;
            //   string Name = (e.Item.FindControl("lblname") as Label).Text;
            string usernameflw = (e.Item.FindControl("lblusename") as Label).Text;
            // string fUserName = (e.Item.FindControl("lblfriendusername") as Label).Text;
            //   string userStatus = (e.Item.FindControl("lblUserStatus") as Label).Text;
            // string bookid = (e.Item.FindControl("lblId") as Label).Text;
            using (SqlConnection con = new SqlConnection(constring))
            {
                using (SqlCommand cmd = new SqlCommand("SELECT f.FriendUserName AS username,fav.Name,'Added' [Status] FROM FStatus f INNER JOIN User3 fav On f.UserName = fav.UserName WHERE fav.UserName=@FriendUserName", con))
                {
                    DataTable dt = new DataTable();
                    SqlDataAdapter sda = new SqlDataAdapter(cmd);
                    cmd.Parameters.AddWithValue("@UserName", Session["userName"]);
                    cmd.Parameters.AddWithValue("@FriendUserName", Session["userName"]);
                    sda.Fill(dt);

                    foreach (DataRow row in dt.Rows)
                    {
                        if (usernameflw == row["username"].ToString())
                        {
                            (e.Item.FindControl("btnRecom") as LinkButton).Text = "ADDED";
                            (e.Item.FindControl("UserName") as Label).Text = row["UserName"].ToString();
                            // (e.Item.FindControl("lblmark") as Label).Text = "";
                        }
                    }
                }
            }
        }
    }

Indresh

0 10

Reply
ANSWER
User: Indresh
Replied: on Jul 28, 2017 10:01 AM
Modified: on Jul 31, 2017 03:54 AM
Report

Hi micah,

I have created sample code which full-fill your requirement.So please refer the below code.

HTML

<form id="form1" runat="server">
<table border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td>
            Name:
        </td>
        <td>
            <asp:TextBox ID="txtName" runat="server" />
        </td>
    </tr>
    <tr>
        <td>
            Country:
        </td>
        <td>
            <asp:TextBox ID="txtcountry" runat="server" />
        </td>
    </tr>
    <tr>
        <td>
            <asp:Button ID="btnSubmit" Text="Submit" runat="server" />
        </td>
    </tr>
</table>
<br />
<div>
    <asp:DataList ID="dlGetresult" runat="server" RepeatColumns="3" RepeatDirection="Horizontal">
        <ItemTemplate>
            <table border="0" cellpadding="0" cellspacing="0">
                <tr>
                    <td>
                        CustomerId:<asp:Label ID="lblCustomerId" Text='<%#Eval("CustomerId")%>' runat="server" />
                    </td>
                </tr>
                <tr>
                    <td>
                        Name:<asp:Label ID="lblName" Text='<%#Eval("Name")%>' runat="server" />
                    </td>
                </tr>
                <tr>
                    <td>
                        Country:<asp:Label ID="lblCountry" Text='<%#Eval("Country")%>' runat="server" />
                    </td>
                </tr>
            </table>
        </ItemTemplate>
    </asp:DataList>
</div>
<div>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
    <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/json2/20130526/json2.min.js"></script>
    <script type="text/javascript">
        $(function () {
            $('[id*=btnSubmit]').click(function () {
                var obj = {};
                obj.name = $('[id*=txtName]').val();
                obj.country = $('[id*=txtcountry]').val();
                $.ajax({
                    type: "POST",
                    url: "Default.aspx/SaveRecord",
                    data: JSON.stringify(obj),
                    contentType: "application/json; charset=utf-8",
                    dataType: "json",
                    success: function (response) {

                    },
                    failure: function (response) {
                    },
                    error: function (response) {

                    }
                });

            });
        });
    </script>
</div>
</form>

private string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
    this.GetData();
}

private void GetData()
{
    SqlConnection con = new SqlConnection(constr);
    SqlCommand cmd = new SqlCommand("Select * from Customers", con);
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    sda.Fill(dt);
    dlGetresult.DataSource = dt;
    dlGetresult.DataBind();
}

[System.Web.Services.WebMethod]
public static void SaveRecord(string name, string country)
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    SqlConnection con = new SqlConnection(constr);
    SqlCommand cmd = new SqlCommand("Insert into Customers Values('" + name + "','" + country + "')", con);
    con.Open();
    cmd.ExecuteNonQuery();
    con.Close();
}

Vb.Net

Private constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Protected Sub Page_Load(sender As Object, e As EventArgs)
	Me.GetData()
End Sub

Private Sub GetData()
	Dim con As New SqlConnection(constr)
	Dim cmd As New SqlCommand("Select * from Customers", con)
	Dim sda As New SqlDataAdapter(cmd)
	Dim dt As New DataTable()
	sda.Fill(dt)
	dlGetresult.DataSource = dt
	dlGetresult.DataBind()
End Sub

<System.Web.Services.WebMethod> _
Public Shared Sub SaveRecord(name As String, country As String)
	Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
	Dim con As New SqlConnection(constr)
	Dim cmd As New SqlCommand((Convert.ToString((Convert.ToString("Insert into Customers Values('") & name) + "','") & country) + "')", con)
	con.Open()
	cmd.ExecuteNonQuery()
	con.Close()
End Sub

Screenshot

Refresh DataList after adding new record on Button click using jQuery Ajax in ASP.Net

Company

Explore

Follow us

Contact Us