Cannot editing data in a data Control

I use VWD 2005 Express edition. I try to use a data control to insert and update data. I did the following steps:

1.In the Toolbox, from the Data group, drag a GridView control onto the page.

2. Right-click the GridView control, click Show Smart Tag, and then on the GridView Tasks menu, in the Choose Data Source box, click SqlDataSource1.

3. On the GridView Tasks menu, click Configure Data Source.

4. Click Next to advance to the Configure the Select Statement page of the wizard.

5. On the Configure the Select Statement page, click Advanced, try to select the Generate INSERT, UPDATE, and DELETE statements check box, but this box is unable/disable.

I try to connect with both SQL Server 2005 full edition and Express edition, neither works.

Is it because it's Express edition?

Can any help please.



11/6/2008 1:22:13 AM 72751 articles. 3 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 44
Get it on Google Play
Get it on Apple App Store

Hi ybc,

Have you selected any column in Configure the Select Statement page? I haven't used VWD 2005 Express edition, but I think it will have this. If not, you can generate them manually.


Qin Dian Tang
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
11/10/2008 9:29:01 AM

Similar Artilces:

Data presentation control in another Data presentation control
 Hello,I want to make a menu with datalist or gridview control.Basically,the menu will be like this,Categories     Sub Categories.For example, for COMPUTING category there will be NOTEBOOKS DESKTOPS etc.There will be a image for CATEGORIES and linkbuttons with Subcategories.If I put a datalist inside a datalist and a link button inside the second datalist visually it satisfies my need.However,CommandArguments come from database to linkbutton.Andwhen one of these command buttons is cliked it must go to proper page.I dont know how to wrie an event_handler ,specifically, for...

Bind Data to an Image Control not in a Data Presentation Control
I've been searching for two days but I don't really know what to search for.I'm making a site for a photographer.  The Default.aspx page displays Albums by showing a title, image and description from the database table Albums. Click an album to view the contents and it passes the QueryString which is AlbumName.  The ViewAlbum.aspx page uses the QueryString to display an UpdatePanel holding a Large Image and a Repeater full of dynamically filled ImageButtons for thumbs.  Both are from the database table Photos and are retrieved using an ObjectDataSource. Click the ...

Using Data Control in another data control
Hey, How to use a SqlDataSource control in a GridView and so on...I mean i wanna show data which comes from UserTables in a gridview whoses data comes from ContentTable so they are two separated tables. Thanks and Regards...I am not a perfect programmer, but i have perfect programmers' habits [ i think so :)] I mean how to use nested gridview controls. Please aren't there any poeple who can help me ?I am not a perfect programmer, but i have perfect programmers' habits [ i think so :)] Try the links below, they might be of some help to you.http://msdn2.microso...

Tracing data controls within data controls
I have a problem with tracing data controls within data controls. Below are the codes and the trace statements. Can anyone help me? Your help is very much appreciated. : : : private void InitializeComponent() { this.DataGrid1.ItemDataBound+=new DataGridItemEventHandler(DataGrid1_ItemDataBound); this.Load += new System.EventHandler(this.Page_Load); } #endregion private void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e) { DropDownList Dropdownlist1 = (DropDownList)e.Item.Controls[2].FindControl("D...

Data presentation without a data control
The Gridview and Formview controls provide good functionality in some circumstances but are clumsey in others. As a newbie to .NET I was wondering if its appropriate to do databinding with textboxes and other data controls outside of one of the new data controls (formview, gridview, etc). Or is it a new standard to always use one of the new data controls. If the answer is yes, would you still use an SQLDatasource, or would you set up the connection in code? And, how would you deal with the syntax? In the Formview we have: <asp:TextBox ID="fnameTextBox" runat="server" ...

ajax control in data presentation controls
can i add ajax controls (MaskedEdit) to presentation controls (dataGrid, dataForm)?? Hi,of course. But keep in mind that those controls are extenders, so you append them to an existing control. Just convert your GridView / DetailsView-fields into templated fields and add the extender you'd like to use to the controls.RegardsMarco Buerckel Don't forget to mark posts that were helpful as answers. Actually, if you looked at the source code for the Masked Edit Extender, you'd see  [TargetControlType(typeof(TextBox))]Meaning, targeting any control type other than textboxes...

data presentation controls (how to call the individual controls)
Hi please help me.,i have this question., example i create a site with one control, like textbox. when i double click on the white page, the page load event, in the intellisense, the textbox is visible, but when a formview with a textbox inside, in the same page load event, intellisense, the textbox is not available. how can i do the simple intellisense calling where the textbox is just outside a data presentation control like formview. i mean by this intellisense calling is in VB code view., thanks JFRBPH12™  The textbox is within the formview then you can find it like this...

Data Presentation Controls and complex data+logic
I'd like to know how people solve problem of binding complex data to data presentation controls. As we all know, real life is not as simple as webcasts etc. assume.Lets say we have something like this.List<Person> liPerson = PersonFactory.GetAllPersons();List<Company> liCompany = CompanyFactory.GetAllCompany();And I want a table something like this:Microsoft      Bill      JohnIBM      Ted      CharlesNokia      Matti Is there a generic solution to...

Visibility control of Panel control and its affect on data controls
Thought I would toss this out here this morning and perhaps someone else had run across the same issue and had found a good way to accomplish what I want. First let me state what I'm attempting to do and the problem that I've run into.  GridView1 has a collection of rows in a SQL table that I want to present to the user. I've provided them the options of sorting and selecting only from the GridView control.  Orgionally, I had created a detail view that was being presented in Edit mode and then customized the layout of the edit item template to suit my needs.&nbs...

how to htmlencode data when using data controls to display data
Hi Lets say you are displaying a colllection of records in a gridview and you want to make sure all of the rows and columns are html encoded before you display them, how can can you get the gridview to do this automatically? I don't want to have to create a template for each bound column. Thanks very much andrea Hi Andrea, I believe there is a "HtmlEncode" property on each column that you can set.  By default I believe it is set to true.  You can pull up the column editor by selecting the "edit columns" task, and then select the columns in the botton left of the dialog to see...

Edit data with GridView Control ? or another control ? help
I use GrivView in ASP.Net 2.0 to show data from DataTable. And i want to edit some fields in some rows. How can I do it? If i touch EDIT button - all columns, which have ReadOnly=false, switch into EDIT mode. But I want, that in first raw I can edit 2,3 column and in second row only 3 column. How can I do it ? ...

Run an event whose control is located in Data Presentation Controls
Hey, How can we fire an event which belongs to such as a button which is located in Data Presentation Controls such as a gridview.For example : Assume that my page contains a gridview control which is contains a button and the button name comes from database by gridview control but i wanna fire button control's own event independently of the GridView. Thanks and Regards.I am not a perfect programmer, but i have perfect programmers' habits [ i think so :)] Hi:   You can use CommandArgument to distinguish different buttons in the same column: <asp:Button ID="Button2&...

Theming the ControlStyle for BoundField controls within data presentation controls.
Hi all, I was wondering if you can set a default width for template fields and/or BoundField controls within a GridView or  DetailsView / FormView controls? I can change the control widths of bound data control fields, including template fields, by setting the ControlStyle. But if I have a bunch of fields in a DetailsView control for example, it's a pain to have to set the ControlStyle property for each field. I would like to do it in one fell swoop. If I add the following to my skin file, then I get server control rendering errors on my pages. The controls can't be rendered becuase I...

Web resources about - Cannot editing data in a data Control -

Editing - Wikipedia, the free encyclopedia
Editing is the process of selecting and preparing written , visual , audible and film media used to convey information. The editing process can ...

Editing - Wikipedia, the free encyclopedia
Editing is the process of selecting and preparing written , visual , audible and film media used to convey information. The editing process can ...

Google Chrome Plugin Photon Brings Instagram-Style Photo Editing To Facebook
A new plugin for Google Chrome brings Instagram -style photo-editing capabilities to Facebook, and Photon is available free-of-charge in the ...

Facebook updates iOS Pages Manager to improve speed, allow photo editing, but removes detailed post insights ...
Facebook released version 2.0 of its Pages Manager app for iOS on Wednesday, making it faster and including features like photo filters and stickers ...

Publishing and Editing Professionals
Publishing and Editing Professionals

Potential Markup and Editing Choices
Good programmers never write what they can steal or borrow. With that in mind, I did some research and found the promising but unfortunately ...

Photography: free magazines and cheap editing. What's not to like?
Zinio, as no doubt you know, is the newsagent of the interweb. Through Zinio we can subscribe to hundreds of magazine titles for download and ...

Gene editing shows promise in treating muscular dystrophy
... large portion of function in the heart and other muscles. These experiments show exciting promise for the use of CRISPR in mammalian gene editing, ...

Meet Microsoft Selfie: A Smart iOS-Exclusive Photo-Editing App
The new Microsoft Corporation (NASDAQ:MSFT) Selfie app allows users to edit any captured photo through filters, and intelligently improves any ...

Gene Editing with CRISPR-Cas9 — Jennifer Doudna
If you Haven't been under a rock for the past year or so, you've oftimes seen news articles referencing CRISPR and/or Cas9. Above, Jennifer Doudna ...

Resources last updated: 1/22/2016 12:40:34 PM