Saturday, May 5, 2012

asp.net Set Cookie for Client Pc using c#

   public void setCookie()
    {


        if ((chk_remember_me.Checked))
        {
            HttpCookie aCookie = new HttpCookie("mwa_gov_saChatInfo");
            Response.Cookies.Remove("mwa_gov_saChatInfo");
            Response.Cookies.Add(aCookie);
            aCookie.Values.Add("UserName",HttpUtility.UrlEncode(txtName.Value) );
            aCookie.Values.Add("Email", txtEmail.Value );
            aCookie.Expires = DateTime.Now.AddMonths(2);
            Response.Cookies.Add(aCookie);
        }
        else
        {
            HttpCookie cookie = Request.Cookies["mwa_gov_saChatInfo"];
            if (cookie != null)
            {
                HttpCookie aCookie = new HttpCookie("mwa_gov_saChatInfo");
                aCookie.Expires = DateTime.Now.AddMonths(-2);
                Response.Cookies.Add(aCookie);
                chk_remember_me.Checked = false;
            }
        }
    }

Friday, May 4, 2012

vb.net Sql server Query Parametrized Select Statement

This Sample Code Clarify how to call Sql statement using Parameters to Avoid Sql Injection problem

 Dim dsEmails As New DataSet()
Using connection As New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("mwa_mwa_gov_saConnectionString").ToString())
 Dim myDataAdapter As New SqlDataAdapter("SELECT [ID], [UserId], [UserName], [FirstName], [FatherName],[GrandfatherName], [FamilyName], [Email], [SubscriptionNo], [MobileNo] From IUSers Where ID=@ID", connection)
                        myDataAdapter.SelectCommand.Parameters.Add("@ID", SqlDbType.Int, 11)
                        myDataAdapter.SelectCommand.Parameters("@ID").Value = Convert.ToInt32(s) 'Request.Cookies("ID").Value)
   myDataAdapter.Fill(dsEmails)
   connection.Close()
   myDataAdapter.Dispose()
 End Using

asp.net Password Validation example

using System;
using System.Text.RegularExpressions;

public void CreateNewUserAccount(string name, string password)
{
    // Check name contains only lower case or upper case letters, 
    // the apostrophe, a dot, or white space. Also check it is 
    // between 1 and 40 characters long
    if ( !Regex.IsMatch(userIDTxt.Text, @"^[a-zA-Z'./s]{1,40}$"))
      throw new FormatException("Invalid name format");

    // Check password contains at least one digit, one lower case 
    // letter, one uppercase letter, and is between 8 and 10 
    // characters long
    if ( !Regex.IsMatch(passwordTxt.Text, 
                      @"^(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).{8,10}$" ))
      throw new FormatException("Invalid password format");

    // Perform data access logic (using type safe parameters)
    ...
}

Sunday, April 29, 2012

VB.NET Oracle Call Function with Parameters

WHEN we need to call Oracle Database Function from vb.net Code Using System.Data.Oracle Client we will need to Pass Function Parameters and receive Function Return Value

so this action Can be Handled by the following Code Sample
NOTE: I have db function called ENCRYPT_STR S have two input arguments and one output return value so , i declared Oracle Command and define it's type as Stored Procedure and pass command text as SchemaName.FunctionName
then deal with command to add parameters and receive Return value and return it after .
    Public Function EncriptLoginData(ByVal username As String, ByVal EncKey As String) As String
        Dim Result_Encripted As String = String.Empty
                    'define Oracle Command
        Dim cmd As New Data.OracleClient.OracleCommand
        cmd.CommandType = Data.CommandType.StoredProcedure
        cmd.CommandText = "MAIN.ENCRYPT_STR"
        cmd.Connection = OConn
        OConn.ConnectionString = ConnString
        If OConn.State <> ConnectionState.Open Then OConn.Open()
        With cmd
            .Parameters.Add("var1", OracleType.VarChar, 100).Direction = ParameterDirection.Input
            .Parameters.Add("p_key", OracleType.VarChar, 100).Direction = ParameterDirection.Input
            .Parameters.Add("encUserName", OracleType.VarChar, 4000).Direction = ParameterDirection.ReturnValue
            .Parameters("var1").Value = username
            .Parameters("p_key").Value = EncKey

        End With
        cmd.ExecuteScalar()
        Result_Encripted = cmd.Parameters("encUserName").Value.ToString()
        cmd.Dispose()
        OConn.Close()
        OConn.Dispose()
        Return Result_Encripted
    End Function

Saturday, April 28, 2012

get Client Ip Address Using Asp.net c#

to get Client Ip address use the following code
 if (Context.Request.ServerVariables["HTTP_VIA"] != null) // using proxy
                            {
                                                              Context.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString();  // Return real client IP.
                            }
                            else// not using proxy or can't get the Client IP
                            {
                                Context.Request.ServerVariables["REMOTE_ADDR"].ToString(); //While it can't get the Client IP, it will return proxy IP.
                            }

Tuesday, April 24, 2012

flexigrid-1.1 fix Html table Using Jquery

flexigrid-1.1 is very nice javascript and css Library to fix Html table sorting drag and drop view and hide table column

Link for Download files.

http://code.google.com/p/flexigrid/downloads/list

C++ program to rotate and capitalize sentences.

The program will start by asking the user to enter a multi-word sentence. The program will then the
program will rotate the sentence and print out the rotated sentence. Moreover, the first letter of each word of sentence must be capitalized. All other words must be in lower case.

#include "stdafx.h"
#include <iostream>
#include "conio.h"
#include "vector"
#include <sstream>

using namespace std;

int _tmain(int argc)
{
      char sentence[1000];
    bool cap_it = true;
    cout << "enter your sentence.\n";
    cin.getline(sentence, 1000);
    for (int i = 0; i < strlen(sentence); i++)
    {
        if (isalpha(sentence[i]) && cap_it == true)
        {
            sentence[i] = toupper(sentence[i]);
            cap_it = false;
        }
        else
            if (isspace (sentence[i]))
                cap_it = true;
    }

    cout << endl <<  endl;

     istringstream converter(sentence);

    vector<string> words((istream_iterator<string>(converter)),  istream_iterator<string>());

    copy(words.rbegin(), words.rend(), ostream_iterator<string>(cout, " "));
  getch();

    return 0;
}