Thursday, November 15, 2012

Read and Write Image into File using Binary Reader and Binary Writer


FileStream fs = new FileStream("D:\\Rajimg\\MyImg.txt", FileMode.OpenOrCreate, FileAccess.ReadWrite);
FileStream fs1 = new FileStream("D:\\Rajimg\\1.jpg",FileMode.Open);

// First Write Image Into File 
 private void button1_Click(object sender, EventArgs e)
        {
           BinaryReader br = new BinaryReader(fs1);
           byte[] bt = new byte[fs1.Length];
           bt = br.ReadBytes(Convert.ToInt32(fs1.Length));
           BinaryWriter bw = new BinaryWriter(fs);
           bw.Write(bt);
           bw.Close();
         }

// Read Image
private void button2_Click(object sender, EventArgs e)
        {
            BinaryReader br=new BinaryReader(fs);
            byte[] bt=br.ReadBytes(Convert.ToInt32(fs.Length));
            MemoryStream ms = new MemoryStream(bt);
            pictureBox1.Image = Image.FromStream(ms);
        }

Wednesday, September 26, 2012

Using Parameter in Crystal Report

// .aspx Code
--------------------------------------------------------------------

  Enter Empid ::
  <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1"
        runat="server" Text="Show Result" onclick="Button1_Click" />
    <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
      EnableDatabaseLogonPrompt="False" EnableParameterPrompt="False" />

1. Add a CrystalReport File
            Solution Explorer -> Add new Item -> CrystalReport.rpt

2. Add Paramater in .rpt file



                  Add Paramater on .rpt Page


--------------------------------------------------------------------------------------------------------

//  Now Write code on .cs File on Button Click Event
---------------------------------------------------------------------------------------------------------

1.  First add Namespace

   using CrystalDecisions.CrystalReports.Engine;
   using CrystalDecisions.Shared;

2. Write code on Button_Click Event


 protected void Button1_Click(object sender, EventArgs e)
    {
        ReportDocument rd = new ReportDocument();
        rd.Load(Server.MapPath("CrystalReport.rpt"));
        rd.SetDatabaseLogon("", "");
        rd.SetParameterValue("ID", TextBox1.Text);
        CrystalReportViewer1.ReportSource = rd;
        CrystalReportViewer1.ParameterFieldInfo.Add(rd.ParameterFields[0]);
     
    }
//----------------------------------------------------------------------------

Enjoy Crystal Report

Thursday, September 20, 2012

Using Link Button in GridView in Asp.net 4.0

//Design
                                                                                                                                                   


 <table width="100%"
        style="background-image: url('images/back1.gif'); height: 367px;">
<tr>
<td>
    <asp:GridView ID="Gv1" runat="server" AutoGenerateColumns="false"
        DataKeyNames="ec_id" onrowdatabound="GridView1_RowDataBound">
    <Columns>
    <asp:BoundField DataField="ec_em_no" ReadOnly="true" HeaderText="Emp No" />
    <asp:BoundField DataField="ec_id" ReadOnly="true" HeaderText="Claim ID" />
    <asp:BoundField DataField="ec_type" ReadOnly="true" HeaderText="Claim Type" />
    <asp:BoundField DataField="ec_amount" ReadOnly="true" HeaderText="Claim Amount" />
    <asp:BoundField DataField="ec_desc" ReadOnly="true" HeaderText="Claim Desc" />
    <asp:BoundField DataField="ec_apply_date" ReadOnly="true" HeaderText="Apply Date" />
    <asp:TemplateField HeaderText="Accept/Reject">
    <ItemTemplate>
    <asp:LinkButton ID="Link1" runat="server" Text="Accept" OnClick="Link1_Click"></asp:LinkButton>
    </ItemTemplate>
    </asp:TemplateField>
 
    </Columns>
    </asp:GridView>
</td>
</tr>
</table>
                                                                                                                                                        
// Code
                                                                                                                                                         

using System.Data.SqlClient;
using System.Configuration;

public partial class Default2 : System.Web.UI.Page
{
    string connectionInfo = ConfigurationManager.AppSettings["ConnectionInfo"];
    SqlCommand cmd;
    SqlConnection con;
    protected void Page_Load(object sender, EventArgs e)
    {
        con = new SqlConnection(connectionInfo);
        if (!Page.IsPostBack)
            ShowData();
    }

    public void ShowData()
    {
        SqlDataAdapter da = new SqlDataAdapter("Select * From emp_claims WHERE ec_approve_status='Await'", con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        Gv1.DataSource = ds.Tables[0];
        Gv1.DataBind();
     }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {

    }
    protected void Link1_Click(object sender, EventArgs e)
    {
        LinkButton lbutton = sender as LinkButton;
        GridViewRow gr = lbutton.NamingContainer as GridViewRow;
        int id = Convert.ToInt32(Gv1.DataKeys[gr.RowIndex].Value);
        cmd = new SqlCommand("UPDATE emp_claims SET ec_approve_status='Accept' WHERE ec_id=" + id + "", con);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        Gv1.EditIndex = -1;
        ShowData();
    }
  }

Wednesday, September 19, 2012

Using Check box in Gridview in asp.net and delete checked record

// Design
---------------------------------------------------------------------------------------

  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" DataKeyNames="Emp_ID">
    <Columns>
    <asp:TemplateField HeaderText="CheckBox">
    <ItemTemplate>
    <asp:CheckBox ID="chk1" runat="server" />
    </ItemTemplate>
    </asp:TemplateField>
    <asp:BoundField HeaderText="Empname" DataField="name" />
    <asp:BoundField HeaderText="City" DataField="City" />
    </Columns>
    </asp:GridView>
    <asp:Button ID="b1" runat="server" Text="Delete" />
-----------------------------------------------------------------------------------------
//Code
-----------------------------------------------------------------------------------------

using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=test;Integrated Security=True");
    SqlDataAdapter da;
    SqlCommand cmd;
    DataSet ds = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            ShowData();
    }
    public void ShowData()
    {
        da = new SqlDataAdapter("Select * From Emp1", con);
        da.Fill(ds);
        GridView1.DataSource = ds.Tables[0];
        GridView1.DataBind();
    }
    protected void b1_Click(object sender, EventArgs e)
    {
        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            GridViewRow gr = GridView1.Rows[i];
            CheckBox ck = (CheckBox)gr.FindControl("chk1");
            int id= (int)GridView1.DataKeys[i].Value;
            if (ck.Checked == true)
            {
                cmd = new SqlCommand("Delete From Emp1 Where Emp_ID=" + id + "", con);
                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();
                //GridView1.EditIndex = -1;
                ShowData();
            }
       
       
        }
    }
}