merhaba script ile veri taban\u0131na daya yazmak istiyorum ama ba\u015far\u0131l\u0131 olamad\u0131m a\u015fa\u011f\u0131daki kod ile yapmaya \u00e7ali\u015ft\u0131m
\nDim SQL_cn As New SqlConnection()
\nSQL_cn.ConnectionString = “Server=(local)\\WINTR\\WinTr;uid=sa;pwd=12341234;database=dataproje”
\nSQL_cn.Open()
\nDim SQL_Ins As String
\n‘Set Datetime Format
\nSQL_Ins = “SET DATEFORMAT dmy”
\nDim SQL_date As SqlCommand = New SqlCommand(SQL_Ins, SQL_cn)
\nDim SQL_cmdnon As SqlCommand = New SqlCommand(SQL_Ins, SQL_cn)
\n if tiptag = True Then
\n\ttip = “Sa\u011f”
\n\tElse
\n\ttip= “Sol”
\n\tEnd If
\n\tsonuc=”OK”<\/p>\n
‘Adding data
\nSQL_Ins = “INSERT INTO Table1(LastValue,DateTime,NotSet,tip,sonuc,tork1deger,tork2deger)”
\nSQL_Ins = SQL_Ins & ” VALUES(‘” & Row_Count & “‘,'” & Now & “‘,’0’,'” & tip & “‘,'” & sonuc & “‘,'” & Float_To_String(tork1)& “‘,'” & Float_To_String(tork2) & “‘)”
\nSQL_cmdnon = New SqlCommand(SQL_Ins, SQL_cn)
\nSQL_cmdnon.ExecuteNonQuery()
\n‘Close Database connection
\nSQL_cn.Close()
\n\tkontrol = True
\nCatch ex As Exception
\n‘ messagebox.show(ex.tostring,ex.message)
\n‘ ScriptError = ex.message<\/p>\n
End Try
\n\t‘——- Script End Line ——-<\/p>\n
\tEnd Sub
\nFunction Float_To_String(Byval Sayi as Single)
\nreturn\tSayi.ToString(“G”, CultureInfo.CreateSpecificCulture(“en-US”))
\nEnd Function<\/p>\n
End Class
\nEnd Namespace<\/p>\n","protected":false},"excerpt":{"rendered":"
merhaba script ile veri taban\u0131na daya yazmak istiyorum ama ba\u015far\u0131l\u0131 olamad\u0131m a\u015fa\u011f\u0131daki kod ile yapmaya \u00e7ali\u015ft\u0131m Dim SQL_cn As New SqlConnection() SQL_cn.ConnectionString = “Server=(local)\\WINTR\\WinTr;uid=sa;pwd=12341234;database=dataproje” SQL_cn.Open() Dim SQL_Ins As String ‘Set Datetime Format SQL_Ins = “SET DATEFORMAT dmy” Dim SQL_date As SqlCommand = New SqlCommand(SQL_Ins, SQL_cn) Dim SQL_cmdnon As SqlCommand = New SqlCommand(SQL_Ins, SQL_cn) if tiptag […]<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_swpsp_post_exclude":false,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-456","post","type-post","status-publish","format-standard","hentry","category-scada-sql-server"],"yoast_head":"\n