ASP.NET

Grid view showing null columns

6-Aug-09 23:45

This may help you Big Grin | :-D

http://support.microsoft.com/kb/925083[^]

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

LucBite6-Aug-09 21:57

LucBite

6-Aug-09 21:57

I have a data gridview on which I want to display data from a datatable. For some unknown reasons, the datatable returns the expected columns plus other unexpected columns with no values in them.I've checked all of my stored procedures and methods that return the datatable and they seem to be fine. How do I limit the gridview to columns I need to see and restrict the other useless columns from displaying in my grid view? Forgive me if I'm in a wrong forum.

ML Lingwati

Blue_Boy6-Aug-09 22:14

Blue_Boy

6-Aug-09 22:14

If you are using GridView control then use DataBoundFileds,if you are using dataGridView then you should post question in C# forum.

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

Abhijit Jana6-Aug-09 23:11

6-Aug-09 23:11

LucBite wrote:
For some unknown reasons, the datatable returns the expected columns plus other unexpected columns with no values in them.

I guess this is the problem with your SP/ Query that you have written Smile | :)

LucBite wrote:
How do I limit the gridview to columns I need to see and restrict the other useless columns from displaying in my grid view?

You have to check it during RowDataBound Event 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

Hemant Thaker7-Aug-09 1:30

Hemant Thaker

7-Aug-09 1:30

Which are these columns....
Means r u getting same columns twice??

Just see that u haven't added columns at design time and also binding gridview at runtime.

By:
Hemant Thaker

LucBite7-Aug-09 21:18

LucBite

7-Aug-09 21:18

Hemant Thaker wrote:
Which are these columns....
Means r u getting same columns twice??

No I mean, It includes columns returned by other datatables

ML Lingwati

smart window

KhandelwalA6-Aug-09 20:56

KhandelwalA

6-Aug-09 20:56

I m devloping shopping cart website...........and after cart check out i want to show a small window with customers orderid and details..........jst like we saw at many bank websites.....which tool to use...........plz guide me Smile | :)

Abhijit Jana6-Aug-09 21:03

6-Aug-09 21:03

KhandelwalA wrote:
i want to show a small window with customers orderid and details..........jst like we saw at many bank websites....

If you want to show it as popup you can. Else, used some DIV Layer to show it and make it visible true/false based on situation.

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

Abhishek Sur6-Aug-09 21:35

6-Aug-09 21:35

Do you think a window is required at all...

Why dont you show these info in your existing screen?

Rather if you want to show popup, make a popup using floating div as Abhijit said. Design the html such a way that it looks like a window... Rose | [Rose]

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 to.

Manas Bhardwaj6-Aug-09 22:13

Manas Bhardwaj

6-Aug-09 22:13

KhandelwalA wrote:
I m devloping shopping cart website...........

I think everone know this in this forum about this by now.
You should ask your client to pay a part of the fee to CP too. Smile | :)

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Email Receiving in ASP.Net

Blue_Boy6-Aug-09 22:16

Blue_Boy

6-Aug-09 22:16

You can check ModalPopupExtender [^]AJAX control.

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

astrovirgin6-Aug-09 20:52

astrovirgin

6-Aug-09 20:52

Hi All,
My problem is that I have to create an application using asp.net which can send and recieve emails. I have compelted the sending part but i am not finding any way to receive emails. I try lot of googling but didn't find any proper way to do that. Please tell me how it can be possible.

Thanks in advance...

Abhijit Jana6-Aug-09 21:01

6-Aug-09 21:01

astrovirgin wrote:
have compelted the sending part but i am not finding any way to receive emails.

Are you using any special Email Server ?

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

astrovirgin6-Aug-09 21:08

astrovirgin

6-Aug-09 21:08

No... I am using gmail as service provider....

Manas Bhardwaj6-Aug-09 22:16

Manas Bhardwaj

6-Aug-09 22:16

astrovirgin wrote:
I try lot of googling but didn't find any proper way to do that.

First of all, it has nothing to with ASP.Net.

I found these results from Google[^], and the first two of them should give answer to you.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

astrovirgin7-Aug-09 0:01

astrovirgin

7-Aug-09 0:01

Thanks for the all hard work you did for me. But my problem is that I don't want to use any dll or third party tool for do the same. I have to do it only by normal c# coding and if you find something like this, then please tell me.... coz i didn't find it....

clearing cookies on browser close

Arun Jacob6-Aug-09 22:28

Arun Jacob

6-Aug-09 22:28

Just create an application with configurable pop3 and SMTP server just like outlook.Just search google or CodeProject for Pop3Client.You'll get lot of resources for that.

Smile | :)

Arun Jacob
http://codepronet.blogspot.com/

amarnath n.n6-Aug-09 20:37

amarnath n.n

6-Aug-09 20:37

Hi All,
I have one doubt, how to clear the cookies on browser closing in asp.net

Abhishek Sur6-Aug-09 21:25

6-Aug-09 21:25

There is no way to trap Browser close event of the client as per I know.

You can clear cookie during sign off. Rose | [Rose]

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 to.

amarnath n.n6-Aug-09 21:58

amarnath n.n

6-Aug-09 21:58

Thank you for your suggestion but i already did that.I have to do the same in browser close also.

Manas Bhardwaj6-Aug-09 22:17

Manas Bhardwaj

6-Aug-09 22:17

Abhishek Sur wrote:
There is no way to trap Browser close event of the client as per I know.

AFAIK, there is. Smile | :)

Abhishek Sur wrote:
You can clear cookie during sign off

Which sign off? D'Oh! | :doh:

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Abhijit Jana6-Aug-09 22:59

6-Aug-09 22:59

Manas Bhardwaj wrote:
Abhishek Sur wrote:
There is no way to trap Browser close event of the client as per I know.

AFAIK, there is. Smile

Manas, you are correct, I have done this think a quite time before Smile | :)

function CheckBrowserClose()
 {
// Check Browser Close [X] , Alt+F4 , File -> Close 
if(window.event.clientX < 0 && window.event.clientY <0)
 {
      
 }
}

And called it on Body unload 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

Abhishek Sur8-Aug-09 10:23

8-Aug-09 10:23

Hey manas.. Thanks for correcting me. 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 to.

Abhijit Jana6-Aug-09 23:28

6-Aug-09 23:28

Abhishek Sur wrote:
There is no way to trap Browser close event of the client as per I know.

We can

. Check my reply to Manas's post !! 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

Abhishek Sur6-Aug-09 23:35