...

View Full Version : .Net Coding. (Changing the text)



hbk1984
09-04-2010, 07:40 AM
Hi all,

I was just wondering how can I code this way..

For example I had a button and a textbox and when I click on it... it will connect the database and change the label.text to the information I wan.. which is "either 1 or 0".

Like I have a few user name - "Tom, Dick and Harry"
I enter tom in the textbox and I hit the button. it will load the database and show on the label (Or anything you want).... how many books he rent. actually is either 1 or 0.


I can get it done by using the Gripview control... but I was thinking if there is anyway I can get it done without using it? how can I do a database connection and get information I want without using the gripview data?

ess
09-07-2010, 09:52 PM
as you didn't provide any code...I'll be making some assumptions here to show how you can get this done in asp.net using c#

Let's say you have a deafult.aspx page and it contains the following code within the form's tag



<asp:Label ID="Label1" runat="server" Text="Number of books will be shown here">
<br />
<asp:Button ID="btnShowBooks" runat="server" Text="Show Books" onclick="btnShowBooks_Click" />


Here is the code in the button's click event



protected void btnShowBooks_Click(object sender, EventArgs e)
{

/* get the connection string from the web.config file
if you haven't added one already, here's an example

<connectionStrings>
<add name="MyConnectionString"
connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|SiteDb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
</connectionStrings>

Please visit this site for connection string examples http://www.connectionstrings.com/

*/
string dbConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;

using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection())
{
connection.ConnectionString = dbConnectionString;
connection.Open();

System.Data.SqlClient.SqlCommand cmd = connection.CreateCommand();

// assuming you have a table in your db defined as
// CREATE TABLE [dbo].[Users] ( UserID INT IDENTITY(1,1), Name VARCHAR( 50 ), Books Bit )

cmd.CommandText = "SELECT [Books] FROM dbo.Users WHERE [UserId] = '1'";

System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();

if (reader.HasRows)
{
// as we only have one record in the db, we don't need a while
// loop to iterate over the the records in the reader object
reader.Read();

// assign the value read from the database to the label
Label1.Text = reader["Books"].ToString();

} //-- ends if


} //-- ends using
} //-- ends btnShowBooks_Click


Hope this helps

Cheers
~E

DustinHoffman10
09-17-2010, 03:19 PM
First you have to create tables for user id and user name. Now when you start to run the query fetch the username according to userid and store that result in particular variable then display the result on particular label.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum