|
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
|
|
|
|
|
Try setting commands timeout property to a higher value
|
|
|
|
|
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.
|
|
|
|
|
Try creating an index on the table columns. that should help increase performance.
|
|
|
|
|
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 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.
|
|
|
|
|
make the object of class of BLL and DAL and use object to call method.
refer following link
Thanks
|
|
|
|
|
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 
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
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
|
|
|
|
|
Why Dont You Use Calendar Exrender Controlinstead of script .If this is not your Answer Sorry
|
|
|
|
|
can u give me some idea of that
|
|
|
|
|
Can you tell me what is you exact requirment ? 
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
i want to have a calendar inside a dropdown list or attached to a text box.can u help me
|
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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?
TextWriter tw = new StreamWriter("output.xml");
while (datareader.read())
{
tw.WriteLine(datareader.ToString());
}
tw.Close();
Knowledge is not power, however, the acquisition and appropriate application of knowledge can make you a very powerful individual.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Sorry Dude ? I have div with property ..!What is the Question?
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
