Home » 2012 » February

Archive for February, 2012

Error – The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

Applies to: Microsoft Access Database Engine 2010 Redistributable This download will install a set of components that can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications. Overview This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files […]

Delete confirm message – VB.NET

Delete confirm message when deleting record in GridView <asp:TemplateField> <ItemTemplate> <asp:LinkButton ID=”LinkButton1″ Runat=”server” OnClientClick=”return confirm(‘Are you sure you want to delete this record?’);” CommandName=”Delete”>Delete </ItemTemplate> </asp:TemplateField>

DefaultValue of parameter – alternative method of setting parameter’s value

Set update parameter default value in code behind: Formview …. Meeting Time: <asp:textbox ID=”TimeTextBox” runat=”server” Text=’< %# Bind("Time") %>‘ /> … <updateparameters> <asp:parameter Name=”Time” Type=”String” /> <asp:parameter Name=”Rid” Type=”Int32″ /> </updateparameters> </asp:textbox> Code behind Protected Sub MemberDetailFV_ItemUpdating(ByVal sender As Object, ByVal_ e As System.Web.UI.WebControls.FormViewUpdateEventArgs)_ Handles MemberDetailFV.ItemUpdating_ MemberDetailDS.UpdateParameters(“Time”).DefaultValue = Now() End Sub