.cs code
=========================
string sqlconn = ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;
SqlConnection con = null;
SqlDataAdapter da = null;
SqlCommand cmd = null;
SqlDataReader dr = null;
DataSet ds = null;
string strsearch = "";
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(sqlconn);
if (Request.QueryString["sid"] != null)
{
if (Session["sid"] != null)
{
if (Session["sid"].ToString() == Session.SessionID && Session["sid"].ToString() == Request.QueryString["sid"].ToString())
{
}
else
{
Response.Redirect("Login.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
showsearchdata();
showclientdetailsdata();
// showdata();
}
}
private void showdata()
{
con.Open();
da = new SqlDataAdapter("select ROW_NUMBER() OVER(ORDER BY companyname)as Sno,companydetailsguid, reqno,companyname,dscuserid,contactpersonname,contactno,contactemailid,emailpwd,pfxpwd,convert(varchar,dateofissue,103) as dateofissue,convert(varchar,dateofrenual,103) as dateofrenual,classtype,dealername,contractortype from companydetailstbl where activestatus=1", con);
ds = new DataSet();
da.Fill(ds,"companydetailtbl");
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
private void showclientdetailsdata()
{
Gridviewclinetdetails.Visible = true;
con.Open();
cmd = new SqlCommand("select ROW_NUMBER() OVER(ORDER BY companyname)as Sno,clientdetailsguid, companyname,portal,userid,password,etokenpassword from clientdetailstbl where companyname=@companyname", con);
cmd.Parameters.Add(new SqlParameter("@companyname", txtsearch.Text));
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "clientdetailstbl");
Gridviewclinetdetails.DataSource = ds;
Gridviewclinetdetails.DataBind();
con.Close();
}
private void showsearchdata()
{
con.Open();
cmd = new SqlCommand("select ROW_NUMBER() OVER(ORDER BY companyname)as Sno,companydetailsguid, reqno,companyname,dscuserid,contactpersonname,contactno,contactemailid,emailpwd,pfxpwd,convert(varchar,dateofissue,103) as dateofissue,convert(varchar,dateofrenual,103) as dateofrenual,classtype,dealername,contractortype from companydetailstbl where companyname=@companyname and activestatus=1 ", con);
cmd.Parameters.Add(new SqlParameter("companyname",txtsearch.Text));
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "companydetailtbl");
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
if (txtsearch.Text == "")
{
// showdata();
}
else
{
showsearchdata();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
Label lblcompanydetailsguid = (Label)row.FindControl("lblcompanydetailsguid");
TextBox txtreqno = (TextBox)row.FindControl("txtreqno");
TextBox txtcompanyname = (TextBox)row.FindControl("txtcompanyname");
TextBox txtdscuserid = (TextBox)row.FindControl("txtdscuserid");
TextBox txtcontactpersonname = (TextBox)row.FindControl("txtcontactpersonname");
TextBox txtcontactno = (TextBox)row.FindControl("txtcontactno");
TextBox txtcontactemailid = (TextBox)row.FindControl("txtcontactemailid");
TextBox txtemailpwd = (TextBox)row.FindControl("txtemailpwd");
TextBox txtpfxpwd = (TextBox)row.FindControl("txtpfxpwd");
TextBox txtdateofissue = (TextBox)row.FindControl("txtdateofissue");
TextBox txtdateofrenual = (TextBox)row.FindControl("txtdateofrenual");
TextBox txtdealername = (TextBox)row.FindControl("txtdealername");
DropDownList ddlclasstype = (DropDownList)row.FindControl("DropDownList2");
DropDownList ddlcontractortype = (DropDownList)row.FindControl("DropDownList1");
con.Open();
cmd = new SqlCommand("update companydetailstbl set reqno = @reqno,companyname = @companyname,dscuserid = @dscuserid,contactpersonname = @contactpersonname,contactno = @contactno,contactemailid = @contactemailid,emailpwd = @emailpwd,pfxpwd = @pfxpwd,dateofissue=CONVERT(datetime,@dateofissue,103),dateofexp=CONVERT(datetime,@dateofexp,103),dateofrenual=CONVERT(datetime,@dateofrenual,103),classtype = @classtype,dealername = @dealername,contractortype = @contractortype where companydetailsguid = @companydetailsguid", con);
cmd.Parameters.Add(new SqlParameter("@reqno", txtreqno.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@companyname", txtcompanyname.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@dscuserid", txtdscuserid.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@contactpersonname", txtcontactpersonname.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@contactno", txtcontactno.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@contactemailid", txtcontactemailid.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@emailpwd", txtemailpwd.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@pfxpwd", txtpfxpwd.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@dateofissue", txtdateofissue.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@dateofexp", txtdateofrenual.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@dateofrenual", txtdateofrenual.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@classtype", ddlclasstype.SelectedValue.ToString().Trim()));
cmd.Parameters.Add(new SqlParameter("@dealername", txtdealername.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@contractortype", ddlcontractortype.SelectedValue.ToString().Trim()));
cmd.Parameters.Add(new SqlParameter("@companydetailsguid", lblcompanydetailsguid.Text.ToString().Trim()));
cmd.ExecuteNonQuery();
con.Close();
con.Open();
cmd = new SqlCommand("update clientdetailstbl set companyname = @companyname where companydetailsguid=@companydetailsguid", con);
cmd.Parameters.Add(new SqlParameter("@companyname", txtcompanyname.Text.ToString().Trim()));
cmd.Parameters.Add(new SqlParameter("@companydetailsguid", lblcompanydetailsguid.Text.ToString().Trim()));
cmd.ExecuteNonQuery();
con.Close();
if (txtsearch.Text !="" && txtsearch.Text != txtcompanyname.Text)
{
txtsearch.Text = txtcompanyname.Text;
}
GridView1.EditIndex = -1;
if (txtsearch.Text == "")
{
// showdata();
}
else
{
showsearchdata();
}
ScriptManager.RegisterStartupScript(this, GetType(), "Alert", "alert('Updated successfully');", true);
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
if (txtsearch.Text == "")
{
// showdata();
}
else
{
showsearchdata();
}
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
if (txtsearch.Text == "")
{
// showdata();
}
else
{
showsearchdata();
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataRowView drv = e.Row.DataItem as DataRowView;
if (e.Row.RowType == DataControlRowType.DataRow)
{
LinkButton lnk = (LinkButton) e.Row.FindControl("lnkbtndelete");
lnk.Attributes.Add("onclick", "javascript:return confirm('Are you sure you want to delete this record');");
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DropDownList dp = (DropDownList)e.Row.FindControl("DropDownList1");
DataTable dt = load_contractortype();
for (int i = 0; i < dt.Rows.Count; i++)
{
ListItem lt = new ListItem();
lt.Text = dt.Rows[i][0].ToString();
dp.Items.Add(lt);
}
dp.SelectedValue = drv[14].ToString(); // CONTRACTORTYPE
DropDownList dp1 = (DropDownList)e.Row.FindControl("DropDownList2");
DataTable dt1 = load_classtype();
for (int i = 0; i < dt1.Rows.Count; i++)
{
ListItem lt = new ListItem();
lt.Text = dt1.Rows[i][0].ToString();
dp1.Items.Add(lt);
}
dp1.SelectedValue = drv[12].ToString(); // CLASSTYPE
}
}
}
public DataTable load_contractortype()
{
DataTable dt = new DataTable();
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
string sql = "select * from contractortypetbl";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
SqlDataAdapter sd = new SqlDataAdapter(cmd);
sd.Fill(dt);
con.Close();
return dt;
}
public DataTable load_classtype()
{
DataTable dt = new DataTable();
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
string sql = "select * from classtypetbl";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
SqlDataAdapter sd = new SqlDataAdapter(cmd);
sd.Fill(dt);
con.Close();
return dt;
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string companydetailsguid = (string)GridView1.DataKeys[e.RowIndex].Value;
con.Open();
cmd = new SqlCommand("delete from companydetailstbl where companydetailsguid = @companydetailsguid", con);
cmd.Parameters.Add(new SqlParameter("@companydetailsguid", companydetailsguid));
cmd.ExecuteNonQuery();
con.Close();
con.Open();
cmd = new SqlCommand("delete from clientdetailstbl where companydetailsguid = @companydetailsguid", con);
cmd.Parameters.Add(new SqlParameter("@companydetailsguid", companydetailsguid));
cmd.ExecuteNonQuery();
con.Close();
// showdata();
txtsearch.Text = "";
showsearchdata();
showclientdetailsdata();
ScriptManager.RegisterStartupScript(this, GetType(), "Alert", "alert('Deleted successfully');", true);
}
protected void btnsearch_Click(object sender, EventArgs e)
{
strsearch = txtsearch.Text;
if (strsearch != "")
{
con.Open();
cmd = new SqlCommand("select ROW_NUMBER() OVER(ORDER BY companyname)as Sno,companydetailsguid, reqno,companyname,dscuserid,contactpersonname,contactno,contactemailid,emailpwd,pfxpwd,convert(varchar,dateofissue,103) as dateofissue,convert(varchar,dateofrenual,103) as dateofrenual,classtype,dealername,contractortype from companydetailstbl where companyname=@companyname and activestatus=1", con);
cmd.Parameters.Add(new SqlParameter("@companyname",strsearch));
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "companydetailtbl");
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
// binding clentdeatils to gridview2
cmd = new SqlCommand("select ROW_NUMBER() OVER(ORDER BY companyname)as Sno,clientdetailsguid, companyname,portal,userid,password,etokenpassword from clientdetailstbl where companyname=@companyname", con);
cmd.Parameters.Add(new SqlParameter("@companyname", strsearch));
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "clientdetailstbl");
if (ds.Tables[0].Rows.Count > 0)
{
Gridviewclinetdetails.Visible = true;
Gridviewclinetdetails.DataSource = ds;
Gridviewclinetdetails.DataBind();
}
else
{
Gridviewclinetdetails.Visible = true;
Gridviewclinetdetails.EmptyDataText = "No clientdeatils";
Gridviewclinetdetails.DataBind();
}
}
else
{
ScriptManager.RegisterStartupScript(this,GetType(),"Alert","alert('Companyname doesnot exist');",true);
}
con.Close();
}
else
{
// showdata();
Gridviewclinetdetails.Visible = false;
}
}
protected void Gridviewclinetdetails_RowEditing(object sender, GridViewEditEventArgs e)
{
Gridviewclinetdetails.EditIndex = e.NewEditIndex;
showclientdetailsdata();
}
protected void Gridviewclinetdetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = (GridViewRow)Gridviewclinetdetails.Rows[e.RowIndex];
string clientdetailsguid = (string) Gridviewclinetdetails.DataKeys[e.RowIndex].Value;
DropDownList ddleditprotal = (DropDownList)row.FindControl("ddleditprotal");
TextBox txtuserid = (TextBox)row.FindControl("txtuserid");
TextBox txtpassword = (TextBox)row.FindControl("txtpassword");
DropDownList ddleditetokenpwd = (DropDownList)row.FindControl("ddleditetokenpwd");
con.Open();
cmd = new SqlCommand("update clientdetailstbl set portal=@portal,userid=@userid,password=@password,etokenpassword=@etokenpassword where clientdetailsguid= @clientdetailsguid",con);
cmd.Parameters.Add(new SqlParameter("@portal",ddleditprotal.SelectedValue.ToString().Trim()));
cmd.Parameters.Add(new SqlParameter("@userid",txtuserid.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@password",txtpassword.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@etokenpassword",ddleditetokenpwd.SelectedValue.ToString().Trim()));
cmd.Parameters.Add(new SqlParameter("@clientdetailsguid",clientdetailsguid));
cmd.ExecuteNonQuery();
con.Close();
Gridviewclinetdetails.EditIndex = -1;
showclientdetailsdata();
ScriptManager.RegisterStartupScript(this, GetType(), "Alert", "alert('Updated successfully');", true);
}
protected void Gridviewclinetdetails_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataRowView drv = e.Row.DataItem as DataRowView;
if (e.Row.RowType == DataControlRowType.DataRow)
{
LinkButton lnkclientedetailsbtn = (LinkButton)e.Row.FindControl("lnkclientdeetailsdeletebtn");
lnkclientedetailsbtn.Attributes.Add("onclick", "javascript:return confirm('Are you sure you want to delete this record');");
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DropDownList ddleditportal = (DropDownList)e.Row.FindControl("ddleditprotal");
DropDownList ddleditetokenpwd = (DropDownList)e.Row.FindControl("ddleditetokenpwd");
DataTable dt = load_portalddl();
ddleditportal.DataSource = dt;
ddleditportal.DataTextField = "portal";
ddleditportal.DataValueField = "portal";
ddleditportal.DataBind();
DataTable dt1 = load_etokenpwdddl();
ddleditetokenpwd.DataSource = dt1;
ddleditetokenpwd.DataTextField = "etokenpwd";
ddleditetokenpwd.DataValueField = "etokenpwd";
ddleditetokenpwd.DataBind();
ddleditportal.SelectedValue = drv[3].ToString();
ddleditetokenpwd.SelectedValue = drv[6].ToString();
}
}
}
private DataTable load_etokenpwdddl()
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = new SqlCommand("select distinct etokenpwd from etokenpwdtbl", con);
da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
return dt;
}
private DataTable load_portalddl()
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = new SqlCommand("select distinct portal from portaltbl", con);
da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
return dt;
}
protected void Gridviewclinetdetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
Gridviewclinetdetails.EditIndex = -1;
showclientdetailsdata();
}
protected void Gridviewclinetdetails_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
Gridviewclinetdetails.PageIndex = e.NewPageIndex;
showclientdetailsdata();
}
protected void Gridviewclinetdetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string clientdetailsguid = (string)Gridviewclinetdetails.DataKeys[e.RowIndex].Value;
con.Open();
cmd = new SqlCommand("delete from clientdetailstbl where clientdetailsguid = @clientdetailsguid", con);
cmd.Parameters.Add(new SqlParameter("@clientdetailsguid", clientdetailsguid));
cmd.ExecuteNonQuery();
con.Close();
showclientdetailsdata();
ScriptManager.RegisterStartupScript(this,GetType(),"Alert","alert('Deleted successfully');",true);
}
.aspx code
=================
<style type="text/css">
.GridviewDiv {font-size: 100%; font-family: 'Lucida Grande', 'Lucida Sans Unicode', Verdana, Arial, Helevetica, sans-serif; color: #303933;}
Table.Gridview{border:solid 1px #df5015;}
.GridviewTable{border:none;}
.GridviewTable td{margin-top:0;padding: 0; vertical-align:middle }
.GridviewTable tr{color: White; background-color: #df5015; height: 30px; text-align:center}
.Gridview th{color:#FFFFFF;border-right-color:#abb079;border-bottom-color:#abb079;padding:0.5em 0.5em 0.5em 0.5em;text-align:center; width:50%;}
.Gridview td{border-bottom-color:#f0f2da;border-right-color:#f0f2da;padding:0.5em 0.5em 0.5em 0.5em; word-wrap: break-word;WORD-BREAK:BREAK-ALL;overflow: hidden;text-overflow: ellipsis;
}
.Gridview tr{color: Black; background-color: White; text-align:left;}
:link,:visited { color: #DF4F13; text-decoration:none }
</style>
<script src="autocomplete/jquery-1.4.1.min.js" type="text/javascript"></script>
<script src="autocomplete/jquery.autocomplete.js" type="text/javascript"></script>
<link href="autocomplete/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
$(document).ready(function () {
var sid = location.search.substring(1);
sid = sid.split('=');
//alert(sid);
$("#savefriends").attr("href", "savefriendsinfo.aspx?sid=" + sid[1]);
$("#saveofficers").attr("href", "saveoffiecersinfo.aspx?sid=" + sid[1]);
$("#displayfriends").attr("href", "displayfriendsinfo.aspx?sid=" + sid[1]);
$("#displayofficers").attr("href", "displayofficersinfo.aspx?sid=" + sid[1]);
$("#Excelsf").attr("href", "ExcelSavefriends.aspx?sid=" + sid[1]);
$("#Excelso").attr("href", "ExcelSaveofficers.aspx?sid=" + sid[1]);
$("#companydetails").attr("href", "companydetails.aspx?sid=" + sid[1]);
$("#clientdetails").attr("href", "clientdetails.aspx?sid=" + sid[1]);
$("#displaycompanydetails").attr("href", "displaycompanydetails.aspx?sid=" + sid[1]);
$("#renualcompanydetails").attr("href", "Renualcompanydetails.aspx?sid=" + sid[1]);
$("#importcompanydetails").attr("href", "importcompanydetails.aspx?sid=" + sid[1]);
$("#importclientdetails").attr("href", "importclientdetails.aspx?sid=" + sid[1]);
$("#importcontractortypedetails").attr("href", "importcontractortypedetails.aspx?sid=" + sid[1]);
$("#importrenualcompanydetails").attr("href", "importrenualcompanydetails.aspx?sid=" + sid[1]);
$("#excelexportcompanydetails").attr("href", "Excelexportcompanydetails.aspx?sid=" + sid[1]);
$("#excelexportclientdetails").attr("href", "Excelexportclientdetails.aspx?sid=" + sid[1]);
$("#<%= txtsearch.ClientID %>").autocomplete('Handler.ashx?StrMethodName=autocompletecompanynamesbycompanyedetailstbl');
});
</script>
<span style="text-decoration:underline;"><b>DisplayCompanydetails:</b></span><br />
<div id="divsearch">
Companyname:<asp:TextBox ID="txtsearch" runat="server"></asp:TextBox>
<asp:Button ID="btnsearch" runat="server" Text="Submit"
onclick="btnsearch_Click" />
</div>
<div id="showcompanydetailsdiv" style="overflow:auto;">
<asp:GridView ID="GridView1" DataKeyNames="companydetailsguid" runat="server"
AutoGenerateColumns="false" CssClass="Gridview"
CellPadding="4" ForeColor="#333333" GridLines="Both" Width="100%"
HorizontalAlign="Center" AllowPaging="True"
onpageindexchanging="GridView1_PageIndexChanging" PageSize="3"
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating"
onrowdatabound="GridView1_RowDataBound"
onrowdeleting="GridView1_RowDeleting" >
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#4A97CA" Height="30px" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="black" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="Sno" HeaderText="Sno" />
<asp:TemplateField HeaderText="companydetailsguid" Visible="false">
<ItemTemplate>
<asp:Label ID="lblcompanydetailsguid" runat="server" Text='<%# Eval("companydetailsguid") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Reqno">
<ItemTemplate>
<%# Eval("reqno") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtreqno" Text='<%# Eval("reqno") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Compname" >
<ItemTemplate>
<%# Eval("companyname")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtcompanyname" Width="100px" Text='<%# Eval("companyname") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Dscuserid">
<ItemTemplate>
<%# Eval("dscuserid")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtdscuserid" Text='<%# Eval("dscuserid") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Cname">
<ItemTemplate>
<%# Eval("contactpersonname")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtcontactpersonname" Text='<%# Eval("contactpersonname") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contactno">
<ItemTemplate>
<%# Eval("contactno")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtcontactno" Text='<%# Eval("contactno") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Emailid">
<ItemTemplate>
<%# Eval("contactemailid")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtcontactemailid" Text='<%# Eval("contactemailid") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Emailpwd">
<ItemTemplate>
<%# Eval("emailpwd")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtemailpwd" Text='<%# Eval("emailpwd") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="PFXpwd">
<ItemTemplate>
<%# Eval("pfxpwd")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtpfxpwd" Text='<%# Eval("pfxpwd") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Doi">
<ItemTemplate>
<%# Eval("dateofissue") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtdateofissue" Text='<%# Eval("dateofissue") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Dor">
<ItemTemplate>
<%# Eval("dateofrenual")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtdateofrenual" Text='<%# Eval("dateofrenual") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Classtype">
<ItemTemplate>
<%# Eval("classtype") %>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="DropDownList2" runat="server" >
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Dealername">
<ItemTemplate>
<%# Eval("dealername")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtdealername" Text='<%# Eval("dealername") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Types">
<ItemTemplate>
<%# Eval("contractortype") %>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" >
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="Action" ShowCancelButton="true" ShowEditButton="true" />
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="lnkbtndelete" CommandArgument='<%# Eval("companydetailsguid") %>' CommandName="Delete" Text="Delete" runat="server"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:GridView ID="Gridviewclinetdetails" DataKeyNames="clientdetailsguid" runat="server"
AutoGenerateColumns="false" CssClass="Gridview"
CellPadding="4" ForeColor="#333333" GridLines="Both" Width="100%"
HorizontalAlign="Center" AllowPaging="True"
onpageindexchanging="Gridviewclinetdetails_PageIndexChanging"
onrowcancelingedit="Gridviewclinetdetails_RowCancelingEdit"
onrowdatabound="Gridviewclinetdetails_RowDataBound"
onrowediting="Gridviewclinetdetails_RowEditing"
onrowupdating="Gridviewclinetdetails_RowUpdating"
onrowdeleting="Gridviewclinetdetails_RowDeleting">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#4A97CA" Height="30px" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="black" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="Sno" HeaderText="Sno" />
<asp:TemplateField HeaderText="clientdetailsguid" Visible="false" >
<ItemTemplate>
<asp:Label ID="lblclientdetailsguid" runat="server" Text='<%# Eval("clientdetailsguid") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Portal">
<ItemTemplate>
<%# Eval("portal")%>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="ddleditprotal" runat="server">
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="userid">
<ItemTemplate>
<%# Eval("userid")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtuserid" runat="server" Text='<%# Eval("userid") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Password">
<ItemTemplate>
<%# Eval("password")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtpassword" runat="server" Text='<%# Eval("password") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="etokenpassword">
<ItemTemplate>
<%# Eval("etokenpassword") %>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="ddleditetokenpwd" runat="server">
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="Action" ShowCancelButton="true" ShowEditButton="true" />
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="lnkclientdeetailsdeletebtn" runat="server" CommandArgument='<%# Eval("clientdetailsguid") %>' Text="Delete" CommandName="Delete"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
=========================
string sqlconn = ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;
SqlConnection con = null;
SqlDataAdapter da = null;
SqlCommand cmd = null;
SqlDataReader dr = null;
DataSet ds = null;
string strsearch = "";
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(sqlconn);
if (Request.QueryString["sid"] != null)
{
if (Session["sid"] != null)
{
if (Session["sid"].ToString() == Session.SessionID && Session["sid"].ToString() == Request.QueryString["sid"].ToString())
{
}
else
{
Response.Redirect("Login.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
}
else
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
showsearchdata();
showclientdetailsdata();
// showdata();
}
}
private void showdata()
{
con.Open();
da = new SqlDataAdapter("select ROW_NUMBER() OVER(ORDER BY companyname)as Sno,companydetailsguid, reqno,companyname,dscuserid,contactpersonname,contactno,contactemailid,emailpwd,pfxpwd,convert(varchar,dateofissue,103) as dateofissue,convert(varchar,dateofrenual,103) as dateofrenual,classtype,dealername,contractortype from companydetailstbl where activestatus=1", con);
ds = new DataSet();
da.Fill(ds,"companydetailtbl");
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
private void showclientdetailsdata()
{
Gridviewclinetdetails.Visible = true;
con.Open();
cmd = new SqlCommand("select ROW_NUMBER() OVER(ORDER BY companyname)as Sno,clientdetailsguid, companyname,portal,userid,password,etokenpassword from clientdetailstbl where companyname=@companyname", con);
cmd.Parameters.Add(new SqlParameter("@companyname", txtsearch.Text));
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "clientdetailstbl");
Gridviewclinetdetails.DataSource = ds;
Gridviewclinetdetails.DataBind();
con.Close();
}
private void showsearchdata()
{
con.Open();
cmd = new SqlCommand("select ROW_NUMBER() OVER(ORDER BY companyname)as Sno,companydetailsguid, reqno,companyname,dscuserid,contactpersonname,contactno,contactemailid,emailpwd,pfxpwd,convert(varchar,dateofissue,103) as dateofissue,convert(varchar,dateofrenual,103) as dateofrenual,classtype,dealername,contractortype from companydetailstbl where companyname=@companyname and activestatus=1 ", con);
cmd.Parameters.Add(new SqlParameter("companyname",txtsearch.Text));
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "companydetailtbl");
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
if (txtsearch.Text == "")
{
// showdata();
}
else
{
showsearchdata();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
Label lblcompanydetailsguid = (Label)row.FindControl("lblcompanydetailsguid");
TextBox txtreqno = (TextBox)row.FindControl("txtreqno");
TextBox txtcompanyname = (TextBox)row.FindControl("txtcompanyname");
TextBox txtdscuserid = (TextBox)row.FindControl("txtdscuserid");
TextBox txtcontactpersonname = (TextBox)row.FindControl("txtcontactpersonname");
TextBox txtcontactno = (TextBox)row.FindControl("txtcontactno");
TextBox txtcontactemailid = (TextBox)row.FindControl("txtcontactemailid");
TextBox txtemailpwd = (TextBox)row.FindControl("txtemailpwd");
TextBox txtpfxpwd = (TextBox)row.FindControl("txtpfxpwd");
TextBox txtdateofissue = (TextBox)row.FindControl("txtdateofissue");
TextBox txtdateofrenual = (TextBox)row.FindControl("txtdateofrenual");
TextBox txtdealername = (TextBox)row.FindControl("txtdealername");
DropDownList ddlclasstype = (DropDownList)row.FindControl("DropDownList2");
DropDownList ddlcontractortype = (DropDownList)row.FindControl("DropDownList1");
con.Open();
cmd = new SqlCommand("update companydetailstbl set reqno = @reqno,companyname = @companyname,dscuserid = @dscuserid,contactpersonname = @contactpersonname,contactno = @contactno,contactemailid = @contactemailid,emailpwd = @emailpwd,pfxpwd = @pfxpwd,dateofissue=CONVERT(datetime,@dateofissue,103),dateofexp=CONVERT(datetime,@dateofexp,103),dateofrenual=CONVERT(datetime,@dateofrenual,103),classtype = @classtype,dealername = @dealername,contractortype = @contractortype where companydetailsguid = @companydetailsguid", con);
cmd.Parameters.Add(new SqlParameter("@reqno", txtreqno.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@companyname", txtcompanyname.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@dscuserid", txtdscuserid.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@contactpersonname", txtcontactpersonname.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@contactno", txtcontactno.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@contactemailid", txtcontactemailid.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@emailpwd", txtemailpwd.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@pfxpwd", txtpfxpwd.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@dateofissue", txtdateofissue.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@dateofexp", txtdateofrenual.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@dateofrenual", txtdateofrenual.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@classtype", ddlclasstype.SelectedValue.ToString().Trim()));
cmd.Parameters.Add(new SqlParameter("@dealername", txtdealername.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@contractortype", ddlcontractortype.SelectedValue.ToString().Trim()));
cmd.Parameters.Add(new SqlParameter("@companydetailsguid", lblcompanydetailsguid.Text.ToString().Trim()));
cmd.ExecuteNonQuery();
con.Close();
con.Open();
cmd = new SqlCommand("update clientdetailstbl set companyname = @companyname where companydetailsguid=@companydetailsguid", con);
cmd.Parameters.Add(new SqlParameter("@companyname", txtcompanyname.Text.ToString().Trim()));
cmd.Parameters.Add(new SqlParameter("@companydetailsguid", lblcompanydetailsguid.Text.ToString().Trim()));
cmd.ExecuteNonQuery();
con.Close();
if (txtsearch.Text !="" && txtsearch.Text != txtcompanyname.Text)
{
txtsearch.Text = txtcompanyname.Text;
}
GridView1.EditIndex = -1;
if (txtsearch.Text == "")
{
// showdata();
}
else
{
showsearchdata();
}
ScriptManager.RegisterStartupScript(this, GetType(), "Alert", "alert('Updated successfully');", true);
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
if (txtsearch.Text == "")
{
// showdata();
}
else
{
showsearchdata();
}
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
if (txtsearch.Text == "")
{
// showdata();
}
else
{
showsearchdata();
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataRowView drv = e.Row.DataItem as DataRowView;
if (e.Row.RowType == DataControlRowType.DataRow)
{
LinkButton lnk = (LinkButton) e.Row.FindControl("lnkbtndelete");
lnk.Attributes.Add("onclick", "javascript:return confirm('Are you sure you want to delete this record');");
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DropDownList dp = (DropDownList)e.Row.FindControl("DropDownList1");
DataTable dt = load_contractortype();
for (int i = 0; i < dt.Rows.Count; i++)
{
ListItem lt = new ListItem();
lt.Text = dt.Rows[i][0].ToString();
dp.Items.Add(lt);
}
dp.SelectedValue = drv[14].ToString(); // CONTRACTORTYPE
DropDownList dp1 = (DropDownList)e.Row.FindControl("DropDownList2");
DataTable dt1 = load_classtype();
for (int i = 0; i < dt1.Rows.Count; i++)
{
ListItem lt = new ListItem();
lt.Text = dt1.Rows[i][0].ToString();
dp1.Items.Add(lt);
}
dp1.SelectedValue = drv[12].ToString(); // CLASSTYPE
}
}
}
public DataTable load_contractortype()
{
DataTable dt = new DataTable();
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
string sql = "select * from contractortypetbl";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
SqlDataAdapter sd = new SqlDataAdapter(cmd);
sd.Fill(dt);
con.Close();
return dt;
}
public DataTable load_classtype()
{
DataTable dt = new DataTable();
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
string sql = "select * from classtypetbl";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
SqlDataAdapter sd = new SqlDataAdapter(cmd);
sd.Fill(dt);
con.Close();
return dt;
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string companydetailsguid = (string)GridView1.DataKeys[e.RowIndex].Value;
con.Open();
cmd = new SqlCommand("delete from companydetailstbl where companydetailsguid = @companydetailsguid", con);
cmd.Parameters.Add(new SqlParameter("@companydetailsguid", companydetailsguid));
cmd.ExecuteNonQuery();
con.Close();
con.Open();
cmd = new SqlCommand("delete from clientdetailstbl where companydetailsguid = @companydetailsguid", con);
cmd.Parameters.Add(new SqlParameter("@companydetailsguid", companydetailsguid));
cmd.ExecuteNonQuery();
con.Close();
// showdata();
txtsearch.Text = "";
showsearchdata();
showclientdetailsdata();
ScriptManager.RegisterStartupScript(this, GetType(), "Alert", "alert('Deleted successfully');", true);
}
protected void btnsearch_Click(object sender, EventArgs e)
{
strsearch = txtsearch.Text;
if (strsearch != "")
{
con.Open();
cmd = new SqlCommand("select ROW_NUMBER() OVER(ORDER BY companyname)as Sno,companydetailsguid, reqno,companyname,dscuserid,contactpersonname,contactno,contactemailid,emailpwd,pfxpwd,convert(varchar,dateofissue,103) as dateofissue,convert(varchar,dateofrenual,103) as dateofrenual,classtype,dealername,contractortype from companydetailstbl where companyname=@companyname and activestatus=1", con);
cmd.Parameters.Add(new SqlParameter("@companyname",strsearch));
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "companydetailtbl");
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
// binding clentdeatils to gridview2
cmd = new SqlCommand("select ROW_NUMBER() OVER(ORDER BY companyname)as Sno,clientdetailsguid, companyname,portal,userid,password,etokenpassword from clientdetailstbl where companyname=@companyname", con);
cmd.Parameters.Add(new SqlParameter("@companyname", strsearch));
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "clientdetailstbl");
if (ds.Tables[0].Rows.Count > 0)
{
Gridviewclinetdetails.Visible = true;
Gridviewclinetdetails.DataSource = ds;
Gridviewclinetdetails.DataBind();
}
else
{
Gridviewclinetdetails.Visible = true;
Gridviewclinetdetails.EmptyDataText = "No clientdeatils";
Gridviewclinetdetails.DataBind();
}
}
else
{
ScriptManager.RegisterStartupScript(this,GetType(),"Alert","alert('Companyname doesnot exist');",true);
}
con.Close();
}
else
{
// showdata();
Gridviewclinetdetails.Visible = false;
}
}
protected void Gridviewclinetdetails_RowEditing(object sender, GridViewEditEventArgs e)
{
Gridviewclinetdetails.EditIndex = e.NewEditIndex;
showclientdetailsdata();
}
protected void Gridviewclinetdetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = (GridViewRow)Gridviewclinetdetails.Rows[e.RowIndex];
string clientdetailsguid = (string) Gridviewclinetdetails.DataKeys[e.RowIndex].Value;
DropDownList ddleditprotal = (DropDownList)row.FindControl("ddleditprotal");
TextBox txtuserid = (TextBox)row.FindControl("txtuserid");
TextBox txtpassword = (TextBox)row.FindControl("txtpassword");
DropDownList ddleditetokenpwd = (DropDownList)row.FindControl("ddleditetokenpwd");
con.Open();
cmd = new SqlCommand("update clientdetailstbl set portal=@portal,userid=@userid,password=@password,etokenpassword=@etokenpassword where clientdetailsguid= @clientdetailsguid",con);
cmd.Parameters.Add(new SqlParameter("@portal",ddleditprotal.SelectedValue.ToString().Trim()));
cmd.Parameters.Add(new SqlParameter("@userid",txtuserid.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@password",txtpassword.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@etokenpassword",ddleditetokenpwd.SelectedValue.ToString().Trim()));
cmd.Parameters.Add(new SqlParameter("@clientdetailsguid",clientdetailsguid));
cmd.ExecuteNonQuery();
con.Close();
Gridviewclinetdetails.EditIndex = -1;
showclientdetailsdata();
ScriptManager.RegisterStartupScript(this, GetType(), "Alert", "alert('Updated successfully');", true);
}
protected void Gridviewclinetdetails_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataRowView drv = e.Row.DataItem as DataRowView;
if (e.Row.RowType == DataControlRowType.DataRow)
{
LinkButton lnkclientedetailsbtn = (LinkButton)e.Row.FindControl("lnkclientdeetailsdeletebtn");
lnkclientedetailsbtn.Attributes.Add("onclick", "javascript:return confirm('Are you sure you want to delete this record');");
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
DropDownList ddleditportal = (DropDownList)e.Row.FindControl("ddleditprotal");
DropDownList ddleditetokenpwd = (DropDownList)e.Row.FindControl("ddleditetokenpwd");
DataTable dt = load_portalddl();
ddleditportal.DataSource = dt;
ddleditportal.DataTextField = "portal";
ddleditportal.DataValueField = "portal";
ddleditportal.DataBind();
DataTable dt1 = load_etokenpwdddl();
ddleditetokenpwd.DataSource = dt1;
ddleditetokenpwd.DataTextField = "etokenpwd";
ddleditetokenpwd.DataValueField = "etokenpwd";
ddleditetokenpwd.DataBind();
ddleditportal.SelectedValue = drv[3].ToString();
ddleditetokenpwd.SelectedValue = drv[6].ToString();
}
}
}
private DataTable load_etokenpwdddl()
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = new SqlCommand("select distinct etokenpwd from etokenpwdtbl", con);
da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
return dt;
}
private DataTable load_portalddl()
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = new SqlCommand("select distinct portal from portaltbl", con);
da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
return dt;
}
protected void Gridviewclinetdetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
Gridviewclinetdetails.EditIndex = -1;
showclientdetailsdata();
}
protected void Gridviewclinetdetails_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
Gridviewclinetdetails.PageIndex = e.NewPageIndex;
showclientdetailsdata();
}
protected void Gridviewclinetdetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string clientdetailsguid = (string)Gridviewclinetdetails.DataKeys[e.RowIndex].Value;
con.Open();
cmd = new SqlCommand("delete from clientdetailstbl where clientdetailsguid = @clientdetailsguid", con);
cmd.Parameters.Add(new SqlParameter("@clientdetailsguid", clientdetailsguid));
cmd.ExecuteNonQuery();
con.Close();
showclientdetailsdata();
ScriptManager.RegisterStartupScript(this,GetType(),"Alert","alert('Deleted successfully');",true);
}
.aspx code
=================
<style type="text/css">
.GridviewDiv {font-size: 100%; font-family: 'Lucida Grande', 'Lucida Sans Unicode', Verdana, Arial, Helevetica, sans-serif; color: #303933;}
Table.Gridview{border:solid 1px #df5015;}
.GridviewTable{border:none;}
.GridviewTable td{margin-top:0;padding: 0; vertical-align:middle }
.GridviewTable tr{color: White; background-color: #df5015; height: 30px; text-align:center}
.Gridview th{color:#FFFFFF;border-right-color:#abb079;border-bottom-color:#abb079;padding:0.5em 0.5em 0.5em 0.5em;text-align:center; width:50%;}
.Gridview td{border-bottom-color:#f0f2da;border-right-color:#f0f2da;padding:0.5em 0.5em 0.5em 0.5em; word-wrap: break-word;WORD-BREAK:BREAK-ALL;overflow: hidden;text-overflow: ellipsis;
}
.Gridview tr{color: Black; background-color: White; text-align:left;}
:link,:visited { color: #DF4F13; text-decoration:none }
</style>
<script src="autocomplete/jquery-1.4.1.min.js" type="text/javascript"></script>
<script src="autocomplete/jquery.autocomplete.js" type="text/javascript"></script>
<link href="autocomplete/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
$(document).ready(function () {
var sid = location.search.substring(1);
sid = sid.split('=');
//alert(sid);
$("#savefriends").attr("href", "savefriendsinfo.aspx?sid=" + sid[1]);
$("#saveofficers").attr("href", "saveoffiecersinfo.aspx?sid=" + sid[1]);
$("#displayfriends").attr("href", "displayfriendsinfo.aspx?sid=" + sid[1]);
$("#displayofficers").attr("href", "displayofficersinfo.aspx?sid=" + sid[1]);
$("#Excelsf").attr("href", "ExcelSavefriends.aspx?sid=" + sid[1]);
$("#Excelso").attr("href", "ExcelSaveofficers.aspx?sid=" + sid[1]);
$("#companydetails").attr("href", "companydetails.aspx?sid=" + sid[1]);
$("#clientdetails").attr("href", "clientdetails.aspx?sid=" + sid[1]);
$("#displaycompanydetails").attr("href", "displaycompanydetails.aspx?sid=" + sid[1]);
$("#renualcompanydetails").attr("href", "Renualcompanydetails.aspx?sid=" + sid[1]);
$("#importcompanydetails").attr("href", "importcompanydetails.aspx?sid=" + sid[1]);
$("#importclientdetails").attr("href", "importclientdetails.aspx?sid=" + sid[1]);
$("#importcontractortypedetails").attr("href", "importcontractortypedetails.aspx?sid=" + sid[1]);
$("#importrenualcompanydetails").attr("href", "importrenualcompanydetails.aspx?sid=" + sid[1]);
$("#excelexportcompanydetails").attr("href", "Excelexportcompanydetails.aspx?sid=" + sid[1]);
$("#excelexportclientdetails").attr("href", "Excelexportclientdetails.aspx?sid=" + sid[1]);
$("#<%= txtsearch.ClientID %>").autocomplete('Handler.ashx?StrMethodName=autocompletecompanynamesbycompanyedetailstbl');
});
</script>
<span style="text-decoration:underline;"><b>DisplayCompanydetails:</b></span><br />
<div id="divsearch">
Companyname:<asp:TextBox ID="txtsearch" runat="server"></asp:TextBox>
<asp:Button ID="btnsearch" runat="server" Text="Submit"
onclick="btnsearch_Click" />
</div>
<div id="showcompanydetailsdiv" style="overflow:auto;">
<asp:GridView ID="GridView1" DataKeyNames="companydetailsguid" runat="server"
AutoGenerateColumns="false" CssClass="Gridview"
CellPadding="4" ForeColor="#333333" GridLines="Both" Width="100%"
HorizontalAlign="Center" AllowPaging="True"
onpageindexchanging="GridView1_PageIndexChanging" PageSize="3"
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating"
onrowdatabound="GridView1_RowDataBound"
onrowdeleting="GridView1_RowDeleting" >
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#4A97CA" Height="30px" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="black" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="Sno" HeaderText="Sno" />
<asp:TemplateField HeaderText="companydetailsguid" Visible="false">
<ItemTemplate>
<asp:Label ID="lblcompanydetailsguid" runat="server" Text='<%# Eval("companydetailsguid") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Reqno">
<ItemTemplate>
<%# Eval("reqno") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtreqno" Text='<%# Eval("reqno") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Compname" >
<ItemTemplate>
<%# Eval("companyname")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtcompanyname" Width="100px" Text='<%# Eval("companyname") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Dscuserid">
<ItemTemplate>
<%# Eval("dscuserid")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtdscuserid" Text='<%# Eval("dscuserid") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Cname">
<ItemTemplate>
<%# Eval("contactpersonname")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtcontactpersonname" Text='<%# Eval("contactpersonname") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contactno">
<ItemTemplate>
<%# Eval("contactno")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtcontactno" Text='<%# Eval("contactno") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Emailid">
<ItemTemplate>
<%# Eval("contactemailid")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtcontactemailid" Text='<%# Eval("contactemailid") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Emailpwd">
<ItemTemplate>
<%# Eval("emailpwd")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtemailpwd" Text='<%# Eval("emailpwd") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="PFXpwd">
<ItemTemplate>
<%# Eval("pfxpwd")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtpfxpwd" Text='<%# Eval("pfxpwd") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Doi">
<ItemTemplate>
<%# Eval("dateofissue") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtdateofissue" Text='<%# Eval("dateofissue") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Dor">
<ItemTemplate>
<%# Eval("dateofrenual")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtdateofrenual" Text='<%# Eval("dateofrenual") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Classtype">
<ItemTemplate>
<%# Eval("classtype") %>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="DropDownList2" runat="server" >
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Dealername">
<ItemTemplate>
<%# Eval("dealername")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtdealername" Text='<%# Eval("dealername") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Types">
<ItemTemplate>
<%# Eval("contractortype") %>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" >
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="Action" ShowCancelButton="true" ShowEditButton="true" />
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="lnkbtndelete" CommandArgument='<%# Eval("companydetailsguid") %>' CommandName="Delete" Text="Delete" runat="server"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:GridView ID="Gridviewclinetdetails" DataKeyNames="clientdetailsguid" runat="server"
AutoGenerateColumns="false" CssClass="Gridview"
CellPadding="4" ForeColor="#333333" GridLines="Both" Width="100%"
HorizontalAlign="Center" AllowPaging="True"
onpageindexchanging="Gridviewclinetdetails_PageIndexChanging"
onrowcancelingedit="Gridviewclinetdetails_RowCancelingEdit"
onrowdatabound="Gridviewclinetdetails_RowDataBound"
onrowediting="Gridviewclinetdetails_RowEditing"
onrowupdating="Gridviewclinetdetails_RowUpdating"
onrowdeleting="Gridviewclinetdetails_RowDeleting">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#4A97CA" Height="30px" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="black" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="Sno" HeaderText="Sno" />
<asp:TemplateField HeaderText="clientdetailsguid" Visible="false" >
<ItemTemplate>
<asp:Label ID="lblclientdetailsguid" runat="server" Text='<%# Eval("clientdetailsguid") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Portal">
<ItemTemplate>
<%# Eval("portal")%>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="ddleditprotal" runat="server">
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="userid">
<ItemTemplate>
<%# Eval("userid")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtuserid" runat="server" Text='<%# Eval("userid") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Password">
<ItemTemplate>
<%# Eval("password")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtpassword" runat="server" Text='<%# Eval("password") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="etokenpassword">
<ItemTemplate>
<%# Eval("etokenpassword") %>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="ddleditetokenpwd" runat="server">
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="Action" ShowCancelButton="true" ShowEditButton="true" />
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="lnkclientdeetailsdeletebtn" runat="server" CommandArgument='<%# Eval("clientdetailsguid") %>' Text="Delete" CommandName="Delete"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
No comments:
Post a Comment