I am using asp.net 2.0 and sqlserver experess 2005.
ihad created a data base and a table in it.
i want to show its record in gridview on clicking a button.
i had write this code in my aspx.cs file


using System.Data.SqlClient;


public partial class data : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection("Server=localhost;Database=vinod;uid =sa;pwd=papa;");

    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {

        string s = "select * from emp";
        SqlDataAdapter adp = new SqlDataAdapter(s, con);
        DataSet ds = new DataSet();
        adp.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
}


when i build this page it succeeded but when i run this page and click the button to show the data in gridview it shows error in my aspx.cs fil.


PLZ help me to solve this problem

hi
in this u didn't take the sqlcommand .
u put the below code and check

        string s = "select * from emp";
        SqlCommand cmd = new SqlCommand(s,con);
        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        adp.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();

gudluck
Kiranmai

Archu

Thanks for reply,
but it has the same error as it was giving earlier,

and the error is

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

 on line adp.fill(ds);

Sry
Even i'm also getting the same error in one of my application
if u get the solution then plz forward it to me also
thank u in advance
Kiranami

Archu

Check your connectionstring. It may be incorrect.
Try this connectionstring:
SqlConnection con = new SqlConnection("Server=localhost;Database=vinod;uid =sa;pwd=;");
                   Or,
SqlConnection con = new SqlConnection("Server=FullDatabaseName;Database=vi nod;uid=sa;pwd=papa;");

Gaurav
   

Thanks Gaurav,

but i solved this problem using
SqlConnection con = new SqlConnection("server=localhost;database=vinod;Integrated Security=True");
 and set sql server on windows authentication mode.