Friday, February 10, 2012

Unrecognized escape sequence in C# SQL

I 've faced an problem in SQL server database connectivity from C# its all because my server name consist of  "\" ,C# read \ as n escape sequence to resolve this problem  use "@" symbol before the connectivity statement.

("Server=DIVI-PC\SQLEXPRESS;database=project")

Here is the problem there is "\" after the DIVI-PC C# reads its as an escape sequence so it is not possible to connect with sql  to Solve this problem add "@"

(@"Server=DIVI-PC\SQLEXPRESS;database=project")

Now it 'll work .

NOTE : Don't forget to add username and passwords

Suggestions are always welcome !!

Saturday, February 4, 2012

PHP to email

PHP uses email function to send email from php code . To send email u must need to create header . Before that First create an HTML form .

Enquiry
First Name * :
Last Name * :
Email Address * :
Company Name :
Designation :
Phone :
Mobile :
Messange * :



After clicking the Submit button send_form_email.php page will be called


if(isset($_POST['email'])) {
$email_to = "yourname@maildomain.com"; //change to ur mail id
$email_subject = "Enquiry";
function died($error)
{
echo "These errors appear below.

";
echo $error."

";
echo "Please go back and fix these errors.

";
die();
}
// validation expected data exists
if(!isset($_POST['first_name']) ||
!isset($_POST['last_name']) ||
!isset($_POST['email']) ||
!isset($_POST['telephone']) ||
!isset($_POST['comments'])) {
died('There is an Error in ur Filled form');
}
$first_name = $_POST['first_name']; // required
$last_name = $_POST['last_name']; // required
$email_from = $_POST['email']; // required
$company = $_POST['company'];// not required
$designation = $_POST['designation'];// not required
$telephone = $_POST['telephone']; // not required
$mobile = $_POST['mobile']; //not required
$comments = $_POST['comments']; // required
$error_message = "";
$email_exp = '/^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$/';
if(!preg_match($email_exp,$email_from)) {
$error_message .= 'The Email Address you entered does not appear to be valid.
';
}
$string_exp = "/^[A-Za-z .'-]+$/";
if(!preg_match($string_exp,$first_name)) {
$error_message .= 'The First Name you entered does not appear to be valid.
';
}
if(!preg_match($string_exp,$last_name)) {
$error_message .= 'The Last Name you entered does not appear to be valid.
';
}
if(strlen($comments) < 2) {
$error_message .= 'The Comments you entered do not appear to be valid.
';
}
if(strlen($error_message) > 0) {
died($error_message);
}
$email_message = "Form details below.\n\n";
function clean_string($string) {
$bad = array("content-type","bcc:","to:","cc:","href");
return str_replace($bad,"",$string);
}
$email_message .= "First Name: ".clean_string($first_name)."\n";
$email_message .= "Last Name: ".clean_string($last_name)."\n";
$email_message .= "Email: ".clean_string($email_from)."\n";
$email_message .= "Company Name: ".clean_string($company)."\n";
$email_message .= "Designation : ".clean_string($designation)."\n";
$email_message .= "Telephone: ".clean_string($telephone)."\n";
$email_message .= "Mobile: ".clean_string($mobile)."\n";
$email_message .= "Comments: ".clean_string($comments)."\n";
// create email headers
$headers = 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();
mail($email_to, $email_subject, $email_message, $headers);
?>


How to Validate only Numbers in Textbox

To validate only numbers in text box.

Step 1: Desing a Textbox in asp.net .

Step 2 : Goto Coding side of the page .

Step 3: Post the following coding

<asp:regularexpressionvalidator controltovalidate="TextBox9" errormessage="Please Enter Numbers Only " id="RegularExpressionValidator2" runat="server" validationexpression="^\d+$" validationgroup="check"></asp:regularexpressionvalidator>

How to Validate E-Mail address in Asp.net Text box

To validate E-mail address in asp.net Text box .

Step 1: Design a Textbox and post in web page.

Step 2: Enter in to the Coding mode .

Step3: Below the Textbox coding enter the following expression coding.

   <asp:RegularExpressionValidator id="RegularExpressionValidator1" runat="server" ControlToValidate="TextBox10"
  ErrorMessage="You must enter an email address"
  ValidationExpression="\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*">
</asp:RegularExpressionValidator>

Step 4: Press F5 and validate the text box.