Now the current date and time will automatically get inserted with each record and you can eliminate the line of code that sets the date value. thank you keak The GEEK for the help, it really works..=)... The Inserting event occurs before the insert takes place. Sql Data Source Command Event Args)' is inaccessible due to its protection level the source error there highlighted is Line 124: " Line 128: Insert Command="insert into qna(quser, ques, date) values (@quser, @ques, convert(varchar, GETDATE(), 101))" i dont know whats wrong with it.. This post has been edited by keak The GEEK: 22 August 2010 - PM thank you keak The GEEK, i did it.
would you mind me to ask about something about it again? if the @quser parameter, i want to use the system's value. So, for example you could do this: Notice the new On Inserting="On_Inserting" attribute. This post has been edited by de212: 22 August 2010 - AM If changing it to protected doesn't work then try public. after i changed to protected it got a error, there say quser must have a control ID, so i simply assign a textbox for it.. =)..thanks alot for helping so now i can go on my project..
I am using "dbo.aspnet_Users_Delete User" stored procedure to do this action.
Update() End Sub The Day Pilot Month control is placed inside an Update Panel control (Update Panel Calendar). Open() Dim cmd As Sql Command = New Sql Command("UPDATE [event] SET [eventstart] = @start, [eventend] = @end WHERE [id] = @id", con) cmd.
In this example, this time I used my own database called Sample DB which has Customers Table and basically contains the following field columns: As you have noticed in STEP 2, we have added six Text Box and a Button in the web form in order for us to type the information there and Insert them to the database.
Now let’s create a method for executing the Update or Insert.
Protected Sub Button1_Click(By Val sender As Object, By Val e As Event Args) Handles Button1. However, it will be a bit slower because the Update Panel gets fully redrawn.
The Time Range Selected event and Event Click event are handled using Post Back: Using an Update Panel usually makes things easier (you can modify other controls in your Update Panel, such as Labels, Drop Down Lists).