Ограничих таблица на sql база данни с vb форма DataGridView чрез съветника на Visual studio.
Опитах кода по-долу и той се изпълнява успешно и показва съобщение „Актуализирано успешно“, но в действителност не прави никакви промени в SQL база данни. Когато презареждам формуляра, не виждам никакви промени. Аз съм нов във VB.Net и само това нещо ми се съпротивлява да завърша проекта си. Моля, помогнете...Благодаря предварително
Imports System.Data.SqlClient
Public Class FormUpdate
'Variables declared here
Dim Con As New SqlConnection
Dim Cmd As New SqlCommand
Dim ds As DataSet
Dim da As New SqlDataAdapter
Dim cmdString As String
Dim dt As New DataTable
Dim dr As SqlDataReader
Dim cmdbl As New SqlCommandBuilder
Public Sub FormUpdate_Load(sender As Object, e As EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'ShipmentDataSetDataGridView.Shipment_Main' table. You can move, or remove it, as needed.
Me.Shipment_MainTableAdapter2.Fill(Me.ShipmentDataSetDataGridView.Shipment_Main)
'CONNECTION STRING FOR THE DATABASE
Con.ConnectionString = "Data Source=TARIQUE;Initial Catalog=shipment;Integrated Security=True"
End Sub
Private Sub btnUpdate_Click(sender As Object, e As EventArgs) Handles btnUpdate.Click
Try
Con.Open()
cmdbl = New SqlCommandBuilder(da)
da.Update(dt)
MessageBox.Show("Updated successfully!")
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
Con.Close()
End Sub
da
,dt
иCon
. - person S. Adam Nissley   schedule 17.04.2015'To perform search operation by search button Private Sub btnSearch_Click(sender As Object, e As EventArgs) Handles btnSearch.Click dt.Clear() DataGridView1.DataSource = dt DataGridView1.DataSource = Nothing If txtSearch.Text = Nothing Then cmdString = "SELECT * FROM Shipment_Main" da = New SqlDataAdapter(cmdString, Con) da.Fill(dt) DataGridView1.DataSource = dt
- person Muhammad Tarique   schedule 17.04.2015