Monday, 21 July 2014

Create RDLC report

No comments
1> Create new Dataset , add columns
2> Create SP
3>add references of Microsoft.ReportViewer.WebForms
4>draag and drop RDLC report

Register assambly

ASPX

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

 <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
                    Font-Size="8pt" InteractiveDeviceInfos="(Collection)"
                    WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt">
                    <LocalReport ReportPath="Resolution_report.rdlc">
                        <DataSources>
                            <rsweb:ReportDataSource Name="DataSet1" />
                        </DataSources>
                   </LocalReport>
 </rsweb:ReportViewer>

CS

on button click

protected void Btndownloadpdf_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Example"].ToString());
        SqlCommand cmd = new SqlCommand("Your_SP", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@id", id.Text);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);

        ReportDataSource datasource = new ReportDataSource("DataSet1", ds.Tables[0]);
        ReportViewer ReportViewer1 = new ReportViewer();
        ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report.rdlc");
        ReportViewer1.LocalReport.DataSources.Clear();
        ReportViewer1.LocalReport.DataSources.Add(datasource);
        ReportViewer1.LocalReport.Refresh();
        byte[] byt = ReportViewer1.LocalReport.Render("PDF");
        Response.Buffer = true;
        Response.Clear();
        Response.ContentType = "application/pdf";
        Response.AddHeader("content-disposition", "attachment; filename= Report" + "." + "pdf");
        Response.OutputStream.Write(byt, 0, byt.Length); // create the file 
        Response.Flush(); // send it to the client to download 
        Response.End();
    }

read more

Thursday, 17 July 2014

Javascript validation to allow only alpahbet or numeric value in textbox

No comments
Codes

charCode > 31 --> allow backspace to work

charCode > 32 --> allow space to work

 charCode <  97 || charCode >122 --> allow only alphabetic value

 charCode <  45 || charCode > 45 --> allow only - as special character

 charCode <  65 || charCode > 93 --> allow capslock character

 charCode <  65 || charCode > 90 --> allow only . as special character

 charCode <  48 || charCode > 57 --> allow numeric

/*For alpha and numeric*/

 <script type="text/javascript">
        function functionN1(evt) {
            if (evt.charCode > 32 && (evt.charCode < 48 || evt.charCode > 57) && (evt.charCode < 97 || evt.charCode > 122) && (evt.charCode < 65 || evt.charCode > 93)) {
                return false;
            }
        }
    </script>

 <asp:TextBox ID="txtcname" runat="server" onkeypress="return functionc(event)></asp:TextBox>

/*For numeric*/ 

 <script type="text/javascript">
        function functionx(evt) {
            if (evt.charCode > 31 && (evt.charCode < 48 || evt.charCode > 57)) {
                return false;
            }
        }
    </script>

 <asp:TextBox ID="txtcname" runat="server" onkeypress="return functionx(event)></asp:TextBox>

/*for alphabets*/

function functionN1(evt) {
            if (evt.charCode > 32 && (evt.charCode < 97 || evt.charCode > 122) && (evt.charCode < 65 || evt.charCode > 93)) {
                return false;
            }
        }
    </script>

 <asp:TextBox ID="txtcname" runat="server" onkeypress="return functionc(event)></asp:TextBox>


read more

Sunday, 13 July 2014

Use ImageButton for uploading file and priview image on that ImageButton before uploading

No comments
.ASPX

<head runat="server">
    <title></title>
    <script type="text/javascript" src="http://code.jquery.com/jquery-1.8.2.js"></script>
    <script type="text/javascript">
        function showimagepreview(input) {
            if (input.files && input.files[0]) {
                var filerdr = new FileReader();
                filerdr.onload = function (e) {
                    $('#ImageButton1').attr('src', e.target.result);
                }
                filerdr.readAsDataURL(input.files[0]);
            }
        }
    </script>
    <script language="javascript" type="text/javascript">
        function clk() {
            document.getElementById("FileUpload1").click();
        }      
    </script>
</head>

<body>
    <form id="form1" runat="server">
    <div>
        <div style="display: none">
            <asp:FileUpload ID="FileUpload1" runat="server" onchange="showimagepreview(this)"/>
        </div>   
        <asp:ImageButton ID="ImageButton1" runat="server" OnClientClick="clk(); return false;"
            ImageUrl="~/img/b1.png" Width="40px" Height="40px"></asp:ImageButton>
        <asp:Button ID="btnupload" runat="server" OnClick="btnupload_Click" Text="Upload" />
    </div>
    </form>
</body>

calling from code behind

protected void Page_Load(object sender, EventArgs e)
    {
 ImageButton1.Attributes.Add("onclick", string.Format("jQuery('#" + FileUpload1.ClientID + "').click();return true;",ClientScript.GetPostBackEventReference(ImageButton1, null)));

reference  :-  aspdotnet-suresh
read more

Wednesday, 25 June 2014

Adding items to datatable dynamically

No comments
Adding rows in datatable
     
        DataTable dt = new DataTable();
        if (Session["data"] != null)
                {
                    dt = (DataTable)Session["data"];
                }
                else
                {
                    DataColumn proid = new DataColumn("p_id");
                    DataColumn Product_id = new DataColumn("Product");                 

                    dt.Columns.Add(proid);
                    dt.Columns.Add(Product);                
                }
                DataRow dr = dt.NewRow();
                dr["p_id"] = productid.Text;
                dr["Product"] = pid.Text;                            
                dt.Rows.Add(dr);
                Session["data"] = dt;

Updating data in datatable

 protected void Edit_Click(object sender, EventArgs e)
     {      
        Button im = (Button)sender;
        GridViewRow gr = (GridViewRow)im.NamingContainer;
        DataTable dt = (DataTable)Session["myDt"];
        DataRow dr = dt.Rows[gr.RowIndex];
        Session["dr"] = dr;
        Label lblpro = (Label)GridView1.Rows[gr.RowIndex].FindControl("lblpronm");
        texttBox1.text=lblpro.text;
        }   

  protected void Update_Click(object sender, EventArgs e)
     {    
            DataTable dt = (DataTable)Session["myDt"];
            DataRow dr = (DataRow)Session["dr"];
            dr["Proname"] = lblpro.text;         
            GridView1.DataSource = dt;
            GridView1.DataBind();
      }

Deleting rows from datatable

 protected void Delete_Click(object sender, ImageClickEventArgs e)
    {
        ImageButton img = (ImageButton)sender;
        GridViewRow gr = (GridViewRow)img.NamingContainer;
        DataTable dt = (DataTable)Session["data"];
        DataRow dr = dt.Rows[gr.RowIndex];
        dr.Delete();
        GridView1.DataSource = dt;
        GridView1.DataBind();
      
    }

Inserting data from datatable to database

protected void btn_checkout_Click(object sender, EventArgs e)
    {
 DataTable dt = (DataTable)Session["data"];
for (int j = 0; j < dt.Rows.Count; j++)
        {
            dl.p_id = Convert.ToInt16(dt.Rows[j]["p_id"]);
            dl.products = Convert.ToInt16(dt.Rows[j]["Product"]);
            bl.insert_order(dl);                                             
        }
read more

Monday, 23 June 2014

AccordionPane in ajax

No comments
.css

 .accheader
    {
        background-color:#2E4D7B;
        border:1px solid #2F4F4F;
        color:White;
        cursor:pointer;
        font-family: Arial,Sans-Serif;
        font-size:12px;
        font-weight:bold;
        margin-top:5px;
        padding:5px;
        width:730px;
       
       
   
    }
    .accheaderselected
    {
        background-color:#5078B3;
        border:1px solid #2F4F4F;
        color:White;
        cursor:pointer;
        font-family:Arial,Sans-Serif;
        font-size:12px;
        font-weight:bold;
        margin-top:5px;
        padding:5px;
        width:730px;
    }
    .acccontent
    {
        background-color:#D3DEEF;
        border-color:-moz-use-text-color #2F4F4F #2F4F4F;
        border-right: 1px dashed #2F4F4F;
        border-style: none dashed dashed;
        border-width: medium 1px 1px;
        padding: 10px 5px 5px;
        width:715px;
       
    }
 

.aspx


div class="accordation">
    <asp:Accordion ID="Accordion1" runat="server"
        FramesPerSecond="40" RequireOpenedPane="false" SuppressHeaderPostbacks="True"
        TransitionDuration="255" Enabled="true" HeaderCssClass="accheader"
        HeaderSelectedCssClass="accheaderselected" ContentCssClass="acccontent" FadeTransitions="true" AutoSize="Limit" SelectedIndex="0">
        <Panes>
            <asp:AccordionPane ID="AccordionPane1" runat="server">
            <Header><a href="" class="href">Articles</a></Header>
            <Content >
            <ul>
            <li>Animation/ Multimedia</li>
            <li>Engineering/ Technology</li>
           </ul>
             </Content>           
            </asp:AccordionPane>
        </Panes>
      </asp:Accordion>
</div>
  
read more

Saturday, 21 June 2014

Sorting in gridview

No comments
 public SortDirection dir
    {
        get
        {
            if (ViewState["dirState"] == null)
            {
                ViewState["dirState"] = SortDirection.Ascending;
            }
            return (SortDirection)ViewState["dirState"];
        }
        set
        {
            ViewState["dirState"] = value;
        }
    }
    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        all_resol();
        DataTable dt = new DataTable();
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand cmd = new SqlCommand("select* from Details whereActive='Active' and Status=1 ", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        dt = ds.Tables[0];
        {
            string SortDir = string.Empty;
            if (dir == SortDirection.Ascending)
            {
                dir = SortDirection.Descending;
                SortDir = "Desc";
            }
            else
            {
                dir = SortDirection.Ascending;
                SortDir = "Asc";
            }
            DataView sortedView = new DataView(dt);
            sortedView.Sort = e.SortExpression + " " + SortDir;
            GridView1.DataSource = sortedView;
            GridView1.DataBind();
        }
    }


 <asp:TemplateField HeaderText="IS" SortExpression="IS">
</asp:TemplateField>
read more

Friday, 20 June 2014

show online users

No comments
Global.asax

Application_start
{
    Application["unm"] =0;
}
Application_end
{
   Application["unm"] =0;
}
Session_start
{
   Application.lock();
   Application["unm"] =Convert.toInt16(Application["unm"]+1);
   Application.Unlock();
}Session_end
{
   Application.lock();
   Application["unm"] =Convert.toInt16(Application["unm"]-1);
   Application.Unlock();
}

.cs file

label1.text="online users"+Application["unm"];
read more
Subscribe to: Posts (Atom)