Re: is datatable in loop kills the application speed - ASP.NET Discussion Boards

Re: how to give more than one column to the datavalue field of the dropdown field

DotNetXenon31-Dec-07 5:25

31-Dec-07 5:25

You will have to do it on the database side.
SELECT Col1 + ' ' + Col2 as Column FROM Table

When I googled, I found something:
http://easylistbox.com/home.aspx[^]

Can try this.

------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates

Need Tech. support in ASP.NET 2.0.

S R Madhavan30-Dec-07 23:42

S R Madhavan

30-Dec-07 23:42

We need Tech. support in ASP.NET 2.0.

We are developing an alumni portal for our college in ASP.NET 2.0.
We are facing session management problem in our website. We have given an individual session management for alumni people in the site.

Whenever i try to login to the individual session area by providing the right username and password, the session has been immediately terminated and exited from that area with the message of session timed out.

But locally its working normal. I dont know that whether the problem is on the remote server itself or in our web.config file itself.

Here bellow i have given the web.config setting we are using:

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>

<connectionStrings>

<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=SSPI;Initial Catalog=jorya_aspnetdb" />
<add name="sona_alumniConStr" connectionString="server=ipaddress;user id=username;pwd=****;database=sona"
providerName="System.Data.SqlClient" />

</connectionStrings>

<system.web>
<identity impersonate="true"/>
<authorization>
<allow users="*"/>
</authorization>

<pages enableEventValidation="false" viewStateEncryptionMode="Never"/>

<httpHandlers>
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
</httpHandlers>

<compilation debug="false">
<buildProviders>
<add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</buildProviders>
</compilation>

<authentication mode="Windows"/>

<customErrors mode="Off" />

<httpRuntime enableKernelOutputCache="false"/>

<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.0:42424"
sqlConnectionString="Data Source=127.0.0.0;
user id=username;pwd=*****;Trusted_Connection=yes"
cookieless="false"
timeout="20"
/>

One more thing we are checking the individual session user by the following code in each page of that session. the code is below:

<%
if (!(Session["Uname"].Equals(null) || Session["Uname"].Equals("")))
{
%>
Html Statements to display the page.
<%
}
else
{
Response.Redirect(@"..\esctlogin.aspx?alert=Unknown User or Session Timed Out. Try again..");
}

%>

If there is any changes should be made in web.config file, pls inform me.
we are facing this problem since 3months.
we need solution to this.... so pls help me to solve this. pls forward this to your friends to find any solutions.

Thank you for your co-operation and i lookforward to here from you.

Thanks and Regards,
r mohan.

Re: Need Tech. support in ASP.NET 2.0.

Paul Conrad31-Dec-07 12:52

Paul Conrad

31-Dec-07 12:52

This is not a tech support company but a free community.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Problem with UserControl

amin_behzadi30-Dec-07 22:29

amin_behzadi

30-Dec-07 22:29

Hi Dears,
I have using my UserControl inside an updatePanel.
When I build my site on my pc everythings is ok. but when I want to publish website an error occures with this message:
"Cannot create an object of 'System.Int32' from its string representation 'MyUsrCntrl' for the ID property."
I realy don`t know what the problem is...

thx 4 yr Help!

www.behzadi.net

Re: Problem with UserControl

Abhijit Jana31-Dec-07 1:38

Abhijit Jana

31-Dec-07 1:38

is this problem related to date time issue !!! just let me know this Cool | :cool:

Best Regards
-----------------
Abhijit Jana
View My CodeProject Articles

"Success is Journey it's not a destination"

is datatable in loop kills the application speed

jagan12330-Dec-07 21:14

jagan123

30-Dec-07 21:14

iam looping the datatable in loop is this kills the speed of the application?iam assinging this datatabele to the grid view can i loop the grid view for my application

Re: is datatable in loop kills the application speed

Michael Sync30-Dec-07 21:22

Michael Sync

30-Dec-07 21:22

jagadeeshkumar2106 wrote:
iam looping the datatable in loop is this kills the speed of the application?

If your dataset is too large, it might kill the speed of app. Why don't you just bind the gridview instead of looping through ..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

modified on Monday, December 31, 2007 4:01:04 AM

Re: is datatable in loop kills the application speed

N a v a n e e t h30-Dec-07 21:37

N a v a n e e t h

30-Dec-07 21:37

jagadeeshkumar2106 wrote:
iam looping the datatable in loop is this kills the speed of the application?

Filling datatable is costly, usually when you loop through high volume data, application will become slower. This will happen with datatable too. If you need forward only movement, better use DataReader. They are faster.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: is datatable in loop kills the application speed

jagan12330-Dec-07 21:50

jagan123

30-Dec-07 21:50

sir u mean instead datatable to check in loop i have to use datareader

Re: is datatable in loop kills the application speed

N a v a n e e t h30-Dec-07 22:00

N a v a n e e t h

30-Dec-07 22:00

jagadeeshkumar2106 wrote:
i have to use datareader

It would be bit faster. BTW, what is the need to loop through each data ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

please help

Basheer30-Dec-07 21:13

Basheer

30-Dec-07 21:13

I display the data from database in gridview after that i click the row it will display the particular data for every 5 minutes in detailsview.please give us the article

Re: please help

Michael Sync30-Dec-07 21:20

Michael Sync

30-Dec-07 21:20

You can probably reply to the previous thread that you have made. Plus, there are some replies for your questions. You should reply those questions without posting new thread..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: please help

Abhijit Jana31-Dec-07 1:17

Abhijit Jana

31-Dec-07 1:17

use AJAX Timer Control for that

Best Regards
-----------------
Abhijit Jana
View My CodeProject Articles

"Success is Journey it's not a destination"

Re: please help

Paul Conrad31-Dec-07 10:32

Paul Conrad

31-Dec-07 10:32

Be more descriptive in your subject line. "Please help" is very vague.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Image Inserting Pbm

SreejithAchutan30-Dec-07 20:53

SreejithAchutan

30-Dec-07 20:53

I ahve a table for storing some datas.In the table one field is an image upload field.The datatype of that field is image.When i tried to save the image using a fileupload control the image is saved.The code for saving is gioven below.

public void SaveUnitDetails(string UnitName, string UnitShortName, string Location, string UnitLogoPath, string UnitStream, string MaxStudentsPerClass, string CreatedByUser, DateTime CreatedDate)
{
string sqlstatement;
Boolean isSaved;
try
{
sqlstatement = "INSERT INTO Units(UnitName,UnitShortName,Location,UnitLogoPath,UnitStream,MaxStudentsPerClass,CreatedByUser,CreatedDate) VALUES ('" + UnitName + "','" + UnitShortName + "','" + Location + "','" + UnitLogoPath + "','" + UnitStream + "','" + MaxStudentsPerClass + "','" + CreatedByUser + "','" + CreatedDate + "')";
isSaved = dbtObj.ExecuteSqlCmd(sqlstatement);
}
finally
{
}
}

The datas will be bindede into a grid .An image field is bounded on the grid .But the image is same for all rows.What is the pbm.Plz help me.

insunit.SaveUnitDetails(Txt_UnitName.Text, Txt_ShortName.Text, Txt_Location.Text, Upload_Logo.FileName.ToString(), Stream, TxtStdperClass.Text, username, date);

the datas will be saved on a button click event the saved function is called as given above.Plz check the code and help me to overcome the pbm...

DataDridView Have A Footer

Thaer Hamael30-Dec-07 20:47

Thaer Hamael

30-Dec-07 20:47

Hi all
I Wount to add Footer to DataGridView In C#.Net Windows Application
But In Windows Application The DataDridView Dont Have Footer To Add it
I wount to How i can add footer to DataGridView or A new Free Grid Control Have Footer
Thanks For Any Body Help Me Rose | [Rose]

Thaer

Re: DataDridView Have A Footer

Michael Sync30-Dec-07 21:05

Michael Sync

30-Dec-07 21:05

If you want to show the footer of GridView in ASP.NET, you need to check "Show Footer".

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: DataDridView Have A Footer

Sun Rays30-Dec-07 21:06

Sun Rays

30-Dec-07 21:06

Hi,
in window application is there any property like that ?

Michael Sync wrote:
"Show Footer".

I didnt see ever.

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Re: DataDridView Have A Footer

Michael Sync30-Dec-07 21:10

Michael Sync

30-Dec-07 21:10

I wrote "in ASP.NET" in my thread.. As you know, this forum is for ASP.NET question.. not for Window application... So, I'm not gonna answer the window question in web forum..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: DataDridView Have A Footer

Sun Rays30-Dec-07 21:12

Sun Rays

30-Dec-07 21:12

Hi,
oh ok.
But actually he asked for window application..

So we have to guide him to go for window forum..

Cool | :cool:

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Re: DataDridView Have A Footer

Thaer Hamael31-Dec-07 0:22

Thaer Hamael

31-Dec-07 0:22

hi ok i know
but what is problem for this quesion in this Forum
i need any help for this subject in windows application no one can help me
may be in this Forum any one can help me because the members in ther is more jenuse than windows application
thanks Mr Michael

Thaer

Re: DataDridView Have A Footer

Sun Rays30-Dec-07 21:05

Sun Rays

30-Dec-07 21:05

Hey,
check it out..

May be it will help you.

Link[^]

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Can't figure out the error:does not exist in the current context

Albert8330-Dec-07 20:28

Albert83

30-Dec-07 20:28

Hello everybody,

I am getting an error: The name 'DataList1' does not exist in the current context.
DataList1 is a data list the code is in two pages:
Have no idea what the problem is. Any assistance is appreciated.

groups.aspx, and groups.aspx.cs

groups.aspx:

I remobed the open tags so that the code can be seen.

asp:DataList ID="DataList1" runat="server" DataSourceID="ChalkDL">
ItemTemplate>
asp:TextBox ID="postComment" runat="server">
asp:Button runat="server" OnClick="postBtn_Click" ID="postBtn" Text="Post!" />
/ItemTemplate>
/asp:DataList>

groups.aspx.cs
protected void postBtn_Click(object sender, EventArgs e)
{
SqlDataSource PostDS = new SqlDataSource();

System.Web.UI.WebControls.TextBox PostText = (System.Web.UI.WebControls.TextBox)DataList1.FindControl("postComment");

PostDS.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();

PostDS.InsertCommandType = SqlDataSourceCommandType.Text;
PostDS.InsertCommand = "INSERT INTO GroupChalkboard (Text, GroupID, UserID, CreatedDate) VALUES (@Text, @GroupID, @UserID, @CreatedDate)";

PostDS.InsertParameters.Add("Text", PostText.Text);
PostDS.InsertParameters.Add("GroupID", pid.ToString());
PostDS.InsertParameters.Add("UserID", Session["UserID"].ToString());
PostDS.InsertParameters.Add("CreatedDate", DateTime.Now.ToString());

PostDS.Insert();
}

Re: Can't figure out the error:does not exist in the current context

Imran Khan Pathan30-Dec-07 20:57

Imran Khan Pathan

30-Dec-07 20:57

Albert83 wrote:
System.Web.UI.WebControls.TextBox PostText = (System.Web.UI.WebControls.TextBox)DataList1.FindControl("postComment");

This line should be
TextBox PostText=(TextBox)DataList1.Items[IndexHere].FindControl("PostComment");

Albert83 wrote:
I am getting an error: The name 'DataList1' does not exist in the current context.

Can you get DataList1 control in codebehind side?
If no, It should be inherit problem of the page.
Check page directory of groups.aspx and class name of groups.aspx.cs.

please don't forget to vote on the post that helped you.

Re: Can't figure out the error:does not exist in the current context

Albert8330-Dec-07 21:04

Albert83

30-Dec-07 21:04

I can't get the DataList in code behind that's the problem. The weird thing DataList1 does show up in the list and I can choose Items property and find control property. But when I run it, it says DataList1 does not exist in the current context.

How to resolve it ?

That's aspx:
%@ Page Language="C#" AutoEventWireup="true" CodeFile="groups.aspx.cs" Inherits="groups" %>

that's aspx.cs
public partial class groups : System.Web.UI.Page
{

Also

In this code: TextBox PostText=(TextBox)DataList1.Items[IndexHere].FindControl("PostComment");

what's Items[IndexHere] - what index is that. Should I count the number of items in the ItemTemplate?

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