|
Hi i am if i have the second date then i will use query.....,
But i dont have second date...........,
Just my input is intime and outtime only...........
with that i want to calculate for night shift work hours..........
see my ques is i have intime(19:45) and outtime(8:53)
so if i use time span then i am getting value (10:59)
but exact answer is (13:08)
i need difference between two times.............
Magi
|
|
|
|
|
then in time of night shift add 24 hours with your outtime
outtime.AddHours(24)
now place your subtraction code
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
"outtime.addhoutrs(24)"exactly its working really thanks lot........,
Magi
|
|
|
|
|
Hi,
You can check whether the second time is smaller than the first time. If it is smaller construct a date (for second time) with 1 days added to the date of the in-time. In this way, you will have these dates-
consider todays date is 1/1/2007
In-time is 19:45
Out-Time is 8:53
Now the Out-time is lesser than in-time, hence your new in and out times will be -
In-Time : 1/1/2007 19:45
Out-Time : 1/2/2007 10:59
Now if you subtract in time from out time, you should get the correct answer.
Note that all the dates are specified in MM/DD/YYYY format. you will have to keep the formats same, since you are going to construct a date from scrap.
Hope you got my logic ?
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
coolestCoder
|
|
|
|
|
Hi,
i am assigning my textbox values to a string builder obj and i am sending that as a body of mail.what my problem is if the text box is multiline i am getting in my body of the mail is a single line with spaces.i want to get that in the exact format what i have written in the multiline textbox.
with regards
Anu
|
|
|
|
|
Dont repost.
Regards,
Satips.
|
|
|
|
|
|
You can delete this post
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
i have a modal dialog,which showing "web page dialog" on the title bar.
how can i change the default title name.
thks
|
|
|
|
|
Convert word doc to pdf
How can I convert a word doc uploaded by the user to a pdf?
How can I store the converted pdf in the database?
am using asp.net 1.1 and vb.net
Nina
|
|
|
|
|
hi,
here is one link of site from where any word doc can converted to pdf. check it out.
http://www.doc2pdf.net/
Thanks,
Sun Rays
|
|
|
|
|
i would first like to apologize for the many question i paste in the forum about providers however i feel that they are different and are importatnt for me >.<
please correct my definition of provider(standard provider and custom provider) if u feel its wrong
my definition of provider is that it will create a database either locally or remitely if the database its looking for does not exist.
and that if i use a custom provider meaning it will create the database depending on how i define it.
above is what i need to know to understand wat a provider is
what i need to know for my project is weather i can configure a custom provider to save username password in a single table(instead of the default 1) which i create(as i only require 1 table for the user information
|
|
|
|
|
hi
i have login form in that i am taking two fields
UserId and Password.
when i enter password in text box after that how can store password in sql databse table in binary format.
In my sql database i take feilds --
CREATE TABLE tUser
(
UserCode NUMERIC(8) NOT NULL
, UserID VARCHAR(20) NOT NULL
, FirstName VARCHAR(40) NOT NULL
, LastName VARCHAR(40) NOT NULL
, Password VARBINARY(60) NOT NULL
, UserType VARCHAR(20) NOT NULL
, ExpireDays NUMERIC(3) NULL
, WarningDays NUMERIC(3) NULL
, StatusCode VARCHAR(1) NOT NULL
, CreatedBy VARCHAR(10) NOT NULL
, CreateDate DATETIME NOT NULL
, UpdatedBy VARCHAR(10) NULL
, UpdateDate DATETIME NULL
, FullName VARCHAR(60) NOT NULL
)
GO
CREATE UNIQUE CLUSTERED INDEX tUser_idx ON tUser (UserCode)
i am new in asp.net so pls give me a code with details.
gayatri
Gayatri
|
|
|
|
|
Dont repost .
Regards,
Satips.
|
|
|
|
|
hi,
whats wrong with you ? why u are posting same post again and again as new post ?
We all are here to help anybody but please take care of this.
Thank if you understand it.
Thanks,
Sun Rays
|
|
|
|
|
Hi,
How to create ASP.Net deployemnt with no source code
JK
|
|
|
|
|
krishnaklm wrote: How to create ASP.Net deployemnt with no source code
Here[ ^] is the Setup for Web Deployment. Good way of web deployment.
Knock out 't' from can't,
You can if you think you can
|
|
|
|
|
Hi friends
My code is:
public class database<br />
{<br />
<br />
public database()<br />
{<br />
}<br />
public static object ExecuteScaler(string constr, string cmdText, params object[] paramValue) {<br />
if (paramValue != null && paramValue.Length > 0)<br />
{<br />
SqlParameter[] cmdParameter = SetParameter(constr, cmdText);<br />
Assignparameter(cmdParameter, paramValue);<br />
SqlConnection con = new SqlConnection(constr);<br />
con.Open();<br />
return ExecuteScaler(con, cmdText, CommandType.StoredProcedure, cmdParameter);<br />
}<br />
else<br />
return ExecuteScaler(constr, cmdText, CommandType.StoredProcedure);<br />
}<br />
<br />
<br />
public static SqlParameter[] SetParameter(string constr, string cmdtext) {<br />
using (SqlConnection con = new SqlConnection(constr))<br />
using (SqlCommand cmd = new SqlCommand(cmdtext, con))<br />
{<br />
con.Open();<br />
cmd.CommandType = CommandType.StoredProcedure;<br />
SqlCommandBuilder.DeriveParameters(cmd);<br />
cmd.Parameters.RemoveAt(0);<br />
SqlParameter[] cmdparameter = new SqlParameter[cmd.Parameters.Count];<br />
cmd.Parameters.CopyTo(cmdparameter, 0);<br />
return cmdparameter;<br />
}<br />
}<br />
<br />
<br />
public static void Assignparameter(SqlParameter[] cmdparameter, object[] ParameterValue)<br />
{<br />
if ((cmdparameter == null) || (ParameterValue == null))<br />
return;<br />
if (cmdparameter.Length != ParameterValue.Length)<br />
throw new ArgumentException("Argument Error");<br />
for (int i = 0, j = cmdparameter.Length; i < j; i++)<br />
cmdparameter[i].Value = ParameterValue[i];<br />
<br />
}<br />
<br />
<br />
public static object ExecuteScaler(SqlConnection con, string cmdtext, CommandType cmdtype, params SqlParameter[] cmdparams) {<br />
SqlCommand cmd = new SqlCommand();<br />
Preparecmd(cmd, con, (SqlTransaction)null, cmdtype, cmdtext, cmdparams);<br />
object retval = cmd.ExecuteScalar();<br />
cmd.Parameters.Clear();<br />
return retval;<br />
<br />
}<br />
<br />
<br />
public static void Preparecmd(SqlCommand cmd, SqlConnection con, SqlTransaction sqlT, CommandType cmdType, string cmdtext, SqlParameter[] cmdParams)<br />
{<br />
if (con.State != ConnectionState.Open)<br />
con.Open();<br />
cmd.Connection = con;<br />
cmd.CommandType = cmdType;<br />
cmd.CommandText = cmdtext;<br />
if (cmdParams != null)<br />
AttachParameter(cmdParams, cmd);<br />
return;<br />
}<br />
<br />
<br />
public static void AttachParameter(SqlParameter[] cmdparamsvalues, SqlCommand cmd)<br />
{<br />
foreach (SqlParameter pp in cmdparamsvalues)<br />
{<br />
if (pp.Direction == ParameterDirection.InputOutput && pp.Value == null)<br />
pp.Value = DBNull.Value;<br />
<br />
cmd.Parameters.Add(pp);
}<br />
<br />
}
Error is: The SqlParameter is already contained by another SqlParameterCollection.
First i cal ExecuteScaler Method.
Plz help me out.
Thanks in advance
Pathan
GOD HELP THOSE WHO HELP THEMSELves
|
|
|
|
|
Imran Khan Pathan wrote: Plz help me out.
The clue is in the error message. You cannot have a SqlParameter in two SqlParameter collections.
I suspect, because I've never used SqlCommandBuilder, that it creates the parameters in a SqlParameterCollection. It does this because it expects you to use the command object it creates, but you throw it away. The parameters are still linked to the collection in which they were originally created.
|
|
|
|
|
Respected Gurus
I m working on asp.net 1.1
I am opening a form through javascript
on this form i have to take two dates from the user.and pass these two dates to the parent page.i m able to pass these dates if i m using textboxes.
but i dont want to use textboxes instead i want to use some calendar
if any one can give some good link for it.
keep in mind that i have to open the window through javascript and those calendars should be on that page itself.
Please suggest me.
|
|
|
|
|
|
thanks for your early response sir
but this does not fulfill my requirement.
my requirement is to open a window from javascript and again open a calendar in that javascript page.Fill the dates and pass these to the parent page.
Ajay
|
|
|
|
|
hi
this is the code <1111a href="javascript:calendar_window=window.open('calendarFORM.aspx?formname=Form1.txtDate','calendar_window','width=154,height=188');calendar_window.focus()">
or
<111a href="javascript:calendar_window=window.open('calendarFORM.aspx?formname=Form1.txtDate','calendar_window','width=154,height=188');calendar_window.focus()"1111/1>
you can try out this code in which txtdate is textbox which will get date from calendar popup
remoove 1111 etc from code
ok...
gs 
|
|
|
|
|
hi
i have login form in that i am taking two fields
UserId and Password.
In my sql database i take feilds --
CREATE TABLE tUser
(
UserCode NUMERIC(8) NOT NULL
, UserID VARCHAR(20) NOT NULL
, FirstName VARCHAR(40) NOT NULL
, LastName VARCHAR(40) NOT NULL
, Password VARBINARY(60) NOT NULL
, UserType VARCHAR(20) NOT NULL
, ExpireDays NUMERIC(3) NULL
, WarningDays NUMERIC(3) NULL
, StatusCode VARCHAR(1) NOT NULL
, CreatedBy VARCHAR(10) NOT NULL
, CreateDate DATETIME NOT NULL
, UpdatedBy VARCHAR(10) NULL
, UpdateDate DATETIME NULL
, FullName VARCHAR(60) NOT NULL
)
GO
CREATE UNIQUE CLUSTERED INDEX tUser_idx ON tUser (UserCode)
then how can encrypt the password.
i am new in asp.net so pls give me a code with details.
gayatri
Gayatri
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
