Comments by karthikkushala

karthikkushala 10-Jul-12 4:54am View

Hey sorry . windos form Mean i created an desktop application which is used to login the user and after checking of my coditions. am redircting to IE
InternetExplorer IE = new InternetExplorer();
IWebBrowserApp wb = (IWebBrowserApp)IE;
wb.MenuBar = false;
wb.ToolBar = 0;
wb.StatusBar = false;

if (IE != null)
{
object Empty = String.Empty;
object URL = "http://URL.aspx?Id=" + Id + "&Pw=" + PW + "";

IE.Visible = true;
IE.StatusBar = true;
IE.StatusText = "Loading....";
IE.FullScreen = true;
IE.Navigate2(ref URL, ref Empty, ref Empty, ref Empty, ref Empty);

}

karthikkushala 6-Apr-12 13:04pm View

we use to pay bulk repayment for loans and in accounts forms xml to DB insertion
problem is all select and insert going very slow .
when DB is small it worked fine

karthikkushala 6-Apr-12 12:57pm View

thanks for reply.
i tried sql server profiler , audit logout taking more durantion.and SSRS taking more resources.
i didn't tried about database engine tuning adviser.and
am using .net , in our application we us more insert and select statement data base size is 25 GB.
system configration windows server 2008 and 4 GB RAM

karthikkushala 14-Dec-11 0:53am View

ya what u said is correct , but i have a drop down before grid view , i will work as conditional ,like if i select 1 it shows only 3 hierarchies , if i select 2 it shows all.
the functionality working fine but , get after entering member id it how can i bind in revers order for drop down which are in gridview with out any event

karthikkushala 14-Dec-11 0:48am View

i added asp and cs code ,

karthikkushala 14-Dec-11 0:47am View

no, not accordion menu . dynamic drop down list and revere binding

karthikkushala 23-Oct-11 12:09pm View

yes i will update but how my cursoer come back with out executing complete SP

karthikkushala 17-Sep-11 0:19am View

sorry you understood wrongly ,
inserting mutiple rows means Example
a journel Voucher 1st 10rs tea one entry, 2nd 50 Rs sancks 3rd 500Rs for maintance charges.

i need to save all these thre entries under single voucher No.
so am inserting into temp table then finanlly saving into transation table.

karthikkushala 21-Aug-11 3:52am View

yes i agree with you , my intention is not to split application but for HR module i want to use my SQL instead of SQLserver because it is open source any one can easily afford and how can i use single application with different DB

karthikkushala 27-Apr-11 1:34am View

i have grid in aspx i need to generate report from grid , i want to use componet model for this generation of report

karthikkushala 26-Apr-11 8:42am View

by stroing with '<' html tags i can bind that directly to literal

karthikkushala 6-Apr-11 1:57am View

how to use it it has more 5 overload methods

karthikkushala 6-Apr-11 1:56am View

when i used Request.LoginUserIdentity.Name in my wed page am getting my server login name but i need userId of windows appication login Id

karthikkushala 2-Mar-11 23:19pm View

i did same its working but when am enable =true it not get enableing in first click

karthikkushala 10-Feb-11 7:38am View

Deleted

string _user_role;

protected void Page_Load(object sender, EventArgs e)
{
int rowid = -1;

//if (!IsPostBack)
//{
#region Code for Menu
DataSet ds = new DataSet();
DataTable dt1 = new DataTable();
try
{

//By Dileep [5Jan11] - to add Session of UserRole
//dt1 = DALAuthentication.GetUserRoleName(Session["UserID"].ToString());
//_user_role = dt1.Rows[0][0].ToString();
if (Session["RoleName"] == null)
{
Session.Abandon();
Response.Redirect("login.aspx");
}

else
{
_user_role = Session["RoleName"].ToString();
ds.ReadXml(Server.MapPath("~/XmlData/" + _user_role + ".xml"));
}
//End Dileep
}
catch
{
if (Session["RoleName"] == null)
{

Session.Abandon();
Response.Redirect("login.aspx");
}
else
{
Response.Write("<script language='javascript'>alert('User:" + Session["UserID"].ToString() + " Role not exists');</script>");
return;
}
}
DataRow[] found2ndDBRows;
DataRow[] found2ndDBRows1;
DataRow[] found2ndDBRows2;
string strDBExpr1;
foreach (DataRow drRow in ds.Tables[0].Rows)
{
if (drRow["value"].ToString() == "Operations")
// if (drRow["value"].ToString() != "")
{
string strDBExpr = "value = '" + "Operations" + "'";
found2ndDBRows = ds.Tables[0].Select(strDBExpr, string.Empty);
foreach (DataRow str in found2ndDBRows)
{
if (rowid != Convert.ToInt32(str[0].ToString()))
{
strDBExpr1 = "type_id = " + str[0].ToString() + "";
rowid = Convert.ToInt32(str[0].ToString());
found2ndDBRows1 = ds.Tables[1].Select(strDBExpr1, string.Empty);

foreach (DataRow str3 in found2ndDBRows1)
{
string strDBExpr2 = "ActionType_id = " + str3[0].ToString() + "";
found2ndDBRows2 = ds.Tables[2].Select(strDBExpr2, string.Empty);
AjaxControlToolkit.AccordionPane pane = new AjaxControlToolkit.AccordionPane();
pane.ID = strDBExpr2;
PaneHTMLTemplate header = new PaneHTMLTemplate(" <div >" + " <a href='' önclick='return false;' >" + str3[1].ToString() + "" + "</a></div>");

pane.Header = header;

foreach (DataRow str1 in found2ndDBRows2)
{
LinkButton lb = new LinkButton();
lb.Text = str1[0].ToString();
lb.ID = str1[0].ToString() + "-link";
lb.PostBackUrl = str1[1].ToString();
lb.CommandArgument = str1[0].ToString();
lb.Click += new EventHandler(lb_Click);
lb.CssClass = "accordionContent";
pane.ContentContainer.Controls.Add(lb);
Panel innerpan = new Panel();
innerpan.ID = str1[0] + "_pan";
innerpan.Controls.Add(lb);

karthikkushala 10-Feb-11 7:10am View

sorry but its creating lot of problem

karthikkushala 3-Feb-11 0:21am View

i wrote but it not saving into seporate folder which and how to give name dynamically

karthikkushala 31-Jan-11 23:41pm View

please any body can help

karthikkushala 30-Jan-11 23:55pm View

CheckBoxList SubCategoryChkboxLst = new CheckBoxList(); i created object in load . am geeting error same id control, and when i click first checkbox of parent it generating checkboxlist when i check 2nd check box list it generating checkboxlist but first generated is get clearing

karthikkushala 28-Jan-11 7:41am View

in any event checkboxlist is getting clear

karthikkushala 10-Dec-10 0:06am View

is there any scuh date picker which can i use

karthikkushala 9-Dec-10 7:46am View

how i can save all subcategories at atime like supose i have a category (employee,unemployee)
i got two check boxes of(employee and Unemployee) which are cateogory. then when am clickin on first check box Employee i need to display Govt.employee,Prvt Employee,Self Employee Etc..) as subcategory and when on same time if i clicked on another category Unemployee check box i have to display all sub categorys under unEmpolyee . i.e when on checking on all categorys (Empolyee And Unemployee), I have to bind all sub categories Under Selected Categoys(Empolyee And Unemployee).
how i identify on saving check boxes which are selected of subcategory under which category
?

karthikkushala 9-Dec-10 2:55am View

int i = BLAccountHeadCreation.SaveAccountsDetails(ref objdc);
if (i > 0)
{
GetTreeViewBind();
}
after save button click and after no of rows effected retuned an binging GetTreeViewBind() but its not working

karthikkushala 9-Dec-10 2:52am View

hey am even i tried that but data set getting updated value but tree view is not loading

karthikkushala 9-Dec-10 2:47am View

Deleted

GetTreViewBind do we have such type of event if yes please where i can find

karthikkushala 9-Dec-10 1:10am View

thanks for ur solution i may go for first solution am notusing MVC model .plz can u suggest me wht are the uses by using MVC wht is MVC .

karthikkushala 7-Dec-10 5:36am View

any example please

karthikkushala 7-Dec-10 5:35am View

protected void loanProductsGv_SelectedIndexChanged(object sender, EventArgs e)
{
SaveImgBtn.Visible = false;
UpdateeImgBtn.Visible = true;
GridViewRow row = (GridViewRow)loanProductsGv.SelectedRow;
try
{
ProductIDLbl.Text = Server.HtmlDecode(row.Cells[0].Text);
LoanTypeDdl.SelectedValue = Server.HtmlDecode(row.Cells[9].Text);
LoanProductNameTxt.Text = Server.HtmlDecode(row.Cells[2].Text);
CreationDateTxt.Text=Server.HtmlDecode(row.Cells[3].Text);
LoanCategoryTxt.Text = Server.HtmlDecode(row.Cells[4].Text);
LoanLedgerCodeCmBox.SelectedItem.Text = Server.HtmlDecode(row.Cells[11].Text);
LoanLedgerNameCmBox.SelectedValue = Server.HtmlDecode(row.Cells[11].Text);
InsertLedgerNameCmBox.SelectedValue = Server.HtmlDecode(row.Cells[12].Text);
InterestLedgerCodeCmBox.SelectedItem.Text = Server.HtmlDecode(row.Cells[12].Text);
string GroupCodes = Server.HtmlDecode(row.Cells[10].Text);

for (int i = 0; i < GroupCodes.Length; i++)
{

if (GroupCodes.Substring(i,1) != ",")
{
GroupTypeChkBxLst.SelectedValue = GroupCodes.Substring(i, 1);
}
}

}
catch (Exception ex)
{
log.Error(ex.Message, ex);
}

}
problem is not while insertion when getting from DB
am storing in DB (1,2,4,5,)

karthikkushala 16-Nov-10 23:31pm View

same proble could you please correct me am sending complete code

public partial class AuditCheckList : System.Web.UI.Page
{
DataTable ForDdl;
#region Logger Setup
protected static readonly log4net.ILog log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
#endregion
//Creating an object for datacontainer class
DCCheckList objdc = new DCCheckList();
//creating an object for business layer class
BLCkeckList objbl = new BLCkeckList();

protected void Page_Load(object sender, EventArgs e)
{
Session["UserId"] = 101;
Session["RoleId"] = 201;
Session["RoleName"] = "admin";
objdc.auditphase = Request.QueryString["AuditPhase"];
objdc.auditorname = Request.QueryString["AuditorName"];
objdc.branch = Request.QueryString["Branch"];
objdc.ActualStartDate = Request.QueryString["ActualStartDate"];
if (Session["UserId"] != null && Session["RoleId"] != null && Session["RoleName"] != null)
{
if (!IsPostBack)
{
NameLbl.Text = Request.QueryString["AuditorName"];
DateLbl.Text = Request.QueryString["ActualStartDate"];
BranchLbl.Text = Request.QueryString["Branch"];
//This method binds data to the gridview
FillmainGrid();

}
}
else
{
Session.Abandon();
Response.Redirect("~/Login.aspx");
}

}

private void FillmainGrid()
{
DataTable dt = new DataTable();
dt = objbl.BindmainGrid();
HeaderGv.DataSource = dt;
HeaderGv.DataBind();

}

protected void HeaderGv_RowDataBound(object sender, GridViewRowEventArgs e)
{
GridViewRow row = e.Row;
if (e.Row.RowType != DataControlRowType.Pager)
{
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Cells[0].Visible = false;
e.Row.Cells[1].Visible = false;
e.Row.Cells[2].Visible = false;
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[1].ForeColor = System.Drawing.Color.FromArgb(153, 0, 0);
e.Row.Cells[1].BackColor = Color.FromArgb(221, 221, 221);
e.Row.Cells[1].Font.Size = 12;
e.Row.Cells[1].Font.Name = "Century";
e.Row.Cells[1].Visible = true;
e.Row.Cells[0].Visible = false;
e.Row.Cells[2].Visible = false;
}
}
if (row.DataItem == null)
{
return;
}
GridView gv = new GridView();
objdc.headerID = Convert.ToInt32(e.Row.Cells[2].Text);
gv = (GridView)row.Cells[1].FindControl("ParameterGv");
if (gv != null)
{

BindCheckList(gv, objdc.headerID);

}

}

private void BindCheckList(GridView gv, int p)
{
objdc.auditphase = Request.QueryString["AuditPhase"];
objdc.auditorname = Request.QueryString["AuditorName"];
objdc.branch = Request.QueryString["Branch"];
objdc.headerID = p;
ViewState["HeaderId"] = p;
DataTable dt = new DataTable();
dt = objbl.FillParametersGrid(ref objdc);
DataTable dt1 = new DataTable();
dt1 = objbl.getdata(ref objdc);
if (dt1.Rows.Count > 0)
{
ForDdl = dt1.Copy();
ForDdl.Columns.Remove("SNO");
ForDdl.Columns.Remove("PARAM_HEAD_ID");
ForDdl.C

karthikkushala 20-Oct-10 6:02am View

protected void ParamGV_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
SaveImgBtn.Visible = false;
UpdateImgBtn.Visible = true;
HeadingRdBtn.Enabled = false;
ParameterRdBtn.Enabled = false;
FormTypeDdl.Enabled = false;
HeadNameDdl.Enabled = false;

GridViewRow row = HeaderGV.SelectedRow;
int rowindex = HeaderGV.SelectedIndex;

GridView gv = this.HeaderGV;
GridView gv1 = (GridView)this.HeaderGV.Rows[rowindex + 1].FindControl("ParamGV");

GridViewRow Childrow = gv1.SelectedRow;

int RowIndex = gv1.SelectedIndex;
HeadNameDdl.SelectedValue = Server.HtmlDecode(Childrow.Cells[1].Text).Trim();
ViewState["ParameterId"] = Server.HtmlDecode(Childrow.Cells[2].Text).Trim();
ParameterNametxt.Text = Server.HtmlDecode(Childrow.Cells[3].Text).Trim();

}

here am getting headerGV selected row -1

karthikkushala 12-Oct-10 0:47am View

protected void HeaderGV_RowDataBound(object sender, GridViewRowEventArgs e)
{
GridViewRow row = e.Row;
if (e.Row.RowType != DataControlRowType.Pager)
{
e.Row.Cells[2].Visible = false;
if (Session["Type"].ToString() == "Parameter")
{
if (e.Row.RowType == DataControlRowType.DataRow)
{

e.Row.Cells[1].ForeColor = System.Drawing.Color.FromArgb(153, 0, 0);
e.Row.Cells[1].BackColor = Color.FromArgb(221, 221, 221);
//e.Row.Cells[1].Font.Bold = true;
e.Row.Cells[1].Font.Size = 12;
e.Row.Cells[1].Font.Name = "Century";
//e.Row.Attributes.Add("onmouseover", "this.className='highlightrow'");
//e.Row.Attributes.Add("onmouseout", "this.className='normalrow'");
//this is line of code because of ur suggestion
GridView Par = (GridView)e.Row.FindControl("ParamGV");

}
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Cells[1].Visible = false;
e.Row.Cells[2].Visible = false;
}
e.Row.Cells[0].Visible = false;
e.Row.Cells[3].Visible = false;

}

}

if (row.DataItem == null)
{
return;
}

GridView gv = new GridView();
objdc.HeaderID = Convert.ToInt32(row.Cells[2].Text);
gv = (GridView)row.Cells[1].FindControl("ParamGV");
DataTable dt = new DataTable();
if (gv != null && Session["Type"].ToString() == "Parameter")
{
dt = objbl.FillGridForFormParameters(ref objdc);
gv.DataSource = dt;
gv.DataBind();
}
else
{
//gv.DataSource = null;
//gv.DataBind();
}

}

sir but i have to write selectindexchage for my child grid
when i wrote GridView Par = (GridView)e.Row.FindControl("ParamGV"); in RowDataBound event how would i call ParamGV_selectedIndexChanges

karthikkushala 12-Oct-10 0:26am View

Thank q for replying i will try it

karthikkushala 28-Sep-10 2:17am View

no for a dropdown i need Auto Complete my code works but after binding a dataset i have to sort according to text entered

Comments by karthikkushala (Top 33 by date)