Search results for query: *

how to use datediff in my query to get the difference between two time form the table i wrote a query but its may have some errors and not working Select [Date],[TimeIn], [TimeOut], DateDiff(m, TimeIn, TimeOut) as Duration from [dbo].[Logs] WHERE PhoneNo = '"+lblphoneno.text+"'" i am...

sir i am new in here i got an error when i try to search a phone no from the database the error is "conversion from string phoneno to type integer is invalid the phoneno with type nvarchar(11) and the code is Dim Con As SqlConnection = New SqlClient.SqlConnection("Data...

hi i am newbie in knowledge and also beginner in vb.net and it is my second question here i am trying to make a software where users will register and then log on using their id on the sign up form i plced some textboxes to get the user data and through code i successfully create a new user...

hi me new in this forum and got a problem plz tell me how can i add a custom column that is derived form the other two columns of the datagrid view in my datagtidview ther are 4 columns named" User ID, Tate, Time in, Time out" and now i want to add a column named "Duration" which will display...

hi i am developing an application in which i will connect the cell phone using the com port and will fetch some data from the cell phone now i have successfully coded that can detect the comports in the system but i dont understand how to detect the cellphone that is connected on the com port...