Home Assigning DefaultValue in ASP.NET for SelectParameters
Reply: 0

Assigning DefaultValue in ASP.NET for SelectParameters

user43266
1#
user43266 Published in September 19, 2018, 6:44 pm

I'm trying to assign default value to the user that are currently login, for them to view their profile.

Here is the datasource:

<asp:SqlDataSource ID="SqlDataProfile" runat="server" ConnectionString="<%$ ConnectionStrings:RegistrationConnectionString %>" SelectCommand="SELECT username, email, studIC, password, studGuardian, studPhone, studAddress, studClass, studName FROM RegStudents WHERE (username LIKE @username + '%')" UpdateCommand="UPDATE RegStudents SET username = @username, password = @password, studName = @studName, studClass = @studClass, studAddress = @studAddress, studPhone = @studPhone, studGuardian = @studGuardian, studIC = @studIC WHERE (username LIKE @username + '%')">
    <SelectParameters>
        <asp:Parameter Name="username" Type="String" DefaultValue="@username" />
    </SelectParameters>
    <UpdateParameters>
        <asp:Parameter Name="username" />
        <asp:Parameter Name="password" />
        <asp:Parameter Name="studName" />
        <asp:Parameter Name="studClass" />
        <asp:Parameter Name="studAddress" />
        <asp:Parameter Name="studPhone" />
        <asp:Parameter Name="studGuardian" />
        <asp:Parameter Name="studIC" />
    </UpdateParameters>
</asp:SqlDataSource>

Here is my code behind:

  public partial class ProfilePage : System.Web.UI.Page {

     protected void Page_Load(object sender, EventArgs e) { 
          SqlDataProfile.SelectParameters["username"].DefaultValue =User.Identity.Name; 
                }

When I set the default value into existing username as below, it totally works but doesn't work with the code above.

<asp:Parameter Name="username" Type="String" DefaultValue="amanda123" />
share|improve this question
  • You could delete the DefaultValue attribute from Parameter tag. <asp:Parameter Name="username" Type="String"> anyhow you are assigning this through codebehind. – Rojalin Sahoo Nov 14 '17 at 22:52
  • Thanks I did that, but still, it isn't working :\ – Bell H. Nov 14 '17 at 23:10

active oldest votes

Your Answer

StackExchange.ifUsing("editor", function () { StackExchange.using("externalEditor", function () { StackExchange.using("snippets", function () { StackExchange.snippets.init(); }); }); }, "code-snippets"); StackExchange.ready(function() { var channelOptions = { tags: "".split(" "), id: "1" }; initTagRenderer("".split(" "), "".split(" "), channelOptions); StackExchange.using("externalEditor", function() { // Have to fire editor after snippets, if snippets enabled if (StackExchange.settings.snippets.snippetsEnabled) { StackExchange.using("snippets", function() { createEditor(); }); } else { createEditor(); } }); function createEditor() { StackExchange.prepareEditor({ heartbeatType: 'answer', convertImagesToLinks: true, noModals: false, showLowRepImageUploadWarning: true, reputationToPostImages: 10, bindNavPrevention: true, postfix: "", onDemand: true, discardSelector: ".discard-answer" ,immediatelyShowMarkdownHelp:true }); } });
 
StackExchange.ready( function () { StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f47295859%2fassigning-defaultvalue-in-asp-net-for-selectparameters%23new-answer', 'question_page'); } );

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged c# asp.net .net visual-studio or ask your own question.

StackExchange.ready(function(){$.get('/posts/47295859/ivc/f131');});
StackExchange.ready(function () { StackExchange.responsiveness.addSwitcher(); }) (function(i, s, o, g, r, a, m) { i['GoogleAnalyticsObject'] = r; i[r] = i[r] || function() { (i[r].q = i[r].q || []).push(arguments) }, i[r].l = 1 * new Date(); a = s.createElement(o), m = s.getElementsByTagName(o)[0]; a.async = 1; a.src = g; m.parentNode.insertBefore(a, m); })(window, document, 'script', 'https://www.google-analytics.com/analytics.js', 'ga'); StackExchange.ready(function () { StackExchange.ga.init({ sendTitles: true, tracker: window.ga, trackingCodes: [ 'UA-108242619-1' ] }); StackExchange.ga.setDimension('dimension2', '|c#|asp.net|.net|visual-studio|'); StackExchange.ga.setDimension('dimension3', 'Questions/Show'); StackExchange.ga.trackPageView(); }); /**/ var _qevents = _qevents || [], _comscore = _comscore || []; (function() { var ssl = 'https:' == document.location.protocol, s = document.getElementsByTagName('script')[0], qc = document.createElement('script'); qc.async = true; qc.src = (ssl ? 'https://secure' : 'http://edge') + '.quantserve.com/quant.js'; s.parentNode.insertBefore(qc, s); _qevents.push({ qacct: "p-c1rF4kxgLUzNc" }); /**/ var sc = document.createElement('script'); sc.async = true; sc.src = (ssl ? 'https://sb' : 'http://b') + '.scorecardresearch.com/beacon.js'; s.parentNode.insertBefore(sc, s); _comscore.push({ c1: "2", c2: "17440561" }); })();
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.310653 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO