ASP.NET

2-Jan-10 18:48

Hi peoples,

i like to use the ajax modal popup window for dynamically genarated link button.

my code is

<table>

<tr><td>
<asp:Button runat="server" ID="btntext" Text="test"
/>
<ajaxToolkit:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</ajaxToolkit:ToolkitScriptManager>
<ajaxToolkit:ModalPopupExtender ID="MPE" runat="server"
TargetControlID="btntext"
PopupControlID="panel"
BackgroundCssClass="modalBackground"
DropShadow="false"
OkControlID="Ok"

X="200"
Y="200"
CancelControlID="Cancel"
/>
</td></tr>
</table>

<asp:repeater id="rptProducts" runat="server" OnItemDataBound="RepeaterItemEventHandler">
<ItemTemplate>
<table cellpadding="5" cellspacing="0">
<tr>
<tr><td><asp:LinkButton runat="server" ID="i" OnClick="Link_Click" CommandName=<%#Eval("fao_addsnumber")%> > <%#Eval("fao_subcategory")%> </asp:LinkButton></td></tr>
<tr><td align="left" ><asp:Label runat="server" ID="lblitem"></asp:Label></td></tr>
</table>
</ItemTemplate>
</asp:repeater>
in the above code the target id is button and is working fine.

but my req is with some conditions i will dynamically generate the link labels from , and that will be in the repeaters.
in that link label i want to give this modal dialogue to open.

how to do that, please help.. thanks in advance

executing procedure,

Hema Bairavan2-Jan-10 17:40

2-Jan-10 17:40

Hi all,

the stored procedure is working fine if i run from the query editor, but its not when from asp application (C#)

actually

my procedure is

create proc test
@text varchar(50)

select * from table where Column like @text

if i execute from query editor

exec proc '%text%'

its working fine for me

but from asp C#
SqlDataReader dr;
SQLCommand Cmd;
Cmd.Parameters.Add("@text","%text%")
dr = Cmd.ExecuteReader();
its not working for me, its giving wrong result.
any idea can any one help me?

Brij2-Jan-10 23:04

Brij

2-Jan-10 23:04

Have a look to thislink.It will help you

Cheers!!
Brij

Hema Bairavan3-Jan-10 2:06

3-Jan-10 2:06

mr brij,

what you gave is how to execute a procedure from .net.

but my question is not that, the behavior of the varchar(i/p parameter) while sending from the .net.

Brij3-Jan-10 3:28

Brij

3-Jan-10 3:28

For sending the parameter to SP,you need to keep in mind very first, that the parameter name should be same in c# as in sp.
For details how to pass to parameter to a sp have a look
One more thing you are passing special characters from C#.It might be creating problem.Just for validation of your code,make a sample POC that doesn't take special characters.
You can also append special characters in SP itself according to your need.
Please let me know when your problem gets resolved.

Cheers!!
Brij

N a v a n e e t h3-Jan-10 5:38

N a v a n e e t h

3-Jan-10 5:38

You haven't set CommandType property of SqlCommand to CommandType.StoredProcedure.

Best wishes,
Navaneeth

Hema Bairavan3-Jan-10 5:51

3-Jan-10 5:51

thanks for your reply navneeth,
and i have give the same
..

my code is

SqlCommand Cmd = new SqlCommand();
_Dal.CreateCommand(ref Cmd, "dbo.fao_getpagedproducts");

Cmd.CommandType = CommandType.StoredProcedure;

SqlDataReader dr;

Cmd.Parameters.Add("@PageSize", SqlDbType.Int, 4).Value = pager1.PageSize;
Cmd.Parameters.Add("@CurrentPage", SqlDbType.Int, 4).Value = pager1.CurrentIndex;
Cmd.Parameters.Add("@Text", SqlDbType.Char, 50).Value = "%"+txtSearch.Text.Trim()+"%";
Cmd.Parameters.Add("@DDLCategory", SqlDbType.Int, 1).Value = Convert.ToInt32(RBCategory.SelectedValue.ToString().Trim()
== "" || RBCategory.SelectedValue.ToString().Trim() == "9" ? "0" : RBCategory.SelectedValue.ToString().Trim());
Cmd.Parameters.Add("@ItemCount", SqlDbType.Int).Direction = ParameterDirection.Output;

dr = Cmd.ExecuteReader();

rptProducts.DataSource = dr;
rptProducts.DataBind();

dr.Close();

here txtSearch is a text box for which i have search
and my procedure is

create PROCEDURE dbo.fao_getpagedproducts(
@Text INT,
)

select * from table where column like @Text

i have shown my simple code

here my text is not working fine..
can you get me wat i m asking for?

N a v a n e e t h3-Jan-10 6:11

N a v a n e e t h

3-Jan-10 6:11

Hema Bairavan wrote:
Cmd.Parameters.Add("@Text", SqlDbType.Char, 50).Value = "%"+txtSearch.Text.Trim()+"%";

Hema Bairavan wrote:
@Text INT,

I guess the datatype is wrong. Procedure expects and INT and you are passing Char. Try changing the parameter type to Varchar in both places.

Best wishes,
Navaneeth

Hema Bairavan3-Jan-10 6:18

3-Jan-10 6:18

extremly sorry navneeth that was char though.
while editing here i missed the text as INT.
i gave that as char only,

and previously i gave varchar in procedure, its not working
when i changed at both the places it works fine
thanks for your support.

and i have also posted new post regarding the ajax controls. if u have time help me though.......

happy new year

asp:menu issue

THE SK2-Jan-10 9:42

2-Jan-10 9:42

Hi All

I want to add a menu somewhat like that of codeproject(see above the green horizontal div)
Home Articles Quick Answers etc

I was using asp:menu

<asp:menu id="NavigationMenu"
staticdisplaylevels="2"
staticsubmenuindent="10"
orientation="Vertical"
target="_blank"
runat="server" >

<DynamicMenuItemStyle BackColor="Aqua" Font-Bold="true" />
<dynamichoverstyle backcolor="Green"
forecolor="Black"/>

<items>
<asp:menuitem navigateurl="Home.aspx"
text="Home"
tooltip="Home">
<asp:menuitem navigateurl="Music.aspx"
text="Music"
tooltip="Music">
<asp:menuitem navigateurl="Classical.aspx"
text="Classical"
tooltip="Classical"/>
<asp:menuitem navigateurl="Rock.aspx"
text="Rock"
tooltip="Rock"/>
<asp:menuitem navigateurl="Jazz.aspx"
text="Jazz"
tooltip="Jazz"/>
</asp:menuitem>
<asp:menuitem navigateurl="Movies.aspx"
text="Movies"
tooltip="Movies">
<asp:menuitem navigateurl="Action.aspx"
text="Action"
tooltip="Action"/>
<asp:menuitem navigateurl="Drama.aspx"
text="Drama"
tooltip="Drama"/>
<asp:menuitem navigateurl="Musical.aspx"
text="Musical"
tooltip="Musical"/>
</asp:menuitem>
</asp:menuitem>
</items>

</asp:menu>

But I have seen that if I disable javascript on my browser asp:menu doesnot work.
However codeproject menu works even after disabling the javascript.
Please guide which control is the codeproject using for menu.I want to use the same

Thanks

Regards
Sandeep

Abhijit Jana2-Jan-10 10:19

Abhijit Jana

2-Jan-10 10:19

I will suggest you to go for CSS Friendly Menu Adapter. That will resolve your issue.
http://www.asp.net/CssAdapters/[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

THE SK2-Jan-10 10:30

2-Jan-10 10:30

Abhijit thanks for your answer

Does the menu on the codeproject site is implemented in the same way?
After disabling the javascript would cssadapters will work?
The codeproject menu works even after disabling javascript on the browser.

Thanks

Regards
Sandeep

Abhishek Sur2-Jan-10 10:54

Abhishek Sur

2-Jan-10 10:54

simple CSS fixes will do this..

Say in codeproject the Menu structure is like this :

<ul class="nav" >
<li ><a href="#">Home</a></li>
<ul style="display:none;">
<li ><a href="#">ASP.NET</a></li></ul>
</ul>

Now on

#nav a:hover >ul
{
 //css to display
}

You can apply these sort of simple CSS to show / hide menu items which will not be dependent on Javascript as with Codeproject.
Smile | :)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Windows7 API Code Pack

Simplify Code Using NDepend
Basics of Bing Search API using .NET

THE SK2-Jan-10 11:03

2-Jan-10 11:03

Thanks Abhishek

Now got the right answer . But please tell me
what the following css code do

#nav a:hover >ul
{
//css to display
}

Thanks

Regards
Sandeep

ClickOnce Deployment Issue!!

Abhishek Sur3-Jan-10 2:30

Abhishek Sur

3-Jan-10 2:30

This is actually a Combined selector of CSS, means you are going to the first ul under the anchor(a) tag.

Why dont you learn CSS from here :
http://www.w3schools.com/Css/default.asp[^]

I hope this would definitely benefit you while writing CSS menu.
Cheers.
Thumbs Up | :thumbsup:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Windows7 API Code Pack

Simplify Code Using NDepend
Basics of Bing Search API using .NET

Sr...Frank2-Jan-10 9:07

Sr...Frank

2-Jan-10 9:07

Hi,

I am trying to customize ClickOnce application for WPF project.
The simple setup works fine but we need automatic updates so we like to use ClickOnce and the requirement is to start application when user logon to his system.
For this requirement we need to create shortcut to user’s startup folder.
Please let me know how to create shortcut to user’s startup folder for ClickOnce.

Thanks

Re: ClickOnce Deployment Issue!!

Abhijit Jana2-Jan-10 9:19

Abhijit Jana

2-Jan-10 9:19

You are in wrong forum ! This is ASP.NET Forum Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: ClickOnce Deployment Issue!!

Sr...Frank2-Jan-10 9:35

Sr...Frank

2-Jan-10 9:35

Where should I post?

Menu Links In Master Pages

Brendan Vogt2-Jan-10 2:43

Brendan Vogt

2-Jan-10 2:43

Hi,

I'm trying to setup my menu links in my master page so that it can be used by all pages irrespective how far down the page hierarchy you are. I haven't done this in ages, I know it is something like:

<a href="<% "~/Product/Default.aspx" %>">Home</a>

Please can someone advise.

Regards,
Brendan

Re: Menu Links In Master Pages

Brij2-Jan-10 3:40

Brij

2-Jan-10 3:40

Why don't you use asp.net menu control.. for details have a look

You can also use normal html links and give look n feel using css as per your need.

Cheers!!
Brij

Re: Menu Links In Master Pages

Brendan Vogt4-Jan-10 5:24

Brendan Vogt

4-Jan-10 5:24

I'm not looking to use it as a menu. I have links across that are used over all pages irrespective where you, so menu control will not work. Like for example Contact Us, Terms and Conditions, etc.

How would I do these links?

I can use html links like I showed in my example, but how do I get the href part correct as "../" won't work.

Please can someone advise?

How to Format Text in ASP.net ?????????

THE SK2-Jan-10 1:31