You can use this against SQL Server or Access (I think)...
SELECT R_ID, some_other_columns
FROM some_table
WHERE R_ID In (SELECT R_ID FROM some_table As T GROUP BY R_ID HAVING Count(*)>1 )
'If you want only ones that have no duplicates then change the > 1 to = 1
Is the IIS installed on your Win2k or WinXP Pro?
If yes, open the command prompt, and run this C:\WINNT\Microsoft.NET\Framework\v1.0.3705\aspnet_regiis.exe /i
The directory should be the same location as your version of the Framwork.
The directory containing your aspx files should be created as "Virtual".
Also, if this is a shared hosting environment, you (they) need to grant ASPNET as a user of that new directory.
Sorry I just noticed you'r using C#
{
for (int i = 1; i <= 10; i++)
{
Label lbl;
lbl = new Label();
lbl.BorderColor = Color.Red;
lbl.BorderStyle = BorderStyle.Solid;
lbl.BorderWidth = Unit.Pixel(1);
lbl.Text = "Test";
lbl.CssClass = "SomeCssClass"; //If you wish, use this instead of the properties
this.Controls.Add(lbl); //or place the controls into a Panel or PlaceHolder
}
Dim x As Integer
For x = 0 To 10
Dim lbl As New Label()
With lbl
.BorderColor = Color.Red
.BorderStyle = BorderStyle.Solid
.BorderWidth = Unit.Pixel(1)
.Text = "Test"
.CssClass = "SomeCssClass" 'If you wish, use this instead of the properties
End With
Me.Controls.Add(lbl) 'or place the controls into a Panel or PlaceHolder
Next
1) I can think of many reason for this, a calculation or a condition is met so you update the grid through code,,,,
2) You can use the DataAdapter's Update command for this. (commandBuilder)
3) I only know for web controls, sorry.
If you're creating the grid at design-time then make sure that Enable Soritng is marked as True, at runtime you can just set the property via your code .EnableSorting = True