|
The following code displays the data from the datasource to the form using data grid...................
But wanted to allow update from the datagrid and store the updated data back to the database.....................
Dim oData As New Sanega.Hospital.DataAccess.DataAccess
Dim strsql As String
strsql = " select ID,NAME,LINE_1,LINE_2,STREET,CITY,STATE,COUNTRY,ZI P,PHONE_1,PHONE_2,FAX_1,FAX_2,EMAIL,Discontinued from ENTITY_MASTER,ADDRESS_MASTER,CONTACT_MASTER,DISCON TINUED"
Dim myDataSet As DataSet
myDataSet = oData.ReturnDS(strsql, "ENTITY_MASTER")
DataGrid1.DataSource = myDataSet
Dim tableStyle As New DataGridTableStyle
tableStyle.MappingName = "ENTITY_MASTER"
Dim discontinuedCol As New DataGridBoolColumn
discontinuedCol.MappingName = "Discontinued"
discontinuedCol.HeaderText = ""
discontinuedCol.Width = 30
discontinuedCol.AllowNull = False
tableStyle.GridColumnStyles.Add(discontinuedCol)
Dim column As New DataGridTextBoxColumn
column.MappingName = "ID"
column.HeaderText = "ID"
column.Width = 30
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "NAME"
column.HeaderText = "NAME"
column.Width = 140
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "LINE_1"
column.HeaderText = "LINE_1"
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "LINE_2"
column.HeaderText = "LINE_1"
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "STREET"
column.HeaderText = "STREET"
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "CITY"
column.HeaderText = "CITY"
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "STATE"
column.HeaderText = "STATE"
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "COUNTRY"
column.HeaderText = "COUNTRY"
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "ZIP"
column.HeaderText = "ZIP"
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "PHONE_1"
column.HeaderText = "PHONE1"
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "PHONE_2"
column.HeaderText = "PHONE2"
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "FAX_1"
column.HeaderText = "FAX1"
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "FAX_2"
column.HeaderText = "FAX2"
tableStyle.GridColumnStyles.Add(column)
column = New DataGridTextBoxColumn
column.MappingName = "EMAIL"
column.HeaderText = "EMAIL"
tableStyle.GridColumnStyles.Add(column)
Me.DataGrid1.TableStyles.Add(tableStyle)
But wanted to allow update from the datagrid and store the updated data back to the database.....................
so please tell me the solution ......
if sample codes if possible............
Nabeenpal
-- modified at 6:47 Thursday 12th January, 2006
|
|
|
|