"" A Char and it is Not Null
0 comments Friday, January 26, 2007

Hi

Today at Arab Teem someone ask question about the null and the Space-Key which is not null of course. See this example to know more what I'm talking about.

Have fun.

Bye

Create Table xT

(

FName VarChar ( 30 ) Not Null

)

Go

Insert into xT ( FName ) Values ( Null )

Go

Insert into xT ( FName ) Values ( '' )

Go

Insert into xT ( FName ) Values ( 'Ahamd' )

Go

Alter Table xT With NoCheck

Add Constraint CH_xT_FName Check ( Len ( FName ) > 0 )

Go

Insert into xT ( FName ) Values ( Null )

Go

Insert into xT ( FName ) Values ( '' )

Go

Insert into xT ( FName ) Values ( 'Desigen' )

Go

Select * From xT

Go

Labels:

Posted byUnknown
at3:52 AM

0 comments
 
UML Design Tool
0 comments Thursday, January 18, 2007

Hi Folks


I have been recently looking for a UML tool and I found this cool tool designed by

Have fun.

Bye

Labels:

Posted byUnknown
at1:38 AM

0 comments
 
Adding new file to Oracle Database not change Control File size
0 comments Tuesday, January 16, 2007

Hi

This is nice, when you create a database on thing that you have to do is setting the Max Clauses MaxDataFiles so this will determine the max number of data files in the database. Oracle use this number to create the Control file. So when you add another file the Control file will never change. Consider it like that, why I have to recreate the control file if one Max Clauses change? Because Oracle uses them to create the Control file.

Have fun

Bye

Labels:

Posted byUnknown
at5:38 AM

0 comments
 
Pass the page to server without validation
0 comments

Hi

 

This is a tricky, I think if I didn't study yesterday I will never know about this.

You can make a button pass the page to server without validation by using the Button ( Command ) property CausessValidation

 

This is an example

 

<%@ Page Language="C#"

    Inherits="System.Web.UI.MobileControls.MobilePage" %>

<%@ Register TagPrefix="mobile"

    Namespace="System.Web.UI.MobileControls"

    Assembly="System.Web.Mobile" %>

 

<script runat="server">

 

    protected void Command1_Click(object sender, EventArgs e)

    {

        if (Page.IsValid)

            ActiveForm = Form3;

    }

 

    protected void Command2_Click(object sender, EventArgs e)

    {

        ActiveForm = Form3;

    }

</script>

 

<html xmlns="http://www.w3.org/1999/xhtml" >

<body>

    <mobile:form id="form1" runat="server">

        <mobile:Label ID="Label2" Runat="server">Write a value</mobile:Label>

        <mobile:TextBox ID="TextBox1" Runat="server">

        </mobile:TextBox>

        <mobile:RequiredFieldValidator ID="RequiredFieldValidator1"

            Runat="server" ControlToValidate="TextBox1"

            ErrorMessage="Text is required ">

        </mobile:RequiredFieldValidator>

        <mobile:Command ID="Command1"

            Runat="server"

            OnClick="Command1_Click"

            Format="Link">Validate </mobile:Command>

        <mobile:Command ID="Command2"

            Runat="server"

            CausesValidation="False"

            OnClick="Command2_Click"

            Format="Link"

            SoftkeyLabel="No Validation !!!">No Validation</mobile:Command>

 

    </mobile:form>

    <mobile:Form ID="Form3" Runat="server">

        <mobile:Label ID="Label3"

            Runat="server"

            ForeColor="Green"

            StyleReference="title">You Passed</mobile:Label>

    </mobile:Form>

</body>

</html>

 

Have fun

Bye

 

Posted byUnknown
at5:32 AM

0 comments
 
Create PDF from SQL stored procedure
0 comments Tuesday, January 9, 2007

Hi,

How are you?

It has been a while. I have a lot of homework and next week I have exams.

Today I found this interesting thing about creating a PDF from Sql Server without using any external tool

Have fun

Labels:

Posted byUnknown
at12:54 AM

0 comments
 
Subscribe to: Posts (Atom)