itblog: April 2012

Tuesday, 24 April 2012

Sunday, 22 April 2012

3 -Tier using edmx in MS Visual Studio 2010 + Dropdown Binding and File Uploadind,Downloading in Gridview + Auto Complete Extender using Web Service

/////If you are using “CommandfieldShowdeleteButton” to delete record then pass “ID(table’s PK)” as “DatakeyName” to fetch data from table.

/////To fetch table’s ID(given as DataKeyName in RowDeleting Event) Using

int id=Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());

<%–<asp:CommandField ShowDeleteButton=”True” />–%>
<asp:TemplateField>
<HeaderTemplate>
Delete
</HeaderTemplate>
<ItemTemplate>
<asp:LinkButton ID=”lnk_del” runat=”server” Text=”Delete” OnClick=”lnk_del_Click”></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>
name
</HeaderTemplate>
<ItemTemplate>
<%#Eval(“name”)%>
<asp:Label ID=”Lbl_Id_del” runat=”server” Text=’<%#Eval(“id”)%>’ Visible=”false”></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID=”Txt_name” runat=”server” Text=’<%#Eval(“name”)%>’></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>
mobile
</HeaderTemplate>
<ItemTemplate>
<%#Eval(“mobile”)%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID=”Txt_mobile” runat=”server” Text=’<%#Eval(“mobile”)%>’></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>
address
</HeaderTemplate>
<ItemTemplate>
<%#Eval(“adress”)%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID=”Txt_add” runat=”server” Text=’<%#Eval(“adress”)%>’></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>
district
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID=”lbl_grid” runat=”server” Text=’<%#Eval(“district”)%>’></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID=”ddl_grid” runat=”server” OnSelectedIndexChanged=”ddl_grid_SelectedIndexChanged”
AutoPostBack=”true”>
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>

<asp:TemplateField>

<HeaderTemplate>
Taluka
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID=”lbl_taluka” runat=”server” Text=’<%#Eval(“taluka”)%>’></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID=”ddl_taluka” runat=”server”>
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>
Image
</HeaderTemplate>
<ItemTemplate>
<asp:ImageButton ID=”img1″ runat=”server” ImageUrl=’<%# Eval(“image”) %>’ Width=”50px”
Height=”50px” CommandArgument=’<%# Eval(“image”) %>’ CommandName=”cmd” />
</ItemTemplate>
<EditItemTemplate>
<asp:FileUpload ID=”fuc_grid” runat=”server” />
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<%–</asp:Panel>–%>
</div>
</form>
</body>
</html>

/////*.aspx.cs/////

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.EnterpriseServices;
using System.Data.EntityModel;
using testn1.dbModel;

public partial class aaa : System.Web.UI.Page
{
Entities1 ent = new Entities1();
tbl_tjs tbl = new tbl_tjs();
WebService web = new WebService();
tbl_tjs_dist dist = new tbl_tjs_dist();
tbl_tjs_taluka taluka = new tbl_tjs_taluka();

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

lbl_error.Visible = false;
int a;
}

private void bind_drop()
{
var f = ent.tbl_tjs_dist.ToList();
ddl_dist.DataSource = f;
ddl_dist.DataTextField = “Dis_name”;
ddl_dist.DataValueField = “Dis_id”;
ddl_dist.DataBind();
ddl_dist.Items.Insert(0, “—Select—”);
}

protected void btn_submit_Click(object sender, EventArgs e)
{
if (name.Text == “”)
{
lbl_error.Visible = true;
}
else
{
tbl.name = name.Text;
tbl.mobile =mobile.Text;
tbl.adress = address.Text;
tbl.district = ddl_dist.SelectedItem.Text;
string path = “Upload/” + FileUpload1.PostedFile.FileName;
FileUpload1.SaveAs(Server.MapPath(path));
tbl.image = path;
ent.AddTotbl_tjs(tbl);
ent.SaveChanges();
name.Text = “”;
mobile.Text = “”;
address.Text = “”;
ddl_dist.ClearSelection();
}
}

protected void bind()
{
var t = ent.select_tjs_sp();
GridView1.DataSource = t.ToList();
GridView1.DataBind();
}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{

GridView1.EditIndex = e.NewEditIndex;
bind();

DropDownList ddl = (DropDownList)GridView1.Rows[e.NewEditIndex].Cells[0].FindControl(“ddl_grid”);
var f = ent.tbl_tjs_dist.ToList();
ddl.DataSource = f;
ddl.DataTextField = “Dis_name”;
ddl.DataValueField = “Dis_id”;
ddl.DataBind();
ddl.Items.Insert(0, “—Select—”);
}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
///// Using Datakeynames

int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());

///// Using Lable.
/////Label bl_id =(Label)GridView1.Rows[e.RowIndex].FindControl(“Lbl_Id_del”);

int id = Convert.ToInt32(bl_id.Text);
var t = ent.tbl_tjs.Where(m => m.id == id).Single<tbl_tjs>();
ent.tbl_tjs.DeleteObject(t);
ent.SaveChanges();
bind();
}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{

//using Datakey

int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
TextBox txt_name = (TextBox)GridView1.Rows[e.RowIndex].FindControl(“Txt_name”);
TextBox txt1_mo = (TextBox)GridView1.Rows[e.RowIndex].FindControl(“Txt_mobile”);
TextBox txt2_add = (TextBox)GridView1.Rows[e.RowIndex].FindControl(“Txt_add”);
DropDownList ddl = (DropDownList)GridView1.Rows[e.RowIndex].FindControl(“ddl_grid”);
DropDownList dd2 = (DropDownList)GridView1.Rows[e.RowIndex].FindControl(“ddl_taluka”);
FileUpload file1 = (FileUpload)GridView1.Rows[e.RowIndex].FindControl(“fuc_grid”);

int id1 = Convert.ToInt32(id );

var s = ent.tbl_tjs.Where(n => n.id == id1).Single<tbl_tjs>();
s.name = txt_name.Text;
s.mobile = txt1_mo.Text;
s.adress = txt2_add.Text;
s.district = ddl.SelectedItem.Text;
s.taluka = dd2.SelectedItem.Text;

string path = “Upload/” + file1.PostedFile.FileName;
file1.SaveAs(Server.MapPath(path));
s.image = path;
ent.SaveChanges();
GridView1.EditIndex = -1;
bind();
}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
bind();
}

protected void lnk_del_Click(object sender, EventArgs e)
{
LinkButton lnk = (LinkButton)sender;
GridViewRow grd = (GridViewRow)lnk.NamingContainer;
int row = grd.RowIndex;

///// Using Lable.
Label bl_id = (Label)GridView1.Rows[row].FindControl(“Lbl_Id_del”);

int id = Convert.ToInt32(bl_id.Text);
var t = ent.tbl_tjs.Where(m => m.id == id).Single<tbl_tjs>();
ent.tbl_tjs.DeleteObject(t);
ent.SaveChanges();
bind();
}

protected void btn_view_Click(object sender, EventArgs e)
{
bind();
}

protected void GridView1_PreRender(object sender, EventArgs e)
{
//GridView1.UseAccessibleHeader = true;
//GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;
}

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{

if (e.CommandName == “cmd”)
{
string path = MapPath(e.CommandArgument.ToString());
byte[] bts = System.IO.File.ReadAllBytes(path);
Response.Clear();
Response.ClearHeaders();
Response.AddHeader(“Content-Length”, bts.Length.ToString());
Response.AddHeader(“Content-Disposition”, “attachment; filename=” + e.CommandArgument.ToString());
Response.ContentType = “Application/upload”;
Response.BinaryWrite(bts);
Response.Flush();
Response.End();
}
}

protected void ddl_grid_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList lnk = (DropDownList)sender;
GridViewRow grd = (GridViewRow)lnk.NamingContainer;
int row = grd.RowIndex ;

DropDownList dd2 = (DropDownList)GridView1.Rows[row].FindControl(“ddl_grid”);
DropDownList ddl = (DropDownList)GridView1.Rows[row].FindControl(“ddl_taluka”);

int d = Convert.ToInt32(dd2.SelectedValue);
var t = ent.tbl_tjs_taluka.Where(n => n.taluka_id == d).ToList();

ddl.DataSource = t;
ddl.DataTextField = “taluka_name”;
ddl.DataValueField = “id”;
ddl.DataBind();
ddl.Items.Insert(0, “—Select—”);
}

[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
public static string[] GetClientName(string prefixText, int count)
{
SqlConnection con = new SqlConnection(“server=192.168.1.95;Database=testn1.db;User ID=sa;Password=Bisag123;”);

con.Open();
string strQuery = “select name from tbl_tjs where name like ‘” + prefixText + “%’”;

DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(strQuery, con);
da.Fill(ds);
con.Close();
List<string> cityList = new List<string>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
cityList.Add(ds.Tables[0].Rows[i][0].ToString());
}
return cityList.ToArray();
}
}

Asp.net example

w3school

Ajax toolkit

Saturday, 14 April 2012

All In Three Tier (insert)(update,delete in gridview )with export to excel

//.aspx page-source page//

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" EnableEventValidation ="false" Inherits="_Default" %>

<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI" TagPrefix="asp" %>

<%--<%@ Register Src="UI/footer.ascx" TagName="Footer" TagPrefix="uc3" %>--%>
<%@ Register Src="~/UI/Menu.ascx" TagName="menu" TagPrefix="uc4" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<link href="Stylecal.css" rel="stylesheet" type="text/css" />
<link href="css/style.css" rel="stylesheet" type="text/css" />
<script src="JScript.js" language="javascript" type="text/javascript"></script>
</head>
<body>
<form id="form1" runat="server">

<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="Updatepanel1" runat="server">
<ContentTemplate>
<table align="center" width="100%" class ="table-class" >
<uc4:menu ID="u4" runat="server" />
<tr >
<td class="td-class" align="center">
COMPANY<asp:DropDownList id="DropDownList1" runat="server" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" AutoPostBack="True">
</asp:DropDownList>
</td>

</tr>
<tr>
<td align="center">
PRODUCT<asp:DropDownList id="DropDownList2" runat="server">
</asp:DropDownList></td>

<td class="td-class">
</td>
</tr>
<tr>
<td align="center" colspan="2" style="height: 22px">
<asp:Button ID="Button1" runat="server" Text="ok" OnClick="Button1_Click" CssClass="stamp" /></td>
</tr>
<tr>
<td align="center" colspan="2">

<asp:SiteMapPath ID="SiteMapPath1" runat="server">

</asp:SiteMapPath>

</td>
</tr>
<tr>
<td align="center" colspan="2" rowspan="1">
</td>
</tr>
<tr>
<td colspan="2" rowspan="4" align="center">
 <asp:UpdatePanel ID ="up1" runat ="server">

<ContentTemplate>

<asp:GridView ID="GridView1" runat="server" DataKeyNames="id" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" AutoGenerateColumns="False" CssClass="GridHeading-text" OnRowCancelingEdit="GridView1_RowCancelingEdit" AllowPaging="True" OnPageIndexChanging="GridView1_PageIndexChanging">
<Columns>
<asp:CommandField ShowDeleteButton="True" />
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="id" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression = "id" Visible ="False" />
<asp:BoundField DataField="companyname" HeaderText="CompanyName" />
<asp:BoundField DataField="productname" HeaderText="Product" />

</Columns>
</asp:GridView>

</ContentTemplate>
</asp:UpdatePanel>  

</td>
</tr>

<tr>
</tr>
<tr>
</tr>

<tr>
<td align="center" >
</td>
</tr>
<tr>
<td align="center" colspan="2" rowspan="1">
<asp:Button ID="btn_export" runat="server" CssClass="stamp" ForeColor="White" OnClick="btn_export_Click"
Text="Export To Excel" /></td>
<td align="center">
</td>
</tr>
<tr>
<td align="center" colspan="2">
 
<br />

</td>
</tr>
<tr>
<td align="center" colspan="2" style="height: 21px">
 </td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:Wizard ID="Wizard1" runat="server" ActiveStepIndex="0" FinishCompleteButtonImageUrl="1"
OnFinishButtonClick="Wizard1_FinishButtonClick1">
<WizardSteps>
<asp:WizardStep runat="server" Title="Step 1">
<asp:AdRotator ID="AdRotator1" runat="server" AdvertisementFile="~/XMLFile.xml"
Height="67px" Width="100px" />
</asp:WizardStep>
<asp:WizardStep runat="server" Title="Step 2">
<asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px" AllowPaging="True" OnPageIndexChanging="DetailsView1_PageIndexChanging" CssClass="GridHeading-text">

</asp:DetailsView>
</asp:WizardStep>
</WizardSteps>
</asp:Wizard>
 
   </td>
</tr>
<tr>
<td align="center" colspan="2">
</td>
</tr>
<tr>
<td align="center" colspan="2">
</td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:Button ID="Button2" runat="server" Text="submit" OnClick="Button2_Click" OnClientClick ="return mainprogram();" CssClass="stamp" />

</td>
</tr>
<tr>
<td align="center" colspan="2" >
<asp:Label ID="Label1" runat="server" Text="Label" Visible="False"></asp:Label></td>
</tr>
<tr >
<td width="100%" class="td-class"><%--<uc3:footer id="Footer1" runat="server"></uc3:footer></td>--%>
</tr>
</table>
</ContentTemplate>
<Triggers>
<asp:PostBackTrigger ControlID="btn_export" />

</Triggers>
</asp:UpdatePanel>
</div>
</form>
</body>
</html>

//.aspx.cs//

using System;

using System.Data;

using System.Configuration;

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;

using grid;

using System.Collections.Generic;

using System.IO;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

//SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

//cn.Open();

DataSet ds = new DataSet();

company cs = new company();

bindgrid1();

ds=company.show();

//ds=cs.show();

// SqlDataAdapter da = new SqlDataAdapter("select_sp", cn);

//da.Fill(ds);

DropDownList1.DataSource = ds.Tables[0];

DropDownList1.DataTextField = "name";

DropDownList1.DataValueField = "id";

DropDownList1.DataBind();

DropDownList1.Items .Insert(0, "--SELECT--");

bindgrid();

}

protected void Button1_Click(object sender, EventArgs e)

{

// SqlConnection cn = new SqlConnection(ConfigurationManager .ConnectionStrings[1].ConnectionString );

//cn.Open();

//SqlCommand cmd = new SqlCommand("insertgridlist_sp", cn);

//SqlCommand cmd = new SqlCommand("insert into gridlist values ('" + DropDownList1.SelectedItem.ToString() + "','" + DropDownList2.SelectedItem.ToString () + "')", cn);

//cmd.Parameters.AddWithValue("@companyname", DropDownList1.SelectedItem.ToString());

//cmd.Parameters.AddWithValue("@productname", DropDownList2.SelectedItem.ToString());

//cmd.CommandType = CommandType.StoredProcedure;

//cmd.ExecuteNonQuery();

//cn.Close();

company cs = new company();

cs.companyname = DropDownList1.SelectedItem.ToString();

cs.productname = DropDownList2.SelectedItem.ToString();

cs.add();

//DataSet ds = new DataSet();

//SqlDataAdapter da = new SqlDataAdapter("select_grid_sp ", cn);

//da.Fill(ds);

//GridView1 .DataSource = ds.Tables[0];

//GridView1 .DataBind();

bindgrid();

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

{

int aa=Convert.ToInt32( DropDownList1.SelectedValue.ToString());

//SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

//cn.Open();

DataSet ds = new DataSet();

//company cs = new company();

//SqlDataAdapter da = new SqlDataAdapter("SELECT dbo.product.pname,dbo.product.id,dbo.company.id,dbo.product.pid FROM dbo.company INNER JOIN dbo.product ON dbo.company.id = dbo.product.id where product.id=" + aa, cn);

//SqlCommand cmd = new SqlCommand("select_join_sp", cn);

//cmd.Parameters.AddWithValue("@id", aa);

//cmd.CommandType = CommandType.StoredProcedure;

// SqlDataAdapter da = new SqlDataAdapter(cmd);

//da.Fill(ds);

ds = company.show1(aa);

DropDownList2.DataSource = ds.Tables[0];

DropDownList2.DataTextField = "pname";

DropDownList2.DataValueField = "pid";

DropDownList2.DataBind();

DropDownList2.Items.Insert(0, "--SELECT--");

}

protected void Button2_Click(object sender, EventArgs e)

{

}

public void bindgrid()

{

//SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

//cn.Open();

DataSet ds = new DataSet();

//SqlDataAdapter da = new SqlDataAdapter("select_grid_sp",cn);

//da.Fill(ds);

ds = company.Grid1();

GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();

}

public void bindgrid1()

{

//SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

//cn.Open();

DataSet ds = new DataSet();

//SqlDataAdapter da = new SqlDataAdapter("select_grid_sp",cn);

//da.Fill(ds);

ds = company.Grid1();

DetailsView1.DataSource = ds.Tables[0];

DetailsView1.DataBind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

bindgrid();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

GridViewRow gd = GridView1.Rows[e.RowIndex];

company cs = new company();

//cs.id = Convert .ToInt32 (GridView1.DataKeys[e.RowIndex].Value);

int i = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);

GridView1.EditIndex = -1;

cs.delete(i);

bindgrid();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

GridViewRow gd = GridView1.Rows[e.RowIndex];

company cs = new company();

cs.id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);

string companyname = ((TextBox)(gd.Cells[3].Controls[0])).Text;

string productname = ((TextBox)(gd.Cells[4].Controls[0])).Text;

cs.companyname = companyname;

cs.productname = productname;

cs.update();

Label1.Visible = true;

Label1.Text = "update sucessfully";

GridView1.EditIndex = -1;

bindgrid();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

}

protected void Wizard1_FinishButtonClick(object sender, WizardNavigationEventArgs e)

{

}

protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)

{

DetailsView1.PageIndex = e.NewPageIndex;

bindgrid1();

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

GridView1.PageIndex = e.NewPageIndex;

bindgrid();

}

protected void Wizard1_FinishButtonClick1(object sender, WizardNavigationEventArgs e)

{

}

public override void VerifyRenderingInServerForm(Control control)

{

}

protected void Button3_Click(object sender, EventArgs e)

{

string attachment = "";

attachment = "attachment; filename= SMSSENDINGREPORTS.xls";

Response.ClearContent();

Response.AddHeader("content-disposition", attachment);

Response.ContentType = "application/ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

HtmlForm frm = new HtmlForm();

GridView1.Parent.Controls.Add(frm);

frm.Controls.Add(GridView1);

frm.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

protected void btn_export_Click(object sender, EventArgs e)

{

string attachment = "";

attachment = "attachment; filename= SMSSENDINGREPORTS.xls";

Response.ClearContent();

Response.AddHeader("content-disposition", attachment);

Response.ContentType = "application/ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

HtmlForm frm = new HtmlForm();

GridView1 .Parent.Controls.Add(frm);

frm.Controls.Add(GridView1 );

frm.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

//.cs page classfile//

using System;

using System.Data;

using System.Collections.Generic;

using System.Configuration;

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.Common;

using System.Data.SqlClient;

/// <summary>

/// Summary description for company

/// </summary>

///

namespace grid

{

public class company

{

private string company_name;

private string product_name;

private int c_id;

public string companyname

{

get

{

return company_name;

}

set

{

company_name = value;

}

public int id

{

get

{

return c_id ;

}

set

{

c_id = value;

}

public string productname

{

get

{

return product_name;

}

set

{

product_name = value;

}

public void add()

{

//SqlConnection cn = new SqlConnection(ConfigurationManager .ConnectionStrings [1].ConnectionString );

SqlConnection cn = new SqlConnection(ConfigurationManager .AppSettings ["cn"]);

cn.Open();

SqlCommand cmd = new SqlCommand("insertgridlist_sp", cn);

cmd.Parameters.AddWithValue("@companyname", company_name);

cmd.Parameters.AddWithValue("@productname", product_name);

cmd.CommandType = CommandType.StoredProcedure;

cmd.ExecuteNonQuery();

cn.Close();

}

public void delete(int id)

{

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

cn.Open();

SqlCommand cmd = new SqlCommand("deleterow_sp", cn);

cmd.Parameters.AddWithValue("@id",id );

cmd.CommandType = CommandType.StoredProcedure;

cmd.ExecuteNonQuery();

cn.Close();

}

public static DataSet show()

{

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

cn.Open();

DataSet ds = new DataSet();

string str = "select_sp";

SqlCommand cmd = new SqlCommand(str,cn);

SqlDataAdapter da = new SqlDataAdapter(cmd);

try

{

da.Fill(ds);

}

catch(Exception e)

{

throw e;

}

return ds;

}

public void update()

{

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

cn.Open();

SqlCommand cmd = new SqlCommand("str_company_update",cn);

cmd.Parameters.AddWithValue("@id",id);

cmd.Parameters.AddWithValue("@companyname", company_name);

cmd.Parameters.AddWithValue("@productname", product_name);

cmd.CommandType = CommandType.StoredProcedure;

cmd.ExecuteNonQuery();

cn.Close();

}

public static DataSet show1(int id)

{

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

cn.Open();

DataSet ds = new DataSet();

string str = "select_join_sp";

SqlCommand cmd = new SqlCommand(str, cn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@id", id);

SqlDataAdapter da = new SqlDataAdapter(cmd);

try

{

da.Fill(ds);

}

catch (Exception e)

{

throw e;

}

return ds;

}

public static DataSet Grid1()

{

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);

cn.Open();

DataSet ds = new DataSet();

string str = "select_grid_sp";

SqlCommand cmd = new SqlCommand(str, cn);

SqlDataAdapter da = new SqlDataAdapter(cmd);

try

{

da.Fill(ds);

}

catch (Exception e)

{

throw e;

}

return ds;

}

image upload and retrive in gridview

//.aspx file//

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="upload.aspx.cs" Inherits="upload" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td style="width: 100px">
images</td>
<td style="width: 100px">
<asp:FileUpload ID="FileUpload1" runat="server" /></td>
</tr>
<tr>
<td colspan="2">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnPageIndexChanging="GridView1_PageIndexChanging">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" />
<asp:TemplateField>
<HeaderTemplate>
<asp:Label ID="Label1" runat="server" Text="Image"></asp:Label>
</HeaderTemplate>
<ItemTemplate >
<asp:Image ID ="img1" runat ="server" ImageUrl='<%# Eval("img","~/Upload/{0}") %>' Width="50px" Height ="50px"/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:Button ID="btn_submit" runat="server" OnClick="btn_submit_Click" Text="submit" /></td>
</tr>
</table>

</div>
</form>
</body>
</html>

//.aspx.cs file//

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Data.SqlClient;

using System.Drawing;

using System.IO;

public partial class upload : System.Web.UI.Page

{

SqlConnection cn = new SqlConnection(ConfigurationManager .ConnectionStrings [1].ConnectionString );

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

bind();

}

protected void btn_submit_Click(object sender, EventArgs e)

{

cn.Open();

//SqlCommand cmd = new SqlCommand("insert into image_tbl values('" + FileUpload1.FileName + "')", cn);

//cmd.ExecuteNonQuery();

string filePath = MapPath("~/UPLOAD") + "/";

string fname = FileUpload1.FileName;

string extention = Path.GetExtension (fname).ToLower();

if (FileUpload1.HasFile)

{

if (extention == ".jpg" || extention == ".png" || extention == ".bmp" || extention ==".gif ")

{

SqlCommand cmd = new SqlCommand("insert into image_tbl values('" + FileUpload1.FileName + "')", cn);

cmd.ExecuteNonQuery();

//FileUpload1.SaveAs(Path + fname);

FileUpload1.SaveAs(Server.MapPath("~/UPLOAD"+ "/") + fname);

Response.Write("<script>alert('file is uploaded successfully')</script>");

cn.Close();

bind();

}

else

{ Response.Write("<script>alert('this format not valide')</script>"); }

}

//cn.Close();

//bind();

}

public void bind()

{

cn.Open();

SqlCommand cmd = new SqlCommand("select * from image_tbl",cn);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

GridView1.PageIndex = e.NewPageIndex;

bind();

}

3-Tier using DAL, BAL in C#

Posted on April 14, 2012

/////*.aspx/////

/////*.aspx.cs ////

public partial class _Default : System.Web.UI.Page
{

Bal bal1 = new Bal();

protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
Bal bal1 = new Bal();
bal1.name = TextBox1.Text;
bal1.Phone_no = Convert.ToDecimal(TextBox2.Text);
bal1.Age = Convert.ToDecimal(TextBox3.Text);
int result = Bal.Insert_bal(bal1);
}

protected void Button2_Click(object sender, EventArgs e)
{
bind_grid();
}

protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView2.EditIndex = e.NewEditIndex;
bind_grid();
}

private void bind_grid()
{
DataSet ds = new DataSet();
ds = Bal.view();
GridView1.DataSource = ds;
GridView1.DataBind();
GridView2.DataSource = ds;
GridView2.DataBind();
}

protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
bal1.Id=Convert.ToDecimal(GridView2.Rows[e.RowIndex].Cells[1].Text);

TextBox txt1 = new TextBox();
txt1 = (TextBox)GridView2.Rows[e.RowIndex].Cells[2].Controls[0];
bal1.name = txt1.Text;

TextBox txt2 = new TextBox();
txt2 = (TextBox)GridView2.Rows[e.RowIndex].Cells[3].Controls[0];
bal1.Age = Convert.ToDecimal(txt2.Text);

int re=Bal.update(bal1);
GridView2.EditIndex = -1;
bind_grid();

}

protected void GridView2_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView2.EditIndex = -1;
bind_grid();
}

protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
bal1.Id=Convert.ToDecimal(GridView2.Rows[e.RowIndex].Cells[1].Text);

int re = Bal.delete(Convert.ToInt32(bal1.Id));

bind_grid();

}

protected void Button3_Click(object sender, EventArgs e)
{
bal1.Id=Convert.ToInt32(TextBox1.Text);
int re = Bal.delete(Convert.ToInt32(bal1.Id));
}
}

/////web.config/////

/////DAL.cs/////

using System;
using System.Data;
using System.Configuration;
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;
/// <summary>
/// Summary description for Dal
/// </summary>
public class Dal
{
public static string connect ;

public Dal()
{
//
// TODO: Add constructor logic here
//
}

public static int Insert(Bal obj_insert)
{
int result;
try
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ToString();
SqlCommand cmd = new SqlCommand(“sp_insert_Emp_Detail”, con);
cmd.CommandType = CommandType.StoredProcedure;

// cmd.CommandText = “sp_insert_Emp_Detail”;

con.Open();

cmd.Parameters.AddWithValue(“Name”, obj_insert.name);
cmd.Parameters.AddWithValue(“Phone_no”, obj_insert.Phone_no);
cmd.Parameters.AddWithValue(“Age”, obj_insert.Age);

result= cmd.ExecuteNonQuery();

con.Close();

}
catch (Exception ex)
{
throw ex;
}
return result;
}

public static DataSet view()
{
DataSet ds=new DataSet();
try
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ToString();
//SqlCommand cmd = new SqlCommand(“View_sp”, con);
//cmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter adp = new SqlDataAdapter(“View_sp”, con);

con.Open();
//DataSet ds=new DataSet();
adp.Fill(ds);
con.Close();
}
catch(Exception ex)
{
throw ex;
}
return ds;
}

public static int update(Bal bal1)
{
int result;
try
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ToString();
SqlCommand cmd = new SqlCommand(“Update_sp”, con);
cmd.CommandType = CommandType.StoredProcedure;

con.Open();
cmd.Parameters.AddWithValue(“Id”, bal1.Id);
cmd.Parameters.AddWithValue(“Name”, bal1.name);
cmd.Parameters.AddWithValue(“Age”, bal1.Age);

result = cmd.ExecuteNonQuery();
con.Close();

}
catch (Exception ex)
{
throw ex;
}
return result;
}
public static int delete(int Id)
{
int result;
try
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ToString();
SqlCommand cmd = new SqlCommand(“Delete_sp”, con);
cmd.CommandType = CommandType.StoredProcedure;

con.Open();
cmd.Parameters.AddWithValue(“Id”, Id);
result=cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
throw ex;

}
return result;
}
}

/////BAL.cs/////

/// <summary>
/// Summary description for Bal
/// </summary>
public class Bal
{
public Bal()
{
//
// TODO: Add constructor logic here
//
}
private Decimal _Id;
public Decimal Id
{
get { return _Id; }
set { _Id = value; }
}
private String _name;
public String name
{
get { return _name; }
set { _name = value; }
}

private Decimal _Phone_no;
public Decimal Phone_no
{
get { return _Phone_no; }
set { _Phone_no = value; }
}
private Decimal _Age;
public Decimal Age
{
get { return _Age; }
set { _Age = value; }
}

public static int Insert_bal(Bal bal1)
{
try
{

return Dal.Insert(bal1);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataSet view()
{
try
{
return Dal.view();
}
catch (Exception ex)
{
throw ex;
}
}
public static int update(Bal bal1)
{
try
{
return Dal.update(bal1);
}
catch (Exception ex)
{
throw ex;
}
}
public static int delete(int Id)
{
try
{
return Dal.delete(Id);
}
catch (Exception ex)
{
throw ex;
}
}
}

itblog

Tuesday, 24 April 2012

Sunday, 22 April 2012

3 -Tier using edmx in MS Visual Studio 2010 + Dropdown Binding and File Uploadind,Downloading in Gridview + Auto Complete Extender using Web Service

Saturday, 14 April 2012

All In Three Tier (insert)(update,delete in gridview )with export to excel

image upload and retrive in gridview

3-Tier using DAL, BAL in C#

3-Tier using DAL, BAL in C#

About Me

Blog Archive