C#

Judah Himango wrote:

Perhaps the MediaElement class in WPF will help?

<br />
col1 = dr["col1"].ToString().Trim();<br />
col2 = dr["col2"].ToString().Trim();<br />
col3 = dr["col3"].ToString().Trim();<br />
<br />
if( dr["col4"] == DBNull.Value )<br />
{<br />
    // Do Stuff<br />
    recordsSelected = dt.Select("col2 = " + "'" + col2 + "'" + " And col1 = " + "'" + col1 + "'" + " And col3 = " + "'" + col3+ "'" + " And col4 = ''"); <br />
}<br />
else<br />
{<br />
    col4 = dr ["col4"].ToString().Trim(); <br />
    recordsSelected = dt.Select("col2 = " + "'" + col2 + "'" + " And col1 = " + "'" + col1 + "'" + " col3 = " + "'" + col3 + "'" + " And col4 = " + "'" + col4 + "'");<br />
}<br />

bemahesh wrote:

I already tried that. If you read my post I have that select line already in my code. I want to find out a work around. I replaced all nulls to the empty strings. However, this approach may not work if a column i am looking for is not string. As a result, if someone knows a better way or other way to select if values are null in datatable.

1. Build a directed graph of your regex with nodes==state and edges==allowed state transitions
2. Build a structure containing the number of steps that can be made from
   any one state to any other that is <= the length of your result (2d matrix of lists)
3. Randomly choose an acceptance state (named 'as') where your connectivity matrix
   indicates you can go from the start state to the final state in exactly n transitions.
4. Iterate through the following (initialize cur = startStateNode) until your string is found:
   a. Set 'n' to 'n-1'
   b. Out of all of the nodes reachable from 'cur' in one move,
      eliminate those that can not reach 'as' in 'n' moves
   c. Choose one of the resulting nodes in the collection found in (b)