Question

C#如何查找两个字符串之间的数据

str="前方据不确字AAAA123456BBB后面数据不确定BBB"
//我想取AAAA和第一个BBB之间的数据只要123456就可以了.代码怎么写?

Answer 1

string begin = "AAAA";
string end = "BBB";
int beginIndex = str.IndexOf(begin)+begin.Length;
int endIndex = str.IndexOf(end);
string resultstr = str.Substring(beginIndex, endIndex - beginIndex);

IndexOf(string value)查找子串value第一个出现的位置
Substring(int begin,int length)从begin开始截取长度为length长度的子串

追问

哈哈,牛X多谢..

Answer 2

string sql= "select * from acttable where where act_start>='" + s1 + "' and act_stop<='" + s2 + "'";
string sql= "select * from acttable where act_start>='" + s1 + "' and act_stop<='" + s2 + "'";
另外还可以试试：
string sql= "select * from acttable where act_start between #" + s1 + "# and #" + s2 + "#";