Help Required For The Select Query :-(

Hi i'm developing a website for my final year project with ASP.net and SQL Server 2005 databse. The problem i'm facing since last week is that, i'm unable to use "Select" query to fetch the data from my SQL Server database.

 i've used the following code to INSERT the database which is successfull.SqlDataSource sample= new SqlDataSource();

sample.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ToString();sample.InsertCommandType = SqlDataSourceCommandType.Text;

sample.InsertCommand = "INSERT INTO Table_Name(Fields) VALUES (@Fields)";

sample.InsertParameters.Add("Fields", FieldsTxtBox.Text);

 

 int row = 0;

try

{

row = sample.Insert();

}catch (Exception ex)

{

// Response.Redirect ("Failed.aspx");

Label1.Text = ex.ToString();

}

finally

{sample= null;

}if (row != 0)

{Response.Redirect("Success.aspx");

}

else

{Response.Redirect("Failed.aspx");

}

 

 

It successfully updates my database fields. I've tried many codes that i've found over the internet but none worked. can anyone please tell me how to use SELECT query in the fashion as the above one?

I shall be very thankfull for the help.

Regards,

Jigzy