判断TXT文件中每行每列空格……

Question

像这种格式
1 2 3 4 5 6 7 8 9 10
在TEXTBOX里.每列对应的是一个字段.俺要把这些字段插入数据库里的...
现在俺是这么写的
if (!(checkname2.Checked || checksex2.Checked || checkmoble2.Checked || checkPhone2.Checked || checkCity2.Checked || checkCardtype2.Checked || checkAddress2.Checked || checkFund2.Checked || checkFund3.Checked || checkCredential2.Checked || checkCredit2.Checked || checkNotes2.Checked || checkResidence2.Checked))
            {
                MessageBox.Show("请选择导入的字段！");
                return;
            } string msg = "";//
            try
            {                string Temp= OpenFile();
                this.richTextBox1.Text = ReadFile(Temp);
                string from2 = this.comboBox9.Text;
                StringBuilder sb = new StringBuilder();
                sb.Append(" INSERT INTO "+from2+"(");
                sb.Append(checkname2.Checked ? "username" : "");
                sb.Append(checksex2.Checked ? ",sex" : "");
                sb.Append(checkmoble2.Checked ? ",moble" : "");
                sb.Append(checkPhone2.Checked ? ",Phone" : "");
                sb.Append(checkCity2.Checked ? ",City" : "");
                sb.Append(checkCardtype2.Checked? ",CardType" : "");
                sb.Append(checkAddress2.Checked ? ",Address" : "");
                sb.Append(checkFund2.Checked ? ",Funds" : "");
                sb.Append(checkFund3.Checked ? ",Funds2" : "");
                sb.Append(checkCredential2.Checked ? ",Credential" : "");
                sb.Append(checkCredit2.Checked ? ",Credit" : "");
                sb.Append(checkNotes2.Checked ? ",Notes" : "");
                sb.Append(checkResidence2.Checked ? ",ComeFrom" : "");
                sb.Append(")");                string m_BaseContent = this.richTextBox1.Text.ToString();                int i = 0;//计量数字
                string sql1 = GetIndexOf(sb.ToString());
                string SQL = "";
                if (m_BaseContent != "")
                {
                                       char[] split = "\r\n".ToCharArray();
                    string[] arrRows = m_BaseContent.Split(split);
                    string[] arrCells;
                    for (int j = 0; j < arrRows.Length; j++)
                    {
                        SQL = " VALUES(";
                        i++;
                        arrCells = arrRows[j].Split('\t');                        if (arrCells.Length != 10)
                        {
                            msg += "第" + i + "数据不全，应为10列。\n";
                            continue;
                        }                        if (checkname2.Checked)
                            SQL += "','" + arrCells[0];                        if (checksex2.Checked)
                            SQL += "','" + arrCells[1];                        if (checkmoble2.Checked)
                            SQL += "','" + arrCells[2];                        if (checkPhone2.Checked)
                            SQL += "','" + arrCells[3];                        if (checkCity2.Checked)
                            SQL += "','" + arrCells[4];                        if (checkCardtype2.Checked)
                            SQL += "','" + arrCells[5];                        if (checkAddress2.Checked)
                            SQL += "','" + arrCells[6];                        if (checkFund2.Checked)
                            SQL += "','" + arrCells[7];                        if (checkFund3.Checked)
                            SQL += "','" + arrCells[8];                        if (checkCredential2.Checked)
                            SQL += "','" + arrCells[9];                        if (checkCredit2.Checked)
                            SQL += "','" + arrCells[10];                        if (checkNotes2.Checked)
                            SQL += "','" + arrCells[11];                        if (checkResidence2.Checked)
                            SQL+="','"+arrCells[12];
                        SQL += "')";                        try
                        {
                            baseAccess.ExecuteNonQuery(sql1 + GetIndex(SQL));
                            msg += "第" + i + "导入成功。\n";
                        }
                        catch (Exception ex)
                        {
                            msg += ex.Message;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                if (msg.Length > 0)
                    MessageBox.Show(msg);
            }        }                private static string GetIndexOf(string sql)
        {
            int i = sql.IndexOf(',');
            if (i < 0)
                return sql;
            else
                return sql.Remove(i, 1);
        }        private static string GetIndex(string sql)
        {
            int i = sql.IndexOf("',");
            if (i < 0)
            {
                return sql;
            }
            else
                return sql.Remove(i, 2);
        }...求高人帮忙啊，急...

Answer 1

string s=File.ReadAllText("");
string[] arr=s.Split(new string[]{"\r\n"},StringSplitOptions.RemoveEmptyEntries);

Answer 2

string Temp = OpenFile();
this.richTextBox1.Text = ReadFile(Temp);
string from2 = this.comboBox9.Text;
StringBuilder sb = new StringBuilder();
//sb.Append(" INSERT INTO " + from2 + "(");
sb.Append(checkname2.Checked ? ",username" : "");
sb.Append(checksex2.Checked ? ",sex" : "");
sb.Append(checkmoble2.Checked ? ",moble" : "");
sb.Append(checkPhone2.Checked ? ",Phone" : "");
sb.Append(checkCity2.Checked ? ",City" : "");
sb.Append(checkCardtype2.Checked ? ",CardType" : "");
sb.Append(checkAddress2.Checked ? ",Address" : "");
sb.Append(checkFund2.Checked ? ",Funds" : "");
sb.Append(checkFund3.Checked ? ",Funds2" : "");
sb.Append(checkCredential2.Checked ? ",Credential" : "");
sb.Append(checkCredit2.Checked ? ",Credit" : "");
sb.Append(checkNotes2.Checked ? ",Notes" : "");
sb.Append(checkResidence2.Checked ? ",ComeFrom" : "");
//sb.Append(")");string fields=sb.ToString();string sql1 = " INSERT INTO " + from2 + "(" + fields.Substring(1) + ")";同样下面也采用这样的处理方法，你的GetIndex()及GetIndexOf()这两个函数就不需要啦！

Answer 3

string Temp = OpenFile();
this.richTextBox1.Text = ReadFile(Temp);
string from2 = this.comboBox9.Text;
StringBuilder sb = new StringBuilder();
//sb.Append(" INSERT INTO " + from2 + "(");
sb.Append(checkname2.Checked ? ",username" : "");
sb.Append(checksex2.Checked ? ",sex" : "");
sb.Append(checkmoble2.Checked ? ",moble" : "");
sb.Append(checkPhone2.Checked ? ",Phone" : "");
sb.Append(checkCity2.Checked ? ",City" : "");
sb.Append(checkCardtype2.Checked ? ",CardType" : "");
sb.Append(checkAddress2.Checked ? ",Address" : "");
sb.Append(checkFund2.Checked ? ",Funds" : "");
sb.Append(checkFund3.Checked ? ",Funds2" : "");
sb.Append(checkCredential2.Checked ? ",Credential" : "");
sb.Append(checkCredit2.Checked ? ",Credit" : "");
sb.Append(checkNotes2.Checked ? ",Notes" : "");
sb.Append(checkResidence2.Checked ? ",ComeFrom" : "");
//sb.Append(")");string fields=sb.ToString();string sql1 = " INSERT INTO " + from2 + "(" + fields.Substring(1) + ")";同样下面也采用这样的处理方法，你的GetIndex()及GetIndexOf()这两个函数就不需要啦！