TESTING SYSTEM

Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Data.SqlClient
Imports DAL

Namespace DAL

    Public Class db

        ''' <summary>
        ''' Function return connection string with open state
        ''' </summary>
        ''' <returns></returns>
        ''' <remarks></remarks>
        Public Function OpenConnection() As SqlConnection

            SqlConnection.ClearAllPools()
            Dim str As String = ""
            str = ConfigurationManager.ConnectionStrings("con").ConnectionString
            Dim cn As New SqlConnection
            cn.ConnectionString = str
            cn.Open()
            Return cn


        End Function

        ''' <summary>
        ''' Function use the execute non query
        ''' </summary>
        ''' <param name="strQuery"></param>
        ''' <param name="strFunctionName"></param>
        ''' <remarks></remarks>
        Public Sub ExecuteNonQuery(ByVal strQuery As String, Optional ByVal strFunctionName As String = "")

            HttpContext.Current.Trace.Warn(strFunctionName & ":" & strQuery)
            Dim cn As New SqlConnection
            Dim cmd As New SqlCommand


            Try

                cn = OpenConnection()
                cmd.Connection = cn
                cmd.CommandType = CommandType.Text
                cmd.CommandText = strQuery
                cmd.ExecuteNonQuery()

            Finally

                cn.Close()

            End Try

        End Sub


        ''' <summary>
        ''' Function return dataset
        ''' </summary>
        ''' <param name="strQuery"></param>
        ''' <param name="strFunctionName"></param>
        ''' <remarks></remarks>
        Public Function FillDataset(ByVal strQuery As String, Optional ByVal strFunctionName As String = "") As DataSet

            HttpContext.Current.Trace.Warn(strFunctionName & ":" & strQuery)
            Dim cn As New SqlConnection
            Dim cmd As New SqlCommand
            Dim dst As New DataSet
            Dim da As New SqlDataAdapter

            Try

                cn = OpenConnection()
                cmd.Connection = cn
                cmd.CommandType = CommandType.Text
                cmd.CommandText = strQuery
                cmd.ExecuteNonQuery()
                da = New SqlDataAdapter(cmd)
                da.Fill(dst)

            Finally

                cn.Close()

            End Try

            Return dst

        End Function

        ''' <summary>
        ''' Function return dataset
        ''' </summary>
        ''' <param name="strQuery"></param>
        ''' <param name="strFunctionName"></param>
        ''' <remarks></remarks>
        Public Function FillDatareader(ByVal strQuery As String, Optional ByVal strFunctionName As String = "") As SqlDataReader

            HttpContext.Current.Trace.Warn(strFunctionName & ":" & strQuery)
            Dim cn As New SqlConnection
            Dim cmd As New SqlCommand
            Dim dr As SqlDataReader

            cn = OpenConnection()
            cmd.Connection = cn
            cmd.CommandType = CommandType.Text
            cmd.CommandText = strQuery
            dr = cmd.ExecuteReader()
            Return dr


        End Function


    End Class

End Namespace

SEO Fresher Jobs In Ahmedabad | Ahmedabad SEO Fresher Job | SEO Jr Joabs In Ahmedabad West

2 - Jr. or fresher SEO person

Company: Omex Infotech
Address: B-1 3rd Floor Sardar Mall,
Nikol Road,
Ahmedabad - 382350.

Website: http://www.omexinfotech.com

Require: 2 Jr. SEO (Full time only)

Qualification:  B.C.A., Dimploma Computer, Diploma IT, B.Com, BA with English,
Graduation in any stream. If B.A. (English) Or B.Com. then plus point for candidate. If candidate know SEO or have experience then also taken plus point for candidate. If candidate have and experience of data entry and have good typing speed then also give some additional points.
Salary : We will discuss after interview
Experience : 0 to 1 years
Job Location: Ahmedabad
Job Time: 9:00 AM to 7:30 PM
*Every Saturday half day.
Job Profile: We have number of in house projects. So a person who join us need to work on same. You have to do all seo process on our sites.
Please send your C.V. at: sagar.net2005@gmail.com
Phone no. +91 999 888 98 04
Note: We require dedicate person who can join our organization for long period. We are not like other companies, who only give stress. We believe that "Work with joy not with stress.". We have our own in-house projects.
If you don't have any knowledge about seo then don't worry, Company will take guarantee that they will give try to give you batter knowledge about seo.

ahmedabad lowest temprature

Record breaking cold for this season

Today, ahmeadabad face record breaking cold of this season. As per weather report today ahmedabad's lowest temperature is 8 Degree C. And maximum noted 18 Degree C. From this season amdavadi never face this temperature. We collect some amdavadi photos who really enjoy this cold.

As per weather department amdavadi can take relax from this heavy cold after 3 to 4 days. And I don't think after completed this round of cold amdavadi feel cold again. Because after completed this cold summer started and all people said that, "Cold is batter then summer of ahmedabad".

Today When I meet my friend either call, chat, email or personally everyone's first sentence was, "How was cold today?". Hope we relax as soon as possible and can start our A.C.

Fog In Ahmedabad

Today's ahmedabad has very nice and sweet fog. Its live photo of todays ahmedabad fog. After started winter its first day where this type of environment visible in ahmedabad. Cold is really nice season but its become nice when you able to enjoy. And fog is the best way to do it. Ahmedabad fog is really give you great feel like manali and kasmir. But you also need to take little care from fog. Please switch on your vehicle head light. Because as per today environment if you go with motor cycle, four wheel then its really dangerous because you not able to visible 500 mtr distance. So switch on your head light and drive safely.

kankaria carnival 2011

Again ahmedabad rock with carnival 2011. This is fourth kankaria carnival 2011. We all want to give lots of congrats and thanks to Mr. Narendra modi who give different view of our ahmedabad in front of whole world. This time our ahmedabad going to plan celebrate Carnival 2011 (Karnival) In different way.

New events on this carnival 2011

• Vintage Games: Some of the selected player playing our vintage games which are not currently available or we are not aware of these types of games. Like kabaddi, kho kho, bethi kho, hututu and many more. These all games have been played by some of selected players. Our present mayor Mr. Ashit Vora told on Radio that there also more games which has been visible over there. Right now government tries to make some interest in people for these old games. And on next carnival 2012 ahmedabad people can participate on these games.



• Slum Children Play Area: Government made some plays station for slum children at kankaria lake carnival 2011. All people can celebrate New Year.
• AMC ahmedabad municipal corporation also going to plan events for traditional performance by civic body. The performance based on Juthan, Chatki and Bhugali among others. Some artist songs Guajarati songs and other play theater show which was played before 5 decades.
• We all are directly or indirectly, known or unknown make our city dirty. AMC try to give us eye where we can see these all our mistakes and give instruction to take some good habits as a citizen. The artists also play some role where smoking, throw garbage on road or water, spitting and many more.

• Cartoons: AMC also going to play some role by cartoon where they give instruction to be good citizen. The cartoons characters are get from Choota Bhim, aeroplane, Contessa car, moon, old model scooter and many more too.
• Moreover, a visualization of various musical instruments, folk songs and folk dances along with dialects of five geographical regions of Gujarat will also be presented during the carnival. The civic body also plans to provide a platform for release of mobile films on carnival activities.
• AMC will also add various attractions such as bungee trampoline, bungee ejection, baby car ride, moon walker, desert safari car, water bubble ride, obstacle courses and artificial rock climbing at Kankaria, said the statement.
• Win prize for upload kankaria carnival 2011 video: Upload your recorded video for carnival 2011 on facebook and youtube. A person who gets maximum likes or maximum click will get prize from government said by AMC officers

On each carnival Mr. Narendra Modi going to give some gift to ahmedabad. On this carnival narendra modi give over bridge open located at sardar nagar ITI. Which is regular and in used before 1st, Jan 2012. Hope this kankaria lake carnival going to be huge event and every amdavadi celebrate this event.