ljwolf67

I would suggest using the RangeValidator so that you could set the range as MaximumValue="9999" MinimumValue="1111" Type="Integer"

If you only want one column from multiple records, look at the fields within gridview to make sure you only have one column bound.

[QUOTE=abu taher;937752]I made a cross tab query. please see the attach file. the sum of category show in textbox in my project. like: Stationary = 2000.00 Machinery = 5000.00 Salary = 2200.00 here I can write sql command like:[CODE]select sum(stationery) from table1 [/CODE] but here I know the category"stationery" so …

Example - Table1 has two fields: [B]Country[/B] [B]State[/B] Germany Hamburg Germany Saxony Germany Holstein United States Alabama United States Alaska United States California Form has two combo boxes: cboCountry cboState Set the row source of the first combo box (cboCountry) to the following: SELECT [Table1].[Country] FROM Table1 GROUP BY [Country] …

just a guess, but i think you are missing the last line. dt.DataBind()

Hello to everyone. My name is Leslie and I am from Missouri. I have been in programming for the past 15 years or so. Started out coding in RPG years ago on an AS/400, which is still the main system. Have written numerous applications in MS Access 2000, 2003, and …