Error:
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0117: 'System.Data.SqlClient.SqlDataReader' does not contain a definition for 'read'

Code
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
String strConString = ConfigurationManager.ConnectionStrings["SocialSystemConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection();
con.ConnectionString = strConString;

//create Command
SqlCommand cmd = new SqlCommand("Select TextInput FROM Update", con);

// Open Connection
con.Open();

//Create Dataset to store query
SqlDataReader reader = cmd.ExecuteReader();

//Read and display data
while (reader.read())
{
lblResult.Text += Reader("TextInput").ToString();
}

//Close Reader
reader.Close();
con.Close();

}
}

Wat is the problem..

hi there...

maybe, reader.Read() ?

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

hey

hmm. i change to Read but it appears..

Compiler Error Message: CS0103: The name 'Reader' does not exist in the current context

The error is very explicit. You know that C# is case sensitive, don't you?

copy this exact text: reader("TextInput").ToString()

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

I am actually new to c#. Was doing vb all along. I got it.
But however,
it appears another error after i oversee the case.

Compiler Error Message: CS0118: 'reader' is a 'variable' but is used like a 'method'

it is solved. I changed the "(" to "["
Thanks anyway.

But another error occured.. sigh
Incorrect syntax near the keyword 'Update'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'Update'.

Hi Julius
Update is an sql server keyword. To stop this exact error, it is recommended not to use keywords for the names of tables etc. It is however possible to use them by putting [] round it (this is why if you script tables in SQL Management Studio it always surrounds the names of objects in []).
So your sql statement will look like
Hope this helps
Phil

Yeah. Thanks alot. :D

But however, i encounter anyproblem.. when i Inner join 2 tables together.

It shows the error below:
Incorrect syntax near 'User'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'User'.

protectedvoid Button1_Click(object sender, EventArgs e)
{
String strConString = ConfigurationManager.ConnectionStrings["SocialSystemConnectionString"].ConnectionString;
SqlConnection con = newSqlConnection();
con.ConnectionString = strConString;
//create Command
SqlCommand cmd = newSqlCommand("SELECT [Update].Email, [Update].TextInput, [User].FullName FROM [Update] INNERJOIN [User] ON [Update].Email = [User].Email", con);
// Open Connection
con.Open();
//Execute Command
SqlDataReader reader = cmd.ExecuteReader();
//Read and display data
while (reader.Read())
{
lblResult.Text += reader["FullName"].ToString() + " receive a new comment" + "<br/>" + reader["TextInput"].ToString() + "<br/>";
}
//Close Reader
reader.Close();
con.Close();
lblResult.Visible = true;
}

Why is this so?

It looks like you have put innerjoin as one word, it should be 2: INNER JOIN

thanks pal !