As I do to fill out two droplist of different tables in the event open of
the webforms.

I get to fill out one, but when I try two says that cannot open another
connection.

Can you provide some more details....
Is there any exception? The stacktrace and, preferably also, the code.

--
Happy Hacking,
Gaurav Vaish
http://www.mastergaurav.org
http://www.edujini.in
-------------------


"Frank Dulk" <fdulk (AT) bol (DOT) com.br> wrote

That is the code that I am sweating for filling out the dropdownlist1 with
the records of the table1.
How do I do to fill out other dropdownlist2 with the records of another
table2?

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

'Put user code to initialize the page here

If Not IsPostBack Then

Dim strSql As String

Dim conexao As OleDbConnection

Dim dscmd As OleDbDataAdapter

Dim ds As DataSet

conexao = New OleDbConnection("provider=microsoft.jet.oledb.4.0; data
source=C:\Inetpub\wwwroot\Database_acesso1\talao.m db;")

conexao.Open()

Try

strSql = "select distinct tplt_desc from TblTipoLente order by tplt_desc"

dscmd = New OleDbDataAdapter(strSql, conexao)

ds = New DataSet

dscmd.Fill(ds, "TblTipoLente")

Me.DropCategorias.DataTextField = "tplt_desc"

Me.DropCategorias.DataValueField = "tplt_desc"

Me.DropCategorias.DataSource = ds.Tables("TblTipoLente").DefaultView

Me.DropCategorias.DataBind()

Me.DropCategorias.Items.Insert(0, New ListItem("Selecione seu tipo de
lente...", ""))

Finally

conexao.Close()

End Try

End If

End Sub

End Class




"Gaurav Vaish (EduJini.IN)" <gaurav.vaish.nospam (AT) nospam (DOT) gmail.com> escreveu
na mensagem news:ef950r7fGHA.1520 (AT) TK2MSFTNGP03 (DOT) phx.gbl...

Exactly the same way as you did for ddl1.
You need to have a new instance of OldDbConnection. The same connection will
not work.



--
Happy Hacking,
Gaurav Vaish
http://www.mastergaurav.org
http://www.edujini.in
-------------------

I've been using a tool called the DataSet Toolkit to handle Fills and
Updates of multiple DataTables like you're doing. It will manage your
connection for you so you don't need to worry about creating a new one,
and it will even write the SQL to fill your table at runtime, so you
won't need to do that either. You can find it here:

http://www.hydrussoftware.com

John B.
http://johnsbraindump.blogspot.com

ok Gaurav Vaish, will test in your way.
Thank you very much John B. will also see that program.

Does he/she/you have how in the dropdownlist to show the name and does keep
the id in the table, as if it was two columns?


<jmbledsoe (AT) gmail (DOT) com> escreveu na mensagem
news:1148651580.333959.321070 (AT) i40g2000cwc (DOT) googlegroups.com...

Hi Frank,

Probably couldn't understand your question.
Here's my understanding:

Table1: id, name
DropDownList:
DisplayText => name
Value => id

eg:

<option value='1'>Gaurav Vaish</option>
where 1 is the value of the field id and "Gaurav Vaish" is the value of
the field name.

That should be trivial.
ddl.DataTextField = "name";
ddl.DataValueField = "id";


--
Happy Hacking,
Gaurav Vaish
http://www.mastergaurav.org
http://www.edujini.in
-------------------

Exactly that.
Thank you very much.

would have as in a text box to type +1 or -1 or +74 or...
but would have to impose a limit up to +170 or -170

But has to have that mask.+ or -


"Gaurav Vaish (EduJini.IN)" <gaurav.vaish.nospam (AT) nospam (DOT) gmail.com> escreveu
na mensagem news:%23vHrzNZgGHA.4932 (AT) TK2MSFTNGP03 (DOT) phx.gbl...

Use javascript to validate the value.
onchange (client side) event.

That should be trivial.
You would need even smarter / faster event -- onkeypress, again the client
side.


--
Happy Hacking,
Gaurav Vaish
http://www.mastergaurav.org
http://www.edujini.in
http://webservices.edujini.in
-------------------

Would be able to for an example?


"Gaurav Vaish (EduJini.IN)" <gaurav.vaish.nospam (AT) nospam (DOT) gmail.com> escreveu
na mensagem news:u1kAp2fgGHA.1264 (AT) TK2MSFTNGP05 (DOT) phx.gbl...