Check Constraint and DataGrid

Question

Hello evyone. I have 2 questions. 1.I need to retrieve the checkconstraints of a field in a table(MS Sql Server).A dropdown list should hold these check constraints.How do I do it with C#? 2.I need to change the Column length of a DataGrid whose columns are DataBound.How do I do it?? Thanx in advance Aravind

tsuman_in · Answer

1. I don't understand what you mean by displaying check constraints of a field. A check constraint is on a table in MS SQL This question would be better answered in the ADO.NET forum. 2. If you mean you want to restrict users to the maximum field length you have to convert your tablecolumn to a templatecolumn ' /> ' MaxLength=15 /> When you want to retrieve the data from the txtData Control during the update command get: (TextBox)e.Item.Cells[ColumnIndex].FindControl(txtData)