Get Dynamic Data From DataTable

Question

Hi I have String Like

string message = "Hi Your Payment |payment| is Due on Date |date| , So Make Payment as soon as possible.";

now,

text between | and | is refer Column Name of Datatable, and i want to put data from datatable in it.

how can i ?

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