ASP.NET Discussion Boards

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

ncsubbu31-Aug-09 2:47

31-Aug-09 2:47

Hi
I am using sqlhelper class for dataaccess.I am retriving records from view.The records more than 20,000.In this case i got timeout expired.i increase the connectiontimeout is 120sec.If any solution to solve this problem.

your's subbu

Re: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Tamer Oz31-Aug-09 2:55

Tamer Oz

31-Aug-09 2:55

Try setting commands timeout property to a higher value

Re: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Abhijit Jana31-Aug-09 3:06

Abhijit Jana

31-Aug-09 3:06

ncsubbu wrote:
The records more than 20,000.In this case i got timeout expired.

Why you are trying to retreive this much of data ? Try to use some filter criteria to minimize the records.

If you have enoung time out, check the process in backend. Where its taking time, Use Breakpoint and Debug to find it out. Or Profile your Query.

One more suggestion, please don't hit database frequently for this. It will impact your Performacne badly. Try to use caching for improve the performance !

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

Re: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Fayu31-Aug-09 6:50

Fayu

31-Aug-09 6:50

Try creating an index on the table columns. that should help increase performance.

Re: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Christian Graus31-Aug-09 14:19

Christian Graus

31-Aug-09 14:19

While that may work, it doesn't address the insanity of a web page asking for 20,000 records...

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

in 3 tier how can we access in asp.net, how can we make object of them.

vaishali.terse31-Aug-09 2:16

vaishali.terse

31-Aug-09 2:16

In Asp.Net 3.5 In One Project 3 solutions are there One is BOl, DAl , Presentation Layer how can access through them. plz send me code.

Re: in 3 tier how can we access in asp.net, how can we make object of them.

Amit Patel198531-Aug-09 2:20

Amit Patel1985

31-Aug-09 2:20

make the object of class of BLL and DAL and use object to call method.

refer following link

Thanks

Re: in 3 tier how can we access in asp.net, how can we make object of them.

Abhijit Jana31-Aug-09 2:48

Abhijit Jana

31-Aug-09 2:48

vaishali.terse wrote:
In Asp.Net 3.5 In One Project 3 solutions are there One is BOl, DAl , Presentation Layer how can access through them.

This is not Only the case of ASP.NET 3.5, this is the normal 3 Tier Architecture for Application Development.
UI/Presentation layer will interact with BAL and BAL will Interact with DAL.

DAL will directly Communicate with Datbase, and BAL should contain the Object of DAL Class. And You should call BAL Object from your UI.

Here is one of the good Example for you,
3-Tier Application with ASP.NET and C#[^]

Hope this will help you Big Grin | :-D

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

calendar popup

ankitjain111031-Aug-09 1:59

ankitjain1110

31-Aug-09 1:59

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page
{
private void calDate_SelectionChanged(object sender, System.EventArgs e)
{
control.Value = calDate.SelectedDate.ToShortDateString();
Response.Write("<script language='javascript'>window.returnValue='" + calDate.SelectedDate.ToString("dd/MM/yyyy") + "';window.close();</script>");
}

protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
private void calDate_SelectionChanged(object sender, System.EventArgs e)
{
control.Value = calDate.SelectedDate.ToShortDateString();
Response.Write("<script language='javascript'>window.returnValue='" + calDate.SelectedDate.ToString("dd/MM/yyyy") + "';window.close();</script>");
}
}
protected void calDate_SelectionChanged1(object sender, EventArgs e)
{
Response.Write("<script language = "javascript">opener.document.getElementById(Request.QueryString["ID"]).value='" + (Calendar1.SelectedDate) + "'; self.close();</script>");
}

}

can anyone help me out wid this code.i just want to generate a popup calendar.
this piece of code is throwing some errors.

i got this code from http://www.codeproject.com/Messages/2246753/calendar-in-popup-window.aspx[^]
plz help me to use this

Re: calendar popup

sashidhar31-Aug-09 2:22

sashidhar

31-Aug-09 2:22

Why Dont You Use Calendar Exrender Controlinstead of script .If this is not your Answer Sorry

Re: calendar popup

ankitjain111031-Aug-09 2:45

ankitjain1110

31-Aug-09 2:45

can u give me some idea of that

Re: calendar popup

Abhijit Jana31-Aug-09 2:54

Abhijit Jana

31-Aug-09 2:54

Can you tell me what is you exact requirment ? Smile | :)

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

Re: calendar popup

ankitjain111031-Aug-09 3:00

ankitjain1110

31-Aug-09 3:00

i want to have a calendar inside a dropdown list or attached to a text box.can u help me

Re: calendar popup

Abhijit Jana31-Aug-09 3:14

Abhijit Jana

31-Aug-09 3:14

Below are the two reference which may help you Smile | :)

Creating a Dropdown Calendar Control for ASP.NET[^]
and
Extending the Calendar Control's Date Navigation [^]

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

Generate xml file from sql server in asp.net

.NET- India 31-Aug-09 1:56

.NET- India

31-Aug-09 1:56

Hello Friends,

I'm generating a xml file from sql table in asp.net(c#). Here is my code given below

using (SqlConnection mCon = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()))
{
mCon.Open();

string strsql = "Select * From MakeTable Where Active=1 For XML Auto,ELEMENTS";
//string strsql = "Select * From MakeTable Where Active=1 ";

SqlCommand mDataCom = new SqlCommand();
mDataCom.Connection = mCon;
mDataCom.CommandText = strsql;
mDataCom.CommandTimeout = 15;

DataSet ds = new DataSet();
XmlReader xmlReader = null;
xmlReader = mDataCom.ExecuteXmlReader();
ds.ReadXml(xmlReader);
ds.DataSetName = "Halo";
ds.WriteXml("F://Manoj//Autoneed/Rough//XMLFile2.xml");
}

but it's giving me output as shown here
<MakeTable>
<MakeID>10</MakeID>
<MakeNameID>36</MakeNameID>
<MakeYear>2009</MakeYear>
<Active>1</Active>
</MakeTable>

but if i run my sql command in sql then it's giving me following records
as shown below

<MakeTable>
<MakeID>1</MakeID>
<MakeNameID>17</MakeNameID>
<MakeYear>2009</MakeYear>
<Active>1</Active>
</MakeTable>
<MakeTable>
<MakeID>3</MakeID>
<MakeNameID>17</MakeNameID>
<MakeYear>2006</MakeYear>
<Active>1</Active>
</MakeTable>
<MakeTable>
<MakeID>4</MakeID>
<MakeNameID>17</MakeNameID>
<MakeYear>2007</MakeYear>
<Active>1</Active>
</MakeTable>
<MakeTable>
<MakeID>5</MakeID>
<MakeNameID>17</MakeNameID>
<MakeYear>2005</MakeYear>
<Active>1</Active>
</MakeTable>
<MakeTable>
<MakeID>7</MakeID>
<MakeNameID>17</MakeNameID>
<MakeYear>2004</MakeYear>
<Active>1</Active>
</MakeTable>

can anybody let me know how can i get this output or where and what change i should make in my code or sqlcommand

Re: Generate xml file from sql server in asp.net

compninja2531-Aug-09 4:31

compninja25

31-Aug-09 4:31

What happens if you try this?

while (xmlReader.Read())
{
ds.ReadXml(xmlReader);
ds.DataSetName = "Halo";
ds.WriteXml("F://Manoj//Autoneed/Rough//XMLFile2.xml");
}

Knowledge is not power, however, the acquisition and appropriate application of knowledge can make you a very powerful individual.

Re: Generate xml file from sql server in asp.net

compninja2531-Aug-09 6:16

compninja25

31-Aug-09 6:16

it didn't dawn on me at first glance that you had a dataset in there...so I don't think the above would work. Since it appears to be coming back from the SQL server correctly, what if you avoided the DataSet all together and just saved it straight to a file?

// create a writer and open the file
TextWriter tw = new StreamWriter("output.xml");


while (datareader.read())
{
// write a line of text to the file
tw.WriteLine(datareader.ToString());
}

// close the stream
tw.Close();

Knowledge is not power, however, the acquisition and appropriate application of knowledge can make you a very powerful individual.

Re: Generate xml file from sql server in asp.net

www.Developerof.NET31-Aug-09 7:28

www.Developerof.NET

31-Aug-09 7:28

Is it mandatory for you to write down the file to the server?????

why don`t you try

ds.GetXml();

But remember to fill you dataset with the data.

which actually returns you a XmlDocument. Debug your code and see what results you get in the document object.

When you fail to plan, you are planning to fail.

Div overlapping

meghamaharshi31-Aug-09 1:38

meghamaharshi

31-Aug-09 1:38

Hi all,
I have div with property

there are some more div below this div in different table i am making its visible on click of link its working in IE 7 but not in IE 8.In IE 8 its not visible properly means not expanding its hidden by below text.

Thanks.

Re: Div overlapping

sashidhar31-Aug-09 1:52

sashidhar

31-Aug-09 1:52

Sorry Dude ? I have div with property ..!What is the Question?

Opacity mask in IE8

vikash_singh31-Aug-09 1:38

vikash_singh

31-Aug-09 1:38

hi friends,

On a web page, when iam clicking a button it is displaying a popup
but i applied prop "Opacity" in CSS to that popup. which is not working. mine IE VERSION IS 8.0. where the same opacity is working fine in mozilla firefox.

Could you help me in ASP.Net.

abglorie31-Aug-09 1:19

abglorie

31-Aug-09 1:19

Sorry for the distrubing. Please give your answer.

Now, I want store a picture in database. Later retrieve the picture
from database and show in a page.

1. Which type of datatype to create in SQL?

and

2. How to retrieve from (picture) data and display on IE.

Please give exact coding.
Thanking you,
abglorie

Re: Could you help me in ASP.Net. [modified]

sashidhar31-Aug-09 1:40

sashidhar

31-Aug-09 1:40

It Is Easy To Store And Retrive the image From Database

1)The DataType In sqlServer Is [image]
2) -->First Store the image in byte format
-->Retrieve the Bytes And Conver the Byte In buffer Stream
-->And Display the image in image Control

To Understand More Clearly You Can Refer the Following Article With Example

http://www.beansoftware.com/asp.net-tutorials/images-database.aspx[^]

http://www.dotnetcurry.com/ShowArticle.aspx?ID=129[^]

Storing and Retrieving Images from SQL Server using Microsoft .NET[^]

http://www.dotnetspider.com/resources/460-Store-Retrieve-SQL-Server-database.aspx[^]

If the Above Is Helpful Mark It As Answer And let Me Know

modified on Monday, August 31, 2009 7:49 AM

Re: Could you help me in ASP.Net.

Abhijit Jana31-Aug-09 3:10

Abhijit Jana

31-Aug-09 3:10

I am agree what sashidhar suggested,

You can do one more thing, rather than sotring image in DB in byte format, store image in your hard drive and store the path in Database.

Retreive the path from database, and display the image from your hard drive. This will make your task simple.

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

how to open filled page which was not saved due to system has shutdown

itsmitm31-Aug-09 1:08

itsmitm

31-Aug-09 1:08

I have a problem , that
see if a user is filling a information page , after filling more then half, suddenly system automatically shuts down. so again user start the system . so is it possible that when he open that page again, it should be half filled from where the system shut down.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.