|
i'm developing an application for venue booking
i have two datasets ds1, ds2
ds1-contains venue booking information (bookingId, venueId, date, startTime, endTime)
ds2-contains venues information (venueId, name, capacity...etc)
my goal is to display the available venue from user specified date and timeslot(startTime, endTime)
so, the idea is when the venueId exist in ds1, delete the same venueId in ds2 so that it will not be displayed to the user, but my code doesn't seem to work.
any other idea? i'm new to this asp.net thing
|
|
|
|
|
I assume that U R creating the 2 datasets by querying from 2 different tables.
Instead of filtering the ds2, query records for ds2 as needed.
And the query might be:
select * from VenueInfo where VenuID not in
(select VenuID from BookingInfo where <condition to filter based on date> )
The condition might be:
(startTime>userStartTime and startTime<userEndTime)
or ( endTime>userStartTime and endTime<userEndTime)
This condition should check neither the userStartTime nor
the userEndTime fall in the booked range.
Regards,
Arun Kumar.A
|
|
|
|
|
hi,
i don't know tht i've got u right. but i want to give u a hint as far as i've got ur problem.
Man it could be very simple for u.a dataset can hot as many tables as u want.
thts it. go ahead.
|
|
|
|
|
a dataset can hold as many tables as u want.
|
|
|
|
|
I have a username and opassword text boxes and one login button. When I type password it checks three times weather my username and password is correct or not. After 3 failed attempts it gives me message that Notify your administrator.
I used form Authnication. How can I count weather user attempts 3 times. My username and password is stored in database
|
|
|
|
|
Hope this helps U.
In the Page Load event of the Login page
write the following code.
if( username!="xxx" and password!="xxx")
{
if(Session["failCount"]==null)
Session["failcount"]=0;
Session["failcount"]=Int32.Parse(Session["failcount"].ToString())+1;
if(Session["failcount"].ToString()=="4")
Ur code
}
Regards,
Arun Kumar.A
|
|
|
|
|
Add one more feild in your database named lock_flg.If user is entering correct pwd means nothing to do with this lock_flg.Otherwise update lock_flg as one.Each and every time when user enters wrong pwd increment the value of lock_flg and update it.When that lock_flg becomes 3 you wil come to know that user entered wrong pwd 3 times.
|
|
|
|
|
I think this will not work fine.
Consider the scenario:
On Monday he spells wrong password for the first time and
enter correct password in the next time.
The same happens for 3 days.
He cannot log on the next time.
We will have to give provision for making the flag to ZERO
when the user enters right password.
Regards,
Arun Kumar.A
|
|
|
|
|
You are absolutily correct Mr Arun Kumar.We have to update lock_flg as zero when user enters correct pwd.Actually i included that in my project.But i forgot to tell that. Sorry
|
|
|
|
|
Public Function CeProjTrend_Data(ByVal p_projno As String, ByVal p_projest As String())
Dim P_CNSTESTM_CSTTYP_CD As String
Dim n As Integer
Dim Dt_CePT As New DataTable
Dim Sql_CePT As String
Do
Sql_CePT = "select a.CST_TYP_AMT, a.CST_TYP_DT, a.WPWKMIX, a.MANDISDV, b.LOC_1_TXT || b.LOC_2_TXT as LOCATION, C.CNST_ESTM_RSN_CD from IEIT002_CONTESTM a, IEIT003_PROJECT b, IEIT010_CONTESTM_CHNG C where a.CNSTESTM_CSTTYP_CD = " & P_CNSTESTM_CSTTYP_CD & " and a.WPITEM || a.WPITMSEG || a.WPPHAZGP || a.WPPHAZTP || a.FINPRJSQ = " & p_projno & " "
While (p_projest(0) <= p_projest(10))
n = 0
P_CNSTESTM_CSTTYP_CD = p_projest(n)
End While
n = n + 1
Loop
Return Dt_CePT
End Function
|
|
|
|
|
Public Function CeProjTrend_Retrive(ByVal p_wpitem As String, ByVal p_wpitmseg As String, ByVal p_wpphazgp As String, ByVal p_wpphaztp As String, ByVal p_finprjsq As String)
Dim p_projno As String
Dim Dt_ProjEst As New DataTable
Dim p_projest As String()
p_projest = New String() {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}
p_projest(0) = "10"
p_projest(1) = "20"
p_projest(2) = "30"
p_projest(3) = "40"
p_projest(4) = "50"
p_projest(5) = "60"
p_projest(6) = "80"
p_projest(7) = "65"
p_projest(8) = "75"
p_projest(9) = "70"
p_projest(10) = "85"
p_projno = p_wpitem & p_wpitmseg & p_wpphazgp & p_wpphaztp & p_finprjsq
obj = New Construction_Dal
Dt_ProjEst = obj.CeProjTrend_Data(p_projno, p_projest)
Return Dt_CePT
End Function
|
|
|
|
|
dim P_CNSTESTM_CSTTYP_CD as string = ""
for i = 1 to 10
P_CNSTESTM_CSTTYP_CD = p_projest(i)
1+=i
next
|
|
|
|
|
DataRow drow ;
drow = dtloc.NewRow();
drow["locname"] = ((TextBox) tx).ID;
drow["locval"] = ((TextBox) tx).Text;
dtloc.Rows.Add(drow);
|
|
|
|
|
Maybe I missed it, but was there a question in there? My eyes start to burn when they see Visual Basic code. 
--Jesse "... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi
|
|
|
|
|
Jesse Squire wrote: Maybe I missed it, but was there a question in there?
Your eyes are fine (I think). I didn't see a question in there either.
|
|
|
|
|
|
Wow - I only saw his first post, at the bottom of a page. It's worst than I thought. That's an awesome link tho, I've bookmarked that for future reference.
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 )
|
|
|
|
|
What did you expect this to do ? You're incrementing n outside your while loop, so it looks likely to me that it will loop forever. Your SQL is ripe for injection attacks. I don't see how this can work at all, or at least, how it can do anything.
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 )
|
|
|
|
|
Hello,
can someone please tell me, if it is possible (and how) to generate a server-generated-error like "HTTP 404 - File not found" or "HTTP 403.4 - Forbidden: SSL is required to view this resource error" from within a asp.net WebMethod call?
All this exception stuff that I tried, produced a "HTTP 500 Internal server error"
best rgds and thanxxx in advance
the-unforgiven
|
|
|
|
|
Help!!!
How do i give write permissios to a folder through code and whenever not needed i can take away the permissions. How 2 achieve this???
|
|
|
|
|
I'm not an expert on this subject but I think that usually it is not possible because changing a folder permissions require special code permissions that the ASP.NET process doesn't have.
Usually if your web application need to write on a folder you must ask the administrator to manually set the write permissions.
If you use a shared hosting probably you have a control panel to set the permissions on the folder.
Consider also that usually for ASP.NET 2.0 the App_Data directory is already configured with the right write permissions (if configured correctly).
Davide
|
|
|
|
|
Yup, sorry, I'm not gonna be much help either.
Try looking at chmod[^]
Hopefully I'm not stering you in the wrong direction
|
|
|
|
|
Simulate a administrator in your csharp code.
|
|
|
|
|
I am using AJAX UpdatePanel for a GridView. The GridView has serveral row commands. Most of the row commands prefer to have the page staying at the same posistion after the command, except one command. That command will display a panel at the top of the page and the user will do something on the panel. It works fine when the list is short because the user can directly see the panel being displayed. However, when the list is very long, it doesn't work well. The reason is when a user click on that row command, the page still stay at the same position because UpdatePanel only does partial page postback. So the panel being display on the top of page won't be seen by the user.
I think, probablly, to use javascript to reset the page position when that row command is clicked, but I don't know how to do it. Could everybody give me some hints, or does anybody have better ideas to do it?
Thanks in advance!
|
|
|
|
|
Hi Everybody,
Thanks for looking at my topic. I'm completely new to C# ASP.NET, so my question might be too easy.
I'm trying to get current values from the row in the DataGrid, that has Field1, Field2 fields.
I'm doing something like this:
string item = (string)((TextBox) e.Item.FindControl("Field1")).Text; on the update button click event.
I do not want to go through the DataTable, just get the current values from the active row in the DataGrid.
Please help me 
Thanks a lot.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)