ASP.NET

Wanna maintain table state in different function call

11-Dec-08 3:15

double posts

Cheers!!
Brij

joindotnet10-Dec-08 22:41

joindotnet

10-Dec-08 22:41

Hi folks,

I want my datatable to persist through diff function calls, but I can not use static datatable as it not read only. Neither I want to use session coz its an overhead.
Is there any other way to do this...

I know the forum is full of great techies, someone might be kind enough to help.

Re: Wanna maintain table state in different function call

SeMartens10-Dec-08 22:49

Re: Wanna maintain table state in different function call

10-Dec-08 22:49

Hi joindotnet,

what do you want to achieve exactly?

You could store the datatable into a static dictionary, using guids as keys. This guid could be attached to a hidden field, that the web form always transport. I know this is how sessions work, but this is more a lightweight implementation.

<br />
  static Dictionary<guid,> dictTables = new Dictionary<guid,>();<br />
<br />
  public void MyFunction() {<br />
    // get GUID from Hiddenfield<br />
    Guid oGuid = new Guid(this.MyHiddenField.Value);<br />
    DataTable oCurTable = dictTables[oGuid];<br />
  }<br />

Regards
Sebastian

It's not a bug, it's a feature!

Me in Softwareland.

joindotnet10-Dec-08 23:00

joindotnet

10-Dec-08 23:00

Hi Sebastian,

Thanks for ur help.Could u plz tell if I implement this solution my table would not be shared and each user would have her own copy.

Can I have a more detailed description or a link where I can understand the working of dictionary.

I would be so nice of u...

Thanks again

Re: Wanna maintain table state in different function call

SeMartens10-Dec-08 23:18

Re: Wanna maintain table state in different function call

10-Dec-08 23:18

Hi,

for a description of a dictionary have a look here http://msdn.microsoft.com/en-us/library/xfhwa508.aspx[^].

The table itself will not be shared, but the dictionary. You have to be careful by using this because you have to manage (cleanup etc.) all by yourself. Also the static dictionary will only live as long as the IIS-process is running (which will be recycled every 24 hours, am I right?). But why don't you want to use sessions? (The solution I proposed is a kind of self-implemented session).

It's not a bug, it's a feature!

Me in Softwareland.

joindotnet10-Dec-08 23:48

joindotnet

10-Dec-08 23:48

Thanks alot for the link.I ll try this.
I am already using session for the solution but it's making my site very slow as my datatable is very large.
When a user will use it on a dial up connection it would suck him up.
Dossn't session slows the site down??
I mean I don't know I have read it at many places.

Re: Wanna maintain table state in different function call

Paddy Boyd11-Dec-08 0:44

Paddy Boyd

11-Dec-08 0:44

If it is to be for many users (i.e. the same), have you looked at using the .net Cache?

Re: Wanna maintain table state in different function call

Christian Graus10-Dec-08 23:39

Christian Graus

10-Dec-08 23:39

Using the session is the best way to create a per user object. A static variable will be the same for all users.

Christian Graus

Driven to the arms of OSX by Vista.

Re: Wanna maintain table state in different function call

SeMartens11-Dec-08 0:02

Re: Wanna maintain table state in different function call

11-Dec-08 0:02

Hi Christian,

yep you're right, but as I understood the question he wants the datatable to be not the same for all users. Thought using a static dictionary storing the datatables would be a better way...

By the way: Don't know nothing about that the session is slowing down the site. Did you heard something like this before?

Kind regards
Sebastian

It's not a bug, it's a feature!

Me in Softwareland.

Abhijit Jana11-Dec-08 2:42

Abhijit Jana

11-Dec-08 2:42

SeMartens wrote:
Don't know nothing about that the session is slowing down the site

Session store data on server side, so it can causes performance overhead. But Its depends on your data size of session. You can Enable Trace of your page and Check the Session Data Object Size.

Good luck !!!

cheers,
Abhijit
My Recent Article : Beginner's Guide to ASP.NET Application Folder

Re: Wanna maintain table state in different function call

Brij11-Dec-08 3:18

download problem from Secure Sockets Layer enabled site(https) [modified]

11-Dec-08 3:18

You have one more option to use some application variable and if you have to use on same page(if UI page) then you can use viewstate too.

Cheers!!
Brij

DotnetRafi10-Dec-08 22:11

DotnetRafi

10-Dec-08 22:11

download problem from Secure Sockets Layer enabled site(https)

I got error message this
"
internet explorer was not able to open this internet site.this requested site is either unavailable or cannot be found .please try later"

i ca't download file

i am using following code

to download the file

string outputFile = "test 1";
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "inline; filename=test.xls" );
Response.AddHeader("Pragma", "public");
Response.AddHeader("Cache-Control", "max-age=0");
Response.Charset = "";
EnableViewState = false;
Response.Write(outputFile);
Response.End();

it's working normal http site,

in https site it's not working ,means i deployed as Secure Sockets Layer enabled site, error happen

mohamad rafi

modified on Thursday, December 11, 2008 5:25 AM

Re: download problem from Secure Sockets Layer enabled site(https)

SeMartens10-Dec-08 22:50

GridView column value needs to be in Order and sequence

10-Dec-08 22:50

Hi,

could you please provide more information (code etc.), so that we can help you better.

Regards
Sebastian

It's not a bug, it's a feature!

Me in Softwareland.

codingrocks10-Dec-08 21:55

codingrocks

10-Dec-08 21:55

Gridview having some values say column1 have name and column2 have empid. I need to check all this empids and
make sure that they start from 1 and are in order.

No number is missed out in middle. If missed out, then an alert should be shown that saying the order is not proper.

Any help please.....

I have the values in Dataset but, how can i show the alert in asp.net ?

SAJAN A PILLAI

ASP.NET,C#.NET Programmer
BANGALORE

"Winners don't do different things. They do things differently. ...

Re: GridView column value needs to be in Order and sequence

Brij10-Dec-08 22:12

Re: GridView column value needs to be in Order and sequence

10-Dec-08 22:12

For showing an alert you have only option to use Javascript alert you can register it for the alert message and for checking the proper sequence you can check it in RowDataBound event.

Cheers!!
Brij

codingrocks10-Dec-08 22:20

codingrocks

10-Dec-08 22:20

I have tried this code.....can you suggest anything else...

protected void gvCRMODField_RowDataBound(object sender, GridViewRowEventArgs e)
{

GridViewRow gvCRMOD = gvCRMODField.Rows;
if (gvCRMOD.Cells[2].Text != null)
{
///Logic here

}

}

I cannot find any method......please help me....

SAJAN A PILLAI

ASP.NET,C#.NET Programmer
BANGALORE

"Winners don't do different things. They do things differently. ...

Re: GridView column value needs to be in Order and sequence

Brij10-Dec-08 22:42

Re: GridView column value needs to be in Order and sequence

10-Dec-08 22:42

take a varaible in viewstate.increase it one by one and check from the actual value like

object temp = DataBinder.Eval(e.Row.DataItem, "empid");

and check it temp from the viewstate's value if flase register an javascript alert.

Cheers!!
Brij

Christian Graus10-Dec-08 22:29

Christian Graus

10-Dec-08 22:29

sajan ss wrote:
ASP.NET,C#.NET Programmer

This appears increasingly unlikely to me.

If you're telling the user that the data they entered is invalid, you can use a custom validator, or you can use an alert. If you're checking the data in the DB, you can just use a label. Is the user entering data ? If so, just reject data that doesn't follow your rules. Hell, it's fundamentally broken that you have such a rule and you don't just auto generate the ids according to the rule set.

Christian Graus

Driven to the arms of OSX by Vista.

insert image

arnds2007810-Dec-08 20:15

arnds20078

10-Dec-08 20:15

i wont to no ho ican insert image into database sqlserver and retrive in my page

thank you

_AK_10-Dec-08 20:26

_AK_

10-Dec-08 20:26

If you try to search in Google you will get at least 100 articles written on the same.

Apurva Kaushal

Abhijit Jana10-Dec-08 20:42

Abhijit Jana

10-Dec-08 20:42

There is two way, you can store image path on database, or can store image directly in DB.
But How ? Just Try google. You will find lots of codes Smile | :)

cheers,
Abhijit
My Recent Article : Beginner's Guide to ASP.NET Application Folder

Christian Graus10-Dec-08 21:02

Christian Graus

10-Dec-08 21:02

arnds20078 wrote:
wont to no ho ican insert image

I guess it's because you can't spell that you can't use google. Try 'SQL Server store bitmap ASP.NET'

Christian Graus

Driven to the arms of OSX by Vista.

Brij10-Dec-08 21:51

10-Dec-08 21:51

Better if you use imagepath in DB which won't increase the size of database.Check feasibilty according to number of images

Cheers!!
Brij