try { String sql = " select collmast_no,collmast_desc from lncollmaster where collmast_desc is not null "; Sdt d = WebUtil.QuerySdt(sql); while (d.Next()) { //int i = d.GetString("collmast_desc").LastIndexOf("ขนาดที่ดิน"); //int y = d.GetString("collmast_desc").LastIndexOf("ไร่"); int i = d.GetString("collmast_desc").IndexOf("ขนาดที่ดิน"); int y = d.GetString("collmast_desc").IndexOf("ไร่"); // y = y - i; string[] c = d.GetString("collmast_desc").Substring(i + 10, y-i-10).Split('-'); String sqlupdate = " update lncollmaster set size_rai =" + c[0] + " , size_ngan= " + c[1] + " , size_wa =" + c[2] + " where collmast_no like '%" + d.GetString("collmast_no") + "%' "; WebUtil.QuerySdt(sqlupdate); } LtServerMessage.Text = " สำเร็จ"; } catch (Exception ) { LtServerMessage.Text = " NO สำเร็จ"; }