Click here to Skip to main content
15,878,852 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have taken a gridview. I want to make this gridview work like modify table option of sql server. So, its one column has "s.no.", one column for "column name" of table,it contains textbox. One column for choosing the "Datatype" ,it contains Dropdownlist. dropdown list is filled with query--
"select name from sys.types". I have done this work through tamplets. Its not giving any error but this gridview is not displaying in the output.

Please help.
Any suggestion will be appreciated.
Thanks.
Posted
Comments
raj ch 11-Jun-13 6:19am    
-post ur code
shalini mehrotra 11-Jun-13 6:37am    
add gridview from toolbox
edit columns
templatefield
edit templates
item template
drag dropdownlist
choose data source
sql database
connection string
mytable
custom sql statement
select name from sys.types
finish
Thanks7872 11-Jun-13 7:14am    
What you are aimed at? As per as i understand the question,you want to change column datatype like nvarchar(max) etc.?
shalini mehrotra 11-Jun-13 7:18am    
i want the user to write column name and its datatype. so, empty textbox for writing column name and dropdown to choose datatype. just like modify tabl eoption of sql server 2005
Please post the code, so that we can check what is the issue.

And debug your code to find out where exactly the problem.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900