public static int CreatePoetry(DataTable maindt, DataTable detaildt) { string mno = Guid.NewGuid().ToString(); string msql = @"insert TPoetry(FNo,FTitle,FAuther) " + "values('" + mno + "'," + "'" + maindt.Rows[0]["no"].ToString() + "'," + "'" + maindt.Rows[0]["no"].ToString() + "'," + "'" + maindt.Rows[0]["no"].ToString() + "'," + "'" + maindt.Rows[0]["no"].ToString() + "')"; string dsql = @"insert TPoetryDetail(FMNo,FLine1,FLine2,FLine3,FLine4) " + "values('" + mno + "'," + "'" + detaildt.Rows[0]["line1"].ToString() + "'," + "'" + detaildt.Rows[0]["line2"].ToString() + "'," + "'" + detaildt.Rows[0]["line3"].ToString() + "'," + "'" + detaildt.Rows[0]["line4"].ToString() + "')"; int retvalue = dBUtil.Execute(msql); retvalue += dBUtil.Execute(dsql); return(retvalue); }