|
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
|
|
|
|
|
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?
|
|
|
|
|
One without a body, apparently.
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
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
|
|
|
|
|
i need the ASP.net code for creating a library.. kindly help me in finding it.. thank u
|
|
|
|
|
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?
|
|
|
|
|
Google is the best guy.
Regards
Saanj
There is no foolish question, there is no final answer...
|
|
|
|
|
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!
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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;
}
|
|
|
|
|
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
|
|
|
|
|
scar_face wrote: am trying to load images in my login page,but they are
not getting displayed
Check your image path is valid or not !!
|
|
|
|
|
Right click on the cross image and check the path which is it taking. You can also view the source and check the path from which the image is mapped. It is preferred to set the image path dynamically in the code-behind with the fully qualified virtual path like shown below:
img1.Src = "http://localhost/demoapp/images/img_bak.gif";
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
i had tried givin that path but it dint work ..
scarface
|
|
|
|
|
You have to remove the image path from the image definition in aspx as well. Try to check what is the image url (virtual path) and then paste it into that code. Are you trying it in your localhost or somewhere else? If it is not in localhost then permission can be an issue. Just paste image path that you are specifying in the code, in the browser and check manually whether the image is getting displayed or not.
There is no foolish question, there is no final answer...
|
|
|
|
|
Is it possible that only logged in members have permission to view these images ?
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
|
|
|
|
|
thanks christian.. i think thats the reason..checking on it..
scarface
|
|
|
|
|
hi sir
i have used following code but got same error "the server tag is not well formed".
" width="9px" border="0" src="images/plus.gif"/>
sorry sir
i will keep it mind.i was new in code project so i don't know about how to ask another question of same topic.
i have used following code but got same error "the server tag is not well formed".
alt=<%# "Click to show/hide StatusDetail" + Eval("Item_Code")%> runat ="server" width="9px" border="0" src="images/plus.gif"/>
modified on Thursday, June 11, 2009 5:22 AM
|
|
|
|
|
Please stop creating new threads.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|