Updating is not supported by data source ''SqlDataSource1'' unless UpdateCommand is specified

Posted: Jan/22/2011 By: nikhil Points:15 Category: .NET - ASP.Net Views:298 Vote Up (0) Vote Down (0)

hi all,

how its possible when i try to update Master table Status...it must reflect to the child table(status).

View Complete Post

Comments:

Be the first to comment this post.

Post Comment

Please login to post your comment

More Related Resources

Grouping Data in the ListView Control

In ASP.NET 1.X and ASP.NET 2.0 DataList was the primary control used to display data in groups. In ASP.NET 3.5 we have a new control that takes care of grouping data. In this article we are going to demonstrate how to group data using the ListView control.

Selecting and Highlighting Multiple Columns in a Data Grid

Many times you want to select multiple columns in a DataGrid and highlight the columns selected.

In the DataGrid MouseDown Event you will find out if you have selected a column header through the hit test. You then find the co-ordinate of the column and construct a rectangle out of that. If you are selecting multiple columns you can store the index of the columns and the rectangle in ArrayList.

Make sure you clear the ArrayList when you HitType is None.

How to keep rigth data in cache

Hi,

I would want to know what is better: to keep a lot of data in cache at once or to keep a little data by paging?

For example:

I have 1000 articles and 200 pages.

send alert message to user if close internet browser before save web form data

Hi, I have window form to let user fill data, I want to alert user if close web browser before saved web form data, could anyone provide any clue?

Thanks,

Martin

How to display dynamic XML data inside a Panel control?

Hi all,

I have a SQL routine which builds me an entire XML file and returns it as a string.
If I save the content of this file as sample.xml for instance, I am able to open it in IE or any other browser and the user can expand the nodes and see all the content he wishes.

I am trying to build a ASP.Net page which will display the content of a XML file in the same way (or similar) that the browsers do.

So far, I've been reading some posts and noticed I can use XmlDataSource control and its Data property to load the entire XML doc as a string. Now I am stuck how to display the contents. I found TreeView very confusing and not sure if DataGrid would be a alternative as well. I need to user to be able to open and expand the nodes.

Please someone point me to the right direction. What controls to use, etc... sample codes are the best ;-)

Thank you

grid view without any data source date sorting problem

i grid view contain the following coloum

id name DateofBirth DateofJoining

1 a 22-Aug-1980 10-jan-2000

1 a 22-may-1980 20-feb-2000

1 a 12-Feb-1980 15-mar-2000

1 a 3-Aug-1980 7-jan-2000

how to sort if we click DateofBirth or Dateofjoining and not sort any where if we click(Id,Name)

display data in row and column both

i have created university timetable.

how to display data.??

days show in row wise and period showin column wise

aur every period have particular course..

gridview..detalview or any thing..??

plz reply urgent....

give complete steps

Gridview checkbox not updating

Helllo there

Really important and very urgent

I am new to programming

i am trying to update my checkbox column in a gridview which i cont

I can able to get the data 1 or 0 in database and able to update the checkbox as checked or unchecked

my code is

<asp:TemplateField HeaderText="Available" SortExpression="Available">
                <EditItemTemplate>
                    <asp:CheckBox Checked='<%# ConvertToBool(Eval("Available")) %>' Runat="Server" />
                     </EditItemTemplate>
                <ItemTemplate>
                    <asp:CheckBox Checked='<%# ConvertToBool(Eval("Available")) %>' Runat="Server" />
                    </ItemTemplate>
            </asp:TemplateField>

please help in this bug i am scratching my head for last 3 days

thanks in advance

Trying to prevent multiple submits with a dataview item updating

I have a button in my dataview that drives the update:

<asp:Button ID="btnUpdate" runat="server" Text="Submit Bid" CommandName="Update"

ValidationGroup="response" CssClass="buttonDarkBlue" />

<asp:Button ID="btnUpdate" runat="server" Text="Submit Bid" CommandName="Update"

ValidationGroup="response" CssClass="buttonDarkBlue" />

If you hit the button quickly multiple times, the code below gets run and multiple database updates occur.

I added the Response.Redirect because I saw that as a technique to prevent this problem. It seems to have worked on another page, but not this one.

Thoughts on a best solution?

protected void dvwResponse_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)

{

// (do a database update)

Response.Redirect("~/MySite/SamePage.aspx");

}

Selected value for filtered data in ListView

My page has ListView with SqlDataSource. I set SqlDataSource as DataSet and EnableCaching = True.

BEFORE I filter SqlDataSource, I don't have problem to get the record value for selected record data in my ListView.

AFTER I filter SqlDataSource, my ListView can display the filter record data properly, but I have problem to get the record value for selected record data in my ListView. The record value for selected record data does not refer to the record value what I am selecting.

Please advise this problem. SqlDataSource must be set as DataSet and EnableCaching = True for solving this problem.

Thanks.