Reading the table into a DataTable and adding that to a DataSetis what I would recommend, but iterating over the list of values in the text file and using a simple SqlCommand with SqlParameters (so you declare the command one and parameterize it to simply change the values and call ExecuteNonQuery) would also be easy and more efficient. If you want to use the SqlDataAdapter, you must at least have the SelectCommand assigned to with a SqlCommand for your SELECT statement. In order to insert, update, or delete rows, however, you must have the InsertCommand, UpdateCommand, and DeleteCommand assigned on the SqlDataAdapter. You can use the SqlCommandBuilder with the SelectCommand if the command is simple enough (i.e., JOINs and other advanced statements are not supported). Also, the SelectCommand must be parameterized (see the SqlCommand.Parameters property). See the SqlDataAdapter class documentation in the .NET Framework SDK (installed by default with VS.NET, and available online from http://msdn.microsoft.com/netframework[^]) for more information and an example of how to use some of these classes. Microsoft MVP, Visual C# My Articles

Move your first line: r = DataSet.Tables["TradeOrderFills"].NewRow(); inside the foreach loop. What you were doing is inserting the same physical row each time, but just changing the data it contained. You need to create a new physical row on each iteration. --Colin Mackay-- "In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown) Enumerators in .NET: See how to customise foreach loops with C#

Thanks! Much appreciated. I'm gonna give it a try later this afternoon.

I'm not a security expert, but there's one thing I've picked up... In general, you should never store a password. I think it's a bad idea to even store an encrypted one. If you store an encrypted one and your keys are compromised, decrypting it is trivial. Store the hash of a password and "salt" that hash. It's preferable to have your salt have something in it that varies per user. Assuming the user-list and password hash is compromised, salting prevents a hacker from gaining easy entry. Having your salt have something unique per user in it prevents comparing a known account with a known password and finding another account with that same password. Then hash what they input and check it against the stored hash. Do a search for hash's and salt for some more info. I, for one, do not think the problem was that the band was down. I think that the problem may have been that there was a Stonehenge monument on the stage that was in danger of being crushed by a dwarf. -David St. Hubbins

You can either implement data-binding yourself using the CurrencyManager from the CheckListBox control's BindingContext. See that property documentation and follow the references to learn more. You won't get it for free, but it's a good place to start. If you use it often, extend CheckedListBox with your own control and add data-binding capabilities. -----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----

To be honest, i'm a bit surprised that CheckedListbox doesn't expose DataSource and others. I'm sure there's a better answer, but at the least you can use it's base class' methods: ArrayList list = new ArrayList(); list.Add("Hello"); ListBox box = (ListBox)checkedListBox1; box.DataSource = list;

Not unless you override or make your own toolbar. One an image is set for one ToolBarButton, space is allocated for the rest. The ToolBar in the BCL does kind of stink, but there are plenty of alternatives available, including many here on CP and lots of commercial versions, too. -----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----

No, DataGrid.DataSource needs an object which can be a DataSet, Table, View, ...You can read this in the help. Yes, the DataGrid is "equal" to the Table. When you change Data in the Grid, the Table will change at once, too. Two questions: 1. When you make changes to the two lists you have, is the correct Data shown in the Grid? 2. When you Update the Tables, DataSet is the new data written to Sql-Server?

I think those two attributes are converted into information in a version resource, and not retained as attributes. You should be able to access them via FileVersionInfo.GetVersionInfo(). Burt Harris

Thanks for the reply. I tried something similiar to what you have posted, but nothing is returned for the title. Even thought I have an entry in the Assembly title attribute AssemblyInfo.cs file. Any idea why this might happen ?

I just tried something similar & found I had to... ' Create a tool window handle for the Output window. Dim win As Window = DTE.Windows.Item(EnvDTE.Constants.vsWindowKindOutput) ' Create handles to the Output window and its panes. Dim OW As OutputWindow = win.Object Dim OWp As OutputWindowPane Dim textFileOWp As OutputWindowPane Dim found As Boolean Dim enumerator As IEnumerator ' Try to find a pane named "Output" enumerator = OW.OutputWindowPanes.GetEnumerator() found = False Do While enumerator.MoveNext OWp = enumerator.Current If OWp.Name = "Output" Then found = True textFileOWp = OWp End If Loop ' If pane not found Create one If Not found Then textFileOWp = OW.OutputWindowPanes.Add("Output") End If ' Add a new pane to the Output window. ' Add a line of text to the new pane. textFileOWp.Clear() textFileOWp.OutputString("Some Text" & CRLF) I hope this helps (I'm a complete novice when it comes to macro programming and am just guessing my way) DAve

something like this: public struct TradeData { public object OrderTime { get { return orderTime; } set { orderTime = value; } } private Object orderTime; }

Thanks for your reply, but I am still not clear on how to implement what I am seeking. I know I have to create a class that derives from the System.EventArgs base class, but I am not sure how creating this class ties in with everything else. For example, where do I instaniate this class, how does that relate to onclick and the type the method takes. Any help is appreciated.

have a constructor, pass by value a string or object , use MDI methods.

Thanks for that Shaun. Its a little clearer now.:)

zuhx wrote: Can you give a little more detail on why it is not recommended? I don't recommend adding a form to a panel UNLESS you change the border style. Otherwise you wind up with a form that can be moved around (not so bad if that is the intended purpose) but it can also be closed which can be a problem. James "I despise the city and much prefer being where a traffic jam means a line-up at McDonald's" Me when telling a friend why I wouldn't want to live with him