Abou Ado.net

Question

 using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;


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

    }
    
    protected void btnadminmlogin_Click1(object sender, EventArgs e)
    {
        string constring = ConfigurationManager.ConnectionStrings["conn"].ToString();
        SqlCommand cmd = new SqlCommand();
        SqlConnection conn = new SqlConnection(constring);
        cmd.Connection = conn;
        conn.Open();
        cmd.CommandText = "spadmin2";
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("name", txtnameadmin.Text);
        cmd.Parameters.AddWithValue("password", txtpwdadmin.Text);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
       
        da.Fill(ds);
     
        if (ds != null && ds.Tables.Count > 0)
        {
            string status = ds.Tables[0].Rows[0][0].ToString();
            if (status == "yes")
            {
                Session["name"]          = ds.Tables[1].Rows[0]["name"].ToString();
                Session["password"]      = ds.Tables[1].Rows[0]["password"].ToString();
                Response.Redirect("adminhome.aspx");
            }
            else
            {
                lblmsg.Text = "ivalid credentials";

            }
        }
   

this is my .CS code

and my Db is


create table admin
(
name varchar(50),
password varchar(50),
)

select * from admin

insert into admin (name,password)values('varun','varun123')



create proc spadmin2
(
@name varchar(50),
@password varchar(50)
 
)
as
begin
if exists (select * from admin where name=@name and password=@password )
begin
select 'yes' as status
end
else
begin

select 'no' as status
end
end


and my error is in this line...it says " Cannot find table 1."


Session["name"]          = ds.Tables[1].Rows[0]["name"].ToString();



can any one help me out

Thanks & Regards