ASP.NET

Re: URL Confusion [modified]

15-Jan-09 7:26

Try Uri pathUri = new Uri(HttpContext.Current.Request.Url, string.Format("~/Secure/SearchResults.aspx?{0}={1}", QS_SEARCH_TERMS, HttpContext.Current.Server.UrlEncode(search)));

I didn't get any requirements for the signature

Tristan Rhodes15-Jan-09 22:40

Tristan Rhodes

15-Jan-09 22:40

Hi Todd,

I had origionally tried this, but the tilde is just added to the path, rather than being replaced, and i end up with:

http://localhost:00001/~/Secure/SearchResults?search=aaaa

Additionally, if i were to remove the ~/ and just use 'Secure/SearchResults?search=aaaa' for the second part of the URI, then the entire directory structure is used, which also results in the resource not being found.

i.e.

new Uri("http://localhost:00001/Project/Secure", "Secure/SearchResults?search=aaaa");

i get:
http://localhost:00001/Project/Secure/Secure/SearchResults?search=aaaa

As i am trying to generate links in a master page, this is increadiably frustrating as it is used in multiple sub directories, which causes the links to be generated differently.

Any further ideas?

Regards

Tris

-------------------------------

Carrier Bags - 21st Century Tumbleweed.

modified on Friday, January 16, 2009 4:59 AM

Re: URL Confusion

ToddHileHoffer16-Jan-09 2:11

16-Jan-09 2:11

try Page.ResolveUrl ("~/...")

I didn't get any requirements for the signature

Re: URL Confusion

Tristan Rhodes16-Jan-09 5:23

Tristan Rhodes

16-Jan-09 5:23

Hi Todd,

I was not in the context of the page when running this block of code, however i have found a solution.

<br />
        /// <summary><br />
        /// Method for generating a link to this page with the supplied querystring parameters.<br />
        /// </summary><br />
        /// <param name="search"></param><br />
        /// <returns></returns><br />
        public static string GetLink(string search, int searchStart)<br />
        {<br />
            string path = VirtualPathUtility.ToAbsolute("~/Secure/SearchResults.aspx");<br />
<br />
            return string.Format("{0}?{1}={2}&{3}={4}", path, QS_SEARCH_START, searchStart, QS_SEARCH_TERMS, HttpContext.Current.Server.UrlEncode(search));<br />
        }<br />

While this didn't generate the complete URL, it did provide me with one that works from any location in the application.

Thanks for taking the time to reply

Regards

Tris

-------------------------------

Carrier Bags - 21st Century Tumbleweed.

gridview

mihirkul15-Jan-09 6:07

mihirkul

15-Jan-09 6:07

i have a grid view on which i m doing insert ,delete,edit operations.
i have created stored procedures for them in sql server 2005.

i created buttons for edit and delete in each row of gridview.
i am only using "rowcommand" event for editing and deleting operation.
on edit button click i want to insert cell values of row into textboxes in my webform outside gridview.
i have edit button outside on clicking which it enters textbox value in grid view..
HOW CAN I ACHIEVE THIS?

mihirkul vikram

Re: gridview

ToddHileHoffer15-Jan-09 7:23

Sys.WebForms.PageRequestManagerParserErrorException

15-Jan-09 7:23

protected void EditButton_Click(object sender, EventArgs e)
{
LinkButton EditButton = (LinkButton)sender;
GridViewRow gvrObject = (GridViewRow)EditButton.NamingContainer;

Textbox tb = (Textbox)gvrObject.FindControl("tb"); //Must be a template column

this.yourTextBoxOutsideOfGrid.Text = tb.Text;
}

pmartike15-Jan-09 6:04

pmartike

15-Jan-09 6:04

Hi!

I have a problem with my website. I'm using UpdatePanel and i update it's content using a timer.
On local server everything is fine but when i upload it on the server on every update i get this error:

Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled.

Details: Error parsing near '

<!DOCTYPE html P'.

- No Response.Write();
- No Response filters
- No HttpModules
- No Server trace
- No Server.Transfer();

Please help me....

--------------------------------
visit: http://pmartike.deviantart.com/

Re: Sys.WebForms.PageRequestManagerParserErrorException

CoolFire4eva19-Feb-09 17:35

CoolFire4eva

19-Feb-09 17:35

Try the following.
Add attribute UpdateMode="Conditional" in the UpdatePanel.

http://forums.asp.net/t/1360023.aspx[^]

Hope this works for you.

Procedure and Codebehind Problem

monika_vasvani15-Jan-09 5:55

monika_vasvani

15-Jan-09 5:55

Hi all

I have created one procedure:
CREATE PROCEDURE [dbo].[dynamic_insert](@table varchar(50),@parameter nvarchar(4000))
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
set @opration='insert into '+@table+'(+@testTable+) values(+ @parameter +)'
end

My front end code is:

com.Parameters("@table").Value = "order1"
com.Parameters.Add("@parameter", SqlDbType.NVarChar)
com.Parameters("@parameter").Value = c2.cust_id & "," & c2.item_id & "," & c2.cust_items & "," & c2.item_name

c2 is my class object.

My problem is:when i assign values in parameter field,it takes as string.
So data is not inserted.

example: c2.cust_id = 1
c2.item_id = 1
c2.cust_items = "cd"
c2.item_name = "pen"
com.Parameters("@parameter").Value ="1,1,cd,pen"

It's not possible to insert string.

what i do?is there any another datatype? or another way?

Thanks
monika

[Formatting] Procedure and Codebehind Problem

Scott Dorman15-Jan-09 6:20

Scott Dorman

15-Jan-09 6:20

I have created one procedure:

CREATE PROCEDURE [dbo].[dynamic_insert](@table varchar(50),@parameter nvarchar(4000))
AS
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;
  SET @opration='insert into '+@table+'(+@testTable+) values(+ @parameter +)'
  END

My front end code is:

com.Parameters("@table").Value = "order1"
com.Parameters.Add("@parameter", SqlDbType.NVarChar)
com.Parameters("@parameter").Value = c2.cust_id & "," & c2.item_id & "," & c2.cust_items & "," & c2.item_name

c2 is my class object.

My problem is when I assign values in parameter field, it takes as string.
So data is not inserted.

example:

c2.cust_id = 1
c2.item_id = 1
c2.cust_items = "cd"
c2.item_name = "pen"
com.Parameters("@parameter").Value ="1,1,cd,pen"

It's not possible to insert string.

what i do? is there any another datatype? or another way?

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Re: Procedure and Codebehind Problem

Scott Dorman15-Jan-09 6:24

Scott Dorman

15-Jan-09 6:24

You can't execute dynamic SQL like this. I believe you would need to call the "EXEC" function on the generated SQL. What is the actual SQL statement you want executed? Where does the @testTable parameter come from?

Why are you not just creating a single stored procedure to handle inserts into the table and simply calling that, passing the appropriate parameters as discrete values?

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

onselectedindexchanged

Franklinlloyd15-Jan-09 5:16

Franklinlloyd

15-Jan-09 5:16

dropdown list, something not right in my code, say for i'm trying to view movies for thrus, but wed page is showing up when I click on thrusday dropdown
here my code behind

Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
'Dim ds As DataTable
'ds = GridView1.DataSource
'GridView1.DataSource = ds
PopulateGrid(Convert.ToDateTime(DropDownList1.SelectedValue.ToString()))

Re: onselectedindexchanged

Scott Dorman15-Jan-09 5:31

Scott Dorman

15-Jan-09 5:31

First, please use the <pre> tags for code blocks (using the "code block" formatting option).

Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
  'Dim ds As DataTable
  'ds = GridView1.DataSource
  'GridView1.DataSource = ds
  PopulateGrid(Convert.ToDateTime(DropDownList1.SelectedValue.ToString()))

Is this the complete method? It looks like it might be missing stuff.

Anyway, what does your drop down list of values look like? Remember, VB collections/arrays start counting at 1 not 0 and from your description it sounds like you are off by one on your indexing.

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Problem with Repeater........Values get repeated.

Charmy315-Jan-09 4:32

Re: Problem with Repeater........Values get repeated.

15-Jan-09 4:32

My repeater looks like :

Cat
cat.jpg

Dog
dog.jpg //total 2 results.So repated twice

Cat
cat.jpg

Dog
dog.jpg

Code .aspx page

<asp:repeater id="Rep_First" runat="server" visible="true" onitemdatabound="Rep_First_ItemDataBound" xmlns:asp="#unknown">

<itemtemplate>

<asp:repeater id="Rep_Second" runat="server">

<itemtemplate>

<asp:literal id="litImage" runat="server" text="<%# DataBinder.Eval(Container.DataItem," name")%>"="">

<asp:image id="Img" runat="server">

Code Behind

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)

{

Repeater Rep_Sec = (Repeater)e.Item.FindControl("Rep_Second");

if (Rep_Sec != null)

{

Rep_Sec.DataSource =myresultlist;

Rep_Sec.DataBind();

}

What do I do????

Abhijit Jana15-Jan-09 5:28

Abhijit Jana

15-Jan-09 5:28

Charmy3 wrote:
Rep_Sec.DataSource =myresultlist;

How many records are there in myresultlist ?

cheers,
Abhijit
CodeProject MVP
My Recent Article : Exploring Session in ASP.Net

Re: Problem with Repeater........Values get repeated.

Charmy315-Jan-09 5:52

Re: Problem with Repeater........Values get repeated.

15-Jan-09 5:52

2 records....
And actually when i debugged it....I saw
In ..

if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{

}
So what happens is...it comes in if loop 2 times....once for Item type and once for Alternating Item type..and thats where it prints twice...Thats what I think

Charmy315-Jan-09 7:34

15-Jan-09 7:34

I am done with Solution.Thank you all.

excel upload probs

Member 387988115-Jan-09 4:27

Member 3879881

15-Jan-09 4:27

Hi guys i am facing a new probs,

I have an excel sheet, i am just uploading all those datas to my dataset...,

In that excel sheet one of the column having the values like:

16093
TNB00075

See in this i can able get this integer value data, but in my for loop i cant able to get this second value,

Whats the wrong this is my sample code:

if (DS_Trade.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < DS_Trade.Tables[0].Rows.Count; i++)
{

if (DS_Trade.Tables[0].Rows[i]["Status"].ToString().ToLower().Trim() == "active")
{
active = 1;
}
else
{
active = 0;
}
Response.Write(DS_Trade.Tables[0].Rows[i]["PAN NO"].ToString().Trim() + "\n");

Thanks & Regards,
Member 3879881,
please don't forget to vote on the post

Re: excel upload probs

ToddHileHoffer15-Jan-09 4:42

15-Jan-09 4:42

First of all, you can do

foreach (datarow r in ds.tables[0].rows)
{
//what value does DS_Trade.Tables[0].Rows[i]["PAN NO"].ToString() return?
}

I didn't get any requirements for the signature

[Message Deleted]

Charmy315-Jan-09 4:05

15-Jan-09 4:05

[Message Deleted]

Abhijit Jana15-Jan-09 4:29

Abhijit Jana

15-Jan-09 4:29

swetapatel3 wrote:
What do I do????

What do you want ? What is your problem ? and one more thing while posting any question please use proper Formatting . Its very difficult to understand .

cheers,
Abhijit
CodeProject MVP
My Recent Article : Exploring Session in ASP.Net

Charmy315-Jan-09 4:52

15-Jan-09 4:52

Hey I did correct the format..Abhijit Now Reply me please with the solution

Abhijit Jana15-Jan-09 5:08

Abhijit Jana

15-Jan-09 5:08

Charmy3 wrote:
Hey I did correct the format.

No you didn't. You have deleted the original message and Post it a new one again ! Looks this is your first post in this forum , I will suggest you please don't delete and cross post. Here every one present to give you solution. Smile | :)

For answer , let me check your new post !! Smile | :)

cheers,
Abhijit
CodeProject MVP
My Recent Article : Exploring Session in ASP.Net

Charmy315-Jan-09 5:20