Naveen Pal - Professional Profile

Action

Author

Authority

Debator

Editor

Enquirer

Organiser

Participant

If Owner

Member Types

Have no restrictions on voting frequency

silver

Bypass spam checks when posting content

silver

gold

SubEditor, Mentor, Protector, Editor

Store personal files in your account area

platinum

SubEditor, Editor

Have live hyperlinks in your profile

bronze

silver

SubEditor, Protector, Editor

Have the ability to include a biography in your profile

bronze

silver

SubEditor, Protector, Editor

Edit a Question in Q&A

silver

Yes

SubEditor, Protector, Editor

Edit an Answer in Q&A

silver

Yes

SubEditor, Protector, Editor

Delete a Question in Q&A

Yes

SubEditor, Protector, Editor

Delete an Answer in Q&A

Yes

SubEditor, Protector, Editor

Report an Article

silver

SubEditor, Mentor, Protector, Editor

Approve/Disapprove a pending Article

gold

SubEditor, Mentor, Protector, Editor

Edit other members' articles

SubEditor, Protector, Editor

Create an article without requiring moderation

platinum

SubEditor, Mentor, Protector, Editor

Approve/Disapprove a pending Question

Protector

Approve/Disapprove a pending Answer

Protector

Report a forum message

silver

bronze

Protector, Editor

Approve/Disapprove a pending Forum Message

Protector

Have the ability to send direct emails to members in the forums

Protector

Create a new tag

silver

Modify a tag

silver

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............ Confused | :confused: