Is there a code ib VB or Design phase that I can check for any null inputs for primary key fields (DetailsView) before submitting into the database?

Can u be more clear


Archu

Are you using validation-controls?

I apologise for not being clear.

Okays, I'm using Visual Web Developer 2005 Express Edition, MS Access, AccessDataSource control. To view, edit, or insert entry, I'm using the DetailsView control in-built from the Visual Web Developer. I've tried the intellisense by typing "DetailsView1." to hope and try get the parameter for the textbox in DetailsView holding the promary key when I insert the value. However, I couldn't find it. It there any VB codes or and asp.net codes that could check whether this particular textbox(in-built from DetailsView provided by Visual Web Developer) is empty before or after I click "Insert" hyperlink(again in-built from DetailsView provided by Visual Web Developer), so that I do not end up with an error?

I have used the Validation controls before, is there anything like Validation that I can use on this in-built DetailsView to check on that particular textbox? Validation control's RequiredFieldValidation do not work on DetailsView.

Thank you

hi there..

why can you just add the validation control to the detailsview???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I've tried it, however the RequiredFieldValidation's ControlToValidate doesn't work on DetailsView. Is there others that can work on DetailsView?

Hey guys! I found the answer! Thank you so much for guiding me through, thought I'll post here to benefit others who might have the same problems as I had.

http://msdn2.microsoft.com/en-us/lib...es(VS.80).aspx

<%@ Page language="VB" autoeventwireup="false" %>

<script runat="server">

  Sub CustomerDetailsView_ItemInserting(ByVal sender As Object, _
    ByVal e As DetailsViewInsertEventArgs) _
    Handles CustomerDetailsView.ItemInserting

    ' Use the Values property to retrieve the key field value.
    Dim keyValue As String = e.Values("CustomerID").ToString()

    ' Insert the record only if the key field is four characters
    ' long; otherwise, cancel the insert operation.
    If keyValue.Length = 4 Then

      ' Change the key field value to upper case before inserting
      ' the record in the data source.
      e.Values("CustomerID") = keyValue.ToUpper()

      MessageLabel.Text = ""

    Else

      MessageLabel.Text = "The key field must have four digits."
      e.Cancel = True

    End If

  End Sub

</script>