IN OBOUT grid, how to move from first grid to another grid by clicking a row in first grid

IN OBOUT grid, how to move from first grid to another grid by clicking a

row in first grid



Im using OBOUT GRID

im getting data from database and displaying it in grid1 . now in client

side in the grid1 if they select any row ,i should get that id and search

it in database retrieve the data similar to that id and i should display

in grid2. how can i do it?.. please help me

Thanks in advance..

Here my javascript

function onSelect() {

for (var i = 0; i < Grid1.PageSelectedRecords.length; i++) {

var record = Grid1.PageSelectedRecords[i];

var text = document.getElementById("TextBox1");

text.value = record.order_id;

alert(PageMethods.second(record.order_id));

}

}

here my HTML

<asp:ScriptManager ID="ScriptManager1" EnablePageMethods="true"

EnablePartialRendering="true" runat="server" />

<cc1:Grid ID="Grid1" AllowRecordSelection="true"

AllowMultiRecordSelection="true" runat="server">

<ClientSideEvents OnClientSelect="onSelect" />

</cc1:Grid>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

here my code behind

[WebMethod]

public void second(int oid)

{

Response.Write(oid);

MySqlConnection con = new MySqlConnection("server=localhost;

database=db1; uid=root;");

con.Open();

MySqlCommand sel1cmd = new MySqlCommand("select

order_id,firstname,lastname from api where order_id=@oid", con);

sel1cmd.Parameters.AddWithValue("@oid", oid);

sel1cmd.ExecuteNonQuery();

MySqlDataAdapter da1 = new MySqlDataAdapter(sel1cmd);

DataSet ds1 = new DataSet();

da1.Fill(ds1);

DataTable dt1 = new DataTable();

da1.Fill(dt1);

Grid1.DataSource = ds1.Tables[0];

Grid1.DataBind();

}

Please help me