Databases
StackOverflow2013
Postsdbo
PORedirect to another page based on a double-click of a row in a jQGrid.( Asp.Net C# )
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORedirect to another page based on a double-click of a row in a jQGrid.( Asp.Net C# )
    text
    copied!<p>In a <code>jQGrid</code>, when I double-click a row, I want to open another page that shows more data regarding the selected row. A query would need to be constructed based on the selected row and passed to that page. My <code>jQGrid</code> is dynamically created based on who logs in. I am a software student and I don't know what to do. I've searched online but have got nowhere. Please can you help. If you need more info, please let me know. </p> <pre><code>&lt;trirand:JQGrid ID="JQGrid1" runat="server" Width="760px" onsearching="JQGrid1_Searching" &gt; &lt;Columns&gt; &lt;/Columns&gt; &lt;PagerSettings ScrollBarPaging="true" PageSize="100" NoRowsMessage="Scroll to bottom to retrieve new page" /&gt; &lt;AppearanceSettings HighlightRowsOnHover="true" /&gt; &lt;ToolBarSettings ShowAddButton="true" ShowSearchToolBar="true" ShowRefreshButton="true" /&gt; &lt;AddDialogSettings ReloadAfterSubmit="true" Caption="Add a new row" SubmitText="Add the row" Resizable="false" /&gt; &lt;/trirand:JQGrid&gt; </code></pre> <p>Functions:</p> <pre><code>public static DataTable GetAnimalsByClient(Client cli) { DataTable dt = new DataTable(); try { MySqlConnection connection = Database.Connect(); string sql = string.Format("select a.animal_official_tag as AnimalOfficialTag, DATE_FORMAT(a.animal_date_of_birth,'%d/%m/%Y') AS DateOfBirth, a.animal_gender as AnimalGender, a.animal_breed as AnimalBreed, a.animal_jumbo as AnimalJumbo from animal a inner join herd_animal ha on a.animal_id = ha.animal_id join herd h on ha.herd_id = h.herd_id join client c on h.client_id = c.client_id where c.client_id = {0}", cli.ID); MySqlDataAdapter adapter = new MySqlDataAdapter(sql, connection); adapter.Fill(dt); adapter.Dispose(); Database.Disconnect(connection); } catch (Exception exp) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); Error.SaveError(methodBase.Name, exp.Message); } return dt; } public DataTable GetCurrentStock() { try { DataTable dt = (DataTable)AnimalDao.GetAnimalsByClient(UserSession.GetClient()); List&lt;DataColumn&gt; lstCol = new List&lt;DataColumn&gt;(); foreach (DataColumn col in dt.Columns) { lstCol.Add(col); } for (int i = 0; i &lt; dt.Columns.Count; i++) { JQGridColumn col = new JQGridColumn(); col.DataField = lstCol[i].ColumnName; col.HeaderText = lstCol[i].ColumnName; col.Width = lstCol[i].ColumnName.Length; col.Visible = true; col.Editable = true; JQGrid1.Columns.Add(col); } return dt; } catch (Exception exp) { return null; } } protected void Page_Load(object sender, EventArgs e) { if (!UserSession.LoggedIn()) { Response.Redirect("Default.aspx"); } RefreshGrid(); JQGrid1.DataSource = GetCurrentStock(); JQGrid1.DataBind(); } </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload