What type of list? For list of int you can do it like this: List<int> myList = new List<int>(100); for (int i = 1; 1 <= 50; i++) { myList.Add(i); } // Create DataTable without column and row DataTable dt = new DataTable("MyTbl"); // Add an integer Column dt.Columns.Add("MyColumn", Type.GetType("System.Int32")); for (int j = 0; j < myList.Count; j++) // fill DataTable { dt.Rows.Add(myList\[j\]); }

hi can you explain with example please regards kesavan

You can simply implement it using AJAX Update Panel or JavaScript. You need to check the Selected value from dropdown list, and based on that you have enable/disable the Textbox. To avoid the un-necessary postback you have to use AJAX Updatepanel or Javscript :) Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

This is a C# forum. Why would you suggest JavaScript? Unless you have assumed that the OP is writing a Web App, in which case you should point him towards the Web Development forum. :) Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

put the code to insert one record in a loop (upto records count)

Here you go: Multiple Ways to do Multiple Inserts[^] Giorgi Dalakishvili #region signature my articles #endregion

Here it is a version (displays from master database the parameters name, type and length for sp_addserver stored procedure): -- SQL 2000/2005 if exists (select * from syscolumns where id = object_id('sp_addserver')) begin select name , type_name(xusertype) , length from syscolumns where id = object_id('sp_addserver') end -- SQL 2005 if exists (select * from sys.all_parameters where object_id = object_id('sp_addserver')) begin select name , type_name(user_type_id) , max_length from sys.all_parameters where object_id = object_id('sp_addserver') end Cristian Nuclear launch detected

What is this for? ASP.Net or something else? FOr ASP.Net the code you have there is correct, if it's giving you the wrong results then you probably don't have impersonation setup correctly. If it's for something else then check out the System.Environment[^] class.

^select$

NK7 wrote: [Lable]Connect [combobox]ServersList below one button Click to connect You can achieve this by creating one UserControl that receives several parameters. Once you have created a UserControl, and build the solution you will have your control in the toolbox. You can drag and drop it anywhere in you form. Another way is to create a new Windows Control Library Project, create all your user controls there and add the controls to the toolbox specifying the DLL file. You can also check this link hope it helps. There are 10 kinds of people: those who understand binary and those who don't

Your XML looks a bit dodgy :p The 'Domain' element is not properly closed. ** xacc.ide-0.2.0.57 - now with C# 2.0 parser and seamless VS2005 solution support! **

setting the datasource to null should clear the grid.

Thanks a lot for your timing help. kesavan

Thanks a lot ben I have done this by following way Select Tab1.Column_name,(select Schema_name(uid) from sys.sysobjects where id=PK_table_id)+'.'+Tab2.PKtable_name as PKTable_name, Tab2.PKColumn_name, Tab1.Table_Schema+'.'+Tab2.FKTable_Name as FKTable_Name, Tab2.FKColumn_Name from (Select Column_Name, Data_Type, Table_Schema from Information_schema.columns where Table_Name='Product' and Table_Schema='Production') Tab1 left outer join (select PKColumn_Name=c1.name,PKTable_Name=Convert(Sysname,Object_Name(f.refereced_Object_id)),PKTable_ID=f.referenced_Object_id,FKTable_Name=o1.name,FKColumn_Name=c2.name from sys.all_objects o1, sys.all_objects o2, sys.all_columns c1, sys.all_column c2, sys.foreign_keys f inner join sys.foreign_key_column k on(k.constraint_object_id=f.object_id) inner join sys.indexes i on (f.referenced_object_id=i.object_id and f.key_index_id=i.index_id) where o1.object_id=f.parent_object_id and o1.object_id=object_id('production.product') and o2.object_id=f.parent_object_id and c1.object_id=f.referenced_object_id and c2.object_id=f.parent_object_id and c1.column_id=k.referenced_column_id and c2.column_id=k.parent_column_id) Tab2 on Tab1.Column_name=Tab2.FKColumn_name kesavan

Thanks a lot pete kesavan