ASP.NET

6-Aug-09 8:05

benams wrote:
where can I get an asp .net based forum?..

You are already in a best ASP.NET Forum. Big Grin | :-D

benams wrote:
where can I get an asp .net based forum?..
It doesn't need to be free...I'm willing to pay for it.

So, you want to develope a ASP.NET Web forum ?
Have a look into it.
Kigg

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: asp.net based forum

Apr^Ngp6-Aug-09 8:46

Apr^Ngp

6-Aug-09 8:46

you need only two controls, gridview and detailsview to design a forum.
Obviously, some database tables, and stored procedures or SQL queries ...

Apurv

“Never trust a computer you can’t throw out a window.”
(Steve Wozniak)

“There are only two industries that refer to their customers as ‘users’.”
(Edward Tufte)

Re: asp.net based forum

Abhishek Sur6-Aug-09 9:41

Abhishek Sur

6-Aug-09 9:41

How about

http://www.dmgforums.com/[^]
it is open source.

Also have a look at
http://www.yetanotherforum.net/[^]

If you want a blog use this:
http://www.dotnetblogengine.net/[^]

Hope this helps. Thumbs Up | :thumbsup:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like t

Datetime problem

greendragons6-Aug-09 7:11

6-Aug-09 7:11

I am creating a site for social gathering as a part of my project...i want that unaccepted friend request should be deleted after 10 days. For this im using current date time and substracting it with the date time selected from database(datetime when friend request was sent)..its giving value of datetime but i just want date part of it not time so that i can convert into int and compare it with 10..if greater than 10 then delete that record..

Abhijit Jana6-Aug-09 7:26

6-Aug-09 7:26

How you are planning for implement it. I will suggest you to forget about to ASP.NET, Implement this part using SQL Server only ( IF your DB is SQL Server ).
Create a SQL Server Job Agent, which will check for some status from DB, if this is unaccepted then delete the request.
Hope you understood what I mean.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

greendragons6-Aug-09 7:30

6-Aug-09 7:30

I have some issues with sql on my vista so unfortunately i have to use ms access.. Frown | :(

Abhijit Jana6-Aug-09 7:48

6-Aug-09 7:48

greendragons wrote:
I have some issues with sql on my vista so unfortunately i have to use ms access..

Why what is the problem, for what you want to move total database to MS-SQL to Access ? OMG | :OMG:

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

greendragons6-Aug-09 8:10

6-Aug-09 8:10

Not moved db..instead i cant find option to open database in sql configuration manager..sql server surface area coniguration and sql server config manager r the only two icons i can see. I cant' find option to create db , add tables n all..i tried hard..even sql express was not working before but anyhow i managed to enable that bt still it shows account login failed..

Abhijit Jana6-Aug-09 8:18

6-Aug-09 8:18

You need SQL Server Management Studio for it. Please Install SSMS. Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

greendragons6-Aug-09 8:16

6-Aug-09 8:16

Do u have yahoo id..i want to solve my some queries..they are headache from long time please..my id is dorian_yates2007@yahoo.co.in

Abhijit Jana6-Aug-09 8:19

6-Aug-09 8:19

greendragons wrote:
Do u have yahoo id..i want to solve my some queries.

You are welcome. Check my ID from my profile Page. Feel free to drop me mail.

Thanks.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

greendragons6-Aug-09 8:28

6-Aug-09 8:28

Sure..but what about my problem is ther anyway that i can get just date part from datetime object..?

Abhijit Jana6-Aug-09 8:34

6-Aug-09 8:34

greendragons wrote:
that i can get just date part from datetime object..?

U are asking for C# or SQL ?
here it for SQL

DECLARE @DateOnly DATETIME<br />
SET @DateOnly = CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS DATETIME)

Details Source : Check

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

greendragons6-Aug-09 8:44

6-Aug-09 8:44

For c#

Abhijit Jana6-Aug-09 8:47

6-Aug-09 8:47

greendragons wrote:
For c#

This is genral syntax.
DateTime.Now.ToShortDateString(); Big Grin | :-D

Some more clarification :

DateTime dt=DateTime.Now;
int year=dt.Year;
int month=dt.Month;
int day=dt.Day;

Hope this will help you Big Grin | :-D

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

greendragons6-Aug-09 8:54

6-Aug-09 8:54

Thnx alot

it's working..
Timespan ko = date1.subtract(dtc);

int day= ko.days;
now i can eaisly check dates THNX!

Abhijit Jana6-Aug-09 8:56

6-Aug-09 8:56

You are welcome ! Wink | ;)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Need help on my Map control application

Blue_Boy6-Aug-09 10:42

Blue_Boy

6-Aug-09 10:42

string dateValue = DateTime.Now.ToString("dd.MM.yyyy");

Just hoping this will helps you more. Smile | :)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

LucBite6-Aug-09 5:01

LucBite

6-Aug-09 5:01

I am developing an asp.net map control application to help people who cannot find their way to their destination when they go to events, any tips on how i can find something similar to google earth in order to make my application functional?

ML Lingwati

Re: Need help on my Map control application

Abhijit Jana6-Aug-09 7:29