showing data in 2nd gridview on select arow from 1st grid

Hi shilpi...

plz try the following code:

                 CellSpacing="0" Width="100%" ShowHeader="False" AutoGenerateColumns="False" Height="100%">
               
                   
                       
                           
                           
                                                            AllowPaging="false" DataSource='<%#Getdatasource(Container.DataItem)%>' ShowHeader="False"
                                Width="100%" ShowFooter="False">
                               
                                   
                                   
                                       
                                       
                                                                                            CommandArgument='<%# DataBinder.Eval(Container.DataItem, "SubCategoryId") %>'
                                                OnCommand="LinkButtonPostName_Command" />
                                       
                                   
                               
                           
                       
                   
               
           

Now bind the first grid as follows:

protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("Data Source = SQLSERVER2005; Initial Catalog = Personal; User ID = sa; Password = wintellect;");
        SqlDataAdapter da = new SqlDataAdapter("select * from Category", con);
        con.Open();
        DataSet ds = new DataSet();
        da.Fill(ds);
        GridViewCategory.DataSource = ds;
        GridViewCategory.DataBind();
        con.Close();
    }

Write the following method for second grid:

 public DataSet Getdatasource(object objDRView)
    {
        if (!object.Equals(objDRView, null))
        {
            DataRowView dRView = (DataRowView)objDRView;
            int CategoryId = int.Parse(dRView["CategoryId"].ToString());
            SqlConnection con = new SqlConnection("Data Source = SQLSERVER2005; Initial Catalog = Personal; User ID = sa; Password = wintellect;");
            string cmd = "select * from SubCategory where CategoryId=" + CategoryId;
            SqlDataAdapter da = new SqlDataAdapter(cmd, con);
            con.Open();
            DataSet ds = new DataSet();
            da.Fill(ds);
            con.Close();
            return ds;
        }
        else
        {
            return null;
        }
    }