Question

vb net binding source绑定data grid view 怎么样保存数据

多次关闭form后数据被清空怎么解决

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励30（财富值+成长值）

Answer 1

Dim conn As SqlDataSource
conn = New SqlDataSource
conn.ConnectionString = "SERVER=;DATABASE=tpb;UID=;PWD="
conn.InsertCommand = "insert into test(ship_date,customer,type,number,po,pn,ad,contact,phone,note,date_time) values('" & ship_date.Text & "','" & customer.Text & "','" & type.Text & "','" & number.Text & "','" & po.Text & "','" & pn.Text & "','" & ad.Text & "','" & contact.Text & "','" & phone.Text & "','" & note.Text & "','" & Now() & "')"
conn.Insert()
MsgBox("ok", MsgBoxStyle.SystemModal)

conn.Dispose()

Answer 2

在form_load重新绑定数据。