Re: FromUri Method - API - ASP.NET Discussion Boards

Re: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall

kirthikirthi20-Nov-13 22:46

kirthikirthi

20-Nov-13 22:46

Thanks for the reply.

Kirthi

asp.net

Member 1026351919-Nov-13 21:14

Member 10263519

19-Nov-13 21:14

plz help me ..

how to develop asp.net web application, connecting to mysql database.

i searched the google for developing asp.net web application .but it's giving membership, profile,role provider.

what r those ,they r must.plz. help me.

Re: asp.net

Mycroft Holmes19-Nov-13 21:32

Mycroft Holmes

19-Nov-13 21:32

First off don't use txt speak in the forum it is frowned upon.

Secondly, there are 100's of tutorials out there some, probably most will lead you through getting user credentials to access the system. If you do not understand what they are then buy a book on software development or give up now.

Never underestimate the power of human stupidity
RAH

Re: asp.net

Richard MacCutchan19-Nov-13 21:55

Richard MacCutchan

19-Nov-13 21:55

Member 10263519 wrote:
i searched the google for developing asp.net web application

And you didn't find www.asp.net[^]?

Veni, vidi, abiit domum

FromUri Method - API

miss78619-Nov-13 0:38

miss786

19-Nov-13 0:38

Dear all,

I am trying to implement the following method below and I keep experiencing compiler error or "does not contain a definition for 'Where'".

I am already using the library "system.Linq" but I keep getting the same error.

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web;
using System.Web.Http;


namespace API_10Oct.Controllers
{
    public class ItemsController : ApiController
    {
        private TestEntities1 db = new TestEntities1();

        // GET api/Default1
        public IEnumerable<Intex> GetIntexes()
        {
            return db.Intexes.AsEnumerable();
        }

        public IEnumerable<Intex> Get([FromUri]Intex intex)
        {
            return Intex.Where(w => w.Contains(intex.Name));
                
        }
}
}

namespace API_10Oct
{
    using System;
    using System.Collections.Generic;
    
    public partial class Intex
    {
        public string ID { get; set; }
        public string Name { get; set; }
        public string Price { get; set; }
        public string Type { get; set; }
        public string UploadDate { get; set; }
    }
}

Any guidance or help would be very much appreciated.

Many thanks for your time and help.

Re: FromUri Method - API

Richard Deeming19-Nov-13 2:12

Richard Deeming

19-Nov-13 2:12

miss786 wrote:
return Intex.Where(w => w.Contains(intex.Name));

Intex is a Type, so you are trying to call a static method called Where on that type. Since there is no such method, you're getting a compiler error.

I suspect you meant to write something like:

return db.Intexes.Where(w => w.Contains(intex.Name)).AsEnumerable();

NB: This assumes that the Intext class contains an instance method called Contains which accepts a single string argument and returns a bool. If it doesn't, then you'll need to explain what you're trying to achieve with the filter.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: FromUri Method - API

miss7865-Dec-13 23:55

miss786

5-Dec-13 23:55

Hi Richard,

Thank you so much for your help. I am trying to create a query string URL using web API which client can use call certain parameters.

I am using the following method below to pass parameters into the query string but I can not get to filter correctly. If search by name=storm and price_type=talk, it produces results with all talk categories instead of filtering by name.storm + price_type.talk.

public HttpResponseMessage Get([FromUri] Query query)
      {
          var data = from c in db.database_BWICs
                     where c.Name == query.name ||
                    c.CUSIP == query.cusip ||
                    c.ISINs == query.isin ||
                     c.Cover == query.price_type
                     select c;
          if (data == null)
          {
              var message = string.Format("No database_WICs was found");
              return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
          }
          return Request.CreateResponse(HttpStatusCode.OK, data);
      }

api/data?name=STORM%202012-2%20A1&price_type=talk --> query string

Is there a way to create a filter using the Linq query, instead of using oData filters?

any help would be very much appreciated.

Re: FromUri Method - API

Richard Deeming6-Dec-13 1:33

Richard Deeming

6-Dec-13 1:33

miss786 wrote:
If search by name=storm and price_type=talk, it produces results with all talk categories instead of filtering by name.storm + price_type.talk.

That's because you're using || (OR) to combine your filters. If you only want to return data which matches all of the filters, then you need to use && (AND) to combine them.

However, based on your URL, it looks like the filters are optional, and you only want to match the filters which have been passed in. In that case, you'll need to check each filter individually, so a series of chained Where calls is probably the simplest option:

var data = db.database_BWICs.AsQueryable();

if (query.name != null)
{
    data = data.Where(c => c.Name == query.name);
}
if (query.cusip != null)
{
    data = data.Where(c => c.CUSIP == query.cusip);
}
if (query.isin != null)
{
    data = data.Where(c => c.ISINs == query.isin);
}
if (query.price_type != null)
{
    data = data.Where(c => c.Cover == query.price_type);
}

if (!data.Any()) // NB: data will never be null.
{
    var message = string.Format("No database_WICs was found");
    return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
}

return Request.CreateResponse(HttpStatusCode.OK, data);

You might need to change the filter tests, depending on the data types of the fields.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Suggest me a website in asp dotnet

Member 1041107418-Nov-13 23:15

Member 10411074

18-Nov-13 23:15

suggest me a website in asp dot net
Reply me on richasoni78@ymail.com

modified 19-Nov-13 5:22am.

Re: Suggest me a websit in asp dotnet

Chris Quinn18-Nov-13 23:22

Chris Quinn

18-Nov-13 23:22

I suggest this one[^]

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

Re: Suggest me a website in asp dotnet

Dineshshp18-Nov-13 23:39

Dineshshp

18-Nov-13 23:39

i think u r a begginer.

so i want to suggest to create only static site at your first phase.

you can create a site for JWELLERY shops...

DineshT

Re: Suggest me a website in asp dotnet

Chris Quinn19-Nov-13 0:42

Chris Quinn

19-Nov-13 0:42

If you post a question here (what you posted is not a question), you should expect to see the replies in the thread, not by email! This is a collaborative site, not a personal service.

Posting your email like this is a sure way of attracting huge amounts of spam - I hope you are in need of Viagra and gambling sites!

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

Re: Suggest me a website in asp dotnet

thatraja19-Nov-13 1:09

thatraja

19-Nov-13 1:09

Here more than couple of ways.....
Education Needed[^]

thatraja

Code converters | Education Needed | Plans

Re: Suggest me a website in asp dotnet

Abhinav S19-Nov-13 16:56

Abhinav S

19-Nov-13 16:56

Use msdn to learn more about ASP.Net.

Giving your email in a public forum is a never a good idea.

Apps - Color Analyzer | Arctic | XKCD | Sound Meter | Speed Dial

Dropdown list based on another dropdown list.

Member 1040983818-Nov-13 10:20

Member 10409838

18-Nov-13 10:20

I have a dropdown list (dlStage) which uses the selected value of another dropdown list (dlJobName) to populate the values. I have both of the ddls set with Autopostback = true but the list dlStage is not populating. I am including the code here for reference. My ultimate goal is to have the user select a value from the dlJobName and then select a value from the dlStage and then the gridview would populate. I had this working when there was basically one stage per JobName. Now there are multiple Stages and the stages are not consistent across jobnames. For example, JobName 123 could have Stage = Release. While 124 would have Stage Final and First. If the update is not done properly, the gridview does not show results or I get an error that the stage does not exist.

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.Web.Security;
using System.Configuration;

namespace AnnoTracker
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        public static class MyVariables
        {
            public static int PI = 0;
            public static string JN = "";
            public static string ST = "";
            public static string AT = "";
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (MyVariables.AT == "")
                {
                    dlAnnoType.DataBind();
                    dlAnnoType.SelectedValue = "Agency Error";
                }
                if (MyVariables.AT != "")
                {
                    dlAnnoType.DataBind();
                    dlAnnoType.SelectedValue = MyVariables.AT;
                }
                if (MyVariables.JN == "")
                {
                    dlJobName.DataBind();
                    dlJobName.SelectedIndex = 0;
                }
                if (MyVariables.JN != "")
                {
                    dlJobName.DataBind();
                    dlJobName.SelectedValue = MyVariables.JN;
                }
                if (MyVariables.ST == "")
                {
                    dlStage.DataBind();
                    dlStage.SelectedIndex = 0;
                }
                //dlStage.SelectedIndex = 0;
                dlStage.DataBind();

                BindData();

                if (MyVariables.PI == 0)
                {
                    gvSummary.DataBind();
                    gvSummary.PageIndex = 0;
                }
                if (MyVariables.PI != 0)
                {
                    gvSummary.DataBind();
                    gvSummary.PageIndex = MyVariables.PI;
                }
            }
        }

        protected void EditSummary(object sender, GridViewEditEventArgs e)
        {
            gvSummary.EditIndex = e.NewEditIndex;
            string _custName = gvSummary.DataKeys[e.NewEditIndex].Value.ToString();
            BindData();
        }

        protected void CancelEdit(object sender, GridViewCancelEditEventArgs e)
        {
            gvSummary.EditIndex = -1;
            BindData();
        }

        protected void gvSummary_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            gvSummary.PageIndex = e.NewPageIndex;
            MyVariables.PI = e.NewPageIndex;
            BindData();
        }


        protected void RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow && gvSummary.EditIndex == e.Row.RowIndex)
            {

                DropDownList dlBU = (DropDownList)e.Row.FindControl("dlBU");

                string _custName = gvSummary.DataKeys[e.Row.RowIndex].Values[1].ToString();
                string BUquery = "select distinct Unit from vw_BU where Business='" + _custName + "'";
                SqlCommand BUcmd = new SqlCommand(BUquery);
                dlBU.DataSource = GetData(BUcmd);
                dlBU.DataTextField = "Unit";
                dlBU.DataValueField = "Unit";
                dlBU.DataBind();
                dlBU.Items.FindByValue((e.Row.FindControl("lblBU") as Label).Text).Selected = true;

                DropDownList dlPA = (DropDownList)e.Row.FindControl("dlPA");

                string _PAcustName = gvSummary.DataKeys[e.Row.RowIndex].Values[1].ToString();
                string PAquery = "select PA from PA where Business='" + _PAcustName + "' order by PA";
                SqlCommand PAcmd = new SqlCommand(PAquery);
                dlPA.DataSource = GetData(PAcmd);
                dlPA.DataTextField = "PA";
                dlPA.DataValueField = "PA";
                dlPA.DataBind();
                dlPA.Items.FindByValue((e.Row.FindControl("lblPA") as Label).Text).Selected = true;

                DropDownList dlET = (DropDownList)e.Row.FindControl("dlET");

                string ETquery = "select distinct ErrorType from ErrorType order by ErrorType";
                SqlCommand ETcmd = new SqlCommand(ETquery);
                dlET.DataSource = GetData(ETcmd);
                dlET.DataTextField = "ErrorType";
                dlET.DataValueField = "ErrorType";
                dlET.DataBind();
                dlET.Items.FindByValue((e.Row.FindControl("lblET") as Label).Text).Selected = true;

                DropDownList dlAA = (DropDownList)e.Row.FindControl("dlAA");

                string AAquery = "select distinct AAA from ActualAgencyError";
                SqlCommand AAcmd = new SqlCommand(AAquery);
                dlAA.DataSource = GetData(AAcmd);
                dlAA.DataTextField = "AAA";
                dlAA.DataValueField = "AAA";
                dlAA.DataBind();
                dlAA.Items.FindByValue((e.Row.FindControl("lblAA") as Label).Text).Selected = true;

                DropDownList dlSupport = (DropDownList)e.Row.FindControl("dlSupport");

                string SupQuery = "select distinct Support from Support";
                SqlCommand Supcmd = new SqlCommand(SupQuery);
                dlSupport.DataSource = GetData(Supcmd);
                dlSupport.DataTextField = "Support";
                dlSupport.DataValueField = "Support";
                dlSupport.DataBind();
                dlSupport.Items.FindByValue((e.Row.FindControl("lblSupport") as Label).Text).Selected = true;

            }
        }

        protected void UpdateSummary(object sender, GridViewUpdateEventArgs e)
        {
            MyVariables.AT = dlAnnoType.SelectedValue;
            //dlAnnoType.DataBind();
            MyVariables.JN = dlJobName.SelectedValue;
            //dlJobName.DataBind();
            MyVariables.ST = dlStage.SelectedValue;
            //dlStage.DataBind();
            MyVariables.PI = gvSummary.PageIndex;
            //gvSummary.DataBind();

            string BU = (gvSummary.Rows[e.RowIndex].FindControl("dlBU") as DropDownList).SelectedItem.Value;
            string ET = (gvSummary.Rows[e.RowIndex].FindControl("dlET") as DropDownList).SelectedItem.Value;
            string AA = (gvSummary.Rows[e.RowIndex].FindControl("dlAA") as DropDownList).SelectedItem.Value;
            string PA = (gvSummary.Rows[e.RowIndex].FindControl("dlPA") as DropDownList).SelectedValue;
            string AnnotationNumber = gvSummary.DataKeys[e.RowIndex].Value.ToString();
            string sgkComments = (gvSummary.Rows[e.RowIndex].FindControl("tbsgkComm") as TextBox).Text;
            string Support = (gvSummary.Rows[e.RowIndex].FindControl("dlSupport") as DropDownList).SelectedValue;
            string SupportName = (gvSummary.Rows[e.RowIndex].FindControl("tbSupportName") as TextBox).Text;
            string BusImpact = (gvSummary.Rows[e.RowIndex].FindControl("tbBusImpact") as TextBox).Text;

            string strConnString = ConfigurationManager.ConnectionStrings["SRM_MetricConnectionString"].ConnectionString;
            using (SqlConnection con = new SqlConnection(strConnString))
            {
                string query = "update vw_GridviewSource set [BusinessUnit] = @BU, [ErrorType] = @ET, [sgkComments] = @sgk, [ActualAgencyError] = @AA, [PA] = @PA, [Support] = @Support, [SupportName] = @SupportName, [BusImpact] = @BusImpact where [AnnotationNumber] = @AnnoNum";
                using (SqlCommand cmd = new SqlCommand(query))
                {
                    cmd.Connection = con;
                    cmd.Parameters.AddWithValue("@BU", BU);
                    cmd.Parameters.AddWithValue("@AnnoNum", AnnotationNumber);
                    cmd.Parameters.AddWithValue("@ET", ET);
                    cmd.Parameters.AddWithValue("@AA", AA);
                    cmd.Parameters.AddWithValue("@sgk", sgkComments);
                    cmd.Parameters.AddWithValue("@PA", PA);
                    cmd.Parameters.AddWithValue("@Support", Support);
                    cmd.Parameters.AddWithValue("@SupportName", SupportName);
                    cmd.Parameters.AddWithValue("@BusImpact", BusImpact);

                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                    Response.Redirect(Request.Url.AbsoluteUri);
                }
            }
            gvSummary.PageIndex = MyVariables.PI;
            gvSummary.DataBind();

            BindData();
        }

        private void BindData()
        {
            gvSummary.PageIndex = MyVariables.PI;
            gvSummary.DataBind();

            if (MyVariables.JN != "" && MyVariables.ST != "" && MyVariables.AT != "")
            {
                dlJobName.SelectedValue = MyVariables.JN;
                dlJobName.DataBind();
                dlStage.SelectedValue = MyVariables.ST;
                dlStage.DataBind();
                dlAnnoType.SelectedValue = MyVariables.AT;
                dlAnnoType.DataBind();
            }
            gvSummary.PageIndex = MyVariables.PI;
            gvSummary.DataBind();

            String conString = System.Configuration.ConfigurationManager.ConnectionStrings["SRM_MetricConnectionString"].ConnectionString;
            string query = "select [Page_ID],[AnnotationNumber],[AnnotationBy],[PA],[AnnotationType],[BusinessUnit] as Unit,[ErrorType],[ActualAgencyError],AnnotationComments,[sgkComments],[ActualAgencyError],Support,SupportName, BusImpact,Cust from vw_GridviewSource order by [Page_ID]";

            SqlCommand cmd = new SqlCommand();

            if (dlJobName.SelectedValue != "" & dlStage.SelectedValue != "")
            {
                query = "select [Page_ID],[AnnotationNumber],[AnnotationBy],[PA],[AnnotationType],[BusinessUnit] as Unit,[ErrorType],[ActualAgencyError],AnnotationComments,[sgkComments],[ActualAgencyError],Support,SupportName, BusImpact,Cust from vw_GridviewSource where Name = '" + dlJobName.SelectedValue + "' and AnnotationDate = '" + dlStage.SelectedValue + "' order by [Page_ID]";
                //cmd.Parameters.AddWithValue("@Name", dlJobName.SelectedValue);
                //cmd.Parameters.AddWithValue("@Stage", dlStage.SelectedValue);
            }


            if (dlAnnoType.SelectedValue != "" && (dlJobName.SelectedValue.Length < 2 && dlStage.SelectedValue.Length < 2))
            {
                query = "select [Page_ID],[AnnotationNumber],[AnnotationBy],[PA],[AnnotationType],[BusinessUnit] as Unit,[ErrorType],[ActualAgencyError],AnnotationComments,[sgkComments],[ActualAgencyError],Support,SupportName, BusImpact,Cust from vw_GridviewSource where AnnotationType = '" + dlAnnoType.SelectedValue + "' order by [Page_ID]";
            }

            if (dlAnnoType.SelectedValue != "" && (dlJobName.SelectedValue != "" && dlStage.SelectedValue != ""))
            {
                query = "select [Page_ID],[AnnotationNumber],[AnnotationBy],[PA],[AnnotationType],[BusinessUnit] as Unit,[ErrorType],[ActualAgencyError],AnnotationComments,[sgkComments],[ActualAgencyError],Support,SupportName, BusImpact,Cust from vw_GridviewSource where AnnotationType = '" + dlAnnoType.SelectedValue + "' and Name = '" + dlJobName.SelectedValue + "' and AnnotationDate = '" + dlStage.SelectedValue + "' order by [Page_ID]";
            }

            cmd.CommandText = query;
            SqlConnection con = new SqlConnection(conString);
            cmd.CommandType = CommandType.Text;
            cmd.Connection = con;
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            gvSummary.DataSource = ds;
            gvSummary.PageIndex = MyVariables.PI;
            gvSummary.DataBind();

        }
        private DataTable GetData(SqlCommand cmd)
        {
            string strConnString = ConfigurationManager.ConnectionStrings["SRM_MetricConnectionString"].ConnectionString;
            using (SqlConnection con = new SqlConnection(strConnString))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection = con;
                    sda.SelectCommand = cmd;
                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        return dt;
                    }
                }
            }
        }

        protected void dlJobName_SelectedIndexChanged(object sender, EventArgs e)
        {
            MyVariables.JN = dlJobName.SelectedValue;
            dlJobName.DataBind();
            MyVariables.ST = dlStage.SelectedValue;
            dlStage.DataBind();
            MyVariables.AT = dlAnnoType.SelectedValue;
            dlAnnoType.DataBind();

            BindData();
            MyVariables.PI = gvSummary.PageIndex;
            gvSummary.DataBind();
        }
        protected void dlStage_SelectedIndexChanged(object sender, EventArgs e)
        {
            MyVariables.JN = dlJobName.SelectedValue;
            //dlStage.DataBind();
            MyVariables.ST = dlStage.SelectedValue;
            MyVariables.AT = dlAnnoType.SelectedValue;
            gvSummary.DataBind();
            BindData();
        }
        protected void dlAnnoType_SelectedIndexChanged(object sender, EventArgs e)
        {
            MyVariables.AT = dlAnnoType.SelectedValue;
            MyVariables.JN = dlJobName.SelectedValue;
            //dlStage.DataBind();
            MyVariables.ST = dlStage.SelectedValue;
            gvSummary.DataBind();
            BindData();
        }


    }
}

TIA

Tim Vavra

Re: Dropdown list based on another dropdown list.

Richard Deeming19-Nov-13 2:07

Richard Deeming

19-Nov-13 2:07

What you're looking for is commonly called a "cascading dropdown list". There are quite a few articles which explain how to achieve this; for example:
http://www.aspsnippets.com/Articles/Creating-Cascading-DropDownLists-in-ASP.Net.aspx[^]

Your code has some other obvious problems:

Your queries in the RowDataBound and BindData methods are susceptible to SQL Injection[^]. You need to replace the string concatenation with parameterized queries.
You are storing page-specific state in static fields. The value of a static field will be shared across every request from every user for the lifetime of the AppDomain, which is not what you want.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

ASP.NET QUESTION PERSONAL PROJECT

cserakeshcseranjan18-Nov-13 4:30

cserakeshcseranjan

18-Nov-13 4:30

HOW TO CREATE FEEDBACK FORM SO THAT ANY USER CAN SEND MESSAGE TO MY STATIC EMAIL-ID??

Re: ASP.NET QUESTION PERSONAL PROJECT

Joshua Omundson18-Nov-13 4:58

Joshua Omundson

18-Nov-13 4:58

This will help you learn about sending emails in asp.net

http://asp.net-tutorials.com/misc/sending-mails/[^]

Re: ASP.NET QUESTION PERSONAL PROJECT

thatraja18-Nov-13 4:59

thatraja

18-Nov-13 4:59

0) Why shouting? (Don't use UPPER case)
1) Last month, Damian gave you one project[^]
2) Again you have asked another project[^] (Don't Repost your question multiple places)
3) Did you try Google & Codeproject searches?

thatraja

Code converters | Education Needed | Plans

How does IIS recognize that request is for MVC Controllers or webforms Pages?

sanjay24365718-Nov-13 4:08

sanjay243657

18-Nov-13 4:08

How does IIS recognize that request is for MVC Controllers or webforms Pages?

Janus GridEx + asp.net

jojoba201118-Nov-13 4:00

jojoba2011

18-Nov-13 4:00

I am using GridEx in VS2008 (windows 8 - x64).
when i publish the app and run in IIS the janus GridEx doesnt work?
my janus version is :
Janus ASP.NET Server Controls 3.0.0.56

Thanks in advnaced!

Re: Janus GridEx + asp.net

thatraja18-Nov-13 4:32

thatraja

18-Nov-13 4:32

jojoba2011 wrote:
when i publish the app and run in IIS the janus GridEx doesnt work?

how? what's the error? Include those details in your question always.

Besides always ask software provider[^] for quick response.

thatraja

Code converters | Education Needed | Plans

Re: Janus GridEx + asp.net

jojoba201119-Nov-13 18:05

jojoba2011

19-Nov-13 18:05

check this site :

almaselectric.tinagroup.ir

when scrolling the grid,It goes out of box????/
when running on local it doesnt work correctly ?

ADO.NET

rock_monu17-Nov-13 21:58

rock_monu

17-Nov-13 21:58

how to create exe file in c# windows application and also shortcut n desktop..Please Tell me in Step by Step...Urgent..!!!!!

Re: ADO.NET

Rockstar_17-Nov-13 22:26

Rockstar_

17-Nov-13 22:26

Check the following links,

http://vijirajkumar.blogspot.in/2010/03/create-setup-and-deployment-project.html[^]

http://csharpdotnetfreak.blogspot.com/2011/08/create-setup-project-visual-studio.html[^]

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.