- Mar 16 Fri 2012 01:57
-
[C#] Case-Insensitive String Replace
- Oct 07 Fri 2011 11:54
-
DataView RowFilter Syntax [C#]
Column names
If a column name contains any of these special characters ~ ( ) # \ / = > < + - * % & | ^ ' " [ ], you must enclose the column name within square brackets [ ]. If a column name contains right bracket ] or backslash \, escape it with backslash (\] or \\).
If a column name contains any of these special characters ~ ( ) # \ / = > < + - * % & | ^ ' " [ ], you must enclose the column name within square brackets [ ]. If a column name contains right bracket ] or backslash \, escape it with backslash (\] or \\).
- Sep 14 Wed 2011 22:18
-
.NET 調整資料表欄位順序
List<string> lstSCol = new List<string>();
foreach (string sSC in sOutputColumn.Split(','))
if (dtResult.Columns.Contains(sSC))
lstSCol.Add(sSC);
for (int iS = 0; iS < lstSCol.Count; iS++)
dtResult.Columns[lstSCol[iS]].SetOrdinal(iS);
- Aug 23 Tue 2011 14:27
-
Convert string to DataTable with header
private DataTable ConvertToTable(string sVal)
{
DataTable dt = new DataTable();
if (sVal.Length > 0)
{
string[] asVal = sVal.Replace(Environment.NewLine, "\n").Split('\n');
foreach (string sVC in asVal[0].Split(','))
dt.Columns.Add(sVC);
for (int i = 1; i < asVal.Length; i++)
{
string[] asVV = asVal[i].Split(',');
object[] aobj = new object[asVV.Length];
for (int j = 0; j < asVV.Length; j++)
aobj[j] = asVV[j];
dt.LoadDataRow(aobj, true);
}
}
return dt;
}
{
DataTable dt = new DataTable();
if (sVal.Length > 0)
{
string[] asVal = sVal.Replace(Environment.NewLine, "\n").Split('\n');
foreach (string sVC in asVal[0].Split(','))
dt.Columns.Add(sVC);
for (int i = 1; i < asVal.Length; i++)
{
string[] asVV = asVal[i].Split(',');
object[] aobj = new object[asVV.Length];
for (int j = 0; j < asVV.Length; j++)
aobj[j] = asVV[j];
dt.LoadDataRow(aobj, true);
}
}
return dt;
}
- Aug 23 Tue 2011 14:22
-
Read a text file from "Embedded Resource".
private string ReadTextFileFromResource(string sFile)
{
string sRet = "";
try
{
Assembly assembly = Assembly.GetCallingAssembly();
StreamReader textStreamReader = new StreamReader(assembly.GetManifestResourceStream(<File name with full namespce>));
sRet = textStreamReader.ReadToEnd();
textStreamReader.Close();
}
catch (Exception err)
{
MessageBox.Show(this, err.Message, "Error");
}
return sRet;
}
{
string sRet = "";
try
{
Assembly assembly = Assembly.GetCallingAssembly();
StreamReader textStreamReader = new StreamReader(assembly.GetManifestResourceStream(<File name with full namespce>));
sRet = textStreamReader.ReadToEnd();
textStreamReader.Close();
}
catch (Exception err)
{
MessageBox.Show(this, err.Message, "Error");
}
return sRet;
}
1