how to retrive some fields of data from sqlserver in aspx page

Posted by 0194Ca071007 under ASP.NET on 4/9/2012 | Points: 10 | Views : 1726 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hello I hav some feilds such as
StudentName,Class,Subject ,Marks,Totalmarks,Percentage,and grade,
I am inserting the record using sql comand .it inserted successful .now i had a next aspx page where i have two textboxes one for studentName and another for Class when I click the show record button the inserted data shouls hav to so the record according to the name of particular student and class ,,

please help me out sir what to do to perform that task

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Mani5155 on: 4/9/2012 [Member] Starter | Points: 25

what is the primary key of that table to get specific student?

</p><span class="dateClassForHome"><i>0194Ca071007</i>, if this helps please <a href="/login.aspx?ReturnUrl=%2fforums%2fshow%2f9009%2fhow-to-retrive-some-fields-of-data-from-sqlserver-in-aspx-page">login</a> to <b>Mark As Answer</b>. | </span><a rel="nofollow" class="dateClassForHome" href="/feedback.aspx?forumid=9009&rid=23802&writeurl=yes" title="Require moderation? alert moderator.">Alert Moderator</a></div><br /> </td> </tr> </table></div> </div> </div> <div class="panel panel-default"> <div class="panel-heading" style="padding-top:5px;"> Posted by: <a href="/profile/rajni.shekhar.aspx">Rajni.Shekhar</a> <span class="dateClassForHome"> on: 4/9/2012 <span style="color:black;"> [Member] </span> <a href="/misc/page14.aspx"><span style="color:#CD7F32;">Bronze</span></a> | <span class="highlight">Points: 25</span> </span></div> <div class="panel-body spaceKiller"><div class="table-responsive"> <table style="width:100%;"> <tr> <th style="vertical-align:top;text-align:center;padding:5px;"><br /> <img src="/images/voteup.gif" alt="Up" title="Vote up this response" class="voteUD" data-v="1" data-rid="23809" /> <br /><span id="vote23809">0</span><br /> <img src="/images/votedown.gif" alt="Down" title="Vote down this response" class="voteUD" data-v="0" data-rid="23809" /> </th> <td> <div class="spacer">selet * from tablename where studentname='"+txtname.text+"' and class='"+txtclass.text+"'<br /><br /><p class="authorInfo">Thanks, <br />Rajni Shekhar</p><span class="dateClassForHome"><i>0194Ca071007</i>, if this helps please <a href="/login.aspx?ReturnUrl=%2fforums%2fshow%2f9009%2fhow-to-retrive-some-fields-of-data-from-sqlserver-in-aspx-page">login</a> to <b>Mark As Answer</b>. | </span><a rel="nofollow" class="dateClassForHome" href="/feedback.aspx?forumid=9009&rid=23809&writeurl=yes" title="Require moderation? alert moderator.">Alert Moderator</a></div><br /> </td> </tr> </table></div> </div> </div> <div class="panel panel-default"> <div class="panel-heading" style="padding-top:5px;"> Posted by: <a href="/profile/naraayanan.aspx">Naraayanan</a> <span class="dateClassForHome"> on: 4/10/2012 <span style="color:black;"> [Member] </span> <a href="/misc/page14.aspx"><span style="color:#000000;">Starter</span></a> | <span class="highlight">Points: 25</span> </span></div> <div class="panel-body spaceKiller"><div class="table-responsive"> <table style="width:100%;"> <tr> <th style="vertical-align:top;text-align:center;padding:5px;"><br /> <img src="/images/voteup.gif" alt="Up" title="Vote up this response" class="voteUD" data-v="1" data-rid="23895" /> <br /><span id="vote23895">0</span><br /> <img src="/images/votedown.gif" alt="Down" title="Vote down this response" class="voteUD" data-v="0" data-rid="23895" /> </th> <td> <div class="spacer">Hi, <br /> <br /><pre class="prettyprint"> Select Subject ,Marks,Totalmarks,Percentage,grade from tablename where studentName = '"+txtStudetName.Text + "' and class= '"+txtclassName.Text + "' </pre> <br /> <br /><strong>Small suggestion:</strong> <br /> I gave a query for your requirement.But table structure is not a good one. Because No Primary Key in your table.Primary key is not accepted duplicate values. I think, No primary key in your table.So Please change your table structure like this <br /><pre class="prettyprint">StudentID,StudentName,class,marks,Totalmarks,Percentage,grade from tblname.</pre> <br /><br /><p class="authorInfo">Regards, <br />Lakshmi Naraayanan.S <br />http://dotnettechrocks.blogspot.in/ <br />http://abaprocker.blogspot.com/</p><span class="dateClassForHome"><i>0194Ca071007</i>, if this helps please <a href="/login.aspx?ReturnUrl=%2fforums%2fshow%2f9009%2fhow-to-retrive-some-fields-of-data-from-sqlserver-in-aspx-page">login</a> to <b>Mark As Answer</b>. | </span><a rel="nofollow" class="dateClassForHome" href="/feedback.aspx?forumid=9009&rid=23895&writeurl=yes" title="Require moderation? alert moderator.">Alert Moderator</a></div><br /> </td> </tr> </table></div> </div> </div> </div> <p id="MainContent_ResponseForm1_loginP" class="spacer"> <a class="PostResponseB" href="/login.aspx?ReturnUrl=https://dotnetfunda.com/forums/show/9009/how-to-retrive-some-fields-of-data-from-sqlserver-in-aspx-page" title="Login" name="reply">Login to post response</a> </p> <script type="text/javascript"> var dnlr = true; function IsBrowserIE() { if (navigator.userAgent.search(".NET") > 0 || navigator.userAgent.search("MSIE") > 0) { return true; } else { return false; } } if (IsBrowserIE()) { $("#CommentBoxDiv").empty(); $("#CommentBoxDiv").html('<p><a href="/forums/postanswer.aspx?qid=9009" title="Click here to reply">Click here to reply</a></p>'); } $(document).ajaxStart(function() { $('#divWait').show(); $("#btnResPost").prop('disabled', true); }).ajaxStop(function() { $('#divWait').hide(); $("#btnResPost").prop('disabled', false); }); $("#btnResPost").click(function () { dnlr = false; if ($('#txtResponse').val().trim().length == 0) { alert("Please write your response."); $('#txtResponse').focus(); return; } $("#divMessage").html(""); // submit response $.post("/submit/processresponser.aspx", { Flag: "0194Ca071007", tResponse: $("#txtResponse").val(), ResponseForId : 9009, SectionId : 3, Title : "how to retrive some fields of data from sqlserver in aspx page", AuthorUserName : "0194Ca071007" }, function (data) { $("#divMessage").html(data); }); $("#txtResponse").val(''); BindResponses(9009, 3, "0194Ca071007"); // make the preview empty $("#txtResponsePreview").html(''); }); function BindResponses(responseId, SectionId, flag) { $('#alertMessage').html(''); // bind response $.post("/submit/processresponser.aspx", { ResponseForId : responseId, SectionId : SectionId, Flag : flag, CurrentUrl : "%2fforums%2fshow%2f9009%2fhow-to-retrive-some-fields-of-data-from-sqlserver-in-aspx-page", Title : "how to retrive some fields of data from sqlserver in aspx page", AuthorUserName : "0194Ca071007" }, function (data) { $("#divResponse").html(data); }); } $(document).ready(function () { if (!dnlr) { BindResponses(9009, 3, "0194Ca071007"); } else { $('#divWait').hide(); $("#btnResPost").prop('disabled', false); } }); </script> <div class="spacer"> <strong>Latest Posts</strong> <ul class="morePost"> <li><a href="/forums/show/24160/how-to-get-the-exact-property-name-while-getting-error" title="How to get the exact property name while getting error">How to get the exact property name while getting error</a>  (0)</li> <li><a href="/forums/show/24159/pdb-file-is-not-showing-line-number-in-dot-net-application-hosted-on-s" title="PDB file is not showing Line Number in dot net application hosted on server">PDB file is not showing Line Number in dot net application hosted on server</a>  (0)</li> <li><a href="/forums/show/24158/both-strings-morethan-5-letters-in-length-end-of-the-words-one-vowel-a" title="Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different">Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different</a>  (0)</li> <li><a href="/forums/show/24157/how-to-check-any-adjacent-letters-transposed-between-two-stringsex-joh" title="how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON)">how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON)</a>  (1)</li> <li><a href="/forums/show/24155/can39t-receive-data-after-success-login" title="can't receive data after success login ?">can't receive data after success login ?</a>  (1)</li> <li><a href="/forums/show/24154/implement-multi-tenant-in-azure-logic-apps" title="Implement Multi-Tenant in Azure Logic Apps">Implement Multi-Tenant in Azure Logic Apps</a>  (0)</li> <li><a href="/forums/show/24153/why-aspnet-core-70-web-api-showing-as-connection-refused" title="Why ASP.Net Core 7.0 Web API showing as Connection refused?">Why ASP.Net Core 7.0 Web API showing as Connection refused?</a>  (0)</li> <li><a href="/forums/show/24092/iterating-over-columns-of-dataframe-and-print-as-rows-in-python-django" title="Iterating over columns of dataframe and print as rows in Python Django">Iterating over columns of dataframe and print as rows in Python Django</a>  (0)</li> <li><a href="/forums/" title="More Forums Posts ...">More ...</a></li></ul> </div> </div> <link href="/Styles/prettify.css" rel="stylesheet" /> <script type="text/javascript" src="/Scripts/prettify.js"></script> <script type="text/javascript"> $(document).ready(function () { prettyPrint(); $(".voteUD").on('click', function () { var vote = $(this).attr("data-v"); var rid = $(this).attr("data-rid"); $.post("/submit/forumratingupdown.aspx", { rid: rid, vote: vote }, function (data) { if (!isNaN(data)) { $("#vote" + rid).html(data); // alert("Thanks for your vote !"); } else { alert(data); } }).error(function (data) { alert("ERROR: " + data.statusText); });; }); }) </script> </main> </div> </div> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 colSmallLeftSpaceKiller"> <aside> <div class="panel panel-info" style="margin-top:5px;"> <div class="panel-heading"><div class="panel-title">Winners</div></div> <div class="panel-body" style="padding-top:6px;padding-bottom:6px;"> <script type="text/javascript">  </script> <div class="text-center" id="pWinRot"><a href="javascript:Navigate();"><span id="lblWinner">Winners & Prizes</span><img id="WinnerImage" class="img-circle" src="/images/prizes.jpg" width="95" height="80" alt="Win Prizes" title="Win Prizes" style="padding-left:20px;" /></a></div> </div> </div> <div class="panel panel-info"> <div class="panel-heading"> <div class="panel-title">Ads</div> </div> <div class="panel-body text-center"> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-8227619787378220" crossorigin="anonymous"></script>  <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-8227619787378220" data-ad-slot="2167652528" data-ad-format="auto" data-full-width-responsive="true"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div> </div> <div class="panel panel-info"> <div class="panel-heading"> <div class="panel-title">Social</div> </div> <div class="panel-body"> <div style="margin-bottom:10px;font-weight:bold;" > <ul class="list-unstyled"> <li><a href="http://www.youtube.com/dnfvideo" target="_blank"><img src="/images/3rd/social/youtube_32.png" alt="YouTube" class="border0" /> YouTube/DNFVideo</a></li> <li><a href="https://www.facebook.com/pages/DotNetFunda/150208065028141" target="_blank"><img src="/images/3rd/social/facebook_32.png" alt="Facebook" class="border0" /> Facebook/DotNetFunda</a></li> <li><a href="http://twitter.com/dotnetfunda" target="_blank"><img src="/images/3rd/social/twitter_32.png" alt="Twitter" class="border0" /> Twitter/DotNetFunda</a></li> <li><a href="http://www.linkedin.com/in/dotnetfunda" target="_blank"><img src="/images/3rd/social/linkedin_32.png" alt="LinkedIn" class="border0" /> LinkedIn/In/DotNetFunda</a></li> <li><a href="https://plus.google.com/110725672744452026072/" target="_blank"><img src="/images/3rd/social/google_32.png" alt="Google" class="border0" /> Plus.Google.Com</a></li> </ul> </div> <div id="divWinner"> <div class="center" style="padding-top:15px;"> Like us on Facebook <br /></div> <iframe src="//www.facebook.com/plugins/likebox.php?href=http%3A%2F%2Fwww.facebook.com%2Fpages%2FDotNetFunda%2F150208065028141&width=300&height=155&colorscheme=light&show_faces=true&header=false&stream=false&show_border=false&appId=132242113523484" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:300px; height:155px;" allowTransparency="true">

Top Forums Authors

Thu, 02-Jul-2026 Authors

All Time Authors

7860

3455

3340

Latest members | More ...

(Statistics delayed by 5 minutes)