How to execute Sql Query on clicking link and display result in frame

Question

0.00/5 (No votes)

See more:

In my application,I want to execute Sql Query on clicking link and display result in frame of that page.The code written by me as follow.

AdminHomePage.aspx

HTML

<a href="#" önclick="show('PendingStudList.aspx?AdminId')">Student Request</a>

PendingStudList.aspx

ASP.NET

<iframe id="Iframe1" frameborder="1" runat="server" scrolling="yes" title="Student Pending List">
        <%
            string FirstName, EndYear;
            SqlConnection objsqlconnection = new SqlConnection();
            objsqlconnection.ConnectionString = ("Data Source=.\\SQLEXPRESS;AttachDbFilename=G:\\Ujwala\\Project\\Student Community\\Student_Community\\Student_Community\\App_Data\\Stud_Community.mdf;Integrated Security=True;User Instance=True");
            SqlCommand objsqlcommand = objsqlconnection.CreateCommand();
            objsqlconnection.Open();
            string SelectStudInfo = "SELECT tblStudent_Registration.FirstName,tblStudent_Registration.EndYear FROM tblRequestApprove INNER JOIN tblStudent_Registration ON tblRequestApprove.StudId = tblStudent_Registration.StudId WHERE(tblRequestApprove.AdminId = 7)";
            objsqlcommand = objsqlconnection.CreateCommand();
            objsqlcommand.CommandText = SelectStudInfo;
            SqlDataAdapter sqldataadapter = new SqlDataAdapter(objsqlcommand);
            DataTable datatable = new DataTable();
            sqldataadapter.Fill(datatable);
            int i = 0;
            foreach (DataRow row in datatable.Rows)
            {
                FirstName = datatable.Rows[i]["FirstName"].ToString();
                EndYear = datatable.Rows[i]["EndYear"].ToString();
                Response.Write(FirstName);
                Response.Write(EndYear);
                i++;
            }
            objsqlconnection.Close();%>
           </iframe>

Clicking on Student Request link I want to display result in frame.
Please help me.
Thank You.

Posted 13-Sep-11 22:37pm

Ujwala Gholap

Updated 13-Sep-11 22:44pm

Prerak Patel

v2

Add a Solution

Comments

Prerak Patel 14-Sep-11 4:44am

Added code block.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Muralikrishna8811 · Answer 1 · 2011-09-14T04:07:00

hi ,

I hope you know that we cannot show our data in iframes b'coz the main intend of iframe is to show another page output in same page.My suggestion is use DIV tag or
use another page like showresult.aspx

thn use that page into your iframe tag to display it like

HTML

<iframe id="frame1" runat ="server" src="showresult.aspx"  >

 </iframe>

finally the C# code for showing results in div is

C#

LocalDBDataClassesDataContext db = new LocalDBDataClassesDataContext();
        var g = from k in db.UserTabs
                where k.AdminID==7
                select k;
        StringBuilder sb = new StringBuilder("");
        foreach (var j in g)
        {
            sb.Append(" ID :  " + j.uname + "   ;   PWD  :    " + j.pwd + "<br />");
        }
        frame1.InnerHtml = sb.ToString();
        resdiv.InnerHtml = sb.ToString();

here I used Linq to retrieve data from database I hope you know linq.
If any doubts contact or rply.