Get Dynamic Data From DataTable

Question

Vulpes · Answer

Suppose your DataTable (dt say) contains a primary key column CustomerId which stores a unique Id for each customer. Then you first need to locate the customer's row in the DataTable: int id = 134; // or whatever string expression = CustomerId =  + id; DataRow[] rows = dt.Select(expression); if (rows.Count > 0) { string payment = rows[0][payment].ToString(); DateTime date = Convert.ToDateTime(rows[0][date].ToString()); string expression2 = String.Format(Hi Your Payment {0} is Due on Date {1} So Make Payment as soon as possible. payment date.ToShortDateString()); MessageBox.Show(expression2); } else { MessageBox.Show(A customer with an id of  + id +  was not found); }

Vulpes · Answer

One way of dealing with any message string would be to use a regular expression to identify the columns to be replaced and then replace them with the appropriate values in the selected DataRow. I've just quickly thrown together this console application to show you what I mean: using System; using System.Data; using System.Text.RegularExpressions; class Program { static DataTable dt; static DataRow selectedRow; static void Main() { dt = new DataTable(); dt.Columns.Add(CustomerId typeof(int)); dt.Columns.Add(CustomerName); dt.Columns.Add(payment typeof(decimal)); dt.Columns.Add(date typeof(DateTime)); dt.Rows.Add(1 Gadhiya 100 new DateTime(2015 3 1)); dt.Rows.Add(2 Vulpes 200 new DateTime(2015 2 28)); string[] messages = { Hi Your Payment |payment| is Due on Date |date|  So Make Payment as soon as possible. Hello Mr. |CustomerName| Your Payment |payment| is Due. }; string regExp = @\|\w+\|; for(int i = 1; i { int id = i; string expression = CustomerId =  + id; DataRow[] rows = dt.Select(expression); if (rows.Length > 0) { selectedRow = rows[0]; string message = Regex.Replace(messages[i-1] regExp Evaluator); Console.WriteLine(message); } else { Console.WriteLine(A customer with an id of  + id +  was not found); } Console.WriteLine(); } Console.ReadKey(); } static string Evaluator(Match m) { string value = m.Value.Replace(| ).ToLower(); foreach(DataColumn dc in dt.Columns) { if (value == dc.ColumnName.ToLower()) { if (dc.DataType == typeof(DateTime)) { return ((DateTime)selectedRow[dc.ColumnName]).ToShortDateString(); } else { return selectedRow[dc.ColumnName].ToString(); } } } return m.Value; // leave unchanged if column name not found } } The output is: Hi Your Payment 100 is Due on Date 01/03/2015  So Make Payment as soon as possible. Hello Mr. Vulpes Your Payment 200 is Due. A customer with an id of 3 was not found

Vasu Gadhiya · Answer

ok Your Answer Make Helpfull For me. first substring With | Like --> Hi Your Payment Paymnet is Due on Date ...... After I Substring Withing | --> Payment Date .... Match Both Array and put in first array {0} {1} ..... after i add as you shown.. Thanks

Vasu Gadhiya · Answer

Thanks Vulpes for Reply but Problem is in Message String User can enter its own message ex . string message = Hi Your Payment |payment| is Due on Date |date|  So Make Payment as soon as possible.; string message = Hello Mr. |CustomerName| Your Payment |payment| is Due.; How To Substring Every Text Between || and get data from datatable.row[0]. thanks