ED Controls
New member
- Joined
- Aug 9, 2013
- Messages
- 3
- Programming Experience
- Beginner
using visual studio.net 2002 I have a piece of code that is manually run to update a sql server datbase tableThe line of code looks like this:
Update [005].dbo.TMOHistory set TMOADJ = NULL
[005] = database name, TMOHistory is table in database, TMOADJ is collumn in table.
I would like to create a visual studio.net widowns application that can run this code and update the database. I am a controls guy that works mainly with plc's, so I have limited knowledge of vb.net programming. Is this an easy application to do in visual studio.net? Any help or guidance would be greatly appreicated. So far I am able to connect to the server database (I think) using the code below(EVOLUTION is server name). Not sure where to go after that.
myConn = New SqlConnection("Initial Catalog=005;" & _
'"Data Source=EVOLUTION;Integrated Security=SSPI;")
myConn.Open()
Thanks,
-Erik
Update [005].dbo.TMOHistory set TMOADJ = NULL
[005] = database name, TMOHistory is table in database, TMOADJ is collumn in table.
I would like to create a visual studio.net widowns application that can run this code and update the database. I am a controls guy that works mainly with plc's, so I have limited knowledge of vb.net programming. Is this an easy application to do in visual studio.net? Any help or guidance would be greatly appreicated. So far I am able to connect to the server database (I think) using the code below(EVOLUTION is server name). Not sure where to go after that.
myConn = New SqlConnection("Initial Catalog=005;" & _
'"Data Source=EVOLUTION;Integrated Security=SSPI;")
myConn.Open()
Thanks,
-Erik