No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hi here is code snippet used temprarily on button to debug. This works but i wish to use the 2nd snippet. 1st snippet Dim connString As New SqlConnection connString.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("sql2008r2_857000_dmcsqlConnectionString").ConnectionString Dim cmd As New SqlCommand("select TOP 1 no from members ORDER BY no DESC", connString) Dim reader As SqlDataReader … |
|
|
Hi insert command works update does not do anything any help Please SqlTimes.InsertCommand = "insert into athletedata([Athlete],[Mydate],[session],[mytime]) values ('" & athletename & "','" & storedate & "','" & todaysession1 & "','" & savetim1 & "') " SqlTimes.Insert() SqlTimes.UpdateCommand = "UPDATE Members SET [Agegrade]=('" & savetim1 & "'where [Fullname]='" & athletename … 
|
|
|
I have a simple sql table with four columns The data types are Athlete nvarchar(30) Mydate date Mytime varchar(8) Session nvarchar(40) Sample Data **Athlete Mydate Mytime Session** Jerry 14/07/2014 00:00:32 200M Jerry 14/07/2014 00:00:31 200M Jerry 16/07/2014 00:00:59 400M Jerry 16/07/2014 00:00:57 400M Jerry 16/07/2014 00:00:58 400M Now what i … 
|