Retrieve Data from SQL Server and Dispaly using Jquery in Asp.net

Take the look at this:




In the previous example we saw, How to insert data in database using jquery in asp.net? now we will see how to display data in jquery in asp.net. Here we will use html page and a aspx.cs file.
First Step:
CreateTable with column name "Name" and "Email"
Second Step:
 Create a new project
Third Step:
Add a html file in your project.
Fourth Step:
Create input textbox and a button with id "Button1".
Fifth Step:
Add the following code in the aspx.cs file


[WebMethod]

    public static string InsertMethod(string Name)
    {
        string shashi = "";
         StringBuilder sb = new StringBuilder();
        SqlConnection con = new SqlConnection("Data Source=PREETI-PC;Initial Catalog=Record;Integrated Security=True");

        {

            SqlCommand cmd = new SqlCommand("select * from Test where Name='"+Name+"'", con);

            {

                con.Open();
                cmd.ExecuteNonQuery();
                SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    sb.Append(dr["Name"].ToString()+"</br>");
                    sb.Append(dr["Email"].ToString());
                }
                shashi = sb.ToString();
                return shashi;

            }

        }

    }
Sixth Step: 

<link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/themes/base/jquery-ui.css"


        rel="stylesheet" type="text/css" />

    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>

    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {

            $('#Button1').click(function () {

                $.ajax({

                    type: 'POST',

                    contentType: "application/json; charset=utf-8",

                    url: 'Default.aspx/InsertMethod',

                    data: "{'Name':'" + document.getElementById('Text1').value + "' }",
                  
                    async: false,

                    success: function (data) {

                      

                        //                        $('#Text6').val('');
                        //                        $('#Text1').val('');
                        //                        $('#Text2').val('');
                                                document.getElementById('message').innerHTML = data.d ;

                    },

                    error: function ()

                    { alert("error"); }

                });

            });

        });     
  
    </script>
  your process is okay.
Now here in code behind we have added string builder object and append our data according to our requirement you can also append it in the form of table. Return the sting "shashi" which contain string builder object in string formate.
This video is not exactly same as written but this may also help you.


Location: New Delhi, Delhi, India

Comments

Post a Comment

Popular posts from this blog

DTS package conversion in SSIS to use in SQL 2012 and SQL 2016

Image
In my company my team decided to migrate whole SQL 2008 to brand new SQL 2016 in Azure VMs. This was a good idea as we should always be up to date in terms of technology. We did migration all SQL 2008 to SQL 2016 without any problem but suddenly we saw we need to migrate warehouse as well and it was containing very complex DTS package almost 50 in number and we have very less time to finish this task. We first decided to do following things: Upgrade DTS in SSIS with wizard available in SQL 2008 But this was not helpful because if you have some VB script written in DTS and it enables or disables any step then it will not work in SSIS because enabling and disabling is not allowed in SSIS. YOu will have to manually correct all these code. So we tried this and dropped this idea. Manually Convert whole DTS in SSIS: This was blunder for us as it was going to take many months of re creation and testing so tried this and dropped this idea as well because we got a very motivati
Read more

Infinite Scroll in Asp.Net C# using Javascript without Third party Plugin

Image
Infinite Scroll is very common today in website as we all see in facebook , google + , LinkedIn and many other sites, as we scroll down data from server automatically appears in our browser without clicking any button. How We will do it?  We first create a database and then after that we will apply a jquery that will execute when our scroll bar reaches bottom of the page. For demo I will fetch YouTube video link from local server and bind that in iframe when scrolled down..  Here I will define a variable or you can say in other word a counter that will increase according to our requirement when scroll down. and that value will pass to the server so that server can send data when scrolled down. Here in my example I am increasing counter by one and initial value is 14 since my table ID started from 14 (you know when you delete some data this happen when it is PK) How to pass data from a page to server using jquery ? Follow these Steps: 1. Create a new proje
Read more

Add Custom Tags in Web config file in ASP .Net

Image
For any reason we want to add some custom tags in web config file but unfortunately these is some predefined tag available for web.config file. To do so we need to create XML file in the format that suits IIS. You can take example of any config present in C:\Windows\system32\inetsrv\config\schema Now create any custom tags and create file and save in the same directory. Now but this is not enough you need to add in applicationhost file as well at C:\Windows\system32\inetsrv\config This will solve your problem and you will be able to add custom config tag in web config file in ASP.Net website.
Read more