Código:
SqlConnection cn = new SqlConnection(); cn.ConnectionString = "string de coneccion"; SqlCommand cm = new SqlCommand("select o.noteid,o.slsperid,so.shipperid, o.shipname,o.shipaddr1,o.shipaddr2, o.shipcity,o.credithold,so.user4,so.trackingnbr,o.cancelled,o.custid,o.billname,o.slsperid,s.name,o.curytotmerch,o.billaddr1,o.billaddr2,o.billcity,o.status,o.orddate,dia=day(o.orddate),o.custordnbr,so.invcnbr,statusshipper=so.status,so.totmerch,so.shipdateact from soheader o, salesperson s, soshipheader so where o.slsperid=s.slsperid and o.ordnbr='"+txtnumorden.Text+"' and o.ordnbr=so.ordnbr", cn); SqlDataAdapter ad = new SqlDataAdapter(cm); DataSet da = new DataSet(); ad.Fill(da, "soheader"); cn.Open(); mskrut.DataBindings.Add("Text", da, "soheader.custid"); txttotmerch.DataBindings.Add("Text", da, "soheader.totmerch"); txtdireccion.DataBindings.Add("text", da, "soheader.billaddr1");
pero en ASP.NEt como lo puedo hacer.... el databindings no funca..
saludos