DotNetFriends

Export GridView Data Into CSV File in Asp.net 2.0

2008-06-22T04:47:00.000-07:00

Steps.

1) Create Simple Web Application ( asp.net using C#).

2) put the below control in to the page (.aspx)

2.1) GridView (id= GridView1)

2.2) Button (id=button1 and Text =Create CSV File)

or put the below code

<form id="form1" runat="server">
<center>
<div>
<table>
    <tr>
      <td>
       Create CSV File
      </td>
     </tr>
     <tr>
       <td>
<asp:GridView ID="GridView1" runat="server"  CellPadding="4" ForeColor="#333333" GridLines="None">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
                               <AlternatingRowStyle BackColor="White" />
</asp:GridView>
    </td>
    </tr>
     <tr>
     <td align="center">
 <asp:Button ID="Button1" runat="server" Text="Create CSV File" OnClick="Button1_Click" />
                       </td>
                   </tr>
               </table>
           </div>
       </center>
   </form>

3) assign data source to GridView. here i created dynamic dataset (on page load). save the DataSet in to ViewState.

public DataSet MyData
    {
        get
        {
            if (ViewState["MyData"] == null)
               ViewState["MyData"] = new DataSet();
            return (DataSet)ViewState["MyData"];
        }
        set { ViewState["MyData"] = value; }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //create new data set
            DataSet Ds = new DataSet();
            //create new datatable
            DataTable dt = new DataTable();
            //create new column
       DataColumn dc1 = new DataColumn("Id");
       DataColumn dc2 = new DataColumn("Code");
       DataColumn dc3 = new DataColumn("Name");
       DataColumn dc4 = new DataColumn("datetime");

            //add column to datatable
            dt.Columns.Add(dc1);
            dt.Columns.Add(dc2);
            dt.Columns.Add(dc3);
            dt.Columns.Add(dc4);
            for (int i = 0; i < 10; i++)
            {
                //add new row in to datatable
                DataRow dr = dt.NewRow();
                dr["Id"] = i;
                dr["Code"] = "A" + i.ToString();
                dr["Name"] = "B" + i.ToString();
                dr["datetime"] = System.DateTime.Now.AddDays(Convert.ToDouble(i));
                dt.Rows.Add(dr);
            }
            Ds.Tables.Add(dt);
            MyData = Ds;
            GridView1.DataSource = MyData;
            GridView1.DataBind();
        }
        else
        {
            GridView1.DataSource = MyData;
            GridView1.DataBind();
        }
    }

4) Export GridView Data in to CSV format

protected void Button1_Click(object sender, EventArgs e)
   {
       try
       {
           //Create CSV file 
           StreamWriter objSw = new StreamWriter(Server.MapPath("~/demo.csv"));
           //get table from GridView1
           DataTable objDt = ((DataSet)GridView1.DataSource).Tables[0];
           //Get No Of Column in GridView
           int NoOfColumn = objDt.Columns.Count;
           //Create Header
           for (int i = 0; i < NoOfColumn; i++)
           {
               objSw.Write(objDt.Columns[i]);
               //check not last column
               if (i < NoOfColumn - 1)
               {
                   objSw.Write(",");
               }
           }
           objSw.Write(objSw.NewLine);
           //Create Data  
           foreach (DataRow dr in objDt.Rows)
           {
               for (int i = 0; i < NoOfColumn; i++)
               {
                   objSw.Write(dr[i].ToString());

                   if (i < NoOfColumn - 1)
                   {
                       objSw.Write(",");
                   }
               }
               objSw.Write(objSw.NewLine);
           }
           objSw.Close();
       }
       catch (Exception ex)
       {
           Response.Write("Can Not Generate CSV File");
       }       
   }

Thanks.

http://amitpatriwala.wordpress.com

Insert Null Value in DateTime Column SqlServer 2005 using asp.net

2008-06-16T21:12:00.001-07:00

steps:

1) Create Simple web application (asp.net with C#).

2) create below table in the database. here i made table (table_1 in test database).

DataBase Name :Test
Table Name : Table_1
ColumnName ColumnDataType
id int (Auto Increment & Primary Key)
code varchar(50) (Allow Null True)
date datetime (Allow Null True)
3) put the below control on the form.
3.1) Calendar (id --> Calendar1)
3.2) Button (id --> btnInsert)
3.3) Button (id --> btnGet)
3.4) Label (id --> lblDataValue)
4) put the below code in to C# page.

Add below name space first :

using System.Data.SqlClient;
copy the below code and check.

 //connection string
    //please change as per your server and database 
    string constr = @"Data Source=(local);Initial Catalog=test;Integrated Security=True";
    public int insertedId
    {
        get { return Convert.ToInt32(ViewState["inserttedid"]); }
        set { ViewState["inserttedid"] = value; }
    }
    protected void btnInsert_Click(object sender, EventArgs e)
    {
        //if user is not selected any value from calendar at that time null is inserted
        //otherwise selected date is inserted
        string datetime = Calendar1.SelectedDate.Date.Equals(DateTime.MinValue) == true ? "Null" : "'" + Calendar1.SelectedDate + "'";
        string strins = "insert into table_1 values " +
            "('amit'," + datetime + ");select scope_identity();";
        SqlConnection sqlcon = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand(strins, sqlcon);
        sqlcon.Open();
        //get the id of inserted row using Scope_Identity function
         insertedId = Convert.ToInt32(cmd.ExecuteScalar());
        sqlcon.Close();
    }
    protected void btnGet_Click(object sender, EventArgs e)
    {
        //get the inserted record
        string strSelect = "Select * from table_1 where id =" + insertedId;
        SqlConnection sqlcon = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand(strSelect, sqlcon);
        sqlcon.Open();
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            //set the value in the label for display purpose  
            lblDataValue.Text = dr["date"] == System.DBNull.Value ? DateTime.MinValue.ToShortDateString() : Convert.ToString(dr["date"]);
        }
        sqlcon.Close();
    }

Thanks.

http://amitpatriwala.wordpress.com

Change GridView Row Color on Mouse Move And Get Value OnClick In Asp.net

2008-04-16T21:53:00.000-07:00

Steps:

1) Create Simple Web Application (using C#).

2) put control (GridView) on the form (Default.aspx)

  <asp:GridView ID=”GridView1″ runat=”server”

   OnRowDataBound=”GridView1_RowDataBound”>
asp:GridView>

3) On Page Load Event Put Below Code.

  protected void Page_Load(object sender, EventArgs e)
{
//namespace :using System.Collections.Generic;
List<int> obj = new List<int>();
for (int i = 10; i < datasource =" obj;">

4) On the GridView RowDataBound Event Put Below Code.

  protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//change the row color and change mouse display hand
e.Row.Attributes.Add(“onmouseover”,

      “this.style.backgroundColor  = ‘pink’;this.style.cursor=’hand’;”);
//change the cell at that time the row color set white
e.Row.Attributes.Add(“onmouseout”, “style.backgroundColor = ‘white’;”);
//on row click -pass row selected row index,row clientid and cell 0 value
e.Row.Attributes.Add(“onclick”,

      “showClickPage(’” + e.Row.RowIndex  + “‘,’” + e.Row.ClientID + “‘,’”

      + e.Row.Cells[0].Text + “‘);”);
}
}

5) In the JavaScript put the below code.

<script language=”javascript” type =”text/javascript” >
function MouseOver(obj)
{
alert(obj);
document.getElementById(obj).style.backgroundColor =“Red”;
}
//get the row index and client id ,cell value
function showClickPage(rowid,id,selectedid)
{
alert(“Selected Row ->” + rowid);
var gridViewCtl = document.getElementById(‘<%=GridView1.ClientID%>’);
alert(“Selected Cell [0] Value” + selectedid);
}
script>

Thanks

http://amitpatriwala.wordpress.com

DownLoad Pdf file in Asp.net 2.0

2008-04-14T00:44:00.000-07:00

1) Create the Simple Web Application.

2) Now add the new folder (FolderName : PDFFile).

2.1) right click on the project and add folder.

3) put the one pdf file in to folder ( name :1.pdf).

4) in the web page put the control

4.1) put the button control (name : btnPdfFiledownload)

(note: Here we use hardcoded thing (means use button control and path)

if you want to change then you do it.)

5) on the button click (means btnPdfFiledownload) you write the below code.

protected void btnPdfFiledownload_Click(object sender, EventArgs e)

{

//get the physical path of your drive + append the folder and you file name with this

//example my folder is on the same level of this (foldername ->PDFFile)

//file name is 1.pdf

string strMapPath = Server.MapPath(Request.Url.AbsolutePath.Substring(0, Request.Url.AbsolutePath.LastIndexOf(“//”) + 1)) + @”\PDFFile\1.pdf”;

//enter the content type (describe the pdf)

Response.ContentType = “application/pdf”;

//in the filename you can give whatever you want

//when download the file at that save this file with this filename

//Adds an HTTP header to the output stream.

Response.AppendHeader(“Content-Disposition”, “attachment; filename=applicationfile.pdf”);

//TransmitFile do –> Writes the specified file directly to an HTTP response output stream without buffering it in memory

Response.TransmitFile(strMapPath);

//End Response

Response.End();

}

Thank you.

http://amitpatriwala.wordpress.com