ASP.NET

Pallavi Bhoite5-Nov-07 1:20

Pallavi Bhoite

5-Nov-07 1:20

Hi Rahul,

can u show me out put here .. as i dont know if u r using distinct blgid it is showing 3 records to u ?

Do u have one record in first table and 3 records in second table with same ids ?

pallavi

rahul.net115-Nov-07 1:43

5-Nov-07 1:43

Hi Pallavi here is my output,

3	Exma tips for student	2007-11-18 17:47:17.000<br />
3	Exma tips for student	2007-11-05 15:56:20.950<br />
11	New blog under Exam Study  tips	2007-11-05 15:54:17.780<br />
12	This is first blog by user Swati.	2007-11-05 12:39:43.123<br />
13	Blog Created on 11/03/2007	2007-11-03 17:15:38.297<br />
14	This is second blog created by Swati on 11/03/2007.	2007-11-03 17:12:24.437<br />
13	Blog Created on 11/03/2007	2007-11-03 16:32:01.293<br />
12	This is first blog by user Swati.	2007-11-03 11:37:26.170<br />
11	New blog under Exam Study  tips	2007-11-02 16:47:43.263<br />
3	Exma tips for student	2007-10-31 14:47:19.107<br />
6	First Blog by NItin	2007-10-30 18:26:12.183<br />
4	New action Movies coming soon	2007-10-29 17:43:20.310<br />
5	Part time jobs	2007-10-29 17:22:20.857<br />
6	First Blog by NItin	2007-10-23 16:01:47.763<br />
5	Part time jobs	2007-10-23 15:21:10.717<br />
1	What are database.	2007-10-20 19:41:14.780<br />
3	Exma tips for student	2007-10-18 17:47:17.000<br />
4	New action Movies coming soon	2007-10-18 17:47:17.000<br />
<br />

People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.

Pallavi Bhoite5-Nov-07 2:11

Pallavi Bhoite

5-Nov-07 2:11

hi,

can u try query like this .. and tell me what is out put now...

select blog_new.blgid,blog_new.blogtitle,blog_new.createddate
from blog_new inner join blog_post on blog_new.blgid = blog_post.blgid and blog_new.status= 1
order by blog_post.editeddate desc

pallavi

rahul.net115-Nov-07 2:52

5-Nov-07 2:52

Hi Pallavi,(sorry for late rply)
I fired query given by u but the result is same.It shows three column
with same id.

Thanks.

People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.

Re: Question releted to sql query. [modified]

Pallavi Bhoite5-Nov-07 3:02

Pallavi Bhoite

5-Nov-07 3:02

Hi rahul,

can u explain me u r table relationship? means is your first table have blogid as primary key and second table with blogid as forgien key?
can u give me few table content of both tables (2, 3 records for both tables)?

pallavi

rahul.net115-Nov-07 3:17

image button in grid view

5-Nov-07 3:17

Hi
My first table name is Blog_New which having
1)blgid- Primery key
2)blgname-
3) blogtitle
4)createddate
5)editeddate
and my second table is
Blog_Post
1)postid- primery key
2)blgid- forein key
3)posttitle
4)posttext
5)createeddate
6)status
7)createddate
8)editeddate

First three columg of my second table is as follow.
first column postid(P.K),second blgid(F.K) and third Posttitle

1 3 Exam tips for 12 std student.(updated)
3 3 This is second post
4 1 This is post for database blog (updated)
5 4 Which are the New action Movie cming this month.
6 3 This is thire post in this blog.
7 5 Part time jobs in Abroad
8 6 How to do timepass.
9 5 Uploading image into Post.
10 4 This is the new image Picture of James 007
11 6 Which is teh best selller book of the year 2007.
12 10 This is my first Post under Sanjay's Blog.
13 3 How to Create a blog.
14 10 This is new post posted on 11/02/2007
15 11 New post under the blog created on 11/02/2007.
16 11 Test for Blog.
17 12 Hi to all i am new here.
18 12 Which are the best natural places in India.
19 13 This is the post in Blog Exam Study tips created on 11/03/2007
20 13 This is second post in Blog Exam Study Tips created on 11/02/2007.
21 14 This is second post in Blog Exam Study Tips created on 11/02/2007.
22 4 This post publish property is set to false.

and first three column of my second table is as follow.
First column blgid(P.K),userid,third blogtitle

1 4 What are database.
2 4 College Financing. and its Adv
3 4 Exma tips for student
4 4 New action Movies coming soon
5 4 Part time jobs
6 7 First Blog by NItin
7 7 Todays best muxic seller Album
8 4 Which is the best field now a dayz?
9 4 Which is the best field now a dayz?
10 4 Sanjay's Blog
11 4 New blog under Exam Study tips
12 10 This is first blog by user Swati.
13 4 Blog Created on 11/03/2007
14 10 This is second blog created by Swati on 11/03/2007.

This is my table structure and its content. Both table contain created
and edited date column.

Thanks.

-- modified at 10:26 Monday 5th November, 2007

-- modified at 10:31 Monday 5th November, 2007

People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.

justintimberlake5-Nov-07 0:19

justintimberlake

5-Nov-07 0:19

Dear all,
i have grid view in which the first column consist of image button which when clicked redirects to new page. In the last column i have a textbox(non data base field) . now what i want is just to display textbox value in new page. how can i do this

rahul.net115-Nov-07 0:24

5-Nov-07 0:24

HI Use OnRowCommand event of gridview and under that event use findcontrol
event to find out your text box. Once you find textbox use text
property to get value in textbox and redirect to second page. Put this
value in session or pass using qhery string.

Hope this help.

Regards.
Rahul.

People Laugh on me Because
i am Different but i Laugh on them Because they all are same.

justintimberlake5-Nov-07 0:57

justintimberlake

5-Nov-07 0:57

Whe thanx very much

justintimberlake5-Nov-07 0:57

justintimberlake

5-Nov-07 0:57

Well thanx very much

rahul.net115-Nov-07 0:59

5-Nov-07 0:59

Welcome.

People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.

delphi

mahenputta4-Nov-07 23:25

mahenputta

4-Nov-07 23:25

is any body who can help me in delphi.. doubts?
thanks
mahen

Pete O'Hanlon4-Nov-07 23:40

Pete O'Hanlon

4-Nov-07 23:40

mahenputta wrote:
doubts

I have lots of doubts that anybody can help you with Delphi here. You did notice that this site is Your Visual Studio and .NET Resource didn't you?

Deja View - the feeling that you've seen this post before.

mahenputta4-Nov-07 23:46

mahenputta

4-Nov-07 23:46

i know.. but many guys.. who are expertise in visual studio.. are also experienced in delphi..

Pete O'Hanlon4-Nov-07 23:59

Pete O'Hanlon

4-Nov-07 23:59

mahenputta wrote:
i know.. but many guys.. who are expertise in visual studio.. are also experienced in delphi..

But surely a Delphi forum would be a better choice. I'm sure that CodeGear/Borland have links to suitable forums.

Deja View - the feeling that you've seen this post before.

mahenputta5-Nov-07 0:04

mahenputta

5-Nov-07 0:04

thanks

Need Help

yazali4-Nov-07 23:17

yazali

4-Nov-07 23:17

Hello,

This is ravikumar.I have a form Default.aspx.
In code behind(Default.aspx.cs) i have a method. Method is

public void Hello()
{
Response.Write("Hellooooooooooo");
}

I have a user control named User1.I have placed User1 on Default.aspx.In User1.ascx i have placed a button named "print".I wrote nothing in User1.ascx.cs;I wanna call Hello() method when i click on Print Button.
plz help me............

ravikumaryazali

N a v a n e e t h4-Nov-07 23:24

N a v a n e e t h

4-Nov-07 23:24

yazali wrote:
Need Help

A meaningful subject will look good

yazali wrote:
;I wanna call Hello() method when i click on Print Button.

I don't think this is a good way to do so ? Why you need to do this ? Have you tried creating an object for that page and calling the Hello() method ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

yazali5-Nov-07 2:43

yazali

5-Nov-07 2:43

yes i tried to create that class object.but it is not allowed.I know this is not good way.In interview this question asked me.try to answer this.

Paddy Boyd5-Nov-07 0:02

Paddy Boyd

5-Nov-07 0:02

You can have your user control raise an event and then have the page handle that event and call Hello.

yazali5-Nov-07 2:44

yazali

5-Nov-07 2:44

i didnt get you?