If I right click on a Table and choose the C# Expression ("myTable.Take(100)") I'm able to click on the "Edit Data" row to make manual changes to the table.

However, I noticed that if I query a table with SQL (e.g. "Select * from myTable"), I don't get the "Edit Data" button even when viewing as a grid. Am I missing something?

When you click the edit button it transitions into an editable state. If you could transition back into the read-only state via a button click that would be great in order to avoid accidental edits. Sometime you just want to go in, make a quick edit or two, then resume poking around without editing -- especially if you've drilled down through related tables, in which case rerunning the query and re-drilling down is a pain.

Thanks!

Great work. Edit functionality works very smooth, exactly what I was looking for.

Point taken: the next build will make the feature more discoverable.

Yeah it took me a while to find the Edit button as well. There's a small button above the header of the first column that says "Edit Data". When you click it everything becomes editable and the button is replaced by two other buttons, Add Row and Delete Row(s).

Maybe the right-click context menu on tables could have an "Edit top 100 rows" which would open the grid directly in edit mode? Or perhaps double-clicking a field in read-only mode would either automatically switch to edit mode or maybe ask if you'd like to switch?

Fantastic feature, well done!

I runned a query in DataGrid mode. But I cant find any Edit-button.

Thank you thank you! This was my number one wish! Linqpad is becoming indispensable for me.

Yay!!! :)))
Good job!!!

One of the best and important needed!

I have just released a DateGridView based Custom Visualizer http://rapiddevbookcode.codeplex.com/wikipage?title=LINQPadCustomVisualizer, which supports editing the data.

Joe, please allow user to add/update/delete data in the result pane. thanks!

BTW, SSMS isn't usable on x64 at all.
See http://support.microsoft.com/?id=906892

I agree, in fact I've created a couple of tools to do this
http://rapiddevbookcode.codeplex.com/wikipage?title=LINQPadDataEditor and
http://rapiddevbookcode.codeplex.com/wikipage?title=LINQPadHierarchyEditor
You have to open a query first rather than direct from the Schema Explorer but other than that it works a treat.

Bonus points for allowing editing of a subset of the table. I often want to have "Edit Top X Rows" but with a particular set of rows (especially tables with millions of rows).

TFS has Excel integration that allows opening work items in Excel, making changes, then publishing them back to TFS. A similar kind of approach here would be a nice first step:

* export to Excel, which is already done in 2.0, but in a way that keeps them as objects
* then let the changes get pushed back to LinqPad and/or SubmitChanges from inside Excel