ASP.NET

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

15-Jan-09 5:20

Thanks

ballon tooltip

Mogaambo15-Jan-09 3:21

Mogaambo

15-Jan-09 3:21

Hi, i need a solution in which i give a specific coordinates and a balloon pop up appears on that very coordinate. i need this in my imagemap server control , where i have given the option search to search a item, if that particular item is present then a pop will appear over it in image map.

“You will never be a leader unless you first learn to follow and be led.”
–Tiorio

"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford

Re: ballon tooltip

ToddHileHoffer15-Jan-09 3:44