ASP.NET

Re: creating ajax from C#

3-Jan-10 17:11

Hi navneeth hope you can get my problem now,

actually my requirement is that to create ajax modal pop up dialogue for dynamic controls.
i have already posted regarding the same. now i came with one thought that creating the ajax modal pop up extender from C#..

the aspx 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>

this s normal code to create ajax pop up.

and my C# code is( need to open when clicking an link button)

protected void Link_Click(object s, EventArgs e)
{
string str;
LinkButton lbl = s as LinkButton;
str = lbl.CommandName;

//ajax.ToolkitScriptManager ToolkitScriptManager1 = new AjaxControlToolkit.ToolkitScriptManager();

ajax.ModalPopupExtender MPE = new AjaxControlToolkit.ModalPopupExtender();

MPE.TargetControlID = "lbl";
MPE.PopupControlID = "panel";
MPE.BackgroundCssClass = "modalBackground";
MPE.DropShadow = false;
MPE.OkControlID = "Ok";
MPE.X = 200;
MPE.Y = 200;
MPE.CancelControlID = "Cancel";

}

am i going in the correct way?
but its not working though.

In aspx if u give the Popup control id for pop up the control wont be visible in the page , when you click it will come.
but here i.e while creating ajax pop up from the C# code its parameter TargetControlID and PopupControlID is accepting as string, thus it will take the control dynamically, and the control is visible in the page.But in aspx code if we give the control ID to the PopupControlID , the control wont be visible in the page.

can any one help me how to create modal pop up for dynanic??
or is there anything other than ajax..??

help me
thanks in advance

keyur satyadev3-Jan-10 19:03

keyur satyadev

3-Jan-10 19:03

have you search this in goolge. if yes then you will get easily.

any way look at link below and read the same you will easily learn it.

http://www.asp.net/AJAX/AjaxControlToolkit/Samples/ModalPopup/ModalPopup.aspx

Regards
Keyur Satyadev

Re: creating ajax from C# [modified]

Hema Bairavan3-Jan-10 19:58

Question regarding major decline in data retrieval efficiency

3-Jan-10 19:58

guys finally i got the solution for ajax pop up for dynamic control.
if you peoples need have a look

http://www.joshuafolkerts.com/AJAXPopupModal.aspx[^]

modified on Monday, January 4, 2010 4:15 AM

James Shao3-Jan-10 2:59

James Shao

3-Jan-10 2:59

I have built simple asp.net website that retrieve financial data from Yahoo Finance. The data is historical prices for roughly 2000 stock tickers. When running the program, I notice that the speed at which these data get retrieved, processed, and insert (bulk insert) into my database gradually decreases over time. For example, data would be written into the database at 8 stock tickers every 5 seconds, but after 15 minutes, it's like 3 stock tickers every 5 seconds.

Is this because memory was not handled properly (like datasets not disposed at the right time) or some other issues related to ADO.net?

I'd greatly appreciate for any suggestions. Thanks!

Re: Question regarding major decline in data retrieval efficiency

N a v a n e e t h3-Jan-10 4:46

Re: Question regarding major decline in data retrieval efficiency

3-Jan-10 4:46

James Shao wrote:
Is this because memory was not handled properly (like datasets not disposed at the right time) or some other issues related to ADO.net?

May be. Hard to tell more without knowing more about your code. Few things which you could try,

1 - Ensure calls to Dispose() for types that implements IDisposable. Wrapping the object inside a using block is the way to go.

2 - Profile your methods and see which one is taking long time. For now, start with StopWatch class and get the execution time for the methods.

If you can provide some sample code, probably I could help more.

Best wishes,
Navaneeth

James Shao3-Jan-10 12:27

James Shao

3-Jan-10 12:27

Thank you Navaneeth, I'll begin by trying Stopwatch and check the location where inefficiency occurs. Smile | :)

Unit testing is a must learn technology for an asp.net programmer?

popchecker2-Jan-10 19:49

popchecker

2-Jan-10 19:49

I am comparatively new to the test driven development and unit testing. I spent last two weeks to learn the concept of these technologies. Following is my understanding about unit testing. Please correct me if I am wrong.

1. Unit test would be an over kill for small asp.net projects.

2. I believe testing how aspx pages rendering is an important fact. As far I know NUnit test is not capable for doing this. I know the free tool NUnitAsp but the development on this project is terminated. I also found some other tools like selenium. How is your opinion about it?

Is it worth to learn NUnit test for asp.net? How about to implement Unit test in small asp.net applications?

Thanks and regards,

Poppy

Re: Unit testing is a must learn technology for an asp.net programmer?

N a v a n e e t h3-Jan-10 4:57

Re: Unit testing is a must learn technology for an asp.net programmer?

3-Jan-10 4:57

First of all, unit testing is not a technology. It's a practice.

popchecker wrote:
Unit test would be an over kill for small asp.net projects.

I don't think so. Most of the projects start as small and evolve to a bigger one. In such cases unit testing helps you to catch errors when you move code around and add more code. When the application is small, number of unit tests also will be small. So I don't see anything wrong in having that.

popchecker wrote:
I believe testing how aspx pages rendering is an important fact

I am afraid that is not unit testing.

Usually you don't write unit tests for the presentation part. You need to split the things that needs testing from the UI and keep UI very thin. Patterns like MVC and MVP helps you to achieve this kind of design.

popchecker wrote:
I know the free tool NUnitAsp but the development on this project is terminated. I also found some other tools like selenium. How is your opinion about it?

I haven't used it so far. But I have heard some good comments about selenium.

popchecker wrote:
Is it worth to learn NUnit test for asp.net?

Yes.

Best wishes,
Navaneeth

popchecker3-Jan-10 17:16

popchecker

3-Jan-10 17:16

Thanks for reply. Let me ask one more question. How can I test my presentation part? Can you please suggest me a method?

Thanks and regards,
Poppy

Re: Unit testing is a must learn technology for an asp.net programmer?

N a v a n e e t h3-Jan-10 21:39

Re: Unit testing is a must learn technology for an asp.net programmer?

3-Jan-10 21:39

You have to use UI testing frameworks like QTP.

Best wishes,
Navaneeth

popchecker3-Jan-10 22:43

popchecker

3-Jan-10 22:43

Thanks Navaneeth Big Grin | :-D

I am going to implement NUnit test in my next project. Sure I will come back with few more doubts. Thumbs Up | :thumbsup:

Ajax modal pop up for dynamic control

Hema Bairavan2-Jan-10 18:48

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

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

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