ASP.NET

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

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

THE SK

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

THE SK

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