How to display data result from database in C#

Question

I am trying to make a website in C# and .accdb database using Visual Studio 2010 my .accdb database has username and score and I want to display the user that has credit more than 0 to the Default.aspx

So I created a button and a textbox.

<div>
<asp:Button ID="CreditSearch" runat="server" Text="Credit" onclick="btnCreditSearch_Click"  />
 </div>

and the function for btnCreditSearch_Click is:

protected void btnCreditSearch_Click(object sender, EventArgs e)
{
    CreditSearch();
}

private void CreditSearch()
{
    string users;
    users = Process.UserCreditSearch();
    string A = users.ToString();
    TextBox1.Text(A);
}

and my Process.UserCreditSearch() is:

   public static string UserCreditSearch()
{
    string query = "SELECT srusername FROM usertb WHERE credit > 0 ";
    return query;

}

but then it is not working. for the credit search function, it says "Non invocable member' System.UI.Webcontrol.TextBox.Text' can not be use like a method

I hope somebody knows what I done wrong and thanks

Nighil · Accepted Answer · 2011-05-15 08:10:11Z

1

.Text is a Property

TextBox1.Text= A;

answered May 15, 2011 at 8:10

Nighil

4,1277 gold badges34 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Hold_My_Anger Over a year ago

thanks now I changed to TextBox1.Text= A; but now the textbox displayed "SELECT srusername FROM usertb WHERE credit > 0 " but what I want is the users that has credits larger than 0 Is there any problem of the code that causing this?

Nighil Over a year ago

string query = "SELECT srusername FROM usertb WHERE credit > 0 "; //this is wrong because select statement return a table you are assigning it to a string and there must be a connection handling class

Nighil Over a year ago

@Ric: Where is your connection class?

marc_s Over a year ago

@Ric: what do you do if you get back multiple users with credit > 0 ??

Collectives™ on Stack Overflow

How to display data result from database in C#

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related