Click here to Skip to main content
15,902,939 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Case Sensitive in sqlserver Pin
Vasudevan Deepak Kumar15-Mar-08 4:29
Vasudevan Deepak Kumar15-Mar-08 4:29 
Questionhow i want to make one panel display when first click and hide when second click Pin
bigphish15-Mar-08 0:35
bigphish15-Mar-08 0:35 
AnswerRe: how i want to make one panel display when first click and hide when second click Pin
meghamaharshi15-Mar-08 0:42
meghamaharshi15-Mar-08 0:42 
QuestionCreate a simple custom control [modified] Pin
jinovv14-Mar-08 23:59
jinovv14-Mar-08 23:59 
GeneralRe: Create a simple custom control Pin
Abhijit Jana15-Mar-08 0:12
professionalAbhijit Jana15-Mar-08 0:12 
QuestionHow to bind RadioButtonList in a formview in insert mode. Pin
Trishul Tandel14-Mar-08 23:20
Trishul Tandel14-Mar-08 23:20 
GeneralDatagrid binding into two columns Pin
VanithaVasu14-Mar-08 23:04
VanithaVasu14-Mar-08 23:04 
Generalneed some guggession for speeding up of web page Pin
mohd imran abdul aziz14-Mar-08 22:18
mohd imran abdul aziz14-Mar-08 22:18 
Hi all,
I am using C# , asp.net2.0 , ajax1.0 and sql server 2005.
I am facing problem of slowness of web

http://www.bbraunconnect.co.in/HRMS/DailyCallReport/DCR.aspx
please click on the link ,this link will ask username and password . username is em194 and password is TEST123@

let me explain the problem. you will find subdivision .On its selection product dropdownlist is filled but it is consuming some time on main server(where database and code are not on the same machine ) whereas in test server (where database and code are on the same machine ) it does not consume any time I would like to know how to I speed up the process.
let me explain how I am filling the control
I made one class and defined method as shown below (earlier I tried by making datatable and filling in table but it was taking higher timespan then this )


<code>
public void FillctrlList2(DropDownList ctrl, string procedurename,string fieldtext ,string fieldvalue , string conn, SqlCommand cmd, int i)
{

try
{
if (con == null)
{
this.openconnection(conn);
this.con.Open(); // con.Open();

}
if (con.State == ConnectionState.Closed)
{
this.openconnection(conn);
con.Open();
}
ctrl.Items.Clear();
ctrl.Items.Add(new ListItem("Select One", "0"));
cmd.Connection = con;
cmd.CommandText = procedurename;
cmd.CommandType = CommandType.StoredProcedure;

rdr = cmd.ExecuteReader();

ctrl.DataSource = rdr;
ctrl.DataTextField = fieldtext;
ctrl.DataValueField = fieldvalue;
ctrl.DataBind();

}
catch (Exception ex)
{
throw ex;

}
finally
{
if (rdr != null)
{
rdr.Close();

}
if (con != null)
{
con.Close();
}

}
}


I have web config connection as
&amp;lt;add name="bbraunemisconnectstring" connectionString="Data Source=bindh2,1433;Initial Catalog=bbraun_emis;User ID=sa;Password=LITTLEANGEL" providerName="System.Data.SqlClient"/&amp;gt;



</code>
data is also not much in the table it 500 to 600 and also i am using ajax updatepanel too.

The procedure I am using to fetch the data is
<code>
ALTER PROCEDURE [dbo].[SPGETPRODUCT_GIVENSUB]
(
@SUBCODE VARCHAR(50)
)
AS
SELECT PM_PRD_CODE , PM_PRD_NAME FROM PROD_MASTER WHERE PM_PRD_GR_CODE = @SUBCODE

</code>
please suggest something to decrease time span

regards
imran khan
GeneralRe: need some guggession for speeding up of web page Pin
pmarfleet15-Mar-08 1:32
pmarfleet15-Mar-08 1:32 
Questiondelegate Pin
Pankaj Garg14-Mar-08 21:46
Pankaj Garg14-Mar-08 21:46 
General[Out of Topic] Your signature Pin
Vasudevan Deepak Kumar15-Mar-08 4:27
Vasudevan Deepak Kumar15-Mar-08 4:27 
GeneralTable Merge [modified] Pin
md_refay14-Mar-08 21:02
md_refay14-Mar-08 21:02 
GeneralRe: Table Merge Pin
Abhijit Jana14-Mar-08 21:11
professionalAbhijit Jana14-Mar-08 21:11 
Generalerror as 'Access is denied' in C# ASP.NET web application Pin
Murtuza Husain Miyan Patel14-Mar-08 20:59
professionalMurtuza Husain Miyan Patel14-Mar-08 20:59 
GeneralRe: error as 'Access is denied' in C# ASP.NET web application Pin
Abhijit Jana14-Mar-08 21:06
professionalAbhijit Jana14-Mar-08 21:06 
Questionhow to send attachment to mail in background. Pin
rahul.net1114-Mar-08 20:36
rahul.net1114-Mar-08 20:36 
GeneralRe: how to send attachment to mail in background. Pin
Abhijit Jana14-Mar-08 20:49
professionalAbhijit Jana14-Mar-08 20:49 
GeneralRe: how to send attachment to mail in background. Pin
rahul.net1114-Mar-08 20:54
rahul.net1114-Mar-08 20:54 
GeneralRe: how to send attachment to mail in background. Pin
Abhijit Jana14-Mar-08 20:56
professionalAbhijit Jana14-Mar-08 20:56 
GeneralRe: how to send attachment to mail in background. [modified] Pin
rahul.net1114-Mar-08 21:02
rahul.net1114-Mar-08 21:02 
GeneralRe: how to send attachment to mail in background. Pin
Abhijit Jana14-Mar-08 21:18
professionalAbhijit Jana14-Mar-08 21:18 
GeneralRe: how to send attachment to mail in background. Pin
rahul.net1114-Mar-08 21:27
rahul.net1114-Mar-08 21:27 
GeneralRe: how to send attachment to mail in background.(another code for doc) Pin
rahul.net1114-Mar-08 21:28
rahul.net1114-Mar-08 21:28 
GeneralRe: how to send attachment to mail in background.(another code for doc) Pin
Abhijit Jana14-Mar-08 21:29
professionalAbhijit Jana14-Mar-08 21:29 
GeneralRe: how to send attachment to mail in background.(another code for doc) Pin
rahul.net1114-Mar-08 21:30
rahul.net1114-Mar-08 21:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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