ASP.NET Discussion Boards

Re: Want to display based on date...............

RaviJJain26-Mar-07 23:43

RaviJJain

26-Mar-07 23:43

your sql query should like this

<br />
select a.*,b.* from teble1 a, table2 b, <br />
where datedifff(dd,a.carddate,b.leavedate) = 0<br />

Re: Want to display based on date...............

Member 387988127-Mar-07 0:34

Member 3879881

27-Mar-07 0:34

No it willn't work taht much exactly
See once again my pre msg output.........,

Magi

Re: Want to display based on date...............

Imran Khan Pathan27-Mar-07 0:57

Imran Khan Pathan

27-Mar-07 0:57

select CD.*,LD.* from Table1 as CD,Table2 as LD where cd.carddate=ld.leavedate and CD.carddate='"+ inputdate +"' and LD.leavedate='"+ inputdate +"';

I think it will be helpful to u

Best regards

Pathan

GOD HELP THOSE WHO HELP THEMSELVES

Re: Want to display based on date...............

Christian Graus27-Mar-07 2:41

Christian Graus

27-Mar-07 2:41

Please, if you have a question, ask in the correct forum, and no-where else. Don't spam half the site.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

samsonx26-Mar-07 23:18

samsonx

26-Mar-07 23:18

Hi guys i have query....I am login in one page using session and redirect to another page....Now i have to logout from the page...please anyone send me a code for that (Asp.net with c#)

With Regards,
Samson

Re: Login and Logout

_AK_27-Mar-07 0:27

_AK_

27-Mar-07 0:27

You need to clear the session values i.e. the one which you are storing in session and using it to check the login status of the user.

Best Regards,
Apurva Kaushal

Re: Login and Logout

N a v a n e e t h27-Mar-07 0:43

N a v a n e e t h

27-Mar-07 0:43

samsonx wrote:
please anyone send me a code for that (Asp.net with c#)

Session.Remove("yoursessionname");

printf("Navaneeth!!")

www.w3hearts.com

How to validate FTP url ?

cheeken2u26-Mar-07 23:01

cheeken2u

26-Mar-07 23:01

how to check the FTP url is exist or not ?
let said i have ftp://ftp.host.com/folder1/

how i check this FTP Exist or not ?

thanks.

Regards,
Chee ken

Clearing posted data

N a v a n e e t h26-Mar-07 22:53

N a v a n e e t h

26-Mar-07 22:53

I have an ASPX page which contains grid,submit button and textbox. When some one enters text in text box and presses the submit button it will be added to database and will show in grid. All these are working fine. But problem started when I hit refresh button on browser. Suddenly already inserted data added once more. Any way to avoid this ?

printf("Navaneeth!!")

www.w3hearts.com

Re: Clearing posted data

_AK_27-Mar-07 0:07

_AK_

27-Mar-07 0:07

Actually what happens is when the page is getting posted back due to some event then it stores the event which posted back the data so when you clicks refresh then again the same event is getting fired that is why you are getting the same recorded again. I too haven't found a good solution for this problem. What you can do as a workaround is to reload the page again.

Best Regards,
Apurva Kaushal

Re: Clearing posted data

Sandeep Akhare27-Mar-07 0:16

Sandeep Akhare

27-Mar-07 0:16

Strange
How can this ? if you are writing the code in Button click event then this should not happened. I think the data is getting added in datagrid only

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: Clearing posted data

N a v a n e e t h27-Mar-07 0:32

N a v a n e e t h

27-Mar-07 0:32

sandeep akhare wrote:
Strange

It's not..

sandeep akhare wrote:
How can this ? if you are writing the code in Button click event then this should not happened. I think the data is getting added in datagrid only

No, previously posted data will be there and it will repost the data when we press refresh button..

printf("Navaneeth!!")

www.w3hearts.com

Re: Clearing posted data

Sandeep Akhare27-Mar-07 0:35

Sandeep Akhare

27-Mar-07 0:35

OK Can you post the apsx.cs file so that i can learn something if you like

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: Clearing posted data

N a v a n e e t h27-Mar-07 0:41

N a v a n e e t h

27-Mar-07 0:41

sandeep akhare wrote:
OK Can you post the apsx.cs file so that i can learn something if you like

I don't have the code rite now with me., You can try the following scenario.

1. Create one text box, button,and one grid.
2. Write the following in buttons onclick event

button onclick()
{
    //Get textbox value and insert that to DB
    //get the result from db and bind the grid

}

You could see the newly added data on grid. Now press refresh. Browser will show one warning message. Press ok and check the result

printf("Navaneeth!!")

www.w3hearts.com

Re: Clearing posted data

RichardGrimmer27-Mar-07 5:35

RichardGrimmer

27-Mar-07 5:35

Google for Page.IsPostBack....then add appropriately to page_load Smile | :)

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

.NET 2.0 and SQL Server 2000

DanB198326-Mar-07 22:16

DanB1983

26-Mar-07 22:16

Hi
Just wondering if any one can help me on this simple question.

When developing in .NET 2.0 can components such as details view and gridview be used just as they would with SQL Server 2005.

I cannot see why they wouldnt as it is just an SQL Connection but I may be wrong - has any one done this/have any knowledge on this topic?

Thanks

Dan

Re: .NET 2.0 and SQL Server 2000

kubben27-Mar-07 2:54

kubben

27-Mar-07 2:54

Are you questioning why use something like the new sqlDataSource? I was say that the sqldatasource takes you a lot farther with a lot less code with a control like the gridview. Still if you have something simple that you don't need paging you don't need sorting, then yes it might be better to just use a sqlconnection with a sqlcommand doing a dataready to populate your gridview.

Ben

File dialog Box....................

Member 387988126-Mar-07 22:02

Member 3879881

26-Mar-07 22:02

Hi can you plz advice me how to filter file while upload image through webapplication for example when open dialogue box has open you want to show the file type with *.jpg and *.gif the file dialogue box should not show any other file type.

Magi

exporting a crystal report in to Excel format and align and wrap the cells

indian14326-Mar-07 21:58

indian143

26-Mar-07 21:58

Hi all,
I have an asp.net webform which is exporting a crystal report in to Excel format. But what I need is, I would like to format the excel cells so that it should adjust the cell size or wrap the cell according to the data given in it by using VB.Net. If anybody know it pls. advice me or give me some code snippet if possible. Thank you.

Regards,

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

UserName!

nclauder26-Mar-07 21:57

nclauder

26-Mar-07 21:57

I want to Get the name of a user of my web site so I'm using this code but I'm getting errors:
string DomainUser = System.Security.Principal.WindowsIdentity.GetCurrent().Name.Replace("\\","/");
System.DirectoryServices.DirectoryEntry ADEntry = new System.DirectoryServices.DirectoryEntry("WinNT://"+DomainUser);
string Fullname = ADEntry.Properties("FullName").Value;

and the error is:

1:The type or namespace name 'DirectoryServices' does not exist in the class or namespace 'System' (are you missing an assembly reference?)
2:The type or namespace name 'ADEntry' could not be found (are you missing a using directive or an assembly reference?)

What could be the problem?
Thanks.

Re: UserName!

Marcus J. Smith27-Mar-07 3:06

Marcus J. Smith

27-Mar-07 3:06

Imports System.DirectoryServices

I see you are taking some advice from my reply but also noticed that you posted multiple times, please dont do that.

_Cle^aKO

"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)

Re: UserName!

nclauder27-Mar-07 19:29

nclauder

27-Mar-07 19:29

Hi,
Thanks CLEAKO I won't do it again. Yo code Advice worked.
Thanks again.

Check textbox if empty

iamdking26-Mar-07 21:47

iamdking

26-Mar-07 21:47

Hello friends..I have two textboxes on a form accepting url and submit button.when user clicks on submit button, it checks
1) whether the textboxes r empty
2) both textboxes must have same url
3) url must be between 2 to 25 chars..etc
if all these conditions r true then it redirects to another page..
I have taken server controls (textboxes and submit )..and try to write javascript on onclick of that button..but it gives error..like' ")" expected '. what is the easiest way to do that?

Re: Check textbox if empty

varshavmane26-Mar-07 22:05

varshavmane

26-Mar-07 22:05

Post the code...

Re: Check textbox if empty

iamdking27-Mar-07 0:06

iamdking

27-Mar-07 0:06

Is it possible to write javascript on a server control...?

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