@{ string clave = Request.QueryString["c"].ToString(); string estatus = "", nombre = "", rfc = "", calle = "", exterior = "", interior = "", colonia = "", cp = "", poblacion = ""; string municipio = "", estado = "", pais = "", tel1 = "", web = "", correo = "", credito = "", dias = "", pago = "", cuenta = ""; var db = WebMatrix.Data.Database.Open("cweb"); var sql = "SELECT * FROM clientes WHERE clave = '" + clave + "'"; db.QuerySingle(sql); foreach (var row in db.Query(sql)) { estatus = row.estatus; nombre = row.nombre; rfc = row.rfc; calle = row.calle; exterior = row.exterior; interior = row.interior; colonia = row.colonia; municipio = row.municipio; estado = row.estado; cp = row.cp; poblacion = row.poblacion; pais = row.pais; tel1 = row.tel1; web = row.web; correo = row.correo; credito = row.credito; dias = row.dias; pago = row.pago; cuenta = row.cuenta; } db.Connection.Close(); db.Close(); db.Dispose(); }