Retrive the value from query string

[arial]

Hi all,

I need some help on retrive the value from query string.

I have two web forms. One has the datagridview which displays the data from database. On one of the column I made a hyperlink to go to next page

like, qi.aspx?qi_track={0} and now I need to open a detail of this qi_track on second page.

how can I extract the value of qitrack from the url.


and my second problem is:

I want to make my column value a hyperlink in datagrid view.

How can I make that happen.

for ex,

NAME
_______
A.J.
T.J
ETC.

value under name cloumn comes from database and I want a hyperlink under A.J., T.J. etc to open a new page.

Thank you in advanced for your help.

Thanks,

[kunal pawar]

In VB.Net

Request.Querystring("qi_track"), this return value for qi_track

In c#

Request.Querystring["qi_track"], this return value for qi_track

[arial]

Thanks kunal.

But I still have another problem which about making a hyper link on one of the column's datavalue.

like,

name is the column name which holds people's name I need a hyperlink on each of this name to pull up their detail.

how can I do this?

Thanks,

[Plater]

Thanks kunal.

But I still have another problem which about making a hyper link on one of the column's datavalue.

like,

name is the column name which holds people's name I need a hyperlink on each of this name to pull up their detail.

how can I do this?

Thanks,

After you have the data in the gridview, you can do post proccess on it.
Changing what is in it's rows/columns at will.

[arial]

Hi Plater,

Can you explain with example if possible?

I am still new to asp.net.

Thank you,

[Plater]

Hi Plater,

Can you explain with example if possible?

I am still new to asp.net.

Thank you,

Well here's a snipit from one of mine that changes a column to a hyperlink. You should be able to get an idea from it.
gvOverdueSites is the name of my gridview.

protected void procOverdueSites()
{
    string msg = "";
    string href = "ManagerSiteInfo.aspx?siteid=";
    if (gvOverdueSites.HeaderRow != null)
    {
        for (int i = 0; i < gvOverdueSites.Rows.Count; i++)
        {
            msg = gvOverdueSites.Rows[i].Cells[0].Text;
            if (gvOverdueSites.HeaderRow.Cells[0].Text == "SiteID")
            {
                HyperLink hl = new HyperLink();
                hl.Text = msg;
                hl.NavigateUrl = href + msg.Replace("&amp;", "&");
                gvOverdueSites.Rows[i].Cells[0].Controls.Add(hl);
            }
        }//end of forloop
    }
}
 

[arial]

Thanks Plater,

I will try.

Also, is might be a very silly question but I don't seem to figure it out.

I need to extract a last two character of a string matching "99".

My string can be a variable length so I think I can not use substring function.


How can I accomplish this?

Thanks,

[arial]

Sorry but let me redefine my last problem.

I have string of unknown length but all these string will have initial value of current date.

for example, string str1 = 0801hello,
                           str2 = 0801why
etc. I need to extract only the character after the date. 
I save the current date in a variable.
 
sqidate = DateTime.Now.ToString("yyMM");
 

but now I am not sure how to match up the string with date varible("sqidate") and extract only the reset of the value.

Please help me.

Thank You,

[Plater]

if it's always 4digits for the date, just take a .SubString(4); this will skip the first 4 characters and take everything after it.

[arial]

I recently find out that the data store in database removes the first zero from the value.

like for 2008 value is store like 801aaa, 801bbbb ect.
and it will be for 2010, 1001aaa,1002bbb etc.
 

so substring (4) would work for 2010 but what about 2008.

I like to do it in a way so that it will take care of all years like 2008,2009, 2010 and so on.

any suggestion?

Thank You,

[Plater]

I'm not sure I have you statements right.
I though you were using "yyMM" for your datestring, that is always 4digits.
If that is what is going to start every string, then all you have to do is skip 4digits.