TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
firas shaar
NA
15
17.8k
question about datetimepicker
Sep 29 2014 6:57 AM
hi
I have created form from insert daily job (date + time )for employees
start time for job is 8:00 AM
and end time for job is 18:00 PM
I have two datetimepicker
datetimepicker1 is called StartTimePicker for start time
datetimepicker2 is called EndTimePicker for end time
in properties for StartTimePicker I set Format= custom and
custom format = 08:00 MM/dd/yyyy
in properties for EndTimePicker I set Format = custom and
custom foramt = 18:00 MM/dd/yyyy
I created the following class for insert rows
public static bool Addtimerow(DateTime starttime, DateTime endtime )
{
bool b;
string strconn = AlShehabi.Properties.Settings.Default.NewSalariesDBConnectionString;
SqlConnection conn = new SqlConnection(strconn);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand("INSERT INTO JobHours(Worker_ID)
Select Worker_ID FROM Workers;", conn);
int i = cmd.ExecuteNonQuery();
if (i <= 0)
b = false;
else
b = true;
conn.Close();
return b;
}
whent btnadd_click event I want to add in JobHours table all workers names and starttime for job (date +time ) and endtime for job
for example
Mark 3/15/2014 08:00 3/15/2014 18:00
Jack 3/15/2014 08:00 3/15/2014 18:00
and so on
when btnadd_click event I wrote
private void btnadd_Click(object sender, EventArgs e)
{
DateTime Start_Work = StartTimePicker.Value;
DateTime End_Work = EndTimePicker.Value;
if (dailyworkerhours.Addtimerow(Start_Work,End_Work))
gridviewjobhours.EndEdit();
}
the code works but my problems is when btnadd_click
workers names is inserted in the gridview without starttime for job and endtime for job
for example
Mark
Jack
how to solve this problem?
Reply
Answers (
1
)
Generate HTTpResponse message from FileStream in .Net4.0 .
how to make specific fields only visible to admin and not fo