Suresh Sharma: June 2008

Saturday, June 28, 2008

creating Xml data in asp.net

protected void Page_Load(object sender, EventArgs e)
    {
        Response.ContentType = "text/Xml";
        int vid = Convert.ToInt32(Request.QueryString["vid"]);
        SqlConnection con = new SqlConnection( ConfigurationManager.
        ConnectionStrings["connect"].ConnectionString);
        SqlDataAdapter cmd = new SqlDataAdapter("select vedioname,vediourl,vediodesc from vedio where vedioid=@vid", con);
        cmd.SelectCommand.Parameters.Add("@vid", SqlDbType.Int).Value =vid;
        cmd.SelectCommand.CommandType = CommandType.Text;
        DataSet ds = new DataSet();
        cmd.Fill(ds, "root");
        String s = ds.GetXml();

        Response.Write(s);
        Response.End();

    }

Get web control value through javascript

<asp:TextBox id="txtname" runat=server ></asp:TextBox>
<script>

function getvalue()
{
var val=document.getElementById('<%=txtname.ClientID%>').value;
alert(val);
}

gridview with SqlDatasource

<asp:GridView ID="gv" Runat="Server"
AutoGenerateColumns="true"
BorderColor="#000080"
BorderWidth="2px"
HorizontalAlign="Center"
Width="90%" >
</asp:GridView>

codebehind file/////////
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SqlDataSource Source= new SqlDataSource();
Source.ConnectionString = ConfigurationManager.
ConnectionStrings["ConnectionString"].ConnectionString;
Source.DataSourceMode = SqlDataSourceMode.DataReader;
Source.ProviderName = "System.Data.SqlClient";
Source.SelectCommand = "SELECT companyname, companyaddress, companycity FROM companydetail ORDER BY companyname";
gv.DataSource = Source;
gv.DataBind();
}
}

Friday, June 27, 2008

using gridview calculate total in footer template

[sourcecode langauge="html"]

<asp:GridView ID="gv" Runat="Server"
AllowPaging="false"
AllowSorting="false"
AutoGenerateColumns="false"
BorderColor="#000080"
BorderStyle="Solid"
BorderWidth="2px"
Caption=""
HorizontalAlign="Center"
ShowFooter="true"
Width="90%"
OnRowDataBound="gv_RowDataBound" >
<HeaderStyle HorizontalAlign="Center" />
<RowStyle />
<AlternatingRowStyle />
<FooterStyle HorizontalAlign="Right"/>
<Columns>
<asp:TemplateField HeaderText="Name" FooterText="Total:">
<ItemTemplate>
<%# Eval("name") %>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="Salary"
ItemStyle-HorizontalAlign="Right">
<ItemTemplate>
<asp:Literal id="lblsalary" runat="server"
text='<%# Eval("Salry") %>' />
</ItemTemplate>
<FooterTemplate>
<asp:Literal id="lbltotSalary" runat="server" />
</FooterTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="Tax"
ItemStyle-HorizontalAlign="Right">
<ItemTemplate>
<asp:Literal id="lblTax" runat="server"
text='<%# Eval("Tax") %>' />
</ItemTemplate>
<FooterTemplate>
<asp:Literal id="lblTotTax"
runat="server" />
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

[/sourcecode]

codebehind pages

[sourcecode langauge="csharp"]

private Decimal msalaryTotal;
private Decimal mTaxTotal;
protected void Page_Load(object sender, EventArgs e)
{
SqlDataSource dSource = null;

if (!Page.IsPostBack)
{
dSource = new SqlDataSource();
dSource.ConnectionString = ConfigurationManager.
ConnectionStrings["dbConnectionString"].ConnectionString;
dSource.DataSourceMode = SqlDataSourceMode.DataReader;
dSource.ProviderName = "System.Data.SqlDb";
dSource.SelectCommand = "SELECT Name,Salary,Tax" +
"FROM emp " +"ORDER BY name";
msalaryTotal = 0;
mTaxTotal = 0;
gv.DataSource=dSource;
gv.DataBind();
}
}
protected void gv_RowDataBound(Object sender,GridViewRowEventArgs e)
{
DbDataRecord rowData;
Decimal amt;
Literal salaryLabel;
Literal TaxLabel;
Literal totalLabel;
switch (e.Row.RowType)
{
case DataControlRowType.DataRow:
rowData = (DbDataRecord)(e.Row.DataItem);
amt = (Decimal)(rowData["Salry"]);
msalaryTotal += amt;
salaryLabel = (Literal)(e.Row.FindControl("lblSalary"));
salaryLabel.Text = amt.ToString("C2");
amt = (Decimal)(rowData["Tax"]);
mTaxTotal += amt;
TaxLabel = (Literal)(e.Row.FindControl("lblTax"));
TaxLabel.Text = amt.ToString("C2");
break;
case DataControlRowType.Footer:
totalLabel = (Literal)(e.Row.FindControl("lbltotsalary"));
totalLabel.Text =msalaryTotal.ToString("C2");
totalLabel = (Literal)(e.Row.FindControl("lblTotTax"));
totalLabel.Text = mTaxTotal.ToString("C2");
break;
default:
break;
}
}

[/sourcecode]

Inserting in Gridview

<asp:GridView ID="gv" runat="server"
AutoGenerateColumns="False"
HorizontalAlign="Center"
Width="90%"
ShowFooter="True"
OnRowCommand="gv_RowCommand" CellPadding="4" ForeColor="#333333"
GridLines="None">
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:TemplateField HeaderText="companyname"
ItemStyle-HorizontalAlign="Center"
FooterStyle-HorizontalAlign="Center">
<ItemTemplate>
<%#Eval("companyname")%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id="txtcompanyname" runat="server"
Columns="3" />
</FooterTemplate>

<FooterStyle HorizontalAlign="Center"></FooterStyle>

<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:TemplateField>

<asp:TemplateField HeaderText="Address"
ItemStyle-HorizontalAlign="Left"
FooterStyle-HorizontalAlign="Left">
<ItemTemplate>
<%#Eval("Companyaddress")%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id="txtCompanyaddress" runat="server"
Columns="40" />
</FooterTemplate>

<FooterStyle HorizontalAlign="Left"></FooterStyle>

<ItemStyle HorizontalAlign="Left"></ItemStyle>
</asp:TemplateField>

<asp:TemplateField HeaderText="CompanyCity"
ItemStyle-HorizontalAlign="Center"
FooterStyle-HorizontalAlign="Center">
<ItemTemplate>
<%#Eval("CompanyCity")%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id="txtCompanyCity" runat="server"
Columns="40" />
</FooterTemplate>

<FooterStyle HorizontalAlign="Center"></FooterStyle>

<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:TemplateField>

<asp:TemplateField FooterStyle-HorizontalAlign="Center">
<FooterTemplate>
<asp:Button ID="btnInsert" runat="server"
Text="Insert"
CommandName="Insert" />
</FooterTemplate>

<FooterStyle HorizontalAlign="Center"></FooterStyle>
</asp:TemplateField>
</Columns>
</asp:GridView>

coding pages

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
bindData();
}

}

protected void gv_RowCommand(Object sender,GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Insert"))
{

String comp = ((TextBox)(gv.FooterRow.FindControl("txtCompanyName"))).Text;
String address = ((TextBox)(gv.FooterRow.FindControl("txtCompanyAddress"))).Text;
String city = ((TextBox)(gv.FooterRow.FindControl("txtCompanycity"))).Text;
SqlConnection dbConn =new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand dCmd = new SqlCommand("insert into companydetail(companyname,companyaddress,companycity)values(@comp,@address,@city)", dbConn);
dCmd.Connection.Open();
dCmd.Parameters.Add("@comp", SqlDbType.NVarChar).Value = comp;
dCmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = address;
dCmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = city;
dCmd.ExecuteNonQuery();
bindData();
dbConn.Close();
}

}
private void bindData()
{
SqlConnection dbConn =new SqlConnection( ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("SELECT companyname,companyaddress,companycity from companydetail order by companyname", dbConn);
DataTable dTable= new DataTable();
da.Fill(dTable);
gv.DataSource = dTable;
gv.DataBind();
dbConn.Close();

}

datagrid first prev next last paging

<asp:DataGrid ID="dg" Runat="server" BorderColor="#CC9966" BorderWidth="1px" AutoGenerateColumns="False"
Width="90%"
HorizontalAlign="Center"
AllowPaging="True"
PageSize="5"
PagerStyle-Visible="False" BackColor="White" BorderStyle="None"
CellPadding="4">
<HeaderStyle HorizontalAlign="Center" BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC"
/>
<FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
<SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
<PagerStyle Visible="False" BackColor="#FFFFCC" ForeColor="#330099"
HorizontalAlign="Center"></PagerStyle>
<ItemStyle />
<AlternatingItemStyle/>
<Columns>
<asp:BoundColumn HeaderText="regid"
DataField="regid" />
<asp:BoundColumn HeaderText="companyname"
DataField="companyname"
ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundColumn>
<asp:BoundColumn HeaderText="address"
DataField="address"
ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundColumn>
</Columns>
</asp:DataGrid>
<br />
<table width="20%" border="0" align="center">
<tr>
<td align="center">
<input id="btnFirst" runat="server" type="button"
value="First"
onserverclick="btnFirst_ServerClick">
</td>
<td align="center">
<input id="btnPrev" runat="server" type="button"
value="Prev"
onserverclick="btnPrev_ServerClick">
</td>
<td align="center">
<input id="btnNext" runat="server" type="button"
value="Next"
onserverclick="btnNext_ServerClick">
</td>
<td align="center">
<input id="Last" runat="server" type="button"
value="Last"
onserverclick="btnLast_ServerClick">
</td>
</tr>
</table>

codebehind pages

protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            bindData();
        }
    }

    protected void btnFirst_ServerClick(Object sender,EventArgs e)
    {
        if (dg.CurrentPageIndex > 0)
        {   dg.CurrentPageIndex = 0;
            bindData();
        }
    }

    protected void btnPrev_ServerClick(Object sender,EventArgs e)
    {
        if (dg.CurrentPageIndex > 0)
        {   dg.CurrentPageIndex -= 1;
            bindData();
        }
    }

    protected void btnNext_ServerClick(Object sender,EventArgs e)
    {if (dg.CurrentPageIndex < dg.PageCount - 1)
        {   dg.CurrentPageIndex += 1;
            bindData();
        }
    }

    protected void btnLast_ServerClick(Object sender,EventArgs e)
    {
        if (dg.CurrentPageIndex < dg.PageCount - 1)
        { dg.CurrentPageIndex = dg.PageCount - 1;
            bindData();
        }
    }
    private void bindData()
    {
            SqlConnection dbConn = new SqlConnection( ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            SqlDataAdapter da = new SqlDataAdapter("SELECT top 50 regid, companyname, address FROM registration ORDER BY companyname", dbConn);
            DataSet dSet = new DataSet();
             da.Fill(dSet);
             dg.DataSource = dSet;
             dg.DataBind();

    }

Edit,Update in datagrid

<div>
     <asp:DataGrid id="dg" runat="server" BorderColor="#3366CC" BorderWidth="1px"
AutoGenerateColumns="False" HorizontalAlign="Center" dth="63%"
OnCancelCommand="dg_CancelCommand" OnEditCommand="dg_EditCommand"
OnUpdateCommand="dg_UpdateCommand" DataKeyField="companyid"
BackColor="White" BorderStyle="None" CellPadding="4" Height="170px">
<HeaderStyle HorizontalAlign="Center" BackColor="#003399" Font-Bold="True"
ForeColor="#CCCCFF" /> <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<SelectedItemStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
         <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left"
Mode="NumericPages" /><ItemStyle BackColor="White" ForeColor="#003399" />
<AlternatingItemStyle /><Columns><asp:BoundColumn DataField="companyid"
ItemStyle-HorizontalAlign="Center" HeaderText="Company Id" ReadOnly="True" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundColumn><asp:TemplateColumn HeaderText="ComapnyName">
<ItemTemplate><%#Eval("CompanyName")%></ItemTemplate><EditItemTemplate>
<asp:TextBox id="txtcompanyname" runat="server" Columns="55"
text='<%# Eval("CompanyName") %>' /></EditItemTemplate>
</asp:TemplateColumn>
<asp:templatecolumn headertext="Company Address"
itemstyle-horizontalalign="Center"><itemtemplate>
<%# Eval("companyAddress") %></itemtemplate>
<edititemtemplate>
<asp:TextBox id="txtcompanyAddress" runat="server" Columns="55"
text='<%# Eval("companyAddress") %>' />
</edititemtemplate><ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:templatecolumn>
<asp:EditCommandColumn ButtonType="LinkButton" EditText="Edit"
CancelText="Cancel" UpdateText="Update" /></Columns></asp:DataGrid>

code behind file is that

protected void Page_Load(object sender, EventArgs e)
    {if (!Page.IsPostBack)
        {
            bindData();
        }
    }

    protected void dg_CancelCommand(Object source,DataGridCommandEventArgs e)
    {
        dg.EditItemIndex = -1;
        bindData();
    }
    protected void dg_EditCommand(Object source,DataGridCommandEventArgs e)
    {
        dg.EditItemIndex = e.Item.ItemIndex;
        bindData();
    }

    protected void dg_UpdateCommand(Object source,DataGridCommandEventArgs e)
    {
        SqlConnection dbConn = null;
        SqlCommand dCmd = null;
        String comp = null;
         String strConnection = null;
        String strSQL = null;
        int rowsAffected;
        String address = null;

        try
        {   comp = ((TextBox)(e.Item.FindControl("txtComapnyName"))).Text;
            address = ((TextBox)(e.Item.FindControl("txtComapnyAddress"))).Text;
            strConnection = ConfigurationManager.ConnectionStrings["dbConnectionString"].ConnectionString;
            dbConn = new SqlConnection(strConnection);
            dbConn.Open();
            strSQL = "UPDATE companydetail SET companyname='" + comp + "'" +",companyaddress=" + address +
                     " WHERE companyID=" +dg.DataKeys[e.Item.ItemIndex].ToString();
            dCmd = new SqlCommand(strSQL, dbConn);
            rowsAffected = dCmd.ExecuteNonQuery();
            dg.EditItemIndex = -1;
            bindData();
        }

        finally
        {
            if (dbConn != null)
            {
                dbConn.Close();
            }
        }
    }

    private void bindData()
    {
        SqlConnection dbConn = null;
        SqlDataAdapter da = null;
        DataTable dTable = null;
        String strConnection = null;
        String strSQL = null;

        try
        { strConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            dbConn = new SqlConnection(strConnection);
            dbConn.Open();
            strSQL = "SELECT companyid, companyname,companyaddress from companydetail order by companyname";

            da = new SqlDataAdapter(strSQL, dbConn);
            dTable = new DataTable();
            da.Fill(dTable);
             dg.DataSource = dTable;
            dg.DataKeyField = "companyid";
            dg.DataBind();
        }

        finally
        {

            if (dbConn != null)
            {
                dbConn.Close();
            }
        }
    }

Thursday, June 26, 2008

paging and sorting in Datagrid

div><asp:DataGrid id="dg" runat="server" AutoGenerateColumns="False" width="90%"

HorizontalAlign="Center" AllowSorting="True"AllowPaging="True"PageSize="5"

PagerStyle-Mode="NumericPages" PagerStyle-PageButtonCount="5"

PagerStyle-Position="Bottom" pagerStyle-HorizontalAlign="Center"

PagerStyle-NextPageText="Next" PagerStyle-PrevPageText="Prev"

PagerStyle-CssClass="pagerText" OnPageIndexChanged="data_PageIndexChanged"

OnSortCommand="data_SortCommand" CellPadding="4" ForeColor="#333333"

GridLines="None" >

<HeaderStyle HorizontalAlign="Center" BackColor="#507CD1"

Font-Bold="True" ForeColor="White" />

<PagerStyle NextPageText="Next" PageButtonCount="5" PrevPageText="Prev"

HorizontalAlign="Center" BackColor="#2461BF" ForeColor="White"></PagerStyle>

<asp:BoundColumn DataField="companyname" HeaderText="companyname"

SortExpression="companyname" />

<asp:BoundColumn DataField="companyaddress"

ItemStyle-HorizontalAlign="center" SortExpression="companyaddress">

<asp:BoundColumn DataField="companycity"ItemStyle-HorizontalAlign="Center"

SortExpression="companycity" >

</Columns></asp:DataGrid></div>

codebehind pages

private enum SortOrder

{soAscending = 0,

soDescending = 1

}

static readonly String SORTEXPRESSION = "SortExpression";

static readonly String SORTORDER = "SortOrder";

private void Page_Load(object sender, System.EventArgs e)

{String defaultSortExpression;

SortOrder defaultSortOrder;

if (!Page.IsPostBack){

defaultSortExpression =

"companyname";

SortOrder.soAscending;

this.ViewState.Add(SORTEXPRESSION, defaultSortExpression);

this.ViewState.Add(SORTORDER, defaultSortOrder);bindData(defaultSortExpression,defaultSortOrder);

}}

protected void data_SortCommand(Object source, DataGridSortCommandEventArgs e){

String newSortExpression = null;

String currentSortExpression = null;SortOrder currentSortOrder;

currentSortExpression =(String)(this.ViewState[SORTEXPRESSION]);currentSortOrder =(

SortOrder)(this.ViewState[SORTORDER]);

newSortExpression = e.SortExpression;

if (newSortExpression == currentSortExpression){

if (currentSortOrder == SortOrder.soAscending){

currentSortOrder =SortOrder.soDescending;}

else{currentSortOrder =SortOrder.soAscending;}

} else{currentSortExpression =newSortExpression;

currentSortOrder =SortOrder.soAscending;}

this.ViewState.Add(SORTEXPRESSION, currentSortExpression);

ViewState.Add(SORTORDER, currentSortOrder);

bindData(currentSortExpression,currentSortOrder);}

protected void data_PageIndexChanged(Object source, DataGridPageChangedEventArgs

e){String currentSortExpression;

SortOrder currentSortOrder; dg.CurrentPageIndex = e.NewPageIndex;

currentSortExpression =( String)(this.ViewState[SORTEXPRESSION]);

currentSortOrder =(SortOrder)(this.ViewState[SORTORDER]);

bindData(currentSortExpression,currentSortOrder);

}

private void bindData(String sortExpression, SortOrder sortOrder){

DataTable dTable = null;

int index = 0;DataGridColumn col = null;

String colImage = null;

String strSortOrder = null;

SqlConnection dbConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);dbConn.Open();

if (sortOrder == SortOrder.soAscending){strSortOrder =" ASC";}

strSortOrder =" DESC";}

SqlDataAdapter da = new SqlDataAdapter("SELECT companyname,companyaddress,companycity FROM companydetail ORDER BY "

+ sortExpression + strSortOrder, dbConn);

new DataTable();da.Fill(dTable);

for (index = 0; index < dg.Columns.Count; index++)

{col = dg.Columns[index];

if (col.SortExpression == sortExpression){

if (sortOrder == SortOrder

.soAscending){colImage ="<img src='images/sort_ascending.gif' border='0'>";} else{colImage =" <img src='images/sort_descending.gif' border='0'>";}

}

else{colImage ="";}

col.HeaderText = col.SortExpression + colImage;}

dg.DataSource = dTable;dg.DataBind();}

Tuesday, June 24, 2008

page bookmark in javascript

show hide layer on tab clicking

show and hide content on next prev button

<table width="99%" cellpadding="3" cellspacing="1" bgcolor="#000000">
                  <tr>
                    <td height="20" class="photonamewhite"><div style="float: right; width: 100px; position: relative; height: 25px;" class=smallphotoname align="right"><a href="#" class="curhand" title="Previous" onclick="moveRight('div_hall',90)">«prev</a>   <a href="#" title="next" onclick="moveLeft('div_hall',90)">next»</a></div></td>
                  </tr>
                  <tr>
                    <td bgcolor="#999999" >

                    <DIV style="MARGIN-LEFT: 5px; OVERFLOW: hidden; background-color:#666666; WIDTH: 276px; POSITION: relative; HEIGHT: 184px">
                        <DIV id="div_hall" style="LEFT: 0px; WIDTH:<%=(photo.Items.Count%6)==0?(photo.Items.Count/6)*270:((photo.Items.Count/6)+1)*270%>px; POSITION: absolute; TOP: 0px">

                               <asp:DataList ID=photo runat =server   ItemStyle-BackColor="#666666" BackColor=#666666
                                 RepeatDirection=Horizontal RepeatLayout=Table   ItemStyle-Width=90 ItemStyle-Height=90 ItemStyle-CssClass=smallphotoname >
                                <ItemTemplate>
                                <a onclick='getvedio(<%=Request.QueryString["vid"]%>,<%#Eval("vediosno")%>)' class=filterimage><img src='<%#"../../"+Eval("Urlimage") %>' width="80" style="cursor:hand;border-color:DarkGray" height="80" border="2" ><br>
                                     </a></ItemTemplate>

                               </asp:DataList>
                               </DIV>
                               </DIV>

                    </td>
                  </tr>

              </table>
//using method in javascript ///

function moveRight(divname,owidth)
{
var crossobj=document.getElementById(divname) ;
leftpos = parseInt(crossobj.style.left) + owidth ;

if ( leftpos < 0 )
  crossobj.style.left = parseInt(crossobj.style.left) + owidth ;
else
  crossobj.style.left = 0 ;

}

function moveLeft(divname,owidth)
{
var crossobj=document.getElementById(divname) ;
var contentwidth=crossobj.offsetWidth ;
leftpos = (contentwidth - 300) * (-1) ;

if ( parseInt(crossobj.style.left) > leftpos )
  crossobj.style.left = parseInt(crossobj.style.left) - owidth ;
}

Datapager in asp.net 3.5

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
    <style type="text/css">
      th
      {
        background-color:#eef4fa;
        border-top:solid 1px #9dbbcc;
        border-bottom:solid 1px #9dbbcc;
      }
      .itemSeparator { border-right: 1px solid #ccc }
      .groupSeparator
      {
        height: 1px;
        background-color: #cccccc;
      }
    </style>

</head>
<body>
    <form id="form1" runat="server">
    <div>
      <asp:DataPager runat="server" ID="BeforeListDataPager"
        PagedControlID="ProductsListView"
        PageSize="18">
        <Fields>
          <asp:NextPreviousPagerField ButtonType="Link"
            ShowFirstPageButton="true"
            ShowNextPageButton="false"
            ShowPreviousPageButton="false"
            FirstPageText="« Prev" />
          <asp:NumericPagerField ButtonCount="10" />
          <asp:NextPreviousPagerField ButtonType="Link"
            ShowLastPageButton="true"
            ShowNextPageButton="false"
            ShowPreviousPageButton="false"
            LastPageText=" Next »" />
            </Fields>
            </asp:DataPager>

      <asp:ListView ID="ProductsListView"
        DataSourceID="SqlDataSource1"
        GroupItemCount="3"
        runat="server">
        <LayoutTemplate>
          <table cellpadding="2" width="640px" id="tbl1" runat="server">
            <tr>
              <th colspan="5">PRODUCTS LIST</th>
            </tr>
            <tr runat="server" id="groupPlaceholder"></tr>
          </table>
        </LayoutTemplate>
        <GroupTemplate>
          <tr runat="server" id="tr1">
            <td runat="server" id="itemPlaceholder"></td>
          </tr>
        </GroupTemplate>
        <GroupSeparatorTemplate>
          <tr id="Tr1" runat="server">
            <td colspan="5">
                <div class="groupSeparator"><hr></div>
              </td>
          </tr>
        </GroupSeparatorTemplate>
        <ItemTemplate>
          <td id="Td1" align="center" runat="server">
            <asp:Label ID="lblcomp" Text='<%#Eval("companyname") %>' runat=server></asp:Label>
          </td>
        </ItemTemplate>
        <ItemSeparatorTemplate>
          <td id="Td2" class="itemSeparator" runat="server"> </td>
        </ItemSeparatorTemplate>
      </asp:ListView>
     <asp:DataPager runat="server" ID="Afterpagerlist"
        PagedControlID="ProductsListView"
        PageSize="18">
        <Fields>
          <asp:NextPreviousPagerField ButtonType="Link"
            ShowFirstPageButton="true"
            ShowNextPageButton="false"
            ShowPreviousPageButton="false"
            FirstPageText="« Prev" />
          <asp:NumericPagerField ButtonCount="10" />
          <asp:NextPreviousPagerField ButtonType="Link"
            ShowLastPageButton="true"
            ShowNextPageButton="false"
            ShowPreviousPageButton="false"
            LastPageText=" Next »" />
            </Fields>
            </asp:DataPager>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            SelectCommand="SELECT top 200 [CompanyName] FROM [Registration]">
        </asp:SqlDataSource>   </div>
    </form>
</body>
</html>

Tuesday, June 17, 2008

Edit ,Delete,Update in Gridview



    Untitled Page
    


    
    
    
    update college/univercity name in COLLEGEPATH table:
    
    
   
    
        
            
                <%#Eval("RegID")%>
            
           
             
                
                 
        
              
        
            
                <%#Eval("companyname")%>

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class multieditepage : System.Web.UI.Page
{
    advReport adv = new advReport();
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {

            this.DataBind1();
        }

    }

    protected void cancel(object sender, GridViewCancelEditEventArgs e)
    {
        dg.EditIndex = -1;
        this.DataBind1();
    }
    protected void edit(object sender, GridViewEditEventArgs e)
    {
        dg.EditIndex = e.NewEditIndex;
        this.DataBind1();
    }
    protected void update(object sender, GridViewUpdateEventArgs e)
    {
        string regid = ((TextBox)(dg.Rows[e.RowIndex].FindControl("txtreg"))).Text;
        string name = ((FileUpload)(dg.Rows[e.RowIndex].FindControl("upfile"))).FileName;
       
            adv.updateevents(regid, name);
            dg.EditIndex = -1;
            this.DataBind1();
     
    }
   protected void delete(object sender, GridViewDeleteEventArgs e)
    {
   
        int regid = Convert.ToInt32(dg.DataKeys[e.RowIndex].Value);
        adv.deleterecord(regid);
        dg.EditIndex = -1;
      this.DataBind1();
    }
    protected void DataBind1()
    {
         DataSet ds = new DataSet();
      
        SqlDataAdapter myAdapter = new SqlDataAdapter("collegepathupdate", adv.connect());
       
        myAdapter.Fill(ds);
        PagedDataSource objPds = new PagedDataSource();
        objPds.DataSource = ds.Tables[0].DefaultView;

        objPds.AllowPaging = true;
        objPds.PageSize = 13;

        objPds.CurrentPageIndex = CurrentPage;

        lblfind.Text = "Page: " + (CurrentPage + 1).ToString() + " of "
            + objPds.PageCount.ToString() + "    Total Records :(" + ds.Tables[0].Rows.Count.ToString() + ")";

        // Disable Prev or Next buttons if necessary
        cmdPrev.Enabled = !objPds.IsFirstPage;
        cmdNext.Enabled = !objPds.IsLastPage;
        dg.DataSource = objPds;
        dg.DataBind();

    }

    protected void cmdPrev_Click(object sender, System.EventArgs e)
    {
        // Set viewstate variable to the previous page
        CurrentPage -= 1;

        // Reload control
        DataBind1();
    }

    protected void cmdNext_Click(object sender, System.EventArgs e)
    {
        // Set viewstate variable to the next page
        CurrentPage += 1;

        // Reload control
        DataBind1();
    }
    public int CurrentPage
    {
        get
        {
            // look for current page in ViewState
            object o = this.ViewState["_CurrentPage"];
            if (o == null)
                return 0; // default to showing the first page
            else
                return (int)o;
        }

        set
        {
            this.ViewState["_CurrentPage"] = value;
        }
    }
   
}

public class advReport
{
   public advReport()
    {
    }

 public void updateevents(string regid,string name)
    {
        int chk=1;
      
        SqlCommand cmd = new SqlCommand("insert into collegepath(regid,collegeurl,updatechk) values(@regid,@name,@chk)", connect());
        cmd.Parameters.Add("@regid", SqlDbType.Int).Value = Convert.ToInt32(regid);
        cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = name;
        cmd.Parameters.Add("@chk", SqlDbType.Int).Value = chk;

       
        cmd.ExecuteNonQuery();
        cmd.Connection.Close();
    }
public void deleterecord(int regid)
    {
        SqlCommand cmd = new SqlCommand("delete from registration where regID=@regid", connect());
        cmd.Parameters.Add("@regid", SqlDbType.Int).Value = regid;
        cmd.ExecuteNonQuery();
        cmd.Connection.Close();

    }
}

page