Inserting New Records

[Deepa Balasundaram]

I am using a RadGridView in my application. It is connected to a binding datasoure. I am using the following code to insert new records. I have two database fields called createdon and createdby. I have to insert values to those two fields whenever I insert a new record. How can I achieve that?

 

this

 

.Validate();

 

 

this.substationBindingSource.EndEdit();

 

 

this.db.SubmitChanges();

 

[Eric]

I think you should be able to bring those 2 columns into your Grid(Change your sql to bring those 2 columns) then hide them from the user....

RadGridView1.Columns("CreatedBy").IsVisible = False

Then when a new row is created assign those values:

 

Private Sub RadGridView1_CreateRow(ByVal sender As System.Object, ByVal e As Telerik.WinControls.UI.GridViewCreateRowEventArgs) Handles RadGridView1.CreateRow

 

e.RowInfo.Cells("CreatedBy").Value = "SomePainUser"

End Sub

 

then once you call your submitchanges it should automatically update your underlying database. I have never tried this exact code but it looks like it should work...haha  Hope it helps.

Eric

[Stefan]

Hello,

Thank you for writing. 

I can confirm that Eric's suggestion is the best way to achieve this scenario. 

If you encounter any difficulties implementing it, do not hesitate to contact us.
 
All the best,
Stefan
the Telerik team