fields for a table in database - ASP.NET Discussion Boards

Re: Session expired after move a directory

Colin Angus Mackay11-Jun-09 1:06

Colin Angus Mackay

11-Jun-09 1:06

Arindam(Kunal) wrote:
Actually it is required in our project.

Why is it required? What is the overall purpose, not the micro-goal.

Arindam(Kunal) wrote:
Could you please assist us to fix this issue please.

What is the overall task that this directory move fits in to. Understanding the bigger picture will probably result in a better solution all round.

Man who stand on hill with mouth open wait long time for roast duck to drop in

Re: Session expired after move a directory

Arindam(Kunal)11-Jun-09 3:06

Arindam(Kunal)

11-Jun-09 3:06

Hello Colin,

thanks for your reply. Actually I need to rename the directory folder by keeping all the content of that folder as it was.

Thanks,

Arindam

Re: Session expired after move a directory

Colin Angus Mackay11-Jun-09 3:18

Colin Angus Mackay

11-Jun-09 3:18

That does not answer my question. What is the overall goal of what you are trying to do.

Renaming a folder does not bring significant benefits to anyone in and of itself.

What is the content? why does it need to be kept the same? why does the name have to change? What prompts the need to rename the folder? Why is that important?

I'm looking for the big picture. I may not be able to help with this precise issue, but I may be able to help provide a different strategy for achieving the overall goal.

Man who stand on hill with mouth open wait long time for roast duck to drop in

Re: Session expired after move a directory

Abhijit Jana11-Jun-09 1:20

Abhijit Jana

11-Jun-09 1:20

Arindam(Kunal) wrote:
When I move a directory the session gets expiered.

Arindam,
Are you moving directory with in the current ASP.NET application ? if yes then its obvious, because it will recompile the application and will recycle the worker process, causes session expiry.
So please check it.

Thank you !!

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: Session expired after move a directory

Arindam(Kunal)11-Jun-09 3:02

Arindam(Kunal)

11-Jun-09 3:02

Hello Abhijit,

thanks for your reply. But is there any way we can handle the session expired issue?

Thanks

Arindam

Re: Session expired after move a directory

Colin Angus Mackay11-Jun-09 3:20

Colin Angus Mackay

11-Jun-09 3:20

Move the session out of process. That way, when the process is recycled it isn't lost. However, this means that you are going to have to make sure that everything you put in the session is serialisable.

The two main choices for moving the seesion out of process are a state server, or by using SQL State management. Both have slightly different issues which may or may not work for you.

Man who stand on hill with mouth open wait long time for roast duck to drop in

Re: Session expired after move a directory

Abhijit Jana11-Jun-09 3:39

Abhijit Jana

11-Jun-09 3:39

Arindam(Kunal) wrote:
But is there any way we can handle the session expired issue?

Just change the session mode to OutProc and store the Session data either in StateServer or SQL Server.
Hope This article may help you.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

fields for a table in database

sritha11-Jun-09 0:10

sritha

11-Jun-09 0:10

i want to develop a fresher website. i need to post the news for students in home page itself. for that i need to create a table at the backend which is related to news. i included the fields like
news id
title
category
subcategory
author.......................
can you please guide me for some more fields required for news table

Re: fields for a table in database

Christian Graus11-Jun-09 0:17

Christian Graus

11-Jun-09 0:17

This is not even a SQL question. It's a common sense question. Whatever you want to include, put in the table. We don't know your requirements, and if you don't you shouldn't be doing this task.

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Re: fields for a table in database

Abhijit Jana11-Jun-09 0:18

Abhijit Jana

11-Jun-09 0:18

sritha wrote:
i need to post the news for students in home page itself. for that i need to create a table at the backend which is related to news. i included the fields like
news id
title
category
subcategory
author.......................
can you please guide me for some more fields required for news table

which kind of new do you want to show?

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: fields for a table in database

Christian Graus11-Jun-09 0:24

Christian Graus

11-Jun-09 0:24

One without a body, apparently.

Re: fields for a table in database

Robin_Roy11-Jun-09 0:20

Robin_Roy

11-Jun-09 0:20

To make the news module customizable and expandable, you should think of putting in few tables instead of a single table.
NewsCategoryMaster
---------------------
NewsCategoryID (PK)
NewsCategory
NewsParentCategoryID (As Foreign key linking to the NewsCategoryID of the same table)

NewsMasterTable
-------------------
NewsID
NewsCategoryID
Title
Author
NewsDescription
PublishDate
IsActive
IsDeleted

code

sandhya.sa10-Jun-09 23:47

sandhya.sa

10-Jun-09 23:47

i need the ASP.net code for creating a e -library where the books, papers can be uploaded and downloaded.. kindly help me in finding it.. thank u

Re: code

Colin Angus Mackay10-Jun-09 23:49

Colin Angus Mackay

10-Jun-09 23:49

sandhya.sa wrote:
i need the ASP.net code for creating a e -library where the books, papers can be uploaded and downloaded..

Sounds like you are looking for a "Content Management System"

Man who stand on hill with mouth open wait long time for roast duck to drop in

Re: code : Cross Post

Abhijit Jana10-Jun-09 23:53

Abhijit Jana

10-Jun-09 23:53

sandhya.sa wrote:
i need the ASP.net code for creating a e -library where the books, papers can be uploaded and downloaded.. kindly help me in finding it.. thank u

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: code

Christian Graus10-Jun-09 23:57

Christian Graus

10-Jun-09 23:57

IF this is a course, talk to your teacher, you are very lost. If you're teaching yourself, buy a book and read it. If you're charging someone for this code, you are the worst kind of thief, and you should own up, because it's inevitable that this project will end in tears.

code

sandhya.sa10-Jun-09 23:46

sandhya.sa

10-Jun-09 23:46

i need the ASP.net code for creating a library.. kindly help me in finding it.. thank u

Re: code

Abhijit Jana10-Jun-09 23:50

Abhijit Jana

10-Jun-09 23:50

First of all welcome to Code Project.

sandhya.sa wrote:
i need the ASP.net code for creating a library.. kindly help me in finding it.. thank u

Which Library code you want? Is this your Home work?

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: code

saanj10-Jun-09 23:58

saanj

10-Jun-09 23:58

Google is the best guy. Smile | :)

Regards
Saanj

There is no foolish question, there is no final answer...

Re: code

Vasudevan Deepak Kumar11-Jun-09 3:26

Vasudevan Deepak Kumar

11-Jun-09 3:26

sandhya.sa wrote:
kindly help me in finding it

Did you check out Google Maps? That would give you directions to any place on earth now and you can easily find it.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

compare problem

prateekfgiet10-Jun-09 22:32

prateekfgiet

10-Jun-09 22:32

i m using asp.net with c#
i submit some value in database
and then access it
i m trying to do when any fiels contain 0 value then labels visibility should be false.
i m doing like this
cmd.CommandText = "select * from invoice where invoice_no=(Select max(invoice_no) from invoice)";
adp.Fill(ds, "re");
foreach (DataRow dr in ds.Tables["re"].Rows)
{
Label49.Text = dr["invoice_no"].ToString();
Label2.Text = dr["indate"].ToString();
Label9.Text = dr["po_no"].ToString();
Label10.Text = dr["dc_no"].ToString();
Label11.Text = dr["comp_name"].ToString();
Label13.Text = dr["tin_no"].ToString();
Label68.Text = dr["total_vat"].ToString();
Label27.Text = dr["prod1"].ToString();
if (dr["prod2"].ToString() == 0)
{
Label28.Visible = false;
}
else
{
Label28.Text = dr["prod2"].ToString();
}
but it will give error
how i'll do if prod2 contain null or 0 value then label28.visible=false;
plsease help me
thanks in advance

Re: compare problem

Colin Angus Mackay10-Jun-09 22:41

Colin Angus Mackay

10-Jun-09 22:41

prateekfgiet wrote:
Label49.Text

prateekfgiet wrote:
Label68

For the poor bugger (including you in a couple of months time) that will have to maintain this code, please name these things properly. Label49 or Label68 are not an acceptable names.

prateekfgiet wrote:
if (dr["prod2"].ToString() == 0)

You are converting the value to a string, then comparing it with an integer. Why not keep both sides as integers or convert both sides to strings?

Man who stand on hill with mouth open wait long time for roast duck to drop in

Re: compare problem

Leonscape10-Jun-09 22:44

Leonscape

10-Jun-09 22:44

Something like this

if( DBNull.Value.Equals( dr["prod2"] ) || dr["prod2"].ToString() == "0")
    Label28.Visible = false;
else
    Label28.Text = dr["prod2"].ToString();

Using the wrong tool for the job is half the fun.

Re: compare problem

N a v a n e e t h10-Jun-09 22:45

N a v a n e e t h

10-Jun-09 22:45

prateekfgiet wrote:
but it will give error
how i'll do if prod2 contain null or 0 value then label28.visible=false;

Don't call the ToString() before doing a NULL check. Do something like

if (dr["prod2"] != null)
{
    string prod2 = dr["prod2"].ToString();
    Label28.Visible = !(prod2 == "0");
    Label28.Text = prod2;
}

Navaneeth

How to use google | Ask smart questions

Images not getting displayed

scar_face10-Jun-09 21:43

scar_face

10-Jun-09 21:43

Hi,
I am trying to load images in my login page,but they are
not getting displayed.I am also using image button for
images of submit and reset.Tried using ~ but still not
getting displayed.

<asp:Image ID="Image1" runat="server" ImageUrl="~/Images/img snip.jpg" Style="z-index: 100;left: 78px; position: absolute; 
top: 189px" AlternateText="img" />

scarface

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