public DataTable Getdata(string query) { da = new SqlDataAdapter(query, WcfDAL.Connection()); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
public bool DML(string Query) { cmd = new SqlCommand(Query, WcfDAL.Connection()); int x = cmd.ExecuteNonQuery(); if (x == 1) { return(true); } else { return(false); } }