itblog: 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();
}
}

itblog

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

No comments:

Post a Comment

About Me

Blog Archive