AG's Blog

Saturday, January 15, 2011

UploadModule is not installed into web.config.! using

Please check your IIS mode then change the web.config.

IIS 6.0 and IIS 7.0 Classic mode
<configuration>
<system.web>
    <httpModules>
      <add name="CuteWebUI.UploadModule" type="CuteWebUI.UploadModule,CuteWebUI.AjaxUploader"/>
     </httpModules>
</system.web>
</configuration>

IIS 7.0 Integrated mode
<configuration>
<system.webServer>
    <modules>
      <add name="CuteWebUI.UploadModule" type="CuteWebUI.UploadModule,CuteWebUI.AjaxUploader"/>
    </modules>
</system.webServer>
</configuration>

Tuesday, January 4, 2011

Create Capcha using Javascript

Code Behind write:

protected void Button1_Click(object sender, EventArgs e)
    {
        if (txtverification.Text == txt1.Value)
        {
            lblmsg.Text = "Successfull";
        }
        else
        {
            lblmsg.Text = "Failure";
        }
    }

Dopostback on Key Press using javascript

//alert("KeyId="+KeyID);

switch (KeyID) {
        case 118:
            __doPostBack('__Page', 'F7');
            break;
        case 119:
            __doPostBack('__Page', 'F8');
            break;
        case 120:
            __doPostBack('__Page', 'F9');
            break;
        case 121:
            __doPostBack('__Page', 'F10');
            break;
    }
}
</script>

Code Behind write:

protected void Page_Load(object sender, EventArgs e)
    {
        Page.ClientScript.GetPostBackEventReference(this, "");
        string eventArgs = Request["__EVENTARGUMENT"]; if (!string.IsNullOrEmpty(eventArgs))
        {
            switch (eventArgs)
            {
                case "F7":
                    a("F7");
                    break;
                case "F8":
                    a("F8");
                    break;
                case "F9":
                    a("F9");
                    break;
                case "F10":
                    a("F10");
                    break;
            }
        }
    }

   public void a(string str)
    {
         Response.Write("You pressed : " + str);
    }

Monday, January 3, 2011

Delete duplicate rows from the table

Create table ##Test (a int not null, b int not null, c int not null, id int not null identity) on [Primary]
GO
INSERT INTO ##Test (A,B,C) VALUES (1,1,1)
INSERT INTO ##Test (A,B,C) VALUES (1,1,1)
INSERT INTO ##Test (A,B,C) VALUES (1,1,1)

INSERT INTO ##Test (A,B,C) VALUES (1,2,3)
INSERT INTO ##Test (A,B,C) VALUES (1,2,3)
INSERT INTO ##Test (A,B,C) VALUES (1,2,3)

INSERT INTO ##Test (A,B,C) VALUES (4,5,6)
GO
Select * from ##Test
GO
Delete from ##Test where id <
(Select Max(id) from ##Test t where ##Test.a = t.a and
##Test.b = t.b and
##Test.c = t.c)
GO
Select * from ##Test
drop table ##Test
GO

Wednesday, December 22, 2010

Printer friendly using Javascript

</script>

<div id="printcontent" style="width: 100%">This content will be opened in a new window </div>

<asp:ImageButton ID="btnPrint" runat="server" ImageUrl="~/Includes/Images/printerIcon.gif"
AlternateText="Print" CausesValidation="false" OnClientClick="javascript:PrintThisPage();" />

Tuesday, December 21, 2010

Displaying records from the database in gridview based on the page and not fetching all the records from the database.

Here is the way for accessing the records from the database and displaying it in the gridview.
You can use custom paging for navigating withing the pages of the gridview.

EXEC usp_GetRecords 2,5 -- this will fetch only 5 records starting from 6 to 10

CREATE PROCEDURE usp_GetRecords
(
@iPageNumber INT, -- this is the page number sent during pagination
@iNumberOfRecords INT -- this is the number of records displayed per page
)
AS
DECLARE @iStartNumber INT
DECLARE @iEndNumber INT
SET @iEndNumber = (@iPageNumber * @iNumberOfRecords)
SET @iStartNumber = (@iEndNumber - @iNumberOfRecords) + 1;
WITH cte_t1(rownumber,id,a,b)
AS
(
SELECT ROW_NUMBER() OVER(ORDER BY id) AS rownumber,id,a,b FROM t1
)
SELECT * FROM cte_t1
WHERE rownumber BETWEEN @iStartNumber AND @iEndNumber

Tuesday, December 7, 2010

Calling Server side function using javascript

Every server-side method that is called from the client-side, must be declared as “static”, and also has to be decorated with the [System.Web.Services.WebMethod] tag.

Default.aspx

Default.aspx.cs
protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            txtId1.Attributes.Add("onblur", "javascript:CallMe('" + txtId1.ClientID + "', '" + txtContact1.ClientID + "')");
                    }
    }

[System.Web.Services.WebMethod]
    public static string Message(string str)
    {
        return str;
    }
[System.Web.Services.WebMethod]
    public static string GetContactName(string custid)
    {
        if (custid == null || custid.Length == 0)
            return String.Empty;
        SqlConnection conn = null;
        try
        {
            string connection = ConfigurationSettings.AppSettings["ConnectionString"];
            conn = new SqlConnection(connection);
            string sql = "Select sEmpFName from EMP_EmpPersonal where iEmployeeId = @CustID";
            SqlCommand cmd = new SqlCommand(sql, conn);
            cmd.Parameters.AddWithValue("CustID", custid);
            conn.Open();
            string contNm = Convert.ToString(cmd.ExecuteScalar());
            if (contNm.Length > 0)
                return contNm;
            else
                return "No record found.";
        }
        catch (SqlException ex)
        {
            return "error";
        }
        finally
        {
            conn.Close();
        }
    }