Click here to Skip to main content
15,884,099 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
List getListCol = new List();
DataTable dtGetList = new DataTable();

//dtGetList.Columns.Add("Sl No").AutoIncrement = true; //For sorting numeric values set by typeof(int), default sorting is string.
DataColumn SlCol = new DataColumn("#", typeof(System.Int32));
dtGetList.Columns.Add(SlCol);
//SlCol.AutoIncrement = true;
//SlCol.AutoIncrementSeed = 1;
dtGetList.Columns.Add("Voucher Number");
dtGetList.Columns.Add("Voucher Date");
dtGetList.Columns.Add("Vendor Name");
dtGetList.Columns.Add("Cheque Amount");
dtGetList.Columns.Add("Cheque Number", typeof(System.Int32));
//dtGetList.Columns.Add("Select", System.Type.GetType("System.Boolean")); //adding Checkbox to grid column header (Method 1)
dtGetList.Columns.Add(" ", System.Type.GetType("System.Boolean"));
//int SlCount = 1;
int CountChqNo = Convert.ToInt32(strChqNo);
foreach (DataRow dr in dsGetlist.Tables[0].Rows)
{
string strformat;
DataRow drGetList = dtGetList.NewRow();
strformat = "f" + Convert.ToInt32(dr["DecimalPlaces"]).ToString(); //Formatting Currency Value
drGetList["Voucher Number"] = dr["Voucher_No"];
drGetList["Voucher Date"] = dr["Voucher_Date"];
drGetList["Vendor Name"] = dr["VendorName"];
drGetList["Cheque Amount"] = Convert.ToDecimal(dr["Amount"]).ToString(strformat);
drGetList["Cheque Number"] = CountChqNo; //dr["TLRBR_Cheque_Number"]
drGetList[" "] = "false";

dtGetList.Rows.Add(drGetList);
//ChkdGetList = dtGetList;
CountChqNo = CountChqNo + 1; // Auto Increment etxtStartChequNo input No

getListCol.Add(dtGetList.ToString());
}
Posted
Updated 16-Nov-15 19:08pm
v2
Comments
[no name] 17-Nov-15 0:13am    
Can you post your full code ?
Sathish km 17-Nov-15 1:05am    
ok
Sathish km 17-Nov-15 1:08am    
List<string> getListCol = new List<string>();
DataTable dtGetList = new DataTable();

//dtGetList.Columns.Add("Sl No").AutoIncrement = true; //For sorting numeric values set by typeof(int), default sorting is string.
DataColumn SlCol = new DataColumn("#", typeof(System.Int32));
dtGetList.Columns.Add(SlCol);
//SlCol.AutoIncrement = true;
//SlCol.AutoIncrementSeed = 1;
dtGetList.Columns.Add("Voucher Number");
dtGetList.Columns.Add("Voucher Date");
dtGetList.Columns.Add("Vendor Name");
dtGetList.Columns.Add("Cheque Amount");
dtGetList.Columns.Add("Cheque Number", typeof(System.Int32));
//dtGetList.Columns.Add("Select", System.Type.GetType("System.Boolean")); //adding Checkbox to grid column header (Method 1)
dtGetList.Columns.Add(" ", System.Type.GetType("System.Boolean"));
//int SlCount = 1;
int CountChqNo = Convert.ToInt32(strChqNo);
foreach (DataRow dr in dsGetlist.Tables[0].Rows)
{
string strformat;
DataRow drGetList = dtGetList.NewRow();
strformat = "f" + Convert.ToInt32(dr["DecimalPlaces"]).ToString(); //Formatting Currency Value
drGetList["Voucher Number"] = dr["Voucher_No"];
drGetList["Voucher Date"] = dr["Voucher_Date"];
drGetList["Vendor Name"] = dr["VendorName"];
drGetList["Cheque Amount"] = Convert.ToDecimal(dr["Amount"]).ToString(strformat);
drGetList["Cheque Number"] = CountChqNo; //dr["TLRBR_Cheque_Number"]
drGetList[" "] = "false";

dtGetList.Rows.Add(drGetList);
//ChkdGetList = dtGetList;
CountChqNo = CountChqNo + 1; // Auto Increment etxtStartChequNo input No

getListCol.Add(dtGetList.ToString());
}
Krunal Rohit 17-Nov-15 0:36am    
Unclear or Incomplete. Post your relevant code and elaborate your question more precisely.

-KR
Anjali0904 17-Nov-15 2:24am    
could you try to state your issue more clearly. Meanwhile you could put your code into try-catch block and see if you get any exceptions..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900