Databind a dropdownlist

by 
string strQuery = "Select Item FROM Calendar Where UserD='Test'";

Note you need to use single quotations around the string, as in your code you didn’t finish the inital string ever, so the rest of the code just became part of strQuery.

In addition if you bring back more than one field in the future, when you bind a dropdown list you need to specify which field from the database is the value and which is the displayed text.

ddlList.DataSource = sqlTa;
ddlList.DataValueField = "ValueFieldFromDatabaseResults";
ddlList.DataTextField = "ShownTextFieldFromDatabaseResults";
ddlList.DataBind();

More Related Contents:

  1. Unable to cast object of type ‘System.DBNull’ to type ‘System.String`
  2. Insert 2 million rows into SQL Server quickly
  3. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
  4. How do I connect to an .mdf (Microsoft SQL Server Database File) in a simple web project?
  5. What does N’ stands for in a SQL script ? (the one used before characters in insert script)
  6. Populate TreeView from DataBase
  7. How to Format a date pass as a parameter to a function and return data is a string with “yyyy/mm/dd” format?
  8. Memory leak in Data Access layer using enterprise library
  9. How to use __doPostBack()
  10. Can’t get Czech characters while generating a PDF
  11. How to check a input IP fall in a specific IP range
  12. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  13. HttpContext.Current.Session is null when routing requests
  14. DataView.Sort – more than just asc/desc (need custom sort)
  15. Get error message if ModelState.IsValid fails?
  16. SqlConnection.Close() inside using statement
  17. SQL Injection attack prevention: where do I start
  18. Log4Net Logging of two different levels to two different appenders for the same logger
  19. Check ssl protocol, cipher & other properties in an asp.net mvc 4 application
  20. ComboBox SelectedItem vs SelectedValue
  21. On postback, how can I check which control cause postback in Page_Init event
  22. Custom header to HttpClient request
  23. Why use HttpClient for Synchronous Connection
  24. sending mail along with embedded image using asp.net
  25. How can I convert a class into Dictionary?
  26. Share Session between two web sites using asp.net and state server
  27. Read text from response
  28. Creating download link to a file on a file server
  29. Looping through GridView rows and Checking Checkbox Control
  30. See if user is part of Active Directory group in C# + Asp.net

Leave a Comment