August 4, 2010 at 1:17 pm
Is there a way to bind an XML file [SQL Table] to an auto complete text box. The XML is a drug file with over 3000 records. I am using VB .Net.:-)
August 4, 2010 at 2:44 pm
An "XML File" does not equal a "SQL table" so I'm not sure what you mean. Your application can retrieve a list of values from a SQL Server and then programatically populate a control based on the data returned. The specifics of doing so should be referred to a VB.net source.
August 4, 2010 at 5:02 pm
Under windows 2008 SQL server, in the column for the table there is a data type for XML, I was hoping to load the XML file into a defined XML column and then bind to a dataset, as oppose to reading the XML. I never tried that. I still am not sure of making the text box auto complete, and the problem with the 3000+ records to search. When the user begins to type say a all words starting with a appear.
August 4, 2010 at 7:16 pm
Just to make sure you understand ... if you are getting a value from an XML column in a SQL Server table, your application is going to need to handle the XML. Also, keep in mind that 3K items in XML format will take longer to cross the network than 3K varchar items in a dataset.
Your biggest issue is that you need to understand how to populate your vb control (the listbox is what's used for auto-complete without having to resort to AJAX or jscripting right?) with the values. And that's the issue I'm saying would be much better directed towards a forum with a vb/c# specialty. I've done it before but I'm a hack app developer and you would get a much better answer from people who know what they're doing in that realm.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply