Re: Session problem - ASP.NET Discussion Boards

Amit Patel198519-Apr-10 23:10

Amit Patel1985

19-Apr-10 23:10

HI ALL,

I have one requirement

i want to create one grid view in a grid view

first column and row will come from the data base

00:00 - 08:00 | 08:00 - 20:00 | 20:00 24:00 ( this is timing)

feesbydrA want textbox

feesbydrB

feesbydrC

excep these all will be text box where i can mace entry and can save.

Thanks and regards

amit Patel

Re: GRID VIEW ISSUE

Brij19-Apr-10 23:20

Brij

19-Apr-10 23:20

So create your gridview anf if face any problem post your issue

Cheers!!
Brij
Check my latest Article :Exploring ASP.NET Validators

Re: GRID VIEW ISSUE

Amit Patel198519-Apr-10 23:25

Amit Patel1985

19-Apr-10 23:25

i have already created grid view but those text boxes are not coming how to add dynamically template field.

Re: GRID VIEW ISSUE

Brij20-Apr-10 0:14

Brij

20-Apr-10 0:14

Can you post your code snippet?

Cheers!!
Brij
Check my latest Article :Exploring ASP.NET Validators

Re: GRID VIEW ISSUE

Amit Patel198520-Apr-10 0:28

Amit Patel1985

20-Apr-10 0:28

<br />
<asp:gridview ID="Gridview1" runat="server" ShowFooter="true" <br />
        AutoGenerateColumns="false" onrowediting="Gridview1_RowEditing"><br />
<br />
            <Columns><br />
<br />
            <asp:BoundField DataField="RowNumber" HeaderText="Modality" /><br />
<br />
            <asp:TemplateField HeaderText="00:00-08:00"><br />
<br />
            <ItemTemplate><br />
<br />
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
<br />
            </ItemTemplate><br />
<br />
            </asp:TemplateField><br />
<br />
            <asp:TemplateField HeaderText="08:00-20:00"><br />
<br />
            <ItemTemplate><br />
<br />
            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br />
<br />
            </ItemTemplate><br />
<br />
            </asp:TemplateField><br />
<br />
            <asp:TemplateField HeaderText="20:00-24:00"><br />
<br />
            <ItemTemplate><br />
<br />
            <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox><br />
<br />
            </ItemTemplate><br />
<br />
           <%-- <FooterStyle HorizontalAlign="Right" />--%><br />
<br />
           <%-- <FooterTemplate><br />
<br />
            <asp:Button ID="ButtonAdd" runat="server" Text="Add New Row" OnClick ="ButtonAdd_Click" /><br />
<br />
            </FooterTemplate>--%><br />
            </asp:TemplateField><br />
            <br />
            </Columns><br />
<br />
<br />
</asp:gridview><br />
<br />
this function is initializing grid<br />
<br />
   private void SetInitialRow()<br />
    {<br />
        //get list of all modality.<br />
        ReportAction reporting = new ReportAction();<br />
        Int32 userId = Convert.ToInt32(Session["userId"].ToString());<br />
        MySqlDataReader reader = reporting.getModalityList(userId);<br />
        int numberofmodality = 0;<br />
        <br />
        while (reader.Read())<br />
        {<br />
            if (numberofmodality == 0)<br />
            {<br />
                DataTable dt = new DataTable();<br />
<br />
                DataRow dr = null;<br />
<br />
                dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));<br />
<br />
                dt.Columns.Add(new DataColumn("Column1", typeof(string)));<br />
<br />
                dt.Columns.Add(new DataColumn("Column2", typeof(string)));<br />
<br />
                dt.Columns.Add(new DataColumn("Column3", typeof(string)));<br />
<br />
                dr = dt.NewRow();<br />
<br />
                dr["RowNumber"] = reader[1].ToString();<br />
<br />
                dr["Column1"] = string.Empty;<br />
<br />
                dr["Column2"] = string.Empty;<br />
<br />
                dr["Column3"] = string.Empty;<br />
<br />
                dt.Rows.Add(dr);<br />
<br />
                dr = dt.NewRow();<br />
<br />
                //Store the DataTable in ViewState<br />
<br />
                ViewState["CurrentTable"] = dt;<br />
<br />
                Gridview1.DataSource = dt;<br />
                Gridview1.DataBind();<br />
                numberofmodality++;<br />
            }<br />
            else<br />
            {<br />
                //AddNewRowToGrid(reader[1].ToString());<br />
            }<br />
<br />
        }<br />
<br />
    }<br />
<br />
<br />
This function is adding column<br />
<br />
   private void AddNewRowToGrid(string modality)<br />
    {<br />
<br />
        int rowIndex = 0;<br />
<br />
        if (ViewState["CurrentTable"] != null)<br />
        {<br />
<br />
            DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];<br />
<br />
            DataRow drCurrentRow = null;<br />
<br />
            if (dtCurrentTable.Rows.Count > 0)<br />
            {<br />
<br />
                for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)<br />
                {<br />
<br />
                    //extract the TextBox values<br />
                    TemplateField ckhColumn = new TemplateField();<br />
                    <br />
                    TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("TextBox1");<br />
<br />
                    TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("TextBox2");<br />
<br />
                    TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[3].FindControl("TextBox3");<br />
<br />
                    drCurrentRow = dtCurrentTable.NewRow();<br />
<br />
                    drCurrentRow["RowNumber"] = modality;<br />
<br />
                    drCurrentRow["Column1"] = box1.Text;<br />
<br />
                    drCurrentRow["Column2"] = box2.Text;<br />
<br />
                    drCurrentRow["Column3"] = box3.Text;<br />
<br />
                    rowIndex++;<br />
<br />
                }<br />
<br />
                //add new row to DataTable<br />
<br />
                dtCurrentTable.Rows.Add(drCurrentRow);<br />
<br />
                //Store the current data to ViewState<br />
<br />
                ViewState["CurrentTable"] = dtCurrentTable;<br />
<br />
                //Rebind the Grid with the current data<br />
<br />
                Gridview1.DataSource = dtCurrentTable;<br />
<br />
                Gridview1.DataBind();<br />
<br />
            }<br />
<br />
        }<br />
<br />
        else<br />
        {<br />
<br />
            Response.Write("ViewState is null");<br />
<br />
        }<br />
<br />
        //Set Previous Data on Postbacks<br />
<br />
        //SetPreviousData();<br />
<br />
    }<br />
<br />

this is my grid view

i dont want to define template field in code it should come from the database

Re: GRID VIEW ISSUE

Brij20-Apr-10 0:42

Brij

20-Apr-10 0:42

your code is too big.
Have a look to the links.It'll help you
How to create template columns dynamically in a grid view

http://forums.asp.net/t/1294028.aspx<br />
Dynamically Adding Template columns to a GridView

Cheers!!
Brij
Check my latest Article :Exploring ASP.NET Validators

Session problem

SreejithKumar M19-Apr-10 22:21

SreejithKumar M

19-Apr-10 22:21

Hi,

I have developed a web application and created a virtual directory of that application(which is of Windows server 2003).After two weeks i found a problem.

ie when a user login(via virual directory link) i am taking his userid from database(sql 2005) with given userid and password and assigning that userid in session

ie Session["UserId"] = int.Parse(dstLogin.Tables[0].Rows[0]["UserId"].ToString());

then i am checking whether it is null or not
if (Session["UserId"] != null)
{
Response.Redirect("Home.aspx");
}

but in other pages when a user adding some data to database

i am not getting this UserId there.

ie while inserting userid of insering person will also store in database.while designing the table i made that field as "not null".

Not regularly but sometime users are getting an error like this

"Cannot insert userid as null". But most time it works fine

any solution or any idea to prevent this?

Known is a drop, unknown is an ocean

Re: Session problem

Brij19-Apr-10 22:55

Brij

19-Apr-10 22:55

You problem is not very clear. Code is also looking fine .There must be some the data is not retrieved properly and not saved properly in session etc.. Have proper checks at the time saving and retrieving the data.. you'll get the actaul problem

Cheers!!
Brij
Check my latest Article :Exploring ASP.NET Validators

Re: Session problem

SreejithKumar M19-Apr-10 23:12

SreejithKumar M

19-Apr-10 23:12

Hi,

i ve developed an application which is now in testserver.my mates are testing(using the virtal directory link) it by entering data.last 2 week it was fine.but from last day after entering more than 30000 data now they are getting error which is i mentioned above. when i restart or move mouse of that testserver , again it works fine. after 5 mins (i think if there is any slow internet connection) it will raise same error. ive to do same thing again and again.

this is the problem

Known is a drop, unknown is an ocean

Re: Session problem

Brij20-Apr-10 0:14

Brij

20-Apr-10 0:14

This might be problem of slow internet connection. The load is heavy to your server.Do health monitoring of your webserver, you'll get some insight view also can use profiler to know where you can optimize.

Have a look for some performance and health monitoring technique in IIS 6.0
http://www.codeproject.com/KB/aspnet/ExploringIIS.aspx#heading0019Cheers!!
Brij
Check my latest Article :Exploring ASP.NET Validators

how to create a website page ???

3bood.ghzawi19-Apr-10 22:02

3bood.ghzawi

19-Apr-10 22:02

Hi all, i new at asp.net and need to create a website page using asp.net , but i don't know how<<<<<<<<<<<<<<

regards...

Re: how to create a website page ???

Ashfield19-Apr-10 22:37

Ashfield

19-Apr-10 22:37

Well, try searching on CP or google, there are thousands of articles - or go out and buy a book.

Bob
Ashfield Consultants Ltd

Re: how to create a website page ???

Brij19-Apr-10 22:41

Brij

19-Apr-10 22:41

So buy some basic ASP.NET book and study..

Cheers!!
Brij
Check my latest Article :Exploring ASP.NET Validators

Book suggestion & MSDN

David Mujica20-Apr-10 3:21

David Mujica

20-Apr-10 3:21

I like the Wrox books, they give you a good starting point.

Check them out at Amazon:
http://www.amazon.com/ASP-NET-2-0-Instant-Results-Programmer/dp/0471749516/ref=cm_lmf_tit_12[^]

Also checkout MSDN:

MSDN Learn ASP.Net[^]

Urgent need:Onrowediting of Childgrid inside parent grid

anushh19-Apr-10 21:32

anushh

19-Apr-10 21:32

In my project, onrowEditing is inside the childgrid. The parentgrid doesnot have onrowEditing.In this case, is it possible to find the id of childgrid inside onrowEditing method?

Thanks in Advance

Re: Urgent need:Onrowediting of Childgrid inside parent grid

michaelschmitt19-Apr-10 23:19

michaelschmitt

19-Apr-10 23:19

I hope i understand you right.

The row-editing event passes an object as first parameter, its usually named "sender". This
is the grid raising that event. So you could cast that object to the type of your grid and
do anything you want with it. You could also retrieve the id by using YourGrid.ClientID.

rdlc Matrix Web Report

binu77719-Apr-10 18:10

binu777

19-Apr-10 18:10

Dear all,

I have a rdlc report using matrix. The number of columns varies in the runtime as per the data and it is just getting extended to right with horizontal scroll bars. Because of this the report viewing is difficult and printout/export options are also misbehaving. I would like to fit it to a page by limiting the number of columns appearing in a page and showing the balance columns which are yet to be shown (and other related fixed column information) in the next page, so that the report is legible for reading as well as printing/exporting to pdf.

I checked the web and could find out some workarounds only to fix the number of rows per page of the report. Is there any way to fix the number of columns in a matrix report to meet my requirements?

Thanks in advance

Binu

Re: rdlc Matrix Web Report

Sandeep Mewara19-Apr-10 19:02

Sandeep Mewara

19-Apr-10 19:02

First thing is you can change the layout to Landscape for printing.

Now, since you are not aware of number of columns from before, matrix is being used. Thus the column numbers cannot be controlled. Though SSRS itself will display the possible columns in one page and rest in other. (Once the page height/Width & Interactive height/width is properly defined... W:11in & H:8.5in for landscape)

Re: rdlc Matrix Web Report

binu77719-Apr-10 20:25

binu777

19-Apr-10 20:25

Thank you Sandeep for the quick response.

I think, such a requirement is very common and is available in other similar reporting tools like Crystal reports / Oracle report builder. (At least to fix the maximum width of the page so that the remaining columns along with the fixed columns will be spilled to the next page).

All our reports are rdlc's and we would like to standardise the reports in this platform itself. So basically do not want to switch over to Crystal or any other tools. Thats why I am exploring this.

Any other views?

Thanks and regards,
Binu

Doubt on Cookie - asp.net 2.0

Karan_TN19-Apr-10 16:55

Karan_TN

19-Apr-10 16:55

hi,
currently i m using asp.net 2005 (framework 2.0)
i m going to use the cookie for the 1st time in my project (its intranet productivity tool). i need some clarifications...

1. Can we go with Sessions or Cookies? which is best one?
2. If i set cookie expire time as 1 hour, then after 1 hour will it expire? OR every time when user using the application it will retain its time, so that when user didnt work for 1 hour it will get expire? which is right one.
3. Also i want to capture the applications logout time of individual user. so when session expire, can i get those values (say, loginID;team name;department name etc...) and update in my database table?

help me plz - KARAN

Re: Doubt on Cookie - asp.net 2.0 [modified]

Brij19-Apr-10 17:24

Brij

19-Apr-10 17:24

Karan_TN wrote:
1. Can we go with Sessions or Cookies? which is best one?

You can use either one.Better to go for Session because cookies might be disabled at some browser so may not work properly.

Karan_TN wrote:
2. If i set cookie expire time as 1 hour, then after 1 hour will it expire? OR every time when user using the application it will retain its time, so that when user didnt work for 1 hour it will get expire? which is right one.

One need to give specific time to Expiresproperty so it will expire at that time only.So it doesn,t matter whether user works for an hour or not.These are called Persistent cookies, if you set the expires time then it will there in browsers memory and will be removed when one close the browser, these are called <code>Non Persistent cookies</code> and stored on Browser memory while persistent one stored in local hard disk.

for details in Cookies, have a look Beginner's Guide To ASP.NET Cookies

Karan_TN wrote:
Also i want to capture the applications logout time of individual user. so when session expire, can i get those values (say, loginID;team name;department name etc...) and update in my database table?

For this, use session There is two method in Global.asax file one is Session_Start and another is Session_End.Session_Start is called whenevr any new session is getting created and Session_End is called whenever a session ends, so for your requirement you can use Session_End and you can get all those values that you said and can update in datatbase from here only.

Let me know if any issue

Cheers!!
Brij
Check my latest Article :Exploring ASP.NET Validators

modified on Tuesday, April 20, 2010 2:23 AM

Re: Doubt on Cookie - asp.net 2.0

Karan_TN19-Apr-10 18:21

Karan_TN

19-Apr-10 18:21

thanks a lot brij. got cleared with all my doubts. As per your guidance, i will go with sessions itself and take care to remove it at proper place to utilize the memory Smile | :)