Click here to Skip to main content
15,920,005 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionOpening a new window code Pin
netvistal19-Jun-07 15:45
netvistal19-Jun-07 15:45 
AnswerRe: Opening a new window code Pin
Christian Graus19-Jun-07 15:57
protectorChristian Graus19-Jun-07 15:57 
AnswerRe: Opening a new window code Pin
cutequencher19-Jun-07 17:00
cutequencher19-Jun-07 17:00 
AnswerRe: Opening a new window code Pin
koolprasad200319-Jun-07 23:05
professionalkoolprasad200319-Jun-07 23:05 
Questioncan someone please help me to convert a string to time?... tnx!!! Pin
cutequencher19-Jun-07 14:52
cutequencher19-Jun-07 14:52 
AnswerRe: can someone please help me to convert a string to time?... tnx!!! Pin
Christian Graus19-Jun-07 15:24
protectorChristian Graus19-Jun-07 15:24 
AnswerRe: can someone please help me to convert a string to time?... tnx!!! Pin
TwoFaced19-Jun-07 16:11
TwoFaced19-Jun-07 16:11 
GeneralRe: can someone please help me to convert a string to time?... tnx!!! Pin
cutequencher19-Jun-07 16:54
cutequencher19-Jun-07 16:54 
it still doesnt work...
maybe i havent supplied you an enough information...

here's my code... please help me...

Private ds_schedule As New DataSet()

Dim strSQL As String
Dim Connect As New SqlConnection(ConnectionString)

strSQL = "select t.tload_id,t.date_value,convert(char(10),t.start_time,14) start_time,convert(char(10),t.end_time,8) end_time,upper(r.last_name)+', '+r.first_name teacher_name,secondary_teacher_id,datediff(hh,t.start_time,t.end_time)*t.rate totla_rate,t.remarks FROM dbo.ttcpCustomizedSchedule t left outer join dbo.ResourcePersons r on r.teacher_id=t.teacher_id where t.tload_id = " & tload_id.ToString & "order by date_value"

Dim data_adapter As SqlDataAdapter
data_adapter = New SqlDataAdapter(strSQL, Connect)
data_adapter.TableMappings.Add("Table", "ttcpcustomizedschedule")
data_adapter.Fill(ds_schedule)
dtgCustomSched.SetDataBinding(ds_schedule, "ttcpcustomizedschedule")

Dim dateValue As Date
Dim startdate As Date
Dim enddate As Date

row = dtgCustomSched.CurrentRowIndex
dateValue = dtgCustomSched.Item(row, 1)
startdate = Date.ParseExact(dtgCustomSched.Item(row, 2), "HH:mm:ss", Globalization.DateTimeFormatInfo.InvariantInfo)
enddate = Date.ParseExact(dtgCustomSched.Item(row, 3), "HH:mm:ss", Globalization.DateTimeFormatInfo.InvariantInfo)


ConnectionString==my connection that is working properly
dtgCustomSched==the name of my datagrid
ds_schedule==the name of my dataset
dbo.ttcpCustomizedSchedule = table name

i think ther must be something wrong with the interaction of the dataset,datgrid,and data adapter... but i dont know what it is...

thanx!

GeneralRe: can someone please help me to convert a string to time?... tnx!!! Pin
TwoFaced19-Jun-07 19:03
TwoFaced19-Jun-07 19:03 
GeneralRe: can someone please help me to convert a string to time?... tnx!!! Pin
cutequencher19-Jun-07 21:11
cutequencher19-Jun-07 21:11 
GeneralRe: can someone please help me to convert a string to time?... tnx!!! Pin
cutequencher19-Jun-07 21:22
cutequencher19-Jun-07 21:22 
GeneralRe: can someone please help me to convert a string to time?... tnx!!! Pin
TwoFaced20-Jun-07 4:52
TwoFaced20-Jun-07 4:52 
QuestionVB 2005 and Excel Pin
Karma3125119-Jun-07 5:45
Karma3125119-Jun-07 5:45 
AnswerRe: VB 2005 and Excel Pin
MidwestLimey19-Jun-07 6:39
professionalMidwestLimey19-Jun-07 6:39 
GeneralRe: VB 2005 and Excel Pin
koolprasad200319-Jun-07 23:32
professionalkoolprasad200319-Jun-07 23:32 
Questionhow do i send a mail from vb.net? Pin
sathyan_829419-Jun-07 4:50
sathyan_829419-Jun-07 4:50 
AnswerRe: how do i send a mail from vb.net? Pin
Steven J Jowett19-Jun-07 5:08
Steven J Jowett19-Jun-07 5:08 
QuestionTreeview re-order childnodes of same parent VB.net. Pin
.NetRams19-Jun-07 3:19
.NetRams19-Jun-07 3:19 
AnswerRe: Treeview re-order childnodes of same parent VB.net. Pin
Dave Kreskowiak21-Jun-07 3:50
mveDave Kreskowiak21-Jun-07 3:50 
Questionuserdeletingrows event Pin
kermit88819-Jun-07 3:05
kermit88819-Jun-07 3:05 
QuestionProblem with designer in vs.net 2005 pro Pin
Mekong River19-Jun-07 0:06
Mekong River19-Jun-07 0:06 
AnswerRe: Problem with designer in vs.net 2005 pro Pin
Tom Wright19-Jun-07 7:07
Tom Wright19-Jun-07 7:07 
AnswerRe: Problem with designer in vs.net 2005 pro Pin
GoodID19-Jun-07 19:33
GoodID19-Jun-07 19:33 
GeneralRe: Problem with designer in vs.net 2005 pro Pin
Mekong River20-Jun-07 0:28
Mekong River20-Jun-07 0:28 
GeneralRe: Problem with designer in vs.net 2005 pro Pin
GoodID21-Jun-07 17:30
GoodID21-Jun-07 17:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.