|
And if the server is unavailable, how do I handle the exception?
|
|
|
|
|
hi i have two tables like want to display based on the date:
eg:
table1:
Id cardDate Intime1 Outtime1
1 12/22/2006 09:00 20:00
2 12/22/2007 09:00 20:00
3 12/22/2006 09:00 13:00
and table 2:
Id leaveDate Intime2 Outtime2
3 12/22/2006 13:00 20:00
4 12/22/2006 09:00 20:00
5 11/11/2006 09:00 20:00
If i select the date 12/22/2006" then it want to display like:
Id Carddate InTime1 Outtime1 Leavedate Intime2 Outtime2
1 12/22/2006 09:00 20:00 null null null
3 12/22/2006 09:00 13:00 12/22/2006 13:00 20:00
4 12/22/2006 09:00 20:00 null null null
I am week in sqlquery,plz hlp me...,
Magi
|
|
|
|
|
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 />
|
|
|
|
|
No it willn't work taht much exactly
See once again my pre msg output.........,
Magi
|
|
|
|
|
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
|
|
|
|
|
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 )
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
samsonx wrote: please anyone send me a code for that (Asp.net with c#)
Session.Remove("yoursessionname");
|
|
|
|
|
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
|
|
|
|
|
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 ?
|
|
|
|
|
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
|
|
|
|
|
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!
|
|
|
|
|
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..
|
|
|
|
|
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!
|
|
|
|
|
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()
{
}
You could see the newly added data on grid. Now press refresh. Browser will show one warning message. Press ok and check the result
|
|
|
|
|
Google for Page.IsPostBack....then add appropriately to page_load 
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
CleaKO
"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)
|
|
|
|
|
Hi,
Thanks CLEAKO I won't do it again. Yo code Advice worked.
Thanks again.
|
|
|
|
|
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?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
