Get Dynamic Data From DataTable

Vasu Gadhiya

11y1.2kLearn iOS Programming

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 ?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes11y ago
Accepted 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");
}
Vulpes11y ago
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 <= 3; 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 Gadhiya11y ago
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 Gadhiya11y ago
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,