Show value of an other grid row by the selection of the first grid row

Question

0.00/5 (No votes)

See more:

I have a grid view for which i am using only one column and now what is the problem when i am trying to select into first grid view the respectively result is not showing in the second one which is also grid view plz tell me

Here's the code:

C#

[WebMethod]
      public   List<properties> GetStates()
        {
            SqlConnection oSqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
            SqlCommand oSqlCommand = new SqlCommand("select * from States", oSqlConnection);
            oSqlCommand.CommandType = CommandType.Text;
            oSqlConnection.Open();
            List<properties> oListproperties = new List<properties>();
            using (SqlDataReader OReader = oSqlCommand.ExecuteReader())
            {
                while (OReader.Read())
                {
                    properties Oproperties = new properties();
                    Oproperties.Id = Convert.ToInt32(OReader["State_ID"].ToString());
                    Oproperties.State = OReader["State"].ToString();
                    oListproperties.Add(Oproperties);
                }

            }
            return oListproperties;

        }
        [WebMethod]
      public List<properties> GetCity(int ID)
      {

          //properties Oproperties1 = new properties();
          //Oproperties1.Id = StateID;
            
            SqlConnection oSqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
      SqlCommand oSqlCommand = new SqlCommand("select * from City  where State_ID ="+ID , oSqlConnection);
            oSqlCommand.CommandType = CommandType.Text;
            oSqlConnection.Open();
          List<properties>  oListproperties=new List<properties>();
          using(SqlDataReader OReader = oSqlCommand.ExecuteReader())
          {while(OReader.Read())
          
          {properties Oproperties=new properties();
              Oproperties.Id=Convert.ToInt32(OReader["ID"].ToString());
             Oproperties.City=OReader["City"].ToString();
              oListproperties.Add(Oproperties);
          }
          return oListproperties;
          }
      
      }

Posted 25-Jul-13 2:23am

Abhimanyu vij

Updated 25-Jul-13 19:59pm

berrymaria

v4

Add a Solution

Comments

vinay.tatipamula 25-Jul-13 8:35am

Please eloborate your question? it is not clear. or show some code?

Abhimanyu vij 26-Jul-13 1:01am

[WebMethod]
public List<properties> GetStates()
{
SqlConnection oSqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
SqlCommand oSqlCommand = new SqlCommand("select * from States", oSqlConnection);
oSqlCommand.CommandType = CommandType.Text;
oSqlConnection.Open();
List<properties> oListproperties = new List<properties>();
using (SqlDataReader OReader = oSqlCommand.ExecuteReader())
{
while (OReader.Read())
{
properties Oproperties = new properties();
Oproperties.Id = Convert.ToInt32(OReader["State_ID"].ToString());
Oproperties.State = OReader["State"].ToString();
oListproperties.Add(Oproperties);
}

}
return oListproperties;

}
[WebMethod]
public List<properties> GetCity(int ID)
{

//properties Oproperties1 = new properties();
//Oproperties1.Id = StateID;

SqlConnection oSqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
SqlCommand oSqlCommand = new SqlCommand("select * from City where State_ID ="+ID , oSqlConnection);
oSqlCommand.CommandType = CommandType.Text;
oSqlConnection.Open();
List<properties> oListproperties=new List<properties>();
using(SqlDataReader OReader = oSqlCommand.ExecuteReader())
{while(OReader.Read())

{properties Oproperties=new properties();
Oproperties.Id=Convert.ToInt32(OReader["ID"].ToString());
Oproperties.City=OReader["City"].ToString();
oListproperties.Add(Oproperties);
}
return oListproperties;
}

}

vinay.tatipamula 25-Jul-13 8:39am

I assumed you need Row_Command event on your First GridView where you can get the clicked row object, based on that you can fetch information what ever to bind the second GridView?

Ganesan Senthilvel 25-Jul-13 21:27pm

Share your code for the clarity

Abhimanyu vij 26-Jul-13 1:01am

[WebMethod]
public List<properties> GetStates()
{
SqlConnection oSqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
SqlCommand oSqlCommand = new SqlCommand("select * from States", oSqlConnection);
oSqlCommand.CommandType = CommandType.Text;
oSqlConnection.Open();
List<properties> oListproperties = new List<properties>();
using (SqlDataReader OReader = oSqlCommand.ExecuteReader())
{
while (OReader.Read())
{
properties Oproperties = new properties();
Oproperties.Id = Convert.ToInt32(OReader["State_ID"].ToString());
Oproperties.State = OReader["State"].ToString();
oListproperties.Add(Oproperties);
}

}
return oListproperties;

}
[WebMethod]
public List<properties> GetCity(int ID)
{

//properties Oproperties1 = new properties();
//Oproperties1.Id = StateID;

SqlConnection oSqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
SqlCommand oSqlCommand = new SqlCommand("select * from City where State_ID ="+ID , oSqlConnection);
oSqlCommand.CommandType = CommandType.Text;
oSqlConnection.Open();
List<properties> oListproperties=new List<properties>();
using(SqlDataReader OReader = oSqlCommand.ExecuteReader())
{while(OReader.Read())

{properties Oproperties=new properties();
Oproperties.Id=Convert.ToInt32(OReader["ID"].ToString());
Oproperties.City=OReader["City"].ToString();
oListproperties.Add(Oproperties);
}
return oListproperties;
}

}

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Chui PuiKwan · Answer 1 · 2013-07-25T17:10:00

as follows :

C#

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            using (SqlConnection connection = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=Northwind"))
            {
 
                SqlDataAdapter dataAdpater = new SqlDataAdapter("SELECT CategoryID, CategoryName,Description FROM Categories", connection);                
 
                DataSet dataSet = new DataSet();
                dataAdpater.Fill(dataSet, "Categories");
 
                if (dataSet.Tables.Contains("Categories"))
                {
                    gvMain.DataSource = dataSet.Tables["Categories"].DefaultView;
                    gvMain.DataKeyNames = new string[] { "CategoryID" };
                    gvMain.DataBind();
                }                
 
            }
        }
    }
     
    protected void gvMain_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {        
 
        using (SqlConnection connection = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=Northwind"))
        {
 
            SqlDataAdapter dataAdpater = new SqlDataAdapter("SELECT * FROM Products where CategoryID=@CategoryID ", connection);
 
            dataAdpater.SelectCommand.Parameters.Add(new SqlParameter("@CategoryID", gvMain.DataKeys[e.NewSelectedIndex].Value));
 
            DataSet dataSet = new DataSet();
            dataAdpater.Fill(dataSet, "Products");
 
            if (dataSet.Tables.Contains("Products"))
            {
                gv.DataSource = dataSet.Tables["Products"].DefaultView;                
                gv.DataBind();
            }
 
        }
    }