Adding dropdownlist into datagrid on edit mode

I have confusing on adding dropdownlist into datagrid, here some references about that:

• http://www.codeproject.com/useritems/DatagridWithDropdown.asp
• http://www.gridviewguy.com/ArticleDetails.aspx?articleID=71
• http://www.velocityreviews.com/forums/t93920-selectedindex -of-dropdownlist-in-datagrid.html
• http://www.codeproject.com/aspnet/DataGridDropDownList.asp
• http://www.odetocode.com/Articles/231.aspx
• http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vstechart/ html/vbtchTopQuestionsAboutASPNETDataGridServerControl.asp

And now, i’m still in confusing to pick index of the selected record and associate into dropdownlist. I’ll try it again….

Update:
Here the code to associate index of dropdownlist:

/// 
/// Set Selected Item into combo
/// 
/// 
/// 
private void DtDetail_ItemDataBound(object sender,
System.Web.UI.WebControls.DataGridItemEventArgs e)
{
	if(e.Item.ItemType == ListItemType.EditItem)
	{
		DataRowView drv = (DataRowView) e.Item.DataItem;
		String code = drv["Code"].ToString();
		DropDownList ddl = (DropDownList) e.Item.FindControl("cmbItem");
		ddl.SelectedValue = code.Trim();

//manipulate width all textbox (using static variable)
		for (int i=0;i string ctl = "_ctl" + i.ToString().Trim();
			TextBox txtB1 = (TextBox) e.Item.FindControl(ctl);
			txtB1.Width = 50;
		}
	}
}

Client-Side textbox Calculation

javascript Code

script language=”javascript”>

function focusText(control) {
control.style.backgroundColor = “#ffffcc”;
}

function checkText(control) {
if(control.value == “” || isNaN(control.value)) {
control.focus();
focusText(control);
}
else {
control.style.backgroundColor = “#ffffff”;
Calculate();
}
}

function Calculate() {
var price = isNaN(document.frmAddDetail.txtPrice.value) ? 0 : document.frmAddDetail.txtPrice.value;
var qty = isNaN(document.frmAddDetail.txtQuantity.value) ? 0 : document.frmAddDetail.txtQuantity.value;
var disc = isNaN(document.frmAddDetail.txtDiscount.value) ? 0 : document.frmAddDetail.txtDiscount.value;

var discount = price * qty * disc / 100;

document.frmAddDetail.txtTotal.value = price * qty – discount;
}
script>

Aspx Code:

form id=”frmAddDetail” method=”post” runat=”server”>
 
h1>Add Detail Transactionh1>
P>
TABLE id=”tblAdd” style=”WIDTH: 552px; HEIGHT: 163px” cellSpacing=”1″ cellPadding=”1″
width=”552″ border=”0″>
TR>
TD style=”HEIGHT: 6px” noWrap>Item
TD>
TD style=”HEIGHT: 6px”>:TD>
TD style=”HEIGHT: 6px” noWrap>asp:dropdownlist id=”cmbItem” runat=”server” Width=”174px”>asp:dropdownlist>asp:requiredfieldvalidator id=”userValidate” runat=”server” ControlToValidate=”cmbItem” ErrorMessage=”Item Code required”>asp:requiredfieldvalidator>TD>
TR>
TR>
TD noWrap>PriceTD>
TD>:TD>
TD noWrap>asp:textbox id=”txtPrice” runat=”server” onFocus=”focusText(this)” onBlur=”checkText(this)”>asp:textbox>asp:requiredfieldvalidator id=”RequiredFieldValidator1″ runat=”server” ControlToValidate=”txtPrice” ErrorMessage=”Price must be filled”>asp:requiredfieldvalidator>TD>
TR>
TR>
TD noWrap>QuantityTD>
TD>:TD>
TD noWrap>asp:textbox id=”txtQuantity” runat=”server” onFocus=”focusText(this)” onBlur=”checkText(this)”>asp:textbox>asp:requiredfieldvalidator id=”Requiredfieldvalidator2″ runat=”server” ControlToValidate=”txtQuantity” ErrorMessage=”Quantity must be filled”>asp:requiredfieldvalidator>TD>
TR>
TR>
TD noWrap>DiscountTD>
TD>:TD>
TD noWrap>asp:textbox id=”txtDiscount” runat=”server” onFocus=”focusText(this)” onBlur=”checkText(this)”>0asp:textbox>asp:requiredfieldvalidator id=”Requiredfieldvalidator3″ runat=”server” ControlToValidate=”txtDiscount” ErrorMessage=”Discount minimum 0%”>asp:requiredfieldvalidator>TD>
TR>
TR>
TD noWrap>TotalTD>
TD>:TD>
TD noWrap>asp:textbox id=”txtTotal” runat=”server” onFocus=”checkText(this)” ReadOnly>asp:textbox>asp:requiredfieldvalidator id=”Requiredfieldvalidator4″ runat=”server” ControlToValidate=”txtQuantity” ErrorMessage=”Quantity must be filled”>asp:requiredfieldvalidator>TD>
TR>
TR>
TD noWrap colSpan=”3″>asp:button id=”btnSave” runat=”server” Text=”Save”>asp:button> 
asp:button id=”btnCancel” runat=”server” Text=”Cancel”>asp:button>TD>
TR>
TABLE>
asp:label id=”lblError” runat=”server” ForeColor=”Red” Visible=”False”>Labelasp:label>P>
form>

paging on datagrid

Here some code to apply paging on datagrid:

/// 
/// Apllying page changing
/// 
/// 
/// 
private void DtTransaction_PageIndexChanged(object source, 
System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
	DataSet ds = (DataSet) this.Cache["dataset"];
	DtTransaction.CurrentPageIndex = e.NewPageIndex;

	DataTable dt = ds.Tables["TRANSACTION_HEADER"];
	DtTransaction.DataSource = dt.DefaultView;

	DtTransaction.DataBind();
}

Checkbox selection on datagrid

do you want to check / uncheck all checkbox in a datagrid? Use this script:

foreach( DataGridItem di in DtUser.Items )
{
CheckBox cb = (CheckBox)di.Cells[0].Controls[1];
if( cb != null)
{
if (btnCheck.Text == “Check All”)
cb.Checked = true;
else
cb.Checked = false;
}
}

Customize datagrid on web

We can customize datagrid on the web application. Here some explanation:

• http://support.microsoft.com/kb/320707/EN-US/
• http://www.rustemsoft.com/ASPDataGridColumns.htm
• http://www.codeproject.com/aspnet/datagridcheckbox.asp
• http://www.mastercsharp.com/article.aspx?ArticleID=81&&TopicID=2

Login dinamically on Crystal Report

More than one days i was confusing about login dinamically into database in crystal report. I was googling until i got some source in VB .NET. And now, i convert & modify the code into C# .NET. Here the Code:

///
/// Set Connection for all tables.
///
/// Report Document
private void SetConnection(CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc)
{
CrystalDecisions.CrystalReports.Engine.Database crDB = rptDoc.Database;
CrystalDecisions.CrystalReports.Engine.Tables crTables = crDB.Tables;
CrystalDecisions.Shared.TableLogOnInfo crTableLogInfo;
CrystalDecisions.Shared.ConnectionInfo crConnInfo = new ConnectionInfo();

ClassDbConnection classDB = new ClassDbConnection();
classDB.ReadConfigurationFile();

// setting values
crConnInfo.DatabaseName = classDB.Database;
crConnInfo.ServerName = classDB.Hostname;
crConnInfo.UserID = classDB.Username;
crConnInfo.Password = classDB.Password;

foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
crTableLogInfo = crTable.LogOnInfo;
crTableLogInfo.ConnectionInfo = crConnInfo;
crTable.ApplyLogOnInfo(crTableLogInfo);
}
}

Create report using crystal report

Now, i start to learn reporting using crystal report. Here some link to learn crystal report:

• http://www.codeproject.com/useritems/Crystal_Reports.asp
• http://www.codeproject.com/useritems/Le_Quang_Anh.asp
• http://www.c-sharpcorner.com/Code/2004/Feb/ReportsInDotNet.asp

Passing parameter between form

I’ve got problem to passing parameter from client to parent form. I’ve googling for a while, but i’m not found about it. But i found passing parameter from parent to client. Here the links:

• http://msdn2.microsoft.com/en-us/library/f6525896.aspx
• http://www.codeproject.com/dotnet/passingvaluesbetweenforms.asp
• http://www.gamedev.net/community/forums/topic.asp?topic_id=405902
• http://forums.devshed.com/net-development-87/ passing-parameter-through-invoker-to-third-page-375885.html

By now, i can do that (passing parameter from client to parent form), here the litle sampe:

frmAdd = new frmAddDetail(dataSet1);
frmAdd.ShowDialog();
totalAmount = totalAmount + frmAdd.Total;

//counting amount data
lblTotal.Text = totalAmount.ToString();

//destroy form.
frmAdd.Dispose();

XML times

Learn XML, visit here:

• http://www.perfectxml.com/articles/xml/csharp.asp
• http://devresource.hp.com/drc/technical_articles/xmlprocess/index.jsp
• http://www.codeproject.com/csharp/xml_parsing.asp
• http://www.c-sharpcorner.com/Tutorials/ReadWriteXMLTutMellli21.asp

XML File sample:
http://www.cs.rpi.edu/~puninj/XMLJ/classes/class1/slide3-0.html

watchout your whitespace…. or you’ll get problems.

And absolutely ask to uncle google.

OOP Concept

• http://www.publicjoe.f9.co.uk/csharp/tut.html
• http://www.codersource.net/csharp_tutorial_oops.html
• http://otak.csharpindonesia.net/EBookDetail.aspx?bkid=6