You searched for the word(s): userid:874924

More Search Options

RSS Available

• Re: Problems with date format in Access 2007

  got mine working too thanks for the help did the following. Imports System.Data.OleDb Imports System.Data Partial Class Members_Admin_AddEvent Inherits System.Web.UI.Page Protected Sub DropDownOFirstName_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownOFirstName.DataBound DropDownOFirstName.Items.Insert(0, "Please Select Member") End Sub Protected Sub DropDownDMFirstName_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownDMFirstName

  Posted to Access Databases and AccessDataSource Control (Forum) by Hanwell on 9/14/2009

• Re: Date Format Different on Update

  I have set the Web Config with <globalization culture="en-GB"/> and i lets me put in a textbox 31/12/2009 dd/mm/yyyy But if I enter in 03/04/2009 it swaps the date in the database to 04/03/2009 why is it doing that and how do i controll it

  Posted to Access Databases and AccessDataSource Control (Forum) by Hanwell on 9/13/2009

• Re: Date Format Different on Update

  hello you doing know where i can read up on globalization? Some tutorials etc would be helpful.

  Posted to Access Databases and AccessDataSource Control (Forum) by Hanwell on 9/12/2009

• Re: Access Queries or Build New SQL ones?

  Thanks for the reply I just sticking with building the qurrys in the manager in Visual Studio. I still new to this and learning Visual Basic.net along side this. Just one last question I have an addressline1 addressline2 and town fields in my database i have concatenated them Addressline1&' '&Addressline2&' '&Town but I want the fields to be on new line. i have tried Addressline1&'<br/> '&Addressline2&'<br/> '&Town but it

  Posted to Getting Started (Forum) by Hanwell on 9/11/2009

• Date Format Different on Update

  Hello, I have a gride view and it shows the date in the date field as UK date, thats fine. But when I want to update the Field it wants the date in mm/dd/yyyy format? I have set the field up like this:- </asp:TemplateField> <asp:TemplateField HeaderText="Date" SortExpression="Date"> <EditItemTemplate> <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Date", "{0:dd/MM/yyyy}") %>'></asp:TextBox>

  Posted to Access Databases and AccessDataSource Control (Forum) by Hanwell on 9/11/2009

• Re: Date Format Different on Update

  thanks i must have missed that in the tutorials. Going to go back and teach myself about the globilzation in web config.

  Posted to Access Databases and AccessDataSource Control (Forum) by Hanwell on 9/11/2009

• Access Queries or Build New SQL ones?

  Hello just messing round with ASP.net and MS Access. Trying to put what I have learnd to use. But I have a question about which Queries to use? Do I use the ones already built in my Access database or would it be best to make new Queries with the SQL tool in Visual Studio? Robert

  Posted to Getting Started (Forum) by Hanwell on 9/10/2009

• Re: Access Queries or Build New SQL ones?

  no its an Access Database connection.

  Posted to Getting Started (Forum) by Hanwell on 9/10/2009

• Re: Update Deleting row?

  forget it I have got it working after two days of messing around. What a learning curb but the smile on my face is well worth it thanks for all your help guys. But still have a question about DAL and BLL Do i need to really build a BLL if the database is small? I don't have much experiance of makeing Classes in OOP so have stady away from it for now.

  Posted to Data Access and ObjectDataSource Control (Forum) by Hanwell on 9/3/2009

• Re: Update Deleting row?

  UPDATE EventsTBL SET Location = @Location, StartDate = @StartDate, Duration = @Duration, Details = @Details, OrganiserID = @OrganiserID, DiveManagerID = @DiveManagerID WHERE (Eventindex = @Original_Eventindex) Here is the grid view with the update settings <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <asp:ObjectDataSource ID="EventsList" runat="server" DeleteMethod="Delete" InsertMethod="Insert"

  Posted to Data Access and ObjectDataSource Control (Forum) by Hanwell on 9/3/2009