ASP.NET

10-Sep-14 12:39

Hello friends, I need your help in this issue. Am working on exam system using asp.net. There is a feature I would like to apply. On the onload event of the welcome page, the application should check the devices' date and compare it with the current date. If the devices' date is not same as current date, the person should be redirected to a warning page with a warning message the device date is not accurate. Please set time and date. Example, if the current date is 10-09-2014 and the devices' date is 09-09-2014, that means the devices' date is not accurate. I really need this because the date and time student logged in will be auto-captured and saved to database for officials' use. I have googled alot but couldn't found any match and am not even sure if am using the right keywords. Please, any idea on how to play around this will be highly appreciated.

Ali Al Omairi(Abu AlHassan)10-Sep-14 22:08

10-Sep-14 22:08

I think that you should not use the client date instead use your server date on student login so you would face no problem as the server date appears on the screen.

Help people,so poeple can help you.

Otekpo Emmanuel10-Sep-14 23:23

10-Sep-14 23:23

Thanks. But, how can I capture the server date?

Ali Al Omairi(Abu AlHassan)11-Sep-14 1:29

11-Sep-14 1:29

easily.

When a student logged in you save getdate() which would return the database time. or you pass the value of DateTime.Now for the web server time. and you can do the same for the time you want to send it with the response.

Help people,so poeple can help you.

Otekpo Emmanuel11-Sep-14 3:15

11-Sep-14 3:15

Thanks I really appreciate your response. But, when if I use DateTime.Now, is the client device date that will be captured and the date might not be current. This is what am trying to avoid. To be more specific, assuming today's date now which is 11/09/2014 and maybe the student might not have his device date set(assuming the students' device date is 10/08/2014 instead of 11/09/2014, I want to compare the current date with the device date then if match, student should be allowed else should be prompt for system date correction. Anyway? Please.

Richard Deeming11-Sep-14 3:50

11-Sep-14 3:50

Calling DateTime.Now from server-side code will capture the current date and time on the server. The client's date/time settings will have no effect.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Otekpo Emmanuel11-Sep-14 7:45

11-Sep-14 7:45

Ok. Thanks. But, please how can I call the DateTime.Now on the server side?

Richard Deeming11-Sep-14 7:50

11-Sep-14 7:50

Just add it to the code that's saving the details to the database:

yourInsertCommand.Parameters.AddWithValue("@StartDate", DateTime.Now);

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Otekpo Emmanuel12-Sep-14 12:52

12-Sep-14 12:52

I reset my systems' date to incorrect date and tried what you suggested. But, it was the system's date which is inaccurate it captured. Or will this before solve when the site has been host?

Richard Deeming15-Sep-14 1:49

Performance with loading data to DB2

15-Sep-14 1:49

If you're testing the site locally, the client and server will be the same machine. If you change the client's date, then you're also changing the server's date.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

byka10-Sep-14 2:59

byka

10-Sep-14 2:59

I have .net application which loads data from file into DB2 , Drive iSeries to connect to DB2.
Its running really slow (10,000 rows per 1 hour).
The application is simple doing bunch of inserts/updates. Any idea how I can speed it up?

Re: Performance with loading data to DB2

jkirkerx10-Sep-14 6:46

jkirkerx

10-Sep-14 6:46

I had problems like that last year, but with MySQL.
That's the speed rate I had, about 10K per hour, going from disk drive to database.
I had about 50 sets of data that were over 250K rows each, Some took about 8 hours, others 3 hours.

I ended up buying a new workstation, which cut the time down to about 3 minutes per 10K records, over a network.
This is with a Dell T3600 with a 6 core Xeon CPU. What a difference.

Then there's code optimization.

Load up everything first, then write each record one at a time,
There are a number of ways to go about it, not sure what you choose, you sort of vague there.

Re: Performance with loading data to DB2

thatraja11-Sep-14 2:39

thatraja

11-Sep-14 2:39

Analyze the query & tune. Also check the database table structure.
FYI
Tune That SQL to Improve DB2 Performance[^]
DB2 for z/OS Performance Tuning: the Rising Tide and the Home Run[^]
Best Practices for Optimizing DB2 Performance, A guide for DBA Managers[^]

thatraja

Code converters | Education Needed | Improve Everything^New

Creating three DIVS, left and right fixed , center div scrolls

starlimit038-Sep-14 20:33

starlimit03

8-Sep-14 20:33

Hi everybody,
i would need help on creating a layout just like that of GMail using CSS... there would be three divs, the left and right divs are to be fixed while the middle div should scroll- but with the scroll bar at the right most part of the window{ not within the middle div itself}
I have tried to create somthing similar but all i could end up getting it having the scroll bar within the middle div itself... Frown | :(

any help would be appreciated

Re: Creating three DIVS, left and right fixed , center div scrolls

Ali Al Omairi(Abu AlHassan)8-Sep-14 22:51

Re: Creating three DIVS, left and right fixed , center div scrolls

8-Sep-14 22:51

you mean this layout?

co nt en t co nt en t

content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content
content

co nt en t co nt en t

if so try this code

XML

<div style="width:300px;height:400px;">
    <div style="width:250px;background-color:gray;margin:0 auto;">
        <div style="height:40px;border:dashed 1px blue;"></div>
        <div style="float:left;border:dashed 1px blue;width:22px;">content content content content </div>
        <div style="float:left;border:dashed 1px blue;width:200px;max-height:180px;overflow-y:auto;">content content content content </div>
        <div style="float:left;border:dashed 1px blue;width:22px;">content content content content </div>
        <div style="clear:both;"></div>
    </div>
</div>

and you can also use some jquery solution for scrolling

Help people,so poeple can help you.

Richard Deeming9-Sep-14 2:00

Re: Creating three DIVS, left and right fixed , center div scrolls

9-Sep-14 2:00

Something like this?
http://jsfiddle.net/37moe1oa/[^]

HTML

<style>
#left
{
    width: 200px;
    position: fixed;
    top: 0;
    left: 0;
}
#right
{
    width: 200px;
    position: fixed;
    top: 0;
    right: 0;
}
#middle
{
    margin: 0 200px;
}
</style>

<div id="left">
    Left column content here...
</div>
<div id="middle">
    Middle column content here...
</div>
<div id="right">
    Right column content here...
</div>

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

starlimit039-Sep-14 3:10

starlimit03

9-Sep-14 3:10

thanks a million.... just exactly what i wanted......

[ask] asp.net and IBM DB2

ricardo 308-Sep-14 18:10

ricardo 30

8-Sep-14 18:10

i wanna make a simple form login with asp.net using ibm db2 ...

but i'm still new do not understand about db2 ,

hope someone can help me and give me simple tutorial ..

thanks first ...

Re: [ask] asp.net and IBM DB2

ZurdoDev9-Sep-14 6:54

ZurdoDev

9-Sep-14 6:54

You'll want to find some tutorials or articles on this site for learning ASP.Net and then separately need to learn how to use db2. Once you have something specific you are stuck on let us know.

There are only 10 types of people in the world, those who understand binary and those who don't.

Re: [ask] asp.net and IBM DB2

Sibeesh KV29-Sep-14 1:24

Sibeesh KV

29-Sep-14 1:24

You can see a lot of tutorials in online. here i am sharing one of them. http://www.ibm.com/developerworks/data/library/techarticle/0307swart/0307swart.html[^]

Please up vote if it helped you Smile | :)

Thanks And Regards
Sibeesh

Building OData Web API on the basis of other OData API instead of Database

LiQuick8-Sep-14 0:01

LiQuick

8-Sep-14 0:01

Dear readers,

I have looked around the internet and found loads of tutorials all linking OData Web Api's with Entity Framework support on Databases. But I have a multitude of OData web api's that facilitate the retrieval of data from the backend and I want to supply this data with some additional data manipulation to the outside world.

Is there a tutorial about this somewhere on the web? It can't be that OData WebApi's only exist supplying database data.

Best regards and thanks for your help,
Rémy Samulski

Re: Building OData Web API on the basis of other OData API instead of Database

Nathan Minier8-Sep-14 4:54

Nathan Minier

8-Sep-14 4:54

You can still use the Entity Framework using the ObjectContext rather than a DbContext to still work in a familiar paradigm.

MSDN has a brief tutorial here:
http://msdn.microsoft.com/en-us/library/vstudio/bb738471%28v=vs.100%29.aspx[^]

Re: Building OData Web API on the basis of other OData API instead of Database

LiQuick8-Sep-14 9:39

LiQuick

8-Sep-14 9:39

Dear Nathan Minier,

Thx for the link. At first glance I still don't see the whole picture but will try to figure it out tomorrow. Hopefully the brief tutorial will give me enough keywords and hints to solve this puzzle. Will post any findings.

Thx again,
Rémy

onsubmit event

Ali Al Omairi(Abu AlHassan)7-Sep-14 21:07