ASP.NET

25-Dec-08 2:02

Hi Everybody,
I need to store a datatable in my page (To bind a grid again after Sorting To be precised)
At present I am storing it in viewstate
My question is will it better to store it in session rather than ViewState(As that Datatable is quite big the page may become quite heavy)???

Abhijit Jana25-Dec-08 2:07

25-Dec-08 2:07

Yes, I will suggest you to store data table in Session , rather than View State as you data size is quite big.
Any way you can check one of my article on view state
Beginner's Guide to View State[^]
And don't forget to read Discussion Section [ViewState Vs Session ]

cheers,
Abhijit

Nishant Singh25-Dec-08 2:19

25-Dec-08 2:19

hi Abhijit,
read the article ...
good one
thanx

Christian Graus25-Dec-08 14:50

Christian Graus

25-Dec-08 14:50

Your best bet if it's big is to store the ids needed to build it, on the URL perhaps, and then get the data from the DB as needed. keeping viewstate down is a good thing, but using the session too much is also a bad move.

Christian Graus

Driven to the arms of OSX by Vista.

Form Authentication using as.net 2.0

Aman Bhullar25-Dec-08 18:15

Aman Bhullar

25-Dec-08 18:15

Hi Nishant

Session v/s Viewstate is quite a good question, but you need to consider two things before you make up your mind.

1. How long you want to retain the DataTable in Memory. i.e. if your site is hosted on shared server then you cannot hold it for more than a 5-10 mins as the services restart and the session is destroyed. So in this case the viewstate is better option. But if you are having dedicated server then opt for session.

2. Why not XML. Create a XML of datatable with unique name, write it to disk and then save the file name in ViewState. You will save both the ViewState and session memory.

sbua24-Dec-08 23:37

sbua

24-Dec-08 23:37

Hi,

Can anyone give me an useful link for form authentication using asp.net 2.0

Thanks

Re: Form Authentication using as.net 2.0

Abhijit Jana24-Dec-08 23:41

24-Dec-08 23:41

sbua wrote:
Can anyone give me an useful link for form authentication using asp.net 2.0

Sure,
This is very good for startup
Using Forms Authentication in ASP.NET [^]
And
Many More[^]

cheers,
Abhijit

how to get the value

R111924-Dec-08 22:17

R1119

24-Dec-08 22:17

Hi,

here is the code:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class MainCategory : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
int y = Convert.ToInt32(Request.QueryString["menu_id"]);

string z = (Request.QueryString["menu_text"]);
string v1 = z.ToUpper();
v1 = v1.Replace(" ", "");
getid();

SqlConnection con = new SqlConnection("Server=.; Database=eclsc; Trusted_Connection=yes");
SqlDataAdapter sda = new SqlDataAdapter("select top 1 "+v1+".image, ID.category_name from "+v1+", ID where where parent_id='"+test1+"' ", con);
DataTable dt = new DataTable();
con.Open();
sda.Fill(dt);
DataView dview = dt.DefaultView;
DataList1.DataSource = dview;
DataList1.DataBind();
con.Close();
}

public void getid()
{
int y = Convert.ToInt32(Request.QueryString["menu_id"]);

SqlConnection con = new SqlConnection("Server=.; Database=eclsc; Trusted_Connection=yes");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = " select category_id from ID where menuindex='" + y + "' ";
con.Open();
string test1 = cmd.ExecuteScalar().ToString();
con.Close();
}

the error is :test1 is not in current context.I want it in page load

Abhijit Jana24-Dec-08 22:33

24-Dec-08 22:33

Its seems , you didn't understand your last answer that what other people given. Sleepy | :zzz:

just do it using View State.

protected void Page_Load(object sender, EventArgs e)<br />
{<br />
if(ViewState["TestVal"] !=null )<br />
<br />
   {<br />
    //Do Something<br />
   }<br />
   else<br />
   {<br />
    //Do Something<br />
    string test=ViewState["TestVal"]<br />
    //bla bla..... your query etc....<br />
    <br />
   }<br />
}

public void getid()
{
int y = Convert.ToInt32(Request.QueryString["menu_id"]);

SqlConnection con = new SqlConnection("Server=.; Database=eclsc; Trusted_Connection=yes");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = " select category_id from ID where menuindex='" + y + "' ";
con.Open();
string test1 = cmd.ExecuteScalar().ToString();
ViewState["TestVal"]=test1;
con.Close();
}

cheers,
Abhijit

Christian Graus24-Dec-08 23:50

Christian Graus

24-Dec-08 23:50

Please, dear God, tell me no-one is paying for this code.

R1119 wrote:
int y = Convert.ToInt32(Request.QueryString["menu_id"]);

This is retarded. Your page will blow up if someone puts a non number on the URL.

Christian Graus

Driven to the arms of OSX by Vista.

Abhijit Jana24-Dec-08 23:57

24-Dec-08 23:57

Christian Graus wrote:
R1119 wrote:
int y = Convert.ToInt32(Request.QueryString["menu_id"]);

-------------------------
Merry Christmas Boss !!

cheers,
Abhijit

Christian Graus25-Dec-08 0:28

Christian Graus

25-Dec-08 0:28

Merry Christmas, have a good one.

Christian Graus

Driven to the arms of OSX by Vista.

Nishant Singh25-Dec-08 2:26

how to get the value of a variable defined in a method, in page load.

25-Dec-08 2:26

return the value of test1 from getid();

public string getid()
{
int y = Convert.ToInt32(Request.QueryString["menu_id"]);

SqlConnection con = new SqlConnection("Server=.; Database=eclsc; Trusted_Connection=yes");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = " select category_id from ID where menuindex='" + y + "' ";
con.Open();
string test1 = cmd.ExecuteScalar().ToString();
con.Close();
return test1;
}

and on page load use

string test1=getid();

SqlConnection con = new SqlConnection("Server=.; Database=eclsc; Trusted_Connection=yes");
SqlDataAdapter sda = new SqlDataAdapter("select top 1 "+v1+".image, ID.category_name from "+v1+", ID where where parent_id='"+test1+"' ", con);
DataTable dt = new DataTable();
con.Open();
sda.Fill(dt);

as simple as that

R111924-Dec-08 21:43

R1119

24-Dec-08 21:43

Hi to all,

I created a method outside the page_load.
Now I want the value of that variable which is defined in the method, in Page_load.

thanks.....

Re: how to get the value of a variable defined in a method, in page load.

Nishant Singh24-Dec-08 21:45

Re: how to get the value of a variable defined in a method, in page load.

24-Dec-08 21:45

either make that Variable Global .....or store it in some Hidden Field

Tamer Oz24-Dec-08 21:52

Tamer Oz

24-Dec-08 21:52

if you are trying to get value in same request then declare member as class level. if you are trying to get value after postbacks try using viewstate.

Re: how to get the value of a variable defined in a method, in page load.

R111924-Dec-08 21:58

R1119

24-Dec-08 21:58

thanks.........

Report opens back the main screen

Member 580612224-Dec-08 19:43

24-Dec-08 19:43

I hv attached the code

window.open(urlstring,'ReportSearch','height=480,width=640,titlebar=no,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no');

i hv called the code in the button click

Ignore : Repost

Abhijit Jana24-Dec-08 19:49

Report opens back to the main screen

24-Dec-08 19:49

Please Don't Cross Post

cheers,
Abhijit

Member 580612224-Dec-08 18:46

24-Dec-08 18:46

I am using asp.net 2005 and crystal report 10.2 version , my problem is when the report opens it is opened behind the main screen .

In my java script i am using window.open() only still it opened back to the main screen . Can any one help me.

Abhijit Jana24-Dec-08 18:53

24-Dec-08 18:53

Can you please put the line of code that you have used for opening reports ?
Thanks in advance !!

cheers,
Abhijit

Member 580612224-Dec-08 19:32

24-Dec-08 19:32

thank u for the reply

This is the code i hv used to open the report

window.open(urlstring,'ReportSearch','height=480,width=640,titlebar=no,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no');

i hv called it in the button click

Abhijit Jana24-Dec-08 19:53

24-Dec-08 19:53

Just try this,

var CrysWind=window.open(---what ever you have written---)<br />
CrysWind.focus()<br />

cheers,
Abhijit

Member 580612224-Dec-08 19:56